RECURRING Lines Data ColumnsΒΆ
| REQ | SM | COLUMN NAME | TYPE | UC | VALIDATE | DEFAULT | JUST | NOTE |
|---|---|---|---|---|---|---|---|---|
| – – – – – – – – – – – – Keys | ||||||||
| M | S | LINEKEY | SK | U | sequenced | R12 | ||
| M | S | BATCH | N | U | R12 | |||
| M | S | ACCOUNT | A | U | VT=ACCOUNTS | L12 | ||
| M | S | PRODUCT | A | U | VT=PRODUCTS | L12 | ||
| M | S | VARIETY | A | U | VT=PRODUCTS | L12 | ||
| M | S | CONTROL | A | U | VT=LOTS | L12 | ||
| M | S | POSTED | DT | U | DATETIME | R16 | ||
| – – – – – – – – – – – – Calculation Control Entries | ||||||||
| M | S | RECEIVED | DT | U | DATETIME | R16 | ||
| M | S | RUNDATE | DT | U | DATETIME | NOW | R16 | |
| M | S | LAST | DT | U | DATETIME | R16 | ||
| M | S | NEXT | DT | U | DATETIME | R16 | ||
| – – – – – – – – – – – – Audit Entries | ||||||||
| M | S | STARTING | DT | U | DATETIME | LAST+1 | R16 | |
| O | S | QTY_ONHAND | N.4 | (MD4L) | R12 | |||
| O | S | QTY_RECEIVED | N.4 | (MD4L) | R12 | |||
| O | S | QTY_SHIPPED | N.4 | (MD4L) | R12 | |||
| O | S | QTY_ADJUSTED | N.4 | (MD4L) | R12 | |||
| M | S | QTY_BALANCE | N.4 | (MD4L) | R12 | |||
| M | S | ENDING | DT | U | DATETIME | R16 | ||
| – – – – – – – – – – – – Rate Entries | ||||||||
| O | T | GROUP | A | U | VT=RATES | L12 | ||
| O | T | SERVICE | LC | U | (services list) | L4 | ||
| M | S | PERCODE | LC | U | Rating and Value Per Unit | L4 | ||
| M | S | BILLUOM | LC | U | Units of Measure | L4 | ||
| M | S | FACTOR | N.4 | U | R12 | |||
| M | S | QUANTITY | N.4 | U | R12 | |||
| M | S | DEFICIT | N.4 | U | R12 | |||
| M | S | RATE | N.4 | U | R12 | |||
| M | S | CHARGE | N.4 | U | R12 | |||
| – – – – – – – – – – – – Quantitative Entries | ||||||||
| M | S | OH_UNITS | N.4 | (MD4L) | R12 | |||
| O | S | OH_PACKAGES | N.4 | (MD4L) | R12 | |||
| M | S | OH_INNERS | N.4 | (MD4L) | R12 | |||
| O | S | OH_NETWEIGHT | N.4 | (MD4L) | R12 | |||
| M | S | OH_GROSSWEIGHT | N.4 | (MD4L) | R12 | |||
| O | S | OH_DIMVOLUME | N.4 | (MD4L) | R12 | |||
| M | S | RC_UNITS | N.4 | (MD4L) | R12 | |||
| O | S | RC_PACKAGES | N.4 | (MD4L) | R12 | |||
| M | S | RC_INNERS | N.4 | (MD4L) | R12 | |||
| O | S | RC_NETWEIGHT | N.4 | (MD4L) | R12 | |||
| M | S | RC_GROSSWEIGHT | N.4 | (MD4L) | R12 | |||
| O | S | RC_DIMVOLUME | N.4 | (MD4L) | R12 | |||
| M | S | SH_UNITS | N.4 | (MD4L) | R12 | |||
| O | S | SH_PACKAGES | N.4 | (MD4L) | R12 | |||
| M | S | SH_INNERS | N.4 | (MD4L) | R12 | |||
| O | S | SH_NETWEIGHT | N.4 | (MD4L) | R12 | |||
| M | S | SH_GROSSWEIGHT | N.4 | (MD4L) | R12 | |||
| O | S | SH_DIMVOLUME | N.4 | (MD4L) | R12 | |||
| M | S | AJ_UNITS | N.4 | (MD4L) | R12 | |||
| O | S | AJ_PACKAGES | N.4 | (MD4L) | R12 | |||
| M | S | AJ_INNERS | N.4 | (MD4L) | R12 | |||
| O | S | AJ_NETWEIGHT | N.4 | (MD4L) | R12 | |||
| M | S | AJ_GROSSWEIGHT | N.4 | (MD4L) | R12 | |||
| O | S | AJ_DIMVOLUME | N.4 | (MD4L) | R12 | |||
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
- Entries of type list code (TYPE=LC) are validated against the associated linked code option list.
- Entries with a paired requirement (REQ=P) are required when the associated paired entry or code is specified.