OEINVOICE

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
IC216 TX221


UPDATED BY
AR08.1 AR10.1 AR501 AR550 BLI2.1 TX101
WH20.2 WH20.7

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OEI-COMPANY
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
WH20.7
OEI-INVC-PREFIX
Element: Invc Prefix
Alpha 2
This field contains the invoice prefix that is assigned from either the company or process level, depending on the invoice-level option chosen.
WH20.7
OEI-INVC-NUMBER
Element: Invc Number
Numeric 8
The invoice number assigned by the system. Invoice numbers are assigned at the company or process level, depending on the company setting.
WH20.7
OEI-BATCH-NBR
Element: Batch Nbr
Numeric 6
The batch to which the invoices and credit memos belong. The system assigns the batch when the records are added. You can specify a control total on each batch by using Batch Control (BL29.1) after the batch has been added and entering the totals that must equal the detail entered in the batch before releasing the batch.
WH20.7
OEI-PROCESS-LEVEL
Element: Process Level
Alpha 5
This field contains the process level, which is the reporting hierarchy below company.
WH20.7
OEI-LOCATION
Element: Location
Alpha 5
Enter the inventory ship-from location. This location is used for pricing (prices can vary by location) and as a reference when a return to stock situation exists. The location entered here will default to the invoice line level.
WH20.7
OEI-ORIG-INVC-PRE
Element: Invc Prefix
Alpha 2
This field contains the prefix of the original invoice against which the return is being made.
WH20.7
OEI-ORIG-INVC-NBR
Element: Invc Number
Numeric 8
This field contains the number of the original invoice against which the return is being made.
WH20.7
OEI-AUTO-APP-FL
Element: Auto App Fl
Alpha 1
Automatically applies this credit memo to the original invoice.
Y = Yes
N = No
WH20.7
OEI-BILL-TO
Element: Bill To
Numeric 4
This field contains the mailing address for this invoice.
WH20.7
OEI-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
Enter the customer identifier, which represents the customer for which the invoice is being created.
WH20.7
OEI-SHIP-TO
Element: Ship To
Numeric 4
Enter the customer's ship-to location (the mailing address for the goods).
WH20.7
OEI-AR-DETAIL
Element: Ar Detail
Alpha 1
Flag to indicate whether detail postings are to be made to Accounts Receivable.
A = Multiple Activities
M = Mixed sign - Multiple Activity
N = No Detail
S = Mixed Sign
WH20.7
OEI-INVC-TYPE
Element: Invc Type
Alpha 4
The invoice type is updated in this field. This is a required field and can default from the order type (which can then be assigned to the user identifier as a default) when an order is processed through invoicing. If you are entering 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.
WH20.7
OEI-INVC-SOURCE
Element: Invc Source
Alpha 1
This value is updated automatically by the system when an invoice is created. It is designed to identify where the invoice came from, for example, was it interfaced, did it come from processing a shipment, was it manually entered, and so on.
I = Interfaced
M = Manual
S = Shipment
R = Return
C = Recurring Invoice
A = Activity
WH20.7
OEI-INVOICE-DATE
Element: Invoice Date
Numeric 8 (yyyymmdd)
The date the invoice was created. The basis date for the terms discount and due date calculations. For system-generated invoices, the invoice date is the system date assigned when running Daily Shipment Journal (OE129). For manual invoices, this date will default to the system date and you can override it.
WH20.7
OEI-TAX-PNT-DATE
Element: Date
Numeric 8 (yyyymmdd)
The date used to find the effective tax rate.
WH20.7
OEI-PRICE-DATE
Element: Date
Numeric 8 (yyyymmdd)
This is the date with which the price has been determined. This will default to the invoice date but can be overridden when entering an invoice into the system.
WH20.7
OEI-STATUS
Element: Status
Numeric 1
The status of the invoice; for example, released, edited, printed, and so on.
0 = Unreleased
1 = Released
2 = Edited
3 = Printed
9 = AR/GL Updated
WH20.7
OEI-GL-DATE
Element: Gl Date
Numeric 8 (yyyymmdd)
The general ledger posting date. Defaults to the invoice date.
WH20.7
OEI-BOOKED-DATE
Element: Date
Numeric 8 (yyyymmdd)
Date this invoice was booked into Sales Analysis.
WH20.7
OEI-CHECK-NBR
Element: Check Nbr
Numeric 8
This field contains the identifier of the payment that was entered for the order associated with the invoice if the customer is required to send a down payment or cash in advance when placing the order.
WH20.7
OEI-TERMS-CD
Element: Term Code
Alpha 5
The payment terms code that is used to determine the invoice due date and any payment discounts. This will default from the customer master or you can override it when entering the order or invoice.
WH20.7
OEI-BANK-INST-CODE
Element: Bank Inst Code
Alpha 3
A transaction code represents a type of cash payment, bill of exchange payment, or bank service transaction.
WH20.7
OEI-HOLD-CODE
Element: Hold Code
Alpha 4
This is the hold code that determines why an invoice is on hold. If there is a value in this field, the invoice is on hold and will be prevented from being processed through the invoice printing phase.
WH20.7
OEI-REASON-CODE
Element: Reason Code
Alpha 4
Reason code is used to indicate the cause for credit memos. It is allowed on invoices also. If entered, it must be valid in the Reason Code file.
WH20.7
OEI-LIST-NAME
Element: List Name
Alpha 14
This is the name of the price list that is tied to the customer master record.
WH20.7
OEI-AUTH-NO
Element: Auth No
Numeric 10
OEI-CUST-RET-REF
Element: Cust Ret Ref
Alpha 10
OEI-REFERENCE
Element: Reference
Alpha 10 (Lower Case)
An available field to enter any kind of reference information on the order or invoice.
WH20.7
OEI-LETTER-OF-CR
Element: Letter Of Cr
Alpha 20
Optionally enter the letter of credit number for this invoice.
WH20.7
OEI-ORDER-NBR
Element: Order Nbr
Numeric 8
The number of the order associated with this invoice.
WH20.7
OEI-SHIPMENT-NBR
Element: Shipment Nbr
Numeric 10
The number of the shipment of the order to which the invoice belongs.
WH20.7
OEI-ENTERED-DISC
Element: Intl Amt
Signed 18.2
This is the amount of the add-on discount entered in invoice currency. Note: a system invoice can have both an entered discount as well as an order discount.
WH20.7
OEI-ADD-ON-DISC
Element: Intl Amt
Signed 18.2
This is the amount of the add-on discount in company base currency.
WH20.7
OEI-CIA-AMT
Element: Intl Amt
Signed 18.2
The amount of cash in advance (down payment) that was entered when placing the customer's order or invoice.
WH20.7
OEI-CIA-AMT-BASE
Element: Intl Amt
Signed 18.2
This is the amount of cash in advance (down payment) in company base currency that was entered when adding the order or invoice to the customer's account.
WH20.7
OEI-COD-PRINT-FL
Element: All Flag
Alpha 1
A flag to indicate whether cash on delivery invoice has been printed.
Y = Yes
N = No
WH20.7
OEI-NET-DUE-CURR
Element: Net Due Curr
Derived
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
Element: Net Due Base
Derived
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
Element: Intl Amt
Signed 18.2
This field is used internally by the system. This takes place when the invoice is interfaced into the Accounts Receivable system, and this is the amount by which the open order totals in the Accounts Receivable system will be 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.
WH20.7
OEI-TAX-CODE
Element: Tax Code
Alpha 10
A user-defined code representing the tax authorities this ship-to pays sales tax to. Must be a valid tax code record. This is required if the company does not use a third-party taxing system and the line is not tax exempt.
WH20.7
OEI-TAX-FLAG
Element: Tax Flag
Alpha 1
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
TX101
OEI-TERRITORY
Element: Territory
Alpha 4
This is the sales territory to which the customer being invoiced belongs.
WH20.7
OEI-SALESMAN
Element: Salesman
Numeric 4
The primary sales representative responsible for this order or invoice. Defaults from the customer ship-to for the order or if the ship-to is not entered, will default from the customer master.
WH20.7
OEI-SALESMAN-2
Element: Salesman
Numeric 4
This is the secondary sales representative responsible for this order or invoice. Defaults from the customer ship-to for the order, or if the ship-to is not entered, will default from the customer master.
WH20.7
OEI-COMM-RATE-1
Element: Chrg Rate
Percent 7.5 (Percent)
The commission rate of the primary sales representative.
WH20.7
OEI-COMM-RATE-2
Element: Chrg Rate
Percent 7.5 (Percent)
This field contains the commission rate for the second sales representative. This defaults from the Sales Representative file.
WH20.7
OEI-COMM-SPLIT
Element: Comm Split
Percent 5.3 (Percent)
The portion of the invoice or order that the second sales representative's commission percent is applied to. The first sales representative's commission percent is applied to the remaining amount. Defaults from the Customer Master file.
WH20.7
OEI-LAST-MISC-SEQ
Element: Seq
Numeric 3
This is the number of the last add-on charge that was added to this order or invoice.
WH20.7
OEI-LAST-LINE-NBR
Element: Line Nbr
Numeric 6
This is the number of the last line item added. It is used to determine the number when the next line is added.
WH20.7
OEI-LAST-TP-SEQ
Element: Seq
Numeric 3
This is the number of the last top comment line added to the order or invoice.
BLI2.1 WH20.7
OEI-LAST-BM-SEQ
Element: Seq
Numeric 3
This is the number of the last bottom comment added to the order or invoice.
BLI2.1 WH20.7
OEI-SA-INVOICE-FL
Element: All Flag
Alpha 1
This is the sales analysis flag which indicates to the system whether this invoice has been interfaced into Sales Analysis or not.
Y = Yes
N = No
WH20.7
OEI-CURRENCY-CODE
Element: Currency Code
Alpha 5
The currency code of the invoice in this file. In a multicurrency company, this defaults from the customer master and you can override it when entering the order or invoice. In a non-multicurrency company, the company base currency is assigned.
WH20.7
OEI-CURR-MUDV
Element: Curr Mudv
Alpha 1
This is a flag to indicate whether the conversion from base to the billing currency is accomplished by multiplication or division.
M = Multiplier
D = Divider
WH20.7
OEI-CURR-RATE
Element: Curr Rate
Signed 14.7
The currency conversion rate used to convert the billing currency to base currency.
WH20.7
OEI-CURR-ND
Element: Acct Nd
Numeric 1
This is the number of decimals used by the billing currency.
WH20.7
OEI-REVALUE-FL
Element: Revalue Fl
Alpha 1
This revalue flag is used by the Accounts Receivable system if multicurrency processing is used.
WH20.7
OEI-INV-GOODS
Element: Intl Amt
Signed 18.2
Total net amount of inventory type invoice lines.
WH20.7
OEI-INV-GOODS-BSE
Element: Intl Amt
Signed 18.2
Total net amount of inventory type lines in company base currency.
WH20.7
OEI-NON-INV-GOODS
Element: Intl Amt
Signed 18.2
Total net amount of invoice lines that are nonstock or special items.
WH20.7
OEI-NON-INV-GDS-B
Element: Intl Amt
Signed 18.2
Total net amount of invoice lines that are nonstock or special items in company base currency.
WH20.7
OEI-TOTAL-GOODS
Element: Total Goods
Derived
Total amount of goods on an order or invoice regardless of the item type in billing currency.
OEI-TOTAL-GOODS-B
Element: Total Goods B
Derived
Total amount of inventory goods regardless of the item type in company base currency.
OEI-MISC-TOTAL
Element: Intl Amt
Signed 18.2
This is the total net amount of the add-on charges.
WH20.7
OEI-MISC-TOT-BASE
Element: Intl Amt
Signed 18.2
This is the total net amount of add-on charges where freight flag = Yes in company base currency.
WH20.7
OEI-FREIGHT-CODE
Element: Freight Code
Alpha 2
This field contains the freight code. This is must be valid in the Order Entry Freight Code file. This determines whether carrier and charge are allowed for the shipment.
WH20.7
OEI-FRT-CHARGE
Element: Intl Amt
Signed 18.2
This is the total amount of freight being charged on this invoice.
WH20.7
OEI-FRT-CHARGE-B
Element: Intl Amt
Signed 18.2
This is the total amount of freight being charged to this invoice in company base currency.
WH20.7
OEI-FRT-TAXABLE-FL
Element: All Flag
Alpha 1
This field indicates if the freight is taxable.
Y = Yes
N = No
WH20.7
OEI-DISCOUNTABLE
Element: Intl Amt
Signed 18.2
This is the total net amount of lines and add-on charges where the Order Discount Flag = Yes. In invoice currency.
WH20.7
OEI-ORD-DISCOUNT
Element: Intl Amt
Signed 18.2
This field stores the order discount amount.
WH20.7
OEI-ORD-DISC-BSE
Element: Intl Amt
Signed 18.2
This field stores the order discount amount in company base currency.
WH20.7
OEI-RECUR-INVOICE
Element: Recur Invoice
Alpha 10
This is the recurring invoice identifier.
WH20.7
OEI-BILL-DATE
Element: Bill Date
Numeric 8 (yyyymmdd)
This field contains the last bill date from the last invoice that was run.
WH20.7
OEI-TAXABLE-TOTAL
Element: Intl Amt
Signed 18.2
The total of taxable amounts of the lines and add-on charges in invoice currency.
WH20.7
OEI-TAX-TOTAL
Element: Intl Amt
Signed 18.2
This is the total tax as calculated by the tax logic or a third-party taxing system.
WH20.7
OEI-TAX-TOTAL-BSE
Element: Intl Amt
Signed 18.2
This is the total tax amount as calculated by the tax logic or a third-party taxing system in company base currency.
WH20.7
OEI-CUST-PO-NBR
Element: Cust Po Nbr
Alpha 22
This is the customer purchase order number associated with this order or invoice.
WH20.7
OEI-SHIP-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
WH20.7
OEI-AR-CODE
Element: Ar Code
Alpha 4
This is the Accounts Receivable code (tied to the Accounts Receivable general ledger account) that will be or has been debited for this order or invoice.
WH20.7
OEI-AR-LINE-FL
Element: All Flag
Alpha 1
Flag used to indicate whether line level interface records are to be created for Accounts Receivable.
Y = Yes
N = No
OEI-TRANS-USER1
Element: Trans User1
Alpha 10
The first user-defined field on the invoice. This value will be passed with the invoice into Accounts Receivable.
WH20.7
OEI-TRANS-USER2
Element: Agent
Alpha 15
The second user-defined field on the invoice. This value will be passed with the invoice into Accounts Receivable.
WH20.7
OEI-TRANS-USER3
Element: Trans User3
Numeric 8 (yyyymmdd)
The third user-defined field on the invoice. This value will be passed with the invoice into Accounts Receivable.
WH20.7
OEI-TRANS-USER4
Element: Trans User4
Numeric 9
The fourth user-defined field on the invoice. This value will be passed with the invoice into Accounts Receivable.
WH20.7
OEI-TRANS-USER5
Element: Intl Amt
Signed 18.2
The fifth user-defined field on the invoice. This value will be passed with the invoice into Accounts Receivable.
WH20.7
OEI-TAX-EXEMPT-CD
Element: Tax Exempt Cd
Alpha 1
Indicates whether the invoice is tax exempt or not. If taxable, then the corrsponding invoice lines may be both taxable as well as exempt. If exempt, then all corresponding invoice lines must be exempt.
E = Exempt
T = Taxable
WH20.7
OEI-INV-OBJ-ID
Element: Inv Obj Id
Numeric 12
OEI-INVOICE-STR
Element: Invoice Str
Derived
Invoice number consists of a two character invoice prefix and an 8-digit invoice number.
OEI-GROSS-CURR
Element: Gross Curr
Derived
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
Element: Gross Base
Derived
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
Element: Net Curr
Derived
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
Element: Net Base
Derived
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
Element: Invc Tot Curr
Derived
The invoice total in billing currency.
OEI-INVC-TOT-BASE
Element: Invc Tot Base
Derived
The invoice total in base currency.
OEI-BT-NAME
Element: Bt Name
Derived
This is the bill-to name.
OEI-BT-ADDR1
Element: Bt Addr1
Derived
This is the first line of the bill-to address.
OEI-BT-ADDR2
Element: Bt Addr2
Derived
This is the second line of the bill-to address.
OEI-BT-ADDR3
Element: Bt Addr3
Derived
This is the third line of the bill-to address.
OEI-BT-ADDR4
Element: Bt Addr4
Derived
This is the fourth line of the bill-to address.
OEI-BT-CITY
Element: Bt City
Derived
This is the city of the bill-to address.
OEI-BT-STATE
Element: Bt State
Derived
This is the state of the bill-to address.
OEI-BT-ZIP
Element: Bt Zip
Derived
This is the postal code on the ship-to address.
OEI-BT-COUNTRY
Element: Bt Country
Derived
This is the country of the bill-to address.
OEI-BT-COUNTY
Element: Bt County
Derived
OEI-ST-NAME
Element: St Name
Derived
This is the customer short name.
OEI-ST-ADDR1
Element: St Addr1
Derived
This is the first line of the customer's address.
OEI-ST-ADDR2
Element: St Addr2
Derived
This is the second line of the customer's address.
OEI-ST-ADDR3
Element: St Addr3
Derived
This is the third line of the customer's address.
OEI-ST-ADDR4
Element: St Addr4
Derived
This is the fourth line of the customer's address.
OEI-ST-CITY
Element: St City
Derived
This is the city of the customer's address.
OEI-ST-STATE
Element: St State
Derived
This is the state of the customer's address.
OEI-ST-ZIP
Element: St Zip
Derived
This is the postal code on the customer's address.
OEI-ST-COUNTRY
Element: St Country
Derived
This is the country on the customer's address.
OEI-ST-COUNTY
Element: St County
Derived
OEI-INVC-NBR
Element: Invc Nbr
Derived
This field combines the invoice prefix and the invoice number. Together they match the Accounts Receivable invoice number.
OEI-TAX-DESC
Element: Tax Desc
Derived
This field contains the description of the tax code.
OEI-REQ-EP-SETTLE
Element: Req Ep Settle
Alpha 1
OEI-ORDER-REF-NBR
Element: Order Ref Nbr
Numeric 8
This field contains the order reference number. This number can be filled with extra order number information.
OEI-REF-NBR-FLAG
Element: Ref Nbr Flag
Alpha 1
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
Element: Ep Trans Id
Numeric 12
WH20.7
OEI-EP-TRANS-ID-2
Element: Ep Trans Id 2
Numeric 12
WH20.7
OEI-EP-STTL-BASE
Element: Intl Amt
Signed 18.2
OEI-EP-STTL-CURR
Element: Intl Amt
Signed 18.2
OEI-EP-TYPE
Element: Ep Type
Alpha 5
WH20.7
OEI-EP-ACCOUNT
Element: Ep Account
Alpha 32
WH20.7
OEI-EP-EXP-DATE
Element: Ep Exp Date
Numeric 8 (yyyymmdd)
WH20.7
OEI-EP-MARGIN-MIN
Element: Ep Margin Min
Signed 7.2
WH20.7
OEI-EP-MARGIN-PCT
Element: Ep Margin Pct
Percent 8.5 (Percent)
WH20.7
OEI-BT-CTRY-CD
Element: Bt Ctry Cd
Alpha 2
WH20.7
OEI-BT-REGION
Element: Bt Region
Alpha 2
WH20.7
OEI-BT-EC-CTRY
Element: Bt Ec Ctry
Numeric 3
WH20.7
OEI-BT-ISO-CTRY
Element: Bt Iso Ctry
Numeric 3
WH20.7
OEI-ST-CTRY-CD
Element: St Ctry Cd
Alpha 2
WH20.7
OEI-ST-REGION
Element: St Region
Alpha 2
WH20.7
OEI-ST-EC-CTRY
Element: St Ec Ctry
Numeric 3
WH20.7
OEI-ST-ISO-CTRY
Element: St Iso Ctry
Numeric 3
WH20.7
OEI-INTRASTAT-NBR
Element: Intrastat Nbr
Numeric 12
The number assigned by the Intrastat system to a transaction that involves Intrastat reporting after it has been added.
WH20.7
OEI-ACTIVITY
Element: Activity
Alpha 15
Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.
WH20.7
OEI-ACCT-CATEGORY
Element: Acct Category
Alpha 5
Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using 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
WH20.7
OEI-ACTIVITY-C
Element: Activity
Alpha 15
Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.
WH20.7
OEI-ACCT-CATEG-C
Element: Acct Category
Alpha 5
Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using 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
WH20.7
OEI-OPR-CODE
Element: Opr Code
Alpha 10 (Lower Case)
This field contains the operator code. This is the user ID of the person who last maintained this record.
WH20.7


OEINVOICE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OEISET1 COMPANY
INVC-PREFIX
INVC-NUMBER
BLI2.1 IC216
TX101 TX221
WH20.7
OEISET10 COMPANY
INVC-PREFIX
INVC-NUMBER
Subset
WhereSA-INVOICE-FL !="Y"
AndSTATUS =9
OEISET2 COMPANY
STATUS
PROCESS-LEVEL
INVC-PREFIX
INVC-NUMBER
KeyChange, Subset
WhereSTATUS <9
OEISET3 COMPANY
ORDER-NBR
SHIPMENT-NBR
INVC-PREFIX
INVC-NUMBER
KeyChange
WH20.2 WH20.7
OEISET4 COMPANY
CUSTOMER
INVC-PREFIX
INVC-NUMBER
AR08.1 AR10.1
AR501 AR550
OEISET5 COMPANY
HOLD-CODE
INVC-PREFIX
INVC-NUMBER
KeyChange, Subset
WhereHOLD-CODE !=Spaces
OEISET6 COMPANY
ORDER-NBR
INVC-PREFIX
INVC-NUMBER
KeyChange
OEISET7 COMPANY
GL-DATE
INVC-PREFIX
INVC-NUMBER
KeyChange, Subset
WhereSTATUS <4
OEISET8 COMPANY
BATCH-NBR
INVC-PREFIX
INVC-NUMBER
Subset
WhereSTATUS =Zeroes
WH20.7
OEISET9 COMPANY
INVC-PREFIX
INVC-NUMBER
Subset
WhereSTATUS =1
OrSTATUS =2


OEINVOICE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
When OEI-INVC-SOURCE ="S"
AndWHS-CARRIER !=Spaces
OEI-COMPANY->CPY-COMPANY
Apvenmast APVENMAST Required
When OEI-INVC-SOURCE ="S"
AndWHS-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
AndOIN-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
AndOIN-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
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"
AndOEI-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
Oemethod OEMETHOD Required
When OEI-INVC-SOURCE ="S"
AndWHS-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
NAME
RELATED 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


File created: Thu Jun 09 11:09:39 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.