OEINVCMISC – Invoice Miscellaneous Charges

System: Billing (BL)
Prefix: OIM
Primary key: COMPANY, INVC-PREFIX, INVC-NUMBER, LINE-NBR, SEQ
Fields: 53
Updated by: 1 program
Referenced by: 1 program

OEINVCMISC is the Invoice Miscellaneous Charges table in Lawson Billing (prefix OIM). It is indexed by COMPANY, INVC-PREFIX, INVC-NUMBER, LINE-NBR, SEQ (OIMSET1); alternate indexes: OIMSET2, OIMSET3, OIMSET4 and OIMSET5. It is related 1:1 to BLRICUST, GLMASTER, OECOMPANY, OEINVCLINE, OEINVOICE, OEINVSGBLK and OEMISC and 1:M to OEDIST and OEINVCTAX. It is updated by WH20.7 and referenced by TX101. The table has 53 fields, 5 indexes and 12 documented relations.

About OEINVCMISC

This file stores the add-on charges that are related to a specific invoice or invoice line.

Fields (53)

Column = COBOL field name without the OIM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`OIM-COMPANY` PK COMPANY	Numeric 4	Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	WH20.7
`OIM-INVC-PREFIX` PK INVC_PREFIX	Alpha 2	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.	WH20.7
`OIM-INVC-NUMBER` PK INVC_NUMBER	Numeric 8	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.	WH20.7
`OIM-LINE-NBR` PK LINE_NBR	Numeric 6	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.	WH20.7
`OIM-SEQ` PK SEQ	Numeric 3	The sequence number identifying the last add-on charge record tied to the invoice line or the invoice itself.	WH20.7
`OIM-MISC` MISC	Alpha 16	The add-on charge code used. Define add-on charges using BL09.1 (Add-on Charges).	WH20.7
`OIM-TAX-EXEMPT-CD` TAX_EXEMPT_CD	Alpha 1	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.	WH20.7
`OIM-TAX-CODE` TAX_CODE	Alpha 10	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).	WH20.7
`OIM-ENT-TAXABLE` ENT_TAXABLE	Signed 18.2	The taxable amount of the add-on charge in original currency.	WH20.7
`OIM-TAXABLE-BSE` TAXABLE_BSE	Signed 18.2	Taxable amount of the add-on charge in company base currency.	WH20.7
`OIM-TAX-AMT-CURR` TAX_AMT_CURR	Signed 18.2	Tax amount for the add-on charge in billing currency.	WH20.7
`OIM-TAX-AMT-BSE` TAX_AMT_BSE	Signed 18.2	Tax amount for the add-on charge in company base currency.	WH20.7
`OIM-CHARGE-TYPE` CHARGE_TYPE	Numeric 1	Indicates whether the add-on charge is calculated via lump sum, unit price, or percentage. `1` Lump Sum `2` Unit Price `3` Percentage	WH20.7
`OIM-ENT-UNIT-PRC` ENT_UNIT_PRC	Signed 18.5	Price of add-on charge in original currency. Defaults from the add-on charge set up on BL09.1 (Add-on Charges).	WH20.7
`OIM-UNIT-PRICE` UNIT_PRICE	Signed 18.5	Unit price as defaulting from BL09.1 (Add-on Charges) in company base currency.	WH20.7
`OIM-PRICE-PCT` PRICE_PCT	Percent 5.3 (Percent)	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).	WH20.7
`OIM-ENT-PRICE` ENT_PRICE	Signed 18.2	Optionally enter the price of the add-on charge in original billing currency.	WH20.7
`OIM-PRICE` PRICE	Signed 18.2	Price of the add-on charge as defaulting from BL09.1 (Add-on Charges) in company base currency.	WH20.7
`OIM-UNIT-COST` UNIT_COST	Signed 18.5	The unit cost of the add-on charge in base currency.	WH20.7
`OIM-COST-PCT` COST_PCT	Percent 5.3 (Percent)	The cost percent. The percent to apply to the line or invoice extended net amount to arrive at the add-on charge cost.	WH20.7
`OIM-COST` COST	Signed 18.5	The flat monetary amount of cost of the add-on charge as it defaults from BL09.1 (Add-on Charges) in company base currency.	WH20.7
`OIM-ALLOC-DISC` ALLOC_DISC	Signed 18.2	Amount of the order discount or add-on discount allocated to this add-on charge.	WH20.7
`OIM-UPD-SA-FL` UPD_SA_FL	Alpha 1	This field identifies whether or not the Sales Analysis system is to be updated.	WH20.7
`OIM-ORD-DISC-FL` ORD_DISC_FL	Alpha 1	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	WH20.7
`OIM-SLS-ACCT-UNIT` SLS_ACCT_UNIT	Alpha 15	Sales account unit to be credited or debited for this add-on charge.	WH20.7
`OIM-SLS-ACCOUNT` SLS_ACCOUNT	Numeric 6	Sales account number to be debited or credited for this add-on charge.	WH20.7
`OIM-SLS-SUB-ACCT` SLS_SUB_ACCT	Numeric 4	Sales subaccount number to be debited or credited for this add-on charge.	WH20.7
`OIM-OFF-ACCT-UNIT` OFF_ACCT_UNIT	Alpha 15	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.	WH20.7
`OIM-OFF-ACCOUNT` OFF_ACCOUNT	Numeric 6	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.	WH20.7
`OIM-OFF-SUB-ACCT` OFF_SUB_ACCT	Numeric 4	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.	WH20.7
`OIM-CGS-ACCT-UNIT` CGS_ACCT_UNIT	Alpha 15	The 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.	WH20.7
`OIM-CGS-ACCOUNT` CGS_ACCOUNT	Numeric 6	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.	WH20.7
`OIM-CGS-SUB-ACCT` CGS_SUB_ACCT	Numeric 4	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.	WH20.7
`OIM-ACTIVITY` ACTIVITY	Alpha 15	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.	WH20.7
`OIM-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	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.	WH20.7
`OIM-ATN-OBJ-ID` ATN_OBJ_ID	Numeric 12	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.	WH20.7
`OIM-ACTIVITY-C` ACTIVITY_C	Alpha 15	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.	WH20.7
`OIM-ACCT-CATEG-C` ACCT_CATEG_C	Alpha 5	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.	WH20.7
`OIM-ATN-OBJ-ID-C` ATN_OBJ_ID_C	Numeric 12	The system defined object id representing the Activity Management commitment for Cost (COGS).	WH20.7
`OIM-INVC-PCT-AMT` INVC_PCT_AMT	Derived	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` LINE_PCT_AMT	Derived	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` UNIT_AMOUNT	Derived	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` CHARGE_AMT	Derived	Final calculated amount of the add-on charge.	—
`OIM-CHARGE-CURR` CHARGE_CURR	Signed 18.2	Final calculated amount of the add-on charge in billing currency.	WH20.7
`OIM-CHARGE-BASE` CHARGE_BASE	Signed 18.2	Final calculated amount of the add-on charge in company base currency.	WH20.7
`OIM-COST-BASE` COST_BASE	Signed 18.2	Final calculated cost amount of the add-on charge in company base currency.	WH20.7
`OIM-PROD-TAX-CAT` PROD_TAX_CAT	Alpha 15	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.	WH20.7
`OIM-PER-UNIT-FL` PER_UNIT_FL	Derived	This field contains the per unit charge type.	—
`OIM-INVC-PCT-COST` INVC_PCT_COST	Derived	This field contains the cost if the charge type is a percentage.	—
`OIM-LINE-PCT-COST` LINE_PCT_COST	Derived	This field contains the percentage that is attached to the line.	—
`OIM-LINE-UNIT-COST` LINE_UNIT_COST	Derived	This field contains the per unit cost.	—
`OIM-LINE-COST-AMT` LINE_COST_AMT	Derived	This field determines which cost to display.	—
`OIM-TRACK-TYPE` TRACK_TYPE	Alpha 1	" " = Other AOC `I` Insurance `F` Freight `C` Customs Charges	WH20.7

Indexes (5)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`OIMSET1`	`COMPANY`, `INVC-PREFIX`, `INVC-NUMBER`, `LINE-NBR`, `SEQ`	Primary		TX101, WH20.7
`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`, `INVC-PREFIX`, `INVC-NUMBER`, `TAX-CODE`, `PROD-TAX-CAT`, `LINE-NBR`, `SEQ`	KeyChange		WH20.7
`OIMSET5`	`COMPANY`, `INVC-PREFIX`, `INVC-NUMBER`, `SEQ`, `LINE-NBR`			WH20.7

Relations

One to one (10) — lookups and parents

Relation	Table	Rules	Condition	Field map
Blricust	BLRICUST	Not Required	Valid When OEI-RECUR-INVOICE != Spaces	`OIM-COMPANY` → `BRC-COMPANY`, `OEI-RECUR-INVOICE` → `BRC-RECUR-INVOICE`, `OEI-CUSTOMER` → `BRC-CUSTOMER`
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`
Oecustsrvc	BLRICUST	Not Required	Valid When OEI-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`
Oemisc	OEMISC	Required		`OIM-COMPANY` → `OEM-COMPANY`, `OIM-MISC` → `OEM-MISC`, `OEI-CURRENCY-CODE` → `OEM-CURRENCY-CODE`
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`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
Oedist	OEDIST		Valid When OEI-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`, → `OIT-TAX-LEVEL`

OEINVCMISC – Invoice Miscellaneous Charges

About OEINVCMISC

Fields (53)

Indexes (5)

Relations

One to one (10) — lookups and parents

One to many (2) — child tables

Programs

Updated by (1)

Referenced by (1)