Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CUSTORDER


                             CUSTORDER FILE

                          Customer Order File

This file contains a record for every order entered in the Lawson Order Entry
system.  This is the order header record for which any lines on the order are
kept in the Customer Order Line file.

REFERENCED BY

AP125     AP126     AP131     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP23.1    AP25.1    AP25.2
AP26.1    AP27.1    AP30.4    API1.1    AR21.6    AR21.1
AR21.2    AR21.3    CXCP.1    IC28.1    IC83.1    MA180
MA41.2    MA41.7    MA43.1    MA43.2    MA43.3    MA43.9
MA530     MA531     MA60.2    MA60.3    MA60.5    MA61.1
MA66.2    MA66.3    MA67.1    MA67.2    MA70.1    MA75.1
MA80.1    MAI1.1    PO100     PO101     PO122     PO131
PO20.1    PO21.1    PO21.2    PO21.3    PO21.4    PO21.5
PO22.1    PO23.1    PO25.1    PO25.5    PO25.6    PO25.7
PO27.2    PO29.1    PO30.1    PO30.2    PO30.3    PO300
PO31.1    PO31.2    PO32.2    PO33.1    PO34.1    PO35.1
PO36.1    PO36.2    PO38.1    PO39.1    PO39.2    PO44.1
PO50.1    PO52.1    PO520     PO536     POI3.1    POII.1
POIJ.1    RQ10.1    RQ10.2    RQ10.3    RQ11.1    RQ12.1
RQ13.1    RQ35.1    RQ500     RQIE.1    RQIF.1    WH110
WH120     WH126     WH140     WH21.1    WH21.2    WH21.3
WH21.4    WH210     WH22.1    WH222     WH224     WH25.1
WH25.2    WO120     WO131     WO132     WO133     WO140
WO20.1    WO30.1    WO32.1    WO32.2    WO32.3    WO32.4
WO32.5    WO40.1    WO40.2    WO40.3    WO40.4    WO40.5
WO41.1    WO41.2    WO41.3    WO41.4    WO42.1    WO42.2
WO42.3    WO42.4    WO42.5    WO45.1    WOEX.1    WOSP.1
AR08.1    AR10.1    AR501     AR550     AR115     AR124
AR20.1    AR24.1    AR30.1    AR30.2    AR30.4    AR570
AR575     AR580     CB191

UPDATED BY

BLI2.1    WH130     WH132     WH190     WH20.7    WH30.1
WH30.2    WH30.3    WH30.4    WH31.1    WH31.2    WH31.3
WH31.4    WH32.1    WH32.2    WH32.3    WH32.4    WH33.1
WH33.2    WH33.3    WH33.4    WH33.5    WH33.6    WH33.8
WH33.9    WH34.1    WH34.2    WH34.3    WH34.4    WH40.1
WH40.2    WH520     WH830     WHD2.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

COR-COMPANY            Numeric 4                                 WH20.7
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

COR-ORDER-NBR          Numeric 8                                 WH20.7
Element: 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                                 WH20.7
Element: Status        This field contains the status of the
                       order.
                       1 = Unreleased
                       2 = Released
                       8 = Canceled
                       9 = Ready for purge

COR-PROCESS-LEVEL      Alpha 5                                   WH20.7
Element: Process Level This field contains the process level,
                       which is the reporting hierarchy below
                       company.

COR-ORDER-TYPE         Alpha 2                                   WH20.7
Element: Order Type CodThis field contains the order type.

COR-ORDER-DATE         Numeric 8  (yyyymmdd)                     WH20.7
Element: Date          This field contains the date of the
                       order. The system date defaults.

COR-PRICE-DATE         Numeric 8  (yyyymmdd)                     WH20.7
Element: 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)                    WH20.7
Element: Requester     This field contains the user ID, which
                       is required for each order.

COR-CHG-OPR            Alpha 10  (Lower Case)                    WH20.7
Element: Requester     This field contains the user ID of the
                       last operator to maintain this order.

COR-CRED-OPR           Alpha 10  (Lower Case)                    WH20.7
Element: Requester     This field contains the user ID of the
                       person who released the order from
                       credit hold.

COR-CUST-PO-NBR        Alpha 22                                  WH20.7
Element: Customer P.O. 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                                  WH20.7
Element: Letter of CredThis 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                                 WH20.7
Element: Ship-to Code  This field contains the bill-to
                       customer number.

COR-CUSTOMER           Alpha 9  (Right Justified)                WH20.7
Element: Customer NumbeThis field contains the number that
                       represents a customer.

COR-BILL-NAME          Alpha 30  (Lower Case)                    WH20.7
Element: 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)                    WH20.7
Element: Address 1     This field contains the first line of
                       the bill-to customer's address.

COR-BILL-ADDR2         Alpha 30  (Lower Case)                    WH20.7
Element: Address 1     This field contains the second line of
                       the bill-to customer's address.

COR-BILL-ADDR3         Alpha 30  (Lower Case)                    WH20.7
Element: Address 1     This field contains the third line of
                       the bill-to customer's address.

COR-BILL-ADDR4         Alpha 30  (Lower Case)                    WH20.7
Element: Address 1     This field contains the fourth line of
                       the bill-to customer's address.

COR-BILL-CITY          Alpha 18                                  WH20.7
Element: Billing City  This field contains the city of the
                       bill-to customer's address.

COR-BILL-STATE         Alpha 2                                   WH20.7
Element: State or ProviThis field contains the state or
                       province of the bill-to customer's
                       address.

COR-BILL-ZIP           Alpha 10                                  WH20.7
Element: Postal Code   This field contains the postal code of
                       the bill-to customer's address.

COR-BILL-CNTRY         Alpha 30  (Lower Case)                    WH20.7
Element: Country or OthThis field contains the country of the
                       bill-to customer's address.

COR-BILL-COUNTY        Alpha 25  (Lower Case)                    WH20.7
Element: County

COR-EXP-SHIP-DT        Numeric 8  (yyyymmdd)                     WH132   WH20.7
Element: Date          This field contains the expected ship     WH222
                       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)                     WH20.7
Element: Date          This field contains the customer's
                       requested delivery date. If left blank,
                       the system date defaults.

COR-USER-ID-RLS        Alpha 3                                   WH20.7
Element: User Id Entry 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                                   WH20.7
Element: 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                                   WH20.7
Element: Tax Exempt CodThis 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                                 WH20.7
Element: Ship-to Code  This field contains the ship-to
                       customer's number.

COR-SHIP-TO-NAME       Alpha 30  (Lower Case)                    WH20.7
Element: Name          This field contains the name of
                       the-ship-to customer.

COR-SHIP-TO-ADDR1      Alpha 30  (Lower Case)                    WH20.7
Element: Address 1     This field contains the first line of
                       the ship-to customer's address.

COR-SHIP-TO-ADDR2      Alpha 30  (Lower Case)                    WH20.7
Element: Address 1     This field contains the second line of
                       the ship-to customer's address.

COR-SHIP-TO-ADDR3      Alpha 30  (Lower Case)                    WH20.7
Element: Address 1     This field contains the third line of
                       the ship-to customer's address.

COR-SHIP-TO-ADDR4      Alpha 30  (Lower Case)                    WH20.7
Element: Address 1     This field contains the fourth line of
                       the ship-to customer's address.

COR-SHIP-TO-CITY       Alpha 18                                  WH20.7
Element: Billing City  This field contains the city of the
                       ship-to customer's address.

COR-SHIP-TO-STATE      Alpha 2                                   WH20.7
Element: State or ProviThis field contains the state or
                       province of the ship-to customer's
                       address.

COR-SHIP-TO-ZIP        Alpha 10                                  WH20.7
Element: Postal Code   This field contains the postal code of
                       the ship-to customer's address.

COR-SHIP-TO-CNTRY      Alpha 30  (Lower Case)                    WH20.7
Element: Country or OthThis field contains the country of the
                       ship-to customer's address.

COR-SHIP-TO-COUNTY     Alpha 25  (Lower Case)                    WH20.7
Element: County

COR-HOLD-CODE          Alpha 4                                   WH130   WH132
Element: Hold Code     This field contains the hold code. If     WH190   WH20.7
                       this field is not blank, processing for   WH30.1  WH30.2
                       the order is suspended. You can take an   WH30.3  WH30.4
                       order off hold by clearing its hold code  WH31.1  WH31.2
                       field.                                    WH31.3  WH31.4
                                                                 WH32.1  WH32.2
                                                                 WH32.3  WH32.4
                                                                 WH33.5  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

COR-HOLD-APR-FL        Alpha 1                                   WH20.7
Element: All Flag      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                                   WH20.7
Element: Location Code 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                                   WH20.7
Element: Sales TerritorThis 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                                 WH20.7
Element: Salesman NumbeThis 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                                 WH20.7
Element: Salesman NumbeThis 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)                    WH20.7
Commission Split       This field contains the commission
Percentage             split. This defaults from the customer
                       file.

COR-COMM-RATE-1        Percent 7.5  (Percent)                    WH20.7
Element: Chrg Rate

COR-COMM-RATE-2        Percent 7.5  (Percent)                    WH20.7
Element: Chrg Rate     This field contains the commission rate
                       for the second sales representative.
                       This defaults from the sales
                       representative's file.

COR-CHECK-NBR          Numeric 8                                 WH20.7
Element: Payment NumberThis field contains the payment number.
                       This is only valid with a down payment.

COR-AUTH-REQUIRED      Alpha 1
Element: All Flag      Flag indicating that explicit
                       authorization must be received from
                       credit card service, prior to resulting
                       line items being printed on pick list.
                       Y = Yes
                       N = No

COR-AUTH-APPROVED      Alpha 1
Element: Auth Approved Indicates whether authorization was
                       approved by credit card service or not.

COR-TERMS-CD           Alpha 5                                   WH20.7
Element: 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                                   WH20.7
Element: Transaction CoA transaction code represents a type of
                       cash payment, bill of exchange payment,
                       or bank service transaction.

COR-COD-FL             Alpha 1                                   WH20.7
Element: All Flag      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                                   WH20.7
Element: Cash In AdvancThis 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)                    WH20.7
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                                   WH20.7
Accounts Receivable    This field contains the order discount
Code                   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)                    WH20.7
Element: 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                               WH20.7
Element: Current Cash  This field contains the down payment
                       amount entered in the order's currency.

COR-MULT-PMNT          Derived
Element: Mult Pmnt     This field indicates what the base
                       payment amount is if a multiplier is
                       used when converting the payment from
                       foreign to base currency.

COR-DIV-PMNT           Derived
Element: Div Pmnt      This field indicates what the base
                       payment amount is if a divider is used
                       when converting the payment from foreign
                       to company base currency.

COR-PMNT-BASE          Derived
Element: Pmnt Base     This field contains the amount of the
                       payment in the company base currency.

COR-NET-DUE-CURR       Derived
Element: Net Due Curr  This field contains the total amount of
                       the order minus the down payment valued
                       in the order's original currency.

COR-NET-DUE-BASE       Derived
Element: Net Due Base  This field contains the total amount in
                       company base currency of the order minus
                       the down payment.

COR-PMNT-INVCED        Signed 15.2                               WH20.7
Element: Invoice AmountThis 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                               WH20.7
Element: Actual 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
Element: Mult Disc     This field contains the base discount
                       amount if a multiplier is used in its
                       conversion.

COR-DIV-DISC           Derived
Element: Div Disc      This field contains the base discount
                       amount if a divider is used in its
                       conversion.

COR-DISC-BASE          Derived
Element: Disc Base     This field contains the amount of the
                       discount in the company's base currency.


COR-DISC-TKN-CURR      Signed 15.2                               WH20.7
Element: Actual Disc   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
Element: Mult Disc Tkn This field contains the amount of
                       additional discounts for this order in
                       base currency if a multiplier is used
                       when converting the discount amount.

COR-DIV-DISC-TKN       Derived
Element: Div Disc Tkn  This field contains the amount of the
                       additional discount taken from the order
                       in the base currency if a divider is
                       used when converting the discount.

COR-DISC-TKN-BASE      Derived
Element: Disc Tkn Base This field contains the amount of the
                       additional discount taken on invoices of
                       the order in the company base currency.

COR-TAX-CODE           Alpha 10                                  WH20.7
Element: 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)                     WH20.7
Element: 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                                   WH20.7
Element: 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                                   WH130   WH132
Element: Add On Cost CoThis field contains the freight code,     WH190   WH20.7
                       which determines if carrier and freight   WH30.1  WH30.2
                       charges are assessed on the shipment.     WH30.3  WH30.4
                       Freight codes are defined in BL12.1       WH31.1  WH31.2
                       (Freight Codes). A freight code can be    WH31.3  WH31.4
                       added to the customer's file as a         WH32.1  WH32.2
                       default, or it can be added at order      WH32.3  WH32.4
                       entry time.                               WH33.5  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

COR-FRT-CHG-CURR       Signed 15.2                               WH20.7
Element: Frt Charge    This field contains the freight charge
                       amount in billing currency.

COR-FRT-TAXABLE-FL     Alpha 1                                   WH20.7
Element: All Flag      Select Yes if freight is taxable.
                       Y = Yes
                       N = No

COR-MULT-FRT-CHG       Derived
Element: Mult Frt Chg  This field contains the freight charge
                       amount in the base currency if a
                       multiplier is in the conversion from
                       original to base currency.

COR-DIV-FRT-CHG        Derived
Element: Div Frt Chg   This field contains the base amount of
                       the freight charge if a divider is used
                       in the conversion from original to base
                       currency.

COR-FRT-CHG-BASE       Derived
Element: Frt Chg Base  This field contains the freight charge
                       amount in base currency.

COR-ACTUAL-FRT-CHG     Signed 15.2                               WH130   WH132
Element: Actual Frt ChgThe actual freight charges to-date in     WH190   WH20.7
                       GL company base currency.                 WH30.1  WH30.2
                                                                 WH30.3  WH30.4
                       Sourced from:                             WH31.1  WH31.2
                        1).  All freight that has been paid by   WH31.3  WH31.4
                       the AP system involving a drop-ship       WH32.1  WH32.2
                       customer order  originating from OE. In   WH32.3  WH32.4
                       this case, the Actual-Frt-Chg is updated  WH33.5  WH34.1
                        by OE129.                                WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                       2).  All freight billed to a customer     WH40.2  WH520
                       excluding drop-ship freight.  Updated by  WH830
                       OE129.

COR-MULT-A-FRT-CHG     Derived
Element: Mult A Frt Chg

COR-DIV-A-FRT-CHG      Derived
Element: Div A Frt Chg

COR-ACTUAL-FR-CH-B     Derived
Element: Actual Fr Ch B

COR-CARRIER            Alpha 9  (Right Justified)                WH20.7
Element: Vendor ID     This field contains the carrier vendor
                       number. Vendors are set up in the
                       Accounts Payable system.

COR-METHOD             Alpha 10                                  WH20.7
Element: Opt Method    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                                  WH20.7
Element: 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                                  WH20.7
Element: 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                                 WH20.7
Element: Picking PrioriThis 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                                   WH20.7
Element: All 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                                   WH20.7
Element: All 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                                   WH20.7
Element: All Flag      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         Alpha 1                                   WH20.7
Element: All Flag      This field indicates if an
                       acknowledgment was printed to avoid
                       duplicate printing of the document.
                       N = No
                       Y = Yes

COR-BACK-ORD-FL        Alpha 1                                   WH20.7
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                                   WH20.7
Element: 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   WH132
Element: All Flag      This field indicates that this order on   WH190   WH30.1
                       hold has passed to the Workflow           WH30.2  WH30.3
                       Management system.                        WH30.4  WH31.1
                       Y = Yes                                   WH31.2  WH31.3
                       N = No                                    WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.5
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

COR-ACTIVITY           Alpha 15                                  WH20.7
Element: 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                                   WH20.7
Element: Account CategoIn 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                                  WH20.7
Element: Activity      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                                   WH20.7
Element: Account CategoIn 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)                     WH20.7
Element: Date          This field contains the first
                       user-definable date. This is used by
                       OE280 (Open Orders By Customer).

COR-USER-DATE-2        Numeric 8  (yyyymmdd)                     WH20.7
Element: Date          This field contains the second
                       user-definable date. This is used by
                       OE280 (Open Orders By Customer).

COR-TRANS-USER1        Alpha 10                                  WH20.7
Element: Cust 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                                  WH20.7
Element: Agent         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)                     WH20.7
Element: Date          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                                 WH20.7
Element: Cust User5    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                               WH20.7
Element: Par Value     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                                WH20.7
Element: Cubic Feet    This field contains the total cubic
                       feet of the items comprising this order.

COR-WEIGHT             Signed 9.3                                WH20.7
Element: Unit Weight   This field contains the total weight of
                       this order.

COR-LAST-LINE-NBR      Numeric 6                                 WH20.7
Element: Line Number   This field contains the number of the
                       last line item added to the order.

COR-LAST-TP-SEQ        Numeric 3                                 BLI2.1  WH20.7
Element: Sequence NumbeThis field contains the last sequence
                       number used for top comments.

COR-LAST-BM-SEQ        Numeric 3                                 BLI2.1  WH20.7
Element: Sequence NumbeThis field contains the last sequence
                       number used for bottom comments.

COR-LAST-MISC-SEQ      Numeric 3                                 WH20.7
Element: Sequence NumbeThis field contains the last sequence
                       number used for add-on charges.

COR-SHIPMENT-NBR       Numeric 10                                WH130   WH132
Element: Shipment NumbeThis field contains the last shipment     WH190   WH20.7
                       number used for this order.               WH30.1  WH30.2
                                                                 WH30.3  WH30.4
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH31.4
                                                                 WH32.1  WH32.2
                                                                 WH32.3  WH32.4
                                                                 WH33.5  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

COR-LST-IF-REF-NBR     Numeric 6                                 WH20.7
Element: Lst If Ref NbrThis field contains an internally
                       generated reference number used by the
                       Requisitions system.

COR-SLS-QUOTE-FL       Alpha 1                                   WH20.7
Element: All 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                                   WH20.7
Element: Future Order FThis 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                                   WH20.7
Element: All Flag      This field indicates whether a picking
                       list has been printed for this order.
                       N = No
                       Y = Yes

COR-POD-REQ-FL         Alpha 1                                   WH20.7
Element: 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                                 WH20.7
Element: Age Periods   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)                     WH20.7
Element: Date          This field contains the date the order
                       was canceled.

COR-CXL-OPR            Alpha 10  (Lower Case)                    WH20.7
Element: Requester     This field contains the user ID of the
                       person who canceled the order.

COR-CXL-REASON         Alpha 4                                   WH20.7
Element: Cb Reason     This field contains the cancellation
                       reason code. This is passed to the Sales
                       Analysis system for reporting.

COR-SA-UPDATED-FL      Alpha 1                                   WH20.7
Element: 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                                   WH20.7
Element: 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                                   WH20.7
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                               WH20.7
Element: Currency Rate This field contains the currency
                       conversion rate to base currency.

COR-CURR-ND            Numeric 1                                 WH20.2  WH20.7
Account Currency       This field contains the number of
Code                   decimals for the billing currency.

COR-CURR-OVR-FL        Alpha 1
Element: All Flag      This field indicates whether you can
                       override the currency for transactions
                       on the customer's account.
                       Y = Yes
                       N = No

COR-RATE-FRZ-CD        Alpha 1                                   WH20.7
Element: 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                               WH130   WH132
Element: Adj Amt       This field contains the total amount of   WH190   WH20.7
                       the open order added to the customer's    WH520   WH830
                       open order total from the customer's
                       file in tran currency.

COR-OPEN-ORD-CURR      Signed 15.2                               WH20.7
Element: Open Orders   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                               WH20.7
Element: Adj 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                               WH130   WH132
Element: Invoice AmountThis field contains the amount of         WH190   WH20.7
                       inventoried goods for this order in       WH520   WH830
                       billing currency.

COR-INV-GDS-BASE       Signed 15.2                               WH130   WH132
Element: Invoice AmountThis field contains the amount of         WH190   WH20.7
                       inventoried goods for this order in base  WH520   WH830
                       currency.

COR-NI-GDS-CURR        Signed 15.2                               WH130   WH132
Element: Exchange Rate This field contains the amount of         WH190   WH20.7
                       non-inventoried goods for this order in   WH520   WH830
                       billing currency. These could be either
                       nonstock or special items.

COR-NI-GDS-BASE        Signed 15.2                               WH130   WH132
Element: Exchange Rate This field contains the amount of         WH190   WH20.7
                       non-inventoried goods for this order in   WH520   WH830
                       base currency. These can be either
                       nonstock or special items.

COR-GDS-TTL-CURR       Derived
Element: Gds Ttl Curr  This field contains the total goods
                       amount for this order in billing
                       currency.

COR-GDS-TTL-BASE       Derived
Element: Gds Ttl Base  This field contains the total goods
                       amount for this order in base currency.

COR-MISC-TTL-CURR      Signed 15.2                               WH20.7
Element: Current Cash  This field contains the total of add-on
                       charges for this order in billing
                       currency.

COR-MULT-MISC-TTL      Derived
Element: Mult Misc Ttl This field contains the total of add-on
                       charges in base currency if a multiplier
                       is used in the conversion from original
                       to base amount.

COR-DIV-MISC-TTL       Derived
Element: Div Misc Ttl  This field contains the total amount of
                       add-on charges in base currency if a
                       divider is used in the conversion from
                       original to base currency.

COR-MISC-TTL-BASE      Derived
Element: Misc Ttl Base This field contains the total amount of
                       add-on charges in base currency.

COR-DISCNTBL-CURR      Signed 15.2                               WH130   WH132
Element: Actual Disc   This field contains the total             WH190   WH20.7
                       discountable amount for this order in     WH520   WH830
                       billing currency. This amount is used to
                       compute the order discount amount.

COR-MULT-DISCNTBL      Derived
Element: Mult Discntbl This field contains the total
                       discountable amount for this order in
                       base currency if the conversion from
                       original to base currency is
                       accomplished using a multiplier.

COR-DIV-DISCNTBL       Derived
Element: Div Discntbl  This field contains the total
                       discountable amount of the order in base
                       currency if a divider is used in the
                       conversion from original to base
                       currency.

COR-DISCNTBL-BASE      Derived
Element: Discntbl Base This field contains the total
                       discountable amount of the order in base
                       currency.

COR-ORD-DISC-CURR      Signed 15.2                               WH20.7
Element: Actual Disc   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
Element: Mult Ord Disc This field contains the order discount
                       for this order in base currency if a
                       multiplier is used in the conversion
                       from original to base currency.

COR-DIV-ORD-DISC       Derived
Element: Div Ord Disc  This field contains the total order
                       discount amount for this order if a
                       divider is used in the conversion from
                       original to base currency.

COR-ORD-DISC-BASE      Derived
Element: Ord Disc Base This field contains the total amount of
                       the order discount in the company base
                       currency.

COR-TXBL-TTL-CURR      Signed 15.2                               WH20.7
Element: Item Tax      This field contains the taxable amount
                       for this order in billing currency.

COR-MULT-TXBL-TTL      Derived
Element: Mult Txbl Ttl This field contains the taxable amount
                       for this order in base currency if a
                       multiplier is used in the conversion
                       from original to base currency.

COR-DIV-TXBL-TTL       Derived
Element: Div Txbl Ttl  This field contains the taxable amount
                       for this order in base currency if a
                       divider is used in the conversion from
                       original to base currency.

COR-TXBL-TTL-BASE      Derived
Element: Txbl Ttl Base This field contains the taxable amount
                       for this order in the company base
                       currency.

COR-TAX-TTL-CURR       Signed 15.2                               WH20.7
Element: Item Tax      This field contains the total amount of
                       tax on the order in original billing
                       currency.

COR-MULT-TAX-TTL       Derived
Element: Mult Tax Ttl  This field contains the total amount of
                       tax on the order in base currency if a
                       multiplier is used in the conversion
                       from original to base currency.

COR-DIV-TAX-TTL        Derived
Element: Div Tax Ttl   This field contains the total amount of
                       tax on the order in base currency if a
                       divider is used in the conversion from
                       original to base currency.

COR-TAX-TTL-BASE       Derived
Element: Tax Ttl Base  This field contains the total amount of
                       tax on the order in base currency.

COR-ORD-GRS-BASE       Derived
Element: Ord Grs Base  This field contains the total gross
                       amount of the order in base currency.

COR-ORD-GRS-CURR       Derived
Element: Ord Grs Curr  This field contains the total gross
                       amount of the order in original billing
                       currency.

COR-ORDER-NET          Derived
Element: Order Net     This field contains the total of line
                       net amounts plus add-on charges minus
                       order discounts.

COR-ORD-NET-BASE       Derived
Element: Ord Net Base  This field contains the total of line
                       net amounts and add-on charges minus
                       order discounts in base currency.

COR-ORD-NET-CURR       Derived
Element: Ord Net Curr  This field contains the net order,
                       which is the total of line net amounts
                       and add-on charges minus the order
                       discount in the order's original
                       currency.

COR-HOLD-LIT           Derived
Element: Hold Lit      This field contains the hold code.

COR-TERMS-1            Derived
Element: Terms 1       This field contains the description of
                       the first credit card terms table.

COR-TERM-2             Derived
Element: Term 2        This field contains the description of
                       the second credit card terms table.

COR-ORDER-NBR-A        Derived
Element: Order Nbr A   This field is used internally to create
                       relationships.

COR-ORDER-ZERO         Derived
Element: Order Zero    This field is used internally to create
                       relationships

COR-COMM-LIT           Derived
Element: Comm Lit      If comments are attached, this field
                       displays "comments exist."

COR-WF-CO-ORDR-NBR     Derived
Element: Wf Co Ordr Nbr

COR-INTRASTAT-NBR      Numeric 12                                WH20.7
Element: 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                                   WH20.7
Element: Bill Cntry Cd The Bill-To country code; must be
                       defined in IN01.1 (Country Maintenance).

COR-BILL-REGION        Alpha 2                                   WH20.7
Element: 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                                   WH20.7
Element: To Cntry Cd   The Ship-To country code. Must be
                       defined in IN01.1 (Country
                       Maintenaance).

COR-SHIP-TO-REGION     Alpha 2                                   WH20.7
Element: Ship To RegionThe ship-to region code.
                       Must be a valid region for the country,
                       defined in IN02.1 (Region
                       Maintenance).

COR-ORDER-REF-NBR      Numeric 8
Element: Order Ref Nbr This field contains the order reference
                       number.  This number can be filled with
                       extra order number information.

COR-REF-NBR-FLAG       Alpha 1
Element: Ref Nbr Flag  This field contains a flag to indicate
                       whether the Order reference number is
                       being used.  This could be used to flag
                       whether we use the order-ref-nbr in
                       place of our order number.

COR-REQ-EP-AUTH        Alpha 1
Element: Req Ep Auth

COR-EP-AMT-CURR        Signed 15.2                               WH20.7
Element: Ep Amt Curr

COR-EP-AMT-BASE        Signed 15.2                               WH20.7
Element: Ep Amt Base

COR-EP-SETTLE-AMT      Signed 15.2                               WH20.7
Element: Ep Settle Amt

COR-EP-TRANS-ID        Numeric 12                                WH20.7
Element: Ep Trans Id

COR-EP-TYPE            Alpha 5                                   WH20.7
Element: Ep Type

COR-EP-ACCOUNT         Alpha 32                                  WH20.7
Element: Ep Account

COR-EP-EXP-DATE        Numeric 8  (yyyymmdd)                     WH20.7
Element: Ep Exp Date

COR-EP-MARGIN-MIN      Signed 7.2                                WH20.7
Element: Ep Margin Min

COR-EP-MARGIN-PCT      Percent 8.5  (Percent)                    WH20.7
Element: Ep Margin Pct

COR-ORDER-TTL-CURR     Signed 15.2
Element: Order Ttl Curr

COR-ORDER-TTL-BASE     Signed 15.2
Element: Order Ttl Base

COR-BILL-EC-CTRY       Numeric 3                                 WH20.7
Element: Bill Ec Ctry

COR-BILL-ISO-CTRY      Numeric 3                                 WH20.7
Element: Bill Iso Ctry

COR-TO-EC-CTRY         Numeric 3                                 WH20.7
Element: To Ec Ctry

COR-TO-ISO-CTRY        Numeric 3                                 WH20.7
Element: To Iso Ctry

COR-NOTC               Alpha 2                                   WH20.7
Element: Notc          The Nature of Transaction code.  Must
                       be a valid code defined in IN07.1 (NOTC
                       Maintenance).

COR-STAT-PROC          Alpha 6                                   WH20.7
Element: 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                                  WH20.7
Element: 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.

COR-SIEB-ORDER-FL      Alpha 1                                   WH20.2  WH20.7
Element: Sieb Order Fl Y
                       N

COR-SIEB-LOCKED        Alpha 1                                   WH20.2  WH20.7
Element: Sieb Locked   Y
                       N

                         CUSTORDER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CORSET1   COMPANY                                                AP125   AP126
          ORDER-NBR                                              AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 AR21.6  BLI2.1
                                                                 CXCP.1  IC28.1
                                                                 IC83.1  MA180
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 MA530   MA531
                                                                 ...

CORSET10  COMPANY       Subset
          ORDER-NBR     Where SA-UPDATED-FL != "Y"
                        And   STATUS        >  1

CORSET2   COMPANY                                                AR08.1  AR10.1
          CUSTOMER                                               AR501   AR550
          ORDER-NBR                                              WH20.2  WH20.7

CORSET3   COMPANY       KeyChange
          CUST-PO-NBR
          ORDER-NBR

CORSET5   COMPANY
          OPR-CODE
          ORDER-NBR

CORSET6   COMPANY       KeyChange, Subset                        AR115   AR124
          CUSTOMER      Where HOLD-CODE != Spaces                AR20.1  AR21.1
          HOLD-CODE                                              AR21.2  AR21.3
          ORDER-NBR                                              AR24.1  AR30.1
                                                                 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           -> -COMPANY

Apvenmast      APVENMAST    Required
                            When COR-CARRIER != Spaces

                            CPY-VENDOR-GROUP      -> VEN-VENDOR-GROUP
                            COR-CARRIER           -> VEN-VENDOR

Arcomp         ARCOMP       Required

                            COR-COMPANY           -> ACO-COMPANY

Arcustomer     ARCUSTOMER   Required

                            COR-COMPANY           -> ACM-COMPANY
                            COR-CUSTOMER          -> ACM-CUSTOMER

Billto         BILLTO       Not Required
                            Valid When COR-BILL-TO != Zeroes

                            ACO-CUST-GROUP        -> ABS-CUST-GROUP
                            COR-CUSTOMER          -> ABS-CUSTOMER
                            COR-BILL-TO           -> ABS-BILL-TO

Cosgblk        COSGBLK      Not Required

                            COR-COMPANY           -> OSG-COMPANY
                            COR-ORDER-NBR         -> OSG-ORDER-NBR
                            Zeroes                -> OSG-LINE-NBR
                            Zeroes                -> OSG-SEQ

Cucodes        CUCODES      Required
                            When COR-CURRENCY-CODE != COR-CURRENCY-CODE

                            COR-CURRENCY-CODE     -> CUC-CURRENCY-CODE

Curelat        CURELAT      Not Required

                            GLS-CURRENCY-TABLE    -> CRL-CURRENCY-TABLE
                            COR-CURRENCY-CODE     -> CRL-FR-CURR-CODE
                            OEC-CURRENCY-CODE     -> CRL-TO-CURR-CODE

Custdesc       CUSTDESC     Required

                            ACO-CUST-GROUP        -> CUD-CUST-GROUP
                            COR-CUSTOMER          -> CUD-CUSTOMER

Cxl Operator   OPERATOR     Not Required
                            Valid When COR-CXL-REASON != Spaces

                            COR-CXL-OPR           -> OPE-OPR-CODE
                            COR-COMPANY           -> OPE-DEF-COMPANY

Glsystem       GLSYSTEM     Required

                            COR-COMPANY           -> GLS-COMPANY

Holdcodes      HOLDCODES    Required
                            When COR-HOLD-CODE != Spaces

                            ACO-CUST-GROUP        -> HDD-CUST-GROUP
                            COR-HOLD-CODE         -> HDD-HOLD-CODE

Iccompany      ICCOMPANY    Required

                            COR-COMPANY           -> ICC-COMPANY

Iclocation     ICLOCATION   Required
                            When COR-INV-LOCATION != Spaces

                            COR-COMPANY           -> ICL-COMPANY
                            COR-INV-LOCATION      -> ICL-LOCATION

Oecompany      OECOMPANY    Required

                            COR-COMPANY           -> OEC-COMPANY

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