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	AP510	API1.1
API2.1	CX05.1	CX05.2	CX100	CX20.1	CX20.2
CX20.4	CX20.5	CX220	CX30.1	CX300	CX506
CX805	CXCP.1	DR100	IC12.1	IC140	IC141
IC142	IC145	IC243	IC330	IC64.1	IC64.2
IC64.3	IC64.4	IC64.5	IC64.6	IC64.7	IC64.8
IC64.9	IC66.1	IC83.1	MA180	MA278	MA41.1
MA41.2	MA41.4	MA41.7	MA42.2	MA43.2	MA43.7
MA44.1	MA44.2	MA53.1	MA530	MA531	MA60.2
MA60.3	MA60.5	MA61.1	MA66.2	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	PD570	PO04.1	PO04.2	PO10.1	PO10.2
PO100	PO101	PO115	PO120	PO122	PO131
PO132	PO136	PO15.1	PO15.2	PO15.4	PO150
PO17.1	PO190	PO20.1	PO20.6	PO20.9	PO204
PO21.1	PO21.2	PO21.3	PO21.4	PO21.5	PO22.1
PO22.3	PO22.4	PO220	PO222	PO224	PO225
PO229	PO23.1	PO230	PO234	PO24.1	PO25.1
PO25.5	PO25.6	PO25.7	PO251	PO26.3	PO26.7
PO26.9	PO27.2	PO27.3	PO27.4	PO275	PO276
PO277	PO28.2	PO280	PO29.1	PO30.1	PO30.2
PO30.3	PO30.4	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	PO54.5	POCP.1	POI3.1	POID.1
POII.1	POIJ.1	RQ01.1	RQ10.1	RQ10.2	RQ10.3
RQ10.4	RQ10.5	RQ11.1	RQ12.1	RQ13.1	RQ13.2
RQ35.1	RQ44.1	RQ500	RQ810	RQIB.1	RQIC.1
RQID.1	RQIF.1	RQIG.1	RQII.1	RQIJ.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	AR501	AR550	CB191

UPDATED BY

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	WH32.5
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 Element: Company	Numeric 4 Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	WH20.7
COR-ORDER-NBR Element: Order Nbr	Numeric 8 Each order is assigned a unique number. Order numbers are either manually assigned or system assigned based on a company-level option.	WH20.7
COR-STATUS Element: Status	Numeric 1 This field contains the status of the order. 1 = Unreleased 2 = Released 8 = Canceled 9 = Ready for purge	WH20.7
COR-PROCESS-LEVEL Element: Process Level	Alpha 5 This field contains the process level, which is the reporting hierarchy below company.	WH20.7
COR-ORDER-TYPE Element: Order Type	Alpha 2 This field contains the order type.	WH20.7
COR-ORDER-DATE Element: Date	Numeric 8 (yyyymmdd) This field contains the date of the order. The system date defaults.	WH20.7
COR-PRICE-DATE Element: Date	Numeric 8 (yyyymmdd) This field contains the pricing basis date. If left blank, each line when added defaults to the system date. The price date is tied to the price list.	WH20.7
COR-OPR-CODE Element: Opr Code	Alpha 10 (Lower Case) This field contains the user ID, which is required for each order.	WH20.7
COR-CHG-OPR Element: Requester	Alpha 10 (Lower Case) This field contains the user ID of the last operator to maintain this order.	WH20.7
COR-CRED-OPR Element: Requester	Alpha 10 (Lower Case) This field contains the user ID of the person who released the order from credit hold.	WH20.7
COR-CUST-PO-NBR Element: Cust Po Nbr	Alpha 22 This field contains the customer's purchase order number. If a purchase order number is entered, it updates to the order and any invoices created from this order.	WH20.7
COR-LETTER-OF-CR Element: Letter Of Cr	Alpha 20 This field contains the letter of credit. This value prints on the invoice and, if the order is dropshipped, this field prints on the purchase order.	WH20.7
COR-BILL-TO Element: Bill To	Numeric 4 This field contains the bill-to customer number.	WH20.7
COR-CUSTOMER Element: Customer	Alpha 9 (Right Justified) This field contains the number that represents a customer.	WH20.7
COR-BILL-NAME Element: Name	Alpha 30 (Lower Case) This field contains the bill-to customer's name. This defaults from the customer file, but can be overridden.	WH20.7
COR-BILL-ADDR1 Element: Addr1	Alpha 30 (Lower Case) This field contains the first line of the bill-to customer's address.	WH20.7
COR-BILL-ADDR2 Element: Addr1	Alpha 30 (Lower Case) This field contains the second line of the bill-to customer's address.	WH20.7
COR-BILL-ADDR3 Element: Addr1	Alpha 30 (Lower Case) This field contains the third line of the bill-to customer's address.	WH20.7
COR-BILL-ADDR4 Element: Addr1	Alpha 30 (Lower Case) This field contains the fourth line of the bill-to customer's address.	WH20.7
COR-BILL-CITY Element: Bill City	Alpha 18 This field contains the city of the bill-to customer's address.	WH20.7
COR-BILL-STATE Element: State Prov	Alpha 2 This field contains the state or province of the bill-to customer's address.	WH20.7
COR-BILL-ZIP Element: Zip	Alpha 10 This field contains the postal code of the bill-to customer's address.	WH20.7
COR-BILL-CNTRY Element: Country	Alpha 30 (Lower Case) This field contains the country of the bill-to customer's address.	WH20.7
COR-BILL-COUNTY Element: County	Alpha 25 (Lower Case) The county for the company address.	WH20.7
COR-EXP-SHIP-DT Element: Date	Numeric 8 (yyyymmdd) This field contains the expected ship date of this order. If left blank and no ship days are defined on this order's process level, the order date defaults. If ship days exist with the process level, the ship days are added to the order date to calculate the expected ship date.	WH132 WH20.7 WH222
COR-RQST-DATE Element: Date	Numeric 8 (yyyymmdd) This field contains the customer's requested delivery date. If left blank, the system date defaults.	WH20.7
COR-USER-ID-RLS Element: User Id Entry	Alpha 3 This field contains the user ID of the person who released this order. This field is only used if the order is entered using the Customer Entry of OE15.	WH20.7
COR-USER-ID-ENTRY Element: User Id Entry	Alpha 3 This field contains the user ID of the person who entered this order at the customer's site.	WH20.7
COR-TAX-EXEMPT-CD Element: Tax Exempt Cd	Alpha 1 This field contains the tax exempt code. If the order header is tax exempt, all order lines are tax exempt. If the order is taxable, you can override the taxable status of individual lines. If lines on the order are taxable, then the 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	WH20.7
COR-SHIP-TO Element: Ship To	Numeric 4 This field contains the ship-to customer's number.	WH20.7
COR-SHIP-TO-NAME Element: Name	Alpha 30 (Lower Case) This field contains the name of the-ship-to customer.	WH20.7
COR-SHIP-TO-ADDR1 Element: Addr1	Alpha 30 (Lower Case) This field contains the first line of the ship-to customer's address.	WH20.7
COR-SHIP-TO-ADDR2 Element: Addr1	Alpha 30 (Lower Case) This field contains the second line of the ship-to customer's address.	WH20.7
COR-SHIP-TO-ADDR3 Element: Addr1	Alpha 30 (Lower Case) This field contains the third line of the ship-to customer's address.	WH20.7
COR-SHIP-TO-ADDR4 Element: Addr1	Alpha 30 (Lower Case) This field contains the fourth line of the ship-to customer's address.	WH20.7
COR-SHIP-TO-CITY Element: Bill City	Alpha 18 This field contains the city of the ship-to customer's address.	WH20.7
COR-SHIP-TO-STATE Element: State Prov	Alpha 2 This field contains the state or province of the ship-to customer's address.	WH20.7
COR-SHIP-TO-ZIP Element: Zip	Alpha 10 This field contains the postal code of the ship-to customer's address.	WH20.7
COR-SHIP-TO-CNTRY Element: Country	Alpha 30 (Lower Case) This field contains the country of the ship-to customer's address.	WH20.7
COR-SHIP-TO-COUNTY Element: County	Alpha 25 (Lower Case) The county for the company address.	WH20.7
COR-HOLD-CODE Element: Hold Code	Alpha 4 This field contains the hold code. If this field is not blank, processing for the order is suspended. You can take an order off hold by clearing its hold code field.	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 WH32.5 WH33.5 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
COR-HOLD-APR-FL Element: All Flag	Alpha 1 This field indicates if the hold code is approved. When a one time credit hold code is removed, this field defaults to Yes, which ensures the order is not placed on hold. Y = Yes N = No	WH20.7
COR-INV-LOCATION Element: Location	Alpha 5 This field contains the location from which inventory is taken. If the item ordered is non-stock, the inventory location is used for reporting purposes.	WH20.7
COR-TERRITORY Element: Territory	Alpha 4 This field contains the sales territory for this order. This defaults from the order's ship-to customer. If no ship-to customer is associated with the order, this defaults from the customer's file.	WH20.7
COR-SALESMAN Element: Salesman	Numeric 4 This field contains the primary sales representative for this order. This defaults from the order's ship-to customer. If no ship-to customer is associated with the order, this defaults from the customer's file.	WH20.7
COR-SALESMAN-2 Element: Salesman	Numeric 4 This field contains the code representing the second sales representative. This defaults from the ship-to customer. If no ship-to customer is associated with the order, this defaults from the customer's file.	WH20.7
COR-COMM-SPLIT Element: Comm Split	Percent 5.3 (Percent) This field contains the commission split. This defaults from the customer file.	WH20.7
COR-COMM-RATE-1 Element: Chrg Rate	Percent 7.5 (Percent) Charge rate by month.	WH20.7
COR-COMM-RATE-2 Element: Chrg Rate	Percent 7.5 (Percent) This field contains the commission rate for the second sales representative. This defaults from the sales representative's file.	WH20.7
COR-CHECK-NBR Element: Check Nbr	Numeric 8 This field contains the payment number. This is only valid with a down payment.	WH20.7
COR-AUTH-REQUIRED Element: All Flag	Alpha 1 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 Element: Auth Approved	Alpha 1 Indicates whether authorization was approved by credit card service or not.
COR-TERMS-CD Element: Term Code	Alpha 5 This field contains the payment terms code. This defaults from the customer's file. Terms codes are set up in Terms.	WH20.7
COR-BANK-INST-CODE Element: Bank Inst Code	Alpha 3 A transaction code represents a type of cash payment, bill of exchange payment, or bank service transaction.	WH20.7
COR-COD-FL Element: All Flag	Alpha 1 This field indicates if COD (Cash On Delivery) orders are accepted. This defaults to Yes if the terms code specifies COD orders. Y = Yes N = No	WH20.7
COR-CIA-FL Element: Cia Fl	Alpha 1 This field indicates that a down payment is needed for the order to be released. The required down payment amount is a percentage of the total order amount. Y = Yes N = No	WH20.7
COR-CIA-PCT Element: Cia Pct	Percent 8.5 (Percent) This field contains the cash in advance percentage, which is used to determine the down payment amount of the total order value.	WH20.7
COR-ORD-DISC-CODE Element: Ord Disc Code	Alpha 4 This field contains the order discount code. If left blank, this defaults from the customer's file. Discounts based on the total value of the order. Order Discount Codes are set up on OE59.1 (Order Discount Code). The order discount and any add-on discounts are printed on the invoices following the line items.	WH20.7
COR-PCT Element: Pct	Percent 5.2 (Percent) This field contains the order discount percent for which this order qualifies based on the total value of the order.	WH20.7
COR-ENTERED-PMNT Element: Intl Amt	Signed 18.2 This field contains the down payment amount entered in the order's currency.	WH20.7
COR-MULT-PMNT Element: Mult Pmnt	Derived 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 Element: Div Pmnt	Derived 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 Element: Pmnt Base	Derived This field contains the amount of the payment in the company base currency.
COR-NET-DUE-CURR Element: Net Due Curr	Derived This field contains the total amount of the order minus the down payment valued in the order's original currency.
COR-NET-DUE-BASE Element: Net Due Base	Derived This field contains the total amount in company base currency of the order minus the down payment.
COR-PMNT-INVCED Element: Intl Amt	Signed 18.2 This field contains the amount of payment that has been printed on invoices for this order. Once the invoice has been printed, the payment amount cannot be changed below the original value.	WH20.7
COR-ENTERED-DISC Element: Intl Amt	Signed 18.2 This field contains the additional discount amount entered on the order in the original currency in which the order was placed.	WH20.7
COR-MULT-DISC Element: Mult Disc	Derived This field contains the base discount amount if a multiplier is used in its conversion.
COR-DIV-DISC Element: Div Disc	Derived This field contains the base discount amount if a divider is used in its conversion.
COR-DISC-BASE Element: Disc Base	Derived This field contains the amount of the discount in the company's base currency.
COR-DISC-TKN-CURR Element: Intl Amt	Signed 18.2 This field contains the amount of additional discount that has been taken on invoices for this order. This can be different from the total order discount if partial shipments are invoiced for the order.	WH20.7
COR-MULT-DISC-TKN Element: Mult Disc Tkn	Derived 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 Element: Div Disc Tkn	Derived 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 Element: Disc Tkn Base	Derived This field contains the amount of the additional discount taken on invoices of the order in the company base currency.
COR-TAX-CODE Element: Tax Code	Alpha 10 This field contains a code representing the tax authorities this ship-to pays sales tax to. This must be valid in the Tax Code file.	WH20.7
COR-TAX-DATE Element: Date	Numeric 8 (yyyymmdd) This field contains the tax point date. This is only used if you are overriding the normal tax point date. This is the source of the invoice's tax point date only if this field is not equal to zero.	WH20.7
COR-ORDER-SOURCE Element: Order Source	Alpha 2 This field contains the order source code that indicates the reason the customer gave for placing the order. Order source codes are set up in Order Source (OE52.1).	WH20.7
COR-FREIGHT-CODE Element: Freight Code	Alpha 2 This field contains the freight code, which determines if carrier and freight charges are assessed on the shipment. Freight codes are defined in Freight Codes (BL12.1). A freight code can be added to the customer's file as a default, or it can be added at order entry time.	WH20.7
COR-FRT-CHG-CURR Element: Intl Amt	Signed 18.2 This field contains the freight charge amount in billing currency.	WH20.7
COR-FRT-TAXABLE-FL Element: All Flag	Alpha 1 Select Yes if freight is taxable. Y = Yes N = No	WH20.7
COR-MULT-FRT-CHG Element: Mult Frt Chg	Derived 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 Element: Div Frt Chg	Derived 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 Element: Frt Chg Base	Derived This field contains the freight charge amount in base currency.
COR-ACTUAL-FRT-CHG Element: Intl Amt	Signed 18.2 The actual freight charges to-date in GL company base currency. Sourced from: 1). All freight that has been paid by Accounts Payable involving a dropship 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).	WH20.7
COR-MULT-A-FRT-CHG Element: Mult A Frt Chg	Derived
COR-DIV-A-FRT-CHG Element: Div A Frt Chg	Derived
COR-ACTUAL-FR-CH-B Element: Actual Fr Ch B	Derived
COR-CARRIER Element: Vendor	Alpha 9 (Right Justified) This field contains the carrier vendor number. Vendors are set up in Accounts Payable.	WH20.7
COR-METHOD Element: Method	Alpha 10 User-defined shipping method. Shipping methods are set up in Warehouse. The shipping method will print on order acknowledgments, packing lists, and invoices.	WH20.7
COR-TRANS-ID Element: Trans Id	Alpha 20 This field contains the transportation ID, which is a user-definable field form that prints on invoices and bills of lading. This field is not validated.	WH20.7
COR-LIST-NAME Element: List Name	Alpha 14 This field contains the customer's price list. This defaults from the customer's price list when the order is entered.	WH20.7
COR-PK-PRIORITY Element: Pk Priority	Numeric 2 This field contains the picking priority, which defaults from the customer's file. Batch Allocation (WH110) uses this as a priority when assigning inventory to orders.	WH20.7
COR-IMMEDIATE-FL Element: All Flag	Alpha 1 This field indicates that this order should be delivered on the next run of route construction regardless of the routes being delivered today. Y = Yes N = No	WH20.7
COR-EDI-OE-FLAG Element: All Flag	Alpha 1 This field contains the EDI flag, which is set on if this order was created by the EDI interface. N = No Y = Yes	WH20.7
COR-ACKNWLDG-FL Element: All Flag	Alpha 1 This field indicates whether a printed acknowledgment is required for this order. This defaults from the customer's file. N = No Y = Yes	WH20.7
COR-ACK-PRT-FL Element: All Flag	Alpha 1 This field indicates if an acknowledgment was printed to avoid duplicate printing of the document. N = No Y = Yes	WH20.7
COR-BACK-ORD-FL Element: Back Ord Fl	Alpha 1 This field indicates if backorders are allowed. If No, an order cannot be placed for items that do not have sufficient stock to be allocated to them. This is only valid for companies that use online allocation. This defaults from the customer's file. N = No Y = Yes	WH20.7
COR-SHIP-COMP-FL Element: Ship Comp Fl	Alpha 1 This field indicates whether partial shipments are allowed. This defaults from the customer's file. N = No Y = Yes " " = Determined by Line	WH20.7
COR-CREDIT-WF-FL Element: All Flag	Alpha 1 This field indicates that this order on hold has passed to the Workflow Management system. Y = Yes N = No	WH130 WH132 WH190 WH30.1 WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH32.5 WH33.5 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
COR-ACTIVITY Element: Activity	Alpha 15 In this file the Activity field is used for revenue (sales) postings whereas the Activity-C field is used for Cost (COGS) postings. Activities are the processes or 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.	WH20.7
COR-ACCT-CATEGORY Element: Acct Category	Alpha 5 In this file the Acct-Category field is used for revenue (sales) postings whereas the Acct-Categ-C field is used for Cost (COGS) postings. Account categories are groupings of 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.	WH20.7
COR-ACTIVITY-C Element: Activity	Alpha 15 In this file the Activity-C field is used for Cost (COGS) postings whereas the Activity field is used for revenue (sales) postings. Activities are the processes or 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.	WH20.7
COR-ACCT-CATEG-C Element: Acct Category	Alpha 5 In this file the Acct-Categ-C field is used for Cost (COGS) postings whereas the Acct-Category field is used for revenue (sales) postings. Account categories are groupings of 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.	WH20.7
COR-USER-DATE-1 Element: Date	Numeric 8 (yyyymmdd) This field contains the first user-definable date. This is used by Orders Not Shipped for Customer (OE280).	WH20.7
COR-USER-DATE-2 Element: Date	Numeric 8 (yyyymmdd) This field contains the second user-definable date. This is used by Orders Not Shipped for Customer (OE280).	WH20.7
COR-TRANS-USER1 Element: Trans User1	Alpha 10 This field contains the first user-definable transaction field. This field can be used in Accounts Receivable as a sort option during cash application and select criteria for the aged trial balance.	WH20.7
COR-TRANS-USER2 Element: Agent	Alpha 15 This field contains the second user-definable transaction field. This updates on the invoice in the Accounts Receivable file.	WH20.7
COR-TRANS-USER3 Element: Trans User3	Numeric 8 (yyyymmdd) This field contains the third user-definable transaction field. This updates on the invoice in the Accounts Receivable file.	WH20.7
COR-TRANS-USER4 Element: Trans User4	Numeric 9 This field contains the fourth user-definable transaction field. This updates on the invoice in the Accounts Receivable file.	WH20.7
COR-TRANS-USER5 Element: Intl Amt	Signed 18.2 This field contains the fifth user-definable transaction field. This updates on the invoice in the Accounts Receivable file.	WH20.7
COR-CUBIC-FEET Element: Cubic Feet	Signed 9.3 This field contains the total cubic feet of the items comprising this order.	WH20.7
COR-WEIGHT Element: Weight	Signed 9.3 This field contains the total weight of this order.	WH20.7
COR-LAST-LINE-NBR Element: Line Nbr	Numeric 6 This field contains the number of the last line item added to the order.	WH20.7
COR-LAST-TP-SEQ Element: Seq	Numeric 3 This field contains the last sequence number used for top comments.	BLI2.1 WH20.7
COR-LAST-BM-SEQ Element: Seq	Numeric 3 This field contains the last sequence number used for bottom comments.	BLI2.1 WH20.7
COR-LAST-MISC-SEQ Element: Seq	Numeric 3 This field contains the last sequence number used for add-on charges.	WH20.7
COR-SHIPMENT-NBR Element: Shipment Nbr	Numeric 10 This field contains the last shipment number used for this order.	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 WH32.5 WH33.5 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
COR-LST-IF-REF-NBR Element: Lst If Ref Nbr	Numeric 6 This field contains an internally generated reference number used by the Requisitions system.	WH20.7
COR-SLS-QUOTE-FL Element: All Flag	Alpha 1 This field indicates if the order is a quote. Quotes cannot be released and have no effect on inventory. They can be changed to regular orders and subsequently processed. Y = Yes N = No	WH20.7
COR-FUTURE-FL Element: Future Fl	Alpha 1 This field contains the future flag, which defaults to No. If set to Yes, future lines do not have inventory allocated to them until it is necessary to meet the customer's requested delivery date. N = No Y = Yes	WH20.7
COR-PK-PRT-FL Element: All Flag	Alpha 1 This field indicates whether a picking list has been printed for this order. N = No Y = Yes	WH20.7
COR-POD-REQ-FL Element: Pod Req Fl	Alpha 1 This field indicates that a POD (Proof of Delivery) is required. Indicates whether this customer's ship-to requires a POD form to accompany the shipment. The shipment is not billed until the POD is returned or the POD grace period expires. N = No Y = Yes	WH20.7
COR-POD-GRACE-PER Element: Age Periods	Numeric 3 This field contains the number of days from the shipment date after which POD shipments are automatically billed even if the POD is not returned.	WH20.7
COR-CXL-DATE Element: Date	Numeric 8 (yyyymmdd) This field contains the date the order was canceled.	WH20.7
COR-CXL-OPR Element: Requester	Alpha 10 (Lower Case) This field contains the user ID of the person who canceled the order.	WH20.7
COR-CXL-REASON Element: Cb Reason	Alpha 4 This field contains the cancellation reason code. This is passed to the Sales Analysis system for reporting.	WH20.7
COR-SA-UPDATED-FL Element: Sa Updated Fl	Alpha 1 This field indicates if this order has been booked in the Sales Analysis system. Y = Yes N = No C = Change	WH20.7
COR-CURRENCY-CODE Element: Currency Code	Alpha 5 This field contains the currency the customer is to be billed in for this order. This defaults from the customer's file.	WH20.7
COR-CURR-MUDV Element: Curr Mudv	Alpha 1 This field indicates whether the conversion from base to the billing currency is accomplished using a multiplier or divider. M = Multiply D = Divide	WH20.7
COR-CURR-RATE Element: Curr Rate	Signed 14.7 This field contains the currency conversion rate to base currency.	WH20.7
COR-CURR-ND Element: Acct Nd	Numeric 1 This field contains the number of decimals for the billing currency.	WH20.2 WH20.7
COR-CURR-OVR-FL Element: All Flag	Alpha 1 This field indicates whether you can override the currency for transactions on the customer's account. Y = Yes N = No
COR-RATE-FRZ-CD Element: Rate Frz Cd	Alpha 1 This field contains the code indicating when the currency conversion rate is frozen for this order. O = Order I = Invoice P = Payment	WH20.7
COR-OPEN-ORD-AMT Element: Intl Amt	Signed 18.2 This field contains the total amount of the open order added to the customer's open order total from the customer's file in tran currency.	WH130 WH132 WH190 WH20.7 WH520 WH830
COR-OPEN-ORD-CURR Element: Intl Amt	Signed 18.2 This field contains the total amount of the open order added to the customer's open order total from the customer's file in base currency.	WH20.7
COR-PASS-ORD-AMT Element: Intl Amt	Signed 18.2 This field contains the amount of the open order that was subtracted from the customer's open order total by invoices that have been created for this order.	WH20.7
COR-INV-GDS-CURR Element: Intl Amt	Signed 18.2 This field contains the amount of inventoried goods for this order in billing currency.	WH130 WH132 WH190 WH20.7 WH520 WH830
COR-INV-GDS-BASE Element: Intl Amt	Signed 18.2 This field contains the amount of inventoried goods for this order in base currency.	WH130 WH132 WH190 WH20.7 WH520 WH830
COR-NI-GDS-CURR Element: Intl Amt	Signed 18.2 This field contains the amount of non-inventoried goods for this order in billing currency. These could be either nonstock or special items.	WH130 WH132 WH190 WH20.7 WH520 WH830
COR-NI-GDS-BASE Element: Intl Amt	Signed 18.2 This field contains the amount of non-inventoried goods for this order in base currency. These can be either nonstock or special items.	WH130 WH132 WH190 WH20.7 WH520 WH830
COR-GDS-TTL-CURR Element: Gds Ttl Curr	Derived This field contains the total goods amount for this order in billing currency.
COR-GDS-TTL-BASE Element: Gds Ttl Base	Derived This field contains the total goods amount for this order in base currency.
COR-MISC-TTL-CURR Element: Intl Amt	Signed 18.2 This field contains the total of add-on charges for this order in billing currency.	WH20.7
COR-MULT-MISC-TTL Element: Mult Misc Ttl	Derived 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 Element: Div Misc Ttl	Derived 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 Element: Misc Ttl Base	Derived This field contains the total amount of add-on charges in base currency.
COR-DISCNTBL-CURR Element: Intl Amt	Signed 18.2 This field contains the total discountable amount for this order in billing currency. This amount is used to compute the order discount amount.	WH130 WH132 WH190 WH20.7 WH520 WH830
COR-MULT-DISCNTBL Element: Mult Discntbl	Derived 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 Element: Div Discntbl	Derived 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 Element: Discntbl Base	Derived This field contains the total discountable amount of the order in base currency.
COR-ORD-DISC-CURR Element: Intl Amt	Signed 18.2 This field contains the discount for this order in billing currency. Order discounts are calculated using the discount codes set up on Order Discount Code (OE59.1) that are assigned to the customer's record.	WH20.7
COR-MULT-ORD-DISC Element: Mult Ord Disc	Derived 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 Element: Div Ord Disc	Derived 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 Element: Ord Disc Base	Derived This field contains the total amount of the order discount in the company base currency.
COR-TXBL-TTL-CURR Element: Intl Amt	Signed 18.2 This field contains the taxable amount for this order in billing currency.	WH20.7
COR-MULT-TXBL-TTL Element: Mult Txbl Ttl	Derived 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 Element: Div Txbl Ttl	Derived 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 Element: Txbl Ttl Base	Derived This field contains the taxable amount for this order in the company base currency.
COR-TAX-TTL-CURR Element: Intl Amt	Signed 18.2 This field contains the total amount of tax on the order in original billing currency.	WH20.7
COR-MULT-TAX-TTL Element: Mult Tax Ttl	Derived 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 Element: Div Tax Ttl	Derived 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 Element: Tax Ttl Base	Derived This field contains the total amount of tax on the order in base currency.
COR-ORD-GRS-BASE Element: Ord Grs Base	Derived This field contains the total gross amount of the order in base currency.
COR-ORD-GRS-CURR Element: Ord Grs Curr	Derived This field contains the total gross amount of the order in original billing currency.
COR-ORDER-NET Element: Order Net	Derived This field contains the total of line net amounts plus add-on charges minus order discounts.
COR-ORD-NET-BASE Element: Ord Net Base	Derived This field contains the total of line net amounts and add-on charges minus order discounts in base currency.
COR-ORD-NET-CURR Element: Ord Net Curr	Derived 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 Element: Hold Lit	Derived This field contains the hold code.
COR-TERMS-1 Element: Terms 1	Derived This field contains the description of the first credit card terms table.
COR-TERM-2 Element: Term 2	Derived This field contains the description of the second credit card terms table.
COR-ORDER-NBR-A Element: Order Nbr A	Derived This field is used internally to create relationships.
COR-ORDER-ZERO Element: Order Zero	Derived This field is used internally to create relationships
COR-COMM-LIT Element: Comm Lit	Derived If comments are attached, this field displays "comments exist."
COR-WF-CO-ORDR-NBR Element: Wf Co Ordr Nbr	Derived
COR-INTRASTAT-NBR Element: Intrastat Nbr	Numeric 12 The number assigned by the Intrastat system to a transaction that involves Intrastat reporting after it has been added.	WH20.7
COR-BILL-CNTRY-CD Element: Bill Cntry Cd	Alpha 2 The Bill-To country code; must be defined in IN01.1 (Country Maintenance).	WH20.7
COR-BILL-REGION Element: Bill Region	Alpha 2 The Bill-To region code. Must be a valid region for the country, defined in IN02.1 (Region Maintenance).	WH20.7
COR-TO-CNTRY-CD Element: To Cntry Cd	Alpha 2 The Ship-To country code. Must be defined in IN01.1 (Country Maintenaance).	WH20.7
COR-SHIP-TO-REGION Element: Ship To Region	Alpha 2 The ship-to region code. Must be a valid region for the country, defined in IN02.1 (Region Maintenance).	WH20.7
COR-ORDER-REF-NBR Element: Order Ref Nbr	Numeric 8 This field contains the order reference number. This number can be filled with extra order number information.
COR-REF-NBR-FLAG Element: Ref Nbr Flag	Alpha 1 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 Element: Req Ep Auth	Alpha 1
COR-EP-AMT-CURR Element: Intl Amt	Signed 18.2	WH20.7
COR-EP-AMT-BASE Element: Intl Amt	Signed 18.2	WH20.7
COR-EP-SETTLE-AMT Element: Intl Amt	Signed 18.2	WH20.7
COR-EP-TRANS-ID Element: Ep Trans Id	Numeric 12	WH20.7
COR-EP-TYPE Element: Ep Type	Alpha 5	WH20.7
COR-EP-ACCOUNT Element: Ep Account	Alpha 32	WH20.7
COR-EP-EXP-DATE Element: Ep Exp Date	Numeric 8 (yyyymmdd)	WH20.7
COR-EP-MARGIN-MIN Element: Ep Margin Min	Signed 7.2	WH20.7
COR-EP-MARGIN-PCT Element: Ep Margin Pct	Percent 8.5 (Percent)	WH20.7
COR-ORDER-TTL-CURR Element: Intl Amt	Signed 18.2
COR-ORDER-TTL-BASE Element: Intl Amt	Signed 18.2
COR-BILL-EC-CTRY Element: Bill Ec Ctry	Numeric 3	WH20.7
COR-BILL-ISO-CTRY Element: Bill Iso Ctry	Numeric 3	WH20.7
COR-TO-EC-CTRY Element: To Ec Ctry	Numeric 3	WH20.7
COR-TO-ISO-CTRY Element: To Iso Ctry	Numeric 3	WH20.7
COR-NOTC Element: Notc	Alpha 2 The Nature of Transaction code. Must be a valid code defined in IN07.1 (NOTC Maintenance).	WH20.7
COR-STAT-PROC Element: Stat Proc	Alpha 6 The statistical procedure code applied to the data. The code must be defined in IN06.1. (Statistical Procedure Maintenance).	WH20.7
COR-VAT-REG-NBR Element: Vat Reg Nbr	Alpha 12 The number component of the VAT Registration Number. This field together with the Registration Country field make up the VAT Registration Number.	WH20.7
COR-GLBL-DOC-TYPE Element: Glbl Doc Type	Alpha 10	WH20.7
COR-FREIGHT-TOT Element: Freight Total	Signed 18.2	WH20.7
COR-INSURANCE-TOT Element: Insurance Tot	Signed 18.2	WH20.7
COR-CSTMS-TOT Element: Cstms Total	Signed 18.2	WH20.7
COR-OTHER-AOC-TOT Element: Other Aoc Tot	Signed 18.2	WH20.7

CUSTORDER FILE INDEX

CUSTORDER FILE RELATIONS

ONE TO ONE RELATIONS

CUSTORDER FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.