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 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 AR08.1
AR10.1 AR120 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 TX101 WH20.7
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
WH20.7
OEI-INVC-PREFIX Alpha 2 BL120 BL122
Element: Invc Prefix This field contains the invoice prefix BL130 BL20.1
that is assigned from either the company BL20.3 BL21.2
or process level, depending on the BL21.5 BL29.1
invoice-level option chosen. BL29.2 BL520
BL820 BL92.1
WH20.7
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
WH20.7
OEI-BATCH-NBR Numeric 6 BL120 BL122
Element: Batch Nbr 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 Batch Control (BL29.1) BL820 BL92.1
after the batch has been added and WH20.7
entering the totals that must equal the
detail entered in the batch before
releasing the batch.
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
WH20.7
OEI-LOCATION Alpha 5 BL120 BL122
Element: Location 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 WH20.7
level.
OEI-ORIG-INVC-PRE Alpha 2 BL120 BL122
Element: Invc Prefix This 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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
OEI-CUSTOMER Alpha 9 (Right Justified) BL120 BL122
Element: Customer Enter 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
WH20.7
OEI-SHIP-TO Numeric 4 BL120 BL122
Element: Ship To 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
WH20.7
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 WH20.7
S = Mixed Sign
OEI-INVC-TYPE Alpha 4 BL120 BL122
Element: Invc 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 WH20.7
an invoice unrelated to an order, you
must enter this invoice type. Define
invoice types using Invoice Types
(BL06.1). The invoice type identifies
the record being entered as either an
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 WH20.7
so on.
I = Interfaced
M = Manual
S = Shipment
R = Return
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 Daily Shipment Journal (OE129). WH20.7
For manual invoices, this date will
default to the system date and you can
override it.
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
WH20.7
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
WH20.7
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 WH20.7
OEI-GL-DATE Numeric 8 (yyyymmdd) BL120 BL122
Element: Gl Date The 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
WH20.7
OEI-BOOKED-DATE Numeric 8 (yyyymmdd) BL120 BL122
Element: Date Date this invoice was booked into Sales BL130 BL20.1
Analysis. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OEI-CHECK-NBR Numeric 8 BL120 BL122
Element: Check Nbr This 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. WH20.7
OEI-TERMS-CD Alpha 5 BL120 BL122
Element: Term 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. WH20.7
OEI-BANK-INST-CODE Alpha 3 BL120 BL122
Element: Bank Inst CodeA 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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
OEI-LETTER-OF-CR Alpha 20 BL120 BL122
Element: Letter Of Cr Optionally 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
WH20.7
OEI-ORDER-NBR Numeric 8 BL120 BL122
Element: Order Nbr 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
WH20.7
OEI-SHIPMENT-NBR Numeric 10 BL120 BL122
Element: Shipment Nbr The 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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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 WH20.7
reduced. This will normally be the order
net amount except when partial shipments
are involved. In the latter case, the
open order amount will be reduced as the
shipments are made with the last
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 WH20.7
the line is not tax exempt.
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: Territory This 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
WH20.7
OEI-SALESMAN Numeric 4 BL120 BL122
Element: Salesman The 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. WH20.7
OEI-SALESMAN-2 Numeric 4 BL120 BL122
Element: Salesman This 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. WH20.7
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
WH20.7
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
WH20.7
OEI-COMM-SPLIT Percent 5.3 (Percent) BL120 BL122
Element: Comm Split The portion of the invoice or order BL130 BL20.1
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 WH20.7
Master file.
OEI-LAST-MISC-SEQ Numeric 3 BL120 BL122
Element: Seq This 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
WH20.7
OEI-LAST-LINE-NBR Numeric 6 BL120 BL122
Element: Line Nbr 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
WH20.7
OEI-LAST-TP-SEQ Numeric 3 BL120 BL122
Element: Seq This 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
WH20.7
OEI-LAST-BM-SEQ Numeric 3 BL120 BL122
Element: Seq This 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
WH20.7
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 Sales BL21.5 BL29.1
Analysis or not. BL29.2 BL520
Y = Yes BL820 BL92.1
N = No WH20.7
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 WH20.7
base currency is assigned.
OEI-CURR-MUDV Alpha 1 BL120 BL122
Element: Curr Mudv This is a flag to indicate whether the BL130 BL20.1
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 WH20.7
OEI-CURR-RATE Signed 14.7 BL120 BL122
Element: Curr 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
WH20.7
OEI-CURR-ND Numeric 1 BL120 BL122
Element: Acct Nd This is the number of decimals used by BL130 BL20.1
the billing currency. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OEI-REVALUE-FL Alpha 1 BL120 BL122
Element: Revalue Fl 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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
BL80.1 BL820
BL92.1 WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
OEI-CUST-PO-NBR Alpha 22 BL120 BL122
Element: Cust Po Nbr 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
WH20.7
OEI-SHIP-DATE Numeric 8 (yyyymmdd) BL120 BL122
Element: Date This field displays the system date BL130 BL20.1
when this was created. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OEI-AR-CODE Alpha 4 BL120 BL122
Element: Ar Code This is the Accounts Receivable code BL130 BL20.1
(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
WH20.7
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 Accounts Receivable. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
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 Accounts Receivable. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
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 Accounts Receivable. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
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 Accounts Receivable. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
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 Accounts Receivable. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OEI-TAX-EXEMPT-CD Alpha 1 BL120 BL122
Element: Tax Exempt Cd Indicates 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. WH20.7
If exempt, then all corresponding
invoice lines must be exempt.
E = Exempt
T = Taxable
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
OEI-ACTIVITY Alpha 15 BL120 BL122
Element: Activity Activities are the processes or BL130 BL20.1
procedures that produce work. Cost BL20.3 BL21.2
objects (products, services, customers, BL21.5 BL29.1
and so on) are the reasons for BL29.2 BL520
performing the activity. BL820 BL92.1
WH20.7
OEI-ACCT-CATEGORY Alpha 5 BL120 BL122
Element: Acct Category Account categories are groupings of BL130 BL20.1
costs, revenues, or a combination of BL20.3 BL21.2
both used for reporting and inquiries BL21.5 BL29.1
for activities in the Activity BL29.2 BL520
Management system. All transactions are BL820 BL92.1
posted to an account category within an WH20.7
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
Valid account category types are:
cost
revenue
accrual
pass thru
OEI-ACTIVITY-C Alpha 15 BL120 BL122
Element: Activity Activities are the processes or BL130 BL20.1
procedures that produce work. Cost BL20.3 BL21.2
objects (products, services, customers, BL21.5 BL29.1
and so on) are the reasons for BL29.2 BL520
performing the activity. BL820 BL92.1
WH20.7
OEI-ACCT-CATEG-C Alpha 5 BL120 BL122
Element: Acct Category Account categories are groupings of BL130 BL20.1
costs, revenues, or a combination of BL20.3 BL21.2
both used for reporting and inquiries BL21.5 BL29.1
for activities in the Activity BL29.2 BL520
Management system. All transactions are BL820 BL92.1
posted to an account category within an WH20.7
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
Valid account category types are:
cost
revenue
accrual
pass thru
OEI-OPR-CODE Alpha 10 (Lower Case) BL120 BL122
Element: Opr Code This field contains the operator code. BL130 BL20.1
This is the user ID of the person who BL20.3 BL21.2
last maintained this record. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OEINVOICE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OEISET1 COMPANY AR21.6 AR33.5
INVC-PREFIX AR42.2 AR42.7
INVC-NUMBER 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 BL80.1
...
OEISET10 COMPANY Subset
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
WH20.2 WH20.7
OEISET4 COMPANY AR08.1 AR10.1
CUSTOMER AR120 AR501
INVC-PREFIX AR550 BL80.3
INVC-NUMBER
OEISET5 COMPANY KeyChange, Subset BL125 BL220
HOLD-CODE Where HOLD-CODE != Spaces BL91.1
INVC-PREFIX
INVC-NUMBER
OEISET6 COMPANY KeyChange 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 WH20.7
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
|