DOCUMENTS Data Table Columns

Header Columns

Data entries in the document head occur once per transaction. Some entries may contain multiple values. Columns are defined in the table following.

REQ SM COLUMN NAME TYPE UC VALIDATE DEFAULT JUST
– – – – – – – – – – – – Keys
M S TYPE LC U Document Type Codes   L4
M S IDENTIFIER SK U     L12
M S REVISION S U     L4
– – – – – – – – – – – – Posting & Reference
M S STATUS LC U Document Status Codes   L2
M S DATETIME D U   TODAY R10
M S ACCOUNT A U VT=ACCOUNTS   L12
O S BUILDING A U VT=CONTACTS*B   L4
P AM REFERENCECODE LC U Document Reference Codes   L4
P AM REFERENCE A       L20
– – – – – – – – – – – – Transportation
P AM ADDRESSCODE LC U Contacts Type Codes ST,SF L4
P AM ADDRESS A U VT=CONTACTS*ST,SF,PF   L12
O S CONTACT A       L20
O S CARRIERCODE A U VT=CONTACTS*CA   L8
O S ROUTE A       T30
O S FREIGHTPAY LC U Freight Payor Codes PP L4
O S TRANSPORTMETHOD LC U Transportation Methods M L4
O S LOADINGOPTION LC U Loading Option Codes 01 L4
P AM VEHICLECODE LC U Vehicle Equipment Codes   L4
P AM VEHICLE A U     T20
– – – – – – – – – – – – Qualitative Values
P AM DATECODE LC U Date/Time Qualifier Codes   L4
P AM DATETIME DT U     R20
P AM TEMPERATURECODE LC U Temperature Codes   L4
P AM TEMPERATURE N       R6
P AM QUANTITYCODE LC U Quantity Codes   L4
P AM QUANTITY N.4       R12
– – – – – – – – – – – – Notes and Messages
P AM NOTECODE LC U Note & Message Codes   L4
P AM NOTE A       T40
P AM NOTEAPPLY LC U Document Type Codes   L4

LEGEND:

REQ
O = optional
M = mandatory
P = pair required
C = conditional
SM
S = single valued
M = multiple values
A = associated (array member)
COLUMN NAME (not case specific)
TYPE
A = alpha
N.n = numeric with decimals
B = boolean
D = datetime
U = UUID
LC = list of codes
SK = key sequence
S = sequence
U Key values and codes are uppercase
VALIDATE
links refer to code validation lists
Tablenames (uppercase) refer to verifiles
(‘values’) list allowed entries
DEFAULT a value default
JUST
Justify (L)eft, (C)enter, (R)ight, (T)ext
n = characters to show

Note

  1. Entries of type list code (TYPE=LC) are validated against the associated linked code option list.
  2. Entries with a paired requirement (REQ=P) are required when the associated paired entry or code is specified.