OEINVCLINE – Invoice Line

System: Billing (BL)
Prefix: OIL
Primary key: COMPANY, INVC-PREFIX, INVC-NUMBER, LINE-NBR
Fields: 109
Updated by: 3 programs
Referenced by: 1 program

OEINVCLINE is the Invoice Line table in Lawson Billing (prefix OIL). It is indexed by COMPANY, INVC-PREFIX, INVC-NUMBER, LINE-NBR (OILSET1); alternate indexes: OILSET2, OILSET3, OILSET4, OILSET5 and OILSET6. It is related 1:1 to GLMASTER, ARCOMP, BLOILUF, BLRICLINE, COLINE, CUSTDESC, ICCATEGORY, ICCOMPANY and 19 more and 1:M to COCOMP, COMISC, OEINVCCOMM, OEINVCMISC, OEINVCTAX, OEDIST, OEINVCDTL, OEINVSGBLK and 2 more. It is updated by BLI2.1, IC216 and WH20.7 and referenced by TX101. The table has 109 fields, 6 indexes and 47 documented relations.

About OEINVCLINE

This file stores invoice line information. Each line on an invoice will have a record in this file. Inventory, nonstock, and special order lines are stored here. Add-on charges are stored in their own specific file.

Fields (109)

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

Field / column	Type	Description & values	Updated by
`OIL-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
`OIL-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
`OIL-INVC-NUMBER` PK INVC_NUMBER	Numeric 8	This field contains the invoice number assigned by the system. Invoice numbers are assigned at the company or process level, depending on an invoice-level option on the company file.	WH20.7
`OIL-LINE-NBR` PK LINE_NBR	Numeric 6	The system number of the line on the invoice.	WH20.7
`OIL-LINE-TYPE` LINE_TYPE	Alpha 1	The line type indicates whether the item on the line is an inventoried item, non-stock, or special item. `I` Inventoried item `N` Non-stock `X` Special order	WH20.7
`OIL-ITEM` ITEM	Alpha 32	This field contains the item identifier.	WH20.7
`OIL-ITEM-16` ITEM_16	Derived	This field contains the 16-character item description. Derived by the system.	—
`OIL-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	The description of the item.	WH20.7
`OIL-ORDER-NBR` ORDER_NBR	Numeric 8	If the invoice this invoice line was created on is based on an order shipment, this field will store the order number related to the line.	WH20.7
`OIL-SHIPMENT-NBR` SHIPMENT_NBR	Numeric 10	This field contains the shipment number. One order can have several shipment numbers if the items of the order were not shipped at the same time.	WH20.7
`OIL-QUANTITY` QUANTITY	Signed 13.4	The quantity of the item that is being billed on this line.	WH20.7
`OIL-INVC-CW-QTY` INVC_CW_QTY	Signed 13.4	Invoice catch weight quantity. This field is valid only for catch weight items. This is used in extended price calculation, but quantity is used for pricing.	WH20.7
`OIL-SPR-UOM` SPR_UOM	Alpha 4	Indicates the selling price unit of measure with which this line has been priced.	WH20.7
`OIL-SELL-UOM` SELL_UOM	Alpha 4	The selling unit of measure for the item.	WH20.7
`OIL-SEC-UOM` SEC_UOM	Alpha 4	This field contains the secondary quantity unit of measure. Only used for catch weight items.	WH20.7
`OIL-MULT-SPR-FL` MULT_SPR_FL	Alpha 1	Multiple sell price flag. The flag is set if the item has multiple pricing set in the Item Master file. If this flag is set, price break is maintained in the Order Line Pricing UOM's file. `Y` Yes `N` No	WH20.7
`OIL-SPR-TO-STOCK` SPR_TO_STOCK	Signed 13.7	Conversion factor from pricing unit of measure back to stock unit of measure.	WH20.7
`OIL-SELL-TO-STOCK` SELL_TO_STOCK	Signed 13.7	Conversion factor from selling unit of measure back to stock unit of measure.	WH20.7
`OIL-SEC-UOM-MULT` SEC_UOM_MULT	Signed 13.7	This field contains the secondary quantity unit of measure multiplier. It is used to convert the stock on hand quantity to the secondary quantity or visa versa. Used with catch weight items only.	WH20.7
`OIL-LOCATION` LOCATION	Alpha 5	This field contains a valid stock location within the company inventory.	WH20.7
`OIL-PRICE-STATUS` PRICE_STATUS	Alpha 1	This value indicates how the invoice line was priced; for example, was the price overridden or amalgamated pricing used. `A` Amalgated (group) pricing. `C` System calculated pricing. `O` Manual override of pricing.	WH20.7
`OIL-ENTERED-PRICE` ENTERED_PRICE	Signed 18.5	This is the price of the line item.	WH20.7
`OIL-UNIT-PRICE` UNIT_PRICE	Signed 18.5	The unit price of the line item.	WH20.7
`OIL-SELL-PRC-CURR` SELL_PRC_CURR	Signed 18.5	This is the selling price in the original billing unit of measure.	WH20.7
`OIL-SELL-UNIT-PRC` SELL_UNIT_PRC	Signed 18.5	The price in selling unit of measure. Used internally; never seen on the form.	WH20.7
`OIL-UNIT-COST` UNIT_COST	Signed 18.5	This is the unit cost for the invoice line.	WH20.7
`OIL-CURRENT-COST` CURRENT_COST	Signed 18.5	This is the cost used for valuation when the stock on hand goes negative for an average costing company.	WH20.7
`OIL-NO-CHARGE-FL` NO_CHARGE_FL	Alpha 1	No Charge Flag indicating if the line is intentionally supposed to be no charge. `N` No, normal pricing. `Y` Yes, this is a no charge line.	WH20.7
`OIL-ENTERED-DISC` ENTERED_DISC	Signed 18.2	The add-on discount that can be entered when adding an invoice line.	WH20.7
`OIL-ADD-ON-DISC` ADD_ON_DISC	Signed 18.2	This is the add-on discount in the company base currency.	WH20.7
`OIL-ALLOC-DISC` ALLOC_DISC	Signed 18.5	The portion of the order level discount or invoice add-on discount allocated to this line on the invoice. Tax is calculated after discounts are taken out of the invoice amount and the invoice/order level discounts must be dispersed among the lines of the invoice as the system calculates tax at the line level.	WH20.7
`OIL-TAX-EXEMPT-CD` TAX_EXEMPT_CD	Alpha 1	Indicates whether the line item is tax exempt or not. `E` Exempt `T` Taxable	WH20.7
`OIL-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.	WH20.7
`OIL-ENT-TAXABLE` ENT_TAXABLE	Signed 18.2	The taxable amount of the line item if it is not tax exempt. This is a calculated amount and is stored in company base currency. The taxable amount is the net amount of the line minus the allocated discount amount.	WH20.7
`OIL-TAXABLE-BSE` TAXABLE_BSE	Signed 18.2	Taxable amount of the line in company base currency.	WH20.7
`OIL-TAX-AMT-CURR` TAX_AMT_CURR	Signed 18.2	Taxable amount of the line item in original billing currency.	WH20.7
`OIL-TAX-AMT-BSE` TAX_AMT_BSE	Signed 18.2	Tax amount in company base currency.	WH20.7
`OIL-REASON-CODE` REASON_CODE	Alpha 4	Reason code is used to indicate the reason for adding a credit memo to the system. If entered, it must be valid in the Reason Code file.	WH20.7
`OIL-DISC-CODE` DISC_CODE	Alpha 10	This field holds the discount code used to assess a discount amount to this line item. If the item is an inventory or non-stock item, and the pricing of this item includes discounting, the discount code defaults from the pricing modifier (price list, contract, or promotion) and cannot be changed.	WH20.7
`OIL-ORD-DISC-FL` ORD_DISC_FL	Alpha 1	This flag determines whether the order line is eligible for an allocated discount. `Y` Yes `N` No	WH20.7
`OIL-CONTRACT-NBR` CONTRACT_NBR	Alpha 14	If a contract appears on this line field, the line was priced using this contract number.	WH20.7
`OIL-PROMOTION` PROMOTION	Alpha 10	If a promotion is found in this field, this line item was priced using a promotion price modifier.	WH20.7
`OIL-ACTIVITY` ACTIVITY	Alpha 15	In this file the Activity field is used for the revenue (sales) side of the posting whereas the Activity-C field is used for the Cost (COGS) side of the posting. Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. Activities and cost object activities are used synonymously in Project Accounting. Direct costs are posted to activities, and indirect costs are allocated to activities based on activity drivers. Activities are grouped or organized by activity levels. There are two types of activities: "posting allowed" and "summary only." Use posting level activities to budget and maintain all posted transactions. Summary activities or macro activities combine information and balances from lower level activities for reporting and inquiries.	WH20.7
`OIL-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	In this file the Acct-Category field is used for the revenue (sales) postings whereas the Acct-Categ-C field is used for Cost (COGS) postings. Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in Project Accounting. 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 Account Assignment (AC07.1). 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.	WH20.7
`OIL-ATN-OBJ-ID` ATN_OBJ_ID	Numeric 12	Represents Activity Management system ID for the revenue (sales) Activity. Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. Activities and cost object activities are used synonymously in the Activity Management system. Direct costs are posted to activities, and indirect costs are allocated to activities based on activity drivers. Activities are grouped or organized by activity levels. There are two types of activities: "posting allowed" and "summary only." Use posting level activities to budget and maintain all posted transactions. Summary activities or macro activities combine information and balances from lower level activities for reporting and inquiries.	WH20.7
`OIL-ACTIVITY-C` ACTIVITY_C	Alpha 15	In this file the Activity-C field is used for the Cost (COGS) side of the posting whereas the Activity field is used for the revenue (sales) side of the posting. Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. Activities and cost object activities are used synonymously in Project Accounting. Direct costs are posted to activities, and indirect costs are allocated to activities based on activity drivers. Activities are grouped or organized by activity levels. There are two types of activities: "posting allowed" and "summary only." Use posting level activities to budget and maintain all posted transactions. Summary activities or macro activities combine information and balances from lower level activities for reporting and inquiries.	WH20.7
`OIL-ACCT-CATEG-C` ACCT_CATEG_C	Alpha 5	In this file the Acct-Categ-C field is used for Cost (COGS) postings whereas the Acct-Category field is used for revenue (sales) postings. Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in Project Accounting. 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 Account Assignment (AC07.1). 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.	WH20.7
`OIL-ATN-OBJ-ID-C` ATN_OBJ_ID_C	Numeric 12	The system defined object id representing the Activity Management commitment for Cost (COGS).	WH20.7
`OIL-FINAL-INVC-FL` FINAL_INVC_FL	Alpha 1	This flag indicates if the invoice this line is on is the last invoice for this order. `Y` Yes `N` No	WH20.7
`OIL-SLS-ACCT-UNIT` SLS_ACCT_UNIT	Alpha 15	Sales account unit to be credited or debited for this line.	WH20.7
`OIL-SLS-ACCOUNT` SLS_ACCOUNT	Numeric 6	Sales account number to be debited or credited for this line.	WH20.7
`OIL-SLS-SUB-ACCT` SLS_SUB_ACCT	Numeric 4	Sales subaccount number to be debited or credited for this line.	WH20.7
`OIL-SALES-MAJCL` SALES_MAJCL	Alpha 4	Sales major class code of the line item.	WH20.7
`OIL-SALES-MINCL` SALES_MINCL	Alpha 4	Sales minor class code of the line item.	WH20.7
`OIL-DSC-AMT` DSC_AMT	Signed 18.2 Occurs 3 Times ×3	This is the price modifier discount amount calculated for the line item.	WH20.7
`OIL-DSC-ACCT-UNIT` DSC_ACCT_UNIT	Alpha 15 Occurs 3 Times ×3	These fields store the discount account units that are to be debited for nonstock line items that are affected by price modifier discounts. These account units are credited for credit memo line items.	WH20.7
`OIL-DSC-ACCOUNT` DSC_ACCOUNT	Numeric 6 Occurs 3 Times ×3	These fields store the discount account numbers that are to be debited for nonstock line items that are affected by price modifier discounts. The account is credited for credit memo line items.	WH20.7
`OIL-DSC-SUB-ACCT` DSC_SUB_ACCT	Numeric 4 Occurs 3 Times ×3	These fields store the discount subaccount numbers that are to be debited for nonstock line items that are affected by price modifier discounts. The account is credited for credit memo line items.	WH20.7
`OIL-DSC-AMT-CURR` DSC_AMT_CURR	Derived	This is the sum total of the price modifier discount amounts as calculated for the line item in original billing currency.	—
`OIL-DSC-AMT-BASE` DSC_AMT_BASE	Signed 18.2	This is the sum total of the price modifier discount amounts as calculated for the line item in company base currency.	WH20.7
`OIL-OFF-ACCT-UNIT` OFF_ACCT_UNIT	Alpha 15	This cost of goods offset account unit will be credited for non-stock and special items ordered that have a cost associated with them. This account can default from the sales class for non-stock items and will default from the process level for special items. The account will be debited for return to stock credit memos.	WH20.7
`OIL-OFF-ACCOUNT` OFF_ACCOUNT	Numeric 6	This cost of goods offset account number will be credited for non-stock and special items that have a cost associated with them. This account can default from the sales class for non-stock items and will default from the process level for special items with associated costs. This account will be debited for return to stock credit memo line items.	WH20.7
`OIL-OFF-SUB-ACCT` OFF_SUB_ACCT	Numeric 4	This cost of goods offset subaccount will be credited for non-stock and special items ordered that have a cost associated with them. This account can default from the sales class for non-stock items and will default from the process level for special items with associated costs. The account will be debited for return to stock credit memos.	WH20.7
`OIL-CGS-ACCT-UNIT` CGS_ACCT_UNIT	Alpha 15	The cost of goods sold account unit is debited for non-stock or special items. Defaults from the process level for special orders and defaults from the sales class for non-stock items. This account is credited for return to stock credit memo lines.	WH20.7
`OIL-CGS-ACCOUNT` CGS_ACCOUNT	Numeric 6	The cost of goods sold account number is debited for non-stock or special items. This account defaults from the process level for special orders and defaults from the sales class for non-stock items. This account is credited for return to stock credit memo lines.	WH20.7
`OIL-CGS-SUB-ACCT` CGS_SUB_ACCT	Numeric 4	The cost of goods sold subaccount number is debited for non-stock and special items. This will default from the process level for special orders and defaults from the sales class for non-stock items. This account is credited for return to stock credit memo lines.	WH20.7
`OIL-LAST-MISC-SEQ` LAST_MISC_SEQ	Numeric 3	This value indicates the number of the last add-on charge attached to this line. This value determines the sequence number of the next add-on charge.	WH20.7
`OIL-LAST-COMM-SEQ` LAST_COMM_SEQ	Numeric 3	This is the sequence number of the last comment line entered for this invoice line.	BLI2.1, WH20.7
`OIL-TERRITORY` TERRITORY	Alpha 4	The sales territory to which this line belongs. The territory is determined based upon the customer and the sales representative assigned to the customer. Territory can be overridden online when adding an invoice.	WH20.7
`OIL-SALESMAN` SALESMAN	Numeric 4	The primary sales representative responsible for this order and/or invoice. Defaults from the customer ship-to for this order, or if the ship-to is not entered, will default from the customer master. The sales representative can be overridden when entering an order and/or invoice. This is the sales representative to which the invoice or order belongs. This will default from the customer master or can be overridden when placing the order or entering the invoice.	WH20.7
`OIL-SALESMAN-2` SALESMAN_2	Numeric 4	The secondary sales representative responsible for this order and/or invoice. Defaults from the customer ship-to for this order, or if the ship-to is not entered, will default from the customer master.	WH20.7
`OIL-COMM-RATE-1` COMM_RATE_1	Percent 7.5 (Percent)	Commission rate for sales representative 1. Defaults from the sales representative record.	WH20.7
`OIL-COMM-RATE-2` COMM_RATE_2	Percent 7.5 (Percent)	Commission rate for sales representative 2. Defaults from the salesman record.	WH20.7
`OIL-COMM-SPLIT` COMM_SPLIT	Percent 5.3 (Percent)	The portion of the invoice line 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
`OIL-USER-FLD1` USER_FLD1	Alpha 2	This is the first user-defined field on the invoice line. These user-defined field values, if entered, and the line is a create PO = Yes, will interface into Purchase Order and appear on the purchase order line in the purchase order user-defined fields.	WH20.7
`OIL-USER-FLD2` USER_FLD2	Alpha 30 (Lower Case)	The second user-defined field on the invoice line. These user-defined field values, if entered and the line creates a purchase order, will interface into Purchase Order and appear on the purchase order line in the purchase order user-defined fields.	WH20.7
`OIL-USER-FLD3` USER_FLD3	Alpha 15 (Lower Case)	The third user-defined field on the invoice line. These user-defined field values, if entered and the line creates a purchase order, will interface into Purchase Order and appear on the purchase order line in the purchase order user-defined fields.	WH20.7
`OIL-LINE-GRS-CURR` LINE_GRS_CURR	Signed 18.2	This is the gross amount of the line in original billing currency. Calculated by multiplying quantity by sell price in billing currency.	WH20.7
`OIL-INVL-OBJ-ID` INVL_OBJ_ID	Numeric 12	—	—
`OIL-PROD-TAX-CAT` PROD_TAX_CAT	Alpha 15	A classification of items for determining taxes using the VERTEX system in Lawson Order Entry system or the cash receipts programs in the Lawson Cash Ledger system.	WH20.7
`OIL-LINE-NET-CURR` LINE_NET_CURR	Derived	This is the net amount of the line in original billing currency. This is calculated in the following way: Line gross amount in billing currency - entered discount - discount amount in billing currency.	—
`OIL-LINE-NTX-CURR` LINE_NTX_CURR	Derived	Net amount for tax purposes. Allocated discount from header also subtracted from gross.	—
`OIL-LINE-GRS-BASE` LINE_GRS_BASE	Signed 18.2	This is the gross amount of the line in original company base currency. Calculated by multiplying Quantity by Sell Unit Price.	WH20.7
`OIL-LINE-NET-BASE` LINE_NET_BASE	Derived	This is the net amount of the line in company base currency. This is calculated in the following way: line gross amount in base currency - add-on discount - discount amount in base currency.	—
`OIL-QTY-IN-STOCK` QTY_IN_STOCK	Derived	Order quantity in the stock unit of measure.	—
`OIL-LINE-COST` LINE_COST	Derived	The total cost of the line item.	—
`OIL-S-ACCT-UNIT` S_ACCT_UNIT	Derived	The sales account unit that the system posts to.	—
`OIL-S-ACCOUNT` S_ACCOUNT	Derived	The sales account that the system posts to.	—
`OIL-S-SUB-ACCT` S_SUB_ACCT	Derived	The sales subaccount that the system posts to.	—
`OIL-D1-ACCT-UNIT` D1_ACCT_UNIT	Derived	The first discount account unit that the system posts to.	—
`OIL-D1-ACCOUNT` D1_ACCOUNT	Derived	The first discount account that the system posts to.	—
`OIL-D1-SUB-ACCT` D1_SUB_ACCT	Derived	The first discount subaccount that the system posts to.	—
`OIL-D2-ACCT-UNIT` D2_ACCT_UNIT	Derived	The second discount account unit that the system posts to.	—
`OIL-D2-ACCOUNT` D2_ACCOUNT	Derived	The second discount account that the system posts to.	—
`OIL-D2-SUB-ACCT` D2_SUB_ACCT	Derived	The second discount subaccount that the system posts to.	—
`OIL-D3-ACCT-UNIT` D3_ACCT_UNIT	Derived	The third discount account unit that the system posts to.	—
`OIL-D3-ACCOUNT` D3_ACCOUNT	Derived	The third discount account that the system posts to.	—
`OIL-D3-SUB-ACCT` D3_SUB_ACCT	Derived	The third discount subaccount that the system posts to.	—
`OIL-D1-AMOUNT` D1_AMOUNT	Derived	The dollar amount for the first discount.	—
`OIL-D2-AMOUNT` D2_AMOUNT	Derived	The dollar amount for the second discount.	—
`OIL-D3-AMOUNT` D3_AMOUNT	Derived	The dollar amount for the third discount.	—
`OIL-I-ACCT-UNIT` I_ACCT_UNIT	Derived	The inventory account unit that the system posts to.	—
`OIL-I-ACCOUNT` I_ACCOUNT	Derived	The inventory account that the system posts to.	—
`OIL-I-SUB-ACCT` I_SUB_ACCT	Derived	The inventory subaccount that the system posts to.	—
`OIL-C-ACCT-UNIT` C_ACCT_UNIT	Derived	The cost of goods sold account unit that the system posts to.	—
`OIL-C-ACCOUNT` C_ACCOUNT	Derived	The cost of goods sold account that the system posts to.	—
`OIL-C-SUB-ACCT` C_SUB_ACCT	Derived	The cost of goods sold subaccount that the system posts to.	—
`OIL-RND-FLG` RND_FLG	Alpha 1	" " = Blank `Y` Yes	WH20.7
`OIL-GLBL-LINE-TYPE` GLBL_LINE_TYPE	Alpha 15	—	WH20.7

Indexes (6)

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
`OILSET1`	`COMPANY`, `INVC-PREFIX`, `INVC-NUMBER`, `LINE-NBR`	Primary		BLI2.1, IC216, TX101, WH20.7
`OILSET2`	`COMPANY`, `INVC-PREFIX`, `INVC-NUMBER`, `SALES-MAJCL`, `SALES-MINCL`, `LINE-NBR`	Subset	Where PRICE-STATUS = "A"	WH20.7
`OILSET3`	`ATN-OBJ-ID`	KeyChange, Subset	Where ATN-OBJ-ID != Zeroes	—
`OILSET4`	`ATN-OBJ-ID-C`	KeyChange, Subset	Where ATN-OBJ-ID-C != Zeroes	—
`OILSET5`	`COMPANY`, `INVC-PREFIX`, `INVC-NUMBER`, `TAX-CODE`, `PROD-TAX-CAT`, `LINE-NBR`	KeyChange		WH20.7
`OILSET6`	`COMPANY`, `INVC-PREFIX`, `LINE-NBR`, `INVC-NUMBER`			WH20.7

Relations

One to one (34) — lookups and parents

Relation	Table	Rules	Condition	Field map
Add On Disc	GLMASTER	Not Required		`OIL-COMPANY` → `-COMPANY`, `OEP-DSC-ACCT-UNIT` → `-ACCT-UNIT`, `OEP-DSC-ACCOUNT` → `-ACCOUNT`, `OEP-DSC-SUB-ACCT` → `-SUB-ACCOUNT`
Arcomp	ARCOMP	Required		`OIL-COMPANY` → `ACO-COMPANY`
Bloiluf	BLOILUF	Not Required		`OIL-COMPANY` → `BDU-COMPANY`, `OIL-INVC-PREFIX` → `BDU-INVC-PREFIX`, `OIL-INVC-NUMBER` → `BDU-INVC-NUMBER`, `OIL-LINE-NBR` → `BDU-LINE-NBR`
Blricline	BLRICLINE	Not Required	Valid When OEI-RECUR-INVOICE != Spaces	`OIL-COMPANY` → `BUL-COMPANY`, `OEI-RECUR-INVOICE` → `BUL-RECUR-INVOICE`, `OEI-CUSTOMER` → `BUL-CUSTOMER`, `OIL-LINE-NBR` → `BUL-LINE-NBR`
Cogs Account	GLMASTER	Not Required		`OIL-COMPANY` → `GLM-COMPANY`, `OIL-CGS-ACCT-UNIT` → `GLM-ACCT-UNIT`, `OIL-CGS-ACCOUNT` → `GLM-ACCOUNT`, `OIL-CGS-SUB-ACCT` → `GLM-SUB-ACCOUNT`
Coline	COLINE	Not Required		`OIL-COMPANY` → `COL-COMPANY`, `OIL-ORDER-NBR` → `COL-ORDER-NBR`, `OIL-LINE-NBR` → `COL-LINE-NBR`
Custdesc	CUSTDESC	Required		`ACO-CUST-GROUP` → `CUD-CUST-GROUP`, `OEI-CUSTOMER` → `CUD-CUSTOMER`
Iccategory	ICCATEGORY	Not Required	Valid When OIL-LINE-TYPE = "I"	`OIL-COMPANY` → `ICA-COMPANY`, `OIL-LOCATION` → `ICA-LOCATION`, `ITL-GL-CATEGORY` → `ICA-GL-CATEGORY`
Iccompany	ICCOMPANY	Required	When OIL-LINE-TYPE != "X"	`OIL-COMPANY` → `ICC-COMPANY`
Inventory Acct	GLMASTER	Not Required		`OIL-COMPANY` → `GLM-COMPANY`, `OIL-OFF-ACCT-UNIT` → `GLM-ACCT-UNIT`, `OIL-OFF-ACCOUNT` → `GLM-ACCOUNT`, `OIL-OFF-SUB-ACCT` → `GLM-SUB-ACCOUNT`
Itemloc	ITEMLOC	Required	When OIL-LINE-TYPE = "I"	`OIL-COMPANY` → `ITL-COMPANY`, `OIL-LOCATION` → `ITL-LOCATION`, `OIL-ITEM` → `ITL-ITEM`
Itemmast	ITEMMAST	Required	When OIL-LINE-TYPE = "I" Or OIL-LINE-TYPE = "N"	`ICC-ITEM-GROUP` → `ITE-ITEM-GROUP`, `OIL-ITEM` → `ITE-ITEM`
Oecompany	OECOMPANY	Required		`OIL-COMPANY` → `OEC-COMPANY`
Oecsline	BLRICLINE	Not Required	Valid When OEI-RECUR-INVOICE != Spaces	`OIL-COMPANY` → `BUL-COMPANY`, `OEI-RECUR-INVOICE` → `BUL-RECUR-INVOICE`, `OEI-CUSTOMER` → `BUL-CUSTOMER`, `OIL-LINE-NBR` → `BUL-LINE-NBR`
Oecustsrvc	BLRICUST	Not Required		`OIL-COMPANY` → `BRC-COMPANY`, `OEI-RECUR-INVOICE` → `BRC-RECUR-INVOICE`, `OEI-CUSTOMER` → `BRC-CUSTOMER`
Oediscount	OEDISCOUNT	Required		`OIL-COMPANY` → `OED-COMPANY`, `OIL-DISC-CODE` → `OED-DISC-CODE`
Oeincdgblk	OEINVSGBLK	Not Required		`OIL-COMPANY` → `OSB-COMPANY`, `OIL-INVC-PREFIX` → `OSB-INVC-PREFIX`, `OIL-INVC-NUMBER` → `OSB-INVC-NUMBER`, `OIL-LINE-NBR` → `OSB-LINE-NBR`, `Zeroes` → `OSB-SEQ`
Oeinvcuom	OEINVCUOM	Not Required	Valid When OIL-MULT-SPR-FL = "Y"	`OIL-COMPANY` → `OEU-COMPANY`, `OIL-INVC-PREFIX` → `OEU-INVC-PREFIX`, `OIL-INVC-NUMBER` → `OEU-INVC-NUMBER`, `OIL-LINE-NBR` → `OEU-LINE-NBR`
Oeinvhdr	OEINVHDR	Required	When OEI-BATCH-NBR != Zeroes	`OIL-COMPANY` → `OIH-COMPANY`, `OEI-BATCH-NBR` → `OIH-BATCH-NBR`
Oeinvoice	OEINVOICE	Required		`OIL-COMPANY` → `OEI-COMPANY`, `OIL-INVC-PREFIX` → `OEI-INVC-PREFIX`, `OIL-INVC-NUMBER` → `OEI-INVC-NUMBER`
Oeproclev	OEPROCLEV	Required		`OIL-COMPANY` → `OEP-COMPANY`, `OEI-PROCESS-LEVEL` → `OEP-PROCESS-LEVEL`
Oereason	OEREASON	Required	When OIL-REASON-CODE != Spaces	`OIL-COMPANY` → `OER-COMPANY`, `OIL-REASON-CODE` → `OER-REASON-CODE`
Oeshipline	WHSHIPLINE	Not Required		`OIL-COMPANY` → `WHL-COMPANY`, `OIL-LOCATION` → `WHL-LOCATION`, `OIL-SHIPMENT-NBR` → `WHL-SHIPMENT-NBR`, `OIL-LINE-NBR` → `WHL-LINE-NBR`
Oeshipment	WHSHIPMENT	Required	When OEI-INVC-SOURCE = "S"	`OIL-COMPANY` → `WHS-COMPANY`, `OIL-LOCATION` → `WHS-LOCATION`, `OEI-SHIPMENT-NBR` → `WHS-SHIPMENT-NBR`
Oeslsacct	OESLSACCT	Not Required	Valid When OIL-LINE-TYPE = "I" Or OIL-LINE-TYPE = "N"	`OIL-COMPANY` → `OSA-COMPANY`, `OEI-PROCESS-LEVEL` → `OSA-PROCESS-LEVEL`, `OIL-SALES-MAJCL` → `OSA-SALES-MAJCL`, `OIL-SALES-MINCL` → `OSA-SALES-MINCL`
Price List	OEPRCLIST	Required		`OIL-COMPANY` → `OPL-COMPANY`, `Spaces` → `OPL-CUSTOMER`, `OEI-LIST-NAME` → `OPL-LIST-NAME`, `Spaces` → `OPL-PROMOTION`
Sales Account	GLMASTER	Not Required		`OIL-COMPANY` → `GLM-COMPANY`, `OIL-SLS-ACCT-UNIT` → `GLM-ACCT-UNIT`, `OIL-SLS-ACCOUNT` → `GLM-ACCOUNT`, `OIL-SLS-SUB-ACCT` → `GLM-SUB-ACCOUNT`
Salesman	SALESREP	Required		`OIL-COMPANY` → `SAW-COMPANY`, `OIL-SALESMAN` → `SAW-SALESMAN`
Salesman2	SALESREP	Required	When OIL-SALESMAN-2 != Zeroes	`OIL-COMPANY` → `SAW-COMPANY`, `OIL-SALESMAN-2` → `SAW-SALESMAN`
Salesrep	SALESREP	Required		`OIL-COMPANY` → `SAW-COMPANY`, `OIL-SALESMAN` → `SAW-SALESMAN`
Salesrep2	SALESREP	Required	When OIL-SALESMAN-2 != Zeroes	`OIL-COMPANY` → `SAW-COMPANY`, `OIL-SALESMAN-2` → `SAW-SALESMAN`
Teritory	TERITORY	Required		`OIL-COMPANY` → `TRY-COMPANY`, `OIL-TERRITORY` → `TRY-TERRITORY`
Txtaxcode	TXTAXCODE	Required	When OIL-TAX-CODE != Spaces And OIL-TAX-EXEMPT-CD = "T"	`OIL-COMPANY` → `TAC-COMPANY`, `OIL-TAX-CODE` → `TAC-TAX-CODE`
Whdemndhdr	WHDEMNDHDR	Not Required		`OIL-COMPANY` → `WDH-COMPANY`, `"OE"` → `WDH-SYSTEM-CD`, `OIL-ORDER-NBR` → `WDH-DOC-NBR-NUM`

One to many (13) — child tables

Relation	Table	Rules	Condition	Field map
Cocomp	COCOMP			`OIL-COMPANY` → `CKT-COMPANY`, `"OE"` → `CKT-SYSTEM-CD`, `WDH-DOC-NBR` → `CKT-DOC-NBR`, `OIL-LINE-NBR` → `CKT-LINE-NBR`, → `CKT-COMPONENT-SEQ`
Comisc	COMISC	Required		`OIL-COMPANY` → `CMC-COMPANY`, `OIL-ORDER-NBR` → `CMC-ORDER-NBR`, `OIL-LINE-NBR` → `CMC-LINE-NBR`, → `CMC-SEQ`
Line Comments	OEINVCCOMM	Delete Restricted		`OIL-COMPANY` → `OIC-COMPANY`, `OIL-INVC-PREFIX` → `OIC-INVC-PREFIX`, `OIL-INVC-NUMBER` → `OIC-INVC-NUMBER`, `OIL-LINE-NBR` → `OIC-LINE-NBR`, → `OIC-SEQ`
Line Misc	OEINVCMISC			`OIL-COMPANY` → `OIM-COMPANY`, `OIL-INVC-PREFIX` → `OIM-INVC-PREFIX`, `OIL-INVC-NUMBER` → `OIM-INVC-NUMBER`, `OIL-LINE-NBR` → `OIM-LINE-NBR`, → `OIM-SEQ`
Line Tax	OEINVCTAX		Valid When OEC-TAX-PRINT-CD = "D"	`OIL-COMPANY` → `OIT-COMPANY`, `OIL-INVC-PREFIX` → `OIT-INVC-PREFIX`, `OIL-INVC-NUMBER` → `OIT-INVC-NUMBER`, `OIL-LINE-NBR` → `OIT-LINE-NBR`, → `OIT-TAX-CODE`, → `OIT-SEQ`, → `OIT-TAX-LEVEL`
Oedist	OEDIST		Valid When OEI-STATUS = 9	`OIL-COMPANY` → `ODI-COMPANY`, `OIL-INVC-PREFIX` → `ODI-INVC-PREFIX`, `OIL-INVC-NUMBER` → `ODI-INVC-NUMBER`, `Zeroes` → `ODI-AUTH-NO`, `OIL-LINE-NBR` → `ODI-LINE-NBR`, → `ODI-ACCT-UNIT`, → `ODI-ACCOUNT`, → `ODI-SUB-ACCOUNT`, → `ODI-SEQ`, → `ODI-POSTING-TYPE`
Oeinvccomm	OEINVCCOMM			`OIL-COMPANY` → `OIC-COMPANY`, `OIL-INVC-PREFIX` → `OIC-INVC-PREFIX`, `OIL-INVC-NUMBER` → `OIC-INVC-NUMBER`, `OIL-LINE-NBR` → `OIC-LINE-NBR`, → `OIC-SEQ`
Oeinvcdtl	OEINVCDTL			`OIL-COMPANY` → `OID-COMPANY`, `OIL-INVC-PREFIX` → `OID-INVC-PREFIX`, `OIL-INVC-NUMBER` → `OID-INVC-NUMBER`, `OIL-LINE-NBR` → `OID-LINE-NBR`, → `OID-UOM`, → `OID-LOT`, → `OID-SUBLOT`, → `OID-BIN`, → `OID-SERIAL`
Oeinvcmisc	OEINVCMISC			`OIL-COMPANY` → `OIM-COMPANY`, `OIL-INVC-PREFIX` → `OIM-INVC-PREFIX`, `OIL-INVC-NUMBER` → `OIM-INVC-NUMBER`, `OIL-LINE-NBR` → `OIM-LINE-NBR`, → `OIM-SEQ`
Oeinvctax	OEINVCTAX	Required		`OIL-COMPANY` → `OIT-COMPANY`, `OIL-INVC-PREFIX` → `OIT-INVC-PREFIX`, `OIL-INVC-NUMBER` → `OIT-INVC-NUMBER`, `OIL-LINE-NBR` → `OIT-LINE-NBR`, `Zeroes` → `OIT-SEQ`, → `OIT-TAX-CODE`, → `OIT-TAX-LEVEL`
Oeinvsgblk	OEINVSGBLK			`OIL-COMPANY` → `OSB-COMPANY`, `OIL-INVC-PREFIX` → `OSB-INVC-PREFIX`, `OIL-INVC-NUMBER` → `OSB-INVC-NUMBER`, `OIL-LINE-NBR` → `OSB-LINE-NBR`, → `OSB-SEQ`
Polinesrc	POLINESRC		Valid When COL-CREATE-PO = "Y"	`OIL-COMPANY` → `PLS-OPER-COMPANY`, `"OE"` → `PLS-ORIGIN-CD`, `OIL-ORDER-NBR` → `PLS-SOURCE-DOC-N`, `COL-LINE-NBR` → `PLS-SRC-LINE-NBR`, → `PLS-PO-CODE`, → `PLS-PO-NUMBER`, → `PLS-PO-RELEASE`, → `PLS-LINE-NBR`
Returnline	RETURNLINE			`OIL-COMPANY` → `RTL-COMPANY`, `OEI-CUSTOMER` → `RTL-CUSTOMER`, `OIL-ITEM` → `RTL-ITEM`, `OEI-SHIP-TO` → `RTL-SHIP-TO`, → `RTL-DATE`, → `RTL-AUTH-NO`, → `RTL-LINE-NBR`

OEINVCLINE – Invoice Line

About OEINVCLINE

Fields (109)

Indexes (6)

Relations

One to one (34) — lookups and parents

One to many (13) — child tables

Programs

Updated by (3)

Referenced by (1)