Lawson Insight Technical Documentation |
|
COLINE
COLINE FILE
Customer Order Line
Customer order line information is stored in this file. There are three
possible types of lines that can be stored here: inventory, nonstock, and
special items. During processing, totals are kept here, for example, the
total quantity ordered, allocated, printed, picked, packed and shipped. The
quantity shipped on a specific shipment is kept in the Order Entry Shipment
Line file.
REFERENCED BY
BL125 BL80.1 IC11.1 OE112 OE210 OE229
OE270 OE271 OE280 OE281 OE282 OE283
OE286 OE288 OE289 OE290 OE293 OE80.1
OE80.2 OE80.3 OE80.4 OE80.5 OE88.1 WH126
WH222 WH224 OE287 WH210
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 BLI2.1 IC28.1 MA180 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA66.2
MA66.3 MA67.1 MA67.2 MA70.1 MA75.1 MA80.1
MAI1.1 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5
OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.5
OE11.8 OE11.9 OE110 OE111 OE113 OE114
OE116 OE129 OE13.2 OE13.3 OE13.5 OE13.6
OE14.4 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5
OE30.6 OE30.7 OE30.9 OE310 OE510 OE530
OE81.1 OE810 OE830 OE90.1 OE90.2 PO100
PO101 PO122 PO131 PO20.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO23.1 PO29.1 PO30.1
PO30.2 PO30.3 PO300 PO31.1 PO31.2 PO32.2
PO33.1 PO34.1 PO35.1 PO38.1 PO39.1 PO39.2
PO44.1 PO50.1 PO52.1 PO520 POI3.1 POIE.1
POII.1 POIJ.1 RQ10.1 RQ10.2 SA100 SA101
WH110 WH120 WH130 WH132 WH190 WH20.2
WH20.7 WH21.1 WH21.2 WH21.3 WH21.4 WH22.1
WH30.1 WH30.2 WH30.3 WH30.4 WH31.1 WH31.2
WH31.3 WH31.4 WH32.1 WH32.2 WH32.3 WH32.4
WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830 WO20.1 WO30.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
COL-COMPANY Numeric 4 BL120 BL122
Element: Company Identifies the AP company if the BL130 BL20.1
resource type = V. Identifies the HR BL20.3 BL21.2
company if the resource type = E. It is BL21.5 BL29.1
blank for type A, P or Q resources. BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE286
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE530
OE810 OE830
WH20.7
COL-ORDER-NBR Numeric 8 BL120 BL122
Element: Order Number Each order is assigned a unique number. BL130 BL20.1
Order numbers are either manually BL20.3 BL21.2
assigned or system assigned based on a BL21.5 BL29.1
company-level option. BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE286
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE530
OE810 OE830
WH20.7
COL-LINE-NBR Numeric 6 BL120 BL122
Element: Line Number This field displays the line number of BL130 BL20.1
the transaction number. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-STATUS Numeric 1 BL120 BL122
Element: Status This field indicates the status of this BL130 BL20.1
line on the order. BL20.3 BL21.2
0 = Needs clean-up BL21.5 BL29.1
1 = Unreleased BL29.2 BL520
2 = Released BL820 BL92.1
8 = Canceled OE10.1 OE10.2
9 = Ready for delete OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
WH22.1
COL-FUTURE-FL Alpha 1 BL120 BL122
Element: Future Order FThis field indicates if this line has a BL130 BL20.1
future status. BL20.3 BL21.2
Y = Yes BL21.5 BL29.1
N = No BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 OE90.1
WH20.7
COL-SALES-MAJCL Alpha 4 BL120 BL122
Element: Major Class This field contains the major sales BL130 BL20.1
class code. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-SALES-MINCL Alpha 4 BL120 BL122
Element: Minor Class This field contains the minor sales BL130 BL20.1
class code within the major class. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-ITEM Alpha 32 BL120 BL122
Element: Item Number This field contains the item BL130 BL20.1
identifier. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-ITEM-DESC Alpha 30 BL120 BL122
Element: Item DescriptiThis field contains the description for BL130 BL20.1
stock and nonstock items. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
WH222
COL-LINE-TYPE Alpha 1 BL120 BL122
Element: Line Type The line type can be entered. Valid BL130 BL20.1
values are: BL20.3 BL21.2
. BL21.5 BL29.1
I = Inventoried. Default value. BL29.2 BL520
N = Nonstock. BL820 BL92.1
X = Special order. OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-ORIG-LINE Numeric 4 BL120 BL122
Element: Original Line This field contains the original line BL130 BL20.1
number if it was overridden. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-ORIG-ITEM Alpha 32 BL120 BL122
Element: Item Number This field contains the original item BL130 BL20.1
number if it was overridden. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-ORIG-FL Alpha 1 BL120 BL122
Element: Orig Fl This field indicates whether this line BL130 BL20.1
was created as a result of item BL20.3 BL21.2
replacement or substitution. BL21.5 BL29.1
R = Replacement line BL29.2 BL520
S = Substitute line BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-CUSTOMER Alpha 9 (Right Justified) BL120 BL122
Element: Customer NumbeThis field contains the number that BL130 BL20.1
represents a customer. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-CUST-ITEM-FL Alpha 1 BL120 BL122
Customer Item This field indicates whether the number BL130 BL20.1
Numbers Used Fl entered in the order line represents an BL20.3 BL21.2
item set up in the Order Entry Customer BL21.5 BL29.1
file. BL29.2 BL520
C = Customer item was entered BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-CUST-ITEM Alpha 32 BL120 BL122
Element: Item Number This field contains the customer's item BL130 BL20.1
number. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-KIT-FL Alpha 1 BL120 BL122
Element: Kit Flag This field indicates when the item BL130 BL20.1
ordered is a made-to-order kit. BL20.3 BL21.2
N = Not a kit BL21.5 BL29.1
O = Make to order kit BL29.2 BL520
S = Make to stock kit BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-KIT-ALLOC-FL Alpha 1 BL120 BL122
Element: Kit AllocationThis field indicates whether the kit BL130 BL20.1
has been allocated. BL20.3 BL21.2
0 = Kit allocated BL21.5 BL29.1
1 = Kit needs options chosen BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-HOLD-CODE Alpha 4 BL120 BL122
Element: Hold Code If the line is on hold, this field BL130 BL20.1
contains the hold code. Hold codes are BL20.3 BL21.2
set up in the Accounts Receivable BL21.5 BL29.1
system. BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 OE90.2
WH20.7
COL-INV-LOC Alpha 5 BL120 BL122
Element: Location Code This field contains the location from BL130 BL20.1
which inventory is taken. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-PROCESS-LEVEL Alpha 5 BL120 BL122
Element: Process Level This field contains the process level, BL130 BL20.1
which is the reporting hierarchy below BL20.3 BL21.2
company. If you are using the General BL21.5 BL29.1
Ledger Interface system, the process BL29.2 BL520
level determines which general ledger BL820 BL92.1
account the order's invoice debits when OE10.1 OE10.2
its rate updates to the Accounts OE10.3 OE10.4
Receivable system. OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-SPR-UOM Alpha 4 BL120 BL122
Element: Unit of MeasurThis field contains the pricing unit of BL130 BL20.1
measure. This must be a valid pricing BL20.3 BL21.2
unit of measure for the item if the line BL21.5 BL29.1
is not a special order line. BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-SELL-UOM Alpha 4 BL120 BL122
Element: Unit of MeasurThis field contains the stock unit of BL130 BL20.1
measure for the item. If entered, it BL20.3 BL21.2
must be a valid stock unit of measure BL21.5 BL29.1
for this line's item. If not entered, BL29.2 BL520
the default stock unit of measure for BL820 BL92.1
this line's item is assigned. OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH126
WH20.7
COL-SEC-UOM Alpha 4 BL120 BL122
Element: Unit of MeasurThis field contains the secondary BL130 BL20.1
quantity unit of measure. This is used BL20.3 BL21.2
only when the item is a catch weight BL21.5 BL29.1
item. BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-NO-CHARGE-FL Alpha 1 BL120 BL122
Element: No Charge FlagThis field indicates the item's price BL130 BL20.1
is zero. This defaults to No. If set to BL20.3 BL21.2
Yes, this field prevents the system from BL21.5 BL29.1
pricing the item. No charge invoices are BL29.2 BL520
not to be passed to the Accounts BL820 BL92.1
Receivable system for collection. OE10.1 OE10.2
N = No OE10.3 OE10.4
Y = Yes OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-RATE-OVR-FL Alpha 1 BL120 BL122
Element: Rate Ovr Fl This flag indicates whether the BL130 BL20.1
currency conversion rate was overridden BL20.3 BL21.2
for this line of the order. BL21.5 BL29.1
Y = Yes BL29.2 BL520
N = No BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-PRICE-STATUS Alpha 1 BL120 BL122
Element: Price Status This field indicates how the line was BL130 BL20.1
priced. BL20.3 BL21.2
A = Amalgamated (group) pricing BL21.5 BL29.1
C = System calculated pricing BL29.2 BL520
O = Price override BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-PRICE-DATE Numeric 8 (yyyymmdd) BL120 BL122
Element: Date This field contains the date used to BL130 BL20.1
price the line. The system date defaults BL20.3 BL21.2
when the line is added. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-ENTERED-PRICE Signed 18.5 BL120 BL122
Element: Intl Cost This field contains the unit price in BL130 BL20.1
the currency of the order. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-UNIT-PRICE Signed 18.5 BL120 BL122
Element: Intl Cost This field contains the unit price in BL130 BL20.1
base currency. This is an amount per BL20.3 BL21.2
stock unit of measure. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-SELL-UNIT-PRC Signed 18.5 BL120 BL122
Element: Sell Unit Prc This field contains the price per sell BL130 BL20.1
unit of measure in base currency. If BL20.3 BL21.2
multiple unit of measure pricing is BL21.5 BL29.1
used, this is the weighted average price BL29.2 BL520
per sell unit of measure. BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE286
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE530
OE810 OE830
WH20.7
COL-SELL-PRC-CURR Signed 18.5 BL120 BL122
Element: Sell Unit Prc This field contains the price per sell BL130 BL20.1
unit of measure in transaction currency. BL20.3 BL21.2
If multiple unit of measure pricing is BL21.5 BL29.1
used, this is the weighted average price BL29.2 BL520
per sell unit of measure. BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE286
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE530
OE810 OE830
WH20.7
COL-UNIT-COST Signed 18.5 BL120 BL122
Element: Intl Cost This field contains the unit cost. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-DISC-AMT-CURR Signed 18.2 BL120 BL122
Element: Intl Amt This field contains the discount amount BL130 BL20.1
in transaction currency. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE286
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE530
OE810 OE830
WH20.7
COL-MULT-DISC-AMT Derived
Element: Mult Disc Amt This field contains the discount amount
in base currency if a multiplier is used
when converting from original to base
currency.
COL-DIV-DISC-AMT Derived
Element: Div Disc Amt This field contains the discount amount
in base currency if a divider is used
when converting from original to base
currency.
COL-DISC-AMT-BASE Derived
Element: Disc Amt Base This field contains the discount amount
in base currency.
COL-DISC-CODE Alpha 10 BL120 BL122
Element: Discount Code This field contains the discount code BL130 BL20.1
used to calculate the discount amount BL20.3 BL21.2
for this line. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-MULT-SPR-FL Alpha 1 BL120 BL122
Element: All Flag This field indicates whether the item BL130 BL20.1
has multiple pricing. BL20.3 BL21.2
Y = Yes BL21.5 BL29.1
N = No BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-SPR-TO-STOCK Signed 13.7 BL120 BL122
Element: Sell To Stock This field contains the multiplier used BL130 BL20.1
with special order items when converting BL20.3 BL21.2
from pricing unit of measure to stock BL21.5 BL29.1
unit of measure. BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-SELL-TO-STOCK Signed 13.7 BL120 BL122
Element: Sell To Stock This field contains the multiplier that BL130 BL20.1
is used with special order items when BL20.3 BL21.2
converting from selling unit of measure BL21.5 BL29.1
to stock unit of measure. BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE286
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE530
OE810 OE830
WH20.7
COL-SEC-TO-STOCK Signed 13.7 BL120 BL122
Element: Sell To Stock This field contains the multiplier that BL130 BL20.1
is used with catch weight items when BL20.3 BL21.2
converting secondary unit of measure to BL21.5 BL29.1
stock unit of measure. BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-ORD-DISC-FL Alpha 1 BL120 BL122
Element: Order DiscountThis field indicates whether this line BL130 BL20.1
is eligible for an order discount. BL20.3 BL21.2
Y = Yes BL21.5 BL29.1
N = No BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-CUST-SHIP-TO Numeric 4 BL120 BL122
Element: Ship-to Code This field contains the ship-to BL130 BL20.1
customer number. This defaults from the BL20.3 BL21.2
order header. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-CREATE-PO Alpha 1 BL120 BL122
Element: All Flag This field indicates the item is BL130 BL20.1
ordered by a purchase order rather than BL20.3 BL21.2
using stock. BL21.5 BL29.1
N = No BL29.2 BL520
Y = Yes BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-DROPSHIP-FL Alpha 1 BL120 BL122
Element: Dropship Flag This field indicates whether the items BL130 BL20.1
of the purchase order are sent directly BL20.3 BL21.2
from the vendor to the customer. If this BL21.5 BL29.1
field is set to No, items are shipped to BL29.2 BL520
the user who entered the order for BL820 BL92.1
shipment to the customer. OE10.1 OE10.2
N = No OE10.3 OE10.4
Y = Yes OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-CARRIER Alpha 9 (Right Justified) BL120 BL122
Element: Vendor ID This field contains the carrier number. BL130 BL20.1
This must be a valid vendor defined in BL20.3 BL21.2
the Accounts Payable system. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-PO-NUMBER Alpha 14 (Right Justified) BL120 BL122
Element: PO Number This field contains the number BL130 BL20.1
representing the purchase order. This is BL20.3 BL21.2
used if the purchase order line is added BL21.5 BL29.1
to an existing purchase order. BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-PO-CODE Alpha 4 BL120 BL122
Element: Po Code This is the purchase order code that BL130 BL20.1
will be used as part of the purchase BL20.3 BL21.2
order number for a create po order line. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-VENDOR Alpha 9 (Right Justified) BL120 BL122
Element: Vendor ID This field contains the vendor of the BL130 BL20.1
purchase order. If left blank, the BL20.3 BL21.2
Purchase Order system assigns a vendor BL21.5 BL29.1
to the purchase order. BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-PURCH-FR-LOC Alpha 4 BL120 BL122
Purchase From The vendor's purchase from location. BL130 BL20.1
Location Code BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-IF-REF-NBR Numeric 9 BL120 BL122
Element: Reference NumbThis field contains an internally BL130 BL20.1
generated reference number used by the BL20.3 BL21.2
Requisition system. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-ROUTE Numeric 4 BL120 BL122
Element: Route This field contains the route number. BL130 BL20.1
If left blank, the route assigned to the BL20.3 BL21.2
ship-to customer defaults from the Order BL21.5 BL29.1
Entry Route file. If no route is BL29.2 BL520
assigned to the ship-to customer in the BL820 BL92.1
Order Entry Route file, the route OE10.1 OE10.2
defaults from the customer. OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 OE90.1
OE90.2 WH120
WH20.7 WH21.3
WH21.4
COL-STOP Numeric 4 BL120 BL122
Element: Stop This field contains the stop within the BL130 BL20.1
route. If left blank, this defaults from BL20.3 BL21.2
the ship-to customer from the Order BL21.5 BL29.1
Entry Route file. If no stop is BL29.2 BL520
associated with the ship-to customer, BL820 BL92.1
this defaults from the customer's file. OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 OE90.1
OE90.2 WH120
WH20.7 WH21.3
WH21.4
COL-RTE-CREATE-FL Alpha 1 BL120 BL122
Element: All Flag This field indicates whether a route BL130 BL20.1
record exists for this line. BL20.3 BL21.2
Y = Yes BL21.5 BL29.1
N = No BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 OE90.1
OE90.2 WH110
WH120 WH130
WH132 WH190
WH20.7 WH21.1
WH21.2 WH30.1
WH30.2 WH30.3
...
COL-EXP-DELIV-DT Numeric 8 (yyyymmdd) BL120 BL122
Element: Date This field contains the expected BL130 BL20.1
delivery date. This field is valid only BL20.3 BL21.2
for a company that uses routes and BL21.5 BL29.1
stops. The expected delivery date is BL29.2 BL520
calculated by adding the ship days from BL820 BL92.1
the process level associated with the OE10.1 OE10.2
order to the system date when the order OE10.3 OE10.4
is added. This field determines when the OE10.5 OE10.6
order prints on the picking list for OE10.7 OE10.8
processing. OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 OE90.1
OE90.2 WH120
WH20.7 WH21.3
WH21.4
COL-TERRITORY Alpha 4 BL120 BL122
Element: Sales TerritorThis field contains the sales BL130 BL20.1
territory. If left blank, this defaults BL20.3 BL21.2
from the ship-to customer. If no sales BL21.5 BL29.1
territory is assigned to the ship-to BL29.2 BL520
customer, this defaults from the BL820 BL92.1
customer's file. OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-SALESMAN Numeric 4 BL120 BL122
Element: Salesman NumbeThis field contains the code that BL130 BL20.1
represents the primary sales BL20.3 BL21.2
representative of this line. This BL21.5 BL29.1
defaults from the order header. BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-SALESMAN-2 Numeric 4 BL120 BL122
Element: Salesman NumbeThis field contains the code BL130 BL20.1
representing the second sales BL20.3 BL21.2
representative. This defaults from the BL21.5 BL29.1
order header. BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-COMM-SPLIT Percent 5.3 (Percent) BL120 BL122
Commission Split Commission split for the second sales BL130 BL20.1
Percentage representative. This is the percentage BL20.3 BL21.2
of this line's total value the secondary BL21.5 BL29.1
sales representative's commission rate BL29.2 BL520
is applied to. BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-COMM-RATE-1 Percent 7.5 (Percent) BL120 BL122
Element: Chrg Rate Commission rate for sales BL130 BL20.1
representative 1. Defaults from the BL20.3 BL21.2
sales representative file. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-COMM-RATE-2 Percent 7.5 (Percent) BL120 BL122
Element: Chrg Rate This field contains the commission rate BL130 BL20.1
for the second sales representative. BL20.3 BL21.2
This defaults from the sales BL21.5 BL29.1
representative file. BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-ENTERED-DISC Signed 18.2 BL120 BL122
Element: Intl Amt This field contains a per line discount BL130 BL20.1
rather than a per unit discount as BL20.3 BL21.2
entered in the order-line's billing BL21.5 BL29.1
currency. BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE286
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE530
OE810 OE830
WH20.7
COL-MULT-ADD-DISC Derived
Element: Mult Add Disc This field contains the add-on discount
amount in base currency if a multiplier
is used to convert from original to base
currency.
COL-DIV-ADD-DISC Derived
Element: Div Add Disc This field contains the additional
discount amount in base currency if a
divider is used to convert from original
to base currency.
COL-ADD-DISC-BASE Derived
Element: Add Disc Base This field contains the additional
discount amount in base currency.
COL-DISC-TKN-CURR Signed 18.2 BL120 BL122
Element: Intl Amt This field contains the amount of the BL130 BL20.1
additional discount that has been used BL20.3 BL21.2
by invoices for this order line in BL21.5 BL29.1
billing currency. If you need to lower BL29.2 BL520
an additional discount on the line, the BL820 BL92.1
amount cannot be lowered below amount OE10.1 OE10.2
found in this field for this line. OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-MULT-DISC-TKN Derived
Element: Mult Disc Tkn This field contains the multiplier used
to derive the base currency amount of
the discount if the order or invoice is
entered in foreign currency.
COL-DIV-DISC-TKN Derived
Element: Div Disc Tkn This field contains the multiplier used
to derive the base currency amount of
the discount if the order or invoice is
entered in foreign currency.
COL-DISC-TKN-BASE Derived
Element: Disc Tkn Base This field contains the amount of
additional discount in base currency
used by invoices for this order line.
COL-TAX-EXEMPT-CD Alpha 1 BL120 BL122
Element: Tax Exempt CodThis field contains the tax exempt BL130 BL20.1
code. This defaults from the order BL20.3 BL21.2
header. If the order header is tax BL21.5 BL29.1
exempt, the line is also tax exempt. BL29.2 BL520
E = Exempt BL820 BL92.1
T = Taxable OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-TAX-CODE Alpha 10 BL120 BL122
Element: Tax Code This field contains a code representing BL130 BL20.1
the tax authorities this ship-to pays BL20.3 BL21.2
sales tax to. This must be valid in the BL21.5 BL29.1
Tax Code file. If the company is not BL29.2 BL520
using a third-party tax system, this BL820 BL92.1
code is the tax code for the order line. OE10.1 OE10.2
Tax codes are entered in the Tax system OE10.3 OE10.4
and can be associated with the customer OE10.5 OE10.6
or entered when adding the order. OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-TAXABLE-CURR Signed 18.2 BL120 BL122
Element: Intl Amt This field contains the taxable amount BL130 BL20.1
in billing currency. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 OE90.2
WH20.2 WH20.7
COL-MULT-TAXABLE Derived
Element: Mult Taxable This field contains the taxable amount
in base currency if a multiplier is used
to convert from original to base
currency.
COL-DIV-TAXABLE Derived
Element: Div Taxable This field contains the taxable amount
in base currency if a divider is used to
convert from original to base currency.
COL-OVR-TAXABLE Signed 18.2 BL120 BL122
Element: Intl Amt This field contains the override BL130 BL20.1
taxable amount in base currency. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 OE90.2
WH20.2 WH20.7
COL-MULT-OVR-TXBL Derived
Element: Mult Ovr Txbl This field contains the override
taxable amount in base currency if a
multiplier is used to convert from
original to base currency.
COL-DIV-OVR-TXBL Derived
Element: Div Ovr Txbl This field contains the override
taxable amount in base currency if a
divider is used to convert from original
to base currency.
COL-TAXABLE-BASE Derived
Element: Taxable Base This field contains the override
taxable amount in base currency.
COL-EARLY-DL-DATE Numeric 8 (yyyymmdd) BL120 BL122
Early Delivery Date This field contains the early delivery BL130 BL20.1
(Rqst DT) date. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-LATE-DL-DATE Numeric 8 (yyyymmdd) BL120 BL122
Element: Late Delivery This field contains the late delivery BL130 BL20.1
date. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-USER-DATE-3 Numeric 8 (yyyymmdd) BL120 BL122
Element: Date This field contains the third BL130 BL20.1
user-definable date. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-USER-DATE-4 Numeric 8 (yyyymmdd) BL120 BL122
Element: Date This field contains the fourth BL130 BL20.1
user-defined date. Informational BL20.3 BL21.2
purposes only used on OE280 (Open Orders BL21.5 BL29.1
by Customer). BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-USER-FLD1 Alpha 2 BL120 BL122
Purchase Order User This field contains the first BL130 BL20.1
Field 2 user-definable field. If a purchase BL20.3 BL21.2
order is created for this order, this BL21.5 BL29.1
field updates to the Purchase Order BL29.2 BL520
system. BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-USER-FLD2 Alpha 30 (Lower Case) BL120 BL122
Element: User Defined FThis field contains the second BL130 BL20.1
user-definable field. If a purchase BL20.3 BL21.2
order is created for this order, this BL21.5 BL29.1
field updates to the Purchase Order BL29.2 BL520
system. This field also updates to the BL820 BL92.1
Sales Analysis system. OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-USER-FLD3 Alpha 15 (Lower Case) BL120 BL122
Element: User Defined FThis field contains the third BL130 BL20.1
user-definable field. If a purchase BL20.3 BL21.2
order is created for this order, this BL21.5 BL29.1
field updates to the Purchase Order BL29.2 BL520
system. This field also updates to the BL820 BL92.1
Sales Analysis system. OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-EXP-SHIP-DT Numeric 8 (yyyymmdd) BL120 BL122
Element: Date Expected ship date. Defaulted by the BL130 BL20.1
system as the number of ship days (from BL20.3 BL21.2
process level record) beyond the system BL21.5 BL29.1
date when the line is added. May be BL29.2 BL520
overridden. BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-ALLOCATE-DT Numeric 8 (yyyymmdd) BL120 BL122
Element: Date This field contains the date used for BL130 BL20.1
batch allocations. The type of date BL20.3 BL21.2
depends on a company option, and can be BL21.5 BL29.1
the order date, the customer requested BL29.2 BL520
delivery date or the expected ship date. BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-LIST-NAME Alpha 14 BL120 BL122
Element: List Name This field contains the name of the BL130 BL20.1
price list, if this line is priced using BL20.3 BL21.2
a price list or a promotion. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-CONTRACT-NBR Alpha 14 BL120 BL122
Element: Contract NumbeThis field contains the contract BL130 BL20.1
number, if this line is priced using a BL20.3 BL21.2
contract. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-PROMOTION Alpha 10 BL120 BL122
Element: Promotion This field contains the promotion name, BL130 BL20.1
if this line is priced via a promotion. BL20.3 BL21.2
When combined with the list name, it BL21.5 BL29.1
provides access to the promotion file. BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-ACTIVITY Alpha 15 BL120 BL122
Element: Activity In this file the Activity field is used BL130 BL20.1
for the revenue (sales) side of the BL20.3 BL21.2
posting whereas the Activity-C field is BL21.5 BL29.1
used for the Cost (COGS) side of the BL29.2 BL520
posting. BL820 BL92.1
OE10.1 OE10.2
Activities are the processes or OE10.3 OE10.4
procedures that produce work. Cost OE10.5 OE10.6
objects (products, services, customers, OE10.7 OE10.8
and so on) are the reasons for OE11.1 OE11.4
performing the activity. Activities and OE11.8 OE11.9
cost object activities are used OE110 OE111
synonymously in the Activity Management OE113 OE114
system. Direct costs are posted to OE116 OE129
activities, and indirect costs are OE13.2 OE13.3
allocated to activities based on OE13.5 OE13.6
activity drivers. OE14.4 OE30.1
OE30.2 OE30.3
Activities are grouped or organized by OE30.4 OE30.5
activity levels. There are two types of OE30.6 OE30.7
activities: "posting allowed" and OE30.9 OE510
"summary only." Use posting level OE530 OE810
activities to budget and maintain all OE830 WH20.7
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
COL-ACCT-CATEGORY Alpha 5 BL120 BL122
Element: Account CategoIn this file the Acct-Category field is BL130 BL20.1
used for revenue (sales) postings BL20.3 BL21.2
whereas the Acct-Categ-C field is used BL21.5 BL29.1
for Cost (COGS) postings. BL29.2 BL520
BL820 BL92.1
Account categories are groupings of OE10.1 OE10.2
costs, revenues, or a combination of OE10.3 OE10.4
both used for reporting and inquiries OE10.5 OE10.6
for activities in the Activity OE10.7 OE10.8
Management system. All transactions are OE11.1 OE11.4
posted to an account category within an OE11.8 OE11.9
activity. You can assign a specific OE110 OE111
General Ledger account or range of OE113 OE114
accounts (company, accounting unit, OE116 OE129
account, and subaccount) that make up OE13.2 OE13.3
the transactions posted to an account OE13.5 OE13.6
category using AC07.1 (Account OE14.4 OE30.1
Assignment). OE30.2 OE30.3
OE30.4 OE30.5
Period-to-date, year-to-date, and OE30.6 OE30.7
life-to-date balances are maintained by OE30.9 OE510
account category for activities. Account OE530 OE810
categories must be assigned to OE830 WH20.7
activities before you do any budgeting
or transaction processing.
COL-ATN-OBJ-ID Numeric 12 BL120 BL122
Object Represents Activity Management system BL130 BL20.1
Identification ID for the revenue (sales) activity. BL20.3 BL21.2
BL21.5 BL29.1
Activities are the processes or BL29.2 BL520
procedures that produce work. Cost BL820 BL92.1
objects (products, services, customers, OE10.1 OE10.2
and so on) are the reasons for OE10.3 OE10.4
performing the activity. Activities and OE10.5 OE10.6
cost object activities are used OE10.7 OE10.8
synonymously in the Activity Management OE11.1 OE11.4
system. Direct costs are posted to OE11.8 OE11.9
activities, and indirect costs are OE110 OE111
allocated to activities based on OE113 OE114
activity drivers. OE116 OE129
OE13.2 OE13.3
Activities are grouped or organized by OE13.5 OE13.6
activity levels. There are two types of OE14.4 OE30.1
activities: "posting allowed" and OE30.2 OE30.3
"summary only." Use posting level OE30.4 OE30.5
activities to budget and maintain all OE30.6 OE30.7
posted transactions. Summary activities OE30.9 OE510
or macro activities combine information OE530 OE810
and balances from lower level activities OE830 WH20.7
for reporting inquiries.
COL-ACTIVITY-C Alpha 15 BL120 BL122
Element: Activity In this file the Activity-C field is BL130 BL20.1
used for the Cost (COGS) side of the BL20.3 BL21.2
posting whereas the Activity field is BL21.5 BL29.1
used for the revenue (sales) side of the BL29.2 BL520
posting. BL820 BL92.1
OE10.1 OE10.2
Activities are the processes or OE10.3 OE10.4
procedures that produce work. Cost OE10.5 OE10.6
objects (products, services, customers, OE10.7 OE10.8
and so on) are the reasons for OE11.1 OE11.4
performing the activity. Activities and OE11.8 OE11.9
cost object activities are used OE110 OE111
synonymously in the Activity Management OE113 OE114
system. Direct costs are posted to OE116 OE129
activities, and indirect costs are OE13.2 OE13.3
allocated to activities based on OE13.5 OE13.6
activity drivers. OE14.4 OE30.1
OE30.2 OE30.3
Activities are grouped or organized by OE30.4 OE30.5
activity levels. There are two types of OE30.6 OE30.7
activities: "posting allowed" and OE30.9 OE510
"summary only." Use posting level OE530 OE810
activities to budget and maintain all OE830 WH20.7
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
COL-ACCT-CATEG-C Alpha 5 BL120 BL122
Element: Account CategoIn this file the Acct-Categ-C field is BL130 BL20.1
used for Cost (COGS) postings whereas BL20.3 BL21.2
the Acct-Category field is used for BL21.5 BL29.1
revenue (sales) postings. BL29.2 BL520
BL820 BL92.1
Account categories are groupings of OE10.1 OE10.2
costs, revenues, or a combination of OE10.3 OE10.4
both used for reporting and inquiries OE10.5 OE10.6
for activities in the Activity OE10.7 OE10.8
Management system. All transactions are OE11.1 OE11.4
posted to an account category within an OE11.8 OE11.9
activity. You can assign a specific OE110 OE111
general ledger account or range of OE113 OE114
accounts (company, accounting unit, OE116 OE129
account, and subaccount) that make up OE13.2 OE13.3
the transactions posted to an account OE13.5 OE13.6
category using AC07.1 (Account OE14.4 OE30.1
Assignment). OE30.2 OE30.3
OE30.4 OE30.5
Period-to-date, year-to-date, and OE30.6 OE30.7
life-to-date balances are maintained by OE30.9 OE510
account category for activities. Account OE530 OE810
categories must be assigned to OE830 WH20.7
activities before you do any budgeting
or transaction processing.
COL-ATN-OBJ-ID-C Numeric 12 AP125 AP126
Object The system defined object id AP131 AP25.1
Identification representing the Activity Management AP25.2 AP26.1
commitment for Cost (COGS). AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
COL-BOOKED-FL Alpha 1 BL120 BL122
Element: Account Flag This field indicates if the order line BL130 BL20.1
has been booked by the Sales Analysis BL20.3 BL21.2
system. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-BOOKED-DATE Numeric 8 (yyyymmdd) BL120 BL122
Element: Date This field indicates the date when the BL130 BL20.1
order line was booked by the Sales BL20.3 BL21.2
Analysis system. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-BOOKED-QTY Signed 13.4 BL120 BL122
Element: Quantity This field contains the quantity booked BL130 BL20.1
to the customer and sales representative BL20.3 BL21.2
totals. This is updated to the Sales BL21.5 BL29.1
Analysis system for reporting and BL29.2 BL520
inquiry analysis. BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 SA100
SA101 WH20.7
COL-ORDER-QTY Signed 13.4 BL120 BL122
Element: Quantity The order quantity of the line item. BL125 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
OE286 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH130
WH132 WH190
WH20.7 WH520
WH830
COL-SHIPPED-QTY Signed 13.4 BL120 BL122
Element: Quantity This field contains the shipped BL130 BL20.1
quantity. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH126
WH130 WH132
WH190 WH20.7
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
...
COL-INVOICE-QTY Signed 13.4 BL120 BL122
Element: Quantity This field contains the quantity that BL130 BL20.1
has been invoiced for this order line. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-RETURNED-QTY Signed 13.4 OE30.1 OE30.2
Element: Quantity Total quantity returned compared to OE30.3 OE30.4
this quantity. OE30.5 OE30.6
OE30.7 OE30.9
COL-FIRM-FL Alpha 1 BL120 BL122
Element: Firm Fl This field indicates if the allocation BL130 BL20.1
is firm. If the value is set to Yes, BL20.3 BL21.2
WH110 (Batch Allocation) skips the BL21.5 BL29.1
record in the de-allocation phase. BL29.2 BL520
Y = Yes BL820 BL92.1
N = No OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-SHIP-COMP-FL Alpha 1 BL120 BL122
Element: Ship Comp Fl BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-PK-PRIORITY Numeric 2 BL120 BL122
Element: Picking Priority BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-SLS-ACCT-UNIT Alpha 15 BL120 BL122
Element: Accounting UniThis field contains the sales account BL130 BL20.1
unit, if the line is special order. If BL20.3 BL21.2
left blank, this defaults from the BL21.5 BL29.1
process level. BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-SLS-ACCOUNT Numeric 6 BL120 BL122
Element: Account This field contains the sales account BL130 BL20.1
number, if the line is for a special BL20.3 BL21.2
order item. If left blank, this defaults BL21.5 BL29.1
from the process level. BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-SLS-SUB-ACCT Numeric 4 BL120 BL122
Element: Subaccount This field contains the sales BL130 BL20.1
subaccount number, if the line is BL20.3 BL21.2
special order. If left blank, this BL21.5 BL29.1
defaults from the process level. BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-EXP-ACCT-UNIT Alpha 15 BL120 BL122
Element: Accounting UniThis field contains the general ledger BL130 BL20.1
account to credit for the cost amount of BL20.3 BL21.2
nonstock and special orders. This BL21.5 BL29.1
defaults from the process level for BL29.2 BL520
special order lines and from the BL820 BL92.1
major/minor sales class file for OE10.1 OE10.2
nonstock lines. OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-EXP-ACCOUNT Numeric 6 BL120 BL122
Element: Account This field contains the general ledger BL130 BL20.1
distribution account that is credited BL20.3 BL21.2
for nonstock and special orders. This BL21.5 BL29.1
defaults from the process level for BL29.2 BL520
special orders and from major/minor BL820 BL92.1
sales class for nonstock orders. OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-EXP-SUB-ACCT Numeric 4 BL120 BL122
Element: Subaccount This field contains the general ledger BL130 BL20.1
distribution subaccount that is credited BL20.3 BL21.2
for nonstock and special orders. This BL21.5 BL29.1
defaults from the process level for BL29.2 BL520
special orders and from the major/minor BL820 BL92.1
sales class for nonstock orders. OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-CGS-ACCT-UNIT Alpha 15 BL120 BL122
Element: Accounting UniThe cost of goods sold account unit is BL130 BL20.1
debited and defaults from the process BL20.3 BL21.2
level for special order items or from BL21.5 BL29.1
the sales class for inventoried or BL29.2 BL520
nonstock items. This account is credited BL820 BL92.1
for return to stock transactions. OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-CGS-ACCOUNT Numeric 6 BL120 BL122
Element: Account The cost of goods sold account number BL130 BL20.1
is debited and defaults from the process BL20.3 BL21.2
level for special order items or from BL21.5 BL29.1
the sales class for inventoried or BL29.2 BL520
nonstock items. This account is credited BL820 BL92.1
for return to stock transactions. OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-CGS-SUB-ACCT Numeric 4 BL120 BL122
Element: Subaccount The cost of goods sold subaccount BL130 BL20.1
number is debited and defaults from the BL20.3 BL21.2
process level for special order items or BL21.5 BL29.1
from the sales class for inventoried or BL29.2 BL520
nonstock items. This account is credited BL820 BL92.1
for return to stock transactions. OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-PROD-TAX-CAT Alpha 15 BL120 BL122
Element: Product Tax CaA classification of items for BL130 BL20.1
determining taxes using the VERTEX BL20.3 BL21.2
system in Lawson Order Entry system or BL21.5 BL29.1
the cash receipts programs in the Lawson BL29.2 BL520
Cash Ledger system. BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-CXL-DATE Numeric 8 (yyyymmdd) BL120 BL122
Element: Date This field contains the date this line BL130 BL20.1
was canceled. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH130
WH132 WH190
WH20.7 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
...
COL-CXL-QTY Signed 13.4 BL120 BL122
Element: Receiving QuanThis field contains the quantity BL130 BL20.1
canceled for this order line. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH130
WH132 WH190
WH20.7 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
...
COL-CXL-OPR Alpha 10 (Lower Case) BL120 BL122
Element: Requester This field contains the user ID of the BL130 BL20.1
person who canceled this order line. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH130
WH132 WH190
WH20.7 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
...
COL-CXL-REASON Alpha 4 BL120 BL122
Element: Cb Reason This field contains the reason for BL130 BL20.1
canceling this order. Reason codes are BL20.3 BL21.2
set up in BL07.1 (Reason Codes). BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH130
WH132 WH190
WH20.7 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
...
COL-LAST-COMM-SEQ Numeric 3 BL120 BL122
Element: Sequence NumbeThis field contains the sequence number BL130 BL20.1
of the last comment line entered on this BL20.3 BL21.2
line. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BLI2.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.5
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-LAST-MISC-SEQ Numeric 3 BL120 BL122
Element: Sequence NumbeThis field contains the last sequence BL130 BL20.1
used for miscellaneous charges for this BL20.3 BL21.2
line. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-MSDS-REQ-FL Alpha 1 BL120 BL122
Element: All Flag This field indicates that an MSDS BL130 BL20.1
(Material Safety Data Sheet) is BL20.3 BL21.2
required. If set to Yes, an MSDS BL21.5 BL29.1
acknowledgment is required for the first BL29.2 BL520
shipment containing the item even if an BL820 BL92.1
MSDS acknowledgment has been sent within OE10.1 OE10.2
a year for this item to the customer. OE10.3 OE10.4
The Order Entry system does not create OE10.5 OE10.6
MSDS forms, but it keeps track of when OE10.7 OE10.8
the form was sent. OE11.1 OE11.4
Y = Yes OE11.8 OE11.9
N = No OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-LAST-SHIP-NBR Numeric 10 BL120 BL122
Element: Shipment NumbeThis field contains the last shipment BL130 BL20.1
number created for this order line. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-WORK-ORDER Numeric 8 WO20.1 WO30.1
Element: Work Order This identifies the work order the line
may be associated with. It is used if
work order is active and the line is a
finished good with a backorder quantity.
COL-WORK-ORDER-SUF Numeric 2 WO20.1 WO30.1
Element: Work Order SufThis is the suffix of the work order
the line may be associated with. It
will normally be zero.
COL-PRICE-REC-TYPE Alpha 1 BL120 BL122
Element: Price Rec TypeC = Class BL130 BL20.1
I = Item BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-QTY-BREAK-FL Alpha 1 BL120 BL122
Element: Qty Break Fl Y = Yes BL130 BL20.1
N = No BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-GROSS-AMOUNT Derived
Element: Gross Amount This field contains the line extension
in base currency before discounts are
taken.
COL-NET-AMOUNT Derived
Element: Net Amount This field contains the line amount in
base currency after discounts have been
removed.
COL-CURR-GROSS Derived
Element: Curr Gross This field contains the gross amount in
transaction currency.
COL-CURR-NET Derived
Element: Curr Net This field contains the line net amount
in transaction currency.
COL-OPEN-TO-ALLOC Derived
Element: Open To Alloc This field contains quantity available
for allocation.
COL-ALLOC-NOT-PRT Derived
Element: Alloc Not Prt This field contains the allocated
quantity that has not been printed on
the picking list.
COL-PROJ-STD-COST Derived
Element: Proj Std Cost This field contains the projected cost
for a standard cost company. This is
used when editing the profit margin for
a particular order.
COL-PROJ-AVG-COST Derived
Element: Proj Avg Cost This field contains the projected cost
for any company not using standard cost.
This is used when editing the profit
margin for a particular order.
COL-PROJ-SPL-COST Derived
Element: Proj Spl Cost This field contains the projected
extended cost for special and nonstock
items. This is based on the cost entered
when adding the order. This is used when
calculating the profit margin of the
order.
COL-PROJ-COST Derived
Element: Proj Cost This field contains the projected cost
for this line. This can either be the
projected standard cost or the projected
average cost.
COL-PROJ-MARGIN Derived
Element: Proj Margin This field contains the projected
margin for this line.
COL-UNBILLED-QTY Derived
Element: Unbilled Qty This field contains the unbilled
quantity on the line.
COL-UNBILLED-BASE Derived
Element: Unbilled Base This field contains the unbilled
quantity on the order line in base
currency.
COL-UNBILLED-CURR Derived
Element: Unbilled Curr This field contains the unbilled amount
in transaction currency.
COL-ORD-QTY-IN-STK Derived
Element: Ord Qty In StkThis field contains the quantity of
item in stock unit of measure.
COL-BO-FL Derived
Element: Backorder FlagThis field indicates if the order line
was backordered.
COL-PRICE-LOC Derived
Element: Price Loc This field indicates the pricing
location for the order line.
COL-ORDER-FILLER Derived
Element: Order Filler Used to facilitate Drill Around to
shipments for this order.
COL-ORDER-NBR-A Derived
Element: Order Nbr A Used to facilitate Drill Around to
shipments for this order.
COL-DISP-ALLOCATED Derived
Element: Disp AllocatedUsed to facilitate Drill Around of
quantity allocated.
COL-DISP-PRINTED Derived
Element: Disp Printed Used to facilitate Drill Around of pick
list quantity printed.
COL-DISP-IN-PROC Derived
Element: Disp In Proc Used to facilitate Drill Around of
quantity in process.
COL-DISP-BACKORD Derived
Element: Disp Backord Used to facilitate Drill Around of
quantity back ordered.
COL-COMM-LIT Derived
Element: Comm Lit If comments are attached, this field
displays "comments exist."
COL-DER-ORIGIN-CD Derived
Element: Der Origin Cd
COL-INTR-COMP Alpha 1 BL120 BL122
Element: Intr Comp Identifies Inter-Company order lines as BL130 BL20.1
"O" for the customer order line, "S" for BL20.3 BL21.2
the shipping company, or N" not an BL21.5 BL29.1
Inter-company order line. BL29.2 BL520
O = Inter-Co Customer order BL820 BL92.1
S = Inter-Co Shipping order OE10.1 OE10.2
N = Not an Inter-Co Order OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-FOB-CODE Alpha 3 BL120 BL122
Element: Shipping Term The user defined Free On Board Code. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-PORT-CD Alpha 5 BL120 BL122
Element: Port Cd The Intrastat port code. Must be BL130 BL20.1
define BL20.3 BL21.2
in IN04.1 (Port Maintenance) BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-NOTC Alpha 2 BL120 BL122
Element: Notc The Nature of Transaction code. Must BL130 BL20.1
be a valid code defined in IN07.1 (NOTC BL20.3 BL21.2
Maintenance). BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-STAT-PROC Alpha 6 BL120 BL122
Element: Stat Proc The statistical procedure code applied BL130 BL20.1
to the data. The code must be defined BL20.3 BL21.2
in IN06.1. (Statistical Procedure BL21.5 BL29.1
Maintenance). BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-SUPLMNTARY-UOM Alpha 4 BL120 BL122
Element: Unit of Measure BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-SUPLMNTARY-QTY Signed 13.4 BL120 BL122
Element: Quantity BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COL-ICN-CODE Alpha 8 BL120 BL122
Element: Icn Code BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COLINE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
COLSET1 COMPANY AP125 AP126
ORDER-NBR AP131 AP25.1
LINE-NBR AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL125 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL80.1
BL820 BL92.1
BLI2.1 IC11.1
IC28.1 MA180
MA530 MA531
MA60.2 MA60.3
...
COLSET10 COMPANY KeyChange BL120 BL122
ORDER-NBR BL130 BL20.1
TAX-CODE BL20.3 BL21.2
PROD-TAX-CAT BL21.5 BL29.1
LINE-NBR BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE112 OE113
OE114 OE129
...
COLSET11 COMPANY Subset OE129 OE229
CUSTOMER Where CREATE-PO = "Y"
ORDER-NBR And DROPSHIP-FL = "Y"
LINE-NBR And STATUS = 2
And ORDER-QTY > INVOICE-QTY
COLSET12 COMPANY Subset OE90.1 OE90.2
CUSTOMER Where STATUS = 2
ORDER-NBR And CREATE-PO = "Y"
LINE-NBR And ORDER-QTY > SHIPPED-QTY
COLSET13 COMPANY This index was created as a solution to BL120 BL122
LINE-NBR the Find Next/Prev Flag error. It is BL130 BL20.1
ORDER-NBR only used where a modify must be done BL20.3 BL21.2
within a 850-FIND-NLT or 850-FIND-BEGRNG BL21.5 BL29.1
loop. BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
...
COLSET2 COMPANY KeyChange, Subset OE287 WH120
INV-LOC Where STATUS = 2
ITEM
PROCESS-LEVEL
ORDER-NBR
LINE-NBR
COLSET3 COMPANY KeyChange OE81.2 WH21.1
CUSTOMER
ITEM
ORDER-NBR
LINE-NBR
COLSET4 COMPANY Subset BL120 BL122
ORDER-NBR Where PRICE-STATUS = "A" BL130 BL20.1
SALES-MAJCL BL20.3 BL21.2
SALES-MINCL BL21.5 BL29.1
LINE-NBR BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
...
COLSET5 ATN-OBJ-ID KeyChange, Subset
Where ATN-OBJ-ID != Zeroes
COLSET6 COMPANY KeyChange, Subset OE90.2
CUSTOMER Where HOLD-CODE != Spaces
HOLD-CODE
ORDER-NBR
LINE-NBR
COLSET7 COMPANY Subset BL120 BL122
ORDER-NBR Where STATUS < 3 BL130 BL20.1
LINE-NBR BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE129 OE13.2
...
COLSET8 ATN-OBJ-ID-C KeyChange, Subset
Where ATN-OBJ-ID-C != Zeroes
COLSET9 COMPANY Subset BL120 BL122
ORDER-NBR Where STATUS = 2 BL130 BL20.1
VENDOR And CREATE-PO = "Y" BL20.3 BL21.2
CUST-SHIP-TO And ORDER-QTY > SHIPPED-QTY BL21.5 BL29.1
DROPSHIP-FL BL29.2 BL520
LINE-NBR BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
...
COLINE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
When COL-CARRIER != Spaces
COL-COMPANY -> CPY-COMPANY
Apvenmast APVENMAST Required
When COL-CARRIER != Spaces
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
COL-CARRIER -> VEN-VENDOR
Arcomp ARCOMP Required
COL-COMPANY -> ACO-COMPANY
Arcustomer ARCUSTOMER Required
COL-COMPANY -> ACM-COMPANY
COL-CUSTOMER -> ACM-CUSTOMER
Cogs Offset GLMASTER Required
When COL-LINE-TYPE = "N"
Or COL-LINE-TYPE = "X"
COL-COMPANY -> GLM-COMPANY
COL-EXP-ACCT-UNIT -> GLM-ACCT-UNIT
COL-EXP-ACCOUNT -> GLM-ACCOUNT
COL-EXP-SUB-ACCT -> GLM-SUB-ACCOUNT
Colineuom COLINEUOM Not Required, Delete Cascades
Valid When COL-MULT-SPR-FL = "Y"
COL-COMPANY -> COU-COMPANY
COL-ORDER-NBR -> COU-ORDER-NBR
COL-LINE-NBR -> COU-LINE-NBR
Contract OEPRCLIST Required
When COL-CONTRACT-NBR != Spaces
COL-COMPANY -> OPL-COMPANY
COL-CUSTOMER -> OPL-CUSTOMER
COL-CONTRACT-NBR -> OPL-LIST-NAME
Spaces -> OPL-PROMOTION
Cosgblk COSGBLK Not Required
COL-COMPANY -> OSG-COMPANY
COL-ORDER-NBR -> OSG-ORDER-NBR
COL-LINE-NBR -> OSG-LINE-NBR
Zeroes -> OSG-SEQ
Cucodes CUCODES Required
COR-CURRENCY-CODE -> CUC-CURRENCY-CODE
Curelat CURELAT Required
When COR-CURRENCY-CODE != COL-CURRENCY-CODE
GLS-CURRENCY-TABLE -> CRL-CURRENCY-TABLE
COR-CURRENCY-CODE -> CRL-FR-CURR-CODE
OEC-CURRENCY-CODE -> CRL-TO-CURR-CODE
Custdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
COL-CUSTOMER -> CUD-CUSTOMER
Custorder CUSTORDER Required
COL-COMPANY -> COR-COMPANY
COL-ORDER-NBR -> COR-ORDER-NBR
Cxl Operator OPERATOR Required
When COL-CXL-OPR != Spaces
COL-COMPANY -> OPE-DEF-COMPANY
COL-CXL-OPR -> OPE-OPR-CODE
Glsystem GLSYSTEM Required
COL-COMPANY -> GLS-COMPANY
Hdrloc ITEMLOC Not Required
COL-COMPANY -> ITL-COMPANY
COR-INV-LOCATION -> ITL-LOCATION
COL-ITEM -> ITL-ITEM
Holdcodes HOLDCODES Required
When COL-HOLD-CODE != Spaces
ACO-CUST-GROUP -> HDD-CUST-GROUP
COL-HOLD-CODE -> HDD-HOLD-CODE
Iccategory ICCATEGORY Not Required
Valid When COL-LINE-TYPE = "I"
COL-COMPANY -> ICA-COMPANY
COL-INV-LOC -> ICA-LOCATION
ITL-GL-CATEGORY -> ICA-GL-CATEGORY
Iccompany ICCOMPANY Required
When COL-LINE-TYPE != "X"
COL-COMPANY -> ICC-COMPANY
Iclocation ICLOCATION Required
COL-COMPANY -> ICL-COMPANY
COL-INV-LOC -> ICL-LOCATION
Itemlocation ITEMLOC Required
When COL-INV-LOC != Spaces
And COL-LINE-TYPE = "I"
COL-COMPANY -> ITL-COMPANY
COL-INV-LOC -> ITL-LOCATION
COL-ITEM -> ITL-ITEM
Itemmast ITEMMAST Required
When COL-LINE-TYPE != "X"
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
COL-ITEM -> ITE-ITEM
Kititem KITITEM Not Required
Valid When COL-KIT-FL = "O"
ICC-ITEM-GROUP -> KIT-ITEM-GROUP
COL-COMPANY -> KIT-COMPANY
COL-INV-LOC -> KIT-LOCATION
COL-ITEM -> KIT-ITEM
Kititem 2 KITITEM Not Required
Valid When COL-KIT-FL != "O"
ICC-ITEM-GROUP -> KIT-ITEM-GROUP
COL-COMPANY -> KIT-COMPANY
COL-INV-LOC -> KIT-LOCATION
COL-ITEM -> KIT-ITEM
Majorcl MAJORCL Required
When COL-LINE-TYPE != "X"
ICC-ITEM-GROUP -> MAJ-ITEM-GROUP
"S" -> MAJ-CLASS-TYPE
ITE-SALES-MAJCL -> MAJ-MAJOR-CLASS
Minorcl MINORCL Not Required
Valid When COL-LINE-TYPE != "X"
ICC-ITEM-GROUP -> MIN-ITEM-GROUP
"S" -> MIN-CLASS-TYPE
ITE-SALES-MAJCL -> MIN-MAJOR-CLASS
ITE-SALES-MINCL -> MIN-MINOR-CLASS
Oecoluf OECOLUF Required
COL-COMPANY -> OLU-COMPANY
COL-ORDER-NBR -> OLU-ORDER-NBR
COL-LINE-NBR -> OLU-LINE-NBR
Oecompany OECOMPANY Required
COL-COMPANY -> OEC-COMPANY
Oecust OECUST Required
COL-COMPANY -> OET-COMPANY
COL-CUSTOMER -> OET-CUSTOMER
Oeproclev OEPROCLEV Required
COL-COMPANY -> OEP-COMPANY
COL-PROCESS-LEVEL -> OEP-PROCESS-LEVEL
Oereason OEREASON Not Required
Valid When COL-CXL-OPR != Spaces
COL-COMPANY -> OER-COMPANY
COL-CXL-REASON -> OER-REASON-CODE
Oeslsacct OESLSACCT Required
When COL-LINE-TYPE != "X"
COL-COMPANY -> OSA-COMPANY
COL-PROCESS-LEVEL -> OSA-PROCESS-LEVEL
ITE-SALES-MAJCL -> OSA-SALES-MAJCL
ITE-SALES-MINCL -> OSA-SALES-MINCL
Operator OPERATOR Required
COL-COMPANY -> OPE-DEF-COMPANY
COR-OPR-CODE -> OPE-OPR-CODE
Ordertype ORDERTYPE Required
COL-COMPANY -> OTP-COMPANY
COR-ORDER-TYPE -> OTP-ORDER-TYPE
Po Vendor APVENMAST Required
When COL-VENDOR != Spaces
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
COL-VENDOR -> VEN-VENDOR
Promotion OEPRCLIST Required
When COL-PROMOTION > Spaces
COL-COMPANY -> OPL-COMPANY
Spaces -> OPL-CUSTOMER
COR-LIST-NAME -> OPL-LIST-NAME
COL-PROMOTION -> OPL-PROMOTION
Sales Acct GLMASTER Required
When COL-LINE-TYPE = "N"
Or COL-LINE-TYPE = "X"
COL-COMPANY -> GLM-COMPANY
COL-SLS-ACCT-UNIT -> GLM-ACCT-UNIT
COL-SLS-ACCOUNT -> GLM-ACCOUNT
COL-SLS-SUB-ACCT -> GLM-SUB-ACCOUNT
Salesrep1 SALESREP Required
COL-COMPANY -> SAW-COMPANY
COL-SALESMAN -> SAW-SALESMAN
Salesrep2 SALESREP Required
When COL-SALESMAN-2 != Zeroes
COL-COMPANY -> SAW-COMPANY
COL-SALESMAN-2 -> SAW-SALESMAN
Shipto SHIPTO Required
When COL-CUST-SHIP-TO != Zeroes
COL-COMPANY -> SHP-COMPANY
COL-CUSTOMER -> SHP-CUSTOMER
COL-CUST-SHIP-TO -> SHP-SHIP-TO
Teritory TERITORY Required
COL-COMPANY -> TRY-COMPANY
COL-TERRITORY -> TRY-TERRITORY
Txtaxcode TXTAXCODE Required
When COL-TAX-CODE > Spaces
COL-COMPANY -> TAC-COMPANY
COL-TAX-CODE -> TAC-TAX-CODE
Whdemndhdr WHDEMNDHDR Not Required
COL-COMPANY -> WDH-COMPANY
"OE" -> WDH-SYSTEM-CD
COL-ORDER-NBR -> WDH-DOC-NBR-NUM
COLINE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Comisc COMISC
COL-COMPANY -> CMC-COMPANY
COL-ORDER-NBR -> CMC-ORDER-NBR
COL-LINE-NBR -> CMC-LINE-NBR
CMC-SEQ
Companions ITEMSUB
ICC-ITEM-GROUP -> ITS-ITEM-GROUP
COL-ITEM -> ITS-ITEM
"C" -> ITS-SUBTYPE
ITS-SUB-ITEM
Component COMPONENT
Valid When COL-KIT-FL = "O"
ICC-ITEM-GROUP -> COM-ITEM-GROUP
COL-COMPANY -> COM-COMPANY
COL-INV-LOC -> COM-LOCATION
COL-ITEM -> COM-KIT-ITEM
COM-SEQ
COM-OPT-SEQ
Components COMPONENT
ICC-ITEM-GROUP -> COM-ITEM-GROUP
COL-COMPANY -> COM-COMPANY
COL-INV-LOC -> COM-LOCATION
COL-ITEM -> COM-KIT-ITEM
COM-SEQ
COM-OPT-SEQ
Itemcompanion ITEMSUB
ICC-ITEM-GROUP -> ITS-ITEM-GROUP
COL-ITEM -> ITS-ITEM
"C" -> ITS-SUBTYPE
ITS-SUB-ITEM
Itemloc ITEMLOC Required
When COL-LINE-TYPE = "I"
COL-COMPANY -> ITL-COMPANY
COL-ITEM -> ITL-ITEM
ITL-LOCATION
Itemsub ITEMSUB
ICC-ITEM-GROUP -> ITS-ITEM-GROUP
COL-ITEM -> ITS-ITEM
"S" -> ITS-SUBTYPE
ITS-SUB-ITEM
Itserial ITSERIAL
COL-COMPANY -> SER-COMPANY
COL-ITEM -> SER-ITEM
SER-SERIAL
Oeaudit OEAUDIT Delete Cascades
COL-COMPANY -> OEA-COMPANY
COL-ORDER-NBR -> OEA-ORDER-NBR
COL-LINE-NBR -> OEA-LINE-NBR
OEA-FLD-NBR
OEA-UPDATE-DATE
OEA-UPDATE-TIME
Oeordcmnt OEORDCMNT
COL-COMPANY -> OOC-COMPANY
Spaces -> OOC-CUSTOMER
Spaces -> OOC-STD-ORDER-NBR
COL-ORDER-NBR -> OOC-ORDER-NBR
COL-LINE-NBR -> OOC-LINE-NBR
OOC-SEQ
Polinesrc POLINESRC
Valid When COL-CREATE-PO = "Y"
COL-COMPANY -> PLS-OPER-COMPANY
"OE" -> PLS-ORIGIN-CD
COL-ORDER-NBR -> PLS-SOURCE-DOC-N
COL-LINE-NBR -> PLS-SRC-LINE-NBR
PLS-PO-CODE
PLS-PO-NUMBER
PLS-PO-RELEASE
PLS-LINE-NBR
Returnline RETURNLINE
COL-COMPANY -> RTL-COMPANY
COL-CUSTOMER -> RTL-CUSTOMER
COL-ITEM -> RTL-ITEM
COL-CUST-SHIP-TO -> RTL-SHIP-TO
RTL-DATE
RTL-AUTH-NO
RTL-LINE-NBR
Sohbins SOHDETAIL
COL-COMPANY -> SDT-COMPANY
COL-INV-LOC -> SDT-LOCATION
COL-ITEM -> SDT-ITEM
SDT-BIN
SDT-UOM
SDT-LOT
SDT-SUBLOT
Sohdetail SOHDETAIL
COL-COMPANY -> SDT-COMPANY
COL-INV-LOC -> SDT-LOCATION
COL-ITEM -> SDT-ITEM
SDT-UOM
SDT-LOT
SDT-SUBLOT
SDT-BIN
Substitutions ITEMSUB
ICC-ITEM-GROUP -> ITS-ITEM-GROUP
COL-ITEM -> ITS-ITEM
"S" -> ITS-SUBTYPE
ITS-SUB-ITEM
Vendor Company ICLOCATION
COL-VENDOR -> ICL-VENDOR
COL-PURCH-FR-LOC -> ICL-PURCH-FR-LOC
Zeroes -> ICL-COMPANY
ICL-LOCATION
Whdemand WHDEMAND
COL-COMPANY -> WDM-COMPANY
"OE" -> WDM-SYSTEM-CD
WDH-DOC-NBR -> WDM-DOC-NBR
COL-LINE-NBR -> WDM-LINE-NBR
Zeroes -> WDM-COMPONENT-SEQ
WDM-LOCATION
Whshipline WHSHIPLINE
COL-COMPANY -> WHL-COMPANY
"OE" -> WHL-SYSTEM-CD
WDH-DOC-NBR -> WHL-DOC-NBR
COL-LINE-NBR -> WHL-LINE-NBR
WHL-SHIPMENT-NBR
Whshipment WHSHIPMENT
COL-COMPANY -> WHS-COMPANY
COL-INV-LOC -> WHS-LOCATION
COL-ORDER-NBR-A -> WHS-DOC-NBR
WHS-SHIPMENT-NBR
|