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 OE130 OE272 OE294 SA100
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 OE114 OE129 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE310 OE330 OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-INVC-PREFIX Alpha 2 BL120 BL122
Element: Invoice PrefixThis 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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-LINE-NBR Numeric 6 BL120 BL122
Element: Line Number 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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
nonstock, or special item. BL21.5 BL29.1
I = Inventoried item BL29.2 BL520
N = Non-stock BL820 BL92.1
X = Special order OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-ITEM Alpha 32 BL120 BL122
Element: Item Number This field contains the item BL130 BL20.1
identifier. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-ORDER-NBR Numeric 8 BL120 BL122
Element: Order Number 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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-SHIPMENT-NBR Numeric 10 BL120 BL122
Element: Shipment NumbeThis 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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-SPR-UOM Alpha 4 BL120 BL122
Element: Unit of MeasurIndicates 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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-SELL-UOM Alpha 4 BL120 BL122
Element: Unit of MeasurThe selling unit of measure for the BL130 BL20.1
item. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-SEC-UOM Alpha 4 BL120 BL122
Element: Unit of MeasurThis 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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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 OE114 OE129
N = No OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-SEC-UOM-MULT Signed 13.7 BL120 BL122
Unit of Measure This field contains the secondary BL130 BL20.1
Multiplier 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. OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-LOCATION Alpha 5 BL120 BL122
Element: Location Code 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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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. OE114 OE129
O = Manual override of pricing. OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-NO-CHARGE-FL Alpha 1 BL120 BL122
Element: No Charge FlagNo 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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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 OE114 OE129
dispersed among the lines of the invoice OE30.1 OE30.2
as the system calculates tax at the line OE30.3 OE30.4
level. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-TAX-EXEMPT-CD Alpha 1 BL120 BL122
Element: Tax Exempt CodIndicates 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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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. OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
nonstock item, and the pricing of this BL29.2 BL520
item includes discounting, the discount BL820 BL92.1
code defaults from the pricing modifier OE114 OE129
(price list, contract, or promotion) and OE30.1 OE30.2
cannot be changed. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-ORD-DISC-FL Alpha 1 BL120 BL122
Element: Order DiscountThis 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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-CONTRACT-NBR Alpha 14 BL120 BL122
Element: Contract NumbeIf 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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
Activities are the processes or OE30.1 OE30.2
procedures that produce work. Cost OE30.3 OE30.4
objects (products, services, customers, OE30.5 OE30.6
and so on) are the reasons for OE30.7 OE30.9
performing the activity. Activities and OE530 OE830
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-ACCT-CATEGORY Alpha 5 BL120 BL122
Element: Account CategoIn 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 OE114 OE129
costs, revenues, or a combination of OE30.1 OE30.2
both used for reporting and inquiries OE30.3 OE30.4
for activities in the Activity OE30.5 OE30.6
Management system. All transactions are OE30.7 OE30.9
posted to an account category within an OE530 OE830
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.
OIL-ATN-OBJ-ID Numeric 12 BL120 BL122
Object Represents Activity Management system BL130 BL20.1
Identification 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, OE114 OE129
and so on) are the reasons for OE30.1 OE30.2
performing the activity. Activities and OE30.3 OE30.4
cost object activities are used OE30.5 OE30.6
synonymously in the Activity Management OE30.7 OE30.9
system. Direct costs are posted to OE530 OE830
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
OE114 OE129
Activities are the processes or OE30.1 OE30.2
procedures that produce work. Cost OE30.3 OE30.4
objects (products, services, customers, OE30.5 OE30.6
and so on) are the reasons for OE30.7 OE30.9
performing the activity. Activities and OE530 OE830
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-ACCT-CATEG-C Alpha 5 BL120 BL122
Element: Account CategoIn 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 OE114 OE129
costs, revenues, or a combination of OE30.1 OE30.2
both used for reporting and inquiries OE30.3 OE30.4
for activities in the Activity OE30.5 OE30.6
Management system. All transactions are OE30.7 OE30.9
posted to an account category within an OE530 OE830
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.
OIL-ATN-OBJ-ID-C Numeric 12 BL120 BL122
Object The system defined object id BL130 BL20.1
Identification representing the Activity Management BL20.3 BL21.2
commitment for Cost (COGS). BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-SLS-ACCT-UNIT Alpha 15 BL120 BL122
Element: Accounting UniSales 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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-SLS-SUB-ACCT Numeric 4 BL120 BL122
Element: Subaccount 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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-DSC-ACCT-UNIT Alpha 15 Occurs 3 Times BL120 BL122
Element: Accounting UniThese 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. OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-DSC-SUB-ACCT Numeric 4 Occurs 3 Times BL120 BL122
Element: Subaccount 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. OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-DSC-AMT-CURR Derived
Currency Discount This is the sum total of the price
Amount 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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-OFF-ACCT-UNIT Alpha 15 BL120 BL122
Element: Accounting UniThis cost of goods offset account unit BL130 BL20.1
will be credited for nonstock 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
nonstock items and will default from the OE114 OE129
process level for special items. The OE30.1 OE30.2
account will be debited for return to OE30.3 OE30.4
stock credit memos. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-OFF-ACCOUNT Numeric 6 BL120 BL122
Element: Account This cost of goods offset account BL130 BL20.1
number will be credited for nonstock and BL20.3 BL21.2
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
nonstock items and will default from the OE114 OE129
process level for special items with OE30.1 OE30.2
associated costs. This account will be OE30.3 OE30.4
debited for return to stock credit memo OE30.5 OE30.6
line items. OE30.7 OE30.9
OE530 OE830
OIL-OFF-SUB-ACCT Numeric 4 BL120 BL122
Element: Subaccount This cost of goods offset subaccount BL130 BL20.1
will be credited for nonstock 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
nonstock items and will default from the OE114 OE129
process level for special items with OE30.1 OE30.2
associated costs. The account will be OE30.3 OE30.4
debited for return to stock credit OE30.5 OE30.6
memos. OE30.7 OE30.9
OE530 OE830
OIL-CGS-ACCT-UNIT Alpha 15 BL120 BL122
Element: Accounting UniThe cost of goods sold account unit is BL130 BL20.1
debited for nonstock 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 nonstock items. This BL820 BL92.1
account is credited for return to stock OE114 OE129
credit memo lines. OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-CGS-ACCOUNT Numeric 6 BL120 BL122
Element: Account The cost of goods sold account number BL130 BL20.1
is debited for nonstock 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
nonstock items. This account is credited OE114 OE129
for return to stock credit memo lines. OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-CGS-SUB-ACCT Numeric 4 BL120 BL122
Element: Subaccount The cost of goods sold subaccount BL130 BL20.1
number is debited for nonstock 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
nonstock items. This account is credited OE114 OE129
for return to stock credit memo lines. OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-LAST-MISC-SEQ Numeric 3 BL120 BL122
Element: Sequence NumbeThis 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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-LAST-COMM-SEQ Numeric 3 BL120 BL122
Element: Sequence NumbeThis 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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-TERRITORY Alpha 4 BL120 BL122
Element: Sales TerritorThe 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. OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-SALESMAN Numeric 4 BL120 BL122
Element: Salesman NumbeThe 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 OE114 OE129
representative can be overridden when OE30.1 OE30.2
entering an order and/or invoice. OE30.3 OE30.4
OE30.5 OE30.6
This is the sales representative to OE30.7 OE30.9
which the invoice or order belongs. This OE530 OE830
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 NumbeThe 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. OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-COMM-SPLIT Percent 5.3 (Percent) BL120 BL122
Commission Split The portion of the invoice line that BL130 BL20.1
Percentage 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 OE114 OE129
Master file. OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-USER-FLD1 Alpha 2 BL120 BL122
Purchase Order User This is the first user-defined field on BL130 BL20.1
Field 2 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 the Purchase Order system and BL820 BL92.1
appear on the purchase order line in the OE114 OE129
purchase order user-defined fields. OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-USER-FLD2 Alpha 30 (Lower Case) BL120 BL122
Element: User Defined FThe 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
the Purchase Order system and appear on BL820 BL92.1
the purchase order line in the purchase OE114 OE129
order user-defined fields. OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-USER-FLD3 Alpha 15 (Lower Case) BL120 BL122
Element: User Defined FThe 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
the Purchase Order system and appear on BL820 BL92.1
the purchase order line in the purchase OE114 OE129
order user-defined fields. OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIL-INVL-OBJ-ID Numeric 12
Element: Invl Obj Id
OIL-PROD-TAX-CAT Alpha 15 BL120 BL122
Element: Product Tax CaA 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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE130 OE272
...
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OILSET6 COMPANY This index was created as a solution to BL120 BL122
INVC-PREFIX the Find Next/Prev Flag error. It is BL130 BL20.1
LINE-NBR only used where a modify must be done BL20.3 BL21.2
INVC-NUMBER within a 850-FIND-NLT or 850-FIND-BEGRNG BL21.5 BL29.1
loop. BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
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
|