Invoice Line

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.

REFERENCED BY

TX101

UPDATED BY

BLI2.1

WH20.7

IC216

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
OIL-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
OIL-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
OIL-INVC-NUMBER Element: 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 Element: Line Nbr	Numeric 6 The system number of the line on the invoice.	WH20.7
OIL-LINE-TYPE Element: 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 Element: Item	Alpha 32 This field contains the item identifier.	WH20.7
OIL-ITEM-16 Element: Item 16	Derived This field contains the 16-character item description. Derived by the system.
OIL-DESCRIPTION Element: Description	Alpha 30 (Lower Case) The description of the item.	WH20.7
OIL-ORDER-NBR Element: 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 Element: 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 Element: Quantity	Signed 13.4 The quantity of the item that is being billed on this line.	WH20.7
OIL-INVC-CW-QTY Element: Quantity	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 Element: Uom	Alpha 4 Indicates the selling price unit of measure with which this line has been priced.	WH20.7
OIL-SELL-UOM Element: Uom	Alpha 4 The selling unit of measure for the item.	WH20.7
OIL-SEC-UOM Element: Uom	Alpha 4 This field contains the secondary quantity unit of measure. Only used for catch weight items.	WH20.7
OIL-MULT-SPR-FL Element: All Flag	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 Element: Sell To Stock	Signed 13.7 Conversion factor from pricing unit of measure back to stock unit of measure.	WH20.7
OIL-SELL-TO-STOCK Element: 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 Element: 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 Element: Location	Alpha 5 This field contains a valid stock location within the company inventory.	WH20.7
OIL-PRICE-STATUS Element: 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 Element: Intl Cost	Signed 18.5 This is the price of the line item.	WH20.7
OIL-UNIT-PRICE Element: Intl Cost	Signed 18.5 The unit price of the line item.	WH20.7
OIL-SELL-PRC-CURR Element: Sell Unit Prc	Signed 18.5 This is the selling price in the original billing unit of measure.	WH20.7
OIL-SELL-UNIT-PRC Element: 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 Element: Intl Cost	Signed 18.5 This is the unit cost for the invoice line.	WH20.7
OIL-CURRENT-COST Element: Intl 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 Element: 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 Element: Intl Amt	Signed 18.2 The add-on discount that can be entered when adding an invoice line.	WH20.7
OIL-ADD-ON-DISC Element: Intl Amt	Signed 18.2 This is the add-on discount in the company base currency.	WH20.7
OIL-ALLOC-DISC Element: Intl Cost	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 Element: Tax Exempt Cd	Alpha 1 Indicates whether the line item is tax exempt or not. E = Exempt T = Taxable	WH20.7
OIL-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.	WH20.7
OIL-ENT-TAXABLE Element: Intl Amt	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 Element: Intl Amt	Signed 18.2 Taxable amount of the line in company base currency.	WH20.7
OIL-TAX-AMT-CURR Element: Intl Amt	Signed 18.2 Taxable amount of the line item in original billing currency.	WH20.7
OIL-TAX-AMT-BSE Element: Intl Amt	Signed 18.2 Tax amount in company base currency.	WH20.7
OIL-REASON-CODE Element: 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 Element: Discount 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 Element: 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 Element: Contract Nbr	Alpha 14 If a contract appears on this line field, the line was priced using this contract number.	WH20.7
OIL-PROMOTION Element: 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 Element: 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 Element: 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 Element: 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 Element: Activity	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 Element: Acct Category	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 Element: Obj Id	Numeric 12 The system defined object id representing the Activity Management commitment for Cost (COGS).	WH20.7
OIL-FINAL-INVC-FL Element: All Flag	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 Element: Acct Unit	Alpha 15 Sales account unit to be credited or debited for this line.	WH20.7
OIL-SLS-ACCOUNT Element: Account	Numeric 6 Sales account number to be debited or credited for this line.	WH20.7
OIL-SLS-SUB-ACCT Element: Sub Acct	Numeric 4 Sales subaccount number to be debited or credited for this line.	WH20.7
OIL-SALES-MAJCL Element: Major Class	Alpha 4 Sales major class code of the line item.	WH20.7
OIL-SALES-MINCL Element: Minor Class	Alpha 4 Sales minor class code of the line item.	WH20.7
OIL-DSC-AMT Element: Intl Amt	Signed 18.2 Occurs 3 Times This is the price modifier discount amount calculated for the line item.	WH20.7
OIL-DSC-ACCT-UNIT Element: Acct Unit	Alpha 15 Occurs 3 Times 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 Element: Account	Numeric 6 Occurs 3 Times 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 Element: Sub Acct	Numeric 4 Occurs 3 Times 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 Element: 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 Element: Intl Amt	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 Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: Seq	Numeric 3 This is the sequence number of the last comment line entered for this invoice line.	BLI2.1 WH20.7
OIL-TERRITORY Element: 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 Element: 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 Element: Salesman	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 Element: Chrg Rate	Percent 7.5 (Percent) Commission rate for sales representative 1. Defaults from the sales representative record.	WH20.7
OIL-COMM-RATE-2 Element: Chrg Rate	Percent 7.5 (Percent) Commission rate for sales representative 2. Defaults from the salesman record.	WH20.7
OIL-COMM-SPLIT Element: 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 Element: Po User Fld 2	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 Element: 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 Element: 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 Element: Intl Amt	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 Element: Invl Obj Id	Numeric 12
OIL-PROD-TAX-CAT Element: 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 Element: 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 Element: Line Ntx Curr	Derived Net amount for tax purposes. Allocated discount from header also subtracted from gross.
OIL-LINE-GRS-BASE Element: Intl Amt	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 Element: 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 Element: Qty In Stock	Derived Order quantity in the stock unit of measure.
OIL-LINE-COST Element: Line Cost	Derived The total cost of the line item.
OIL-S-ACCT-UNIT Element: S Acct Unit	Derived The sales account unit that the system posts to.
OIL-S-ACCOUNT Element: S Account	Derived The sales account that the system posts to.
OIL-S-SUB-ACCT Element: S Sub Acct	Derived The sales subaccount that the system posts to.
OIL-D1-ACCT-UNIT Element: D1 Acct Unit	Derived The first discount account unit that the system posts to.
OIL-D1-ACCOUNT Element: D1 Account	Derived The first discount account that the system posts to.
OIL-D1-SUB-ACCT Element: D1 Sub Acct	Derived The first discount subaccount that the system posts to.
OIL-D2-ACCT-UNIT Element: D2 Acct Unit	Derived The second discount account unit that the system posts to.
OIL-D2-ACCOUNT Element: D2 Account	Derived The second discount account that the system posts to.
OIL-D2-SUB-ACCT Element: D2 Sub Acct	Derived The second discount subaccount that the system posts to.
OIL-D3-ACCT-UNIT Element: D3 Acct Unit	Derived The third discount account unit that the system posts to.
OIL-D3-ACCOUNT Element: D3 Account	Derived The third discount account that the system posts to.
OIL-D3-SUB-ACCT Element: D3 Sub Acct	Derived The third discount subaccount that the system posts to.
OIL-D1-AMOUNT Element: D1 Amount	Derived The dollar amount for the first discount.
OIL-D2-AMOUNT Element: D2 Amount	Derived The dollar amount for the second discount.
OIL-D3-AMOUNT Element: D3 Amount	Derived The dollar amount for the third discount.
OIL-I-ACCT-UNIT Element: I Acct Unit	Derived The inventory account unit that the system posts to.
OIL-I-ACCOUNT Element: I Account	Derived The inventory account that the system posts to.
OIL-I-SUB-ACCT Element: I Sub Acct	Derived The inventory subaccount that the system posts to.
OIL-C-ACCT-UNIT Element: C Acct Unit	Derived The cost of goods sold account unit that the system posts to.
OIL-C-ACCOUNT Element: C Account	Derived The cost of goods sold account that the system posts to.
OIL-C-SUB-ACCT Element: C Sub Acct	Derived The cost of goods sold subaccount that the system posts to.
OIL-RND-FLG Element: Flag	Alpha 1 " " = Blank Y = Yes	WH20.7
OIL-GLBL-LINE-TYPE Element: Glbl Line Type	Alpha 15	WH20.7

OEINVCLINE FILE INDEX

OEINVCLINE FILE RELATIONS

ONE TO ONE RELATIONS

OEINVCLINE FILE RELATIONS

ONE TO MANY RELATIONS

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