Invoice Miscellaneous Charges

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

REFERENCED BY

TX101

UPDATED BY

WH20.7

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
OIM-COMPANY Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: Intl Amt	Signed 18.2 The taxable amount of the add-on charge in original currency.	WH20.7
OIM-TAXABLE-BSE Element: Intl Amt	Signed 18.2 Taxable amount of the add-on charge in company base currency.	WH20.7
OIM-TAX-AMT-CURR Element: Intl Amt	Signed 18.2 Tax amount for the add-on charge in billing currency.	WH20.7
OIM-TAX-AMT-BSE Element: Intl Amt	Signed 18.2 Tax amount for the add-on charge in company base currency.	WH20.7
OIM-CHARGE-TYPE Element: 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 Element: Intl Cost	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 Element: Intl Cost	Signed 18.5 Unit price as defaulting from BL09.1 (Add-on Charges) in company base currency.	WH20.7
OIM-PRICE-PCT Element: Cost 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 Element: Intl Amt	Signed 18.2 Optionally enter the price of the add-on charge in original billing currency.	WH20.7
OIM-PRICE Element: Intl Amt	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 Element: Intl Cost	Signed 18.5 The unit cost of the add-on charge in base currency.	WH20.7
OIM-COST-PCT Element: 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 Element: Intl 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 Element: Intl Amt	Signed 18.2 Amount of the order discount or add-on discount allocated to this add-on charge.	WH20.7
OIM-UPD-SA-FL Element: All Flag	Alpha 1 This field identifies whether or not the Sales Analysis system is to be updated.	WH20.7
OIM-ORD-DISC-FL Element: 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 Element: Acct Unit	Alpha 15 Sales account unit to be credited or debited for this add-on charge.	WH20.7
OIM-SLS-ACCOUNT Element: Account	Numeric 6 Sales account number to be debited or credited for this add-on charge.	WH20.7
OIM-SLS-SUB-ACCT Element: Sub Acct	Numeric 4 Sales subaccount number to be debited or credited for this add-on charge.	WH20.7
OIM-OFF-ACCT-UNIT Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: Activity	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 Element: Acct Category	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 Element: Obj Id	Numeric 12 The system defined object id representing the Activity Management commitment for Cost (COGS).	WH20.7
OIM-INVC-PCT-AMT Element: 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 Element: 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 Element: 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 Element: Charge Amt	Derived Final calculated amount of the add-on charge.
OIM-CHARGE-CURR Element: Intl Amt	Signed 18.2 Final calculated amount of the add-on charge in billing currency.	WH20.7
OIM-CHARGE-BASE Element: Intl Amt	Signed 18.2 Final calculated amount of the add-on charge in company base currency.	WH20.7
OIM-COST-BASE Element: Intl Amt	Signed 18.2 Final calculated cost amount of the add-on charge in company base currency.	WH20.7
OIM-PROD-TAX-CAT Element: 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 Element: Per Unit Fl	Derived This field contains the per unit charge type.
OIM-INVC-PCT-COST Element: Invc Pct Cost	Derived This field contains the cost if the charge type is a percentage.
OIM-LINE-PCT-COST Element: Line Pct Cost	Derived This field contains the percentage that is attached to the line.
OIM-LINE-UNIT-COST Element: Line Unit Cost	Derived This field contains the per unit cost.
OIM-LINE-COST-AMT Element: Line Cost Amt	Derived This field determines which cost to display.
OIM-TRACK-TYPE Element: Aoc Type	Alpha 1 " " = Other AOC I = Insurance F = Freight C = Customs Charges	WH20.7

OEINVCMISC FILE INDEX

OEINVCMISC FILE RELATIONS

ONE TO ONE RELATIONS

OEINVCMISC FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.