CUSTORDER FILE
Customer Order File
This file contains a record for every order entered in the Lawson Order Entry
system. This is the order header record for which any lines on the order are
kept in the Customer Order Line file.
REFERENCED BY
AR21.6 AR21.1 AR21.2 AR21.3 BL00.1 BL121
BL123 BL291 BL80.1 BL80.4 BL91.1 CXCP.1
DR100 IC141 IC142 IC83.1 POIJ.1 RQ11.1
RQ12.1 RQ13.1 WH110 WH120 WH126 WH140
WH21.1 WH21.2 WH21.3 WH21.4 WH210 WH22.1
WH224 AR08.1 AR501 AR550 AR115 AR124
AR20.1 AR24.1 AR30.1 AR30.2 AR30.4 AR570
AR575 AR580 CB191
UPDATED BY
BLI2.1 WH130 WH33.5 WH34.1 WH34.2 WH34.3
WH34.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
COR-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
COR-ORDER-NBR Numeric 8
Order Number Each order is assigned a unique number.
Order numbers are either manually
assigned or system assigned based on a
company-level option.
COR-STATUS Numeric 1
Status This field contains the status of the
order.
1 = Unreleased
2 = Released
8 = Canceled
9 = Ready for purge
COR-PROCESS-LEVEL Alpha 5
Process Level This field contains the process level,
which is the reporting hierarchy below
company.
COR-ORDER-TYPE Alpha 2
Order Type Code This field contains the order type.
COR-ORDER-DATE Numeric 8 (yyyymmdd)
Order Date This field contains the date of the
order. The system date defaults.
COR-PRICE-DATE Numeric 8 (yyyymmdd)
Price Date 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 Alpha 10 (Lower Case)
Operator Code This field contains the user ID, which
is required for each order.
COR-CHG-OPR Alpha 10 (Lower Case)
Chg Opr This field contains the user ID of the
last operator to maintain this order.
COR-CRED-OPR Alpha 10 (Lower Case)
Cred Opr This field contains the user ID of the
person who released the order from
credit hold.
COR-CUST-PO-NBR Alpha 22
Customer P.O. Number 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 Alpha 20
Letter of Credit 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 Numeric 4
Bill To This field contains the bill-to
customer number.
COR-CUSTOMER Alpha 9 (Right Justified)
Customer Number This field contains the number that
represents a customer.
COR-BILL-NAME Alpha 30 (Lower Case)
Billing Name This field contains the bill-to
customer's name. This defaults from the
customer file, but can be overridden.
COR-BILL-ADDR1 Alpha 30 (Lower Case)
Billing Address One This field contains the first line of
the bill-to customer's address.
COR-BILL-ADDR2 Alpha 30 (Lower Case)
Billing Address Two This field contains the second line of
the bill-to customer's address.
COR-BILL-ADDR3 Alpha 30 (Lower Case)
Bill Addr3 This field contains the third line of
the bill-to customer's address.
COR-BILL-ADDR4 Alpha 30 (Lower Case)
Bill Addr4 This field contains the fourth line of
the bill-to customer's address.
COR-BILL-CITY Alpha 18
Billing City This field contains the city of the
bill-to customer's address.
COR-BILL-STATE Alpha 2
Billing State This field contains the state or
province of the bill-to customer's
address.
COR-BILL-ZIP Alpha 10
Billing Zip Code This field contains the postal code of
the bill-to customer's address.
COR-BILL-CNTRY Alpha 30 (Lower Case)
Billing County This field contains the country of the
bill-to customer's address.
COR-BILL-COUNTY Alpha 25 (Lower Case)
Bill County
COR-EXP-SHIP-DT Numeric 8 (yyyymmdd)
Expected Ship Date 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 Numeric 8 (yyyymmdd)
Request Date This field contains the customer's
requested delivery date. If left blank,
the system date defaults.
COR-USER-ID-RLS Alpha 3
User Id Rls 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 Alpha 3
User Id Entry This field contains the user ID of the
person who entered this order at the
customer's site.
COR-TAX-EXEMPT-CD Alpha 1
Tax Exempt Code 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 Numeric 4
Ship-to Code This field contains the ship-to
customer's number.
COR-SHIP-TO-NAME Alpha 30 (Lower Case)
Ship-to Name This field contains the name of
the-ship-to customer.
COR-SHIP-TO-ADDR1 Alpha 30 (Lower Case)
Ship-to Address This field contains the first line of
Line 1 the ship-to customer's address.
COR-SHIP-TO-ADDR2 Alpha 30 (Lower Case)
Ship-to Address This field contains the second line of
Line 2 the ship-to customer's address.
COR-SHIP-TO-ADDR3 Alpha 30 (Lower Case)
Ship To Addr3 This field contains the third line of
the ship-to customer's address.
COR-SHIP-TO-ADDR4 Alpha 30 (Lower Case)
Ship To Addr4 This field contains the fourth line of
the ship-to customer's address.
COR-SHIP-TO-CITY Alpha 18
Ship-to City This field contains the city of the
ship-to customer's address.
COR-SHIP-TO-STATE Alpha 2
Ship-to State or This field contains the state or
Province province of the ship-to customer's
address.
COR-SHIP-TO-ZIP Alpha 10
Ship-to Postal Code This field contains the postal code of
the ship-to customer's address.
COR-SHIP-TO-CNTRY Alpha 30 (Lower Case)
Ship-to Country This field contains the country of the
ship-to customer's address.
COR-SHIP-TO-COUNTY Alpha 25 (Lower Case)
Ship To County
COR-HOLD-CODE Alpha 4 WH130 WH33.5
Hold Code This field contains the hold code. If WH34.1 WH34.2
this field is not blank, processing for WH34.3 WH34.4
the order is suspended. You can take an
order off hold by clearing its hold code
field.
COR-HOLD-APR-FL Alpha 1
Hold Apr Fl 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 Alpha 5
Inventory Location This field contains the location from
which inventory is taken. If the item
ordered is nonstock, the inventory
location is used for reporting purposes.
COR-TERRITORY Alpha 4
Sales Territory 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 Numeric 4
Salesman Number 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 Numeric 4
Salesman Number 2 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 Percent 5.3 (Percent)
Commission Split This field contains the commission
Percentage split. This defaults from the customer
file.
COR-COMM-RATE-1 Percent 7.5 (Percent)
Commission Rate for This field contains the commission rate
Slsmn 1 of the primary sales representative.
This defaults from the sales
representative's file.
COR-COMM-RATE-2 Percent 7.5 (Percent)
Commission Rate for This field contains the commission rate
Slsmn 2 for the second sales representative.
This defaults from the sales
representative's file.
COR-CHECK-NBR Numeric 8
Payment Number This field contains the payment number.
This is only valid with a down payment.
COR-AUTH-REQUIRED Alpha 1
Auth Required Flag indicating that explicit
authorization must be received from
credit card service, prior to resulting
line items being printed on pick list.
Y = Yes
N = No
COR-AUTH-APPROVED Alpha 1
Auth Approved Indicates whether authorization was
approved by credit card service or not.
COR-TERMS-CD Alpha 5
Terms Code This field contains the payment terms
code. This defaults from the customer's
file. Terms codes are set up in the
Terms system.
COR-BANK-INST-CODE Alpha 3
Transaction Code A transaction code represents a type of
cash payment, bill of exchange payment,
or bank service transaction.
COR-COD-FL Alpha 1 BL121 BL91.1
Cod Fl 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 Alpha 1
Cash In Advance Flag 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 Percent 8.5 (Percent)
Cash In Advance This field contains the cash in advance
Percent percentage, which is used to determine
the down payment amount of the total
order value.
COR-ORD-DISC-CODE Alpha 4
Order Discount Code 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 Percent 5.2 (Percent)
Percent This field contains the order discount
percent for which this order qualifies
based on the total value of the order.
COR-ENTERED-PMNT Signed 15.2
Entered Pmnt This field contains the down payment
amount entered in the order's currency.
COR-MULT-PMNT Derived
Mult Pmnt This field indicates what the base
payment amount is if a multiplier is
used when converting the payment from
foreign to base currency.
COR-DIV-PMNT Derived
Div Pmnt This field indicates what the base
payment amount is if a divider is used
when converting the payment from foreign
to company base currency.
COR-PMNT-BASE Derived
Pmnt Base This field contains the amount of the
payment in the company base currency.
COR-NET-DUE-CURR Derived
Net Due Curr This field contains the total amount of
the order minus the down payment valued
in the order's original currency.
COR-NET-DUE-BASE Derived
Net Due Base This field contains the total amount in
company base currency of the order minus
the down payment.
COR-PMNT-INVCED Signed 15.2
Pmnt Invced 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 Signed 15.2
Entered Disc This field contains the additional
discount amount entered on the order in
the original currency in which the order
was placed.
COR-MULT-DISC Derived
Mult Disc This field contains the base discount
amount if a multiplier is used in its
conversion.
COR-DIV-DISC Derived
Div Disc This field contains the base discount
amount if a divider is used in its
conversion.
COR-DISC-BASE Derived
Disc Base This field contains the amount of the
discount in the company's base currency.
COR-DISC-TKN-CURR Signed 15.2
Disc Tkn Curr 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 Derived
Mult Disc Tkn This field contains the amount of
additional discounts for this order in
base currency if a multiplier is used
when converting the discount amount.
COR-DIV-DISC-TKN Derived
Div Disc Tkn This field contains the amount of the
additional discount taken from the order
in the base currency if a divider is
used when converting the discount.
COR-DISC-TKN-BASE Derived
Disc Tkn Base This field contains the amount of the
additional discount taken on invoices of
the order in the company base currency.
COR-TAX-CODE Alpha 10
Tax Code 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 Numeric 8 (yyyymmdd)
Tax Date 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 Alpha 2
Order Source 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 OE52.1
(Order Source).
COR-FREIGHT-CODE Alpha 2 BL80.1 WH130
Freight Code This field contains the freight code, WH33.5 WH34.1
which determines if carrier and freight WH34.2 WH34.3
charges are assessed on the shipment. WH34.4
Freight codes are defined in BL12.1
(Freight Codes). 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 Signed 15.2
Frt Chg Curr This field contains the freight charge
amount in billing currency.
COR-FRT-TAXABLE-FL Alpha 1
Frt Taxable Fl Select Yes if freight is taxable.
Y = Yes
N = No
COR-MULT-FRT-CHG Derived
Mult Frt Chg This field contains the freight charge
amount in the base currency if a
multiplier is in the conversion from
original to base currency.
COR-DIV-FRT-CHG Derived
Div Frt Chg This field contains the base amount of
the freight charge if a divider is used
in the conversion from original to base
currency.
COR-FRT-CHG-BASE Derived
Frt Chg Base This field contains the freight charge
amount in base currency.
COR-ACTUAL-FRT-CHG Signed 15.2 WH130 WH33.5
Actual Frt Chg The actual freight charges to-date in WH34.1 WH34.2
GL company base currency. WH34.3 WH34.4
Sourced from:
1). All freight that has been paid by
the AP system involving a drop-ship
customer order originating from OE. In
this case, the Actual-Frt-Chg is updated
by OE129.
2). All freight billed to a customer
excluding drop-ship freight. Updated by
OE129.
COR-MULT-A-FRT-CHG Derived
Mult A Frt Chg
COR-DIV-A-FRT-CHG Derived
Div A Frt Chg
COR-ACTUAL-FR-CH-B Derived
Actual Fr Ch B
COR-CARRIER Alpha 9 (Right Justified)
Carrier Vendor This field contains the carrier vendor
Number number. Vendors are set up in the
Accounts Payable system.
COR-METHOD Alpha 10
Method Code User-defined shipping method. Shipping
methods are set up in the Order Entry
system. The shipping method will print
on order acknowledgments, packing lists,
and invoices.
COR-TRANS-ID Alpha 20
Trans Id 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 Alpha 14
List Name This field contains the customer's
price list. This defaults from the
customer's price list when the order is
entered.
COR-PK-PRIORITY Numeric 2
Picking Priority This field contains the picking
priority, which defaults from the
customer's file. WH110 (Batch
Allocation) uses this as a priority when
assigning inventory to orders.
COR-IMMEDIATE-FL Alpha 1
Immediate Order Flag 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 Alpha 1
Edi Oe Flag 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 Alpha 1
Acknowledgement This field indicates whether a printed
Required Flag acknowledgment is required for this
order. This defaults from the customer's
file.
N = No
Y = Yes
COR-ACK-PRT-FL Alpha 1
Acknowledgement This field indicates if an
Printed Flag acknowledgment was printed to avoid
duplicate printing of the document.
N = No
Y = Yes
COR-BACK-ORD-FL Alpha 1
Backorders Allowed This field indicates if backorders are
Flag 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 Alpha 1
Ship Comp Fl 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 Alpha 1 WH130 WH33.5
Credit Wf Fl This field indicates that this order on WH34.1 WH34.2
hold has passed to the Workflow WH34.3 WH34.4
Management system.
Y = Yes
N = No
COR-ACTIVITY Alpha 15
Activity 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 the Activity Management
system. Direct costs are posted to
activities, and indirect costs are
allocated to activities based on
activity drivers.
Activities are grouped or organized by
activity levels. There are two types of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
COR-ACCT-CATEGORY Alpha 5
Account Category 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 the Activity
Management system. 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 AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
COR-ACTIVITY-C Alpha 15
Activity C 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 the Activity Management
system. Direct costs are posted to
activities, and indirect costs are
allocated to activities based on
activity drivers.
Activities are grouped or organized by
activity levels. There are two types of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
COR-ACCT-CATEG-C Alpha 5
Acct Categ C 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 the Activity
Management system. 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 AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
COR-USER-DATE-1 Numeric 8 (yyyymmdd)
User Date 1 This field contains the first
user-definable date. This is used by
OE280 (Open Orders By Customer).
COR-USER-DATE-2 Numeric 8 (yyyymmdd)
User Date 2 This field contains the second
user-definable date. This is used by
OE280 (Open Orders By Customer).
COR-TRANS-USER1 Alpha 10
Trans User1 This field contains the first
user-definable transaction field. This
field can be used in the Accounts
Receivable system as a sort option
during cash application and select
criteria for the aged trial balance.
COR-TRANS-USER2 Alpha 15
Trans User2 This field contains the second
user-definable transaction field. This
updates on the invoice in the Accounts
Receivable system file.
COR-TRANS-USER3 Numeric 8 (yyyymmdd)
Trans User3 This field contains the third
user-definable transaction field. This
updates on the invoice in the Accounts
Receivable system file.
COR-TRANS-USER4 Numeric 9
Trans User4 This field contains the fourth
user-definable transaction field. This
updates on the invoice in the Accounts
Receivable system file.
COR-TRANS-USER5 Signed 13.2
Trans User5 This field contains the fifth
user-definable transaction field. This
updates on the invoice in the Accounts
Receivable system file.
COR-CUBIC-FEET Signed 9.3
Cubic Feet This field contains the total cubic
feet of the items comprising this order.
COR-WEIGHT Signed 9.3
Unit Weight This field contains the total weight of
this order.
COR-LAST-LINE-NBR Numeric 6
Last Line Number This field contains the number of the
last line item added to the order.
COR-LAST-TP-SEQ Numeric 3 BLI2.1
Last Top Comment This field contains the last sequence
Sequence number used for top comments.
COR-LAST-BM-SEQ Numeric 3 BLI2.1
Last Bottom Comment This field contains the last sequence
Sequence number used for bottom comments.
COR-LAST-MISC-SEQ Numeric 3
Last Misc Code This field contains the last sequence
Sequence number used for add-on charges.
COR-SHIPMENT-NBR Numeric 10 WH130 WH33.5
Shipment Number This field contains the last shipment WH34.1 WH34.2
number used for this order. WH34.3 WH34.4
COR-LST-IF-REF-NBR Numeric 6
Lst If Ref Nbr This field contains an internally
generated reference number used by the
Requisitions system.
COR-SLS-QUOTE-FL Alpha 1
Sales Quote Flag 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 Alpha 1
Future Order Flag 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 Alpha 1
Picking List This field indicates whether a picking
Printed Flag list has been printed for this order.
N = No
Y = Yes
COR-POD-REQ-FL Alpha 1
Pod Req Fl 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 Numeric 3
Pod Grace Per 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 Numeric 8 (yyyymmdd)
Cancel Date This field contains the date the order
was canceled.
COR-CXL-OPR Alpha 10 (Lower Case)
Cancel Operator This field contains the user ID of the
person who canceled the order.
COR-CXL-REASON Alpha 4
Cancel Reason This field contains the cancellation
reason code. This is passed to the Sales
Analysis system for reporting.
COR-SA-UPDATED-FL Alpha 1
Sa Updated Fl This field indicates if this order has
been booked in the Sales Analysis
system.
Y = Yes
N = No
C = Change
COR-CURRENCY-CODE Alpha 5
Currency Code 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 Alpha 1
Currency This field indicates whether the
Multiply/Divide conversion from base to the billing
currency is accomplished using a
multiplier or divider.
M = Multiply
D = Divide
COR-CURR-RATE Signed 13.6
Currency Rate This field contains the currency
conversion rate to base currency.
COR-CURR-ND Numeric 1
Currency Number of This field contains the number of
Decimals decimals for the billing currency.
COR-CURR-OVR-FL Alpha 1
Curr Ovr Fl This field indicates whether you can
override the currency for transactions
on the customer's account.
Y = Yes
N = No
COR-RATE-FRZ-CD Alpha 1
Rate Frz Cd 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 Signed 15.2
Open Ord Amt 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 Signed 15.2
Open Ord Curr 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 Signed 15.2
Pass Ord Amt 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 Signed 15.2
Inv Gds Curr This field contains the amount of
inventoried goods for this order in
billing currency.
COR-INV-GDS-BASE Signed 15.2
Inv Gds Base This field contains the amount of
inventoried goods for this order in base
currency.
COR-NI-GDS-CURR Signed 15.2
Ni Gds Curr 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 Signed 15.2
Ni Gds Base 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 Derived
Gds Ttl Curr This field contains the total goods
amount for this order in billing
currency.
COR-GDS-TTL-BASE Derived
Gds Ttl Base This field contains the total goods
amount for this order in base currency.
COR-MISC-TTL-CURR Signed 15.2
Misc Ttl Curr This field contains the total of add-on
charges for this order in billing
currency.
COR-MULT-MISC-TTL Derived
Mult Misc Ttl This field contains the total of add-on
charges in base currency if a multiplier
is used in the conversion from original
to base amount.
COR-DIV-MISC-TTL Derived
Div Misc Ttl This field contains the total amount of
add-on charges in base currency if a
divider is used in the conversion from
original to base currency.
COR-MISC-TTL-BASE Derived
Misc Ttl Base This field contains the total amount of
add-on charges in base currency.
COR-DISCNTBL-CURR Signed 15.2
Discntbl Curr 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 Derived
Mult Discntbl This field contains the total
discountable amount for this order in
base currency if the conversion from
original to base currency is
accomplished using a multiplier.
COR-DIV-DISCNTBL Derived
Div Discntbl This field contains the total
discountable amount of the order in base
currency if a divider is used in the
conversion from original to base
currency.
COR-DISCNTBL-BASE Derived
Discntbl Base This field contains the total
discountable amount of the order in base
currency.
COR-ORD-DISC-CURR Signed 15.2
Ord Disc Curr This field contains the discount for
this order in billing currency. Order
discounts are calculated using the
discount codes set up on OE59.1 (Order
Discount Code) that are assigned to the
customer's record.
COR-MULT-ORD-DISC Derived
Mult Ord Disc This field contains the order discount
for this order in base currency if a
multiplier is used in the conversion
from original to base currency.
COR-DIV-ORD-DISC Derived
Div Ord Disc This field contains the total order
discount amount for this order if a
divider is used in the conversion from
original to base currency.
COR-ORD-DISC-BASE Derived
Ord Disc Base This field contains the total amount of
the order discount in the company base
currency.
COR-TXBL-TTL-CURR Signed 15.2
Txbl Ttl Curr This field contains the taxable amount
for this order in billing currency.
COR-MULT-TXBL-TTL Derived
Mult Txbl Ttl This field contains the taxable amount
for this order in base currency if a
multiplier is used in the conversion
from original to base currency.
COR-DIV-TXBL-TTL Derived
Div Txbl Ttl This field contains the taxable amount
for this order in base currency if a
divider is used in the conversion from
original to base currency.
COR-TXBL-TTL-BASE Derived
Txbl Ttl Base This field contains the taxable amount
for this order in the company base
currency.
COR-TAX-TTL-CURR Signed 15.2
Tax Ttl Curr This field contains the total amount of
tax on the order in original billing
currency.
COR-MULT-TAX-TTL Derived
Mult Tax Ttl This field contains the total amount of
tax on the order in base currency if a
multiplier is used in the conversion
from original to base currency.
COR-DIV-TAX-TTL Derived
Div Tax Ttl This field contains the total amount of
tax on the order in base currency if a
divider is used in the conversion from
original to base currency.
COR-TAX-TTL-BASE Derived
Tax Ttl Base This field contains the total amount of
tax on the order in base currency.
COR-ORD-GRS-BASE Derived
Ord Grs Base This field contains the total gross
amount of the order in base currency.
COR-ORD-GRS-CURR Derived
Ord Grs Curr This field contains the total gross
amount of the order in original billing
currency.
COR-ORDER-NET Derived
Order Net This field contains the total of line
net amounts plus add-on charges minus
order discounts.
COR-ORD-NET-BASE Derived
Ord Net Base This field contains the total of line
net amounts and add-on charges minus
order discounts in base currency.
COR-ORD-NET-CURR Derived
Ord Net Curr This field contains the net order,
which is the total of line net amounts
and add-on charges minus the order
discount in the order's original
currency.
COR-HOLD-LIT Derived
Hold Lit This field contains the hold code.
COR-TERMS-1 Derived
Terms 1 This field contains the description of
the first credit card terms table.
COR-TERM-2 Derived
Term 2 This field contains the description of
the second credit card terms table.
COR-ORDER-NBR-A Derived
Order Nbr A This field is used internally to create
relationships.
COR-ORDER-ZERO Derived
Order Zero This field is used internally to create
relationships
COR-COMM-LIT Derived
Comm Lit If comments are attached, this field
displays "comments exist."
COR-WF-CO-ORDR-NBR Derived
Wf Co Ordr Nbr
COR-INTRASTAT-NBR Numeric 12
Intrastat Nbr The number assigned by the Intrastat
system to a transaction that involves
Intrastat reporting after it has been
added.
COR-BILL-CNTRY-CD Alpha 2
Bill Cntry Cd The Bill-To country code; must be
defined in IN01.1 (Country Maintenance).
COR-BILL-REGION Alpha 2
Bill Region The Bill-To region code. Must be a
valid region for the country, defined in
IN02.1 (Region Maintenance).
COR-TO-CNTRY-CD Alpha 2
To Cntry Cd The Ship-To country code. Must be
defined in IN01.1 (Country
Maintenaance).
COR-SHIP-TO-REGION Alpha 2
Ship To Region The ship-to region code.
Must be a valid region for the country,
defined in IN02.1 (Region
Maintenance).
COR-ORDER-REF-NBR Numeric 8
Order Ref Nbr This field contains the order reference
number. This number can be filled with
extra order number information.
COR-REF-NBR-FLAG Alpha 1
Ref Nbr Flag This field contains a flag to indicate
whether the Order reference number is
being used. This could be used to flag
whether we use the order-ref-nbr in
place of our order number.
COR-REQ-EP-AUTH Alpha 1
Req Ep Auth
COR-EP-AMT-CURR Signed 15.2
Ep Amt Curr
COR-EP-AMT-BASE Signed 15.2
Ep Amt Base
COR-EP-SETTLE-AMT Signed 15.2
Ep Settle Amt
COR-EP-TRANS-ID Numeric 12
Ep Trans Id
COR-EP-TYPE Alpha 5
Ep Type
COR-EP-ACCOUNT Alpha 32
Ep Account
COR-EP-EXP-DATE Numeric 8 (yyyymmdd)
Ep Exp Date
COR-EP-MARGIN-MIN Signed 7.2
Ep Margin Min
COR-EP-MARGIN-PCT Percent 8.5 (Percent)
Ep Margin Pct
COR-ORDER-TTL-CURR Signed 15.2
Order Ttl Curr
COR-ORDER-TTL-BASE Signed 15.2
Order Ttl Base
COR-BILL-EC-CTRY Numeric 3
Bill Ec Ctry
COR-BILL-ISO-CTRY Numeric 3
Bill Iso Ctry
COR-TO-EC-CTRY Numeric 3
To Ec Ctry
COR-TO-ISO-CTRY Numeric 3
To Iso Ctry
COR-NOTC Alpha 2
Notc The Nature of Transaction code. Must
be a valid code defined in IN07.1 (NOTC
Maintenance).
COR-STAT-PROC Alpha 6
Stat Proc The statistical procedure code applied
to the data. The code must be defined
in IN06.1. (Statistical Procedure
Maintenance).
COR-VAT-REG-NBR Alpha 12
Vat Reg Nbr 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 AR21.6 BL00.1
ORDER-NBR BL121 BL123
BL291 BL80.1
BL80.4 BL91.1
BLI2.1 CXCP.1
DR100 IC141
IC142 IC83.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
WH110 WH120
WH126 WH130
WH140 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH224
...
CORSET10 COMPANY Subset
ORDER-NBR Where SA-UPDATED-FL != "Y"
And STATUS > 1
CORSET2 COMPANY AR08.1 AR501
CUSTOMER AR550
ORDER-NBR
CORSET3 COMPANY KeyChange
CUST-PO-NBR
ORDER-NBR
CORSET5 COMPANY
OPR-CODE
ORDER-NBR
CORSET6 COMPANY KeyChange, Subset AR115 AR124
CUSTOMER Where HOLD-CODE != Spaces AR20.1 AR21.1
HOLD-CODE AR21.2 AR21.3
ORDER-NBR AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 CB191
CORSET7 COMPANY KeyChange
HOLD-CODE
ORDER-NBR
CORSET8 COMPANY KeyChange
ORDER-DATE
ORDER-NBR
CORSET9 COMPANY KeyChange
TRANS-USER1
ORDER-NBR
CUSTORDER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
When COR-CARRIER != Spaces
COR-COMPANY -> CPY-COMPANY
Apvenmast APVENMAST Required
When COR-CARRIER != Spaces
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
COR-CARRIER -> VEN-VENDOR
Arcomp ARCOMP Required
COR-COMPANY -> ACO-COMPANY
Arcustomer ARCUSTOMER Required
COR-COMPANY -> ACM-COMPANY
COR-CUSTOMER -> ACM-CUSTOMER
Billto BILLTO Not Required
Valid When COR-BILL-TO != Zeroes
ACO-CUST-GROUP -> ABS-CUST-GROUP
COR-CUSTOMER -> ABS-CUSTOMER
COR-BILL-TO -> ABS-BILL-TO
Cosgblk COSGBLK Not Required
COR-COMPANY -> OSG-COMPANY
COR-ORDER-NBR -> OSG-ORDER-NBR
Zeroes -> OSG-LINE-NBR
Zeroes -> OSG-SEQ
Cucodes CUCODES Required
When COR-CURRENCY-CODE != COR-CURRENCY-CODE
COR-CURRENCY-CODE -> CUC-CURRENCY-CODE
Curelat CURELAT Not Required
GLS-CURRENCY-TABLE -> x u u ( -CURRENCY-TABLE
COR-CURRENCY-CODE -> x u u ( -FR-CURR-CODE
OEC-CURRENCY-CODE -> x u u ( -TO-CURR-CODE
Custdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
COR-CUSTOMER -> CUD-CUSTOMER
Cxl Operator OPERATOR Not Required
Valid When COR-CXL-REASON != Spaces
COR-CXL-OPR -> OPE-OPR-CODE
COR-COMPANY -> OPE-DEF-COMPANY
Glsystem GLSYSTEM Required
COR-COMPANY -> GLS-COMPANY
Holdcodes HOLDCODES Required
When COR-HOLD-CODE != Spaces
ACO-CUST-GROUP -> HDD-CUST-GROUP
COR-HOLD-CODE -> HDD-HOLD-CODE
Iccompany ICCOMPANY Required
COR-COMPANY -> ICC-COMPANY
Iclocation ICLOCATION Required
When COR-INV-LOCATION != Spaces
COR-COMPANY -> ICL-COMPANY
COR-INV-LOCATION -> ICL-LOCATION
Oecompany OECOMPANY Required
COR-COMPANY -> OEC-COMPANY
Oecust OECUST Required
COR-COMPANY -> OET-COMPANY
COR-CUSTOMER -> OET-CUSTOMER
Oefrtcode OEFRTCODE Required
When COR-FREIGHT-CODE != Spaces
COR-COMPANY -> OFR-COMPANY
COR-FREIGHT-CODE -> OFR-FRT-CODE
Oemethod OEMETHOD Required
When COR-METHOD != Spaces
COR-COMPANY -> OMT-COMPANY
COR-METHOD -> OMT-METHOD
Oeorddisc OEORDDISC Required
When COR-ORD-DISC-CODE > Spaces
COR-COMPANY -> OOD-COMPANY
COR-ORD-DISC-CODE -> OOD-ORD-DISC-CODE
COR-CURRENCY-CODE -> OOD-CURRENCY-CODE
Oeprclist OEPRCLIST Required
COR-COMPANY -> OPL-COMPANY
Spaces -> OPL-CUSTOMER
COR-LIST-NAME -> OPL-LIST-NAME
Spaces -> OPL-PROMOTION
Oeproclev OEPROCLEV Required
COR-COMPANY -> OEP-COMPANY
COR-PROCESS-LEVEL -> OEP-PROCESS-LEVEL
Oereason OEREASON Required
When COR-CXL-REASON != Spaces
COR-COMPANY -> OER-COMPANY
COR-CXL-REASON -> OER-REASON-CODE
Oesource OESOURCE Required
When COR-ORDER-SOURCE != Spaces
COR-COMPANY -> OSR-COMPANY
COR-ORDER-SOURCE -> OSR-ORDER-SOURCE
Operator OPERATOR Required
COR-COMPANY -> OPE-DEF-COMPANY
COR-OPR-CODE -> OPE-OPR-CODE
Ordertype ORDERTYPE Required
COR-COMPANY -> OTP-COMPANY
COR-ORDER-TYPE -> OTP-ORDER-TYPE
Salesman SALESREP Required
COR-COMPANY -> SAW-COMPANY
COR-SALESMAN -> SAW-SALESMAN
Salesman2 SALESREP Required
When COR-SALESMAN-2 != Zeroes
COR-COMPANY -> SAW-COMPANY
COR-SALESMAN-2 -> SAW-SALESMAN
Shipto SHIPTO Required
When COR-SHIP-TO != Zeroes
COR-COMPANY -> SHP-COMPANY
COR-CUSTOMER -> SHP-CUSTOMER
COR-SHIP-TO -> SHP-SHIP-TO
Teritory TERITORY Required
When COR-TERRITORY != Spaces
COR-COMPANY -> TRY-COMPANY
COR-TERRITORY -> TRY-TERRITORY
Terms TERMS Not Required
COR-TERMS-CD -> TMS-TERMS-CD
Txcodemast TXCODEMAST Not Required
COR-TAX-CODE -> TCM-TAX-CODE
Txtaxcode TXTAXCODE Required
When COR-TAX-CODE != Spaces
COR-COMPANY -> TAC-COMPANY
COR-TAX-CODE -> TAC-TAX-CODE
Whdemndhdr WHDEMNDHDR Not Required
COR-COMPANY -> WDH-COMPANY
"OE" -> WDH-SYSTEM-CD
COR-ORDER-NBR -> WDH-DOC-NBR-NUM
CUSTORDER FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
All Comisc COMISC
COR-COMPANY -> CMC-COMPANY
COR-ORDER-NBR -> CMC-ORDER-NBR
CMC-LINE-NBR
CMC-SEQ
Coline COLINE Delete Restricted
COR-COMPANY -> COL-COMPANY
COR-ORDER-NBR -> COL-ORDER-NBR
COL-LINE-NBR
Comisc COMISC
COR-COMPANY -> CMC-COMPANY
COR-ORDER-NBR -> CMC-ORDER-NBR
Zeroes -> CMC-LINE-NBR
CMC-SEQ
Custorder CUSTORDER
COR-COMPANY -> COR-COMPANY
COR-CUSTOMER -> COR-CUSTOMER
COR-ORDER-NBR
Hdr Comments OEORDCMNT
COR-COMPANY -> OOC-COMPANY
Spaces -> OOC-CUSTOMER
Spaces -> OOC-STD-ORDER-NBR
COR-ORDER-NBR -> OOC-ORDER-NBR
Zeroes -> OOC-LINE-NBR
OOC-SEQ
Icgeneric ICGENERIC
ICC-ITEM-GROUP -> ICG-ITEM-GROUP
ICG-GENERIC
Majorcl MAJORCL
ICC-ITEM-GROUP -> MAJ-ITEM-GROUP
"S" -> MAJ-CLASS-TYPE
MAJ-MAJOR-CLASS
Minorcl MINORCL
ICC-ITEM-GROUP -> MIN-ITEM-GROUP
"S" -> MIN-CLASS-TYPE
MIN-MAJOR-CLASS
MIN-MINOR-CLASS
Oeaudit OEAUDIT Delete Cascades
COR-COMPANY -> OEA-COMPANY
COR-ORDER-NBR -> OEA-ORDER-NBR
Zeroes -> OEA-LINE-NBR
OEA-FLD-NBR
OEA-UPDATE-DATE
OEA-UPDATE-TIME
Oediscount OEDISCOUNT
COR-COMPANY -> OED-COMPANY
OED-DISC-CODE
Oeinvoice OEINVOICE Delete Restricted
COR-COMPANY -> OEI-COMPANY
COR-ORDER-NBR -> OEI-ORDER-NBR
OEI-SHIPMENT-NBR
OEI-INVC-PREFIX
OEI-INVC-NUMBER
Oeorddisc2 OEORDDISC
COR-COMPANY -> OOD-COMPANY
OOD-ORD-DISC-CODE
OOD-CURRENCY-CODE
Polinesrc POLINESRC
COR-COMPANY -> PLS-OPER-COMPANY
"OE" -> PLS-ORIGIN-CD
COR-ORDER-NBR -> PLS-SOURCE-DOC-N
PLS-SRC-LINE-NBR
PLS-PO-CODE
PLS-PO-NUMBER
PLS-PO-RELEASE
PLS-LINE-NBR
Trl Comments OEORDCMNT
COR-COMPANY -> OOC-COMPANY
Spaces -> OOC-CUSTOMER
Spaces -> OOC-STD-ORDER-NBR
COR-ORDER-NBR -> OOC-ORDER-NBR
999999 -> OOC-LINE-NBR
OOC-SEQ
Whshipment WHSHIPMENT
COR-COMPANY -> WHS-COMPANY
"O" -> WHS-SYSTEM-CD
WDH-DOC-NBR -> WHS-DOC-NBR
WHS-SHIPMENT-NBR
WHS-LOCATION
|
