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 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 AR21.6
AR21.1 AR21.2 AR21.3 BL00.1 BL121 BL123
BL291 BL80.1 BL80.4 BL91.1 CXCP.1 MA180
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.7 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA66.2 MA66.3 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA70.1 MA75.1 MA80.1
MAI1.1 PD10.1 PD10.2 PD130 PD20.1 PD20.2
PD20.3 PO100 PO101 PO122 PO131 PO136
PO190 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO27.2 PO29.1 PO30.1 PO30.2
PO30.3 PO300 PO31.1 PO31.2 PO32.2 PO32.4
PO33.1 PO34.1 PO35.1 PO36.1 PO36.2 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
PO536 POI3.1 POID.1 POII.1 POIJ.1 RQ10.1
RQ10.2 RQ10.3 RQ11.1 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 AR08.1
AR10.1 AR120 AR501 AR550 BL02.1 AR115
AR124 AR20.1 AR24.1 AR30.1 AR32.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 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 WHD2.1
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
WH20.7
COR-ORDER-NBR Numeric 8 BL120 BL122
Element: Order Nbr 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
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 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
WH20.7
COR-ORDER-TYPE Alpha 2 BL120 BL122
Element: Order Type This field contains the order type. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
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
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
WH20.7
COR-OPR-CODE Alpha 10 (Lower Case) BL120 BL122
Element: Opr 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
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
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
WH20.7
COR-CUST-PO-NBR Alpha 22 BL120 BL122
Element: Cust Po Nbr 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
WH20.7
COR-LETTER-OF-CR Alpha 20 BL120 BL122
Element: Letter Of Cr This 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
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
WH20.7
COR-CUSTOMER Alpha 9 (Right Justified) BL120 BL122
Element: Customer This 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
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
WH20.7
COR-BILL-ADDR1 Alpha 30 (Lower Case) BL120 BL122
Element: Addr1 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
WH20.7
COR-BILL-ADDR2 Alpha 30 (Lower Case) BL120 BL122
Element: Addr1 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
WH20.7
COR-BILL-ADDR3 Alpha 30 (Lower Case) BL120 BL122
Element: Addr1 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
WH20.7
COR-BILL-ADDR4 Alpha 30 (Lower Case) BL120 BL122
Element: Addr1 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
WH20.7
COR-BILL-CITY Alpha 18 BL120 BL122
Element: Bill 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
WH20.7
COR-BILL-STATE Alpha 2 BL120 BL122
Element: State Prov This 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
WH20.7
COR-BILL-ZIP Alpha 10 BL120 BL122
Element: Zip 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
WH20.7
COR-BILL-CNTRY Alpha 30 (Lower Case) BL120 BL122
Element: Country This 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
WH20.7
COR-BILL-COUNTY Alpha 25 (Lower Case) BL120 BL122
Element: County The county for the company address. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
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 WH132 WH20.7
order date to calculate the expected WH222
ship date.
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
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
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
WH20.7
COR-TAX-EXEMPT-CD Alpha 1 BL120 BL122
Element: Tax Exempt Cd This 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 WH20.7
order header must be taxable. If either
the customer or the item(s) involved
with the order are exempt then the
entire order is exempt.
E = Exempt
T = Taxable
COR-SHIP-TO Numeric 4 BL120 BL122
Element: Ship To 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
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
WH20.7
COR-SHIP-TO-ADDR1 Alpha 30 (Lower Case) BL120 BL122
Element: Addr1 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
WH20.7
COR-SHIP-TO-ADDR2 Alpha 30 (Lower Case) BL120 BL122
Element: Addr1 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
WH20.7
COR-SHIP-TO-ADDR3 Alpha 30 (Lower Case) BL120 BL122
Element: Addr1 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
WH20.7
COR-SHIP-TO-ADDR4 Alpha 30 (Lower Case) BL120 BL122
Element: Addr1 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
WH20.7
COR-SHIP-TO-CITY Alpha 18 BL120 BL122
Element: Bill 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
WH20.7
COR-SHIP-TO-STATE Alpha 2 BL120 BL122
Element: State Prov This 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
WH20.7
COR-SHIP-TO-ZIP Alpha 10 BL120 BL122
Element: Zip 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
WH20.7
COR-SHIP-TO-CNTRY Alpha 30 (Lower Case) BL120 BL122
Element: Country This 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
WH20.7
COR-SHIP-TO-COUNTY Alpha 25 (Lower Case) BL120 BL122
Element: County The county for the company address. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
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
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.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
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 WH20.7
N = No
COR-INV-LOCATION Alpha 5 BL120 BL122
Element: Location This field contains the location from BL130 BL20.1
which inventory is taken. If the item BL20.3 BL21.2
ordered is non-stock, the inventory BL21.5 BL29.1
location is used for reporting purposes. BL29.2 BL520
BL820 BL92.1
WH20.7
COR-TERRITORY Alpha 4 BL120 BL122
Element: Territory This 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
WH20.7
COR-SALESMAN Numeric 4 BL120 BL122
Element: Salesman This 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. WH20.7
COR-SALESMAN-2 Numeric 4 BL120 BL122
Element: Salesman This 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. WH20.7
COR-COMM-SPLIT Percent 5.3 (Percent) BL120 BL122
Element: Comm Split This field contains the commission BL130 BL20.1
split. This defaults from the customer BL20.3 BL21.2
file. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COR-COMM-RATE-1 Percent 7.5 (Percent) BL120 BL122
Element: Chrg Rate Charge rate by month. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
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
WH20.7
COR-CHECK-NBR Numeric 8 BL120 BL122
Element: Check Nbr This 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
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: Term 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 Terms. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COR-BANK-INST-CODE Alpha 3 BL120 BL122
Element: Bank Inst CodeA 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
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
WH20.7
COR-CIA-FL Alpha 1 BL120 BL122
Element: Cia Fl This 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 WH20.7
N = No
COR-CIA-PCT Percent 8.5 (Percent) BL120 BL122
Element: Cia Pct This field contains the cash in advance BL130 BL20.1
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
WH20.7
COR-ORD-DISC-CODE Alpha 4 BL120 BL122
Element: Ord Disc Code This 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 WH20.7
discount and any add-on discounts are
printed on the invoices following the
line items.
COR-PCT Percent 5.2 (Percent) BL120 BL122
Element: Pct 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
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
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. 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
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. 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
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
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 Order BL29.2 BL520
Source (OE52.1). BL820 BL92.1
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 Freight BL29.2 BL520
Codes (BL12.1). A freight code can be BL80.1 BL820
added to the customer's file as a BL92.1 WH20.7
default, or it can be added at order
entry time.
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
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
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
Accounts Payable involving a dropship WH20.7
customer order originating from Order
Entry. In this case, the Actual-Frt-Chg
is updated by Daily Shipment Journal
(OE129).
2). All freight billed to a customer
excluding dropship freight. Updated by
Daily Shipment Journal (OE129).
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 This field contains the carrier vendor BL130 BL20.1
number. Vendors are set up in Accounts BL20.3 BL21.2
Payable. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COR-METHOD Alpha 10 BL120 BL122
Element: Method User-defined shipping method. Shipping BL130 BL20.1
methods are set up in Warehouse. The BL20.3 BL21.2
shipping method will print on order BL21.5 BL29.1
acknowledgments, packing lists, and BL29.2 BL520
invoices. BL820 BL92.1
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
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
WH20.7
COR-PK-PRIORITY Numeric 2 BL120 BL122
Element: Pk Priority This field contains the picking BL130 BL20.1
priority, which defaults from the BL20.3 BL21.2
customer's file. Batch Allocation BL21.5 BL29.1
(WH110) uses this as a priority when BL29.2 BL520
assigning inventory to orders. BL820 BL92.1
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 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
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 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
WH20.7
COR-BACK-ORD-FL Alpha 1 BL120 BL122
Element: Back Ord Fl This field indicates if backorders are BL130 BL20.1
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 WH20.7
defaults from the customer's file.
N = No
Y = Yes
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 WH20.7
COR-CREDIT-WF-FL Alpha 1 BL92.1 WH130
Element: All Flag This field indicates that this order on WH132 WH190
hold has passed to the Workflow WH30.1 WH30.2
Management system. WH30.3 WH30.4
Y = Yes WH31.1 WH31.2
N = No 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 WH20.7
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity. Activities and
cost object activities are used
synonymously in Project Accounting.
Direct costs are posted to activities,
and indirect costs are allocated to
activities based on activity drivers.
Activities are grouped or organized by
activity levels. There are two types of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
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: Acct Category In 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 WH20.7
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in Project Accounting.
All transactions are posted to an
account category within an activity. You
can assign a specific general ledger
account or range of accounts (company,
accounting unit, account, and
subaccount) that make up the
transactions posted to an account
category using Account Assignment
(AC07.1).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
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 WH20.7
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity. Activities and
cost object activities are used
synonymously in Project Accounting.
Direct costs are posted to activities,
and indirect costs are allocated to
activities based on activity drivers.
Activities are grouped or organized by
activity levels. There are two types of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
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: Acct Category In 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 WH20.7
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in Project Accounting.
All transactions are posted to an
account category within an activity. You
can assign a specific general ledger
account or range of accounts (company,
accounting unit, account, and
subaccount) that make up the
transactions posted to an account
category using Account Assignment
(AC07.1).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
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
Orders Not Shipped for Customer (OE280). BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
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
Orders Not Shipped for Customer (OE280). BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
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 Accounts Receivable BL21.5 BL29.1
as a sort option during cash application BL29.2 BL520
and select criteria for the aged trial BL820 BL92.1
balance. 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 file. BL29.2 BL520
BL820 BL92.1
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 file. BL29.2 BL520
BL820 BL92.1
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 file. BL29.2 BL520
BL820 BL92.1
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 file. BL29.2 BL520
BL820 BL92.1
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
WH20.7
COR-WEIGHT Signed 9.3 BL120 BL122
Element: 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
WH20.7
COR-LAST-LINE-NBR Numeric 6 BL120 BL122
Element: Line Nbr 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
WH20.7
COR-LAST-TP-SEQ Numeric 3 BL120 BL122
Element: Seq This 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 WH20.7
COR-LAST-BM-SEQ Numeric 3 BL120 BL122
Element: Seq This 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 WH20.7
COR-LAST-MISC-SEQ Numeric 3 BL120 BL122
Element: Seq This 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
WH20.7
COR-SHIPMENT-NBR Numeric 10 BL120 BL122
Element: Shipment Nbr This 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
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.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
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
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 WH20.7
N = No
COR-FUTURE-FL Alpha 1 BL120 BL122
Element: Future Fl This 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. WH20.7
N = No
Y = Yes
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
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 WH20.7
expires.
N = No
Y = Yes
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
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
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
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
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 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
WH20.7
COR-CURR-MUDV Alpha 1 BL120 BL122
Element: Curr Mudv This field indicates whether the BL130 BL20.1
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 WH20.7
COR-CURR-RATE Signed 14.7 BL120 BL122
Element: Curr 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
WH20.7
COR-CURR-ND Numeric 1 BL120 BL122
Element: Acct Nd This field contains the number of BL130 BL20.1
decimals for the billing currency. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
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 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
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
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
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
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
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
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
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
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
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 Order Discount BL29.2 BL520
Code (OE59.1) that are assigned to the BL820 BL92.1
customer's record. 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
WH20.7
CUSTORDER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CORSET1 COMPANY AP125 AP126
ORDER-NBR AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 AR21.6
BL00.1 BL120
BL121 BL122
BL123 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
...
CORSET10 COMPANY Subset
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 AR120 AR501
ORDER-NBR AR550 BL02.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.2 WH20.7
CORSET3 COMPANY KeyChange
CUST-PO-NBR
ORDER-NBR
CORSET5 COMPANY
OPR-CODE
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
AR32.1 AR34.1
AR570 AR575
AR580 CB191
CORSET7 COMPANY KeyChange
HOLD-CODE
ORDER-NBR
CORSET8 COMPANY KeyChange
ORDER-DATE
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 -> -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
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
"OE" -> WHS-SYSTEM-CD
WDH-DOC-NBR -> WHS-DOC-NBR
WHS-SHIPMENT-NBR
WHS-LOCATION
|