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

AR08.1

AR10.1

AR501

AR550

UPDATED BY

BLI2.1

TX101

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
OEI-GLBL-DOC-TYPE Element: Glbl Doc Type	Alpha 10	WH20.7
OEI-FREIGHT-TOT Element: Freight Total	Signed 18.2	WH20.7
OEI-INSURANCE-TOT Element: Insurance Tot	Signed 18.2	WH20.7
OEI-CSTMS-TOT Element: Cstms Total	Signed 18.2	WH20.7
OEI-OTHER-AOC-TOT Element: Other Aoc Tot	Signed 18.2	WH20.7

OEINVOICE FILE INDEX

OEINVOICE FILE RELATIONS

ONE TO ONE RELATIONS

OEINVOICE FILE RELATIONS

ONE TO MANY RELATIONS

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