Fixed-length Fields in Invoice Records

The following table describes the fixed-length fields found in invoice records. Both the short label and default long label (if one exists) are shown.

Invoice Record Fields

Field Number

Field Label

Description

Code is

Data in Field Entered by

Limits

Examples

128

INV DATE
or Invoice Date

The date from the vendor's invoice entered by the user.

month-day-year (mm-dd-yy or mm-dd-yyyy) or day-month-year (dd-mm-yy or dd-mm-yyyy

organization

Single entry in valid date format

04-12-99 or 12-04-2001

130

INV STATUS
or Invoice status

Status of the invoice. The status is changed by the system as the user processes an invoice. The invoice status is used internally and is not visible on the invoice.

lowercase alphabetic or numeric

system

Maximum code length: 1 character

CODE	DEFINITION
s	suspended
f	ready to post
1	post step 1
2	post step 2
3	post step 3
4	post step 4
5	post step 5
6	post step 6
c	complete

133

NCODE1
or Inv code1

Not currently used.

N/A

134

NCODE2
or Inv code2

Not currently used.

N/A

135

NCODE3
or Inv code3

Not currently used.

N/A

129

PAID DATE

The date the invoice was finished.

month-day-year (mm-dd-yy or mm-dd-yyyy) or day-month-year (dd-mm-yy or dd-mm-yyyy

system

Single entry in valid date format

04-12-99 or 12-04-2001

132

POST_DATE
or Post date

The date the invoice was posted. System-generated and for internal use only.

month-day-year (mm-dd-yy or mm-dd-yyyy) or day-month-year (dd-mm-yy or dd-mm-yyyy

system

Single entry in valid date format

04-12-99 or 12-04-2001

131

SET_RDATE
or Set rdate

Stores the Use Paid Date as Receive Date setting. The user can change this setting from the Invoice tab in Settings.

Although the user can change this setting, the field is system-generated and for internal use only.

numeric

system

Maximum code length: 1 character

CODE	DEFINITION
0	The system uses this code when the Use Paid Date as Receive Date box is not selected. The system does not update the RDATE field in the order record.
1	When the Use Paid Date as Receive Date box is selected, the system updates the RDATE for each order record on the invoice when the session is posted.