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