Lawson Insight Technical Documentation |
|
OEINVCLINE
OEINVCLINE FILE
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
BL121 BL123 BL125 BL220 BL232 BL290
BL80.1 BL81.1 TX101
UPDATED BY
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.4 BL21.5 BL29.1 BL29.2 BL320 BL520
BL820 BL92.1 BLI2.1 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OIL-COMPANY Numeric 4 BL120 BL122
Element: Company Identifies the AP company if the BL130 BL20.1
resource type = V. Identifies the HR BL20.3 BL21.2
company if the resource type = E. It is BL21.5 BL29.1
blank for type A, P or Q resources. BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-INVC-PREFIX Alpha 2 BL120 BL122
Element: Invc Prefix This field contains the invoice prefix BL130 BL20.1
that is assigned from either the company BL20.3 BL21.2
or process level, depending on the BL21.5 BL29.1
invoice-level option chosen. BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-INVC-NUMBER Numeric 8 BL120 BL122
Element: Invc Number This field contains the invoice number BL130 BL20.1
assigned by the system. Invoice numbers BL20.3 BL21.2
are assigned at the company or process BL21.5 BL29.1
level, depending on an invoice-level BL29.2 BL520
option on the company file. BL820 BL92.1
WH20.7
OIL-LINE-NBR Numeric 6 BL120 BL122
Element: Line Nbr The system number of the line on the BL130 BL20.1
invoice. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-LINE-TYPE Alpha 1 BL120 BL122
Element: Line Type The line type indicates whether the BL130 BL20.1
item on the line is an inventoried item, BL20.3 BL21.2
non-stock, or special item. BL21.5 BL29.1
I = Inventoried item BL29.2 BL520
N = Non-stock BL820 BL92.1
X = Special order WH20.7
OIL-ITEM Alpha 32 BL120 BL122
Element: Item This field contains the item BL130 BL20.1
identifier. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-ITEM-16 Derived
Element: Item 16 This field contains the 16-character
item description. Derived by the system.
OIL-DESCRIPTION Alpha 30 (Lower Case) BL120 BL122
Element: Description The description of the item. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-ORDER-NBR Numeric 8 BL120 BL122
Element: Order Nbr If the invoice this invoice line was BL130 BL20.1
created on is based on an order BL20.3 BL21.2
shipment, this field will store the BL21.5 BL29.1
order number related to the line. BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-SHIPMENT-NBR Numeric 10 BL120 BL122
Element: Shipment Nbr This field contains the shipment BL130 BL20.1
number. One order can have several BL20.3 BL21.2
shipment numbers if the items of the BL21.5 BL29.1
order were not shipped at the same time. BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-QUANTITY Signed 13.4 BL120 BL122
Element: Quantity The quantity of the item that is being BL130 BL20.1
billed on this line. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-INVC-CW-QTY Signed 13.4 BL120 BL122
Element: Quantity Invoice catch weight quantity. This BL130 BL20.1
field is valid only for catch weight BL20.3 BL21.2
items. This is used in extended price BL21.5 BL29.1
calculation, but quantity is used for BL29.2 BL520
pricing. BL820 BL92.1
WH20.7
OIL-SPR-UOM Alpha 4 BL120 BL122
Element: Uom Indicates the selling price unit of BL130 BL20.1
measure with which this line has been BL20.3 BL21.2
priced. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-SELL-UOM Alpha 4 BL120 BL122
Element: Uom The selling unit of measure for the BL130 BL20.1
item. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-SEC-UOM Alpha 4 BL120 BL122
Element: Uom This field contains the secondary BL130 BL20.1
quantity unit of measure. Only used for BL20.3 BL21.2
catch weight items. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-MULT-SPR-FL Alpha 1 BL120 BL122
Element: All Flag Multiple sell price flag. The flag is BL130 BL20.1
set if the item has multiple pricing set BL20.3 BL21.2
in the Item Master file. If this flag is BL21.5 BL29.1
set, price break is maintained in the BL29.2 BL520
Order Line Pricing UOM's file. BL820 BL92.1
Y = Yes WH20.7
N = No
OIL-SPR-TO-STOCK Signed 13.7 BL120 BL122
Element: Sell To Stock Conversion factor from pricing unit of BL130 BL20.1
measure back to stock unit of measure. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-SELL-TO-STOCK Signed 13.7 BL120 BL122
Element: Sell To Stock Conversion factor from selling unit of BL130 BL20.1
measure back to stock unit of measure. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-SEC-UOM-MULT Signed 13.7 BL120 BL122
Element: Uom Mult This field contains the secondary BL130 BL20.1
quantity unit of measure multiplier. It BL20.3 BL21.2
is used to convert the stock on hand BL21.5 BL29.1
quantity to the secondary quantity or BL29.2 BL520
visa versa. Used with catch weight items BL820 BL92.1
only. WH20.7
OIL-LOCATION Alpha 5 BL120 BL122
Element: Location This field contains a valid stock BL130 BL20.1
location within the company inventory. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-PRICE-STATUS Alpha 1 BL120 BL122
Element: Price Status This value indicates how the invoice BL130 BL20.1
line was priced; for example, was the BL20.3 BL21.2
price overridden or amalgamated pricing BL21.5 BL29.1
used. BL29.2 BL520
A = Amalgated (group) pricing. BL820 BL92.1
C = System calculated pricing. WH20.7
O = Manual override of pricing.
OIL-ENTERED-PRICE Signed 18.5 BL120 BL122
Element: Intl Cost This is the price of the line item. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-UNIT-PRICE Signed 18.5 BL120 BL122
Element: Intl Cost The unit price of the line item. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-SELL-PRC-CURR Signed 18.5 BL120 BL122
Element: Sell Unit Prc This is the selling price in the BL130 BL20.1
original billing unit of measure. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-SELL-UNIT-PRC Signed 18.5 BL120 BL122
Element: Sell Unit Prc The price in selling unit of measure. BL130 BL20.1
Used internally; never seen on the form. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-UNIT-COST Signed 18.5 BL120 BL122
Element: Intl Cost This is the unit cost for the invoice BL130 BL20.1
line. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-CURRENT-COST Signed 18.5 BL120 BL122
Element: Intl Cost This is the cost used for valuation BL130 BL20.1
when the stock on hand goes negative for BL20.3 BL21.2
an average costing company. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-NO-CHARGE-FL Alpha 1 BL120 BL122
Element: No Charge Fl No Charge Flag indicating if the line BL130 BL20.1
is intentionally supposed to be no BL20.3 BL21.2
charge. BL21.5 BL29.1
N = No, normal pricing. BL29.2 BL520
Y = Yes, this is a no charge line. BL820 BL92.1
WH20.7
OIL-ENTERED-DISC Signed 18.2 BL120 BL122
Element: Intl Amt The add-on discount that can be entered BL130 BL20.1
when adding an invoice line. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-ADD-ON-DISC Signed 18.2 BL120 BL122
Element: Intl Amt This is the add-on discount in the BL130 BL20.1
company base currency. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-ALLOC-DISC Signed 18.2 BL120 BL122
Element: Intl Amt The portion of the order level discount BL130 BL20.1
or invoice add-on discount allocated to BL20.3 BL21.2
this line on the invoice. Tax is BL21.5 BL29.1
calculated after discounts are taken out BL29.2 BL520
of the invoice amount and the BL820 BL92.1
invoice/order level discounts must be WH20.7
dispersed among the lines of the invoice
as the system calculates tax at the line
level.
OIL-TAX-EXEMPT-CD Alpha 1 BL120 BL122
Element: Tax Exempt Cd Indicates whether the line item is tax BL130 BL20.1
exempt or not. BL20.3 BL21.2
E = Exempt BL21.5 BL29.1
T = Taxable BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-TAX-CODE Alpha 10 BL120 BL122
Element: Tax Code A user-defined code representing the BL130 BL20.1
tax authorities this ship-to pays sales BL20.3 BL21.2
tax to. Must be a valid tax code record. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-ENT-TAXABLE Signed 18.2 BL120 BL122
Element: Intl Amt The taxable amount of the line item if BL130 BL20.1
it is not tax exempt. This is a BL20.3 BL21.2
calculated amount and is stored in BL21.5 BL29.1
company base currency. The taxable BL29.2 BL520
amount is the net amount of the line BL820 BL92.1
minus the allocated discount amount. WH20.7
OIL-TAXABLE-BSE Signed 18.2 BL120 BL122
Element: Intl Amt Taxable amount of the line in company BL130 BL20.1
base currency. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-TAX-AMT-CURR Signed 18.2 BL120 BL122
Element: Intl Amt Taxable amount of the line item in BL130 BL20.1
original billing currency. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-TAX-AMT-BSE Signed 18.2 BL120 BL122
Element: Intl Amt Tax amount in company base currency. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-REASON-CODE Alpha 4 BL120 BL122
Element: Reason Code Reason code is used to indicate the BL130 BL20.1
reason for adding a credit memo to the BL20.3 BL21.2
system. If entered, it must be valid in BL21.5 BL29.1
the Reason Code file. BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-DISC-CODE Alpha 10 BL120 BL122
Element: Discount Code This field holds the discount code used BL130 BL20.1
to assess a discount amount to this line BL20.3 BL21.2
item. If the item is an inventory or BL21.5 BL29.1
non-stock item, and the pricing of this BL29.2 BL520
item includes discounting, the discount BL820 BL92.1
code defaults from the pricing modifier WH20.7
(price list, contract, or promotion) and
cannot be changed.
OIL-ORD-DISC-FL Alpha 1 BL120 BL122
Element: Ord Disc Fl This flag determines whether the order BL130 BL20.1
line is eligible for an allocated BL20.3 BL21.2
discount. BL21.5 BL29.1
Y = Yes BL29.2 BL520
N = No BL820 BL92.1
WH20.7
OIL-CONTRACT-NBR Alpha 14 BL120 BL122
Element: Contract Nbr If a contract appears on this line BL130 BL20.1
field, the line was priced using this BL20.3 BL21.2
contract number. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-PROMOTION Alpha 10 BL120 BL122
Element: Promotion If a promotion is found in this field, BL130 BL20.1
this line item was priced using a BL20.3 BL21.2
promotion price modifier. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-ACTIVITY Alpha 15 BL120 BL122
Element: Activity In this file the Activity field is used BL130 BL20.1
for the revenue (sales) side of the BL20.3 BL21.2
posting whereas the Activity-C field is BL21.5 BL29.1
used for the Cost (COGS) side of the BL29.2 BL520
posting. BL820 BL92.1
WH20.7
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.
OIL-ACCT-CATEGORY Alpha 5 BL120 BL122
Element: Acct Category In this file the Acct-Category field is BL130 BL20.1
used for the revenue (sales) postings BL20.3 BL21.2
whereas the Acct-Categ-C field is used BL21.5 BL29.1
for Cost (COGS) postings. BL29.2 BL520
BL820 BL92.1
Account categories are groupings of WH20.7
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.
OIL-ATN-OBJ-ID Numeric 12 BL120 BL122
Element: Obj Id Represents Activity Management system BL130 BL20.1
ID for the revenue (sales) Activity. BL20.3 BL21.2
BL21.5 BL29.1
Activities are the processes or BL29.2 BL520
procedures that produce work. Cost BL820 BL92.1
objects (products, services, customers, WH20.7
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.
OIL-ACTIVITY-C Alpha 15 BL120 BL122
Element: Activity In this file the Activity-C field is BL130 BL20.1
used for the Cost (COGS) side of the BL20.3 BL21.2
posting whereas the Activity field is BL21.5 BL29.1
used for the revenue (sales) side of the BL29.2 BL520
posting. BL820 BL92.1
WH20.7
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.
OIL-ACCT-CATEG-C Alpha 5 BL120 BL122
Element: Acct Category In this file the Acct-Categ-C field is BL130 BL20.1
used for Cost (COGS) postings whereas BL20.3 BL21.2
the Acct-Category field is used for BL21.5 BL29.1
revenue (sales) postings. BL29.2 BL520
BL820 BL92.1
Account categories are groupings of WH20.7
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.
OIL-ATN-OBJ-ID-C Numeric 12 BL120 BL122
Element: Obj Id The system defined object id BL130 BL20.1
representing the Activity Management BL20.3 BL21.2
commitment for Cost (COGS). BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-FINAL-INVC-FL Alpha 1 BL120 BL122
Element: All Flag This flag indicates if the invoice this BL130 BL20.1
line is on is the last invoice for this BL20.3 BL21.2
order. BL21.5 BL29.1
Y = Yes BL29.2 BL520
N = No BL820 BL92.1
WH20.7
OIL-SLS-ACCT-UNIT Alpha 15 BL120 BL122
Element: Acct Unit Sales account unit to be credited or BL130 BL20.1
debited for this line. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-SLS-ACCOUNT Numeric 6 BL120 BL122
Element: Account Sales account number to be debited or BL130 BL20.1
credited for this line. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-SLS-SUB-ACCT Numeric 4 BL120 BL122
Element: Sub Acct Sales subaccount number to be debited BL130 BL20.1
or credited for this line. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-SALES-MAJCL Alpha 4 BL120 BL122
Element: Major Class Sales major class code of the line item. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-SALES-MINCL Alpha 4 BL120 BL122
Element: Minor Class Sales minor class code of the line item. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-DSC-AMT Signed 18.2 Occurs 3 Times BL120 BL122
Element: Intl Amt This is the price modifier discount BL130 BL20.1
amount calculated for the line item. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-DSC-ACCT-UNIT Alpha 15 Occurs 3 Times BL120 BL122
Element: Acct Unit These fields store the discount account BL130 BL20.1
units that are to be debited for BL20.3 BL21.2
nonstock line items that are affected by BL21.5 BL29.1
price modifier discounts. These account BL29.2 BL520
units are credited for credit memo line BL820 BL92.1
items. WH20.7
OIL-DSC-ACCOUNT Numeric 6 Occurs 3 Times BL120 BL122
Element: Account These fields store the discount account BL130 BL20.1
numbers that are to be debited for BL20.3 BL21.2
nonstock line items that are affected by BL21.5 BL29.1
price modifier discounts. The account is BL29.2 BL520
credited for credit memo line items. BL820 BL92.1
WH20.7
OIL-DSC-SUB-ACCT Numeric 4 Occurs 3 Times BL120 BL122
Element: Sub Acct These fields store the discount BL130 BL20.1
subaccount numbers that are to be BL20.3 BL21.2
debited for nonstock line items that are BL21.5 BL29.1
affected by price modifier discounts. BL29.2 BL520
The account is credited for credit memo BL820 BL92.1
line items. WH20.7
OIL-DSC-AMT-CURR Derived
Element: Dsc Amt Curr 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 Signed 18.2 BL120 BL122
Element: Intl Amt This is the sum total of the price BL130 BL20.1
modifier discount amounts as calculated BL20.3 BL21.2
for the line item in company base BL21.5 BL29.1
currency. BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-OFF-ACCT-UNIT Alpha 15 BL120 BL122
Element: Acct Unit This cost of goods offset account unit BL130 BL20.1
will be credited for non-stock and BL20.3 BL21.2
special items ordered that have a cost BL21.5 BL29.1
associated with them. This account can BL29.2 BL520
default from the sales class for BL820 BL92.1
non-stock items and will default from WH20.7
the process level for special items. The
account will be debited for return to
stock credit memos.
OIL-OFF-ACCOUNT Numeric 6 BL120 BL122
Element: Account This cost of goods offset account BL130 BL20.1
number will be credited for non-stock BL20.3 BL21.2
and special items that have a cost BL21.5 BL29.1
associated with them. This account can BL29.2 BL520
default from the sales class for BL820 BL92.1
non-stock items and will default from WH20.7
the process level for special items with
associated costs. This account will be
debited for return to stock credit memo
line items.
OIL-OFF-SUB-ACCT Numeric 4 BL120 BL122
Element: Sub Acct This cost of goods offset subaccount BL130 BL20.1
will be credited for non-stock and BL20.3 BL21.2
special items ordered that have a cost BL21.5 BL29.1
associated with them. This account can BL29.2 BL520
default from the sales class for BL820 BL92.1
non-stock items and will default from WH20.7
the process level for special items with
associated costs. The account will be
debited for return to stock credit
memos.
OIL-CGS-ACCT-UNIT Alpha 15 BL120 BL122
Element: Acct Unit The cost of goods sold account unit is BL130 BL20.1
debited for non-stock or special items. BL20.3 BL21.2
Defaults from the process level for BL21.5 BL29.1
special orders and defaults from the BL29.2 BL520
sales class for non-stock items. This BL820 BL92.1
account is credited for return to stock WH20.7
credit memo lines.
OIL-CGS-ACCOUNT Numeric 6 BL120 BL122
Element: Account The cost of goods sold account number BL130 BL20.1
is debited for non-stock or special BL20.3 BL21.2
items. This account defaults from the BL21.5 BL29.1
process level for special orders and BL29.2 BL520
defaults from the sales class for BL820 BL92.1
non-stock items. This account is WH20.7
credited for return to stock credit memo
lines.
OIL-CGS-SUB-ACCT Numeric 4 BL120 BL122
Element: Sub Acct The cost of goods sold subaccount BL130 BL20.1
number is debited for non-stock and BL20.3 BL21.2
special items. This will default from BL21.5 BL29.1
the process level for special orders and BL29.2 BL520
defaults from the sales class for BL820 BL92.1
non-stock items. This account is WH20.7
credited for return to stock credit memo
lines.
OIL-LAST-MISC-SEQ Numeric 3 BL120 BL122
Element: Seq This value indicates the number of the BL130 BL20.1
last add-on charge attached to this BL20.3 BL21.2
line. This value determines the sequence BL21.5 BL29.1
number of the next add-on charge. BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-LAST-COMM-SEQ Numeric 3 BL120 BL122
Element: Seq This is the sequence number of the last BL130 BL20.1
comment line entered for this invoice BL20.3 BL21.2
line. BL21.4 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BLI2.1
WH20.7
OIL-TERRITORY Alpha 4 BL120 BL122
Element: Territory The sales territory to which this line BL130 BL20.1
belongs. The territory is determined BL20.3 BL21.2
based upon the customer and the sales BL21.5 BL29.1
representative assigned to the customer. BL29.2 BL520
Territory can be overridden online when BL820 BL92.1
adding an invoice. WH20.7
OIL-SALESMAN Numeric 4 BL120 BL122
Element: Salesman The primary sales representative BL130 BL20.1
responsible for this order and/or BL20.3 BL21.2
invoice. Defaults from the customer BL21.5 BL29.1
ship-to for this order, or if the BL29.2 BL520
ship-to is not entered, will default BL820 BL92.1
from the customer master. The sales WH20.7
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.
OIL-SALESMAN-2 Numeric 4 BL120 BL122
Element: Salesman The secondary sales representative BL130 BL20.1
responsible for this order and/or BL20.3 BL21.2
invoice. Defaults from the customer BL21.5 BL29.1
ship-to for this order, or if the BL29.2 BL520
ship-to is not entered, will default BL820 BL92.1
from the customer master. WH20.7
OIL-COMM-RATE-1 Percent 7.5 (Percent) BL120 BL122
Element: Chrg Rate Commission rate for sales BL130 BL20.1
representative 1. Defaults from the BL20.3 BL21.2
sales representative record. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-COMM-RATE-2 Percent 7.5 (Percent) BL120 BL122
Element: Chrg Rate Commission rate for sales BL130 BL20.1
representative 2. Defaults from the BL20.3 BL21.2
salesman record. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-COMM-SPLIT Percent 5.3 (Percent) BL120 BL122
Element: Comm Split The portion of the invoice line that BL130 BL20.1
the second sales representative's BL20.3 BL21.2
commission percent is applied to. The BL21.5 BL29.1
first sales representative's commission BL29.2 BL520
percent is applied to the remaining BL820 BL92.1
amount. Defaults from the Customer WH20.7
Master file.
OIL-USER-FLD1 Alpha 2 BL120 BL122
Element: Po User Fld 2 This is the first user-defined field on BL130 BL20.1
the invoice line. These user-defined BL20.3 BL21.2
field values, if entered, and the line BL21.5 BL29.1
is a create PO = Yes, will interface BL29.2 BL520
into Purchase Order and appear on the BL820 BL92.1
purchase order line in the purchase WH20.7
order user-defined fields.
OIL-USER-FLD2 Alpha 30 (Lower Case) BL120 BL122
Element: User Fld2 The second user-defined field on the BL130 BL20.1
invoice line. These user-defined field BL20.3 BL21.2
values, if entered and the line creates BL21.5 BL29.1
a purchase order, will interface into BL29.2 BL520
Purchase Order and appear on the BL820 BL92.1
purchase order line in the purchase WH20.7
order user-defined fields.
OIL-USER-FLD3 Alpha 15 (Lower Case) BL120 BL122
Element: User Fld3 The third user-defined field on the BL130 BL20.1
invoice line. These user-defined field BL20.3 BL21.2
values, if entered and the line creates BL21.5 BL29.1
a purchase order, will interface into BL29.2 BL520
Purchase Order and appear on the BL820 BL92.1
purchase order line in the purchase WH20.7
order user-defined fields.
OIL-LINE-GRS-CURR Signed 18.2 BL120 BL122
Element: Intl Amt This is the gross amount of the line in BL130 BL20.1
original billing currency. Calculated by BL20.3 BL21.2
multiplying quantity by sell price in BL21.5 BL29.1
billing currency. BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-INVL-OBJ-ID Numeric 12
Element: Invl Obj Id
OIL-PROD-TAX-CAT Alpha 15 BL120 BL122
Element: Prod Tax Cat A classification of items for BL130 BL20.1
determining taxes using the VERTEX BL20.3 BL21.2
system in Lawson Order Entry system or BL21.5 BL29.1
the cash receipts programs in the Lawson BL29.2 BL520
Cash Ledger system. BL820 BL92.1
WH20.7
OIL-LINE-NET-CURR Derived
Element: Line Net Curr 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 Derived
Element: Line Ntx Curr Net amount for tax purposes. Allocated
discount from header also subtracted
from gross.
OIL-LINE-GRS-BASE Signed 18.2 BL120 BL122
Element: Intl Amt This is the gross amount of the line in BL130 BL20.1
original company base currency. BL20.3 BL21.2
Calculated by multiplying Quantity by BL21.5 BL29.1
Sell Unit Price. BL29.2 BL520
BL820 BL92.1
WH20.7
OIL-LINE-NET-BASE Derived
Element: Line Net Base 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 Derived
Element: Qty In Stock Order quantity in the stock unit of
measure.
OIL-LINE-COST Derived
Element: Line Cost The total cost of the line item.
OIL-S-ACCT-UNIT Derived
Element: S Acct Unit The sales account unit that the system
posts to.
OIL-S-ACCOUNT Derived
Element: S Account The sales account that the system posts
to.
OIL-S-SUB-ACCT Derived
Element: S Sub Acct The sales subaccount that the system
posts to.
OIL-D1-ACCT-UNIT Derived
Element: D1 Acct Unit The first discount account unit that
the system posts to.
OIL-D1-ACCOUNT Derived
Element: D1 Account The first discount account that the
system posts to.
OIL-D1-SUB-ACCT Derived
Element: D1 Sub Acct The first discount subaccount that the
system posts to.
OIL-D2-ACCT-UNIT Derived
Element: D2 Acct Unit The second discount account unit that
the system posts to.
OIL-D2-ACCOUNT Derived
Element: D2 Account The second discount account that the
system posts to.
OIL-D2-SUB-ACCT Derived
Element: D2 Sub Acct The second discount subaccount that the
system posts to.
OIL-D3-ACCT-UNIT Derived
Element: D3 Acct Unit The third discount account unit that
the system posts to.
OIL-D3-ACCOUNT Derived
Element: D3 Account The third discount account that the
system posts to.
OIL-D3-SUB-ACCT Derived
Element: D3 Sub Acct The third discount subaccount that the
system posts to.
OIL-D1-AMOUNT Derived
Element: D1 Amount The dollar amount for the first
discount.
OIL-D2-AMOUNT Derived
Element: D2 Amount The dollar amount for the second
discount.
OIL-D3-AMOUNT Derived
Element: D3 Amount The dollar amount for the third
discount.
OIL-I-ACCT-UNIT Derived
Element: I Acct Unit The inventory account unit that the
system posts to.
OIL-I-ACCOUNT Derived
Element: I Account The inventory account that the system
posts to.
OIL-I-SUB-ACCT Derived
Element: I Sub Acct The inventory subaccount that the
system posts to.
OIL-C-ACCT-UNIT Derived
Element: C Acct Unit The cost of goods sold account unit
that the system posts to.
OIL-C-ACCOUNT Derived
Element: C Account The cost of goods sold account that the
system posts to.
OIL-C-SUB-ACCT Derived
Element: C Sub Acct The cost of goods sold subaccount that
the system posts to.
OEINVCLINE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OILSET1 COMPANY BL120 BL121
INVC-PREFIX BL122 BL123
INVC-NUMBER BL125 BL130
LINE-NBR BL20.1 BL20.3
BL20.5 BL20.6
BL21.2 BL21.4
BL21.5 BL21.6
BL220 BL232
BL29.1 BL29.2
BL290 BL320
BL520 BL80.1
BL81.1 BL820
BL92.1 BLI2.1
TX101 WH20.7
OILSET2 COMPANY Subset BL120 BL122
INVC-PREFIX Where PRICE-STATUS = "A" BL130 BL20.1
INVC-NUMBER BL20.3 BL21.2
SALES-MAJCL BL21.5 BL29.1
SALES-MINCL BL29.2 BL520
LINE-NBR BL820 BL92.1
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 KeyChange BL120 BL122
INVC-PREFIX BL130 BL20.1
INVC-NUMBER BL20.3 BL21.2
TAX-CODE BL21.5 BL29.1
PROD-TAX-CAT BL29.2 BL520
LINE-NBR BL820 BL92.1
WH20.7
OILSET6 COMPANY BL120 BL122
INVC-PREFIX BL130 BL20.1
LINE-NBR BL20.3 BL21.2
INVC-NUMBER BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OEINVCLINE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Add On Disc GLMASTER Not Required
OIL-COMPANY -> GLM-COMPANY
OEP-DSC-ACCT-UNIT -> GLM-ACCT-UNIT
OEP-DSC-ACCOUNT -> GLM-ACCOUNT
OEP-DSC-SUB-ACCT -> GLM-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
Blrimast BLRIMAST Not Required
Valid When OEI-RECUR-INVOICE != Spaces
OIL-COMPANY -> BRM-COMPANY
OEI-RECUR-INVOICE -> BRM-RECUR-INVOICE
Blrimline BLRIMLINE Not Required
Valid When OEI-RECUR-INVOICE != Spaces
OIL-COMPANY -> BML-COMPANY
OEI-RECUR-INVOICE -> BML-RECUR-INVOICE
BUL-MAST-LINE-NBR -> BML-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
Oemastsrvc BLRIMAST Not Required
Valid When OEI-RECUR-INVOICE != Spaces
OIL-COMPANY -> BRM-COMPANY
OEI-RECUR-INVOICE -> BRM-RECUR-INVOICE
Oemsline BLRIMLINE Not Required
Valid When OEI-RECUR-INVOICE != Spaces
OIL-COMPANY -> BML-COMPANY
OEI-RECUR-INVOICE -> BML-RECUR-INVOICE
BUL-MAST-LINE-NBR -> BML-LINE-NBR
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
OEINVCLINE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
|