Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OEINVOICE


                             OEINVOICE FILE

                                Invoice

This file stores invoice records created automatically when processing an
order through OE129 (Daily Shipment Journal) and those created manually when
entering an invoice on BL20.1 (Invoice Entry) or a return on BL30.1 (Recurring
Invoices).

REFERENCED BY

AR21.6    AR31.5    AR33.5    AR42.2    AR42.7    BL00.1
BL01.1    BL217     BL220     BL232     BL290     BL291
BL80.1    BL80.2    BL80.3    BL80.4    BL80.6    BL81.1
OE130     OE272     OE294     OE10.1    OE10.2    OE10.3
OE10.4    OE10.5    OE10.6    OE10.7    OE10.8    OE11.1
OE11.4    OE11.8    OE11.9    OE110     OE111     OE113
OE13.2    OE14.4    OE510     OE810     WH20.2    WH20.7
AR08.1    AR10.1    AR501     AR550     BL199

UPDATED BY

BL120     BL121     BL122     BL123     BL125     BL130
BL20.1    BL20.3    BL21.2    BL21.3    BL21.5    BL29.1
BL29.2    BL320     BL520     BL820     BL91.1    BL92.1
BLI2.1    OE114     OE129     OE30.1    OE30.2    OE30.3
OE30.4    OE30.5    OE30.6    OE30.7    OE30.9    OE310
OE330     OE530     OE830     SA100     SA101     TX101

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OEI-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
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-INVC-PREFIX        Alpha 2                                   BL120   BL122
Element: Invoice PrefixThis 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
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-INVC-NUMBER        Numeric 8                                 BL120   BL122
Element: Invc Number   The invoice number assigned by the        BL130   BL20.1
                       system. Invoice numbers are assigned at   BL20.3  BL21.2
                       the company or process level, depending   BL21.5  BL29.1
                       on the company setting.                   BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-BATCH-NBR          Numeric 6                                 BL120   BL122
Element: Batch Number  The batch to which the invoices and       BL130   BL20.1
                       credit memos belong. The system assigns   BL20.3  BL21.2
                       the batch when the records are added.     BL21.5  BL29.1
                       You can specify a control total on each   BL29.2  BL520
                       batch by using BL29.1 (Batch Control)     BL820   BL92.1
                       after  the batch has been added and       OE114   OE129
                       entering  the totals that must equal the  OE30.1  OE30.2
                       detail  entered in the batch before       OE30.3  OE30.4
                       releasing  the batch.                     OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-PROCESS-LEVEL      Alpha 5                                   BL120   BL122
Element: Process Level This field contains the process level,    BL130   BL20.1
                       which is the reporting hierarchy below    BL20.3  BL21.2
                       company.                                  BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-LOCATION           Alpha 5                                   BL120   BL122
Element: Location Code Enter the inventory ship-from location.   BL130   BL20.1
                       This location is used for pricing         BL20.3  BL21.2
                       (prices can vary by location) and as a    BL21.5  BL29.1
                       reference when a return to stock          BL29.2  BL520
                       situation exists. The location entered    BL820   BL92.1
                       here will default to the invoice line     OE114   OE129
                       level.                                    OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-ORIG-INVC-PRE      Alpha 2                                   BL120   BL122
Element: Invoice PrefixThis field contains the prefix of the     BL130   BL20.1
                       original invoice against which the        BL20.3  BL21.2
                       return is being made.                     BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-ORIG-INVC-NBR      Numeric 8                                 BL120   BL122
Element: Invc Number   This field contains the number of the     BL130   BL20.1
                       original invoice against which the        BL20.3  BL21.2
                       return is being made.                     BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-AUTO-APP-FL        Alpha 1                                   BL120   BL122
Element: Auto App Fl   Automatically applies this credit memo    BL130   BL20.1
                       to the original invoice.                  BL20.3  BL21.2
                       Y = Yes                                   BL21.5  BL29.1
                       N = No                                    BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-BILL-TO            Numeric 4                                 BL120   BL122
Element: Bill To       This field contains the mailing address   BL130   BL20.1
                       for this invoice.                         BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-CUSTOMER           Alpha 9  (Right Justified)                BL120   BL122
Element: Customer NumbeEnter the customer identifier, which      BL130   BL20.1
                       represents the customer for which the     BL20.3  BL21.2
                       invoice is being created.                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-SHIP-TO            Numeric 4                                 BL120   BL122
Element: Ship-to Code  Enter the customer's ship-to location     BL130   BL20.1
                       (the mailing address for the goods).      BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-AR-DETAIL          Alpha 1                                   BL120   BL122
Element: Ar Detail     Flag to indicate whether detail           BL130   BL20.1
                       postings are to be made to Accounts       BL20.3  BL21.2
                       Receivable.                               BL21.5  BL29.1
                       A = Multiple Activities                   BL29.2  BL520
                       M = Mixed sign - Multiple Activity        BL820   BL92.1
                       N = No Detail                             OE114   OE129
                       S = Mixed Sign                            OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-INVC-TYPE          Alpha 4                                   BL120   BL122
Element: Invoice Type  The invoice type is updated in this       BL130   BL20.1
                       field. This is a required field and can   BL20.3  BL21.2
                       default from the order type (which can    BL21.5  BL29.1
                       then be assigned to the user identifier   BL29.2  BL520
                       as a default) when an order is processed  BL820   BL92.1
                       through invoicing. If you are entering    OE114   OE129
                       an invoice unrelated to an order, you     OE30.1  OE30.2
                       must enter this invoice type. Define      OE30.3  OE30.4
                       invoice types using BL06.1 (Invoice       OE30.5  OE30.6
                       Types). The invoice type identifies the   OE30.7  OE30.9
                       record being entered as either an         OE530   OE830
                       invoice or credit memo.

OEI-INVC-SOURCE        Alpha 1                                   BL120   BL122
Element: Invc Source   This value is updated automatically by    BL130   BL20.1
                       the system when an invoice is created.    BL20.3  BL21.2
                       It is designed to identify where the      BL21.5  BL29.1
                       invoice came from, for example, was it    BL29.2  BL520
                       interfaced, did it come from processing   BL820   BL92.1
                       a shipment, was it manually entered, and  OE114   OE129
                       so on.                                    OE30.1  OE30.2
                       I = Interfaced                            OE30.3  OE30.4
                       M = Manual                                OE30.5  OE30.6
                       S = Shipment                              OE30.7  OE30.9
                       R = Return                                OE530   OE830
                       C = Recurring Invoice
                       A = Activity

OEI-INVOICE-DATE       Numeric 8  (yyyymmdd)                     BL120   BL122
Element: Invoice Date  The date the invoice was created. The     BL130   BL20.1
                       basis date for the terms discount and     BL20.3  BL21.2
                       due date calculations. For                BL21.5  BL29.1
                       system-generated invoices, the invoice    BL29.2  BL520
                       date is the system date assigned when     BL820   BL92.1
                       running OE129 (Daily Shipment Journal).   OE114   OE129
                       For manual invoices, this date will       OE30.1  OE30.2
                       default to the system date and you can    OE30.3  OE30.4
                       override it.                              OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-TAX-PNT-DATE       Numeric 8  (yyyymmdd)                     BL120   BL122
Element: Date          The date used to find the effective tax   BL130   BL20.1
                       rate.                                     BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-PRICE-DATE         Numeric 8  (yyyymmdd)                     BL120   BL122
Element: Date          This is the date with which the price     BL130   BL20.1
                       has been determined. This will default    BL20.3  BL21.2
                       to the invoice date but can be            BL21.5  BL29.1
                       overridden when entering an invoice into  BL29.2  BL520
                       the system.                               BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-STATUS             Numeric 1                                 BL120   BL121
Element: Status        The status of the invoice; for example,   BL122   BL123
                       released, edited, printed, and so on.     BL130   BL20.1
                       0 = Unreleased                            BL20.3  BL21.2
                       1 = Released                              BL21.5  BL29.1
                       2 = Edited                                BL29.2  BL520
                       3 = Printed                               BL820   BL92.1
                       9 = AR/GL Updated                         OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-GL-DATE            Numeric 8  (yyyymmdd)                     BL120   BL122
Element: General LedgerThe general ledger posting date.          BL130   BL20.1
                       Defaults to the invoice date.             BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-BOOKED-DATE        Numeric 8  (yyyymmdd)                     BL120   BL122
Element: Date          Date this invoice was booked into the     BL130   BL20.1
                       Sales Analysis system.                    BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830
                                                                 SA100   SA101

OEI-CHECK-NBR          Numeric 8                                 BL120   BL122
Element: Payment NumberThis field contains the identifier of     BL130   BL20.1
                       the payment that was entered for the      BL20.3  BL21.2
                       order associated with the invoice if the  BL21.5  BL29.1
                       customer is required to send a down       BL29.2  BL520
                       payment or cash in advance when placing   BL820   BL92.1
                       the order.                                OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-TERMS-CD           Alpha 5                                   BL120   BL122
Element: Terms Code    The payment terms code that is used to    BL130   BL20.1
                       determine the invoice due date and any    BL20.3  BL21.2
                       payment discounts. This will default      BL21.5  BL29.1
                       from the customer master or you can       BL29.2  BL520
                       override it when entering the order or    BL820   BL92.1
                       invoice.                                  OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-BANK-INST-CODE     Alpha 3                                   BL120   BL122
Element: Transaction CoA transaction code represents a type of   BL130   BL20.1
                       cash payment, bill of exchange payment,   BL20.3  BL21.2
                       or bank service transaction.              BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-HOLD-CODE          Alpha 4                                   BL120   BL122
Element: Hold Code     This is the hold code that determines     BL125   BL130
                       why an invoice is on hold. If there is a  BL20.1  BL20.3
                       value in this field, the invoice is on    BL21.2  BL21.5
                       hold and will be prevented from being     BL29.1  BL29.2
                       processed through the invoice printing    BL520   BL820
                       phase.                                    BL91.1  BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-REASON-CODE        Alpha 4                                   BL120   BL122
Element: Reason Code   Reason code is used to indicate the       BL130   BL20.1
                       cause for credit memos. It is allowed on  BL20.3  BL21.2
                       invoices also. If entered, it must be     BL21.5  BL29.1
                       valid in the Reason Code file.            BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-LIST-NAME          Alpha 14                                  BL120   BL122
Element: List Name     This is the name of the price list that   BL130   BL20.1
                       is tied to the customer master record.    BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-AUTH-NO            Numeric 10
Element: Auth No

OEI-CUST-RET-REF       Alpha 10
Element: Cust Ret Ref

OEI-REFERENCE          Alpha 10  (Lower Case)                    BL120   BL122
Element: Reference     An available field to enter any kind of   BL130   BL20.1
                       reference information on the order or     BL20.3  BL21.2
                       invoice.                                  BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-LETTER-OF-CR       Alpha 20                                  BL120   BL122
Element: Letter of CredOptionally enter the letter of credit     BL130   BL20.1
                       number for this invoice.                  BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-ORDER-NBR          Numeric 8                                 BL120   BL122
Element: Order Number  The number of the order associated with   BL130   BL20.1
                       this invoice.                             BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-SHIPMENT-NBR       Numeric 10                                BL120   BL122
Element: Shipment NumbeThe number of the shipment of the order   BL130   BL20.1
                       to which the invoice belongs.             BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-ENTERED-DISC       Signed 18.2                               BL120   BL122
Element: Intl Amt      This is the amount of the add-on          BL130   BL20.1
                       discount entered in invoice currency.     BL20.3  BL21.2
                       Note: a system invoice can have both an   BL21.5  BL29.1
                       entered discount as well as an order      BL29.2  BL520
                       discount.                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-ADD-ON-DISC        Signed 18.2                               BL120   BL122
Element: Intl Amt      This is the amount of the add-on          BL130   BL20.1
                       discount in company base currency.        BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-CIA-AMT            Signed 18.2                               BL120   BL122
Element: Intl Amt      The amount of cash in advance (down       BL130   BL20.1
                       payment) that was entered when placing    BL20.3  BL21.2
                       the customer's order or invoice.          BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-CIA-AMT-BASE       Signed 18.2                               BL120   BL122
Element: Intl Amt      This is the amount of cash in advance     BL130   BL20.1
                       (down payment) in company base currency   BL20.3  BL21.2
                       that was entered when adding the order    BL21.5  BL29.1
                       or invoice to the customer's account.     BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-COD-PRINT-FL       Alpha 1                                   BL120   BL122
Element: All Flag      A flag to indicate whether cash on        BL130   BL20.1
                       delivery invoice has been printed.        BL20.3  BL21.2
                       Y = Yes                                   BL21.5  BL29.1
                       N = No                                    BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-NET-DUE-CURR       Derived
Element: Net Due Curr  This is the net amount due on the
                       invoice in original billing currency.
                       This amount is calculated by taking the
                       invoice amount - down payment amount.

OEI-NET-DUE-BASE       Derived
Element: Net Due Base  This is the net amount due on the
                       invoice in company base currency. The
                       net due is calculated by taking the
                       invoice amount - down payment amount.

OEI-OPEN-ORD-AMT       Signed 18.2                               BL120   BL122
Element: Intl Amt      This field is used internally by the      BL130   BL20.1
                       system. This takes place when the         BL20.3  BL21.2
                       invoice is interfaced into the Accounts   BL21.5  BL29.1
                       Receivable system, and this is the        BL29.2  BL520
                       amount by which the open order totals in  BL820   BL92.1
                       the Accounts Receivable system will be    OE114   OE129
                       reduced. This will normally be the order  OE30.1  OE30.2
                       net amount except when partial shipments  OE30.3  OE30.4
                       are involved. In the latter case, the     OE30.5  OE30.6
                       open order amount will be reduced as the  OE30.7  OE30.9
                       shipments are made with the last          OE530   OE830
                       invoice's open order amount calculated
                       as open order amount - order amount
                       previously passed to the Accounts
                       Receivable system.

                       For manual invoices entered through
                       BL20, this field represents the total of
                       all line items in transaction currency,
                       and does NOT include Add-On-Costs. When
                       BL123 is run, this field is NOT rolled
                       into the Open Orders field within AR
                       because were dealing with a manual
                       invoice NOT an order.

OEI-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
                       This is required if the company does      BL820   BL92.1
                       not use a third-party taxing system and   OE114   OE129
                       the line is not tax exempt.               OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-TAX-FLAG           Alpha 1                                   TX101
Element: Tax Flag      This is the tax flag which indicates to
                       the system whether this transaction has
                       been interfaced into the Tax Report
                       Files or not.
                       " " = Not interfaced
                       1 = Interfaced

OEI-TERRITORY          Alpha 4                                   BL120   BL122
Element: Sales TerritorThis is the sales territory to which      BL130   BL20.1
                       the customer being invoiced belongs.      BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-SALESMAN           Numeric 4                                 BL120   BL122
Element: Salesman NumbeThe primary sales representative          BL130   BL20.1
                       responsible for this order or invoice.    BL20.3  BL21.2
                       Defaults from the customer ship-to for    BL21.5  BL29.1
                       the order or if the ship-to is not        BL29.2  BL520
                       entered, will default from the customer   BL820   BL92.1
                       master.                                   OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-SALESMAN-2         Numeric 4                                 BL120   BL122
Element: Salesman NumbeThis is the secondary sales               BL130   BL20.1
                       representative responsible for this       BL20.3  BL21.2
                       order or invoice. Defaults from the       BL21.5  BL29.1
                       customer ship-to for the order, or if     BL29.2  BL520
                       the ship-to is not entered, will default  BL820   BL92.1
                       from the customer master.                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-COMM-RATE-1        Percent 7.5  (Percent)                    BL120   BL122
Element: Chrg Rate     The commission rate of the primary        BL130   BL20.1
                       sales representative.                     BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-COMM-RATE-2        Percent 7.5  (Percent)                    BL120   BL122
Element: Chrg Rate     This field contains the commission rate   BL130   BL20.1
                       for the second sales representative.      BL20.3  BL21.2
                       This defaults from the Sales              BL21.5  BL29.1
                       Representative file.                      BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-COMM-SPLIT         Percent 5.3  (Percent)                    BL120   BL122
Commission Split       The portion of the invoice or order       BL130   BL20.1
Percentage             that 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        OE114   OE129
                       Master file.                              OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-LAST-MISC-SEQ      Numeric 3                                 BL120   BL122
Element: Sequence NumbeThis is the number of the last add-on     BL130   BL20.1
                       charge that was added to this order or    BL20.3  BL21.2
                       invoice.                                  BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-LAST-LINE-NBR      Numeric 6                                 BL120   BL122
Element: Line Number   This is the number of the last line       BL130   BL20.1
                       item added. It is used to determine the   BL20.3  BL21.2
                       number when the next line is added.       BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-LAST-TP-SEQ        Numeric 3                                 BL120   BL122
Element: Sequence NumbeThis is the number of the last top        BL130   BL20.1
                       comment line added to the order or        BL20.3  BL21.2
                       invoice.                                  BL21.3  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  BLI2.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-LAST-BM-SEQ        Numeric 3                                 BL120   BL122
Element: Sequence NumbeThis is the number of the last bottom     BL130   BL20.1
                       comment added to the order or invoice.    BL20.3  BL21.2
                                                                 BL21.3  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  BLI2.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-SA-INVOICE-FL      Alpha 1                                   BL120   BL122
Element: All Flag      This is the sales analysis flag which     BL130   BL20.1
                       indicates to the system whether this      BL20.3  BL21.2
                       invoice has been interfaced into the      BL21.5  BL29.1
                       Sales Analysis system or not.             BL29.2  BL520
                       Y = Yes                                   BL820   BL92.1
                       N = No                                    OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830
                                                                 SA100   SA101

OEI-CURRENCY-CODE      Alpha 5                                   BL120   BL122
Element: Currency Code The currency code of the invoice in       BL130   BL20.1
                       this file. In a multicurrency company,    BL20.3  BL21.2
                       this defaults from the customer master    BL21.5  BL29.1
                       and you can override it when entering     BL29.2  BL520
                       the order or invoice. In a                BL820   BL92.1
                       non-multicurrency company, the company    OE114   OE129
                       base currency is assigned.                OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-CURR-MUDV          Alpha 1                                   BL120   BL122
Currency               This is a flag to indicate whether the    BL130   BL20.1
Multiply/Divide        conversion from base to the billing       BL20.3  BL21.2
                       currency is accomplished by               BL21.5  BL29.1
                       multiplication or division.               BL29.2  BL520
                       M = Multiplier                            BL820   BL92.1
                       D = Divider                               OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-CURR-RATE          Signed 14.7                               BL120   BL122
Element: Currency Rate The currency conversion rate used to      BL130   BL20.1
                       convert the billing currency to base      BL20.3  BL21.2
                       currency.                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-CURR-ND            Numeric 1                                 BL120   BL122
Account Currency       This is the number of decimals used by    BL130   BL20.1
Code                   the billing currency.                     BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-REVALUE-FL         Alpha 1                                   BL120   BL122
Element: Revalue       This revalue flag is used by the          BL130   BL20.1
                       Accounts Receivable system if             BL20.3  BL21.2
                       multicurrency processing is used.         BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-INV-GOODS          Signed 18.2                               BL120   BL122
Element: Intl Amt      Total net amount of inventory type        BL130   BL20.1
                       invoice lines.                            BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-INV-GOODS-BSE      Signed 18.2                               BL120   BL122
Element: Intl Amt      Total net amount of inventory type        BL130   BL20.1
                       lines in company base currency.           BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-NON-INV-GOODS      Signed 18.2                               BL120   BL122
Element: Intl Amt      Total net amount of invoice lines that    BL130   BL20.1
                       are nonstock or special items.            BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-NON-INV-GDS-B      Signed 18.2                               BL120   BL122
Element: Intl Amt      Total net amount of invoice lines that    BL130   BL20.1
                       are nonstock or special items in company  BL20.3  BL21.2
                       base currency.                            BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-TOTAL-GOODS        Derived
Element: Total Goods   Total amount of goods on an order or
                       invoice regardless of the item type in
                       billing currency.

OEI-TOTAL-GOODS-B      Derived
Element: Total Goods B Total amount of inventory goods
                       regardless of the item type in company
                       base currency.

OEI-MISC-TOTAL         Signed 18.2                               BL120   BL122
Element: Intl Amt      This is the total net amount of the       BL130   BL20.1
                       add-on charges.                           BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-MISC-TOT-BASE      Signed 18.2                               BL120   BL122
Element: Intl Amt      This is the total net amount of add-on    BL130   BL20.1
                       charges where freight flag = Yes in       BL20.3  BL21.2
                       company base currency.                    BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-FREIGHT-CODE       Alpha 2                                   BL120   BL122
Element: Freight Code  This field contains the freight code.     BL130   BL20.1
                       This is must be valid in the Order Entry  BL20.3  BL21.2
                       Freight Code file. This determines        BL21.5  BL29.1
                       whether carrier and charge are allowed    BL29.2  BL520
                       for the shipment.                         BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-FRT-CHARGE         Signed 18.2                               BL120   BL122
Element: Intl Amt      This is the total amount of freight       BL130   BL20.1
                       being charged on this invoice.            BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-FRT-CHARGE-B       Signed 18.2                               BL120   BL122
Element: Intl Amt      This is the total amount of freight       BL130   BL20.1
                       being charged to this invoice in company  BL20.3  BL21.2
                       base currency.                            BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-FRT-TAXABLE-FL     Alpha 1                                   BL120   BL122
Element: All Flag      This field indicates if the freight is    BL130   BL20.1
                       taxable.                                  BL20.3  BL21.2
                       Y = Yes                                   BL21.5  BL29.1
                       N = No                                    BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-DISCOUNTABLE       Signed 18.2                               BL120   BL122
Element: Intl Amt      This is the total net amount of lines     BL130   BL20.1
                       and add-on charges where the Order        BL20.3  BL21.2
                       Discount Flag = Yes. In invoice           BL21.5  BL29.1
                       currency.                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-ORD-DISCOUNT       Signed 18.2                               BL120   BL122
Element: Intl Amt      This field stores the order discount      BL130   BL20.1
                       amount.                                   BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-ORD-DISC-BSE       Signed 18.2                               BL120   BL122
Element: Intl Amt      This field stores the order discount      BL130   BL20.1
                       amount in company base currency.          BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-RECUR-INVOICE      Alpha 10                                  BL120   BL122
Element: Recur Invoice This is the recurring invoice             BL130   BL20.1
                       identifier.                               BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-BILL-DATE          Numeric 8  (yyyymmdd)                     BL120   BL122
Element: Bill Date     This field contains the last bill date    BL130   BL20.1
                       from the last invoice that was run.       BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-TAXABLE-TOTAL      Signed 18.2                               BL120   BL122
Element: Intl Amt      The total of taxable amounts of the       BL130   BL20.1
                       lines and add-on charges in invoice       BL20.3  BL21.2
                       currency.                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-TAX-TOTAL          Signed 18.2                               BL120   BL122
Element: Intl Amt      This is the total tax as calculated by    BL130   BL20.1
                       the tax logic or a third-party taxing     BL20.3  BL21.2
                       system.                                   BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-TAX-TOTAL-BSE      Signed 18.2                               BL120   BL122
Element: Intl Amt      This is the total tax amount as           BL130   BL20.1
                       calculated by the tax logic or a          BL20.3  BL21.2
                       third-party taxing system in company      BL21.5  BL29.1
                       base currency.                            BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-CUST-PO-NBR        Alpha 22                                  BL120   BL122
Element: Customer P.O. This is the customer purchase order       BL130   BL20.1
                       number associated with this order or      BL20.3  BL21.2
                       invoice.                                  BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-SHIP-DATE          Numeric 8  (yyyymmdd)                     BL120   BL122
Element: Date          This field contains the ship date.  If    BL130   BL20.1
                       left blank, the system date defaults.     BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-AR-CODE            Alpha 4                                   BL120   BL122
Accounts Receivable    This is the Accounts Receivable code      BL130   BL20.1
Code                   (tied to the Accounts Receivable general  BL20.3  BL21.2
                       ledger account) that will be or has been  BL21.5  BL29.1
                       debited for this order or invoice.        BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-AR-LINE-FL         Alpha 1
Element: All Flag      Flag used to indicate whether line
                       level interface records are to be
                       created for Accounts Receivable.
                       Y = Yes
                       N = No

OEI-TRANS-USER1        Alpha 10                                  BL120   BL122
Element: Trans User1   The first user-defined field on the       BL130   BL20.1
                       invoice. This value will be passed with   BL20.3  BL21.2
                       the invoice into the Accounts Receivable  BL21.5  BL29.1
                       system.                                   BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-TRANS-USER2        Alpha 15                                  BL120   BL122
Element: Agent         The second user-defined field on the      BL130   BL20.1
                       invoice. This value will be passed with   BL20.3  BL21.2
                       the invoice into the Accounts Receivable  BL21.5  BL29.1
                       system.                                   BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-TRANS-USER3        Numeric 8  (yyyymmdd)                     BL120   BL122
Element: Trans User3   The third user-defined field on the       BL130   BL20.1
                       invoice. This value will be passed with   BL20.3  BL21.2
                       the invoice into the Accounts Receivable  BL21.5  BL29.1
                       system.                                   BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-TRANS-USER4        Numeric 9                                 BL120   BL122
Element: Trans User4   The fourth user-defined field on the      BL130   BL20.1
                       invoice. This value will be passed with   BL20.3  BL21.2
                       the invoice into the Accounts Receivable  BL21.5  BL29.1
                       system.                                   BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-TRANS-USER5        Signed 18.2                               BL120   BL122
Element: Intl Amt      The fifth user-defined field on the       BL130   BL20.1
                       invoice. This value will be passed with   BL20.3  BL21.2
                       the invoice into the Accounts Receivable  BL21.5  BL29.1
                       system.                                   BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-TAX-EXEMPT-CD      Alpha 1                                   BL120   BL122
Element: Tax Exempt CodIndicates whether the invoice is tax      BL130   BL20.1
                       exempt or not.                            BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                       If taxable, then the corrsponding         BL29.2  BL520
                       invoice lines may be both taxable as      BL820   BL92.1
                       well as exempt.                           OE114   OE129
                                                                 OE30.1  OE30.2
                       If exempt, then all corresponding         OE30.3  OE30.4
                       invoice lines must be exempt.             OE30.5  OE30.6
                       E = Exempt                                OE30.7  OE30.9
                       T = Taxable                               OE530   OE830

OEI-INV-OBJ-ID         Numeric 12
Element: Inv Obj Id

OEI-INVOICE-STR        Derived
Element: Invoice Str   Invoice number consists of a two
                       character invoice prefix and an 8-digit
                       invoice number.

OEI-GROSS-CURR         Derived
Element: Gross Curr    This is the computed gross amount of
                       the invoice in billing currency. This is
                       calculated in the following way:
                       Inventory Goods Amount + Non-Inventory
                       Goods Amount + Add-on Charges Amount +
                       Freight Total + Tax Total = Gross
                       Amount.

OEI-GROSS-BASE         Derived
Element: Gross Base    This is the computed gross amount of
                       the invoice in company base currency.
                       This is calculated in the following way:
                       Inventory Goods Amount + Non-Inventory
                       Goods Amount + Add-on Charges Amount +
                       Freight Total + Tax Total = Gross
                       Amount.

OEI-NET-CURR           Derived
Element: Net Curr      This is the invoice net amount in
                       billing currency. This is calculated in
                       the following way: Gross Currency Amount
                       - Order Discount - Entered Discount
                       Amount = Invoice Net Amount.

OEI-NET-BASE           Derived
Element: Net Base      This is the invoice net amount in
                       company base currency. This is
                       calculated in the following way:  Gross
                       Currency Amount - Order Discount -
                       Entered Discount Amount = Invoice Net
                       Amount.

OEI-INVC-TOT-CURR      Derived
Element: Invc Tot Curr The invoice total in billing currency.

OEI-INVC-TOT-BASE      Derived
Element: Invc Tot Base The invoice total in base currency.

OEI-BT-NAME            Derived
Element: Bt Name       This is the bill-to name.

OEI-BT-ADDR1           Derived
Element: Bt Addr1      This is the first line of the bill-to
                       address.

OEI-BT-ADDR2           Derived
Element: Bt Addr2      This is the second line of the bill-to
                       address.

OEI-BT-ADDR3           Derived
Element: Bt Addr3      This is the third line of the bill-to
                       address.

OEI-BT-ADDR4           Derived
Element: Bt Addr4      This is the fourth line of the bill-to
                       address.

OEI-BT-CITY            Derived
Element: Bt City       This is the city of the bill-to address.

OEI-BT-STATE           Derived
Element: Bt State      This is the state of the bill-to
                       address.

OEI-BT-ZIP             Derived
Element: Bt Zip        This is the postal code on the ship-to
                       address.

OEI-BT-COUNTRY         Derived
Element: Bt Country    This is the country of the bill-to
                       address.

OEI-BT-COUNTY          Derived
Element: Bt County

OEI-ST-NAME            Derived
Element: St Name       This is the customer short name.

OEI-ST-ADDR1           Derived
Element: St Addr1      This is the first line of the
                       customer's address.

OEI-ST-ADDR2           Derived
Element: St Addr2      This is the second line of the
                       customer's address.

OEI-ST-ADDR3           Derived
Element: St Addr3      This is the third line of the
                       customer's address.

OEI-ST-ADDR4           Derived
Element: St Addr4      This is the fourth line of the
                       customer's address.

OEI-ST-CITY            Derived
Element: St City       This is the city of the customer's
                       address.

OEI-ST-STATE           Derived
Element: St State      This is the state of the customer's
                       address.

OEI-ST-ZIP             Derived
Element: St Zip        This is the postal code on the
                       customer's address.

OEI-ST-COUNTRY         Derived
Element: St Country    This is the country on the customer's
                       address.

OEI-ST-COUNTY          Derived
Element: St County

OEI-INVC-NBR           Derived
Element: Invc Nbr      This field combines the invoice prefix
                       and the invoice number. Together they
                       match the Accounts Receivable invoice
                       number.

OEI-TAX-DESC           Derived
Element: Tax Desc      This field contains the description of
                       the tax code.

OEI-REQ-EP-SETTLE      Alpha 1
Element: Req Ep Settle

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

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

OEI-EP-TRANS-ID        Numeric 12                                BL120   BL122
Element: Ep Trans Id                                             BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-EP-TRANS-ID-2      Numeric 12                                BL120   BL122
Element: Ep Trans Id 2                                           BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-EP-STTL-BASE       Signed 18.2
Element: Intl Amt

OEI-EP-STTL-CURR       Signed 18.2
Element: Intl Amt

OEI-EP-TYPE            Alpha 5                                   BL120   BL122
Element: Ep Type                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-EP-ACCOUNT         Alpha 32                                  BL120   BL122
Element: Ep Account                                              BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-EP-EXP-DATE        Numeric 8  (yyyymmdd)                     BL120   BL122
Element: Ep Exp Date                                             BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-EP-MARGIN-MIN      Signed 7.2                                BL120   BL122
Element: Ep Margin Min                                           BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-EP-MARGIN-PCT      Percent 8.5  (Percent)                    BL120   BL122
Element: Ep Margin Pct                                           BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-BT-CTRY-CD         Alpha 2                                   BL120   BL122
Element: Bt Ctry Cd                                              BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-BT-REGION          Alpha 2                                   BL120   BL122
Element: Bt Region                                               BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-BT-EC-CTRY         Numeric 3                                 BL120   BL122
Element: Bt Ec Ctry                                              BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-BT-ISO-CTRY        Numeric 3                                 BL120   BL122
Element: Bt Iso Ctry                                             BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-ST-CTRY-CD         Alpha 2                                   BL120   BL122
Element: St Ctry Cd                                              BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-ST-REGION          Alpha 2                                   BL120   BL122
Element: St Region                                               BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-ST-EC-CTRY         Numeric 3                                 BL120   BL122
Element: St Ec Ctry                                              BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-ST-ISO-CTRY        Numeric 3                                 BL120   BL122
Element: St Iso Ctry                                             BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

OEI-INTRASTAT-NBR      Numeric 12                                BL120   BL122
Element: Intrastat Nbr The number assigned by the Intrastat      BL130   BL20.1
                       system to a transaction that involves     BL20.3  BL21.2
                       Intrastat reporting after it has been     BL21.5  BL29.1
                       added.                                    BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

                         OEINVOICE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OEISET1   COMPANY                                                AR21.6  AR31.5
          INVC-PREFIX                                            AR33.5  AR42.2
          INVC-NUMBER                                            AR42.7  BL00.1
                                                                 BL01.1  BL120
                                                                 BL121   BL122
                                                                 BL123   BL130
                                                                 BL20.1  BL20.3
                                                                 BL20.5  BL20.6
                                                                 BL21.2  BL21.3
                                                                 BL21.4  BL21.5
                                                                 BL21.6  BL217
                                                                 BL220   BL232
                                                                 BL29.1  BL29.2
                                                                 BL290   BL291
                                                                 BL320   BL520
                                                                 ...

OEISET10  COMPANY       Subset                                   SA100
          INVC-PREFIX   Where SA-INVOICE-FL != "Y"
          INVC-NUMBER   And   STATUS        =  9

OEISET2   COMPANY       KeyChange, Subset                        BL121   BL122
          STATUS        Where STATUS < 9                         BL123   BL220
          PROCESS-LEVEL
          INVC-PREFIX
          INVC-NUMBER

OEISET3   COMPANY       KeyChange                                BL120   BL122
          ORDER-NBR                                              BL130   BL20.1
          SHIPMENT-NBR                                           BL20.3  BL21.2
          INVC-PREFIX                                            BL21.5  BL29.1
          INVC-NUMBER                                            BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 OE113   OE114
                                                                 OE129   OE13.2
                                                                 ...

OEISET4   COMPANY                                                AR08.1  AR10.1
          CUSTOMER                                               AR501   AR550
          INVC-PREFIX                                            BL120   BL122
          INVC-NUMBER                                            BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL80.3  BL820
                                                                 BL92.1  OE114
                                                                 OE129   OE30.1
                                                                 OE30.2  OE30.3
                                                                 OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE530
                                                                 OE830

OEISET5   COMPANY       KeyChange, Subset                        BL125   BL220
          HOLD-CODE     Where HOLD-CODE != Spaces                BL91.1
          INVC-PREFIX
          INVC-NUMBER

OEISET6   COMPANY                                                BL80.4
          ORDER-NBR
          INVC-PREFIX
          INVC-NUMBER

OEISET7   COMPANY       KeyChange, Subset                        BL199
          GL-DATE       Where STATUS < 4
          INVC-PREFIX
          INVC-NUMBER

OEISET8   COMPANY       Subset                                   BL120   BL122
          BATCH-NBR     Where STATUS = Zeroes                    BL130   BL20.1
          INVC-PREFIX                                            BL20.3  BL21.2
          INVC-NUMBER                                            BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL80.6  BL820
                                                                 BL92.1  OE114
                                                                 OE129   OE30.1
                                                                 OE30.2  OE30.3
                                                                 OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE530
                                                                 OE830

OEISET9   COMPANY       Subset                                   BL92.1
          INVC-PREFIX   Where STATUS = 1
          INVC-NUMBER   Or    STATUS = 2

                         OEINVOICE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apcompany      APCOMPANY    Required
                            When OEI-INVC-SOURCE =  "S"
                            And  WHS-CARRIER     != Spaces

                            OEI-COMPANY           -> CPY-COMPANY

Apvenmast      APVENMAST    Required
                            When OEI-INVC-SOURCE =  "S"
                            And  WHS-CARRIER     != Spaces

                            CPY-VENDOR-GROUP      -> VEN-VENDOR-GROUP
                            WHS-CARRIER           -> VEN-VENDOR

Arcode         ARCODE       Required

                            OEI-COMPANY           -> RCD-COMPANY
                            OEI-AR-CODE           -> RCD-AR-CODE

Arcomp         ARCOMP       Required

                            OEI-COMPANY           -> ACO-COMPANY

Arcustomer     ARCUSTOMER   Required

                            OEI-COMPANY           -> ACM-COMPANY
                            OEI-CUSTOMER          -> ACM-CUSTOMER

Aroihdr        AROIHDR      Not Required
                            Valid When OEI-STATUS       = 9
                                  And  OIN-INVC-CRED-FL = "N"

                            OEI-COMPANY           -> ARH-COMPANY
                            "I"                   -> ARH-TRANS-TYPE
                            OEI-INVC-NBR          -> ARH-INVOICE

Aroihdr Cm     AROIHDR      Not Required
                            Valid When OEI-STATUS       = 9
                                  And  OIN-INVC-CRED-FL = "Y"

                            OEI-COMPANY           -> ARH-COMPANY
                            "C"                   -> ARH-TRANS-TYPE
                            OEI-INVC-NBR          -> ARH-INVOICE

Arproclevl     ARPROCLEVL   Required

                            OEI-COMPANY           -> APV-COMPANY
                            OEI-PROCESS-LEVEL     -> APV-PROCESS-LEVEL

Batchhdr       OEINVHDR     Not Required

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

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

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

Bloeiuf        BLOEIUF      Not Required

                            OEI-COMPANY           -> BIU-COMPANY
                            OEI-INVC-PREFIX       -> BIU-INVC-PREFIX
                            OEI-INVC-NUMBER       -> BIU-INVC-NUMBER

Blricust       BLRICUST     Not Required
                            Valid When OEI-RECUR-INVOICE != Spaces

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

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

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

Cucodes        CUCODES      Required

                            OEI-CURRENCY-CODE     -> CUC-CURRENCY-CODE

Curelat        CURELAT      Not Required

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

Custdesc       CUSTDESC     Required

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

Custorder      CUSTORDER    Required
                            When OEI-ORDER-NBR != Zeroes

                            OEI-COMPANY           -> COR-COMPANY
                            OEI-ORDER-NBR         -> COR-ORDER-NBR

Glsystem       GLSYSTEM     Required

                            OEI-COMPANY           -> GLS-COMPANY

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

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

Iccompany      ICCOMPANY    Not Required

                            OEI-COMPANY           -> ICC-COMPANY

Iclocation     ICLOCATION   Not Required

                            OEI-COMPANY           -> ICL-COMPANY
                            OEI-LOCATION          -> ICL-LOCATION

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

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

Oecompany      OECOMPANY    Required

                            OEI-COMPANY           -> OEC-COMPANY

Oecust         OECUST       Required

                            OEI-COMPANY           -> OET-COMPANY
                            OEI-CUSTOMER          -> OET-CUSTOMER

Oecustsrvc     BLRICUST     Not Required
                            Valid When OEI-RECUR-INVOICE != Spaces

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

Oefrtcode      OEFRTCODE    Required
                            When OEI-INVC-SOURCE  =  "S"
                            And  OEI-FREIGHT-CODE != Spaces

                            OEI-COMPANY           -> OFR-COMPANY
                            OEI-FREIGHT-CODE      -> OFR-FRT-CODE

Oeinvctype     OEINVCTYPE   Required

                            OEI-COMPANY           -> OIN-COMPANY
                            OEI-INVC-TYPE         -> OIN-INVC-TYPE

Oeinvsgblk     OEINVSGBLK   Not Required

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

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

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

Oemethod       OEMETHOD     Required
                            When OEI-INVC-SOURCE =  "S"
                            And  WHS-METHOD      != Spaces

                            OEI-COMPANY           -> OMT-COMPANY
                            WHS-METHOD            -> OMT-METHOD

Oeprclist      OEPRCLIST    Required

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

Oeproclev      OEPROCLEV    Required

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

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

                            OEI-COMPANY           -> OER-COMPANY
                            OEI-REASON-CODE       -> OER-REASON-CODE

Returnhdr      RETURNHDR    Required
                            When OEI-AUTH-NO != Zeroes

                            OEI-COMPANY           -> RTN-COMPANY
                            OEI-AUTH-NO           -> RTN-AUTH-NO

Salesman       SALESREP     Required

                            OEI-COMPANY           -> SAW-COMPANY
                            OEI-SALESMAN          -> SAW-SALESMAN

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

                            OEI-COMPANY           -> SAW-COMPANY
                            OEI-SALESMAN-2        -> SAW-SALESMAN

Shipto         SHIPTO       Required
                            When OEI-SHIP-TO != Zeroes

                            OEI-COMPANY           -> SHP-COMPANY
                            OEI-CUSTOMER          -> SHP-CUSTOMER
                            OEI-SHIP-TO           -> SHP-SHIP-TO

Teritory       TERITORY     Required

                            OEI-COMPANY           -> TRY-COMPANY
                            OEI-TERRITORY         -> TRY-TERRITORY

Terms          TERMS        Not Required
                            Valid When OEI-TERMS-CD != Spaces

                            OEI-TERMS-CD          -> TMS-TERMS-CD

Txcodemast     TXCODEMAST   Not Required

                            OEI-TAX-CODE          -> TCM-TAX-CODE

Txcompany      TXCOMPANY    Not Required

                            OEI-COMPANY           -> TXC-COMPANY

Txtaxcode      TXTAXCODE    Not Required
                            Valid When OEI-TAX-CODE != Spaces

                            OEI-COMPANY           -> TAC-COMPANY
                            OEI-TAX-CODE          -> TAC-TAX-CODE

Whshipment     WHSHIPMENT   Not Required
                            Valid When OEI-SHIPMENT-NBR != Zeroes

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

                         OEINVOICE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Comisc         COMISC

                            OEI-COMPANY           -> CMC-COMPANY
                            OEI-ORDER-NBR         -> CMC-ORDER-NBR
                            Zeroes                -> CMC-LINE-NBR
                                                     CMC-SEQ

Hdr Comments   OEINVCCOMM   Delete Restricted

                            OEI-COMPANY           -> OIC-COMPANY
                            OEI-INVC-PREFIX       -> OIC-INVC-PREFIX
                            OEI-INVC-NUMBER       -> OIC-INVC-NUMBER
                            Zeroes                -> OIC-LINE-NBR
                                                     OIC-SEQ

Header Misc    OEINVCMISC

                            OEI-COMPANY           -> OIM-COMPANY
                            OEI-INVC-PREFIX       -> OIM-INVC-PREFIX
                            OEI-INVC-NUMBER       -> OIM-INVC-NUMBER
                            Zeroes                -> OIM-LINE-NBR
                                                     OIM-SEQ

Header Tax     OEINVCTAX
                            Valid When OEC-TAX-PRINT-CD = "S"

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

Oedist         OEDIST
                            Valid When OEI-STATUS = 9

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

Oeinvccomm     OEINVCCOMM   Delete Cascades

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

Oeinvcline     OEINVCLINE

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

Oeinvcmisc     OEINVCMISC

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

Oeinvctax      OEINVCTAX

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

Oeordcmnt      OEORDCMNT

                            OEI-COMPANY           -> OOC-COMPANY
                            OEI-CUSTOMER          -> OOC-CUSTOMER
                            Spaces                -> OOC-STD-ORDER-NBR
                            OEI-ORDER-NBR         -> OOC-ORDER-NBR
                            Zeroes                -> OOC-LINE-NBR
                                                     OOC-SEQ

Tlr Comments   OEINVCCOMM   Delete Restricted

                            OEI-COMPANY           -> OIC-COMPANY
                            OEI-INVC-PREFIX       -> OIC-INVC-PREFIX
                            OEI-INVC-NUMBER       -> OIC-INVC-NUMBER
                            999999                -> OIC-LINE-NBR
                                                     OIC-SEQ