Lawson Insight Technical Documentation |
|
CUSTORDER
CUSTORDER FILE
Customer Order File
This file contains a record for every order entered in the Lawson Order Entry
system. This is the order header record for which any lines on the order are
kept in the Customer Order Line file.
REFERENCED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 AR21.6 AR21.1 AR21.2 AR21.3
BL00.1 BL121 BL123 BL291 BL80.1 BL80.4
BL91.1 CXCP.1 IC28.1 IC83.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 OE116 OE12.1 OE210 OE229 OE270
OE280 OE281 OE282 OE283 OE284 OE286
OE287 OE288 OE289 OE290 OE293 OE80.1
OE80.3 OE80.2 OE80.6 OE80.4 OE80.5 OE81.1
OE81.2 OE88.1 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 RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ500
RQIF.1 WH110 WH120 WH126 WH140 WH21.1
WH21.2 WH21.3 WH21.4 WH210 WH22.1 WH222
WH224 WH25.1 WH25.2 WO120 WO131 WO132
WO133 WO140 WO20.1 WO30.1 WO32.1 WO32.2
WO32.3 WO32.4 WO32.5 WO40.1 WO40.2 WO40.3
WO40.4 WO40.5 WO41.1 WO41.2 WO41.3 WO41.4
WO42.1 WO42.2 WO42.3 WO42.4 WO42.5 WO45.1
WOEX.1 WOSP.1 AR08.1 AR10.1 AR501 AR550
BL02.1 OE291 OE292 OE53.1 AR115 AR124
AR20.1 AR24.1 AR30.1 AR34.1 AR570 AR575
AR580 CB191
UPDATED BY
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
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.2 OE11.4
OE11.8 OE11.9 OE110 OE111 OE112 OE113
OE114 OE129 OE13.2 OE13.3 OE13.5 OE14.4
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE310 OE510 OE530 OE810
OE830 OE90.1 SA100 SA101 WH130 WH132
WH190 WH20.7 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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
COR-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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-STATUS Numeric 1 BL120 BL122
Element: Status This field contains the status of the BL130 BL20.1
order. BL20.3 BL21.2
1 = Unreleased BL21.5 BL29.1
2 = Released BL29.2 BL520
8 = Canceled BL820 BL92.1
9 = Ready for purge 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-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. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-ORDER-TYPE Alpha 2 BL120 BL122
Element: Order Type CodThis field contains the order type. 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-ORDER-DATE Numeric 8 (yyyymmdd) BL120 BL122
Element: Date This field contains the date of the BL130 BL20.1
order. The system date defaults. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-PRICE-DATE Numeric 8 (yyyymmdd) BL120 BL122
Element: Date This field contains the pricing basis BL130 BL20.1
date. If left blank, each line when BL20.3 BL21.2
added defaults to the system date. The BL21.5 BL29.1
price date is tied to the price list. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-OPR-CODE Alpha 10 (Lower Case) BL120 BL122
Element: Operator Code This field contains the user ID, which BL130 BL20.1
is required for each 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-CHG-OPR Alpha 10 (Lower Case) BL120 BL122
Element: Requester This field contains the user ID of the BL130 BL20.1
last operator to maintain this 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-CRED-OPR Alpha 10 (Lower Case) BL120 BL122
Element: Requester This field contains the user ID of the BL130 BL20.1
person who released the order from BL20.3 BL21.2
credit hold. 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
OE13.3 OE13.5
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
COR-CUST-PO-NBR Alpha 22 BL120 BL122
Element: Customer P.O. This field contains the customer's BL130 BL20.1
purchase order number. If a purchase BL20.3 BL21.2
order number is entered, it updates to BL21.5 BL29.1
the order and any invoices created from BL29.2 BL520
this order. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-LETTER-OF-CR Alpha 20 BL120 BL122
Element: Letter of CredThis field contains the letter of BL130 BL20.1
credit. This value prints on the invoice BL20.3 BL21.2
and, if the order is dropshipped, this BL21.5 BL29.1
field prints on 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-BILL-TO Numeric 4 BL120 BL122
Element: Bill To This field contains the bill-to BL130 BL20.1
customer 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-BILL-NAME Alpha 30 (Lower Case) BL120 BL122
Element: Name This field contains the bill-to BL130 BL20.1
customer's name. This defaults from the BL20.3 BL21.2
customer file, but can be overridden. 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
OE13.3 OE13.5
OE14.4 OE282
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE530
OE810 OE830
WH20.7
COR-BILL-ADDR1 Alpha 30 (Lower Case) BL120 BL122
Element: Address 1 This field contains the first line of BL130 BL20.1
the bill-to customer's address. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-BILL-ADDR2 Alpha 30 (Lower Case) BL120 BL122
Element: Address 1 This field contains the second line of BL130 BL20.1
the bill-to customer's address. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-BILL-ADDR3 Alpha 30 (Lower Case) BL120 BL122
Element: Address 1 This field contains the third line of BL130 BL20.1
the bill-to customer's address. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-BILL-ADDR4 Alpha 30 (Lower Case) BL120 BL122
Element: Address 1 This field contains the fourth line of BL130 BL20.1
the bill-to customer's address. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-BILL-CITY Alpha 18 BL120 BL122
Element: Billing City This field contains the city of the BL130 BL20.1
bill-to customer's address. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-BILL-STATE Alpha 2 BL120 BL122
Element: State or ProviThis field contains the state or BL130 BL20.1
province of the bill-to customer's BL20.3 BL21.2
address. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-BILL-ZIP Alpha 10 BL120 BL122
Element: Postal Code This field contains the postal code of BL130 BL20.1
the bill-to customer's address. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-BILL-CNTRY Alpha 30 (Lower Case) BL120 BL122
Element: Country or OthThis field contains the country of the BL130 BL20.1
bill-to customer's address. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-BILL-COUNTY Alpha 25 (Lower Case) BL120 BL122
Element: County 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-EXP-SHIP-DT Numeric 8 (yyyymmdd) BL120 BL122
Element: Date This field contains the expected ship BL130 BL20.1
date of this order. If left blank and no BL20.3 BL21.2
ship days are defined on this order's BL21.5 BL29.1
process level, the order date defaults. BL29.2 BL520
If ship days exist with the process BL820 BL92.1
level, the ship days are added to the OE10.1 OE10.2
order date to calculate the expected OE10.3 OE10.4
ship date. OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH132
WH20.7 WH222
COR-RQST-DATE Numeric 8 (yyyymmdd) BL120 BL122
Element: Date This field contains the customer's BL130 BL20.1
requested delivery date. If left blank, BL20.3 BL21.2
the system date defaults. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-USER-ID-RLS Alpha 3 BL120 BL122
Element: User Id Entry This field contains the user ID of the BL130 BL20.1
person who released this order. This BL20.3 BL21.2
field is only used if the order is BL21.5 BL29.1
entered using the Customer Entry of BL29.2 BL520
OE15. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-USER-ID-ENTRY Alpha 3 BL120 BL122
Element: User Id Entry This field contains the user ID of the BL130 BL20.1
person who entered this order at the BL20.3 BL21.2
customer's site. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-TAX-EXEMPT-CD Alpha 1 BL120 BL122
Element: Tax Exempt CodThis field contains the tax exempt BL130 BL20.1
code. If the order header is tax exempt, BL20.3 BL21.2
all order lines are tax exempt. If the BL21.5 BL29.1
order is taxable, you can override the BL29.2 BL520
taxable status of individual lines. If BL820 BL92.1
lines on the order are taxable, then the OE10.1 OE10.2
order header must be taxable. If either OE10.3 OE10.4
the customer or the item(s) involved OE10.5 OE10.6
with the order are exempt then the OE10.7 OE10.8
entire order is exempt. OE11.1 OE11.4
E = Exempt OE11.8 OE11.9
T = Taxable OE110 OE111
OE113 OE114
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-SHIP-TO Numeric 4 BL120 BL122
Element: Ship-to Code This field contains the ship-to BL130 BL20.1
customer's 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-SHIP-TO-NAME Alpha 30 (Lower Case) BL120 BL122
Element: Name This field contains the name of BL130 BL20.1
the-ship-to 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-SHIP-TO-ADDR1 Alpha 30 (Lower Case) BL120 BL122
Element: Address 1 This field contains the first line of BL130 BL20.1
the ship-to customer's address. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-SHIP-TO-ADDR2 Alpha 30 (Lower Case) BL120 BL122
Element: Address 1 This field contains the second line of BL130 BL20.1
the ship-to customer's address. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-SHIP-TO-ADDR3 Alpha 30 (Lower Case) BL120 BL122
Element: Address 1 This field contains the third line of BL130 BL20.1
the ship-to customer's address. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-SHIP-TO-ADDR4 Alpha 30 (Lower Case) BL120 BL122
Element: Address 1 This field contains the fourth line of BL130 BL20.1
the ship-to customer's address. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-SHIP-TO-CITY Alpha 18 BL120 BL122
Element: Billing City This field contains the city of the BL130 BL20.1
ship-to customer's address. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-SHIP-TO-STATE Alpha 2 BL120 BL122
Element: State or ProviThis field contains the state or BL130 BL20.1
province of the ship-to customer's BL20.3 BL21.2
address. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-SHIP-TO-ZIP Alpha 10 BL120 BL122
Element: Postal Code This field contains the postal code of BL130 BL20.1
the ship-to customer's address. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-SHIP-TO-CNTRY Alpha 30 (Lower Case) BL120 BL122
Element: Country or OthThis field contains the country of the BL130 BL20.1
ship-to customer's address. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-SHIP-TO-COUNTY Alpha 25 (Lower Case) BL120 BL122
Element: County 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-HOLD-CODE Alpha 4 BL120 BL122
Element: Hold Code This field contains the hold code. If BL130 BL20.1
this field is not blank, processing for BL20.3 BL21.2
the order is suspended. You can take an BL21.5 BL29.1
order off hold by clearing its hold code BL29.2 BL520
field. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 OE90.1
WH130 WH132
WH190 WH20.7
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
...
COR-HOLD-APR-FL Alpha 1 BL120 BL122
Element: All Flag This field indicates if the hold code BL130 BL20.1
is approved. When a one time credit hold BL20.3 BL21.2
code is removed, this field defaults to BL21.5 BL29.1
Yes, which ensures the order is not BL29.2 BL520
placed on hold. BL820 BL92.1
Y = Yes OE10.1 OE10.2
N = No 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
OE13.3 OE13.5
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
COR-INV-LOCATION Alpha 5 BL120 BL122
Element: Location Code This field contains the location from BL130 BL20.1
which inventory is taken. If the item BL20.3 BL21.2
ordered is nonstock, the inventory BL21.5 BL29.1
location is used for reporting purposes. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-TERRITORY Alpha 4 BL120 BL122
Element: Sales TerritorThis field contains the sales territory BL130 BL20.1
for this order. This defaults from the BL20.3 BL21.2
order's ship-to customer. If no ship-to BL21.5 BL29.1
customer is associated with the order, BL29.2 BL520
this defaults from the customer's file. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-SALESMAN Numeric 4 BL120 BL122
Element: Salesman NumbeThis field contains the primary sales BL130 BL20.1
representative for this order. This BL20.3 BL21.2
defaults from the order's ship-to BL21.5 BL29.1
customer. If no ship-to customer is BL29.2 BL520
associated with the order, this defaults BL820 BL92.1
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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-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
ship-to customer. If no ship-to customer BL29.2 BL520
is associated with the order, this BL820 BL92.1
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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-COMM-SPLIT Percent 5.3 (Percent) BL120 BL122
Commission Split This field contains the commission BL130 BL20.1
Percentage split. This defaults from the customer BL20.3 BL21.2
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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-COMM-RATE-1 Percent 7.5 (Percent) BL120 BL122
Element: Chrg Rate This field contains the commission rate BL130 BL20.1
of the primary sales representative. BL20.3 BL21.2
This defaults from the sales BL21.5 BL29.1
representative's 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-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's 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-CHECK-NBR Numeric 8 BL120 BL122
Element: Payment NumberThis field contains the payment number. BL130 BL20.1
This is only valid with a down payment. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-AUTH-REQUIRED Alpha 1
Element: All Flag Flag indicating that explicit
authorization must be received from
credit card service, prior to resulting
line items being printed on pick list.
Y = Yes
N = No
COR-AUTH-APPROVED Alpha 1
Element: Auth Approved Indicates whether authorization was
approved by credit card service or not.
COR-TERMS-CD Alpha 5 BL120 BL122
Element: Terms Code This field contains the payment terms BL130 BL20.1
code. This defaults from the customer's BL20.3 BL21.2
file. Terms codes are set up in the BL21.5 BL29.1
Terms 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-BANK-INST-CODE Alpha 3 BL120 BL122
Element: Transaction CoA transaction code represents a type of BL130 BL20.1
cash payment, bill of exchange payment, BL20.3 BL21.2
or bank service transaction. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-COD-FL Alpha 1 BL120 BL121
Element: All Flag This field indicates if COD (Cash On BL122 BL130
Delivery) orders are accepted. This BL20.1 BL20.3
defaults to Yes if the terms code BL21.2 BL21.5
specifies COD orders. BL29.1 BL29.2
Y = Yes BL520 BL820
N = No BL91.1 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-CIA-FL Alpha 1 BL120 BL122
Element: Cash In AdvancThis field indicates that a down BL130 BL20.1
payment is needed for the order to be BL20.3 BL21.2
released. The required down payment BL21.5 BL29.1
amount is a percentage of the total BL29.2 BL520
order amount. BL820 BL92.1
Y = Yes OE10.1 OE10.2
N = No 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-CIA-PCT Percent 8.5 (Percent) BL120 BL122
Cash In Advance This field contains the cash in advance BL130 BL20.1
Percent percentage, which is used to determine BL20.3 BL21.2
the down payment amount of the total BL21.5 BL29.1
order value. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-ORD-DISC-CODE Alpha 4 BL120 BL122
Element: Order DiscountThis field contains the order discount BL130 BL20.1
code. If left blank, this defaults from BL20.3 BL21.2
the customer's file. Discounts based on BL21.5 BL29.1
the total value of the order. BL29.2 BL520
Order Discount Codes are set up on BL820 BL92.1
OE59.1 (Order Discount Code). The order OE10.1 OE10.2
discount and any add-on discounts are OE10.3 OE10.4
printed on the invoices following the OE10.5 OE10.6
line items. OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-PCT Percent 5.2 (Percent) BL120 BL122
Element: Percent This field contains the order discount BL130 BL20.1
percent for which this order qualifies BL20.3 BL21.2
based on the total value of the order. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-ENTERED-PMNT Signed 18.2 BL120 BL122
Element: Intl Amt This field contains the down payment BL130 BL20.1
amount entered in the order's 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-MULT-PMNT Derived
Element: Mult Pmnt This field indicates what the base
payment amount is if a multiplier is
used when converting the payment from
foreign to base currency.
COR-DIV-PMNT Derived
Element: Div Pmnt This field indicates what the base
payment amount is if a divider is used
when converting the payment from foreign
to company base currency.
COR-PMNT-BASE Derived
Element: Pmnt Base This field contains the amount of the
payment in the company base currency.
COR-NET-DUE-CURR Derived
Element: Net Due Curr This field contains the total amount of
the order minus the down payment valued
in the order's original currency.
COR-NET-DUE-BASE Derived
Element: Net Due Base This field contains the total amount in
company base currency of the order minus
the down payment.
COR-PMNT-INVCED Signed 18.2 BL120 BL122
Element: Intl Amt This field contains the amount of BL130 BL20.1
payment that has been printed on BL20.3 BL21.2
invoices for this order. Once the BL21.5 BL29.1
invoice has been printed, the payment BL29.2 BL520
amount cannot be changed below the BL820 BL92.1
original value. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-ENTERED-DISC Signed 18.2 BL120 BL122
Element: Intl Amt This field contains the additional BL130 BL20.1
discount amount entered on the order in BL20.3 BL21.2
the original currency in which the order BL21.5 BL29.1
was placed. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-MULT-DISC Derived
Element: Mult Disc This field contains the base discount
amount if a multiplier is used in its
conversion.
COR-DIV-DISC Derived
Element: Div Disc This field contains the base discount
amount if a divider is used in its
conversion.
COR-DISC-BASE Derived
Element: Disc Base This field contains the amount of the
discount in the company's base currency.
COR-DISC-TKN-CURR Signed 18.2 BL120 BL122
Element: Intl Amt This field contains the amount of BL130 BL20.1
additional discount that has been taken BL20.3 BL21.2
on invoices for this order. This can be BL21.5 BL29.1
different from the total order discount BL29.2 BL520
if partial shipments are invoiced for BL820 BL92.1
the 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-MULT-DISC-TKN Derived
Element: Mult Disc Tkn This field contains the amount of
additional discounts for this order in
base currency if a multiplier is used
when converting the discount amount.
COR-DIV-DISC-TKN Derived
Element: Div Disc Tkn This field contains the amount of the
additional discount taken from the order
in the base currency if a divider is
used when converting the discount.
COR-DISC-TKN-BASE Derived
Element: Disc Tkn Base This field contains the amount of the
additional discount taken on invoices of
the order in the company base currency.
COR-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. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-TAX-DATE Numeric 8 (yyyymmdd) BL120 BL122
Element: Date This field contains the tax point date. BL130 BL20.1
This is only used if you are overriding BL20.3 BL21.2
the normal tax point date. This is the BL21.5 BL29.1
source of the invoice's tax point date BL29.2 BL520
only if this field is not equal to zero. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-ORDER-SOURCE Alpha 2 BL120 BL122
Element: Order Source This field contains the order source BL130 BL20.1
code that indicates the reason the BL20.3 BL21.2
customer gave for placing the order. BL21.5 BL29.1
Order source codes are set up in OE52.1 BL29.2 BL520
(Order Source). 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-FREIGHT-CODE Alpha 2 BL120 BL122
Element: Freight Code This field contains the freight code, BL130 BL20.1
which determines if carrier and freight BL20.3 BL21.2
charges are assessed on the shipment. BL21.5 BL29.1
Freight codes are defined in BL12.1 BL29.2 BL520
(Freight Codes). A freight code can be BL80.1 BL820
added to the customer's file as a BL92.1 OE10.1
default, or it can be added at order OE10.2 OE10.3
entry time. 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 OE13.3
OE13.5 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 WH32.2
...
COR-FRT-CHG-CURR Signed 18.2 BL120 BL122
Element: Intl Amt This field contains the freight charge BL130 BL20.1
amount 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
OE129 OE13.2
OE13.3 OE13.5
OE14.1 OE14.4
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE530
OE80.1 OE80.2
OE80.3 OE80.4
OE80.5 OE810
OE830 WH20.7
COR-FRT-TAXABLE-FL Alpha 1 BL120 BL122
Element: All Flag Select Yes if freight is taxable. BL130 BL20.1
Y = Yes BL20.3 BL21.2
N = No 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-MULT-FRT-CHG Derived
Element: Mult Frt Chg This field contains the freight charge
amount in the base currency if a
multiplier is in the conversion from
original to base currency.
COR-DIV-FRT-CHG Derived
Element: Div Frt Chg This field contains the base amount of
the freight charge if a divider is used
in the conversion from original to base
currency.
COR-FRT-CHG-BASE Derived
Element: Frt Chg Base This field contains the freight charge
amount in base currency.
COR-ACTUAL-FRT-CHG Signed 18.2 BL120 BL122
Element: Intl Amt The actual freight charges to-date in BL130 BL20.1
GL company base currency. BL20.3 BL21.2
BL21.5 BL29.1
Sourced from: BL29.2 BL520
1). All freight that has been paid by BL820 BL92.1
the AP system involving a drop-ship OE10.1 OE10.2
customer order originating from OE. In OE10.3 OE10.4
this case, the Actual-Frt-Chg is updated OE10.5 OE10.6
by OE129. OE10.7 OE10.8
OE11.1 OE11.4
2). All freight billed to a customer OE11.8 OE11.9
excluding drop-ship freight. Updated by OE110 OE111
OE129. OE113 OE114
OE129 OE13.2
OE13.3 OE13.5
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
WH32.2 WH32.3
...
COR-MULT-A-FRT-CHG Derived
Element: Mult A Frt Chg
COR-DIV-A-FRT-CHG Derived
Element: Div A Frt Chg
COR-ACTUAL-FR-CH-B Derived
Element: Actual Fr Ch B
COR-CARRIER Alpha 9 (Right Justified) BL120 BL122
Element: Vendor ID This field contains the carrier vendor BL130 BL20.1
number. Vendors are set up in the BL20.3 BL21.2
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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-METHOD Alpha 10 BL120 BL122
Element: Method Code User-defined shipping method. Shipping BL130 BL20.1
methods are set up in the Order Entry BL20.3 BL21.2
system. The shipping method will print BL21.5 BL29.1
on order acknowledgments, packing lists, BL29.2 BL520
and invoices. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-TRANS-ID Alpha 20 BL120 BL122
Element: Trans Id This field contains the transportation BL130 BL20.1
ID, which is a user-definable field form BL20.3 BL21.2
that prints on invoices and bills of BL21.5 BL29.1
lading. This field is not validated. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-LIST-NAME Alpha 14 BL120 BL122
Element: List Name This field contains the customer's BL130 BL20.1
price list. This defaults from the BL20.3 BL21.2
customer's price list when the order is BL21.5 BL29.1
entered. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-PK-PRIORITY Numeric 2 BL120 BL122
Element: Picking PrioriThis field contains the picking BL130 BL20.1
priority, which defaults from the BL20.3 BL21.2
customer's file. WH110 (Batch BL21.5 BL29.1
Allocation) uses this as a priority when BL29.2 BL520
assigning inventory to orders. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-IMMEDIATE-FL Alpha 1 BL120 BL122
Element: All Flag This field indicates that this order BL130 BL20.1
should be delivered on the next run of BL20.3 BL21.2
route construction regardless of the BL21.5 BL29.1
routes being delivered today. 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-EDI-OE-FLAG Alpha 1 BL120 BL122
Element: All Flag This field contains the EDI flag, which BL130 BL20.1
is set on if this order was created by BL20.3 BL21.2
the EDI interface. 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-ACKNWLDG-FL Alpha 1 BL120 BL122
Element: All Flag This field indicates whether a printed BL130 BL20.1
acknowledgment is required for this BL20.3 BL21.2
order. This defaults from the customer's BL21.5 BL29.1
file. BL29.2 BL520
N = No BL820 BL92.1
Y = Yes 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-ACK-PRT-FL Alpha 1 BL120 BL122
Element: All Flag This field indicates if an BL130 BL20.1
acknowledgment was printed to avoid BL20.3 BL21.2
duplicate printing of the document. 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
OE112 OE113
OE114 OE129
OE13.2 OE13.3
OE13.5 OE14.4
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE530
OE810 OE830
WH20.7
COR-BACK-ORD-FL Alpha 1 BL120 BL122
Backorders Allowed This field indicates if backorders are BL130 BL20.1
Flag allowed. If No, an order cannot be BL20.3 BL21.2
placed for items that do not have BL21.5 BL29.1
sufficient stock to be allocated to BL29.2 BL520
them. This is only valid for companies BL820 BL92.1
that use online allocation. This OE10.1 OE10.2
defaults from the customer's file. OE10.3 OE10.4
N = No OE10.5 OE10.6
Y = Yes OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-SHIP-COMP-FL Alpha 1 BL120 BL122
Element: Ship Comp Fl This field indicates whether partial BL130 BL20.1
shipments are allowed. This defaults BL20.3 BL21.2
from the customer's file. BL21.5 BL29.1
N = No BL29.2 BL520
Y = Yes BL820 BL92.1
" " = Determined by Line 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-CREDIT-WF-FL Alpha 1 BL92.1 OE114
Element: All Flag This field indicates that this order on WH130 WH132
hold has passed to the Workflow WH190 WH30.1
Management system. WH30.2 WH30.3
Y = Yes WH30.4 WH31.1
N = No WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
COR-ACTIVITY Alpha 15 BL120 BL122
Element: Activity In this file the Activity field is used BL130 BL20.1
for revenue (sales) postings whereas the BL20.3 BL21.2
Activity-C field is used for Cost (COGS) BL21.5 BL29.1
postings. BL29.2 BL520
BL820 BL92.1
Activities are the processes or OE10.1 OE10.2
procedures that produce work. Cost OE10.3 OE10.4
objects (products, services, customers, OE10.5 OE10.6
and so on) are the reasons for OE10.7 OE10.8
performing the activity. Activities and OE11.1 OE11.4
cost object activities are used OE11.8 OE11.9
synonymously in the Activity Management OE110 OE111
system. Direct costs are posted to OE113 OE114
activities, and indirect costs are OE129 OE13.2
allocated to activities based on OE13.3 OE13.5
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.
COR-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, OE129 OE13.2
account, and subaccount) that make up OE13.3 OE13.5
the transactions posted to an account OE14.4 OE30.1
category using AC07.1 (Account OE30.2 OE30.3
Assignment). OE30.4 OE30.5
OE30.6 OE30.7
Period-to-date, year-to-date, and OE30.9 OE510
life-to-date balances are maintained by OE530 OE810
account category for activities. Account OE830 WH20.7
categories must be assigned to
activities before you do any budgeting
or transaction processing.
COR-ACTIVITY-C Alpha 15 BL120 BL122
Element: Activity In this file the Activity-C field is BL130 BL20.1
used for Cost (COGS) postings whereas BL20.3 BL21.2
the Activity field is used for revenue BL21.5 BL29.1
(sales) postings. BL29.2 BL520
BL820 BL92.1
Activities are the processes or OE10.1 OE10.2
procedures that produce work. Cost OE10.3 OE10.4
objects (products, services, customers, OE10.5 OE10.6
and so on) are the reasons for OE10.7 OE10.8
performing the activity. Activities and OE11.1 OE11.4
cost object activities are used OE11.8 OE11.9
synonymously in the Activity Management OE110 OE111
system. Direct costs are posted to OE113 OE114
activities, and indirect costs are OE129 OE13.2
allocated to activities based on OE13.3 OE13.5
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.
COR-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, OE129 OE13.2
account, and subaccount) that make up OE13.3 OE13.5
the transactions posted to an account OE14.4 OE30.1
category using AC07.1 (Account OE30.2 OE30.3
Assignment). OE30.4 OE30.5
OE30.6 OE30.7
Period-to-date, year-to-date, and OE30.9 OE510
life-to-date balances are maintained by OE530 OE810
account category for activities. Account OE830 WH20.7
categories must be assigned to
activities before you do any budgeting
or transaction processing.
COR-USER-DATE-1 Numeric 8 (yyyymmdd) BL120 BL122
Element: Date This field contains the first BL130 BL20.1
user-definable date. This is used by BL20.3 BL21.2
OE280 (Open Orders By Customer). 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-USER-DATE-2 Numeric 8 (yyyymmdd) BL120 BL122
Element: Date This field contains the second BL130 BL20.1
user-definable date. This is used by BL20.3 BL21.2
OE280 (Open Orders By Customer). 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-TRANS-USER1 Alpha 10 BL120 BL122
Element: Trans User1 This field contains the first BL130 BL20.1
user-definable transaction field. This BL20.3 BL21.2
field can be used in the Accounts BL21.5 BL29.1
Receivable system as a sort option BL29.2 BL520
during cash application and select BL820 BL92.1
criteria for the aged trial balance. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-TRANS-USER2 Alpha 15 BL120 BL122
Element: Agent This field contains the second BL130 BL20.1
user-definable transaction field. This BL20.3 BL21.2
updates on the invoice in the Accounts BL21.5 BL29.1
Receivable system 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-TRANS-USER3 Numeric 8 (yyyymmdd) BL120 BL122
Element: Trans User3 This field contains the third BL130 BL20.1
user-definable transaction field. This BL20.3 BL21.2
updates on the invoice in the Accounts BL21.5 BL29.1
Receivable system 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-TRANS-USER4 Numeric 9 BL120 BL122
Element: Trans User4 This field contains the fourth BL130 BL20.1
user-definable transaction field. This BL20.3 BL21.2
updates on the invoice in the Accounts BL21.5 BL29.1
Receivable system 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-TRANS-USER5 Signed 18.2 BL120 BL122
Element: Intl Amt This field contains the fifth BL130 BL20.1
user-definable transaction field. This BL20.3 BL21.2
updates on the invoice in the Accounts BL21.5 BL29.1
Receivable system 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-CUBIC-FEET Signed 9.3 BL120 BL122
Element: Cubic Feet This field contains the total cubic BL130 BL20.1
feet of the items comprising this 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-WEIGHT Signed 9.3 BL120 BL122
Element: Unit Weight This field contains the total weight of BL130 BL20.1
this 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-LAST-LINE-NBR Numeric 6 BL120 BL122
Element: Line Number This field contains the number of the BL130 BL20.1
last line item added to 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-LAST-TP-SEQ Numeric 3 BL120 BL122
Element: Sequence NumbeThis field contains the last sequence BL130 BL20.1
number used for top comments. BL20.3 BL21.2
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.2 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-LAST-BM-SEQ Numeric 3 BL120 BL122
Element: Sequence NumbeThis field contains the last sequence BL130 BL20.1
number used for bottom comments. BL20.3 BL21.2
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.2 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-LAST-MISC-SEQ Numeric 3 BL120 BL122
Element: Sequence NumbeThis field contains the last sequence BL130 BL20.1
number used for add-on charges. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-SHIPMENT-NBR Numeric 10 BL120 BL122
Element: Shipment NumbeThis field contains the last shipment BL130 BL20.1
number used for this 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
OE129 OE13.2
OE13.3 OE13.5
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
WH32.2 WH32.3
...
COR-LST-IF-REF-NBR Numeric 6 BL120 BL122
Element: Lst If Ref NbrThis field contains an internally BL130 BL20.1
generated reference number used by the BL20.3 BL21.2
Requisitions 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-SLS-QUOTE-FL Alpha 1 BL120 BL122
Element: All Flag This field indicates if the order is a BL130 BL20.1
quote. Quotes cannot be released and BL20.3 BL21.2
have no effect on inventory. They can be BL21.5 BL29.1
changed to regular orders and BL29.2 BL520
subsequently processed. BL820 BL92.1
Y = Yes OE10.1 OE10.2
N = No 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-FUTURE-FL Alpha 1 BL120 BL122
Element: Future Order FThis field contains the future flag, BL130 BL20.1
which defaults to No. If set to Yes, BL20.3 BL21.2
future lines do not have inventory BL21.5 BL29.1
allocated to them until it is necessary BL29.2 BL520
to meet the customer's requested BL820 BL92.1
delivery date. 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-PK-PRT-FL Alpha 1 BL120 BL122
Element: All Flag This field indicates whether a picking BL130 BL20.1
list has been printed for this order. BL20.3 BL21.2
N = No BL21.5 BL29.1
Y = Yes 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-POD-REQ-FL Alpha 1 BL120 BL122
Element: Pod Req Fl This field indicates that a POD (Proof BL130 BL20.1
of Delivery) is required. Indicates BL20.3 BL21.2
whether this customer's ship-to requires BL21.5 BL29.1
a POD form to accompany the shipment. BL29.2 BL520
The shipment is not billed until the POD BL820 BL92.1
is returned or the POD grace period OE10.1 OE10.2
expires. OE10.3 OE10.4
N = No OE10.5 OE10.6
Y = Yes OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-POD-GRACE-PER Numeric 3 BL120 BL122
Element: Age Periods This field contains the number of days BL130 BL20.1
from the shipment date after which POD BL20.3 BL21.2
shipments are automatically billed even BL21.5 BL29.1
if the POD is not returned. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-CXL-DATE Numeric 8 (yyyymmdd) BL120 BL122
Element: Date This field contains the date the order 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-CXL-OPR Alpha 10 (Lower Case) BL120 BL122
Element: Requester This field contains the user ID of the BL130 BL20.1
person who canceled 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-CXL-REASON Alpha 4 BL120 BL122
Element: Cb Reason This field contains the cancellation BL130 BL20.1
reason code. This is passed to the Sales BL20.3 BL21.2
Analysis system for reporting. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-SA-UPDATED-FL Alpha 1 BL120 BL122
Element: Sa Updated Fl This field indicates if this order has BL130 BL20.1
been booked in the Sales Analysis BL20.3 BL21.2
system. BL21.5 BL29.1
Y = Yes BL29.2 BL520
N = No BL820 BL92.1
C = Change 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
OE13.3 OE13.5
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
COR-CURRENCY-CODE Alpha 5 BL120 BL122
Element: Currency Code This field contains the currency the BL130 BL20.1
customer is to be billed in for this BL20.3 BL21.2
order. This defaults from the customer's BL21.5 BL29.1
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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-CURR-MUDV Alpha 1 BL120 BL122
Currency This field indicates whether the BL130 BL20.1
Multiply/Divide conversion from base to the billing BL20.3 BL21.2
currency is accomplished using a BL21.5 BL29.1
multiplier or divider. BL29.2 BL520
M = Multiply BL820 BL92.1
D = Divide 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-CURR-RATE Signed 14.7 BL120 BL122
Element: Currency Rate This field contains the currency BL130 BL20.1
conversion rate to 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-CURR-ND Numeric 1 BL120 BL122
Account Currency This field contains the number of BL130 BL20.1
Code decimals for the 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.2
WH20.7
COR-CURR-OVR-FL Alpha 1
Element: All Flag This field indicates whether you can
override the currency for transactions
on the customer's account.
Y = Yes
N = No
COR-RATE-FRZ-CD Alpha 1 BL120 BL122
Element: Rate Frz Cd This field contains the code indicating BL130 BL20.1
when the currency conversion rate is BL20.3 BL21.2
frozen for this order. BL21.5 BL29.1
O = Order BL29.2 BL520
I = Invoice BL820 BL92.1
P = Payment 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-OPEN-ORD-AMT Signed 18.2 BL120 BL122
Element: Intl Amt This field contains the total amount of BL130 BL20.1
the open order added to the customer's BL20.3 BL21.2
open order total from the customer's BL21.5 BL29.1
file in tran 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
OE129 OE13.2
OE13.3 OE13.5
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 WH520
WH830
COR-OPEN-ORD-CURR Signed 18.2 BL120 BL122
Element: Intl Amt This field contains the total amount of BL130 BL20.1
the open order added to the customer's BL20.3 BL21.2
open order total from the customer's BL21.5 BL29.1
file in base 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-PASS-ORD-AMT Signed 18.2 BL120 BL122
Element: Intl Amt This field contains the amount of the BL130 BL20.1
open order that was subtracted from the BL20.3 BL21.2
customer's open order total by invoices BL21.5 BL29.1
that have been created for this 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-INV-GDS-CURR Signed 18.2 BL120 BL122
Element: Intl Amt This field contains the amount of BL130 BL20.1
inventoried goods for this order in BL20.3 BL21.2
billing currency. 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
OE13.3 OE13.5
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 WH520
WH830
COR-INV-GDS-BASE Signed 18.2 BL120 BL122
Element: Intl Amt This field contains the amount of BL130 BL20.1
inventoried goods for this order in base BL20.3 BL21.2
currency. 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
OE13.3 OE13.5
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 WH520
WH830
COR-NI-GDS-CURR Signed 18.2 BL120 BL122
Element: Intl Amt This field contains the amount of BL130 BL20.1
non-inventoried goods for this order in BL20.3 BL21.2
billing currency. These could be either BL21.5 BL29.1
nonstock or special items. 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
OE13.3 OE13.5
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 WH520
WH830
COR-NI-GDS-BASE Signed 18.2 BL120 BL122
Element: Intl Amt This field contains the amount of BL130 BL20.1
non-inventoried goods for this order in BL20.3 BL21.2
base currency. These can be either BL21.5 BL29.1
nonstock or special items. 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
OE13.3 OE13.5
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 WH520
WH830
COR-GDS-TTL-CURR Derived
Element: Gds Ttl Curr This field contains the total goods
amount for this order in billing
currency.
COR-GDS-TTL-BASE Derived
Element: Gds Ttl Base This field contains the total goods
amount for this order in base currency.
COR-MISC-TTL-CURR Signed 18.2 BL120 BL122
Element: Intl Amt This field contains the total of add-on BL130 BL20.1
charges for this order in billing BL20.3 BL21.2
currency. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-MULT-MISC-TTL Derived
Element: Mult Misc Ttl This field contains the total of add-on
charges in base currency if a multiplier
is used in the conversion from original
to base amount.
COR-DIV-MISC-TTL Derived
Element: Div Misc Ttl This field contains the total amount of
add-on charges in base currency if a
divider is used in the conversion from
original to base currency.
COR-MISC-TTL-BASE Derived
Element: Misc Ttl Base This field contains the total amount of
add-on charges in base currency.
COR-DISCNTBL-CURR Signed 18.2 BL120 BL122
Element: Intl Amt This field contains the total BL130 BL20.1
discountable amount for this order in BL20.3 BL21.2
billing currency. This amount is used to BL21.5 BL29.1
compute the order discount amount. 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
OE13.3 OE13.5
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 WH520
WH830
COR-MULT-DISCNTBL Derived
Element: Mult Discntbl This field contains the total
discountable amount for this order in
base currency if the conversion from
original to base currency is
accomplished using a multiplier.
COR-DIV-DISCNTBL Derived
Element: Div Discntbl This field contains the total
discountable amount of the order in base
currency if a divider is used in the
conversion from original to base
currency.
COR-DISCNTBL-BASE Derived
Element: Discntbl Base This field contains the total
discountable amount of the order in base
currency.
COR-ORD-DISC-CURR Signed 18.2 BL120 BL122
Element: Intl Amt This field contains the discount for BL130 BL20.1
this order in billing currency. Order BL20.3 BL21.2
discounts are calculated using the BL21.5 BL29.1
discount codes set up on OE59.1 (Order BL29.2 BL520
Discount Code) that are assigned to the BL820 BL92.1
customer's record. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-MULT-ORD-DISC Derived
Element: Mult Ord Disc This field contains the order discount
for this order in base currency if a
multiplier is used in the conversion
from original to base currency.
COR-DIV-ORD-DISC Derived
Element: Div Ord Disc This field contains the total order
discount amount for this order if a
divider is used in the conversion from
original to base currency.
COR-ORD-DISC-BASE Derived
Element: Ord Disc Base This field contains the total amount of
the order discount in the company base
currency.
COR-TXBL-TTL-CURR Signed 18.2 BL120 BL122
Element: Intl Amt This field contains the taxable amount BL130 BL20.1
for this order 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-MULT-TXBL-TTL Derived
Element: Mult Txbl Ttl This field contains the taxable amount
for this order in base currency if a
multiplier is used in the conversion
from original to base currency.
COR-DIV-TXBL-TTL Derived
Element: Div Txbl Ttl This field contains the taxable amount
for this order in base currency if a
divider is used in the conversion from
original to base currency.
COR-TXBL-TTL-BASE Derived
Element: Txbl Ttl Base This field contains the taxable amount
for this order in the company base
currency.
COR-TAX-TTL-CURR Signed 18.2 BL120 BL122
Element: Intl Amt This field contains the total amount of BL130 BL20.1
tax on the order in original billing BL20.3 BL21.2
currency. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-MULT-TAX-TTL Derived
Element: Mult Tax Ttl This field contains the total amount of
tax on the order in base currency if a
multiplier is used in the conversion
from original to base currency.
COR-DIV-TAX-TTL Derived
Element: Div Tax Ttl This field contains the total amount of
tax on the order in base currency if a
divider is used in the conversion from
original to base currency.
COR-TAX-TTL-BASE Derived
Element: Tax Ttl Base This field contains the total amount of
tax on the order in base currency.
COR-ORD-GRS-BASE Derived
Element: Ord Grs Base This field contains the total gross
amount of the order in base currency.
COR-ORD-GRS-CURR Derived
Element: Ord Grs Curr This field contains the total gross
amount of the order in original billing
currency.
COR-ORDER-NET Derived
Element: Order Net This field contains the total of line
net amounts plus add-on charges minus
order discounts.
COR-ORD-NET-BASE Derived
Element: Ord Net Base This field contains the total of line
net amounts and add-on charges minus
order discounts in base currency.
COR-ORD-NET-CURR Derived
Element: Ord Net Curr This field contains the net order,
which is the total of line net amounts
and add-on charges minus the order
discount in the order's original
currency.
COR-HOLD-LIT Derived
Element: Hold Lit This field contains the hold code.
COR-TERMS-1 Derived
Element: Terms 1 This field contains the description of
the first credit card terms table.
COR-TERM-2 Derived
Element: Term 2 This field contains the description of
the second credit card terms table.
COR-ORDER-NBR-A Derived
Element: Order Nbr A This field is used internally to create
relationships.
COR-ORDER-ZERO Derived
Element: Order Zero This field is used internally to create
relationships
COR-COMM-LIT Derived
Element: Comm Lit If comments are attached, this field
displays "comments exist."
COR-WF-CO-ORDR-NBR Derived
Element: Wf Co Ordr Nbr
COR-INTRASTAT-NBR Numeric 12 BL120 BL122
Element: Intrastat Nbr The number assigned by the Intrastat BL130 BL20.1
system to a transaction that involves BL20.3 BL21.2
Intrastat reporting after it has been BL21.5 BL29.1
added. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-BILL-CNTRY-CD Alpha 2 BL120 BL122
Element: Bill Cntry Cd The Bill-To country code; must be BL130 BL20.1
defined in IN01.1 (Country Maintenance). 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-BILL-REGION Alpha 2 BL120 BL122
Element: Bill Region The Bill-To region code. Must be a BL130 BL20.1
valid region for the country, defined in BL20.3 BL21.2
IN02.1 (Region 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-TO-CNTRY-CD Alpha 2 BL120 BL122
Element: To Cntry Cd The Ship-To country code. Must be BL130 BL20.1
defined in IN01.1 (Country BL20.3 BL21.2
Maintenaance). 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-SHIP-TO-REGION Alpha 2 BL120 BL122
Element: Ship To RegionThe ship-to region code. BL130 BL20.1
Must be a valid region for the country, BL20.3 BL21.2
defined in IN02.1 (Region 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-ORDER-REF-NBR Numeric 8
Element: Order Ref Nbr This field contains the order reference
number. This number can be filled with
extra order number information.
COR-REF-NBR-FLAG Alpha 1
Element: Ref Nbr Flag This field contains a flag to indicate
whether the Order reference number is
being used. This could be used to flag
whether we use the order-ref-nbr in
place of our order number.
COR-REQ-EP-AUTH Alpha 1
Element: Req Ep Auth
COR-EP-AMT-CURR Signed 18.2 BL120 BL122
Element: Intl Amt 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-EP-AMT-BASE Signed 18.2 BL120 BL122
Element: Intl Amt 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-EP-SETTLE-AMT Signed 18.2 BL120 BL122
Element: Intl Amt 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-EP-TRANS-ID Numeric 12 BL120 BL122
Element: Ep Trans Id 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-EP-TYPE Alpha 5 BL120 BL122
Element: Ep Type 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-EP-ACCOUNT Alpha 32 BL120 BL122
Element: Ep Account 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-EP-EXP-DATE Numeric 8 (yyyymmdd) BL120 BL122
Element: Ep Exp Date 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-EP-MARGIN-MIN Signed 7.2 BL120 BL122
Element: Ep Margin Min 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-EP-MARGIN-PCT Percent 8.5 (Percent) BL120 BL122
Element: Ep Margin Pct 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-ORDER-TTL-CURR Signed 18.2
Element: Intl Amt
COR-ORDER-TTL-BASE Signed 18.2
Element: Intl Amt
COR-BILL-EC-CTRY Numeric 3 BL120 BL122
Element: Bill Ec Ctry 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-BILL-ISO-CTRY Numeric 3 BL120 BL122
Element: Bill Iso Ctry 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-TO-EC-CTRY Numeric 3 BL120 BL122
Element: To Ec Ctry 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-TO-ISO-CTRY Numeric 3 BL120 BL122
Element: To Iso Ctry 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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-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
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COR-VAT-REG-NBR Alpha 12 BL120 BL122
Element: Vat Reg Nbr The number component of the VAT BL130 BL20.1
Registration Number. This field together BL20.3 BL21.2
with the Registration Country field make BL21.5 BL29.1
up the VAT Registration Number. 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
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CUSTORDER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CORSET1 COMPANY AP125 AP126
ORDER-NBR AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AR21.6 BL00.1
BL120 BL121
BL122 BL123
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL291
BL520 BL80.1
BL80.4 BL820
BL91.1 BL92.1
BLI2.1 CXCP.1
...
CORSET10 COMPANY Subset SA100
ORDER-NBR Where SA-UPDATED-FL != "Y"
And STATUS > 1
CORSET11 COMPANY
ORDER-NBR*
CORSET12 COMPANY
CUSTOMER
ORDER-NBR*
CORSET13 COMPANY
TRANS-USER1
ORDER-NBR*
CORSET2 COMPANY AR08.1 AR10.1
CUSTOMER AR501 AR550
ORDER-NBR BL02.1 BL120
BL122 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
...
CORSET3 COMPANY KeyChange OE229 OE80.6
CUST-PO-NBR OE88.1
ORDER-NBR
CORSET5 COMPANY OE110 OE111
OPR-CODE OE53.1 OE80.4
ORDER-NBR
CORSET6 COMPANY KeyChange, Subset AR115 AR124
CUSTOMER Where HOLD-CODE != Spaces AR20.1 AR21.1
HOLD-CODE AR21.2 AR21.3
ORDER-NBR AR24.1 AR30.1
AR34.1 AR570
AR575 AR580
CB191 OE90.1
CORSET7 COMPANY KeyChange OE286
HOLD-CODE
ORDER-NBR
CORSET8 COMPANY KeyChange OE110 OE111
ORDER-DATE OE283 OE310
ORDER-NBR OE80.5
CORSET9 COMPANY KeyChange
TRANS-USER1
ORDER-NBR
CUSTORDER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
When COR-CARRIER != Spaces
COR-COMPANY -> CPY-COMPANY
Apvenmast APVENMAST Required
When COR-CARRIER != Spaces
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
COR-CARRIER -> VEN-VENDOR
Arcomp ARCOMP Required
COR-COMPANY -> ACO-COMPANY
Arcustomer ARCUSTOMER Required
COR-COMPANY -> ACM-COMPANY
COR-CUSTOMER -> ACM-CUSTOMER
Billto BILLTO Not Required
Valid When COR-BILL-TO != Zeroes
ACO-CUST-GROUP -> ABS-CUST-GROUP
COR-CUSTOMER -> ABS-CUSTOMER
COR-BILL-TO -> ABS-BILL-TO
Cosgblk COSGBLK Not Required
COR-COMPANY -> OSG-COMPANY
COR-ORDER-NBR -> OSG-ORDER-NBR
Zeroes -> OSG-LINE-NBR
Zeroes -> OSG-SEQ
Cucodes CUCODES Required
When COR-CURRENCY-CODE != COR-CURRENCY-CODE
COR-CURRENCY-CODE -> CUC-CURRENCY-CODE
Curelat CURELAT Not Required
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
COR-CUSTOMER -> CUD-CUSTOMER
Cxl Operator OPERATOR Not Required
Valid When COR-CXL-REASON != Spaces
COR-CXL-OPR -> OPE-OPR-CODE
COR-COMPANY -> OPE-DEF-COMPANY
Glsystem GLSYSTEM Required
COR-COMPANY -> GLS-COMPANY
Holdcodes HOLDCODES Required
When COR-HOLD-CODE != Spaces
ACO-CUST-GROUP -> HDD-CUST-GROUP
COR-HOLD-CODE -> HDD-HOLD-CODE
Iccompany ICCOMPANY Required
COR-COMPANY -> ICC-COMPANY
Iclocation ICLOCATION Required
When COR-INV-LOCATION != Spaces
COR-COMPANY -> ICL-COMPANY
COR-INV-LOCATION -> ICL-LOCATION
Oecompany OECOMPANY Required
COR-COMPANY -> OEC-COMPANY
Oecoruf OECORUF Required
COR-COMPANY -> OCU-COMPANY
COR-ORDER-NBR -> OCU-ORDER-NBR
Oecust OECUST Required
COR-COMPANY -> OET-COMPANY
COR-CUSTOMER -> OET-CUSTOMER
Oefrtcode OEFRTCODE Required
When COR-FREIGHT-CODE != Spaces
COR-COMPANY -> OFR-COMPANY
COR-FREIGHT-CODE -> OFR-FRT-CODE
Oemethod OEMETHOD Required
When COR-METHOD != Spaces
COR-COMPANY -> OMT-COMPANY
COR-METHOD -> OMT-METHOD
Oeorddisc OEORDDISC Required
When COR-ORD-DISC-CODE > Spaces
COR-COMPANY -> OOD-COMPANY
COR-ORD-DISC-CODE -> OOD-ORD-DISC-CODE
COR-CURRENCY-CODE -> OOD-CURRENCY-CODE
Oeprclist OEPRCLIST Required
COR-COMPANY -> OPL-COMPANY
Spaces -> OPL-CUSTOMER
COR-LIST-NAME -> OPL-LIST-NAME
Spaces -> OPL-PROMOTION
Oeproclev OEPROCLEV Required
COR-COMPANY -> OEP-COMPANY
COR-PROCESS-LEVEL -> OEP-PROCESS-LEVEL
Oereason OEREASON Required
When COR-CXL-REASON != Spaces
COR-COMPANY -> OER-COMPANY
COR-CXL-REASON -> OER-REASON-CODE
Oesource OESOURCE Required
When COR-ORDER-SOURCE != Spaces
COR-COMPANY -> OSR-COMPANY
COR-ORDER-SOURCE -> OSR-ORDER-SOURCE
Operator OPERATOR Required
COR-COMPANY -> OPE-DEF-COMPANY
COR-OPR-CODE -> OPE-OPR-CODE
Ordertype ORDERTYPE Required
COR-COMPANY -> OTP-COMPANY
COR-ORDER-TYPE -> OTP-ORDER-TYPE
Salesman SALESREP Required
COR-COMPANY -> SAW-COMPANY
COR-SALESMAN -> SAW-SALESMAN
Salesman2 SALESREP Required
When COR-SALESMAN-2 != Zeroes
COR-COMPANY -> SAW-COMPANY
COR-SALESMAN-2 -> SAW-SALESMAN
Shipto SHIPTO Required
When COR-SHIP-TO != Zeroes
COR-COMPANY -> SHP-COMPANY
COR-CUSTOMER -> SHP-CUSTOMER
COR-SHIP-TO -> SHP-SHIP-TO
Teritory TERITORY Required
When COR-TERRITORY != Spaces
COR-COMPANY -> TRY-COMPANY
COR-TERRITORY -> TRY-TERRITORY
Terms TERMS Not Required
COR-TERMS-CD -> TMS-TERMS-CD
Txcodemast TXCODEMAST Not Required
COR-TAX-CODE -> TCM-TAX-CODE
Txtaxcode TXTAXCODE Required
When COR-TAX-CODE != Spaces
COR-COMPANY -> TAC-COMPANY
COR-TAX-CODE -> TAC-TAX-CODE
Whdemndhdr WHDEMNDHDR Not Required
COR-COMPANY -> WDH-COMPANY
"OE" -> WDH-SYSTEM-CD
COR-ORDER-NBR -> WDH-DOC-NBR-NUM
CUSTORDER FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
All Comisc COMISC
COR-COMPANY -> CMC-COMPANY
COR-ORDER-NBR -> CMC-ORDER-NBR
CMC-LINE-NBR
CMC-SEQ
Coline COLINE Delete Restricted
COR-COMPANY -> COL-COMPANY
COR-ORDER-NBR -> COL-ORDER-NBR
COL-LINE-NBR
Comisc COMISC
COR-COMPANY -> CMC-COMPANY
COR-ORDER-NBR -> CMC-ORDER-NBR
Zeroes -> CMC-LINE-NBR
CMC-SEQ
Custorder CUSTORDER
COR-COMPANY -> COR-COMPANY
COR-CUSTOMER -> COR-CUSTOMER
COR-ORDER-NBR
Hdr Comments OEORDCMNT
COR-COMPANY -> OOC-COMPANY
Spaces -> OOC-CUSTOMER
Spaces -> OOC-STD-ORDER-NBR
COR-ORDER-NBR -> OOC-ORDER-NBR
Zeroes -> OOC-LINE-NBR
OOC-SEQ
Icgeneric ICGENERIC
ICC-ITEM-GROUP -> ICG-ITEM-GROUP
ICG-GENERIC
Majorcl MAJORCL
ICC-ITEM-GROUP -> MAJ-ITEM-GROUP
"S" -> MAJ-CLASS-TYPE
MAJ-MAJOR-CLASS
Minorcl MINORCL
ICC-ITEM-GROUP -> MIN-ITEM-GROUP
"S" -> MIN-CLASS-TYPE
MIN-MAJOR-CLASS
MIN-MINOR-CLASS
Oeaudit OEAUDIT Delete Cascades
COR-COMPANY -> OEA-COMPANY
COR-ORDER-NBR -> OEA-ORDER-NBR
Zeroes -> OEA-LINE-NBR
OEA-FLD-NBR
OEA-UPDATE-DATE
OEA-UPDATE-TIME
Oediscount OEDISCOUNT
COR-COMPANY -> OED-COMPANY
OED-DISC-CODE
Oeinvoice OEINVOICE Delete Restricted
COR-COMPANY -> OEI-COMPANY
COR-ORDER-NBR -> OEI-ORDER-NBR
OEI-SHIPMENT-NBR
OEI-INVC-PREFIX
OEI-INVC-NUMBER
Oeorddisc2 OEORDDISC
COR-COMPANY -> OOD-COMPANY
OOD-ORD-DISC-CODE
OOD-CURRENCY-CODE
Oestdline OESTDLINE
COR-COMPANY -> OSL-COMPANY
OSL-CUSTOMER
OSL-STD-ORDER-NBR
OSL-LINE-NBR
Oestdorder OESTDORDER
COR-COMPANY -> OSO-COMPANY
COR-CUSTOMER -> OSO-CUSTOMER
OSO-STD-ORDER-NBR
Polinesrc POLINESRC
COR-COMPANY -> PLS-OPER-COMPANY
"OE" -> PLS-ORIGIN-CD
COR-ORDER-NBR -> PLS-SOURCE-DOC-N
PLS-SRC-LINE-NBR
PLS-PO-CODE
PLS-PO-NUMBER
PLS-PO-RELEASE
PLS-LINE-NBR
Trl Comments OEORDCMNT
COR-COMPANY -> OOC-COMPANY
Spaces -> OOC-CUSTOMER
Spaces -> OOC-STD-ORDER-NBR
COR-ORDER-NBR -> OOC-ORDER-NBR
999999 -> OOC-LINE-NBR
OOC-SEQ
Whshipment WHSHIPMENT
COR-COMPANY -> WHS-COMPANY
"O" -> WHS-SYSTEM-CD
WDH-DOC-NBR -> WHS-DOC-NBR
WHS-SHIPMENT-NBR
WHS-LOCATION
|