CUSTORDER – Customer Order File

System
OE (OE)
Prefix
COR
Primary key
COMPANY, ORDER-NBR
Fields
205
Updated by
35 programs
Referenced by
210 programs

CUSTORDER is the Customer Order File table in Lawson OE (prefix COR). It is indexed by COMPANY, ORDER-NBR (CORSET1); alternate indexes: CORSET10, CORSET11, CORSET12, CORSET13, CORSET2, CORSET3, CORSET5, CORSET6 and 2 more. It is related 1:1 to APCOMPANY, APVENMAST, ARCOMP, ARCUSTOMER, BILLTO, COSGBLK, CUCODES, CURELAT and 24 more and 1:M to COMISC, COLINE, CUSTORDER, OEORDCMNT, ICGENERIC, MAJORCL, MINORCL, OEAUDIT and 5 more. It is updated by BLI2.1, WH130, WH132, WH190, WH20.7, WH30.1, WH30.2, WH30.3 and 27 more and referenced by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 202 more. The table has 205 fields, 11 indexes and 49 documented relations.

About CUSTORDER

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.

Fields (205)

Column = COBOL field name without the COR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
COR-COMPANY PK
COMPANY		Numeric 4Identifies 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 PK
ORDER_NBR		Numeric 8Each 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
STATUS		Numeric 1This field contains the status of the order.
  • 1 Unreleased
  • 2 Released
  • 8 Canceled
  • 9 Ready for purge
WH20.7
COR-PROCESS-LEVEL
PROCESS_LEVEL		Alpha 5This field contains the process level, which is the reporting hierarchy below company.WH20.7
COR-ORDER-TYPE
ORDER_TYPE		Alpha 2This field contains the order type.WH20.7
COR-ORDER-DATE
ORDER_DATE		Numeric 8 (yyyymmdd)This field contains the date of the order. The system date defaults.WH20.7
COR-PRICE-DATE
PRICE_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
OPR_CODE		Alpha 10 (Lower Case)This field contains the user ID, which is required for each order.WH20.7
COR-CHG-OPR
CHG_OPR		Alpha 10 (Lower Case)This field contains the user ID of the last operator to maintain this order.WH20.7
COR-CRED-OPR
CRED_OPR		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
CUST_PO_NBR		Alpha 22This 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
LETTER_OF_CR		Alpha 20This 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
BILL_TO		Numeric 4This field contains the bill-to customer number.WH20.7
COR-CUSTOMER
CUSTOMER		Alpha 9 (Right Justified)This field contains the number that represents a customer.WH20.7
COR-BILL-NAME
BILL_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
BILL_ADDR1		Alpha 30 (Lower Case)This field contains the first line of the bill-to customer's address.WH20.7
COR-BILL-ADDR2
BILL_ADDR2		Alpha 30 (Lower Case)This field contains the second line of the bill-to customer's address.WH20.7
COR-BILL-ADDR3
BILL_ADDR3		Alpha 30 (Lower Case)This field contains the third line of the bill-to customer's address.WH20.7
COR-BILL-ADDR4
BILL_ADDR4		Alpha 30 (Lower Case)This field contains the fourth line of the bill-to customer's address.WH20.7
COR-BILL-CITY
BILL_CITY		Alpha 18This field contains the city of the bill-to customer's address.WH20.7
COR-BILL-STATE
BILL_STATE		Alpha 2This field contains the state or province of the bill-to customer's address.WH20.7
COR-BILL-ZIP
BILL_ZIP		Alpha 10This field contains the postal code of the bill-to customer's address.WH20.7
COR-BILL-CNTRY
BILL_CNTRY		Alpha 30 (Lower Case)This field contains the country of the bill-to customer's address.WH20.7
COR-BILL-COUNTY
BILL_COUNTY		Alpha 25 (Lower Case)The county for the company address.WH20.7
COR-EXP-SHIP-DT
EXP_SHIP_DT		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
RQST_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
USER_ID_RLS		Alpha 3This 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
USER_ID_ENTRY		Alpha 3This field contains the user ID of the person who entered this order at the customer's site.WH20.7
COR-TAX-EXEMPT-CD
TAX_EXEMPT_CD		Alpha 1This 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
SHIP_TO		Numeric 4This field contains the ship-to customer's number.WH20.7
COR-SHIP-TO-NAME
SHIP_TO_NAME		Alpha 30 (Lower Case)This field contains the name of the-ship-to customer.WH20.7
COR-SHIP-TO-ADDR1
SHIP_TO_ADDR1		Alpha 30 (Lower Case)This field contains the first line of the ship-to customer's address.WH20.7
COR-SHIP-TO-ADDR2
SHIP_TO_ADDR2		Alpha 30 (Lower Case)This field contains the second line of the ship-to customer's address.WH20.7
COR-SHIP-TO-ADDR3
SHIP_TO_ADDR3		Alpha 30 (Lower Case)This field contains the third line of the ship-to customer's address.WH20.7
COR-SHIP-TO-ADDR4
SHIP_TO_ADDR4		Alpha 30 (Lower Case)This field contains the fourth line of the ship-to customer's address.WH20.7
COR-SHIP-TO-CITY
SHIP_TO_CITY		Alpha 18This field contains the city of the ship-to customer's address.WH20.7
COR-SHIP-TO-STATE
SHIP_TO_STATE		Alpha 2This field contains the state or province of the ship-to customer's address.WH20.7
COR-SHIP-TO-ZIP
SHIP_TO_ZIP		Alpha 10This field contains the postal code of the ship-to customer's address.WH20.7
COR-SHIP-TO-CNTRY
SHIP_TO_CNTRY		Alpha 30 (Lower Case)This field contains the country of the ship-to customer's address.WH20.7
COR-SHIP-TO-COUNTY
SHIP_TO_COUNTY		Alpha 25 (Lower Case)The county for the company address.WH20.7
COR-HOLD-CODE
HOLD_CODE		Alpha 4This 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 +18 more
COR-HOLD-APR-FL
HOLD_APR_FL		Alpha 1This 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
INV_LOCATION		Alpha 5This 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
TERRITORY		Alpha 4This 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
SALESMAN		Numeric 4This 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
SALESMAN_2		Numeric 4This 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
COMM_SPLIT		Percent 5.3 (Percent)This field contains the commission split. This defaults from the customer file.WH20.7
COR-COMM-RATE-1
COMM_RATE_1		Percent 7.5 (Percent)Charge rate by month.WH20.7
COR-COMM-RATE-2
COMM_RATE_2		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
CHECK_NBR		Numeric 8This field contains the payment number. This is only valid with a down payment.WH20.7
COR-AUTH-REQUIRED
AUTH_REQUIRED		Alpha 1Flag 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
AUTH_APPROVED		Alpha 1Indicates whether authorization was approved by credit card service or not.—
COR-TERMS-CD
TERMS_CD		Alpha 5This 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
BANK_INST_CODE		Alpha 3A transaction code represents a type of cash payment, bill of exchange payment, or bank service transaction.WH20.7
COR-COD-FL
COD_FL		Alpha 1This 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
CIA_FL		Alpha 1This 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
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
ORD_DISC_CODE		Alpha 4This 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
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
ENTERED_PMNT		Signed 18.2This field contains the down payment amount entered in the order's currency.WH20.7
COR-MULT-PMNT
MULT_PMNT		DerivedThis 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
DIV_PMNT		DerivedThis 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
PMNT_BASE		DerivedThis field contains the amount of the payment in the company base currency.—
COR-NET-DUE-CURR
NET_DUE_CURR		DerivedThis field contains the total amount of the order minus the down payment valued in the order's original currency.—
COR-NET-DUE-BASE
NET_DUE_BASE		DerivedThis field contains the total amount in company base currency of the order minus the down payment.—
COR-PMNT-INVCED
PMNT_INVCED		Signed 18.2This 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
ENTERED_DISC		Signed 18.2This 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
MULT_DISC		DerivedThis field contains the base discount amount if a multiplier is used in its conversion.—
COR-DIV-DISC
DIV_DISC		DerivedThis field contains the base discount amount if a divider is used in its conversion.—
COR-DISC-BASE
DISC_BASE		DerivedThis field contains the amount of the discount in the company's base currency.—
COR-DISC-TKN-CURR
DISC_TKN_CURR		Signed 18.2This 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
MULT_DISC_TKN		DerivedThis 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
DIV_DISC_TKN		DerivedThis 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
DISC_TKN_BASE		DerivedThis field contains the amount of the additional discount taken on invoices of the order in the company base currency.—
COR-TAX-CODE
TAX_CODE		Alpha 10This 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
TAX_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
ORDER_SOURCE		Alpha 2This 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
FREIGHT_CODE		Alpha 2This 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
FRT_CHG_CURR		Signed 18.2This field contains the freight charge amount in billing currency.WH20.7
COR-FRT-TAXABLE-FL
FRT_TAXABLE_FL		Alpha 1Select Yes if freight is taxable.
  • Y Yes
  • N No
WH20.7
COR-MULT-FRT-CHG
MULT_FRT_CHG		DerivedThis 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
DIV_FRT_CHG		DerivedThis 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
FRT_CHG_BASE		DerivedThis field contains the freight charge amount in base currency.—
COR-ACTUAL-FRT-CHG
ACTUAL_FRT_CHG		Signed 18.2The 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
MULT_A_FRT_CHG		Derived——
COR-DIV-A-FRT-CHG
DIV_A_FRT_CHG		Derived——
COR-ACTUAL-FR-CH-B
ACTUAL_FR_CH_B		Derived——
COR-CARRIER
CARRIER		Alpha 9 (Right Justified)This field contains the carrier vendor number. Vendors are set up in Accounts Payable.WH20.7
COR-METHOD
METHOD		Alpha 10User-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
TRANS_ID		Alpha 20This 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
LIST_NAME		Alpha 14This 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
PK_PRIORITY		Numeric 2This 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
IMMEDIATE_FL		Alpha 1This 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
EDI_OE_FLAG		Alpha 1This 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
ACKNWLDG_FL		Alpha 1This 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
ACK_PRT_FL		Alpha 1This field indicates if an acknowledgment was printed to avoid duplicate printing of the document.
  • N No
  • Y Yes
WH20.7
COR-BACK-ORD-FL
BACK_ORD_FL		Alpha 1This 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
SHIP_COMP_FL		Alpha 1This field indicates whether partial shipments are allowed. This defaults from the customer's file. " " = Determined by Line
  • N No
  • Y Yes
WH20.7
COR-CREDIT-WF-FL
CREDIT_WF_FL		Alpha 1This 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 +17 more
COR-ACTIVITY
ACTIVITY		Alpha 15In 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
ACCT_CATEGORY		Alpha 5In 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
ACTIVITY_C		Alpha 15In 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
ACCT_CATEG_C		Alpha 5In 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
USER_DATE_1		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
USER_DATE_2		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
TRANS_USER1		Alpha 10This 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
TRANS_USER2		Alpha 15This field contains the second user-definable transaction field. This updates on the invoice in the Accounts Receivable file.WH20.7
COR-TRANS-USER3
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
TRANS_USER4		Numeric 9This field contains the fourth user-definable transaction field. This updates on the invoice in the Accounts Receivable file.WH20.7
COR-TRANS-USER5
TRANS_USER5		Signed 18.2This field contains the fifth user-definable transaction field. This updates on the invoice in the Accounts Receivable file.WH20.7
COR-CUBIC-FEET
CUBIC_FEET		Signed 9.3This field contains the total cubic feet of the items comprising this order.WH20.7
COR-WEIGHT
WEIGHT		Signed 9.3This field contains the total weight of this order.WH20.7
COR-LAST-LINE-NBR
LAST_LINE_NBR		Numeric 6This field contains the number of the last line item added to the order.WH20.7
COR-LAST-TP-SEQ
LAST_TP_SEQ		Numeric 3This field contains the last sequence number used for top comments.BLI2.1, WH20.7
COR-LAST-BM-SEQ
LAST_BM_SEQ		Numeric 3This field contains the last sequence number used for bottom comments.BLI2.1, WH20.7
COR-LAST-MISC-SEQ
LAST_MISC_SEQ		Numeric 3This field contains the last sequence number used for add-on charges.WH20.7
COR-SHIPMENT-NBR
SHIPMENT_NBR		Numeric 10This field contains the last shipment number used for this order.WH130, WH132, WH190, WH20.7, WH30.1, WH30.2, WH30.3, WH30.4 +18 more
COR-LST-IF-REF-NBR
LST_IF_REF_NBR		Numeric 6This field contains an internally generated reference number used by the Requisitions system.WH20.7
COR-SLS-QUOTE-FL
SLS_QUOTE_FL		Alpha 1This 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
FUTURE_FL		Alpha 1This 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
PK_PRT_FL		Alpha 1This field indicates whether a picking list has been printed for this order.
  • N No
  • Y Yes
WH20.7
COR-POD-REQ-FL
POD_REQ_FL		Alpha 1This 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
POD_GRACE_PER		Numeric 3This 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
CXL_DATE		Numeric 8 (yyyymmdd)This field contains the date the order was canceled.WH20.7
COR-CXL-OPR
CXL_OPR		Alpha 10 (Lower Case)This field contains the user ID of the person who canceled the order.WH20.7
COR-CXL-REASON
CXL_REASON		Alpha 4This field contains the cancellation reason code. This is passed to the Sales Analysis system for reporting.WH20.7
COR-SA-UPDATED-FL
SA_UPDATED_FL		Alpha 1This field indicates if this order has been booked in the Sales Analysis system.
  • Y Yes
  • N No
  • C Change
WH20.7
COR-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This 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
CURR_MUDV		Alpha 1This 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
CURR_RATE		Signed 14.7This field contains the currency conversion rate to base currency.WH20.7
COR-CURR-ND
CURR_ND		Numeric 1This field contains the number of decimals for the billing currency.WH20.2, WH20.7
COR-CURR-OVR-FL
CURR_OVR_FL		Alpha 1This field indicates whether you can override the currency for transactions on the customer's account.
  • Y Yes
  • N No
—
COR-RATE-FRZ-CD
RATE_FRZ_CD		Alpha 1This 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
OPEN_ORD_AMT		Signed 18.2This 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
OPEN_ORD_CURR		Signed 18.2This 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
PASS_ORD_AMT		Signed 18.2This 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
INV_GDS_CURR		Signed 18.2This field contains the amount of inventoried goods for this order in billing currency.WH130, WH132, WH190, WH20.7, WH520, WH830
COR-INV-GDS-BASE
INV_GDS_BASE		Signed 18.2This field contains the amount of inventoried goods for this order in base currency.WH130, WH132, WH190, WH20.7, WH520, WH830
COR-NI-GDS-CURR
NI_GDS_CURR		Signed 18.2This 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
NI_GDS_BASE		Signed 18.2This 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
GDS_TTL_CURR		DerivedThis field contains the total goods amount for this order in billing currency.—
COR-GDS-TTL-BASE
GDS_TTL_BASE		DerivedThis field contains the total goods amount for this order in base currency.—
COR-MISC-TTL-CURR
MISC_TTL_CURR		Signed 18.2This field contains the total of add-on charges for this order in billing currency.WH20.7
COR-MULT-MISC-TTL
MULT_MISC_TTL		DerivedThis 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
DIV_MISC_TTL		DerivedThis 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
MISC_TTL_BASE		DerivedThis field contains the total amount of add-on charges in base currency.—
COR-DISCNTBL-CURR
DISCNTBL_CURR		Signed 18.2This 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
MULT_DISCNTBL		DerivedThis 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
DIV_DISCNTBL		DerivedThis 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
DISCNTBL_BASE		DerivedThis field contains the total discountable amount of the order in base currency.—
COR-ORD-DISC-CURR
ORD_DISC_CURR		Signed 18.2This 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
MULT_ORD_DISC		DerivedThis 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
DIV_ORD_DISC		DerivedThis 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
ORD_DISC_BASE		DerivedThis field contains the total amount of the order discount in the company base currency.—
COR-TXBL-TTL-CURR
TXBL_TTL_CURR		Signed 18.2This field contains the taxable amount for this order in billing currency.WH20.7
COR-MULT-TXBL-TTL
MULT_TXBL_TTL		DerivedThis 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
DIV_TXBL_TTL		DerivedThis 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
TXBL_TTL_BASE		DerivedThis field contains the taxable amount for this order in the company base currency.—
COR-TAX-TTL-CURR
TAX_TTL_CURR		Signed 18.2This field contains the total amount of tax on the order in original billing currency.WH20.7
COR-MULT-TAX-TTL
MULT_TAX_TTL		DerivedThis 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
DIV_TAX_TTL		DerivedThis 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
TAX_TTL_BASE		DerivedThis field contains the total amount of tax on the order in base currency.—
COR-ORD-GRS-BASE
ORD_GRS_BASE		DerivedThis field contains the total gross amount of the order in base currency.—
COR-ORD-GRS-CURR
ORD_GRS_CURR		DerivedThis field contains the total gross amount of the order in original billing currency.—
COR-ORDER-NET
ORDER_NET		DerivedThis field contains the total of line net amounts plus add-on charges minus order discounts.—
COR-ORD-NET-BASE
ORD_NET_BASE		DerivedThis field contains the total of line net amounts and add-on charges minus order discounts in base currency.—
COR-ORD-NET-CURR
ORD_NET_CURR		DerivedThis 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
HOLD_LIT		DerivedThis field contains the hold code.—
COR-TERMS-1
TERMS_1		DerivedThis field contains the description of the first credit card terms table.—
COR-TERM-2
TERM_2		DerivedThis field contains the description of the second credit card terms table.—
COR-ORDER-NBR-A
ORDER_NBR_A		DerivedThis field is used internally to create relationships.—
COR-ORDER-ZERO
ORDER_ZERO		DerivedThis field is used internally to create relationships—
COR-COMM-LIT
COMM_LIT		DerivedIf comments are attached, this field displays "comments exist."—
COR-WF-CO-ORDR-NBR
WF_CO_ORDR_NBR		Derived——
COR-INTRASTAT-NBR
INTRASTAT_NBR		Numeric 12The number assigned by the Intrastat system to a transaction that involves Intrastat reporting after it has been added.WH20.7
COR-BILL-CNTRY-CD
BILL_CNTRY_CD		Alpha 2The Bill-To country code; must be defined in IN01.1 (Country Maintenance).WH20.7
COR-BILL-REGION
BILL_REGION		Alpha 2The Bill-To region code. Must be a valid region for the country, defined in IN02.1 (Region Maintenance).WH20.7
COR-TO-CNTRY-CD
TO_CNTRY_CD		Alpha 2The Ship-To country code. Must be defined in IN01.1 (Country Maintenaance).WH20.7
COR-SHIP-TO-REGION
SHIP_TO_REGION		Alpha 2The ship-to region code. Must be a valid region for the country, defined in IN02.1 (Region Maintenance).WH20.7
COR-ORDER-REF-NBR
ORDER_REF_NBR		Numeric 8This field contains the order reference number. This number can be filled with extra order number information.—
COR-REF-NBR-FLAG
REF_NBR_FLAG		Alpha 1This 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
REQ_EP_AUTH		Alpha 1——
COR-EP-AMT-CURR
EP_AMT_CURR		Signed 18.2—WH20.7
COR-EP-AMT-BASE
EP_AMT_BASE		Signed 18.2—WH20.7
COR-EP-SETTLE-AMT
EP_SETTLE_AMT		Signed 18.2—WH20.7
COR-EP-TRANS-ID
EP_TRANS_ID		Numeric 12—WH20.7
COR-EP-TYPE
EP_TYPE		Alpha 5—WH20.7
COR-EP-ACCOUNT
EP_ACCOUNT		Alpha 32—WH20.7
COR-EP-EXP-DATE
EP_EXP_DATE		Numeric 8 (yyyymmdd)—WH20.7
COR-EP-MARGIN-MIN
EP_MARGIN_MIN		Signed 7.2—WH20.7
COR-EP-MARGIN-PCT
EP_MARGIN_PCT		Percent 8.5 (Percent)—WH20.7
COR-ORDER-TTL-CURR
ORDER_TTL_CURR		Signed 18.2——
COR-ORDER-TTL-BASE
ORDER_TTL_BASE		Signed 18.2——
COR-BILL-EC-CTRY
BILL_EC_CTRY		Numeric 3—WH20.7
COR-BILL-ISO-CTRY
BILL_ISO_CTRY		Numeric 3—WH20.7
COR-TO-EC-CTRY
TO_EC_CTRY		Numeric 3—WH20.7
COR-TO-ISO-CTRY
TO_ISO_CTRY		Numeric 3—WH20.7
COR-NOTC
NOTC		Alpha 2The Nature of Transaction code. Must be a valid code defined in IN07.1 (NOTC Maintenance).WH20.7
COR-STAT-PROC
STAT_PROC		Alpha 6The statistical procedure code applied to the data. The code must be defined in IN06.1. (Statistical Procedure Maintenance).WH20.7
COR-VAT-REG-NBR
VAT_REG_NBR		Alpha 12The 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
GLBL_DOC_TYPE		Alpha 10—WH20.7
COR-FREIGHT-TOT
FREIGHT_TOT		Signed 18.2—WH20.7
COR-INSURANCE-TOT
INSURANCE_TOT		Signed 18.2—WH20.7
COR-CSTMS-TOT
CSTMS_TOT		Signed 18.2—WH20.7
COR-OTHER-AOC-TOT
OTHER_AOC_TOT		Signed 18.2—WH20.7

Indexes (11)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CORSET1COMPANY, ORDER-NBRPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
CORSET10COMPANY, ORDER-NBRSubsetWhere SA-UPDATED-FL != "Y" And STATUS > 1—
CORSET11COMPANY, ORDER-NBR*—
CORSET12COMPANY, CUSTOMER, ORDER-NBR*—
CORSET13COMPANY, TRANS-USER1, ORDER-NBR*—
CORSET2COMPANY, CUSTOMER, ORDER-NBRAR08.1, AR10.1, AR501, AR550, WH20.2, WH20.7
CORSET3COMPANY, CUST-PO-NBR, ORDER-NBRKeyChange—
CORSET5COMPANY, OPR-CODE, ORDER-NBR—
CORSET6COMPANY, CUSTOMER, HOLD-CODE, ORDER-NBRKeyChange, SubsetWhere HOLD-CODE != SpacesCB191
CORSET7COMPANY, HOLD-CODE, ORDER-NBRKeyChange—
CORSET8COMPANY, ORDER-DATE, ORDER-NBRKeyChange—

Relations

One to one (34) — lookups and parents

RelationTableRulesConditionField map
ApcompanyAPCOMPANYRequiredWhen COR-CARRIER != SpacesCOR-COMPANY → CPY-COMPANY
ApvenmastAPVENMASTRequiredWhen COR-CARRIER != SpacesCPY-VENDOR-GROUP → VEN-VENDOR-GROUP, COR-CARRIER → VEN-VENDOR
ArcompARCOMPRequiredCOR-COMPANY → ACO-COMPANY
ArcustomerARCUSTOMERRequiredCOR-COMPANY → ACM-COMPANY, COR-CUSTOMER → ACM-CUSTOMER
BilltoBILLTONot RequiredValid When COR-BILL-TO != ZeroesACO-CUST-GROUP → ABS-CUST-GROUP, COR-CUSTOMER → ABS-CUSTOMER, COR-BILL-TO → ABS-BILL-TO
CosgblkCOSGBLKNot RequiredCOR-COMPANY → OSG-COMPANY, COR-ORDER-NBR → OSG-ORDER-NBR, Zeroes → OSG-LINE-NBR, Zeroes → OSG-SEQ
CucodesCUCODESRequiredWhen COR-CURRENCY-CODE != COR-CURRENCY-CODECOR-CURRENCY-CODE → CUC-CURRENCY-CODE
CurelatCURELATNot RequiredGLS-CURRENCY-TABLE → CRL-CURRENCY-TABLE, COR-CURRENCY-CODE → CRL-FR-CURR-CODE, OEC-CURRENCY-CODE → CRL-TO-CURR-CODE
CustdescCUSTDESCRequiredACO-CUST-GROUP → CUD-CUST-GROUP, COR-CUSTOMER → CUD-CUSTOMER
Cxl OperatorOPERATORNot RequiredValid When COR-CXL-REASON != SpacesCOR-CXL-OPR → OPE-OPR-CODE, COR-COMPANY → OPE-DEF-COMPANY
GlsystemGLSYSTEMRequiredCOR-COMPANY → GLS-COMPANY
HoldcodesHOLDCODESRequiredWhen COR-HOLD-CODE != SpacesACO-CUST-GROUP → HDD-CUST-GROUP, COR-HOLD-CODE → HDD-HOLD-CODE
IccompanyICCOMPANYRequiredCOR-COMPANY → ICC-COMPANY
IclocationICLOCATIONRequiredWhen COR-INV-LOCATION != SpacesCOR-COMPANY → ICL-COMPANY, COR-INV-LOCATION → ICL-LOCATION
OecompanyOECOMPANYRequiredCOR-COMPANY → OEC-COMPANY
OecorufOECORUFRequiredCOR-COMPANY → OCU-COMPANY, COR-ORDER-NBR → OCU-ORDER-NBR
OecustOECUSTRequiredCOR-COMPANY → OET-COMPANY, COR-CUSTOMER → OET-CUSTOMER
OefrtcodeOEFRTCODERequiredWhen COR-FREIGHT-CODE != SpacesCOR-COMPANY → OFR-COMPANY, COR-FREIGHT-CODE → OFR-FRT-CODE
OemethodOEMETHODRequiredWhen COR-METHOD != SpacesCOR-COMPANY → OMT-COMPANY, COR-METHOD → OMT-METHOD
OeorddiscOEORDDISCRequiredWhen COR-ORD-DISC-CODE > SpacesCOR-COMPANY → OOD-COMPANY, COR-ORD-DISC-CODE → OOD-ORD-DISC-CODE, COR-CURRENCY-CODE → OOD-CURRENCY-CODE
OeprclistOEPRCLISTRequiredCOR-COMPANY → OPL-COMPANY, Spaces → OPL-CUSTOMER, COR-LIST-NAME → OPL-LIST-NAME, Spaces → OPL-PROMOTION
OeproclevOEPROCLEVRequiredCOR-COMPANY → OEP-COMPANY, COR-PROCESS-LEVEL → OEP-PROCESS-LEVEL
OereasonOEREASONRequiredWhen COR-CXL-REASON != SpacesCOR-COMPANY → OER-COMPANY, COR-CXL-REASON → OER-REASON-CODE
OesourceOESOURCERequiredWhen COR-ORDER-SOURCE != SpacesCOR-COMPANY → OSR-COMPANY, COR-ORDER-SOURCE → OSR-ORDER-SOURCE
OperatorOPERATORRequiredCOR-COMPANY → OPE-DEF-COMPANY, COR-OPR-CODE → OPE-OPR-CODE
OrdertypeORDERTYPERequiredCOR-COMPANY → OTP-COMPANY, COR-ORDER-TYPE → OTP-ORDER-TYPE
SalesmanSALESREPRequiredCOR-COMPANY → SAW-COMPANY, COR-SALESMAN → SAW-SALESMAN
Salesman2SALESREPRequiredWhen COR-SALESMAN-2 != ZeroesCOR-COMPANY → SAW-COMPANY, COR-SALESMAN-2 → SAW-SALESMAN
ShiptoSHIPTORequiredWhen COR-SHIP-TO != ZeroesCOR-COMPANY → SHP-COMPANY, COR-CUSTOMER → SHP-CUSTOMER, COR-SHIP-TO → SHP-SHIP-TO
TeritoryTERITORYRequiredWhen COR-TERRITORY != SpacesCOR-COMPANY → TRY-COMPANY, COR-TERRITORY → TRY-TERRITORY
TermsTERMSNot RequiredCOR-TERMS-CD → TMS-TERMS-CD
TxcodemastTXCODEMASTNot RequiredCOR-TAX-CODE → TCM-TAX-CODE
TxtaxcodeTXTAXCODERequiredWhen COR-TAX-CODE != SpacesCOR-COMPANY → TAC-COMPANY, COR-TAX-CODE → TAC-TAX-CODE
WhdemndhdrWHDEMNDHDRNot RequiredCOR-COMPANY → WDH-COMPANY, "OE" → WDH-SYSTEM-CD, COR-ORDER-NBR → WDH-DOC-NBR-NUM

One to many (15) — child tables

RelationTableRulesConditionField map
All ComiscCOMISCCOR-COMPANY → CMC-COMPANY, COR-ORDER-NBR → CMC-ORDER-NBR, → CMC-LINE-NBR, → CMC-SEQ
ColineCOLINEDelete RestrictedCOR-COMPANY → COL-COMPANY, COR-ORDER-NBR → COL-ORDER-NBR, → COL-LINE-NBR
ComiscCOMISCCOR-COMPANY → CMC-COMPANY, COR-ORDER-NBR → CMC-ORDER-NBR, Zeroes → CMC-LINE-NBR, → CMC-SEQ
CustorderCUSTORDERCOR-COMPANY → COR-COMPANY, COR-CUSTOMER → COR-CUSTOMER, → COR-ORDER-NBR
Hdr CommentsOEORDCMNTCOR-COMPANY → OOC-COMPANY, Spaces → OOC-CUSTOMER, Spaces → OOC-STD-ORDER-NBR, COR-ORDER-NBR → OOC-ORDER-NBR, Zeroes → OOC-LINE-NBR, → OOC-SEQ
IcgenericICGENERICICC-ITEM-GROUP → ICG-ITEM-GROUP, → ICG-GENERIC
MajorclMAJORCLICC-ITEM-GROUP → MAJ-ITEM-GROUP, "S" → MAJ-CLASS-TYPE, → MAJ-MAJOR-CLASS
MinorclMINORCLICC-ITEM-GROUP → MIN-ITEM-GROUP, "S" → MIN-CLASS-TYPE, → MIN-MAJOR-CLASS, → MIN-MINOR-CLASS
OeauditOEAUDITDelete CascadesCOR-COMPANY → OEA-COMPANY, COR-ORDER-NBR → OEA-ORDER-NBR, Zeroes → OEA-LINE-NBR, → OEA-FLD-NBR, → OEA-UPDATE-DATE, → OEA-UPDATE-TIME
OediscountOEDISCOUNTCOR-COMPANY → OED-COMPANY, → OED-DISC-CODE
OeinvoiceOEINVOICEDelete RestrictedCOR-COMPANY → OEI-COMPANY, COR-ORDER-NBR → OEI-ORDER-NBR, → OEI-SHIPMENT-NBR, → OEI-INVC-PREFIX, → OEI-INVC-NUMBER
Oeorddisc2OEORDDISCCOR-COMPANY → OOD-COMPANY, → OOD-ORD-DISC-CODE, → OOD-CURRENCY-CODE
PolinesrcPOLINESRCCOR-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 CommentsOEORDCMNTCOR-COMPANY → OOC-COMPANY, Spaces → OOC-CUSTOMER, Spaces → OOC-STD-ORDER-NBR, COR-ORDER-NBR → OOC-ORDER-NBR, 999999 → OOC-LINE-NBR, → OOC-SEQ
WhshipmentWHSHIPMENTCOR-COMPANY → WHS-COMPANY, "OE" → WHS-SYSTEM-CD, WDH-DOC-NBR → WHS-DOC-NBR, → WHS-SHIPMENT-NBR, → WHS-LOCATION

Programs

Updated by (35)

Referenced by (210)