Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OECOMPANY


                             OECOMPANY FILE

                          Order Entry Company

This file stores the companies set up in the Lawson Billing system and used
in the Lawson Billing and Order Entry systems.  The company records in this
file are continually accessed for validation throughout the system.

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    AR08.1    AR10.1
AR115     AR124     AR150     AR20.1    AR21.1    AR21.2
AR21.3    AR219     AR24.1    AR30.1    AR30.2    AR30.4
AR31.5    AR42.2    AR42.7    AR501     AR550     AR560
AR570     AR575     AR580     BR11.1    CB191     CXCP.1
IC02.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
PHI3.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    TX140     WH110
WH120     WH126     WH130     WH132     WH190     WH20.1
WH20.2    WH20.3    WH20.4    WH20.5    WH20.6    WH20.7
WH21.1    WH21.2    WH21.3    WH21.4    WH210     WH22.1
WH222     WH25.1    WH25.2    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     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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

OEC-NAME               Alpha 30  (Lower Case)
Element: Name          Displays the company description.

OEC-ADDR1              Alpha 30  (Lower Case)
Element: Address 1     First line of company address
                       information.

OEC-ADDR2              Alpha 30  (Lower Case)
Element: Address 1     Second line of company address
                       information.

OEC-ADDR3              Alpha 30  (Lower Case)
Element: Address 1     Third line of company address
                       information.

OEC-ADDR4              Alpha 30  (Lower Case)
Element: Address 1     Fourth line of company address
                       information.

OEC-CITY               Alpha 18  (Lower Case)
Element: City          This field contains the city of the
                       address.

OEC-STATE              Alpha 2
Element: State or ProviThis field contains the two-character
                       state code of the address.

OEC-ZIP                Alpha 10
Element: Postal Code   This field contains the postal code of
                       the address.






OEC-COUNTRY            Alpha 30  (Lower Case)
Element: Country or OthThis field contains the country of the
                       address, or it can be used for
                       additional information such as an
                       attention name.

OEC-COUNTY             Alpha 25  (Lower Case)
Element: County        The county for the company address.

OEC-MAN-ORD-FL         Alpha 1
Element: All Flag      Flag indicating whether orders will be
                       manually numbered by the user at entry
                       time or automatically numbered by the
                       system.
                       N = No
                       Y = Yes

OEC-DEF-REASON         Alpha 4
Element: Cb Reason     The default cancellation reason code to
                       be used when orders are canceled or
                       deleted during processing. These codes
                       are set up on BL07.1 (Reason Codes).

OEC-BTCH-CNTRL-TL      Alpha 1
Batch Control Total    Flag indicating whether batch control
Flag                   totals will be required to be added
                       before releasing the batch of invoices
                       on BL120 (Invoice Batch Release).
                       Y = Yes
                       N = No

OEC-POST-UNITS-FL      Alpha 1
Element: All Flag      Flag indicating whether the user wants
                       to post units for any of the journal
                       entries created in the Billing and Order
                       Entry systems.
                       N = No
                       Y = Yes

OEC-SLS-ACCT-UNIT      Alpha 15
Element: Accounting UniDefault sales account unit. When adding
                       process levels to the Billing system,
                       this sales account unit will default
                       onto the process level sales account
                       unit field if left blank. This is the
                       only use for sales account unit at the
                       company level. The system will use the
                       sales account unit at the process level
                       when determining which revenue account
                       to credit for special orders.

OEC-SLS-ACCOUNT        Numeric 6
Element: Account       Sales account number. When adding
                       process levels to the system in Billing,
                       this sales account number will default
                       onto the process level sales account
                       number field if left blank. This is the
                       only use for sales account number at the
                       company level. The system will use the
                       sales account number at the process
                       level when determining what revenue
                       account to credit for special orders.

OEC-SLS-SUB-ACCT       Numeric 4
Element: Subaccount    Sales subaccount number. When adding
                       process level to the system in BL01.1
                       (Process Level), this number will
                       default into the process level sales
                       subaccount number field if left blank.
                       This is the only use for sales
                       subaccount number at the company level.
                       The system will use sales subaccount
                       number at the process level when
                       determining what number to credit for
                       revenue for special orders.

OEC-EXP-ACCT-UNIT      Alpha 15
Element: Accounting UniDefault accounting unit to be used for
                       the offset to COGS for special orders.
                       When a process level is added to the
                       company, this account unit will default
                       onto the process level if left blank.
                       This is the only use for this account
                       unit at the company level. When placing
                       an order for a special item, the system
                       will credit this account unit at the
                       process level.

OEC-EXP-ACCOUNT        Numeric 6
Element: Account       Default account number to be used for
                       the offset to COGS for special orders.
                       When a process level is added to the
                       company this account number will default
                       onto the process level if left blank.
                       This is the only use for this account
                       number at the company level. When
                       placing an order for a special item, the
                       system will credit this account number
                       at the process level.

OEC-EXP-SUB-ACCT       Numeric 4
Element: Subaccount    Default subaccount number to be used as
                       the offset to COGS for special orders.
                       When a process level is added to the
                       company this subaccount number will
                       default onto the process level if left
                       blank. This is the only use for the
                       subaccount number at the company level.
                       When placing an order for a special
                       item, the system will credit this
                       subaccount number at the process level.

OEC-MI-ACCT-UNIT       Alpha 15
Element: Accounting UniDefault sales general ledger account
                       unit. When process levels are added to
                       the Billing system, this sales account
                       unit will default onto the Special Order
                       Sales account unit field on the process
                       level if left blank. This is the only
                       use for this account at the company
                       level. When a special order is placed,
                       this special sales account unit on the
                       process level will be credited.

OEC-MI-ACCOUNT         Numeric 6
Element: Account       Default sales general ledger account
                       number. When process levels are added to
                       the Billing system, this sales account
                       number will default onto the Special
                       Order Sales Account number field on the
                       process level if left blank. This is the
                       only use for this account at the company
                       level. When a special order is placed
                       this special sales account number on the
                       process level will be credited.

OEC-MI-SUB-ACCT        Numeric 4
Element: Subaccount    Default sales general ledger subaccount
                       number. When process levels are added to
                       the Billing system, this sales
                       subaccount number will default onto the
                       Special Order Sales Subaccount number
                       field on the process level if left
                       blank. This is the only use for this
                       account at the company level. When a
                       special order is placed, this special
                       sales subaccount number on the process
                       level will be credited.

OEC-MCG-ACCT-UNIT      Alpha 15
Element: Accounting UniDefault accounting unit to be debited
                       as the COGS for special orders. When a
                       process level is added to the company,
                       this account unit will default onto the
                       process level if left blank. This is the
                       only use for this account unit at the
                       company level. When placing an order for
                       a special item, the system will debit
                       this account unit at the process level.

OEC-MCG-ACCOUNT        Numeric 6
Element: Account       Default accounting number to be debited
                       as the COGS for special orders. When a
                       process level is added to the company,
                       this account unit will default onto the
                       process level if left blank. This is the
                       only use for this account unit at the
                       company level. When placing an order for
                       a special item, the system will debit
                       this account number at the process
                       level.

OEC-MCG-SUB-ACCT       Numeric 4
Element: Subaccount    Default subaccount number to be debited
                       as the COGS for special orders. When a
                       process level is added to the company,
                       this subaccount number will default onto
                       the process level if left blank. This is
                       the only use for this subaccount number
                       at the company level. When placing an
                       order for a special item, the system
                       will debit this subaccount number at the
                       process level.

OEC-DSC-ACCT-UNIT      Alpha 15
Element: Accounting UniDiscount account unit. When adding
                       process levels to the Billing system,
                       this discount account unit will default
                       onto the process level discount account
                       unit field if left blank. This is the
                       only use for discount account unit at
                       the company level. The system will debit
                       this discount account unit at the
                       process level when Add-on discounts are
                       used on an order. Add-on discounts may
                       be entered on an order line or an order
                       header by using some of the options
                       available at order entry time.

OEC-DSC-ACCOUNT        Numeric 6
Element: Account       Discount account number. When adding
                       process levels to the Billing system
                       this discount account number will
                       default onto the process level discount
                       account number field if left blank. This
                       is the only use for discount account
                       number at the company level. The system
                       will debit this discount account number
                       at the process level when add-on
                       discounts are used on an order. Add-on
                       discounts can be entered on an order
                       line or an order header by using some of
                       the options available at order entry
                       time.

OEC-DSC-SUB-ACCT       Numeric 4
Element: Subaccount    Discount subaccount number. When adding
                       process levels to the Billing system,
                       this discount subaccount number will
                       default onto the process level discount
                       subaccount number field if left blank.
                       This is the only use for discount
                       subaccount number at the company level.
                       The system will debit this discount
                       subaccount number on the process level
                       associated with the order when add-on
                       discounts are used on an order. Add-on
                       discounts may be entered on an order
                       line or an order header by using some of
                       the options available at order entry
                       time.

OEC-ROUTE-STOP-FL      Alpha 1
Element: All Flag      Route and stop flag. This indicates
                       whether this company uses route and stop
                       delivery.
                       Y = Yes
                       N = No

OEC-UOM-REQ-FL         Alpha 1
Element: All Flag      This flag indicates whether users will
                       be required to enter the unit of measure
                       for each item when adding an order to
                       the system.
                       N = No
                       Y = Yes

OEC-CURRENCY-CODE      Alpha 5
Element: Currency Code This field contains the company's base
                       currency code established in the General
                       Ledger system.

OEC-MULTI-CURR-FL      Alpha 1
Element: All Flag      This flag indicates whether currencies
                       other than the company base currency are
                       allowed during processing of orders in
                       the Order Entry system.
                       Y = Yes
                       N = No

OEC-BASE-ND            Numeric 1
Account Currency
Code

OEC-CURR-OVR-FL        Alpha 1
Element: All Flag      This flag indicates whether or not
                       users can override the default currency
                       when adding an order to the system.

OEC-RATE-OVR-FL        Alpha 1
Element: All Flag      This flag indicates whether currency
                       exchange rates can be overridden on
                       transactions.
                       Y = Yes
                       N = No

OEC-REPRICE-FL         Alpha 1
Element: All Flag      The flag indicates whether to reprice
                       at invoice creation time or not.
                       Y = Yes
                       N = No

OEC-RATE-FRZ-CD        Alpha 1
Element: Rate Frz Cd   This value indicates when the system
                       should freeze the currency rate used on
                       the transaction.
                       E = Freeze Rate At Entry
                       I = Freeze Rate When Invoiced

OEC-PRICE-LOC-FL       Alpha 1
Element: All Flag      The price location flag indicates if
                       the company will be pricing items at the
                       location level or the company level. If
                       location level is chosen, each item must
                       have a separate base price established
                       for each location.
                       N = No
                       Y = Yes

OEC-PRICE-CURR-FL      Alpha 1
Element: All Flag      Flag indicating if pricing is to be
                       done in the cost-based currency or the
                       currency used when placing the order.
                       Y = Yes
                       N = No

OEC-AUDIT-ORD-FL       Alpha 1
Element: All Flag      Audit order flag indicates whether or
                       not the system should keep track of any
                       changes made to orders. If so, an audit
                       report can be run listing all changes.
                       N = No
                       Y = Yes

OEC-AUDIT-PRC-FL       Alpha 1
Element: All Flag      Audit price flag indicates whether the
                       system should keep track of any changes
                       made to the normal default pricing on an
                       order. If so a report can be run listing
                       all changes or price overrides, OE283
                       (Price Overrides).
                       N = No
                       Y = Yes

OEC-ALLOC-DT-FL        Alpha 1
Allocation Date        This value identifies which date on the
Option                 order the system should use when
                       determining what to allocate.
                       E = Entry Date
                       R = Request Date
                       S = Expected Ship Date

OEC-INVC-OPT-FL        Alpha 1
Invoice                Invoice option flag indicates if
Company/Proc Lvl Flag  invoicing will be done at the company
                       level or process level. Users have the
                       choice of establishing different
                       invoicing parameters for each process
                       level if needed.
                       C = Company level invoicing.
                       P = Process level invoicing.

OEC-INVC-EDIT-OPT      Alpha 1
Element: All Flag      Option to require running of BL121
                       (Invoice Print Edit Report) before the
                       invoices are printed and finalized.
                       N = No
                       Y = Yes

OEC-INTF-COST-FL       Alpha 1
Element: All Flag      Enter Yes to post cost for an
                       interfaced invoice from another system.
                       Y = Yes
                       N = No

OEC-COD-INVC-OPT       Alpha 1
Element: All Flag      This option determines whether invoices
                       should be created and printed twice for
                       Cash On Delivery orders. If Yes is
                       chosen, an invoice will be printed to be
                       sent with the goods (invoice at this
                       time is placed on hold until the driver
                       returns with the payment) and when the
                       driver returns with the payment, this
                       option determines whether that invoice
                       should be printed again to send to the
                       customer for their records. This final
                       invoice will reflect any corrections
                       made after the driver returns.
                       Y = Yes
                       N = No

OEC-BL-OPER-CNTRL      Alpha 1
Element: All Flag      A flag to indicate whether entry of
                       periodic billing quantity and charges
                       are restricted by billing operator. If
                       the flag is set to Yes, operator/item
                       combinations have to be set up in BL15.1
                       (Recurring Invoice User).
                       Y = Yes
                       N = No

OEC-BILL-EQL-INVC      Alpha 1
Element: All Flag      Y = Yes
                       N = No

OEC-TAX-PRINT-CD       Alpha 1
Element: Tax Print Cd  This code determines whether the tax
                       lines should print in summary or detail
                       on the invoice.
                       D = Calc by line - print detail
                       S = Calc by line - print summary
                       T = Calc and print in summary
                       P = Price incl tax - print summary

OEC-TAX-PRICE-FL       Alpha 1
Element: All Flag      Flag to indicate that prices include
                       taxes.
                       Y = Yes
                       N = No

OEC-DISC-AOC-FL        Alpha 1
Element: All Flag      Flag to indicate whether add-on charges
                       are included in order level discount
                       calculations.
                       Y = Yes
                       N = No

OEC-TERMS-AOC-FL       Alpha 1
Element: All Flag      Flag to indicate whether add-on charges
                       are included in the terms calculations.
                       For example, if payment terms include a
                       percentage discount and this flag is set
                       to No, the add-on charge amount will not
                       be included in the total of the order
                       from which the terms discount will be
                       calculated.
                       Y = Yes
                       N = No

OEC-INVC-CR-FL         Alpha 1
Element: All Flag      If invoicing is done at the company
                       level and OE129 (Daily Shipment Journal)
                       is running (this program creates
                       invoices), this flag will be set to Yes
                       to indicate that other invoice updating
                       batch programs cannot be run.
                       N = No
                       Y = Yes

OEC-INVC-EDIT-FL       Alpha 1
Element: All Flag      If invoicing is done at the company
                       level and BL121 (Invoice Print Edit
                       Report) is running, this flag will be
                       set to Yes to indicate that other
                       invoice update programs cannot be run.
                       N = No
                       Y = Yes

OEC-INVC-PRT-FL        Alpha 1
Element: All Flag      If invoicing is done at the company
                       level and BL122 (Invoice and Register
                       Print) is running, this flag will be set
                       to Yes to indicate that other invoice
                       update programs may not be run.
                       N = No
                       Y = Yes

OEC-INVC-UPD-FL        Alpha 1
Element: All Flag      If invoicing is done at the company
                       level and BL123 (Sub-System Update) is
                       running, this flag will be set to Yes to
                       indicate that other invoice update
                       programs cannot be run.
                       N = No
                       Y = Yes

OEC-INVC-DTL-FL        Alpha 1
Element: All Flag      This flag indicates whether
                       lots/sublots and serial numbers of items
                       ordered should print on the invoice.
                       N = No
                       Y = Yes

OEC-REL-COM-OPT        Alpha 1 Occurs 10 Times
Element: Ack Com Opt   An "X" on this field indicates that all
                       comments tied to an item on IC18.1 (Item
                       Comments) and belonging to the comment
                       type at the top of the column will print
                       on OE110 (Batch Order Release).

OEC-ACK-COM-OPT        Alpha 1 Occurs 10 Times
Element: Ack Com Opt   Selecting this field indicates that all
                       comments tied to an item on IC18.1 (Item
                       Comments) and belonging to the comment
                       type at the bottom of the column will
                       print on OE112 (Acknowledgment Print
                       Report).

OEC-QTE-COM-OPT        Alpha 1 Occurs 10 Times
Element: Ack Com Opt   An "X" placed on this line indicates
                       that all comments tied to an item on
                       IC18.1 (Item Comments) and belonging to
                       the comment type at the bottom of the
                       column will print on OE113 (Quotation
                       Listing and Delete).

OEC-JOR-COM-OPT        Alpha 1 Occurs 10 Times
Element: Ack Com Opt   An "X" placed on this line indicates
                       that all comments tied to an item on
                       IC18.1 (Item Comments) and belonging to
                       the comment type at the bottom of the
                       column will print on OE129 (Daily
                       Shipment Journal).

OEC-INV-COM-OPT        Alpha 1 Occurs 10 Times
Element: Ack Com Opt   An "X" on this line indicates that all
                       comments tied to an item on IC18.1 (Item
                       Comments) and belonging to the comment
                       type referenced below will print on
                       BL122 (Invoice Register and Print).

OEC-RMT-NAME           Alpha 30  (Lower Case)
Element: Name          Company remit-to name. If left blank,
                       company name will default or can be
                       overridden. All forms generated to send
                       to a customer will print this as the
                       remit-to name.

OEC-RMT-ADDR1          Alpha 30  (Lower Case)
Element: Address 1     Remit-to address. If left blank,
                       company address will default or it can
                       be overridden. All forms generated by
                       the Order Entry and Billing systems will
                       print this as a remit-to address.

OEC-RMT-ADDR2          Alpha 30  (Lower Case)
Element: Address 1     Remit-to address line 2. If left blank
                       the company address line 2 will default
                       or it can be overridden. All forms
                       generated by the Order Entry and Billing
                       systems will print this address as the
                       remit-to.

OEC-RMT-ADDR3          Alpha 30  (Lower Case)
Element: Address 1     Remit-to address line 3. If left blank
                       the company address line 3 will default
                       or it can be overridden. All forms
                       generated by the Order Entry and Billing
                       systems will print this address as the
                       remit-to.

OEC-RMT-ADDR4          Alpha 30  (Lower Case)
Element: Address 1     Remit-to address line 4. If left blank,
                       company address line 4 will default or
                       it can be overridden. All forms
                       generated by the Order Entry and Billing
                       systems will print this as the remit-to
                       address.

OEC-RMT-CITY           Alpha 18
Element: Billing City  Remit-to city. If left blank, company
                       city will default or it can be
                       overridden. All forms generated by the
                       Order Entry and Billing systems will
                       print this as the remit-to city.

OEC-RMT-STATE          Alpha 2
Element: State or ProviRemit-to state. If left blank, company
                       state will default or it can be
                       overridden. All forms generated by the
                       Order Entry and Billing systems will
                       print this as the remit-to state.

OEC-RMT-ZIP            Alpha 10
Element: Postal Code   Remit-to postal (zip) code. If left
                       blank the company postal code will
                       default or it can be overridden. All
                       forms generated by the Order Entry and
                       Billing systems will print this as the
                       remit-to postal code.

OEC-RMT-COUNTRY        Alpha 30  (Lower Case)
Element: Country or OthRemit-to country. If left blank, the
                       company country will default or can be
                       overridden. All forms generated by the
                       Order Entry and Billing systems will
                       print this as the remit-to country.

OEC-RMT-COUNTY         Alpha 25  (Lower Case)
Element: County

OEC-INCOMPLETE-FL      Alpha 1
Element: Account Flag  Company incomplete flag indicates that
                       the company has not been fully added to
                       the system.

OEC-BL-INCOMPL-FL      Alpha 1
Element: All Flag      This field indicates whether or not
                       setup was completed for the Order Entry
                       company.
                       N = No
                       Y = Yes

OEC-COM-TYPE-1         Derived
Element: Com Type 1    This field contains the first comment
                       type.

OEC-MAN-RET-FL         Alpha 1
Element: Account Flag

OEC-COUNTRY-CODE       Alpha 2
Element: Country Code  The country code.  Required for VAT and
                       intrastat reporting.  Must be defined in
                        IN01.1 (Country Maintenance).

OEC-REGION             Alpha 2
Element: Region Code   The region code, if applicable for the
                       country. Used by Intrastat. Must be
                       defined in IN02.1 (Region Maintenance)

OEC-EC-CTRY-NBR        Numeric 3
Element: Ec Ctry Nbr   The European Community Country number;
                       leave blank if not a member of the
                       European Community.

OEC-ISO-CTRY-NBR       Numeric 3
Element: Iso Ctry Nbr  The ISO country number.

OEC-RMT-CTRY-CODE      Alpha 2
Element: Rmt Ctry Code

OEC-RMT-REGION         Alpha 2
Element: Rmt Region

OEC-RMT-EC-CTRY        Numeric 3
Element: Rmt Ec Ctry

OEC-RMT-ISO-CTRY       Numeric 3
Element: Rmt Iso Ctry

                         OECOMPANY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OECSET1   COMPANY                                                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
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR150   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR219
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 ...

                         OECOMPANY FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Not Required

                            OEC-COMPANY          -> -COMPANY

Cucodes        CUCODES      Required
                            When OEC-CURRENCY-CODE != Spaces

                            OEC-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Exp Acct       GLMASTER     Required
                            When OEC-EXP-ACCT-UNIT != Spaces
                            Or   OEC-EXP-ACCOUNT   != Zeroes
                            Or   OEC-EXP-SUB-ACCT  != Zeroes

                            OEC-COMPANY          -> GLM-COMPANY
                            OEC-EXP-ACCT-UNIT    -> GLM-ACCT-UNIT
                            OEC-EXP-ACCOUNT      -> GLM-ACCOUNT
                            OEC-EXP-SUB-ACCT     -> GLM-SUB-ACCOUNT

Glsystem       GLSYSTEM     Required

                            OEC-COMPANY          -> GLS-COMPANY

Iccompany      ICCOMPANY    Required

                            OEC-COMPANY          -> ICC-COMPANY

Itemgroup      ITEMGROUP    Required

                            ICC-ITEM-GROUP       -> ITG-ITEM-GROUP

Misc Cgs Acct  GLMASTER     Required
                            When OEC-MCG-ACCT-UNIT != Spaces
                            Or   OEC-MCG-ACCOUNT   != Zeroes
                            Or   OEC-MCG-SUB-ACCT  != Zeroes

                            OEC-COMPANY          -> GLM-COMPANY
                            OEC-MCG-ACCT-UNIT    -> GLM-ACCT-UNIT
                            OEC-MCG-ACCOUNT      -> GLM-ACCOUNT
                            OEC-MCG-SUB-ACCT     -> GLM-SUB-ACCOUNT

Misc Sls Acct  GLMASTER     Required

                            OEC-COMPANY          -> GLM-COMPANY
                            OEC-MI-ACCT-UNIT     -> GLM-ACCT-UNIT
                            OEC-MI-ACCOUNT       -> GLM-ACCOUNT
                            OEC-MI-SUB-ACCT      -> GLM-SUB-ACCOUNT

Oereason       OEREASON     Required
                            When OEC-DEF-REASON != Spaces

                            OEC-COMPANY          -> OER-COMPANY
                            OEC-DEF-REASON       -> OER-REASON-CODE

Ord Disc Acct  GLMASTER     Required
                            When OEC-DSC-ACCT-UNIT != Spaces
                            Or   OEC-DSC-ACCOUNT   != Zeroes
                            Or   OEC-DSC-SUB-ACCT  != Zeroes

                            OEC-COMPANY          -> GLM-COMPANY
                            OEC-DSC-ACCT-UNIT    -> GLM-ACCT-UNIT
                            OEC-DSC-ACCOUNT      -> GLM-ACCOUNT
                            OEC-DSC-SUB-ACCT     -> GLM-SUB-ACCOUNT

Sales Account  GLMASTER     Required

                            OEC-COMPANY          -> GLM-COMPANY
                            OEC-SLS-ACCT-UNIT    -> GLM-ACCT-UNIT
                            OEC-SLS-ACCOUNT      -> GLM-ACCOUNT
                            OEC-SLS-SUB-ACCT     -> GLM-SUB-ACCOUNT

                         OECOMPANY FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Coline         COLINE       Delete Restricted

                            OEC-COMPANY          -> COL-COMPANY
                                                    COL-ORDER-NBR
                                                    COL-LINE-NBR

Custorder      CUSTORDER    Delete Restricted

                            OEC-COMPANY          -> COR-COMPANY
                                                    COR-ORDER-NBR

Oebases        OEBASE       Delete Restricted

                            OEC-COMPANY          -> OEB-COMPANY
                                                    OEB-LOCATION
                                                    OEB-BASE-NAME
                                                    OEB-CURRENCY-CODE
                                                    OEB-ITEM

Oecompref      OECOMPREF

                            OEC-COMPANY          -> OEL-COMPANY
                                                    OEL-PROCESS-LEVEL

Oediscount     OEDISCOUNT   Delete Restricted

                            OEC-COMPANY          -> OED-COMPANY
                                                    OED-DISC-CODE

Oefrtcode      OEFRTCODE

                            OEC-COMPANY          -> OFR-COMPANY
                                                    OFR-FRT-CODE

Oeinvoice      OEINVOICE

                            OEC-COMPANY          -> OEI-COMPANY
                                                    OEI-INVC-PREFIX
                                                    OEI-INVC-NUMBER

Oeprclist      OEPRCLIST    Delete Restricted

                            OEC-COMPANY          -> OPL-COMPANY
                                                    OPL-CUSTOMER
                                                    OPL-LIST-NAME
                                                    OPL-PROMOTION

Oeproclev      OEPROCLEV    Delete Restricted

                            OEC-COMPANY          -> OEP-COMPANY
                                                    OEP-PROCESS-LEVEL

Price Lists    OEPRCLIST    Delete Restricted

                            OEC-COMPANY          -> OPL-COMPANY
                            Spaces               -> OPL-CUSTOMER
                                                    OPL-LIST-NAME
                                                    OPL-PROMOTION