|
|
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.
UPDATED BY
BLI2.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OIL-COMPANY Numeric 4
Element: Company The company number represents an
established company and is entered on
all function codes.
OIL-INVC-PREFIX Alpha 2
Element: Invoice PrefixThis 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
Element: 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
Element: Line Number The system number of the line on the
invoice.
OIL-LINE-TYPE Alpha 1
Element: 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
Element: Item Number This field contains the item
identifier.
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)
Element: Description The description of the item.
OIL-ORDER-NBR Numeric 8
Element: 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
Element: Shipment NumbeThis 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
Element: Quantity The quantity of the item that is being
billed on this line.
OIL-INVC-CW-QTY Signed 13.4
Element: Quantity 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
Element: Unit of MeasurIndicates the selling price unit of
measure with which this line has been
priced.
OIL-SELL-UOM Alpha 4
Element: Unit of MeasurThe selling unit of measure for the
item.
OIL-SEC-UOM Alpha 4
Element: Unit of MeasurThis field contains the secondary
quantity unit of measure. Only used for
catch weight items.
OIL-MULT-SPR-FL Alpha 1
Element: All Flag 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
Element: Sell To Stock Conversion factor from pricing unit of
measure back to stock unit of measure.
OIL-SELL-TO-STOCK Signed 13.7
Element: Sell To Stock Conversion factor from selling unit of
measure back to stock unit of measure.
OIL-SEC-UOM-MULT Signed 13.7
Unit of Measure 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
Element: Location Code This field contains a valid stock
location within the company inventory.
OIL-PRICE-STATUS Alpha 1
Element: 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
Element: Base Price This is the price of the line item.
OIL-UNIT-PRICE Signed 13.5
Element: Base Price The unit price of the line item.
OIL-SELL-PRC-CURR Signed 15.7
Element: Sell Unit Prc This is the selling price in the
original billing unit of measure.
OIL-SELL-UNIT-PRC Signed 15.7
Element: Sell Unit Prc The price in selling unit of measure.
Used internally; never seen on the form.
OIL-UNIT-COST Signed 13.5
Element: Base Cost This is the unit cost for the invoice
line.
OIL-CURRENT-COST Signed 13.5
Element: Base 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
Element: No Charge FlagNo 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
Element: Actual Disc The add-on discount that can be entered
when adding an invoice line.
OIL-ADD-ON-DISC Signed 15.2
Element: Actual Disc This is the add-on discount in the
company base currency.
OIL-ALLOC-DISC Signed 15.2
Element: Actual Disc 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
Element: Tax Exempt CodIndicates whether the line item is tax
exempt or not.
E = Exempt
T = Taxable
OIL-TAX-CODE Alpha 10
Element: 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
Element: Item Tax 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
Element: Item Tax Taxable amount of the line in company
base currency.
OIL-TAX-AMT-CURR Signed 15.2
Element: Adj Amt Taxable amount of the line item in
original billing currency.
OIL-TAX-AMT-BSE Signed 15.2
Element: Adj Amt Tax amount in company base currency.
OIL-REASON-CODE Alpha 4
Accounts Receivable Reason code is used to indicate the
Code 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
Element: Discount 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
Element: Order DiscountThis flag determines whether the order
line is eligible for an allocated
discount.
Y = Yes
N = No
OIL-CONTRACT-NBR Alpha 14
Element: Contract NumbeIf a contract appears on this line
field, the line was priced using this
contract number.
OIL-PROMOTION Alpha 10
Element: Promotion If a promotion is found in this field,
this line item was priced using a
promotion price modifier.
OIL-ACTIVITY Alpha 15
Element: 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
Element: Account CategoIn 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
Object Represents Activity Management system
Identification 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
Element: Activity 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
Element: Account CategoIn 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
Object The system defined object id
Identification representing the Activity Management
commitment for Cost (COGS).
OIL-FINAL-INVC-FL Alpha 1
Element: All Flag 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
Element: Accounting UniSales account unit to be credited or
debited for this line.
OIL-SLS-ACCOUNT Numeric 6
Element: Account Sales account number to be debited or
credited for this line.
OIL-SLS-SUB-ACCT Numeric 4
Element: Subaccount Sales subaccount number to be debited
or credited for this line.
OIL-SALES-MAJCL Alpha 4
Element: Major Class Sales major class code of the line item.
OIL-SALES-MINCL Alpha 4
Element: Minor Class Sales minor class code of the line item.
OIL-DSC-AMT Signed 15.2 Occurs 3 Times
Element: Adj Amt This is the price modifier discount
amount calculated for the line item.
OIL-DSC-ACCT-UNIT Alpha 15 Occurs 3 Times
Element: Accounting UniThese fields store the discount account
units that are to be debited for
nonstock line items that are affected by
price modifier discounts. These account
units are credited for credit memo line
items.
OIL-DSC-ACCOUNT Numeric 6 Occurs 3 Times
Element: 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
Element: Subaccount These fields store the discount
subaccount numbers that are to be
debited for nonstock line items that are
affected by price modifier discounts.
The account is credited for credit memo
line items.
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
Element: Adj Amt 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
Element: Accounting UniThis 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
Element: 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
Element: 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
Element: Accounting UniThe cost of goods sold account unit is
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
Element: Account The cost of goods sold account number
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
Element: Subaccount The cost of goods sold subaccount
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
Element: Sequence NumbeThis value indicates the number of the
last add-on charge attached to this
line. This value determines the sequence
number of the next add-on charge.
OIL-LAST-COMM-SEQ Numeric 3 BLI2.1
Element: Sequence NumbeThis is the sequence number of the last
comment line entered for this invoice
line.
OIL-TERRITORY Alpha 4
Element: Sales TerritorThe 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
Element: Salesman NumbeThe 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
Element: Salesman NumbeThe 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)
Element: Chrg Rate Commission rate for sales
representative 1. Defaults from the
sales representative record.
OIL-COMM-RATE-2 Percent 7.5 (Percent)
Element: Chrg Rate Commission rate for sales
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
Purchase Order User This is the first user-defined field on
Field 2 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)
Element: User Defined FThe 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)
Element: User Defined FThe 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
Element: Exchange Rate 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
Element: Invl Obj Id
OIL-PROD-TAX-CAT Alpha 15
Element: Product Tax CaA 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
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 15.2
Element: Exchange Rate 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
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 BLI2.1
INVC-PREFIX
INVC-NUMBER
LINE-NBR
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 -> -COMPANY (XXXXXXXXXX)
OEP-DSC-ACCT-UNIT -> -ACCT-UNIT
OEP-DSC-ACCOUNT -> -ACCOUNT
OEP-DSC-SUB-ACCT -> -SUB-ACCOUNT
Arcomp ARCOMP Required
OIL-COMPANY -> ACO-COMPANY
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
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
Oeinvoice OEINVOICE Required
OIL-COMPANY -> OEI-COMPANY
OIL-INVC-PREFIX -> OEI-INVC-PREFIX
OIL-INVC-NUMBER -> OEI-INVC-NUMBER
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
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
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
|
