OEINVCMISC FILE
Invoice Miscellaneous Charges
This file stores the add-on charges that are related to a specific invoice or
invoice line.
REFERENCED BY
BL121 BL123 BL220 BL232 BL290 BL80.1
UPDATED BY
BL320
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OIM-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
OIM-INVC-PREFIX Alpha 2
Invoice Prefix Invoice prefix is assigned from either
the company or process level depending
on the invoice level option chosen when
setting up the company in the Billing
system.
OIM-INVC-NUMBER Numeric 8
Invc Number Invoice number assigned by the system.
Invoice numbers are assigned at the
company or process level, depending on
the option chosen when setting up the
company in the Billing system.
OIM-LINE-NBR Numeric 6
Line Number This indicates the line of the invoice
the add-on charge is tied to if anything
is entered here. If blank, the add-on
charge was added at the invoice header
level.
OIM-SEQ Numeric 3
Sequence Number The sequence number identifying the
last add-on charge record tied to the
invoice line or the invoice itself.
OIM-MISC Alpha 16
Misc The add-on charge code used. Define
add-on charges using BL09.1 (Add-on
Charges).
OIM-TAX-EXEMPT-CD Alpha 1
Tax Exempt Code Indicates whether or not the add-on
charge is to be included in tax
calculations. If any one of the
following are tax exempt, the exempt
flag will default onto this field:
customer ship-to, customer master, or
add-on charge code.
E = Tax exempt.
T = Taxable.
OIM-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 set up
on TX01.1 (Tax Code Master).
OIM-ENT-TAXABLE Signed 15.2
Entered Taxable The taxable amount of the add-on charge
in original currency.
OIM-TAXABLE-BSE Signed 15.2
Taxable Bse Taxable amount of the add-on charge in
company base currency.
OIM-TAX-AMT-CURR Signed 15.2
Tax Amt Curr Tax amount for the add-on charge in
billing currency.
OIM-TAX-AMT-BSE Signed 15.2
Tax Amt Bse Tax amount for the add-on charge in
company base currency.
OIM-CHARGE-TYPE Numeric 1
Charge Type Indicates whether the add-on charge is
calculated via lump sum, unit price, or
percentage.
1 = Lump Sum
2 = Unit Price
3 = Percentage
OIM-ENT-UNIT-PRC Signed 13.5
Ent Unit Prc Price of add-on charge in original
currency. Defaults from the add-on
charge set up on BL09.1 (Add-on
Charges).
OIM-UNIT-PRICE Signed 13.5
Unit Price Unit price as defaulting from BL09.1
(Add-on Charges) in company base
currency.
OIM-PRICE-PCT Percent 5.3 (Percent)
Price Pct Price percent. This is the percent
applied to price to arrive at the add-on
charge if the add-on charge type is
defined as a percentage pricing charge
on BL09.1 (Add-on Charges).
OIM-ENT-PRICE Signed 15.2
Ent Price Optionally enter the price of the
add-on charge in original billing
currency.
OIM-PRICE Signed 15.2
Price Price of the add-on charge as
defaulting from BL09.1 (Add-on Charges)
in company base currency.
OIM-UNIT-COST Signed 13.5
Unit Cost The unit cost of the add-on charge in
base currency.
OIM-COST-PCT Percent 5.3 (Percent)
Cost Pct The cost percent. The percent to apply
to the line or invoice extended net
amount to arrive at the add-on charge
cost.
OIM-COST Signed 11.2
Cost The flat monetary amount of cost of the
add-on charge as it defaults from BL09.1
(Add-on Charges) in company base
currency.
OIM-ALLOC-DISC Signed 15.2
Allocation Discount Amount of the order discount or add-on
discount allocated to this add-on
charge.
OIM-UPD-SA-FL Alpha 1
Upd Sa Fl This field identifies whether or not
the Sales Analysis system is to be
updated.
OIM-ORD-DISC-FL Alpha 1
Order Discount Flag Order discount flag indicates whether
the charge is eligible to be included
when the system calculates the
order-level discount.
N = not discountable
Y = discountable
OIM-SLS-ACCT-UNIT Alpha 15
Sales Accounting Sales account unit to be credited or
Unit debited for this add-on charge.
OIM-SLS-ACCOUNT Numeric 6
Sales Account Sales account number to be debited or
credited for this add-on charge.
OIM-SLS-SUB-ACCT Numeric 4
Sales Subaccount Sales subaccount number to be debited
or credited for this add-on charge.
OIM-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.
OIM-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.
OIM-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.
OIM-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.
OIM-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.
OIM-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.
OIM-ACTIVITY Alpha 15
Activity In this file the Activity field is used
for revenue (sales) postings whereas the
Activity-C field is used for Cost (COGS)
postings.
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.
OIM-ACCT-CATEGORY Alpha 5
Account Category In this file the Acct-Category field is
used for 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.
OIM-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.
OIM-ACTIVITY-C Alpha 15
Activity C In this file the Activity-C field is
used for Cost (COGS) postings whereas
the Activity field is used for revenue
(sales) postings.
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.
OIM-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.
OIM-ATN-OBJ-ID-C Numeric 12
Atn Obj Id C The system defined object id
representing the Activity Management
commitment for Cost (COGS).
OIM-INVC-PCT-AMT Derived
Invc Pct Amt Amount billed to the customer if the
add-on charge is tied to the invoice
header and is a percentage type. In
company base currency.
OIM-LINE-PCT-AMT Derived
Line Pct Amt Amount billed to the customer if the
add-on charge is tied to the invoice
line and is a percentage type. In
company base currency.
OIM-UNIT-AMOUNT Derived
Unit Amount Amount to be charged per unit of the
item ordered at the line level. The
add-on charge amount will be the sum
total of the charges per unit.
OIM-CHARGE-AMT Derived
Charge Amt Final calculated amount of the add-on
charge.
OIM-CHARGE-CURR Signed 15.2
Charge Curr Final calculated amount of the add-on
charge in billing currency.
OIM-CHARGE-BASE Signed 15.2
Charge Base Final calculated amount of the add-on
charge in company base currency.
OIM-COST-BASE Signed 15.2
Cost Base Final calculated cost amount of the
add-on charge in company base currency.
OIM-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.
OIM-PER-UNIT-FL Derived
Per Unit Fl This field contains the per unit charge
type.
OIM-INVC-PCT-COST Derived
Invc Pct Cost This field contains the cost if the
charge type is a percentage.
OIM-LINE-PCT-COST Derived
Line Pct Cost This field contains the percentage that
is attached to the line.
OIM-LINE-UNIT-COST Derived
Line Unit Cost This field contains the per unit cost.
OIM-LINE-COST-AMT Derived
Line Cost Amt This field determines which cost to
display.
OEINVCMISC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OIMSET1 COMPANY BL121 BL123
INVC-PREFIX BL220 BL232
INVC-NUMBER BL290 BL320
LINE-NBR BL80.1
SEQ
OIMSET2 ATN-OBJ-ID KeyChange, Subset
Where ATN-OBJ-ID != Zeroes
OIMSET3 ATN-OBJ-ID-C KeyChange, Subset
Where ATN-OBJ-ID-C != Zeroes
OIMSET4 COMPANY KeyChange
INVC-PREFIX
INVC-NUMBER
TAX-CODE
PROD-TAX-CAT
LINE-NBR
SEQ
OIMSET5 COMPANY this index was created as a solution to
INVC-PREFIX the Find Next/Prev Flag error. It is
INVC-NUMBER only used where a modify must be done
SEQ within a 850-FIND-NLT or 850-FIND-BEGRNG
LINE-NBR loop.
OEINVCMISC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Blricmisc BLRICMISC Not Required
Valid When OIM-RECUR-INVOICE != Spaces
OIM-COMPANY -> BUM-COMPANY
OEI-RECUR-INVOICE -> BUM-RECUR-INVOICE
OEI-CUSTOMER -> BUM-CUSTOMER
OIM-LINE-NBR -> BUM-LINE-NBR
OIM-SEQ -> BUM-SEQ
Blricust BLRICUST Not Required
Valid When OIM-RECUR-INVOICE != Spaces
OIM-COMPANY -> BRC-COMPANY
OEI-RECUR-INVOICE -> BRC-RECUR-INVOICE
OEI-CUSTOMER -> BRC-CUSTOMER
Blrimast BLRIMAST Not Required
Valid When OIM-RECUR-INVOICE != Spaces
OIM-COMPANY -> BRM-COMPANY
OEI-RECUR-INVOICE -> BRM-RECUR-INVOICE
Blrimmisc BLRIMMISC Not Required
Valid When OIM-RECUR-INVOICE != Spaces
OIM-COMPANY -> BMM-COMPANY
OEI-RECUR-INVOICE -> BMM-RECUR-INVOICE
BUM-MAST-LINE-NBR -> BMM-LINE-NBR
BUM-MAST-SEQ -> BMM-SEQ
Cogs Account GLMASTER Required
When OIM-CGS-ACCT-UNIT != Spaces
Or OIM-CGS-ACCOUNT != Zeroes
Or OIM-CGS-SUB-ACCT != Zeroes
OIM-COMPANY -> GLM-COMPANY
OIM-CGS-ACCT-UNIT -> GLM-ACCT-UNIT
OIM-CGS-ACCOUNT -> GLM-ACCOUNT
OIM-CGS-SUB-ACCT -> GLM-SUB-ACCOUNT
Oecompany OECOMPANY Required
OIM-COMPANY -> OEC-COMPANY
Oecsmisc BLRICMISC Not Required
Valid When OIM-RECUR-INVOICE != Spaces
OIM-COMPANY -> BUM-COMPANY
OEI-RECUR-INVOICE -> BUM-RECUR-INVOICE
OEI-CUSTOMER -> BUM-CUSTOMER
OIM-LINE-NBR -> BUM-LINE-NBR
OIM-SEQ -> BUM-SEQ
Oecustsrvc BLRICUST Not Required
Valid When OIM-RECUR-INVOICE != Spaces
OIM-COMPANY -> BRC-COMPANY
OEI-RECUR-INVOICE -> BRC-RECUR-INVOICE
OEI-CUSTOMER -> BRC-CUSTOMER
Oeinvcline OEINVCLINE Required
When OIM-LINE-NBR != Zeroes
OIM-COMPANY -> OIL-COMPANY
OIM-INVC-PREFIX -> OIL-INVC-PREFIX
OIM-INVC-NUMBER -> OIL-INVC-NUMBER
OIM-LINE-NBR -> OIL-LINE-NBR
Oeinvoice OEINVOICE Required
OIM-COMPANY -> OEI-COMPANY
OIM-INVC-PREFIX -> OEI-INVC-PREFIX
OIM-INVC-NUMBER -> OEI-INVC-NUMBER
Oeinvsgblk OEINVSGBLK Not Required
OIM-COMPANY -> OSB-COMPANY
OIM-INVC-PREFIX -> OSB-INVC-PREFIX
OIM-INVC-NUMBER -> OSB-INVC-NUMBER
OIM-LINE-NBR -> OSB-LINE-NBR
OIM-SEQ -> OSB-SEQ
Oemastsrvc BLRIMAST Not Required
Valid When OIM-RECUR-INVOICE != Spaces
OIM-COMPANY -> BRM-COMPANY
OEI-RECUR-INVOICE -> BRM-RECUR-INVOICE
Oemisc OEMISC Required
OIM-COMPANY -> OEM-COMPANY
OIM-MISC -> OEM-MISC
OEI-CURRENCY-CODE -> OEM-CURRENCY-CODE
Oemsmisc BLRIMMISC Not Required
Valid When OIM-RECUR-INVOICE != Spaces
OIM-COMPANY -> BMM-COMPANY
OEI-RECUR-INVOICE -> BMM-RECUR-INVOICE
BUM-MAST-LINE-NBR -> BMM-LINE-NBR
OIM-SEQ -> BMM-SEQ
Offset Account GLMASTER Required
When OIM-OFF-ACCT-UNIT != Spaces
Or OIM-OFF-ACCOUNT != Zeroes
Or OIM-OFF-SUB-ACCT != Zeroes
OIM-COMPANY -> GLM-COMPANY
OIM-OFF-ACCT-UNIT -> GLM-ACCT-UNIT
OIM-OFF-ACCOUNT -> GLM-ACCOUNT
OIM-OFF-SUB-ACCT -> GLM-SUB-ACCOUNT
Sales Account GLMASTER Required
When OIM-SLS-ACCT-UNIT != Spaces
Or OIM-SLS-ACCOUNT != Zeroes
Or OIM-SLS-SUB-ACCT != Zeroes
OIM-COMPANY -> GLM-COMPANY
OIM-SLS-ACCT-UNIT -> GLM-ACCT-UNIT
OIM-SLS-ACCOUNT -> GLM-ACCOUNT
OIM-SLS-SUB-ACCT -> GLM-SUB-ACCOUNT
OEINVCMISC FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Oedist OEDIST
Valid When OIM-STATUS = 9
OIM-COMPANY -> ODI-COMPANY
OIM-INVC-PREFIX -> ODI-INVC-PREFIX
OIM-INVC-NUMBER -> ODI-INVC-NUMBER
Zeroes -> ODI-AUTH-NO
OIM-LINE-NBR -> ODI-LINE-NBR
ODI-ACCT-UNIT
ODI-ACCOUNT
ODI-SUB-ACCOUNT
ODI-SEQ
ODI-POSTING-TYPE
Oeinvctax OEINVCTAX Required
OIM-COMPANY -> OIT-COMPANY
OIM-INVC-PREFIX -> OIT-INVC-PREFIX
OIM-INVC-NUMBER -> OIT-INVC-NUMBER
OIM-LINE-NBR -> OIT-LINE-NBR
OIM-SEQ -> OIT-SEQ
OIT-TAX-CODE
|
