Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OEINVCLINE


                            OEINVCLINE FILE

                              Invoice Line

This file stores invoice line information.  Each line on an invoice will have
a record in this file.  Inventory, nonstock, and special order lines are
stored here.  Add-on charges are stored in their own specific file.

REFERENCED BY

BL121     BL123     BL125     BL220     BL232     BL290
BL80.1    BL81.1    TX101

UPDATED BY

BL120     BL122     BL130     BL20.1    BL20.3    BL21.2
BL21.4    BL21.5    BL29.1    BL29.2    BL320     BL520
BL820     BL92.1    BLI2.1    WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OIL-COMPANY            Numeric 4                                 BL120   BL122
Element: Company       Identifies the AP company if the          BL130   BL20.1
                       resource type = V.  Identifies the HR     BL20.3  BL21.2
                       company if the resource type = E.  It is  BL21.5  BL29.1
                       blank for type A, P or Q resources.       BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-INVC-PREFIX        Alpha 2                                   BL120   BL122
Element: Invc Prefix   This field contains the invoice prefix    BL130   BL20.1
                       that is assigned from either the company  BL20.3  BL21.2
                       or process level, depending on the        BL21.5  BL29.1
                       invoice-level option chosen.              BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-INVC-NUMBER        Numeric 8                                 BL120   BL122
Element: Invc Number   This field contains the invoice number    BL130   BL20.1
                       assigned by the system.  Invoice numbers  BL20.3  BL21.2
                       are assigned at the company or process    BL21.5  BL29.1
                       level, depending on an invoice-level      BL29.2  BL520
                       option on the company file.               BL820   BL92.1
                                                                 WH20.7

OIL-LINE-NBR           Numeric 6                                 BL120   BL122
Element: Line Nbr      The system number of the line on the      BL130   BL20.1
                       invoice.                                  BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-LINE-TYPE          Alpha 1                                   BL120   BL122
Element: Line Type     The line type indicates whether the       BL130   BL20.1
                       item on the line is an inventoried item,  BL20.3  BL21.2
                       non-stock, or special item.               BL21.5  BL29.1
                       I = Inventoried item                      BL29.2  BL520
                       N = Non-stock                             BL820   BL92.1
                       X = Special order                         WH20.7

OIL-ITEM               Alpha 32                                  BL120   BL122
Element: Item          This field contains the item              BL130   BL20.1
                       identifier.                               BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-ITEM-16            Derived
Element: Item 16       This field contains the 16-character
                       item description. Derived by the system.

OIL-DESCRIPTION        Alpha 30  (Lower Case)                    BL120   BL122
Element: Description   The description of the item.              BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-ORDER-NBR          Numeric 8                                 BL120   BL122
Element: Order Nbr     If the invoice this invoice line was      BL130   BL20.1
                       created on is based on an order           BL20.3  BL21.2
                       shipment, this field will store the       BL21.5  BL29.1
                       order number related to the line.         BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-SHIPMENT-NBR       Numeric 10                                BL120   BL122
Element: Shipment Nbr  This field contains the shipment          BL130   BL20.1
                       number.  One order can have several       BL20.3  BL21.2
                       shipment numbers if the items of the      BL21.5  BL29.1
                       order were not shipped at the same time.  BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-QUANTITY           Signed 13.4                               BL120   BL122
Element: Quantity      The quantity of the item that is being    BL130   BL20.1
                       billed on this line.                      BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-INVC-CW-QTY        Signed 13.4                               BL120   BL122
Element: Quantity      Invoice catch weight quantity. This       BL130   BL20.1
                       field is valid only for catch weight      BL20.3  BL21.2
                       items. This is used in extended price     BL21.5  BL29.1
                       calculation, but quantity is used for     BL29.2  BL520
                       pricing.                                  BL820   BL92.1
                                                                 WH20.7

OIL-SPR-UOM            Alpha 4                                   BL120   BL122
Element: Uom           Indicates the selling price unit of       BL130   BL20.1
                       measure with which this line has been     BL20.3  BL21.2
                       priced.                                   BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-SELL-UOM           Alpha 4                                   BL120   BL122
Element: Uom           The selling unit of measure for the       BL130   BL20.1
                       item.                                     BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-SEC-UOM            Alpha 4                                   BL120   BL122
Element: Uom           This field contains the secondary         BL130   BL20.1
                       quantity unit of measure. Only used for   BL20.3  BL21.2
                       catch weight items.                       BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-MULT-SPR-FL        Alpha 1                                   BL120   BL122
Element: All Flag      Multiple sell price flag. The flag is     BL130   BL20.1
                       set if the item has multiple pricing set  BL20.3  BL21.2
                       in the Item Master file. If this flag is  BL21.5  BL29.1
                       set, price break is maintained in the     BL29.2  BL520
                       Order Line Pricing UOM's file.            BL820   BL92.1
                       Y = Yes                                   WH20.7
                       N = No

OIL-SPR-TO-STOCK       Signed 13.7                               BL120   BL122
Element: Sell To Stock Conversion factor from pricing unit of    BL130   BL20.1
                       measure back to stock unit of measure.    BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-SELL-TO-STOCK      Signed 13.7                               BL120   BL122
Element: Sell To Stock Conversion factor from selling unit of    BL130   BL20.1
                       measure back to stock unit of measure.    BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-SEC-UOM-MULT       Signed 13.7                               BL120   BL122
Element: Uom Mult      This field contains the secondary         BL130   BL20.1
                       quantity unit of measure multiplier. It   BL20.3  BL21.2
                       is used to convert the stock on hand      BL21.5  BL29.1
                       quantity to the secondary quantity or     BL29.2  BL520
                       visa versa. Used with catch weight items  BL820   BL92.1
                       only.                                     WH20.7

OIL-LOCATION           Alpha 5                                   BL120   BL122
Element: Location      This field contains a valid stock         BL130   BL20.1
                       location within the company inventory.    BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-PRICE-STATUS       Alpha 1                                   BL120   BL122
Element: Price Status  This value indicates how the invoice      BL130   BL20.1
                       line was priced; for example, was the     BL20.3  BL21.2
                       price overridden or amalgamated pricing   BL21.5  BL29.1
                       used.                                     BL29.2  BL520
                       A = Amalgated (group) pricing.            BL820   BL92.1
                       C = System calculated pricing.            WH20.7
                       O = Manual override of pricing.

OIL-ENTERED-PRICE      Signed 18.5                               BL120   BL122
Element: Intl Cost     This is the price of the line item.       BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-UNIT-PRICE         Signed 18.5                               BL120   BL122
Element: Intl Cost     The unit price of the line item.          BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-SELL-PRC-CURR      Signed 18.5                               BL120   BL122
Element: Sell Unit Prc This is the selling price in the          BL130   BL20.1
                       original billing unit of measure.         BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-SELL-UNIT-PRC      Signed 18.5                               BL120   BL122
Element: Sell Unit Prc The price in selling unit of measure.     BL130   BL20.1
                       Used internally; never seen on the form.  BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-UNIT-COST          Signed 18.5                               BL120   BL122
Element: Intl Cost     This is the unit cost for the invoice     BL130   BL20.1
                       line.                                     BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-CURRENT-COST       Signed 18.5                               BL120   BL122
Element: Intl Cost     This is the cost used for valuation       BL130   BL20.1
                       when the stock on hand goes negative for  BL20.3  BL21.2
                       an average costing company.               BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-NO-CHARGE-FL       Alpha 1                                   BL120   BL122
Element: No Charge Fl  No Charge Flag indicating if the line     BL130   BL20.1
                       is intentionally supposed to be no        BL20.3  BL21.2
                       charge.                                   BL21.5  BL29.1
                       N = No, normal pricing.                   BL29.2  BL520
                       Y = Yes, this is a no charge line.        BL820   BL92.1
                                                                 WH20.7

OIL-ENTERED-DISC       Signed 18.2                               BL120   BL122
Element: Intl Amt      The add-on discount that can be entered   BL130   BL20.1
                       when adding an invoice line.              BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-ADD-ON-DISC        Signed 18.2                               BL120   BL122
Element: Intl Amt      This is the add-on discount in the        BL130   BL20.1
                       company base currency.                    BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-ALLOC-DISC         Signed 18.2                               BL120   BL122
Element: Intl Amt      The portion of the order level discount   BL130   BL20.1
                       or invoice add-on discount allocated to   BL20.3  BL21.2
                       this line on the invoice. Tax is          BL21.5  BL29.1
                       calculated after discounts are taken out  BL29.2  BL520
                       of the invoice amount and the             BL820   BL92.1
                       invoice/order level discounts must be     WH20.7
                       dispersed among the lines of the invoice
                       as the system calculates tax at the line
                       level.

OIL-TAX-EXEMPT-CD      Alpha 1                                   BL120   BL122
Element: Tax Exempt Cd Indicates whether the line item is tax    BL130   BL20.1
                       exempt or not.                            BL20.3  BL21.2
                       E = Exempt                                BL21.5  BL29.1
                       T = Taxable                               BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-TAX-CODE           Alpha 10                                  BL120   BL122
Element: Tax Code      A user-defined code representing the      BL130   BL20.1
                       tax authorities this ship-to pays sales   BL20.3  BL21.2
                       tax to. Must be a valid tax code record.  BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-ENT-TAXABLE        Signed 18.2                               BL120   BL122
Element: Intl Amt      The taxable amount of the line item if    BL130   BL20.1
                       it is not tax exempt. This is a           BL20.3  BL21.2
                       calculated amount and is stored in        BL21.5  BL29.1
                       company base currency. The taxable        BL29.2  BL520
                       amount is the net amount of the line      BL820   BL92.1
                       minus the allocated discount amount.      WH20.7

OIL-TAXABLE-BSE        Signed 18.2                               BL120   BL122
Element: Intl Amt      Taxable amount of the line in company     BL130   BL20.1
                       base currency.                            BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-TAX-AMT-CURR       Signed 18.2                               BL120   BL122
Element: Intl Amt      Taxable amount of the line item in        BL130   BL20.1
                       original billing currency.                BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-TAX-AMT-BSE        Signed 18.2                               BL120   BL122
Element: Intl Amt      Tax amount in company base currency.      BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-REASON-CODE        Alpha 4                                   BL120   BL122
Element: Reason Code   Reason code is used to indicate the       BL130   BL20.1
                       reason for adding a credit memo to the    BL20.3  BL21.2
                       system. If entered, it must be valid in   BL21.5  BL29.1
                       the Reason Code file.                     BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-DISC-CODE          Alpha 10                                  BL120   BL122
Element: Discount Code This field holds the discount code used   BL130   BL20.1
                       to assess a discount amount to this line  BL20.3  BL21.2
                       item. If the item is an inventory or      BL21.5  BL29.1
                       non-stock item, and the pricing of this   BL29.2  BL520
                       item includes discounting, the discount   BL820   BL92.1
                       code defaults from the pricing modifier   WH20.7
                       (price list, contract, or promotion) and
                       cannot be changed.

OIL-ORD-DISC-FL        Alpha 1                                   BL120   BL122
Element: Ord Disc Fl   This flag determines whether the order    BL130   BL20.1
                       line is eligible for an allocated         BL20.3  BL21.2
                       discount.                                 BL21.5  BL29.1
                       Y = Yes                                   BL29.2  BL520
                       N = No                                    BL820   BL92.1
                                                                 WH20.7

OIL-CONTRACT-NBR       Alpha 14                                  BL120   BL122
Element: Contract Nbr  If a contract appears on this line        BL130   BL20.1
                       field, the line was priced using this     BL20.3  BL21.2
                       contract number.                          BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-PROMOTION          Alpha 10                                  BL120   BL122
Element: Promotion     If a promotion is found in this field,    BL130   BL20.1
                       this line item was priced using a         BL20.3  BL21.2
                       promotion price modifier.                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-ACTIVITY           Alpha 15                                  BL120   BL122
Element: Activity      In this file the Activity field is used   BL130   BL20.1
                       for the revenue (sales) side of the       BL20.3  BL21.2
                       posting whereas the Activity-C field is   BL21.5  BL29.1
                       used for the Cost (COGS) side of the      BL29.2  BL520
                       posting.                                  BL820   BL92.1
                                                                 WH20.7
                       Activities are the processes or
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity. Activities and
                       cost object activities are used
                       synonymously in Project Accounting.
                       Direct costs are posted to activities,
                       and indirect costs are allocated to
                       activities based on activity drivers.

                       Activities are grouped or organized by
                       activity levels. There are two types of
                       activities: "posting allowed" and
                       "summary only." Use posting level
                       activities to budget and maintain all
                       posted transactions. Summary activities
                       or macro activities combine information
                       and balances from lower level activities
                       for reporting and inquiries.

OIL-ACCT-CATEGORY      Alpha 5                                   BL120   BL122
Element: Acct Category In this file the Acct-Category field is   BL130   BL20.1
                       used for the revenue (sales) postings     BL20.3  BL21.2
                       whereas the Acct-Categ-C field is used    BL21.5  BL29.1
                       for Cost (COGS) postings.                 BL29.2  BL520
                                                                 BL820   BL92.1
                       Account categories are groupings of       WH20.7
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in Project Accounting.
                       All transactions are posted to an
                       account category within an activity. You
                       can assign a specific general ledger
                       account or range of accounts (company,
                       accounting unit, account, and
                       subaccount) that make up the
                       transactions posted to an account
                       category using Account Assignment
                       (AC07.1).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

OIL-ATN-OBJ-ID         Numeric 12                                BL120   BL122
Element: Obj Id        Represents Activity Management system     BL130   BL20.1
                       ID for the revenue (sales) Activity.      BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                       Activities are the processes or           BL29.2  BL520
                       procedures that produce work. Cost        BL820   BL92.1
                       objects (products, services, customers,   WH20.7
                       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.

OIL-ACTIVITY-C         Alpha 15                                  BL120   BL122
Element: Activity      In this file the Activity-C field is      BL130   BL20.1
                       used for the Cost (COGS) side of the      BL20.3  BL21.2
                       posting whereas the Activity field is     BL21.5  BL29.1
                       used for the revenue (sales) side of the  BL29.2  BL520
                       posting.                                  BL820   BL92.1
                                                                 WH20.7
                       Activities are the processes or
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity. Activities and
                       cost object activities are used
                       synonymously in Project Accounting.
                       Direct costs are posted to activities,
                       and indirect costs are allocated to
                       activities based on activity drivers.

                       Activities are grouped or organized by
                       activity levels. There are two types of
                       activities: "posting allowed" and
                       "summary only." Use posting level
                       activities to budget and maintain all
                       posted transactions. Summary activities
                       or macro activities combine information
                       and balances from lower level activities
                       for reporting and inquiries.

OIL-ACCT-CATEG-C       Alpha 5                                   BL120   BL122
Element: Acct Category In this file the Acct-Categ-C field is    BL130   BL20.1
                       used for Cost (COGS) postings whereas     BL20.3  BL21.2
                       the Acct-Category field is used for       BL21.5  BL29.1
                       revenue (sales) postings.                 BL29.2  BL520
                                                                 BL820   BL92.1
                       Account categories are groupings of       WH20.7
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in Project Accounting.
                       All transactions are posted to an
                       account category within an activity. You
                       can assign a specific general ledger
                       account or range of accounts (company,
                       accounting unit, account, and
                       subaccount) that make up the
                       transactions posted to an account
                       category using Account Assignment
                       (AC07.1).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

OIL-ATN-OBJ-ID-C       Numeric 12                                BL120   BL122
Element: Obj Id        The system defined object id              BL130   BL20.1
                       representing the Activity Management      BL20.3  BL21.2
                       commitment for Cost (COGS).               BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-FINAL-INVC-FL      Alpha 1                                   BL120   BL122
Element: All Flag      This flag indicates if the invoice this   BL130   BL20.1
                       line is on is the last invoice for this   BL20.3  BL21.2
                       order.                                    BL21.5  BL29.1
                       Y = Yes                                   BL29.2  BL520
                       N = No                                    BL820   BL92.1
                                                                 WH20.7

OIL-SLS-ACCT-UNIT      Alpha 15                                  BL120   BL122
Element: Acct Unit     Sales account unit to be credited or      BL130   BL20.1
                       debited for this line.                    BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-SLS-ACCOUNT        Numeric 6                                 BL120   BL122
Element: Account       Sales account number to be debited or     BL130   BL20.1
                       credited for this line.                   BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-SLS-SUB-ACCT       Numeric 4                                 BL120   BL122
Element: Sub Acct      Sales subaccount number to be debited     BL130   BL20.1
                       or credited for this line.                BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-SALES-MAJCL        Alpha 4                                   BL120   BL122
Element: Major Class   Sales major class code of the line item.  BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-SALES-MINCL        Alpha 4                                   BL120   BL122
Element: Minor Class   Sales minor class code of the line item.  BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-DSC-AMT            Signed 18.2 Occurs 3 Times                BL120   BL122
Element: Intl Amt      This is the price modifier discount       BL130   BL20.1
                       amount calculated for the line item.      BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-DSC-ACCT-UNIT      Alpha 15 Occurs 3 Times                   BL120   BL122
Element: Acct Unit     These fields store the discount account   BL130   BL20.1
                       units that are to be debited for          BL20.3  BL21.2
                       nonstock line items that are affected by  BL21.5  BL29.1
                       price modifier discounts. These account   BL29.2  BL520
                       units are credited for credit memo line   BL820   BL92.1
                       items.                                    WH20.7

OIL-DSC-ACCOUNT        Numeric 6 Occurs 3 Times                  BL120   BL122
Element: Account       These fields store the discount account   BL130   BL20.1
                       numbers that are to be debited for        BL20.3  BL21.2
                       nonstock line items that are affected by  BL21.5  BL29.1
                       price modifier discounts. The account is  BL29.2  BL520
                       credited for credit memo line items.      BL820   BL92.1
                                                                 WH20.7

OIL-DSC-SUB-ACCT       Numeric 4 Occurs 3 Times                  BL120   BL122
Element: Sub Acct      These fields store the discount           BL130   BL20.1
                       subaccount numbers that are to be         BL20.3  BL21.2
                       debited for nonstock line items that are  BL21.5  BL29.1
                       affected by price modifier discounts.     BL29.2  BL520
                       The account is credited for credit memo   BL820   BL92.1
                       line items.                               WH20.7

OIL-DSC-AMT-CURR       Derived
Element: Dsc Amt Curr  This is the sum total of the price
                       modifier discount amounts as calculated
                       for the line item in original billing
                       currency.

OIL-DSC-AMT-BASE       Signed 18.2                               BL120   BL122
Element: Intl Amt      This is the sum total of the price        BL130   BL20.1
                       modifier discount amounts as calculated   BL20.3  BL21.2
                       for the line item in company base         BL21.5  BL29.1
                       currency.                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-OFF-ACCT-UNIT      Alpha 15                                  BL120   BL122
Element: Acct Unit     This cost of goods offset account unit    BL130   BL20.1
                       will be credited for non-stock and        BL20.3  BL21.2
                       special items ordered that have a cost    BL21.5  BL29.1
                       associated with them. This account can    BL29.2  BL520
                       default from the sales class for          BL820   BL92.1
                       non-stock items and will default from     WH20.7
                       the process level for special items. The
                       account will be debited for return to
                       stock credit memos.

OIL-OFF-ACCOUNT        Numeric 6                                 BL120   BL122
Element: Account       This cost of goods offset account         BL130   BL20.1
                       number will be credited for non-stock     BL20.3  BL21.2
                       and special items that have a cost        BL21.5  BL29.1
                       associated with them. This account can    BL29.2  BL520
                       default from the sales class for          BL820   BL92.1
                       non-stock items and will default from     WH20.7
                       the process level for special items with
                       associated costs. This account will be
                       debited for return to stock credit memo
                       line items.

OIL-OFF-SUB-ACCT       Numeric 4                                 BL120   BL122
Element: Sub Acct      This cost of goods offset subaccount      BL130   BL20.1
                       will be credited for non-stock and        BL20.3  BL21.2
                       special items ordered that have a cost    BL21.5  BL29.1
                       associated with them. This account can    BL29.2  BL520
                       default from the sales class for          BL820   BL92.1
                       non-stock items and will default from     WH20.7
                       the process level for special items with
                       associated costs. The account will be
                       debited for return to stock credit
                       memos.

OIL-CGS-ACCT-UNIT      Alpha 15                                  BL120   BL122
Element: Acct Unit     The cost of goods sold account unit is    BL130   BL20.1
                       debited for non-stock or special items.   BL20.3  BL21.2
                       Defaults from the process level for       BL21.5  BL29.1
                       special orders and defaults from the      BL29.2  BL520
                       sales class for non-stock items. This     BL820   BL92.1
                       account is credited for return to stock   WH20.7
                       credit memo lines.

OIL-CGS-ACCOUNT        Numeric 6                                 BL120   BL122
Element: Account       The cost of goods sold account number     BL130   BL20.1
                       is debited for non-stock or special       BL20.3  BL21.2
                       items. This account defaults from the     BL21.5  BL29.1
                       process level for special orders and      BL29.2  BL520
                       defaults from the sales class for         BL820   BL92.1
                       non-stock items. This account is          WH20.7
                       credited for return to stock credit memo
                       lines.

OIL-CGS-SUB-ACCT       Numeric 4                                 BL120   BL122
Element: Sub Acct      The cost of goods sold subaccount         BL130   BL20.1
                       number is debited for non-stock and       BL20.3  BL21.2
                       special items. This will default from     BL21.5  BL29.1
                       the process level for special orders and  BL29.2  BL520
                       defaults from the sales class for         BL820   BL92.1
                       non-stock items. This account is          WH20.7
                       credited for return to stock credit memo
                       lines.

OIL-LAST-MISC-SEQ      Numeric 3                                 BL120   BL122
Element: Seq           This value indicates the number of the    BL130   BL20.1
                       last add-on charge attached to this       BL20.3  BL21.2
                       line. This value determines the sequence  BL21.5  BL29.1
                       number of the next add-on charge.         BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-LAST-COMM-SEQ      Numeric 3                                 BL120   BL122
Element: Seq           This is the sequence number of the last   BL130   BL20.1
                       comment line entered for this invoice     BL20.3  BL21.2
                       line.                                     BL21.4  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  BLI2.1
                                                                 WH20.7

OIL-TERRITORY          Alpha 4                                   BL120   BL122
Element: Territory     The sales territory to which this line    BL130   BL20.1
                       belongs. The territory is determined      BL20.3  BL21.2
                       based upon the customer and the sales     BL21.5  BL29.1
                       representative assigned to the customer.  BL29.2  BL520
                       Territory can be overridden online when   BL820   BL92.1
                       adding an invoice.                        WH20.7

OIL-SALESMAN           Numeric 4                                 BL120   BL122
Element: Salesman      The primary sales representative          BL130   BL20.1
                       responsible for this order and/or         BL20.3  BL21.2
                       invoice. Defaults from the customer       BL21.5  BL29.1
                       ship-to for this order, or if the         BL29.2  BL520
                       ship-to is not entered, will default      BL820   BL92.1
                       from the customer master. The sales       WH20.7
                       representative can be overridden when
                       entering an order and/or invoice.

                       This is the sales representative to
                       which the invoice or order belongs. This
                       will default from the customer master or
                       can be overridden when placing the order
                       or entering the invoice.

OIL-SALESMAN-2         Numeric 4                                 BL120   BL122
Element: Salesman      The secondary sales representative        BL130   BL20.1
                       responsible for this order and/or         BL20.3  BL21.2
                       invoice. Defaults from the customer       BL21.5  BL29.1
                       ship-to for this order, or if the         BL29.2  BL520
                       ship-to is not entered, will default      BL820   BL92.1
                       from the customer master.                 WH20.7

OIL-COMM-RATE-1        Percent 7.5  (Percent)                    BL120   BL122
Element: Chrg Rate     Commission rate for sales                 BL130   BL20.1
                       representative 1. Defaults from the       BL20.3  BL21.2
                       sales representative record.              BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-COMM-RATE-2        Percent 7.5  (Percent)                    BL120   BL122
Element: Chrg Rate     Commission rate for sales                 BL130   BL20.1
                       representative 2. Defaults from the       BL20.3  BL21.2
                       salesman record.                          BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-COMM-SPLIT         Percent 5.3  (Percent)                    BL120   BL122
Element: Comm Split    The portion of the invoice line that      BL130   BL20.1
                       the second sales representative's         BL20.3  BL21.2
                       commission percent is applied to. The     BL21.5  BL29.1
                       first sales representative's commission   BL29.2  BL520
                       percent is applied to the remaining       BL820   BL92.1
                       amount. Defaults from the Customer        WH20.7
                       Master file.

OIL-USER-FLD1          Alpha 2                                   BL120   BL122
Element: Po User Fld 2 This is the first user-defined field on   BL130   BL20.1
                       the invoice line. These user-defined      BL20.3  BL21.2
                       field values, if entered, and the line    BL21.5  BL29.1
                       is a create PO = Yes, will interface      BL29.2  BL520
                       into Purchase Order and appear on the     BL820   BL92.1
                       purchase order line in the purchase       WH20.7
                       order user-defined fields.

OIL-USER-FLD2          Alpha 30  (Lower Case)                    BL120   BL122
Element: User Fld2     The second user-defined field on the      BL130   BL20.1
                       invoice line. These user-defined field    BL20.3  BL21.2
                       values, if entered and the line creates   BL21.5  BL29.1
                       a purchase order, will interface into     BL29.2  BL520
                       Purchase Order and appear on the          BL820   BL92.1
                       purchase order line in the purchase       WH20.7
                       order user-defined fields.

OIL-USER-FLD3          Alpha 15  (Lower Case)                    BL120   BL122
Element: User Fld3     The third user-defined field on the       BL130   BL20.1
                       invoice line. These user-defined field    BL20.3  BL21.2
                       values, if entered and the line creates   BL21.5  BL29.1
                       a purchase order, will interface into     BL29.2  BL520
                       Purchase Order and appear on the          BL820   BL92.1
                       purchase order line in the purchase       WH20.7
                       order user-defined fields.

OIL-LINE-GRS-CURR      Signed 18.2                               BL120   BL122
Element: Intl Amt      This is the gross amount of the line in   BL130   BL20.1
                       original billing currency. Calculated by  BL20.3  BL21.2
                       multiplying quantity by sell price in     BL21.5  BL29.1
                       billing currency.                         BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-INVL-OBJ-ID        Numeric 12
Element: Invl Obj Id

OIL-PROD-TAX-CAT       Alpha 15                                  BL120   BL122
Element: Prod Tax Cat  A classification of items for             BL130   BL20.1
                       determining taxes using the VERTEX        BL20.3  BL21.2
                       system in Lawson Order Entry system or    BL21.5  BL29.1
                       the cash receipts programs in the Lawson  BL29.2  BL520
                       Cash Ledger system.                       BL820   BL92.1
                                                                 WH20.7

OIL-LINE-NET-CURR      Derived
Element: Line Net Curr This is the net amount of the line in
                       original billing currency. This is
                       calculated in the following way: Line
                       gross amount in billing currency -
                       entered discount - discount amount in
                       billing currency.

OIL-LINE-NTX-CURR      Derived
Element: Line Ntx Curr Net amount for tax purposes. Allocated
                       discount from header also subtracted
                       from gross.

OIL-LINE-GRS-BASE      Signed 18.2                               BL120   BL122
Element: Intl Amt      This is the gross amount of the line in   BL130   BL20.1
                       original company base currency.           BL20.3  BL21.2
                       Calculated by multiplying Quantity by     BL21.5  BL29.1
                       Sell Unit Price.                          BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OIL-LINE-NET-BASE      Derived
Element: Line Net Base This is the net amount of the line in
                       company base currency. This is
                       calculated in the following way: line
                       gross amount in base currency - add-on
                       discount - discount amount in base
                       currency.

OIL-QTY-IN-STOCK       Derived
Element: Qty In Stock  Order quantity in the stock unit of
                       measure.

OIL-LINE-COST          Derived
Element: Line Cost     The total cost of the line item.

OIL-S-ACCT-UNIT        Derived
Element: S Acct Unit   The sales account unit that the system
                       posts to.

OIL-S-ACCOUNT          Derived
Element: S Account     The sales account that the system posts
                       to.

OIL-S-SUB-ACCT         Derived
Element: S Sub Acct    The sales subaccount that the system
                       posts to.

OIL-D1-ACCT-UNIT       Derived
Element: D1 Acct Unit  The first discount account unit that
                       the system posts to.

OIL-D1-ACCOUNT         Derived
Element: D1 Account    The first discount account that the
                       system posts to.

OIL-D1-SUB-ACCT        Derived
Element: D1 Sub Acct   The first discount subaccount that the
                       system posts to.

OIL-D2-ACCT-UNIT       Derived
Element: D2 Acct Unit  The second discount account unit that
                       the system posts to.

OIL-D2-ACCOUNT         Derived
Element: D2 Account    The second discount account that the
                       system posts to.

OIL-D2-SUB-ACCT        Derived
Element: D2 Sub Acct   The second discount subaccount that the
                       system posts to.

OIL-D3-ACCT-UNIT       Derived
Element: D3 Acct Unit  The third discount account unit that
                       the system posts to.

OIL-D3-ACCOUNT         Derived
Element: D3 Account    The third discount account that the
                       system posts to.

OIL-D3-SUB-ACCT        Derived
Element: D3 Sub Acct   The third discount subaccount that the
                       system posts to.

OIL-D1-AMOUNT          Derived
Element: D1 Amount     The dollar amount for the first
                       discount.

OIL-D2-AMOUNT          Derived
Element: D2 Amount     The dollar amount for the second
                       discount.

OIL-D3-AMOUNT          Derived
Element: D3 Amount     The dollar amount for the third
                       discount.

OIL-I-ACCT-UNIT        Derived
Element: I Acct Unit   The inventory account unit that the
                       system posts to.

OIL-I-ACCOUNT          Derived
Element: I Account     The inventory account that the system
                       posts to.

OIL-I-SUB-ACCT         Derived
Element: I Sub Acct    The inventory subaccount that the
                       system posts to.

OIL-C-ACCT-UNIT        Derived
Element: C Acct Unit   The cost of goods sold account unit
                       that the system posts to.

OIL-C-ACCOUNT          Derived
Element: C Account     The cost of goods sold account that the
                       system posts to.

OIL-C-SUB-ACCT         Derived
Element: C Sub Acct    The cost of goods sold subaccount that
                       the system posts to.

                         OEINVCLINE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OILSET1   COMPANY                                                BL120   BL121
          INVC-PREFIX                                            BL122   BL123
          INVC-NUMBER                                            BL125   BL130
          LINE-NBR                                               BL20.1  BL20.3
                                                                 BL20.5  BL20.6
                                                                 BL21.2  BL21.4
                                                                 BL21.5  BL21.6
                                                                 BL220   BL232
                                                                 BL29.1  BL29.2
                                                                 BL290   BL320
                                                                 BL520   BL80.1
                                                                 BL81.1  BL820
                                                                 BL92.1  BLI2.1
                                                                 TX101   WH20.7

OILSET2   COMPANY       Subset                                   BL120   BL122
          INVC-PREFIX   Where PRICE-STATUS = "A"                 BL130   BL20.1
          INVC-NUMBER                                            BL20.3  BL21.2
          SALES-MAJCL                                            BL21.5  BL29.1
          SALES-MINCL                                            BL29.2  BL520
          LINE-NBR                                               BL820   BL92.1
                                                                 WH20.7

OILSET3   ATN-OBJ-ID    KeyChange, Subset
                        Where ATN-OBJ-ID != Zeroes

OILSET4   ATN-OBJ-ID-C  KeyChange, Subset
                        Where ATN-OBJ-ID-C != Zeroes

OILSET5   COMPANY       KeyChange                                BL120   BL122
          INVC-PREFIX                                            BL130   BL20.1
          INVC-NUMBER                                            BL20.3  BL21.2
          TAX-CODE                                               BL21.5  BL29.1
          PROD-TAX-CAT                                           BL29.2  BL520
          LINE-NBR                                               BL820   BL92.1
                                                                 WH20.7

OILSET6   COMPANY                                                BL120   BL122
          INVC-PREFIX                                            BL130   BL20.1
          LINE-NBR                                               BL20.3  BL21.2
          INVC-NUMBER                                            BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

                         OEINVCLINE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Add On Disc    GLMASTER     Not Required

                            OIL-COMPANY          -> GLM-COMPANY
                            OEP-DSC-ACCT-UNIT    -> GLM-ACCT-UNIT
                            OEP-DSC-ACCOUNT      -> GLM-ACCOUNT
                            OEP-DSC-SUB-ACCT     -> GLM-SUB-ACCOUNT

Arcomp         ARCOMP       Required

                            OIL-COMPANY          -> ACO-COMPANY

Bloiluf        BLOILUF      Not Required

                            OIL-COMPANY          -> BDU-COMPANY
                            OIL-INVC-PREFIX      -> BDU-INVC-PREFIX
                            OIL-INVC-NUMBER      -> BDU-INVC-NUMBER
                            OIL-LINE-NBR         -> BDU-LINE-NBR

Blricline      BLRICLINE    Not Required
                            Valid When OEI-RECUR-INVOICE != Spaces

                            OIL-COMPANY          -> BUL-COMPANY
                            OEI-RECUR-INVOICE    -> BUL-RECUR-INVOICE
                            OEI-CUSTOMER         -> BUL-CUSTOMER
                            OIL-LINE-NBR         -> BUL-LINE-NBR

Blrimast       BLRIMAST     Not Required
                            Valid When OEI-RECUR-INVOICE != Spaces

                            OIL-COMPANY          -> BRM-COMPANY
                            OEI-RECUR-INVOICE    -> BRM-RECUR-INVOICE

Blrimline      BLRIMLINE    Not Required
                            Valid When OEI-RECUR-INVOICE != Spaces

                            OIL-COMPANY          -> BML-COMPANY
                            OEI-RECUR-INVOICE    -> BML-RECUR-INVOICE
                            BUL-MAST-LINE-NBR    -> BML-LINE-NBR

Cogs Account   GLMASTER     Not Required

                            OIL-COMPANY          -> GLM-COMPANY
                            OIL-CGS-ACCT-UNIT    -> GLM-ACCT-UNIT
                            OIL-CGS-ACCOUNT      -> GLM-ACCOUNT
                            OIL-CGS-SUB-ACCT     -> GLM-SUB-ACCOUNT

Coline         COLINE       Not Required

                            OIL-COMPANY          -> COL-COMPANY
                            OIL-ORDER-NBR        -> COL-ORDER-NBR
                            OIL-LINE-NBR         -> COL-LINE-NBR

Custdesc       CUSTDESC     Required

                            ACO-CUST-GROUP       -> CUD-CUST-GROUP
                            OEI-CUSTOMER         -> CUD-CUSTOMER

Iccategory     ICCATEGORY   Not Required
                            Valid When OIL-LINE-TYPE = "I"

                            OIL-COMPANY          -> ICA-COMPANY
                            OIL-LOCATION         -> ICA-LOCATION
                            ITL-GL-CATEGORY      -> ICA-GL-CATEGORY

Iccompany      ICCOMPANY    Required
                            When OIL-LINE-TYPE != "X"

                            OIL-COMPANY          -> ICC-COMPANY

Inventory Acct GLMASTER     Not Required

                            OIL-COMPANY          -> GLM-COMPANY
                            OIL-OFF-ACCT-UNIT    -> GLM-ACCT-UNIT
                            OIL-OFF-ACCOUNT      -> GLM-ACCOUNT
                            OIL-OFF-SUB-ACCT     -> GLM-SUB-ACCOUNT

Itemloc        ITEMLOC      Required
                            When OIL-LINE-TYPE = "I"

                            OIL-COMPANY          -> ITL-COMPANY
                            OIL-LOCATION         -> ITL-LOCATION
                            OIL-ITEM             -> ITL-ITEM

Itemmast       ITEMMAST     Required
                            When OIL-LINE-TYPE = "I"
                            Or   OIL-LINE-TYPE = "N"

                            ICC-ITEM-GROUP       -> ITE-ITEM-GROUP
                            OIL-ITEM             -> ITE-ITEM

Oecompany      OECOMPANY    Required

                            OIL-COMPANY          -> OEC-COMPANY

Oecsline       BLRICLINE    Not Required
                            Valid When OEI-RECUR-INVOICE != Spaces

                            OIL-COMPANY          -> BUL-COMPANY
                            OEI-RECUR-INVOICE    -> BUL-RECUR-INVOICE
                            OEI-CUSTOMER         -> BUL-CUSTOMER
                            OIL-LINE-NBR         -> BUL-LINE-NBR

Oecustsrvc     BLRICUST     Not Required

                            OIL-COMPANY          -> BRC-COMPANY
                            OEI-RECUR-INVOICE    -> BRC-RECUR-INVOICE
                            OEI-CUSTOMER         -> BRC-CUSTOMER

Oediscount     OEDISCOUNT   Required

                            OIL-COMPANY          -> OED-COMPANY
                            OIL-DISC-CODE        -> OED-DISC-CODE

Oeincdgblk     OEINVSGBLK   Not Required

                            OIL-COMPANY          -> OSB-COMPANY
                            OIL-INVC-PREFIX      -> OSB-INVC-PREFIX
                            OIL-INVC-NUMBER      -> OSB-INVC-NUMBER
                            OIL-LINE-NBR         -> OSB-LINE-NBR
                            Zeroes               -> OSB-SEQ

Oeinvcuom      OEINVCUOM    Not Required
                            Valid When OIL-MULT-SPR-FL = "Y"

                            OIL-COMPANY          -> OEU-COMPANY
                            OIL-INVC-PREFIX      -> OEU-INVC-PREFIX
                            OIL-INVC-NUMBER      -> OEU-INVC-NUMBER
                            OIL-LINE-NBR         -> OEU-LINE-NBR

Oeinvhdr       OEINVHDR     Required
                            When OEI-BATCH-NBR != Zeroes

                            OIL-COMPANY          -> OIH-COMPANY
                            OEI-BATCH-NBR        -> OIH-BATCH-NBR

Oeinvoice      OEINVOICE    Required

                            OIL-COMPANY          -> OEI-COMPANY
                            OIL-INVC-PREFIX      -> OEI-INVC-PREFIX
                            OIL-INVC-NUMBER      -> OEI-INVC-NUMBER

Oemastsrvc     BLRIMAST     Not Required
                            Valid When OEI-RECUR-INVOICE != Spaces

                            OIL-COMPANY          -> BRM-COMPANY
                            OEI-RECUR-INVOICE    -> BRM-RECUR-INVOICE

Oemsline       BLRIMLINE    Not Required
                            Valid When OEI-RECUR-INVOICE != Spaces

                            OIL-COMPANY          -> BML-COMPANY
                            OEI-RECUR-INVOICE    -> BML-RECUR-INVOICE
                            BUL-MAST-LINE-NBR    -> BML-LINE-NBR

Oeproclev      OEPROCLEV    Required

                            OIL-COMPANY          -> OEP-COMPANY
                            OEI-PROCESS-LEVEL    -> OEP-PROCESS-LEVEL

Oereason       OEREASON     Required
                            When OIL-REASON-CODE != Spaces

                            OIL-COMPANY          -> OER-COMPANY
                            OIL-REASON-CODE      -> OER-REASON-CODE

Oeshipline     WHSHIPLINE   Not Required

                            OIL-COMPANY          -> WHL-COMPANY
                            OIL-LOCATION         -> WHL-LOCATION
                            OIL-SHIPMENT-NBR     -> WHL-SHIPMENT-NBR
                            OIL-LINE-NBR         -> WHL-LINE-NBR

Oeshipment     WHSHIPMENT   Required
                            When OEI-INVC-SOURCE = "S"

                            OIL-COMPANY          -> WHS-COMPANY
                            OIL-LOCATION         -> WHS-LOCATION
                            OEI-SHIPMENT-NBR     -> WHS-SHIPMENT-NBR

Oeslsacct      OESLSACCT    Not Required
                            Valid When OIL-LINE-TYPE = "I"
                                  Or   OIL-LINE-TYPE = "N"

                            OIL-COMPANY          -> OSA-COMPANY
                            OEI-PROCESS-LEVEL    -> OSA-PROCESS-LEVEL
                            OIL-SALES-MAJCL      -> OSA-SALES-MAJCL
                            OIL-SALES-MINCL      -> OSA-SALES-MINCL

Price List     OEPRCLIST    Required

                            OIL-COMPANY          -> OPL-COMPANY
                            Spaces               -> OPL-CUSTOMER
                            OEI-LIST-NAME        -> OPL-LIST-NAME
                            Spaces               -> OPL-PROMOTION

Sales Account  GLMASTER     Not Required

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

Salesman       SALESREP     Required

                            OIL-COMPANY          -> SAW-COMPANY
                            OIL-SALESMAN         -> SAW-SALESMAN

Salesman2      SALESREP     Required
                            When OIL-SALESMAN-2 != Zeroes

                            OIL-COMPANY          -> SAW-COMPANY
                            OIL-SALESMAN-2       -> SAW-SALESMAN

Salesrep       SALESREP     Required

                            OIL-COMPANY          -> SAW-COMPANY
                            OIL-SALESMAN         -> SAW-SALESMAN

Salesrep2      SALESREP     Required
                            When OIL-SALESMAN-2 != Zeroes

                            OIL-COMPANY          -> SAW-COMPANY
                            OIL-SALESMAN-2       -> SAW-SALESMAN

Teritory       TERITORY     Required

                            OIL-COMPANY          -> TRY-COMPANY
                            OIL-TERRITORY        -> TRY-TERRITORY

Txtaxcode      TXTAXCODE    Required
                            When OIL-TAX-CODE      != Spaces
                            And  OIL-TAX-EXEMPT-CD =  "T"

                            OIL-COMPANY          -> TAC-COMPANY
                            OIL-TAX-CODE         -> TAC-TAX-CODE

Whdemndhdr     WHDEMNDHDR   Not Required

                            OIL-COMPANY          -> WDH-COMPANY
                            "OE"                 -> WDH-SYSTEM-CD
                            OIL-ORDER-NBR        -> WDH-DOC-NBR-NUM

                         OEINVCLINE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cocomp         COCOMP

                            OIL-COMPANY          -> CKT-COMPANY
                            "OE"                 -> CKT-SYSTEM-CD
                            WDH-DOC-NBR          -> CKT-DOC-NBR
                            OIL-LINE-NBR         -> CKT-LINE-NBR
                                                    CKT-COMPONENT-SEQ

Comisc         COMISC       Required

                            OIL-COMPANY          -> CMC-COMPANY
                            OIL-ORDER-NBR        -> CMC-ORDER-NBR
                            OIL-LINE-NBR         -> CMC-LINE-NBR
                                                    CMC-SEQ

Line Comments  OEINVCCOMM   Delete Restricted

                            OIL-COMPANY          -> OIC-COMPANY
                            OIL-INVC-PREFIX      -> OIC-INVC-PREFIX
                            OIL-INVC-NUMBER      -> OIC-INVC-NUMBER
                            OIL-LINE-NBR         -> OIC-LINE-NBR
                                                    OIC-SEQ

Line Misc      OEINVCMISC

                            OIL-COMPANY          -> OIM-COMPANY
                            OIL-INVC-PREFIX      -> OIM-INVC-PREFIX
                            OIL-INVC-NUMBER      -> OIM-INVC-NUMBER
                            OIL-LINE-NBR         -> OIM-LINE-NBR
                                                    OIM-SEQ

Line Tax       OEINVCTAX
                            Valid When OEC-TAX-PRINT-CD = "D"

                            OIL-COMPANY          -> OIT-COMPANY
                            OIL-INVC-PREFIX      -> OIT-INVC-PREFIX
                            OIL-INVC-NUMBER      -> OIT-INVC-NUMBER
                            OIL-LINE-NBR         -> OIT-LINE-NBR
                                                    OIT-TAX-CODE
                                                    OIT-SEQ
                                                    OIT-TAX-LEVEL

Oedist         OEDIST
                            Valid When OEI-STATUS = 9

                            OIL-COMPANY          -> ODI-COMPANY
                            OIL-INVC-PREFIX      -> ODI-INVC-PREFIX
                            OIL-INVC-NUMBER      -> ODI-INVC-NUMBER
                            Zeroes               -> ODI-AUTH-NO
                            OIL-LINE-NBR         -> ODI-LINE-NBR
                                                    ODI-ACCT-UNIT
                                                    ODI-ACCOUNT
                                                    ODI-SUB-ACCOUNT
                                                    ODI-SEQ
                                                    ODI-POSTING-TYPE

Oeinvccomm     OEINVCCOMM

                            OIL-COMPANY          -> OIC-COMPANY
                            OIL-INVC-PREFIX      -> OIC-INVC-PREFIX
                            OIL-INVC-NUMBER      -> OIC-INVC-NUMBER
                            OIL-LINE-NBR         -> OIC-LINE-NBR
                                                    OIC-SEQ

Oeinvcdtl      OEINVCDTL

                            OIL-COMPANY          -> OID-COMPANY
                            OIL-INVC-PREFIX      -> OID-INVC-PREFIX
                            OIL-INVC-NUMBER      -> OID-INVC-NUMBER
                            OIL-LINE-NBR         -> OID-LINE-NBR
                                                    OID-UOM
                                                    OID-LOT
                                                    OID-SUBLOT
                                                    OID-BIN
                                                    OID-SERIAL

Oeinvcmisc     OEINVCMISC

                            OIL-COMPANY          -> OIM-COMPANY
                            OIL-INVC-PREFIX      -> OIM-INVC-PREFIX
                            OIL-INVC-NUMBER      -> OIM-INVC-NUMBER
                            OIL-LINE-NBR         -> OIM-LINE-NBR
                                                    OIM-SEQ

Oeinvctax      OEINVCTAX    Required

                            OIL-COMPANY          -> OIT-COMPANY
                            OIL-INVC-PREFIX      -> OIT-INVC-PREFIX
                            OIL-INVC-NUMBER      -> OIT-INVC-NUMBER
                            OIL-LINE-NBR         -> OIT-LINE-NBR
                            Zeroes               -> OIT-SEQ
                                                    OIT-TAX-CODE
                                                    OIT-TAX-LEVEL

Oeinvsgblk     OEINVSGBLK

                            OIL-COMPANY          -> OSB-COMPANY
                            OIL-INVC-PREFIX      -> OSB-INVC-PREFIX
                            OIL-INVC-NUMBER      -> OSB-INVC-NUMBER
                            OIL-LINE-NBR         -> OSB-LINE-NBR
                                                    OSB-SEQ

Polinesrc      POLINESRC
                            Valid When COL-CREATE-PO = "Y"

                            OIL-COMPANY          -> PLS-OPER-COMPANY
                            "OE"                 -> PLS-ORIGIN-CD
                            OIL-ORDER-NBR        -> PLS-SOURCE-DOC-N
                            COL-LINE-NBR         -> PLS-SRC-LINE-NBR
                                                    PLS-PO-CODE
                                                    PLS-PO-NUMBER
                                                    PLS-PO-RELEASE
                                                    PLS-LINE-NBR

Returnline     RETURNLINE

                            OIL-COMPANY          -> RTL-COMPANY
                            OEI-CUSTOMER         -> RTL-CUSTOMER
                            OIL-ITEM             -> RTL-ITEM
                            OEI-SHIP-TO          -> RTL-SHIP-TO
                                                    RTL-DATE
                                                    RTL-AUTH-NO
                                                    RTL-LINE-NBR