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
AR31.5 AR42.2 AR42.7 BL00.1 BL01.1 BL220
BL232 BL290 BL291 BL80.1 BL80.2 BL80.3
BL80.5 BL81.1 BL96D OE130 OE272 SA991
WH991 BL720 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 OE113 OE14.4 OE15.1
OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510
OE810 OE920 WH20.2 WH20.7 AR08.1 AR10.1
AR501 AR550 OE294 BL199
UPDATED BY
BL120 BL121 BL122 BL123 BL130 BL20.1
BL20.3 BL21.2 BL21.3 BL21.5 BL21.6 BL22.1
BL29.1 BL29.2 BL320 BL520 BL820 BL91.1
BL92.1 BL940 BL968 OE114 OE129 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE310 OE330 OE830 OE950 SA100
SA101 WH966
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OEI-COMPANY Numeric 4 BL120 BL130
Company The company number represents an BL20.1 BL20.3
established company and is entered on BL21.2 BL21.5
all function codes. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-INVC-PREFIX Alpha 2 BL120 BL130
Invoice Prefix This field contains the invoice prefix BL20.1 BL20.3
that is assigned from either the company BL21.2 BL21.5
or process level, depending on the BL29.1 BL29.2
invoice-level option chosen. BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-INVC-NUMBER Numeric 8 BL120 BL130
Invc Number The invoice number assigned by the BL20.1 BL20.3
system. Invoice numbers are assigned at BL21.2 BL21.5
the company or process level, depending BL29.1 BL29.2
on the company setting. BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-BATCH-NBR Numeric 6 BL120 BL130
Batch Number The batch to which the invoices and BL20.1 BL20.3
credit memos belong. The system assigns BL21.2 BL21.5
the batch when the records are added. BL29.1 BL29.2
You can specify a control total on each BL520 BL820
batch by using BL29.1 (Batch Control) BL92.1 BL940
after the batch has been added and BL968 OE114
entering the totals that must equal the OE129 OE30.1
detail entered in the batch before OE30.2 OE30.3
releasing the batch. OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-PROCESS-LEVEL Alpha 5 BL120 BL130
Process Level This field contains the process level, BL20.1 BL20.3
which is the reporting hierarchy below BL21.2 BL21.5
company. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-LOCATION Alpha 5 BL120 BL130
Location Code Enter the inventory ship-from location. BL20.1 BL20.3
This location is used for pricing BL21.2 BL21.5
(prices can vary by location) and as a BL29.1 BL29.2
reference when a return to stock BL520 BL820
situation exists. The location entered BL92.1 BL940
here will default to the invoice line BL968 OE114
level. OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-ORIG-INVC-PRE Alpha 2 BL120 BL130
Orig Invc Pre This field contains the prefix of the BL20.1 BL20.3
original invoice against which the BL21.2 BL21.5
return is being made. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-ORIG-INVC-NBR Numeric 8 BL120 BL130
Orig Invc Nbr This field contains the number of the BL20.1 BL20.3
original invoice against which the BL21.2 BL21.5
return is being made. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-AUTO-APP-FL Alpha 1 BL120 BL130
Auto App Fl Automatically applies this credit memo BL20.1 BL20.3
to the original invoice. BL21.2 BL21.5
Y = Yes BL29.1 BL29.2
N = No BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-BILL-TO Numeric 4 BL120 BL130
Bill-To Customer This field contains the mailing address BL20.1 BL20.3
Number for this invoice. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-CUSTOMER Alpha 9 (Right Justified) BL120 BL130
Customer Number Enter the customer identifier, which BL20.1 BL20.3
represents the customer for which the BL21.2 BL21.5
invoice is being created. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-SHIP-TO Numeric 4 BL120 BL130
Ship-to Code Enter the customer's ship-to location BL20.1 BL20.3
(the mailing address for the goods). BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-AR-DETAIL Alpha 1 BL120 BL130
Ar Detail Flag to indicate whether detail BL20.1 BL20.3
postings are to be made to Accounts BL21.2 BL21.5
Receivable. BL29.1 BL29.2
Y = Yes BL520 BL820
N = No BL92.1 BL940
M = Multiple BL968 OE114
S = Single OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-INVC-TYPE Alpha 4 BL120 BL130
Invoice Type The invoice type is updated in this BL20.1 BL20.3
field. This is a required field and can BL21.2 BL21.5
default from the order type (which can BL29.1 BL29.2
then be assigned to the user identifier BL520 BL820
as a default) when an order is processed BL92.1 BL940
through invoicing. If you are entering BL968 OE114
an invoice unrelated to an order, you OE129 OE30.1
must enter this invoice type. Define OE30.2 OE30.3
invoice types using BL06.1 (Invoice OE30.4 OE30.5
Types). The invoice type identifies the OE30.6 OE30.7
record being entered as either an OE30.9 OE830
invoice or credit memo. OE950
OEI-INVC-SOURCE Alpha 1 BL120 BL130
Invc Source This value is updated automatically by BL20.1 BL20.3
the system when an invoice is created. BL21.2 BL21.5
It is designed to identify where the BL29.1 BL29.2
invoice came from, for example, was it BL520 BL820
interfaced, did it come from processing BL92.1 BL940
a shipment, was it manually entered, and BL968 OE114
so on. OE129 OE30.1
I = Interfaced OE30.2 OE30.3
M = Manual OE30.4 OE30.5
S = Shipment OE30.6 OE30.7
R = Return OE30.9 OE830
C = Recurring Invoice OE950
A = Activity
OEI-INVOICE-DATE Numeric 8 (yyyymmdd) BL120 BL130
Invoice Date The date the invoice was created. The BL20.1 BL20.3
basis date for the terms discount and BL21.2 BL21.5
due date calculations. For BL29.1 BL29.2
system-generated invoices, the invoice BL520 BL820
date is the system date assigned when BL92.1 BL940
running OE129 (Daily Shipment Journal). BL968 OE114
For manual invoices, this date will OE129 OE30.1
default to the system date and you can OE30.2 OE30.3
override it. OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-TAX-PNT-DATE Numeric 8 (yyyymmdd) BL120 BL130
Tax Point Date The date used to find the effective tax BL20.1 BL20.3
rate. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-PRICE-DATE Numeric 8 (yyyymmdd) BL120 BL130
Price Date This is the date with which the price BL20.1 BL20.3
has been determined. This will default BL21.2 BL21.5
to the invoice date but can be BL29.1 BL29.2
overridden when entering an invoice into BL520 BL820
the system. BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-STATUS Numeric 1 BL120 BL121
Status The status of the invoice; for example, BL122 BL123
released, edited, printed, and so on. BL130 BL20.1
1 = Released BL20.3 BL21.2
2 = Edited BL21.5 BL29.1
3 = Printed BL29.2 BL520
9 = Ar/gl Updated BL820 BL92.1
BL940 BL968
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OEI-GL-DATE Numeric 8 (yyyymmdd) BL120 BL130
General Ledger Date The general ledger posting date. BL20.1 BL20.3
Defaults to the invoice date. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-BOOKED-DATE Numeric 8 (yyyymmdd) BL120 BL130
Booked Date Date this invoice was booked into the BL20.1 BL20.3
Sales Analysis system. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 SA100
SA101
OEI-CHECK-NBR Numeric 8 BL120 BL130
Payment Number This field contains the identifier of BL20.1 BL20.3
the payment that was entered for the BL21.2 BL21.5
order associated with the invoice if the BL29.1 BL29.2
customer is required to send a down BL520 BL820
payment or cash in advance when placing BL92.1 BL940
the order. BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-TERMS-CD Alpha 5 BL120 BL130
Terms Code The payment terms code that is used to BL20.1 BL20.3
determine the invoice due date and any BL21.2 BL21.5
payment discounts. This will default BL29.1 BL29.2
from the customer master or you can BL520 BL820
override it when entering the order or BL92.1 BL940
invoice. BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-BANK-INST-CODE Alpha 3 BL120 BL130
Transaction Code A transaction code represents a type of BL20.1 BL20.3
cash payment, bill of exchange payment, BL21.2 BL21.5
or bank service transaction. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-HOLD-CODE Alpha 4 BL120 BL130
Hold Code This is the hold code that determines BL20.1 BL20.3
why an invoice is on hold. If there is a BL21.2 BL21.5
value in this field, the invoice is on BL29.1 BL29.2
hold and will be prevented from being BL520 BL820
processed through the invoice printing BL91.1 BL92.1
phase. BL940 BL968
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OEI-REASON-CODE Alpha 4 BL120 BL130
Reason Code Reason code is used to indicate the BL20.1 BL20.3
cause for credit memos. It is allowed on BL21.2 BL21.5
invoices also. If entered, it must be BL29.1 BL29.2
valid in the Reason Code file. BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-LIST-NAME Alpha 14 BL120 BL130
List Name This is the name of the price list that BL20.1 BL20.3
is tied to the customer master record. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-REFERENCE Alpha 10 (Lower Case) BL120 BL130
Reference An available field to enter any kind of BL20.1 BL20.3
reference information on the order or BL21.2 BL21.5
invoice. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-LETTER-OF-CR Alpha 20 BL120 BL130
Letter of Credit Optionally enter the letter of credit BL20.1 BL20.3
number for this invoice. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-ORDER-NBR Numeric 8 BL120 BL130
Order Number The number of the order associated with BL20.1 BL20.3
this invoice. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-SHIPMENT-NBR Numeric 10 BL120 BL130
Shipment Number The number of the shipment of the order BL20.1 BL20.3
to which the invoice belongs. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 WH966
OEI-ENTERED-DISC Signed 15.2 BL120 BL130
Entered Disc This is the amount of the add-on BL20.1 BL20.3
discount entered in invoice currency. BL21.2 BL21.5
Note: a system invoice can have both an BL29.1 BL29.2
entered discount as well as an order BL520 BL820
discount. BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-ADD-ON-DISC Signed 15.2 BL120 BL130
Add On Discount This is the amount of the add-on BL20.1 BL20.3
discount in company base currency. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-CIA-AMT Signed 15.2 BL120 BL130
Cash In Advance The amount of cash in advance (down BL20.1 BL20.3
Amount payment) that was entered when placing BL21.2 BL21.5
the customer's order or invoice. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-CIA-AMT-BASE Signed 15.2 BL120 BL130
Cia Amt Base This is the amount of cash in advance BL20.1 BL20.3
(down payment) in company base currency BL21.2 BL21.5
that was entered when adding the order BL29.1 BL29.2
or invoice to the customer's account. BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-COD-PRINT-FL Alpha 1 BL120 BL122
Cod Print Fl 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
BL940 BL968
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OEI-NET-DUE-CURR Derived
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
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 15.2 BL120 BL130
Open Ord Amt This field is used internally by the BL20.1 BL20.3
system. This takes place when the BL21.2 BL21.5
invoice is interfaced into the Accounts BL29.1 BL29.2
Receivable system, and this is the BL520 BL820
amount by which the open order totals in BL92.1 BL940
the Accounts Receivable system will be BL968 OE114
reduced. This will normally be the order OE129 OE30.1
net amount except when partial shipments OE30.2 OE30.3
are involved. In the latter case, the OE30.4 OE30.5
open order amount will be reduced as the OE30.6 OE30.7
shipments are made with the last OE30.9 OE830
invoice's open order amount calculated OE950
as open order amount - order amount
previously passed to the Accounts
Receivable system.
OEI-CC-TYPE Alpha 2 BL120 BL130
Credit Card Type This is the credit card type that was BL20.1 BL20.3
used by the customer to pay for the BL21.2 BL21.5
order or invoice. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-CC-NUMBER Alpha 17 BL120 BL130
Credit Card Number The credit card number that was used by BL20.1 BL20.3
the customer to pay for the order or BL21.2 BL21.5
invoice. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-CC-EXP-DATE Numeric 6 BL120 BL130
Credit Card The credit card expiration date. BL20.1 BL20.3
Expiration Date BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-TAX-CODE Alpha 10 BL120 BL130
Tax Code A user-defined code representing the BL20.1 BL20.3
tax authorities this ship-to pays sales BL21.2 BL21.5
tax to. Must be a valid tax code record. BL29.1 BL29.2
BL520 BL820
This is required if the company does BL92.1 BL940
not use a third-party taxing system and BL968 OE114
the line is not tax exempt. OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-TERRITORY Alpha 4 BL120 BL130
Sales Territory This is the sales territory to which BL20.1 BL20.3
the customer being invoiced belongs. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-SALESMAN Numeric 4 BL120 BL130
Salesman Number The primary sales representative BL20.1 BL20.3
responsible for this order or invoice. BL21.2 BL21.5
Defaults from the customer ship-to for BL29.1 BL29.2
the order or if the ship-to is not BL520 BL820
entered, will default from the customer BL92.1 BL940
master. BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-SALESMAN-2 Numeric 4 BL120 BL130
Salesman Number 2 This is the secondary sales BL20.1 BL20.3
representative responsible for this BL21.2 BL21.5
order or invoice. Defaults from the BL29.1 BL29.2
customer ship-to for the order, or if BL520 BL820
the ship-to is not entered, will default BL92.1 BL940
from the customer master. BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-COMM-RATE-1 Percent 7.5 (Percent) BL120 BL130
Commission Rate for The commission rate of the primary BL20.1 BL20.3
Slsmn 1 sales representative. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-COMM-RATE-2 Percent 7.5 (Percent) BL120 BL130
Commission Rate for This field contains the commission rate BL20.1 BL20.3
Slsmn 2 for the second sales representative. BL21.2 BL21.5
This defaults from the Sales BL29.1 BL29.2
Representative file. BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-COMM-SPLIT Percent 5.3 (Percent) BL120 BL130
Commission Split The portion of the invoice or order BL20.1 BL20.3
Percentage that the second sales representative's BL21.2 BL21.5
commission percent is applied to. The BL29.1 BL29.2
first sales representative's commission BL520 BL820
percent is applied to the remaining BL92.1 BL940
amount. Defaults from the Customer BL968 OE114
Master file. OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-LAST-MISC-SEQ Numeric 3 BL120 BL130
Last Misc Code This is the number of the last add-on BL20.1 BL20.3
Sequence charge that was added to this order or BL21.2 BL21.5
invoice. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-LAST-LINE-NBR Numeric 6 BL120 BL130
Last Line Number This is the number of the last line BL20.1 BL20.3
item added. It is used to determine the BL21.2 BL21.5
number when the next line is added. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-LAST-TP-SEQ Numeric 3 BL120 BL130
Last Top Comment This is the number of the last top BL20.1 BL20.3
Sequence comment line added to the order or BL21.2 BL21.3
invoice. BL21.5 BL21.6
BL22.1 BL29.1
BL29.2 BL520
BL820 BL92.1
BL940 BL968
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OEI-LAST-BM-SEQ Numeric 3 BL120 BL130
Last Bottom Comment This is the number of the last bottom BL20.1 BL20.3
Sequence comment added to the order or invoice. BL21.2 BL21.3
BL21.5 BL21.6
BL22.1 BL29.1
BL29.2 BL520
BL820 BL92.1
BL940 BL968
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OEI-SA-INVOICE-FL Alpha 1 BL120 BL130
Sa-Invoice Fl This is the sales analysis flag which BL20.1 BL20.3
indicates to the system whether this BL21.2 BL21.5
invoice has been interfaced into the BL29.1 BL29.2
Sales Analysis system or not. BL520 BL820
Y = Yes BL92.1 BL940
N = No BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 SA100
SA101
OEI-CURRENCY-CODE Alpha 5 BL120 BL130
Currency Code The currency code of the invoice in BL20.1 BL20.3
this file. In a multicurrency company, BL21.2 BL21.5
this defaults from the customer master BL29.1 BL29.2
and you can override it when entering BL520 BL820
the order or invoice. In a BL92.1 BL940
non-multicurrency company, the company BL968 OE114
base currency is assigned. OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-CURR-MUDV Alpha 1 BL120 BL130
Currency This is a flag to indicate whether the BL20.1 BL20.3
Multiply/Divide conversion from base to the billing BL21.2 BL21.5
currency is accomplished by BL29.1 BL29.2
multiplication or division. BL520 BL820
M = Multiplier BL92.1 BL940
D = Divider BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-CURR-RATE Signed 13.6 BL120 BL130
Currency Rate The currency conversion rate used to BL20.1 BL20.3
convert the billing currency to base BL21.2 BL21.5
currency. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-CURR-ND Numeric 1 BL120 BL130
Currency Number of This is the number of decimals used by BL20.1 BL20.3
Decimals the billing currency. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-REVALUE-FL Alpha 1 BL120 BL130
Revalue This revalue flag is used by the BL20.1 BL20.3
Accounts Receivable system if BL21.2 BL21.5
multicurrency processing is used. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-INV-GOODS Signed 15.2 BL120 BL130
Inv Goods Total net amount of inventory type BL20.1 BL20.3
invoice lines. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-INV-GOODS-BSE Signed 15.2 BL120 BL130
Inv Goods Bse Total net amount of inventory type BL20.1 BL20.3
lines in company base currency. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-NON-INV-GOODS Signed 15.2 BL120 BL130
Non Inv Goods Total net amount of invoice lines that BL20.1 BL20.3
are nonstock or special items. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-NON-INV-GDS-B Signed 15.2 BL120 BL130
Non Inv Gds B Total net amount of invoice lines that BL20.1 BL20.3
are nonstock or special items in company BL21.2 BL21.5
base currency. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-TOTAL-GOODS Derived
Total Goods Total amount of goods on an order or
invoice regardless of the item type in
billing currency.
OEI-TOTAL-GOODS-B Derived
Total Goods B Total amount of inventory goods
regardless of the item type in company
base currency.
OEI-MISC-TOTAL Signed 15.2 BL120 BL130
Misc Total This is the total net amount of the BL20.1 BL20.3
add-on charges. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-MISC-TOT-BASE Signed 15.2 BL120 BL130
Misc Tot Base This is the total net amount of add-on BL20.1 BL20.3
charges where freight flag = Yes in BL21.2 BL21.5
company base currency. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-FREIGHT-CODE Alpha 2 BL120 BL130
Freight Code This field contains the freight code. BL20.1 BL20.3
This is must be valid in the Order Entry BL21.2 BL21.5
Freight Code file. This determines BL29.1 BL29.2
whether carrier and charge are allowed BL520 BL820
for the shipment. BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-FRT-CHARGE Signed 15.2 BL120 BL130
Frt Charge This is the total amount of freight BL20.1 BL20.3
being charged on this invoice. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-FRT-CHARGE-B Signed 15.2 BL120 BL130
Frt Charge B This is the total amount of freight BL20.1 BL20.3
being charged to this invoice in company BL21.2 BL21.5
base currency. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-FRT-TAXABLE-FL Alpha 1 BL120 BL130
Frt Taxable Fl This field indicates if the freight is BL20.1 BL20.3
taxable. BL21.2 BL21.5
Y = Yes BL29.1 BL29.2
N = No BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-DISCOUNTABLE Signed 15.2 BL120 BL130
Order Discountable This is the total net amount of lines BL20.1 BL20.3
Amount and add-on charges where the Order BL21.2 BL21.5
Discount Flag = Yes. In invoice BL29.1 BL29.2
currency. BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-ORD-DISCOUNT Signed 15.2 BL120 BL130
Order Discount This field stores the order discount BL20.1 BL20.3
Amount amount. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-ORD-DISC-BSE Signed 15.2 BL120 BL130
Ord Disc Bse This field stores the order discount BL20.1 BL20.3
amount in company base currency. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-RECUR-INVOICE Alpha 10 BL120 BL130
Recurring Invoice This is the recurring invoice BL20.1 BL20.3
identifier. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-BILL-DATE Numeric 8 (yyyymmdd) BL120 BL130
Bill Date This field contains the last bill date BL20.1 BL20.3
from the last invoice that was run. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-TAXABLE-TOTAL Signed 15.2 BL120 BL130
Taxable Total The total of taxable amounts of the BL20.1 BL20.3
lines and add-on charges in invoice BL21.2 BL21.5
currency. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-TAX-TOTAL Signed 15.2 BL120 BL130
Tax Total This is the total tax as calculated by BL20.1 BL20.3
the tax logic or a third-party taxing BL21.2 BL21.5
system. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-TAX-TOTAL-BSE Signed 15.2 BL120 BL130
Tax Total Bse This is the total tax amount as BL20.1 BL20.3
calculated by the tax logic or a BL21.2 BL21.5
third-party taxing system in company BL29.1 BL29.2
base currency. BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-CUST-PO-NBR Alpha 20 BL120 BL130
Customer P.O. Number This is the customer purchase order BL20.1 BL20.3
number associated with this order or BL21.2 BL21.5
invoice. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-SHIP-DATE Numeric 8 (yyyymmdd) BL120 BL130
Ship Date This field contains the ship date. If BL20.1 BL20.3
left blank, the system date defaults. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-AR-CODE Alpha 4 BL120 BL130
Accounts Receivable This is the Accounts Receivable code BL20.1 BL20.3
Code (tied to the Accounts Receivable general BL21.2 BL21.5
ledger account) that will be or has been BL29.1 BL29.2
debited for this order or invoice. BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-AR-LINE-FL Alpha 1 BL968
Ar Line Fl 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 BL130
Trans User 1 The first user-defined field on the BL20.1 BL20.3
invoice. This value will be passed with BL21.2 BL21.5
the invoice into the Accounts Receivable BL29.1 BL29.2
system. BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-TRANS-USER2 Alpha 15 BL120 BL130
Trans User 2 The second user-defined field on the BL20.1 BL20.3
invoice. This value will be passed with BL21.2 BL21.5
the invoice into the Accounts Receivable BL29.1 BL29.2
system. BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-TRANS-USER3 Numeric 8 (yyyymmdd) BL120 BL130
Trans User 3 The third user-defined field on the BL20.1 BL20.3
invoice. This value will be passed with BL21.2 BL21.5
the invoice into the Accounts Receivable BL29.1 BL29.2
system. BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-TRANS-USER4 Numeric 9 BL120 BL130
Trans User 4 The fourth user-defined field on the BL20.1 BL20.3
invoice. This value will be passed with BL21.2 BL21.5
the invoice into the Accounts Receivable BL29.1 BL29.2
system. BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-TRANS-USER5 Signed 13.2 BL120 BL130
Trans User 5 The fifth user-defined field on the BL20.1 BL20.3
invoice. This value will be passed with BL21.2 BL21.5
the invoice into the Accounts Receivable BL29.1 BL29.2
system. BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-TAX-EXEMPT-CD Alpha 1 BL120 BL130
Tax Exempt Code Indicates whether the invoice is tax BL20.1 BL20.3
exempt or not. BL21.2 BL21.5
E = Exempt BL29.1 BL29.2
T = Taxable BL520 BL820
BL92.1 BL940
BL968 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEI-INVOICE-STR Derived
Invoice Str Invoice number consists of a two
character invoice prefix and an 8-digit
invoice number.
OEI-GROSS-CURR Derived
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
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
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
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
Invc Tot Curr The invoice total in billing currency.
OEI-INVC-TOT-BASE Derived
Invc Tot Base The invoice total in base currency.
OEI-BT-NAME Derived
Bt Name This is the bill-to name.
OEI-BT-ADDR1 Derived
Bt Addr1 This is the first line of the bill-to
address.
OEI-BT-ADDR2 Derived
Bt Addr2 This is the second line of the bill-to
address.
OEI-BT-ADDR3 Derived
Bt Addr3 This is the third line of the bill-to
address.
OEI-BT-ADDR4 Derived
Bt Addr4 This is the fourth line of the bill-to
address.
OEI-BT-CITY Derived
Bt City This is the city of the bill-to address.
OEI-BT-STATE Derived
Bt State This is the state of the bill-to
address.
OEI-BT-ZIP Derived
Bt Zip This is the postal code on the bill-to
address.
OEI-BT-COUNTRY Derived
Bt Country This is the country of the bill-to
address.
OEI-ST-NAME Derived
St Name This is the customer short name.
OEI-ST-ADDR1 Derived
St Addr1 This is the first line of the
customer's address.
OEI-ST-ADDR2 Derived
St Addr2 This is the second line of the
customer's address.
OEI-ST-ADDR3 Derived
St Addr3 This is the third line of the
customer's address.
OEI-ST-ADDR4 Derived
St Addr4 This is the fourth line of the
customer's address.
OEI-ST-CITY Derived
St City This is the city of the customer's
address.
OEI-ST-STATE Derived
St State This is the state of the customer's
address.
OEI-ST-ZIP Derived
St Zip This is the postal code on the
customer's address.
OEI-ST-COUNTRY Derived
St Country This is the country on the customer's
address.
OEI-INVC-NBR Derived
Invc Nbr This field combines the invoice prefix
and the invoice number. Together they
match the Accounts Receivable invoice
number.
OEI-TAX-DESC Derived
Tax Desc This field contains the description of
the tax code.
OEINVOICE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OEISET1 COMPANY AR31.5 AR42.2
INVC-PREFIX AR42.7 BL00.1
INVC-NUMBER BL01.1 BL120
BL121 BL122
BL123 BL130
BL20.1 BL20.3
BL21.2 BL21.3
BL21.4 BL21.5
BL21.6 BL22.1
BL220 BL232
BL29.1 BL29.2
BL290 BL291
BL320 BL520
BL80.1 BL80.2
BL81.1 BL820
...
OEISET10 COMPANY Subset SA100
INVC-PREFIX Where SA-INVOICE-FL != "Y"
INVC-NUMBER And STATUS = 9
OEISET2 COMPANY KeyChange, Subset BL122 BL123
STATUS Where STATUS < 9 BL220 BL720
PROCESS-LEVEL
INVC-PREFIX
INVC-NUMBER
OEISET3 COMPANY KeyChange OE10.1 OE10.2
ORDER-NBR OE10.3 OE10.4
SHIPMENT-NBR OE10.5 OE10.6
INVC-PREFIX OE10.7 OE10.8
INVC-NUMBER OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE310 OE510
OE810 OE920
WH20.2 WH20.7
OEISET4 COMPANY AR08.1 AR10.1
CUSTOMER AR501 AR550
INVC-PREFIX BL120 BL130
INVC-NUMBER BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL80.3
BL820 BL92.1
BL940 OE114
OE129 OE294
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OEISET5 COMPANY KeyChange, Subset BL220 BL91.1
HOLD-CODE Where HOLD-CODE != Spaces
INVC-PREFIX
INVC-NUMBER
OEISET7 COMPANY KeyChange, Subset BL199
GL-DATE Where STATUS < 4
INVC-PREFIX
INVC-NUMBER
OEISET8 COMPANY Subset BL120 BL130
BATCH-NBR Where STATUS = Zeroes BL20.1 BL20.3
INVC-PREFIX BL21.2 BL21.5
INVC-NUMBER BL29.1 BL29.2
BL520 BL80.5
BL820 BL92.1
BL940 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEISET9 COMPANY Subset BL121 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 OEI-CARRIER != Spaces
OEI-COMPANY -> CPY-COMPANY
Apvenmast APVENMAST Required
When OEI-INVC-SOURCE = "S"
And OEI-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 OEI-INVC-CRED-FL = "N"
OEI-COMPANY -> ARH-COMPANY
"I" -> ARH-TRANS-TYPE
OEI-INVC-NBR -> ARH-TRANS-NBR
Aroihdr Cm AROIHDR Not Required
Valid When OEI-STATUS = 9
And OEI-INVC-CRED-FL = "Y"
OEI-COMPANY -> ARH-COMPANY
"C" -> ARH-TRANS-TYPE
OEI-INVC-NBR -> ARH-TRANS-NBR
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
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
Oecredcard OECREDCARD Required
When OEI-CC-TYPE != Spaces
Or OEI-CC-NUMBER != Spaces
OEI-COMPANY -> OCR-COMPANY
OEI-CC-TYPE -> OCR-CC-TYPE
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 OEI-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
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 OEI-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
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
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
|