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 BL122 BL123 BL220 BL232 BL290
BL80.1 BL81.1 BL96E OE130 OE272 OE294
SA100
UPDATED BY
BL120 BL130 BL20.1 BL20.3 BL21.2 BL21.4
BL21.5 BL21.6 BL22.1 BL29.1 BL29.2 BL320
BL520 BL720 BL820 BL92.1 BL940 BL96C
OE114 OE129 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE310 OE330
OE830 OE950 WH966
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OIL-COMPANY Numeric 4 BL120 BL130
Company The company number represents an BL20.1 BL20.3
established company and is entered on BL21.2 BL21.5
all function codes. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-INVC-PREFIX Alpha 2 BL120 BL130
Invoice Prefix This field contains the invoice prefix BL20.1 BL20.3
that is assigned from either the company BL21.2 BL21.5
or process level, depending on the BL29.1 BL29.2
invoice-level option chosen. BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-INVC-NUMBER Numeric 8 BL120 BL130
Invc Number This field contains the invoice number BL20.1 BL20.3
assigned by the system. Invoice numbers BL21.2 BL21.5
are assigned at the company or process BL29.1 BL29.2
level, depending on an invoice-level BL520 BL820
option on the company file. BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-LINE-NBR Numeric 6 BL120 BL130
Line Number The system number of the line on the BL20.1 BL20.3
invoice. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-LINE-TYPE Alpha 1 BL120 BL130
Line Type The line type indicates whether the BL20.1 BL20.3
item on the line is an inventoried item, BL21.2 BL21.5
nonstock, or special item. BL29.1 BL29.2
I = Inventoried item BL520 BL820
N = Non-stock BL92.1 BL940
X = Special order BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-ITEM Alpha 32 BL120 BL130
Item Number This field contains the item BL20.1 BL20.3
identifier. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-ITEM-16 Derived
Item 16 This field contains the 16-character
item description. Derived by the system.
OIL-DESCRIPTION Alpha 30 (Lower Case) BL120 BL130
Description The description of the item. BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-ORDER-NBR Numeric 8 BL120 BL130
Order Number If the invoice this invoice line was BL20.1 BL20.3
created on is based on an order BL21.2 BL21.5
shipment, this field will store the BL29.1 BL29.2
order number related to the line. BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-SHIPMENT-NBR Numeric 10 BL120 BL130
Shipment Number This field contains the shipment BL20.1 BL20.3
number. One order can have several BL21.2 BL21.5
shipment numbers if the items of the BL29.1 BL29.2
order were not shipped at the same time. BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 WH966
OIL-QUANTITY Signed 13.4 BL120 BL130
Quantity The quantity of the item that is being BL20.1 BL20.3
billed on this line. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-INVC-CW-QTY Signed 13.4 BL120 BL130
Invc Cw Qty Invoice catch weight quantity. This BL20.1 BL20.3
field is valid only for catch weight BL21.2 BL21.5
items. This is used in extended price BL29.1 BL29.2
calculation, but quantity is used for BL520 BL820
pricing. BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-SPR-UOM Alpha 4 BL120 BL130
Selling Price Unit Indicates the selling price unit of BL20.1 BL20.3
of Measure measure with which this line has been BL21.2 BL21.5
priced. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-SELL-UOM Alpha 4 BL120 BL130
Sell Unit of Measure The selling unit of measure for the BL20.1 BL20.3
item. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-SEC-UOM Alpha 4 BL120 BL130
Secondary Unit of This field contains the secondary BL20.1 BL20.3
Measure quantity unit of measure. Only used for BL21.2 BL21.5
catch weight items. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-MULT-SPR-FL Alpha 1 BL120 BL130
Mult Spr Fl Multiple sell price flag. The flag is BL20.1 BL20.3
set if the item has multiple pricing set BL21.2 BL21.5
in the Item Master file. If this flag is BL29.1 BL29.2
set, price break is maintained in the BL520 BL820
Order Line Pricing UOM's file. BL92.1 BL940
Y = Yes BL96C OE114
N = No OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-SPR-TO-STOCK Signed 13.7 BL120 BL130
Spr to Stock Conversion factor from pricing unit of BL20.1 BL20.3
measure back to stock unit of measure. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-SELL-TO-STOCK Signed 13.7 BL120 BL130
Sell to Stock Conversion factor from selling unit of BL20.1 BL20.3
measure back to stock unit of measure. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-SEC-UOM-MULT Signed 13.7 BL120 BL130
Secondary UOM This field contains the secondary BL20.1 BL20.3
Multiplier quantity unit of measure multiplier. It BL21.2 BL21.5
is used to convert the stock on hand BL29.1 BL29.2
quantity to the secondary quantity or BL520 BL820
visa versa. Used with catch weight items BL92.1 BL940
only. BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-LOCATION Alpha 5 BL120 BL130
Location Code This field contains a valid stock BL20.1 BL20.3
location within the company inventory. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-PRICE-STATUS Alpha 1 BL120 BL130
Price Status This value indicates how the invoice BL20.1 BL20.3
line was priced; for example, was the BL21.2 BL21.5
price overridden or amalgamated pricing BL29.1 BL29.2
used. BL520 BL820
A = Amalgated (group) pricing. BL92.1 BL940
C = System calculated pricing. BL96C OE114
O = Manual override of pricing. OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-ENTERED-PRICE Signed 13.5 BL120 BL130
Entered Price This is the price of the line item. BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-UNIT-PRICE Signed 13.5 BL120 BL130
Unit Price The unit price of the line item. BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-SELL-PRC-CURR Signed 15.7 BL120 BL130
Sell Prc Currency This is the selling price in the BL20.1 BL20.3
original billing unit of measure. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-SELL-UNIT-PRC Signed 15.7 BL120 BL130
Sell Unit Price The price in selling unit of measure. BL20.1 BL20.3
Used internally; never seen on the form. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-UNIT-COST Signed 13.5 BL120 BL130
Unit Cost This is the unit cost for the invoice BL20.1 BL20.3
line. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-CURRENT-COST Signed 13.5 BL120 BL130
Current Cost This is the cost used for valuation BL20.1 BL20.3
when the stock on hand goes negative for BL21.2 BL21.5
an average costing company. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-NO-CHARGE-FL Alpha 1 BL120 BL130
No Charge Flag No Charge Flag indicating if the line BL20.1 BL20.3
is intentionally supposed to be no BL21.2 BL21.5
charge. BL29.1 BL29.2
N = No, normal pricing. BL520 BL820
Y = Yes, this is a no charge line. BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-ENTERED-DISC Signed 15.2 BL120 BL130
Entered Disc The add-on discount that can be entered BL20.1 BL20.3
when adding an invoice line. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-ADD-ON-DISC Signed 15.2 BL120 BL130
Add On Discount This is the add-on discount in the BL20.1 BL20.3
company base currency. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-ALLOC-DISC Signed 15.2 BL120 BL130
Allocation Discount The portion of the order level discount BL20.1 BL20.3
or invoice add-on discount allocated to BL21.2 BL21.5
this line on the invoice. Tax is BL29.1 BL29.2
calculated after discounts are taken out BL520 BL820
of the invoice amount and the BL92.1 BL940
invoice/order level discounts must be BL96C OE114
dispersed among the lines of the invoice OE129 OE30.1
as the system calculates tax at the line OE30.2 OE30.3
level. OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-TAX-EXEMPT-CD Alpha 1 BL120 BL130
Tax Exempt Code Indicates whether the line item is tax BL20.1 BL20.3
exempt or not. BL21.2 BL21.5
E = Exempt BL29.1 BL29.2
T = Taxable BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-TAX-CODE Alpha 10 BL120 BL130
Tax Code A user-defined code representing the BL20.1 BL20.3
tax authorities this ship-to pays sales BL21.2 BL21.5
tax to. Must be a valid tax code record. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-ENT-TAXABLE Signed 15.2 BL120 BL130
Entered Taxable The taxable amount of the line item if BL20.1 BL20.3
it is not tax exempt. This is a BL21.2 BL21.5
calculated amount and is stored in BL29.1 BL29.2
company base currency. The taxable BL520 BL820
amount is the net amount of the line BL92.1 BL940
minus the allocated discount amount. BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-TAXABLE-BSE Signed 15.2 BL120 BL130
Taxable Bse Taxable amount of the line in company BL20.1 BL20.3
base currency. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-TAX-AMT-CURR Signed 15.2 BL120 BL130
Tax Amount Currency Taxable amount of the line item in BL20.1 BL20.3
original billing currency. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-TAX-AMT-BSE Signed 15.2 BL120 BL130
Tax Amount Base Tax amount in company base currency. BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-REASON-CODE Alpha 4 BL120 BL130
Reason Code Reason code is used to indicate the BL20.1 BL20.3
reason for adding a credit memo to the BL21.2 BL21.5
system. If entered, it must be valid in BL29.1 BL29.2
the Reason Code file. BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-DISC-CODE Alpha 10 BL120 BL130
Disc Code This field holds the discount code used BL20.1 BL20.3
to assess a discount amount to this line BL21.2 BL21.5
item. If the item is an inventory or BL29.1 BL29.2
nonstock item, and the pricing of this BL520 BL820
item includes discounting, the discount BL92.1 BL940
code defaults from the pricing modifier BL96C OE114
(price list, contract, or promotion) and OE129 OE30.1
cannot be changed. OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-ORD-DISC-FL Alpha 1 BL120 BL130
Order Discount Flag This flag determines whether the order BL20.1 BL20.3
line is eligible for an allocated BL21.2 BL21.5
discount. BL29.1 BL29.2
Y = Yes BL520 BL820
N = No BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-CONTRACT-NBR Alpha 14 BL120 BL130
Contract Number If a contract appears on this line BL20.1 BL20.3
field, the line was priced using this BL21.2 BL21.5
contract number. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-PROMOTION Alpha 10 BL120 BL130
Promotion If a promotion is found in this field, BL20.1 BL20.3
this line item was priced using a BL21.2 BL21.5
promotion price modifier. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-ACTIVITY Alpha 15 BL120 BL130
Activity In this file the Activity field is used BL20.1 BL20.3
for the revenue (sales) side of the BL21.2 BL21.5
posting whereas the Activity-C field is BL29.1 BL29.2
used for the Cost (COGS) side of the BL520 BL820
posting. BL92.1 BL940
BL96C OE114
Activities are the processes or OE129 OE30.1
procedures that produce work. Cost OE30.2 OE30.3
objects (products, services, customers, OE30.4 OE30.5
and so on) are the reasons for OE30.6 OE30.7
performing the activity. Activities and OE30.9 OE830
cost object activities are used OE950
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 BL130
Account Category In this file the Acct-Category field is BL20.1 BL20.3
used for the revenue (sales) postings BL21.2 BL21.5
whereas the Acct-Categ-C field is used BL29.1 BL29.2
for Cost (COGS) postings. BL520 BL820
BL92.1 BL940
Account categories are groupings of BL96C OE114
costs, revenues, or a combination of OE129 OE30.1
both used for reporting and inquiries OE30.2 OE30.3
for activities in the Activity OE30.4 OE30.5
Management system. All transactions are OE30.6 OE30.7
posted to an account category within an OE30.9 OE830
activity. You can assign a specific OE950
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 BL130
AC System Object ID Represents Activity Management system BL20.1 BL20.3
(Sales) ID for the revenue (sales) Activity. BL21.2 BL21.5
BL29.1 BL29.2
Activities are the processes or BL520 BL820
procedures that produce work. Cost BL92.1 BL940
objects (products, services, customers, BL96C OE114
and so on) are the reasons for OE129 OE30.1
performing the activity. Activities and OE30.2 OE30.3
cost object activities are used OE30.4 OE30.5
synonymously in the Activity Management OE30.6 OE30.7
system. Direct costs are posted to OE30.9 OE830
activities, and indirect costs are OE950
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-FINAL-INVC-FL Alpha 1 BL120 BL130
Final Invc Fl This flag indicates if the invoice this BL20.1 BL20.3
line is on is the last invoice for this BL21.2 BL21.5
order. BL29.1 BL29.2
Y = Yes BL520 BL820
N = No BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-SLS-ACCT-UNIT Alpha 15 BL120 BL130
Sales Accounting Sales account unit to be credited or BL20.1 BL20.3
Unit debited for this line. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-SLS-ACCOUNT Numeric 6 BL120 BL130
Sales Account Sales account number to be debited or BL20.1 BL20.3
credited for this line. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-SLS-SUB-ACCT Numeric 4 BL120 BL130
Sales Subaccount Sales subaccount number to be debited BL20.1 BL20.3
or credited for this line. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-SALES-MAJCL Alpha 4 BL120 BL130
Sales Major Class Sales major class code of the line item. BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-SALES-MINCL Alpha 4 BL120 BL130
Sales Minor Class Sales minor class code of the line item. BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-DSC-AMT Signed 15.2 Occurs 3 Times BL120 BL130
Discount Amount This is the price modifier discount BL20.1 BL20.3
amount calculated for the line item. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-DSC-ACCT-UNIT Alpha 15 Occurs 3 Times BL120 BL130
Discount Accounting These fields store the discount account BL20.1 BL20.3
Unit units that are to be debited for BL21.2 BL21.5
nonstock line items that are affected by BL29.1 BL29.2
price modifier discounts. These account BL520 BL820
units are credited for credit memo line BL92.1 BL940
items. BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-DSC-ACCOUNT Numeric 6 Occurs 3 Times BL120 BL130
Discount Account These fields store the discount account BL20.1 BL20.3
numbers that are to be debited for BL21.2 BL21.5
nonstock line items that are affected by BL29.1 BL29.2
price modifier discounts. The account is BL520 BL820
credited for credit memo line items. BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-DSC-SUB-ACCT Numeric 4 Occurs 3 Times BL120 BL130
Discount Subaccount These fields store the discount BL20.1 BL20.3
Number subaccount numbers that are to be BL21.2 BL21.5
debited for nonstock line items that are BL29.1 BL29.2
affected by price modifier discounts. BL520 BL820
The account is credited for credit memo BL92.1 BL940
line items. BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
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 15.2 BL120 BL130
Base Discount Amount This is the sum total of the price BL20.1 BL20.3
modifier discount amounts as calculated BL21.2 BL21.5
for the line item in company base BL29.1 BL29.2
currency. BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-OFF-ACCT-UNIT Alpha 15 BL120 BL130
Offset Accounting This cost of goods offset account unit BL20.1 BL20.3
Unit will be credited for nonstock and BL21.2 BL21.5
special items ordered that have a cost BL29.1 BL29.2
associated with them. This account can BL520 BL820
default from the sales class for BL92.1 BL940
nonstock items and will default from the BL96C OE114
process level for special items. The OE129 OE30.1
account will be debited for return to OE30.2 OE30.3
stock credit memos. OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-OFF-ACCOUNT Numeric 6 BL120 BL130
Offset Account This cost of goods offset account BL20.1 BL20.3
number will be credited for nonstock and BL21.2 BL21.5
special items that have a cost BL29.1 BL29.2
associated with them. This account can BL520 BL820
default from the sales class for BL92.1 BL940
nonstock items and will default from the BL96C OE114
process level for special items with OE129 OE30.1
associated costs. This account will be OE30.2 OE30.3
debited for return to stock credit memo OE30.4 OE30.5
line items. OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-OFF-SUB-ACCT Numeric 4 BL120 BL130
Offset Subaccount This cost of goods offset subaccount BL20.1 BL20.3
will be credited for nonstock and BL21.2 BL21.5
special items ordered that have a cost BL29.1 BL29.2
associated with them. This account can BL520 BL820
default from the sales class for BL92.1 BL940
nonstock items and will default from the BL96C OE114
process level for special items with OE129 OE30.1
associated costs. The account will be OE30.2 OE30.3
debited for return to stock credit OE30.4 OE30.5
memos. OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-CGS-ACCT-UNIT Alpha 15 BL120 BL130
Cost Of Goods Sold The cost of goods sold account unit is BL20.1 BL20.3
Acct Unit debited for nonstock or special items. BL21.2 BL21.5
Defaults from the process level for BL29.1 BL29.2
special orders and defaults from the BL520 BL820
sales class for nonstock items. This BL92.1 BL940
account is credited for return to stock BL96C OE114
credit memo lines. OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-CGS-ACCOUNT Numeric 6 BL120 BL130
Cost Of Goods Sold The cost of goods sold account number BL20.1 BL20.3
Account is debited for nonstock or special BL21.2 BL21.5
items. This account defaults from the BL29.1 BL29.2
process level for special orders and BL520 BL820
defaults from the sales class for BL92.1 BL940
nonstock items. This account is credited BL96C OE114
for return to stock credit memo lines. OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-CGS-SUB-ACCT Numeric 4 BL120 BL130
Cost Of Goods Sold The cost of goods sold subaccount BL20.1 BL20.3
Subaccount number is debited for nonstock and BL21.2 BL21.5
special items. This will default from BL29.1 BL29.2
the process level for special orders and BL520 BL820
defaults from the sales class for BL92.1 BL940
nonstock items. This account is credited BL96C OE114
for return to stock credit memo lines. OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-LAST-MISC-SEQ Numeric 3 BL120 BL130
Last Misc Code This value indicates the number of the BL20.1 BL20.3
Sequence last add-on charge attached to this BL21.2 BL21.5
line. This value determines the sequence BL29.1 BL29.2
number of the next add-on charge. BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-LAST-COMM-SEQ Numeric 3 BL120 BL130
Last Comment This is the sequence number of the last BL20.1 BL20.3
Sequence Number comment line entered for this invoice BL21.2 BL21.4
line. BL21.5 BL21.6
BL22.1 BL29.1
BL29.2 BL520
BL820 BL92.1
BL940 BL96C
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OIL-TERRITORY Alpha 4 BL120 BL130
Sales Territory The sales territory to which this line BL20.1 BL20.3
belongs. The territory is determined BL21.2 BL21.5
based upon the customer and the sales BL29.1 BL29.2
representative assigned to the customer. BL520 BL820
Territory can be overridden online when BL92.1 BL940
adding an invoice. BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-SALESMAN Numeric 4 BL120 BL130
Salesman Number The primary sales representative BL20.1 BL20.3
responsible for this order and/or BL21.2 BL21.5
invoice. Defaults from the customer BL29.1 BL29.2
ship-to for this order, or if the BL520 BL820
ship-to is not entered, will default BL92.1 BL940
from the customer master. The sales BL96C OE114
representative can be overridden when OE129 OE30.1
entering an order and/or invoice. OE30.2 OE30.3
OE30.4 OE30.5
This is the sales representative to OE30.6 OE30.7
which the invoice or order belongs. This OE30.9 OE830
will default from the customer master or OE950
can be overridden when placing the order
or entering the invoice.
OIL-SALESMAN-2 Numeric 4 BL120 BL130
Salesman Number 2 The secondary sales representative BL20.1 BL20.3
responsible for this order and/or BL21.2 BL21.5
invoice. Defaults from the customer BL29.1 BL29.2
ship-to for this order, or if the BL520 BL820
ship-to is not entered, will default BL92.1 BL940
from the customer master. BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-COMM-RATE-1 Percent 7.5 (Percent) BL120 BL130
Commission Rate for Commission rate for sales BL20.1 BL20.3
Slsmn 1 representative 1. Defaults from the BL21.2 BL21.5
sales representative record. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-COMM-RATE-2 Percent 7.5 (Percent) BL120 BL130
Commission Rate for Commission rate for sales BL20.1 BL20.3
Slsmn 2 representative 2. Defaults from the BL21.2 BL21.5
salesman record. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-COMM-SPLIT Percent 5.3 (Percent) BL120 BL130
Commission Split The portion of the invoice line that BL20.1 BL20.3
Percentage the second sales representative's BL21.2 BL21.5
commission percent is applied to. The BL29.1 BL29.2
first sales representative's commission BL520 BL820
percent is applied to the remaining BL92.1 BL940
amount. Defaults from the Customer BL96C OE114
Master file. OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-USER-FLD1 Alpha 2 BL120 BL130
User Defined Field 1 This is the first user-defined field on BL20.1 BL20.3
the invoice line. These user-defined BL21.2 BL21.5
field values, if entered, and the line BL29.1 BL29.2
is a create PO = Yes, will interface BL520 BL820
into the Purchase Order system and BL92.1 BL940
appear on the purchase order line in the BL96C OE114
purchase order user-defined fields. OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-USER-FLD2 Alpha 30 (Lower Case) BL120 BL130
User Defined Field 2 The second user-defined field on the BL20.1 BL20.3
invoice line. These user-defined field BL21.2 BL21.5
values, if entered and the line creates BL29.1 BL29.2
a purchase order, will interface into BL520 BL820
the Purchase Order system and appear on BL92.1 BL940
the purchase order line in the purchase BL96C OE114
order user-defined fields. OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-USER-FLD3 Alpha 15 (Lower Case) BL120 BL130
User Defined Field 3 The third user-defined field on the BL20.1 BL20.3
invoice line. These user-defined field BL21.2 BL21.5
values, if entered and the line creates BL29.1 BL29.2
a purchase order, will interface into BL520 BL820
the Purchase Order system and appear on BL92.1 BL940
the purchase order line in the purchase BL96C OE114
order user-defined fields. OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-LINE-GRS-CURR Signed 15.2 BL120 BL130
Line Grs Curr This is the gross amount of the line in BL20.1 BL20.3
original billing currency. Calculated by BL21.2 BL21.5
multiplying quantity by sell price in BL29.1 BL29.2
billing currency. BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-LINE-NET-CURR Derived
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
Line Ntx Curr Net amount for tax purposes. Allocated
discount from header also subtracted
from gross.
OIL-LINE-GRS-BASE Signed 15.2 BL120 BL130
Line Grs Base This is the gross amount of the line in BL20.1 BL20.3
original company base currency. BL21.2 BL21.5
Calculated by multiplying Quantity by BL29.1 BL29.2
Sell Unit Price. BL520 BL820
BL92.1 BL940
BL96C OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIL-LINE-NET-BASE Derived
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
Qty-In Stock Order quantity in the stock unit of
measure.
OIL-LINE-COST Derived
Line Cost The total cost of the line item.
OIL-S-ACCT-UNIT Derived
S Acct Unit The sales account unit that the system
posts to.
OIL-S-ACCOUNT Derived
S Account The sales account that the system posts
to.
OIL-S-SUB-ACCT Derived
S Sub Acct The sales subaccount that the system
posts to.
OIL-D1-ACCT-UNIT Derived
D1 Acct Unit The first discount account unit that
the system posts to.
OIL-D1-ACCOUNT Derived
D1 Account The first discount account that the
system posts to.
OIL-D1-SUB-ACCT Derived
D1 Sub Acct The first discount subaccount that the
system posts to.
OIL-D2-ACCT-UNIT Derived
D2 Acct Unit The second discount account unit that
the system posts to.
OIL-D2-ACCOUNT Derived
D2 Account The second discount account that the
system posts to.
OIL-D2-SUB-ACCT Derived
D2 Sub Acct The second discount subaccount that the
system posts to.
OIL-D3-ACCT-UNIT Derived
D3 Acct Unit The third discount account unit that
the system posts to.
OIL-D3-ACCOUNT Derived
D3 Account The third discount account that the
system posts to.
OIL-D3-SUB-ACCT Derived
D3 Sub Acct The third discount subaccount that the
system posts to.
OIL-D1-AMOUNT Derived
D1-Amount The dollar amount for the first
discount.
OIL-D2-AMOUNT Derived
D2-Amount The dollar amount for the second
discount.
OIL-D3-AMOUNT Derived
D3-Amount The dollar amount for the third
discount.
OIL-I-ACCT-UNIT Derived
I Acct Unit The inventory account unit that the
system posts to.
OIL-I-ACCOUNT Derived
I Account The inventory account that the system
posts to.
OIL-I-SUB-ACCT Derived
I Sub Acct The inventory subaccount that the
system posts to.
OIL-C-ACCT-UNIT Derived
C Acct Unit The cost of goods sold account unit
that the system posts to.
OIL-C-ACCOUNT Derived
C Account The cost of goods sold account that the
system posts to.
OIL-C-SUB-ACCT Derived
C Sub Acct The cost of goods sold subaccount that
the system posts to.
OIL-ACTIVITY-C Alpha 15 BL120 BL130
Activity for Cst of In this file the Activity-C field is BL20.1 BL20.3
Goods Sold used for the Cost (COGS) side of the BL21.2 BL21.5
posting whereas the Activity field is BL29.1 BL29.2
used for the revenue (sales) side of the BL520 BL820
posting. BL92.1 BL940
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 OE830 OE950
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 BL130
Acct Categ (Cst of In this file the Acct-Categ-C field is BL20.1 BL20.3
Goods Sold) used for Cost (COGS) postings whereas BL21.2 BL21.5
the Acct-Category field is used for BL29.1 BL29.2
revenue (sales) postings. BL520 BL820
BL92.1 BL940
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 OE830 OE950
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 BL130
AC System Object ID The system defined object id BL20.1 BL20.3
(Cost) representing the Activity Management BL21.2 BL21.5
commitment for Cost (COGS). BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OIL-PROD-TAX-CAT Alpha 15 BL120 BL130
Product Tax Category A classification of items for BL20.1 BL20.3
determining taxes using the VERTEX BL21.2 BL21.5
system in Lawson Order Entry system or BL29.1 BL29.2
the cash receipts programs in the Lawson BL520 BL720
Cash Ledger system. BL820 BL92.1
BL940 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEINVCLINE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OILSET1 COMPANY BL120 BL121
INVC-PREFIX BL122 BL123
INVC-NUMBER BL130 BL20.1
LINE-NBR BL20.3 BL21.2
BL21.4 BL21.5
BL21.6 BL22.1
BL220 BL232
BL29.1 BL29.2
BL290 BL320
BL520 BL720
BL80.1 BL81.1
BL820 BL92.1
BL940 BL96C
BL96E OE114
OE129 OE130
...
OILSET2 COMPANY Subset BL120 BL130
INVC-PREFIX Where PRICE-STATUS = "A" BL20.1 BL20.3
INVC-NUMBER BL21.2 BL21.5
SALES-MAJCL BL29.1 BL29.2
SALES-MINCL BL520 BL820
LINE-NBR BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
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
BL940 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
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
Blricline BLRICLINE Not Required
Valid When OIL-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 OIL-RECUR-INVOICE != Spaces
OIL-COMPANY -> BRM-COMPANY
OEI-RECUR-INVOICE -> BRM-RECUR-INVOICE
Blrimline BLRIMLINE Not Required
Valid When OIL-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 OIL-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
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 OIL-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 OIL-RECUR-INVOICE != Spaces
OIL-COMPANY -> BRM-COMPANY
OEI-RECUR-INVOICE -> BRM-RECUR-INVOICE
Oemsline BLRIMLINE Not Required
Valid When OIL-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 OIL-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 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 OIL-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
Oedist OEDIST
Valid When OIL-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
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
|