Lawson Insight Technical Documentation |
|
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
|