CUSTORDER

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 API2.1
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1 PO136
PO190 PO300 PO520 POCP.1 POI3.1 POII.1
POIJ.1


UPDATED BY
AR08.1 AR10.1 AR501 AR550 CB191

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.
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.
COR-STATUS
Element: Status
Numeric 1
This field contains the status of the order.
1 = Unreleased
2 = Released
8 = Canceled
9 = Ready for purge
COR-PROCESS-LEVEL
Element: Process Level
Alpha 5
This field contains the process level, which is the reporting hierarchy below company.
COR-ORDER-TYPE
Element: Order Type
Alpha 2
This field contains the order type.
COR-ORDER-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field contains the date of the order. The system date defaults.
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.
COR-OPR-CODE
Element: Opr Code
Alpha 10 (Lower Case)
This field contains the user ID, which is required for each order.
COR-CHG-OPR
Element: Requester
Alpha 10 (Lower Case)
This field contains the user ID of the last operator to maintain this order.
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.
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.
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.
COR-BILL-TO
Element: Bill To
Numeric 4
This field contains the bill-to customer number.
COR-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
This field contains the number that represents a customer.
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.
COR-BILL-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of the bill-to customer's address.
COR-BILL-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
This field contains the second line of the bill-to customer's address.
COR-BILL-ADDR3
Element: Addr1
Alpha 30 (Lower Case)
This field contains the third line of the bill-to customer's address.
COR-BILL-ADDR4
Element: Addr1
Alpha 30 (Lower Case)
This field contains the fourth line of the bill-to customer's address.
COR-BILL-CITY
Element: Bill City
Alpha 18
This field contains the city of the bill-to customer's address.
COR-BILL-STATE
Element: State Prov
Alpha 2
This field contains the state or province of the bill-to customer's address.
COR-BILL-ZIP
Element: Zip
Alpha 10
This field contains the postal code of the bill-to customer's address.
COR-BILL-CNTRY
Element: Country
Alpha 30 (Lower Case)
This field contains the country of the bill-to customer's address.
COR-BILL-COUNTY
Element: County
Alpha 25 (Lower Case)
The county for the company address.
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.
COR-RQST-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field contains the customer's requested delivery date. If left blank, the system date defaults.
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.
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.
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
COR-SHIP-TO
Element: Ship To
Numeric 4
This field contains the ship-to customer's number.
COR-SHIP-TO-NAME
Element: Name
Alpha 30 (Lower Case)
This field contains the name of the-ship-to customer.
COR-SHIP-TO-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of the ship-to customer's address.
COR-SHIP-TO-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
This field contains the second line of the ship-to customer's address.
COR-SHIP-TO-ADDR3
Element: Addr1
Alpha 30 (Lower Case)
This field contains the third line of the ship-to customer's address.
COR-SHIP-TO-ADDR4
Element: Addr1
Alpha 30 (Lower Case)
This field contains the fourth line of the ship-to customer's address.
COR-SHIP-TO-CITY
Element: Bill City
Alpha 18
This field contains the city of the ship-to customer's address.
COR-SHIP-TO-STATE
Element: State Prov
Alpha 2
This field contains the state or province of the ship-to customer's address.
COR-SHIP-TO-ZIP
Element: Zip
Alpha 10
This field contains the postal code of the ship-to customer's address.
COR-SHIP-TO-CNTRY
Element: Country
Alpha 30 (Lower Case)
This field contains the country of the ship-to customer's address.
COR-SHIP-TO-COUNTY
Element: County
Alpha 25 (Lower Case)
The county for the company address.
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.
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
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.
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.
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.
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.
COR-COMM-SPLIT
Element: Comm Split
Percent 5.3 (Percent)
This field contains the commission split. This defaults from the customer file.
COR-COMM-RATE-1
Element: Chrg Rate
Percent 7.5 (Percent)
Charge rate by month.
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.
COR-CHECK-NBR
Element: Check Nbr
Numeric 8
This field contains the payment number. This is only valid with a down payment.
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.
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.
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
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
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.
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.
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.
COR-ENTERED-PMNT
Element: Intl Amt
Signed 18.2
This field contains the down payment amount entered in the order's currency.
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.
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.
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.
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.
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.
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).
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.
COR-FRT-CHG-CURR
Element: Intl Amt
Signed 18.2
This field contains the freight charge amount in billing currency.
COR-FRT-TAXABLE-FL
Element: All Flag
Alpha 1
Select Yes if freight is taxable.
Y = Yes
N = No
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).
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.
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.
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.
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.
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.
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
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
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
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
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
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
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
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.
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.
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.
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.
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).
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).
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.
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.
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.
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.
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.
COR-CUBIC-FEET
Element: Cubic Feet
Signed 9.3
This field contains the total cubic feet of the items comprising this order.
COR-WEIGHT
Element: Weight
Signed 9.3
This field contains the total weight of this order.
COR-LAST-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the number of the last line item added to the order.
COR-LAST-TP-SEQ
Element: Seq
Numeric 3
This field contains the last sequence number used for top comments.
COR-LAST-BM-SEQ
Element: Seq
Numeric 3
This field contains the last sequence number used for bottom comments.
COR-LAST-MISC-SEQ
Element: Seq
Numeric 3
This field contains the last sequence number used for add-on charges.
COR-SHIPMENT-NBR
Element: Shipment Nbr
Numeric 10
This field contains the last shipment number used for this order.
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.
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
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
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
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
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.
COR-CXL-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field contains the date the order was canceled.
COR-CXL-OPR
Element: Requester
Alpha 10 (Lower Case)
This field contains the user ID of the person who canceled the order.
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.
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
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.
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
COR-CURR-RATE
Element: Curr Rate
Signed 14.7
This field contains the currency conversion rate to base currency.
COR-CURR-ND
Element: Acct Nd
Numeric 1
This field contains the number of decimals for the billing currency.
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
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.
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.
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.
COR-INV-GDS-CURR
Element: Intl Amt
Signed 18.2
This field contains the amount of inventoried goods for this order in billing currency.
COR-INV-GDS-BASE
Element: Intl Amt
Signed 18.2
This field contains the amount of inventoried goods for this order in base currency.
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.
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.
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.
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.
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.
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.
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.
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.
COR-BILL-CNTRY-CD
Element: Bill Cntry Cd
Alpha 2
The Bill-To country code; must be defined in IN01.1 (Country Maintenance).
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).
COR-TO-CNTRY-CD
Element: To Cntry Cd
Alpha 2
The Ship-To country code. Must be defined in IN01.1 (Country Maintenaance).
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).
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
COR-EP-AMT-BASE
Element: Intl Amt
Signed 18.2
COR-EP-SETTLE-AMT
Element: Intl Amt
Signed 18.2
COR-EP-TRANS-ID
Element: Ep Trans Id
Numeric 12
COR-EP-TYPE
Element: Ep Type
Alpha 5
COR-EP-ACCOUNT
Element: Ep Account
Alpha 32
COR-EP-EXP-DATE
Element: Ep Exp Date
Numeric 8 (yyyymmdd)
COR-EP-MARGIN-MIN
Element: Ep Margin Min
Signed 7.2
COR-EP-MARGIN-PCT
Element: Ep Margin Pct
Percent 8.5 (Percent)
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
COR-BILL-ISO-CTRY
Element: Bill Iso Ctry
Numeric 3
COR-TO-EC-CTRY
Element: To Ec Ctry
Numeric 3
COR-TO-ISO-CTRY
Element: To Iso Ctry
Numeric 3
COR-NOTC
Element: Notc
Alpha 2
The Nature of Transaction code. Must be a valid code defined in IN07.1 (NOTC Maintenance).
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).
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.


CUSTORDER FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CORSET1 COMPANY
ORDER-NBR
...
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
CORSET10 COMPANY
ORDER-NBR
Subset
WhereSA-UPDATED-FL !="Y"
AndSTATUS >1
CORSET11 COMPANY
ORDER-NBR*
CORSET12 COMPANY
CUSTOMER
ORDER-NBR*
CORSET13 COMPANY
TRANS-USER1
ORDER-NBR*
CORSET2 COMPANY
CUSTOMER
ORDER-NBR
AR08.1 AR10.1
AR501 AR550
CORSET3 COMPANY
CUST-PO-NBR
ORDER-NBR
KeyChange
CORSET5 COMPANY
OPR-CODE
ORDER-NBR
CORSET6 COMPANY
CUSTOMER
HOLD-CODE
ORDER-NBR
KeyChange, Subset
WhereHOLD-CODE !=Spaces
CB191
CORSET7 COMPANY
HOLD-CODE
ORDER-NBR
KeyChange
CORSET8 COMPANY
ORDER-DATE
ORDER-NBR
KeyChange


CUSTORDER FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
When COR-CARRIER !=Spaces
COR-COMPANY->CPY-COMPANY
Apvenmast APVENMAST Required
When COR-CARRIER !=Spaces
CPY-VENDOR-GROUP->VEN-VENDOR-GROUP
COR-CARRIER->VEN-VENDOR
Arcomp ARCOMP Required
COR-COMPANY->ACO-COMPANY
Arcustomer ARCUSTOMER Required
COR-COMPANY->ACM-COMPANY
COR-CUSTOMER->ACM-CUSTOMER
Billto BILLTO Not Required
Valid When COR-BILL-TO !=Zeroes
ACO-CUST-GROUP->ABS-CUST-GROUP
COR-CUSTOMER->ABS-CUSTOMER
COR-BILL-TO->ABS-BILL-TO
Cosgblk COSGBLK Not Required
COR-COMPANY->OSG-COMPANY
COR-ORDER-NBR->OSG-ORDER-NBR
Zeroes->OSG-LINE-NBR
Zeroes->OSG-SEQ
Cucodes CUCODES Required
When COR-CURRENCY-CODE !=COR-CURRENCY-CODE
COR-CURRENCY-CODE->CUC-CURRENCY-CODE
Curelat CURELAT Not Required
GLS-CURRENCY-TABLE->CRL-CURRENCY-TABLE
COR-CURRENCY-CODE->CRL-FR-CURR-CODE
OEC-CURRENCY-CODE->CRL-TO-CURR-CODE
Custdesc CUSTDESC Required
ACO-CUST-GROUP->CUD-CUST-GROUP
COR-CUSTOMER->CUD-CUSTOMER
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
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
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Coline COLINE Delete Restricted
COR-COMPANY->COL-COMPANY
COR-ORDER-NBR->COL-ORDER-NBR
  COL-LINE-NBR
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
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
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


File created: Wed Jun 08 20:50:17 2016

Home
Contact Us



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