OEINVOICE – Invoice

System: Billing (BL)
Prefix: OEI
Primary key: COMPANY, INVC-PREFIX, INVC-NUMBER
Fields: 150
Updated by: 3 programs
Referenced by: 6 programs

OEINVOICE is the Invoice table in Lawson Billing (prefix OEI). It is indexed by COMPANY, INVC-PREFIX, INVC-NUMBER (OEISET1); alternate indexes: OEISET10, OEISET2, OEISET3, OEISET4, OEISET5, OEISET6, OEISET7, OEISET8 and 1 more. It is related 1:1 to APCOMPANY, APVENMAST, ARCODE, ARCOMP, ARCUSTOMER, AROIHDR, ARPROCLEVL, OEINVHDR and 29 more and 1:M to COMISC, OEINVCCOMM, OEINVCMISC, OEINVCTAX, OEDIST, OEINVCLINE and OEORDCMNT. It is updated by BLI2.1, TX101 and WH20.7 and referenced by AR08.1, AR10.1, AR501, AR550, IC216 and TX221. The table has 150 fields, 10 indexes and 52 documented relations.

About OEINVOICE

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).

Fields (150)

Column = COBOL field name without the OEI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`OEI-COMPANY` PK 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` PK 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` PK 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` 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` PROCESS_LEVEL	Alpha 5	This field contains the process level, which is the reporting hierarchy below company.	WH20.7
`OEI-LOCATION` 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` ORIG_INVC_PRE	Alpha 2	This field contains the prefix of the original invoice against which the return is being made.	WH20.7
`OEI-ORIG-INVC-NBR` ORIG_INVC_NBR	Numeric 8	This field contains the number of the original invoice against which the return is being made.	WH20.7
`OEI-AUTO-APP-FL` AUTO_APP_FL	Alpha 1	Automatically applies this credit memo to the original invoice. `Y` Yes `N` No	WH20.7
`OEI-BILL-TO` BILL_TO	Numeric 4	This field contains the mailing address for this invoice.	WH20.7
`OEI-CUSTOMER` 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` SHIP_TO	Numeric 4	Enter the customer's ship-to location (the mailing address for the goods).	WH20.7
`OEI-AR-DETAIL` 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` 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` 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` 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` TAX_PNT_DATE	Numeric 8 (yyyymmdd)	The date used to find the effective tax rate.	WH20.7
`OEI-PRICE-DATE` PRICE_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` 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` GL_DATE	Numeric 8 (yyyymmdd)	The general ledger posting date. Defaults to the invoice date.	WH20.7
`OEI-BOOKED-DATE` BOOKED_DATE	Numeric 8 (yyyymmdd)	Date this invoice was booked into Sales Analysis.	WH20.7
`OEI-CHECK-NBR` 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` TERMS_CD	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` 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` 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` 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` 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` AUTH_NO	Numeric 10	—	—
`OEI-CUST-RET-REF` CUST_RET_REF	Alpha 10	—	—
`OEI-REFERENCE` 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` LETTER_OF_CR	Alpha 20	Optionally enter the letter of credit number for this invoice.	WH20.7
`OEI-ORDER-NBR` ORDER_NBR	Numeric 8	The number of the order associated with this invoice.	WH20.7
`OEI-SHIPMENT-NBR` SHIPMENT_NBR	Numeric 10	The number of the shipment of the order to which the invoice belongs.	WH20.7
`OEI-ENTERED-DISC` ENTERED_DISC	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` ADD_ON_DISC	Signed 18.2	This is the amount of the add-on discount in company base currency.	WH20.7
`OEI-CIA-AMT` CIA_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` CIA_AMT_BASE	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` COD_PRINT_FL	Alpha 1	A flag to indicate whether cash on delivery invoice has been printed. `Y` Yes `N` No	WH20.7
`OEI-NET-DUE-CURR` 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` 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` OPEN_ORD_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` 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` 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` TERRITORY	Alpha 4	This is the sales territory to which the customer being invoiced belongs.	WH20.7
`OEI-SALESMAN` 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` SALESMAN_2	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` COMM_RATE_1	Percent 7.5 (Percent)	The commission rate of the primary sales representative.	WH20.7
`OEI-COMM-RATE-2` COMM_RATE_2	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` 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` LAST_MISC_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` LAST_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` LAST_TP_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` LAST_BM_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` SA_INVOICE_FL	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` 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` 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` CURR_RATE	Signed 14.7	The currency conversion rate used to convert the billing currency to base currency.	WH20.7
`OEI-CURR-ND` CURR_ND	Numeric 1	This is the number of decimals used by the billing currency.	WH20.7
`OEI-REVALUE-FL` REVALUE_FL	Alpha 1	This revalue flag is used by the Accounts Receivable system if multicurrency processing is used.	WH20.7
`OEI-INV-GOODS` INV_GOODS	Signed 18.2	Total net amount of inventory type invoice lines.	WH20.7
`OEI-INV-GOODS-BSE` INV_GOODS_BSE	Signed 18.2	Total net amount of inventory type lines in company base currency.	WH20.7
`OEI-NON-INV-GOODS` NON_INV_GOODS	Signed 18.2	Total net amount of invoice lines that are nonstock or special items.	WH20.7
`OEI-NON-INV-GDS-B` NON_INV_GDS_B	Signed 18.2	Total net amount of invoice lines that are nonstock or special items in company base currency.	WH20.7
`OEI-TOTAL-GOODS` TOTAL_GOODS	Derived	Total amount of goods on an order or invoice regardless of the item type in billing currency.	—
`OEI-TOTAL-GOODS-B` TOTAL_GOODS_B	Derived	Total amount of inventory goods regardless of the item type in company base currency.	—
`OEI-MISC-TOTAL` MISC_TOTAL	Signed 18.2	This is the total net amount of the add-on charges.	WH20.7
`OEI-MISC-TOT-BASE` MISC_TOT_BASE	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` 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` FRT_CHARGE	Signed 18.2	This is the total amount of freight being charged on this invoice.	WH20.7
`OEI-FRT-CHARGE-B` FRT_CHARGE_B	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` FRT_TAXABLE_FL	Alpha 1	This field indicates if the freight is taxable. `Y` Yes `N` No	WH20.7
`OEI-DISCOUNTABLE` DISCOUNTABLE	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` ORD_DISCOUNT	Signed 18.2	This field stores the order discount amount.	WH20.7
`OEI-ORD-DISC-BSE` ORD_DISC_BSE	Signed 18.2	This field stores the order discount amount in company base currency.	WH20.7
`OEI-RECUR-INVOICE` RECUR_INVOICE	Alpha 10	This is the recurring invoice identifier.	WH20.7
`OEI-BILL-DATE` BILL_DATE	Numeric 8 (yyyymmdd)	This field contains the last bill date from the last invoice that was run.	WH20.7
`OEI-TAXABLE-TOTAL` TAXABLE_TOTAL	Signed 18.2	The total of taxable amounts of the lines and add-on charges in invoice currency.	WH20.7
`OEI-TAX-TOTAL` TAX_TOTAL	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` TAX_TOTAL_BSE	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` CUST_PO_NBR	Alpha 22	This is the customer purchase order number associated with this order or invoice.	WH20.7
`OEI-SHIP-DATE` SHIP_DATE	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	WH20.7
`OEI-AR-CODE` 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` AR_LINE_FL	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` 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` TRANS_USER2	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` 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` 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` TRANS_USER5	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` 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` INV_OBJ_ID	Numeric 12	—	—
`OEI-INVOICE-STR` INVOICE_STR	Derived	Invoice number consists of a two character invoice prefix and an 8-digit invoice number.	—
`OEI-GROSS-CURR` 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` 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` 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` 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` INVC_TOT_CURR	Derived	The invoice total in billing currency.	—
`OEI-INVC-TOT-BASE` INVC_TOT_BASE	Derived	The invoice total in base currency.	—
`OEI-BT-NAME` BT_NAME	Derived	This is the bill-to name.	—
`OEI-BT-ADDR1` BT_ADDR1	Derived	This is the first line of the bill-to address.	—
`OEI-BT-ADDR2` BT_ADDR2	Derived	This is the second line of the bill-to address.	—
`OEI-BT-ADDR3` BT_ADDR3	Derived	This is the third line of the bill-to address.	—
`OEI-BT-ADDR4` BT_ADDR4	Derived	This is the fourth line of the bill-to address.	—
`OEI-BT-CITY` BT_CITY	Derived	This is the city of the bill-to address.	—
`OEI-BT-STATE` BT_STATE	Derived	This is the state of the bill-to address.	—
`OEI-BT-ZIP` BT_ZIP	Derived	This is the postal code on the ship-to address.	—
`OEI-BT-COUNTRY` BT_COUNTRY	Derived	This is the country of the bill-to address.	—
`OEI-BT-COUNTY` BT_COUNTY	Derived	—	—
`OEI-ST-NAME` ST_NAME	Derived	This is the customer short name.	—
`OEI-ST-ADDR1` ST_ADDR1	Derived	This is the first line of the customer's address.	—
`OEI-ST-ADDR2` ST_ADDR2	Derived	This is the second line of the customer's address.	—
`OEI-ST-ADDR3` ST_ADDR3	Derived	This is the third line of the customer's address.	—
`OEI-ST-ADDR4` ST_ADDR4	Derived	This is the fourth line of the customer's address.	—
`OEI-ST-CITY` ST_CITY	Derived	This is the city of the customer's address.	—
`OEI-ST-STATE` ST_STATE	Derived	This is the state of the customer's address.	—
`OEI-ST-ZIP` ST_ZIP	Derived	This is the postal code on the customer's address.	—
`OEI-ST-COUNTRY` ST_COUNTRY	Derived	This is the country on the customer's address.	—
`OEI-ST-COUNTY` ST_COUNTY	Derived	—	—
`OEI-INVC-NBR` INVC_NBR	Derived	This field combines the invoice prefix and the invoice number. Together they match the Accounts Receivable invoice number.	—
`OEI-TAX-DESC` TAX_DESC	Derived	This field contains the description of the tax code.	—
`OEI-REQ-EP-SETTLE` REQ_EP_SETTLE	Alpha 1	—	—
`OEI-ORDER-REF-NBR` 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` 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` EP_TRANS_ID	Numeric 12	—	WH20.7
`OEI-EP-TRANS-ID-2` EP_TRANS_ID_2	Numeric 12	—	WH20.7
`OEI-EP-STTL-BASE` EP_STTL_BASE	Signed 18.2	—	—
`OEI-EP-STTL-CURR` EP_STTL_CURR	Signed 18.2	—	—
`OEI-EP-TYPE` EP_TYPE	Alpha 5	—	WH20.7
`OEI-EP-ACCOUNT` EP_ACCOUNT	Alpha 32	—	WH20.7
`OEI-EP-EXP-DATE` EP_EXP_DATE	Numeric 8 (yyyymmdd)	—	WH20.7
`OEI-EP-MARGIN-MIN` EP_MARGIN_MIN	Signed 7.2	—	WH20.7
`OEI-EP-MARGIN-PCT` EP_MARGIN_PCT	Percent 8.5 (Percent)	—	WH20.7
`OEI-BT-CTRY-CD` BT_CTRY_CD	Alpha 2	—	WH20.7
`OEI-BT-REGION` BT_REGION	Alpha 2	—	WH20.7
`OEI-BT-EC-CTRY` BT_EC_CTRY	Numeric 3	—	WH20.7
`OEI-BT-ISO-CTRY` BT_ISO_CTRY	Numeric 3	—	WH20.7
`OEI-ST-CTRY-CD` ST_CTRY_CD	Alpha 2	—	WH20.7
`OEI-ST-REGION` ST_REGION	Alpha 2	—	WH20.7
`OEI-ST-EC-CTRY` ST_EC_CTRY	Numeric 3	—	WH20.7
`OEI-ST-ISO-CTRY` ST_ISO_CTRY	Numeric 3	—	WH20.7
`OEI-INTRASTAT-NBR` 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` 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` 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` ACTIVITY_C	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` ACCT_CATEG_C	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` 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` GLBL_DOC_TYPE	Alpha 10	—	WH20.7
`OEI-FREIGHT-TOT` FREIGHT_TOT	Signed 18.2	—	WH20.7
`OEI-INSURANCE-TOT` INSURANCE_TOT	Signed 18.2	—	WH20.7
`OEI-CSTMS-TOT` CSTMS_TOT	Signed 18.2	—	WH20.7
`OEI-OTHER-AOC-TOT` OTHER_AOC_TOT	Signed 18.2	—	WH20.7

Indexes (10)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`OEISET1`	`COMPANY`, `INVC-PREFIX`, `INVC-NUMBER`	Primary		BLI2.1, IC216, TX101, TX221, WH20.7
`OEISET10`	`COMPANY`, `INVC-PREFIX`, `INVC-NUMBER`	Subset	Where SA-INVOICE-FL != "Y" And STATUS = 9	—
`OEISET2`	`COMPANY`, `STATUS`, `PROCESS-LEVEL`, `INVC-PREFIX`, `INVC-NUMBER`	KeyChange, Subset	Where STATUS < 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	Where HOLD-CODE != Spaces	—
`OEISET6`	`COMPANY`, `ORDER-NBR`, `INVC-PREFIX`, `INVC-NUMBER`	KeyChange		—
`OEISET7`	`COMPANY`, `GL-DATE`, `INVC-PREFIX`, `INVC-NUMBER`	KeyChange, Subset	Where STATUS < 4	—
`OEISET8`	`COMPANY`, `BATCH-NBR`, `INVC-PREFIX`, `INVC-NUMBER`	Subset	Where STATUS = Zeroes	WH20.7
`OEISET9`	`COMPANY`, `INVC-PREFIX`, `INVC-NUMBER`	Subset	Where STATUS = 1 Or STATUS = 2	—

Relations

One to one (41) — lookups and parents

Relation	Table	Rules	Condition	Field map
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`
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`
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`

One to many (11) — child tables

Relation	Table	Rules	Condition	Field map
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`

Programs

Updated by (3)

BLI2.1 BL and OE Attachment Copy
TX101 Journal File Create
WH20.7 Substitute Location

Referenced by (6)

AR08.1 Customer Defaults
AR10.1 Customer
AR501 Customer Conversion
AR550 Customer Interface
IC216 Open Transaction Report
TX221 Tax Transaction Audit