Invoice Miscellaneous Charges
This file stores the add-on charges that are related to a specific invoice or
invoice line.
UPDATED BY
TX101 |
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
OIM-MISC Element: Misc | Alpha 16 The add-on charge code used. Define add-on charges using BL09.1 (Add-on Charges). |
|
|
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. |
|
|
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). |
|
|
OIM-ENT-TAXABLE Element: Intl Amt | Signed 18.2 The taxable amount of the add-on charge in original currency. |
|
|
OIM-TAXABLE-BSE Element: Intl Amt | Signed 18.2 Taxable amount of the add-on charge in company base currency. |
|
|
OIM-TAX-AMT-CURR Element: Intl Amt | Signed 18.2 Tax amount for the add-on charge in billing currency. |
|
|
OIM-TAX-AMT-BSE Element: Intl Amt | Signed 18.2 Tax amount for the add-on charge in company base currency. |
|
|
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 |
|
|
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). |
|
|
OIM-UNIT-PRICE Element: Intl Cost | Signed 18.5 Unit price as defaulting from BL09.1 (Add-on Charges) in company base currency. |
|
|
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). |
|
|
OIM-ENT-PRICE Element: Intl Amt | Signed 18.2 Optionally enter the price of the add-on charge in original billing currency. |
|
|
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. |
|
|
OIM-UNIT-COST Element: Intl Cost | Signed 18.5 The unit cost of the add-on charge in base currency. |
|
|
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. |
|
|
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. |
|
|
OIM-ALLOC-DISC Element: Intl Amt | Signed 18.2 Amount of the order discount or add-on discount allocated to this add-on charge. |
|
|
OIM-UPD-SA-FL Element: All Flag | Alpha 1 This field identifies whether or not the Sales Analysis system is to be updated. |
|
|
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 |
|
|
OIM-SLS-ACCT-UNIT Element: Acct Unit | Alpha 15 Sales account unit to be credited or debited for this add-on charge. |
|
|
OIM-SLS-ACCOUNT Element: Account | Numeric 6 Sales account number to be debited or credited for this add-on charge. |
|
|
OIM-SLS-SUB-ACCT Element: Sub Acct | Numeric 4 Sales subaccount number to be debited or credited for this add-on charge. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
OIM-ATN-OBJ-ID-C Element: Obj Id | Numeric 12 The system defined object id representing the Activity Management commitment for Cost (COGS). |
|
|
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. |
|
|
OIM-CHARGE-BASE Element: Intl Amt | Signed 18.2 Final calculated amount of the add-on charge in company base currency. |
|
|
OIM-COST-BASE Element: Intl Amt | Signed 18.2 Final calculated cost amount of the add-on charge in company base currency. |
|
|
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. |
|
|
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. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
OIMSET1 |
COMPANY INVC-PREFIX INVC-NUMBER LINE-NBR SEQ |
|
| |||||||||||||
OIMSET2 |
ATN-OBJ-ID |
|
||||||||||||||
OIMSET3 |
ATN-OBJ-ID-C |
|
||||||||||||||
OIMSET4 |
COMPANY INVC-PREFIX INVC-NUMBER TAX-CODE PROD-TAX-CAT LINE-NBR SEQ |
|
||||||||||||||
OIMSET5 |
COMPANY INVC-PREFIX INVC-NUMBER SEQ LINE-NBR |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Cogs Account | GLMASTER |
Required
| ||||||||||||||||||||||||||||||
Oecompany | OECOMPANY |
Required
| ||||||||||||||||||||||||||||||
Oeinvcline | OEINVCLINE |
Required
| ||||||||||||||||||||||||||||||
Oeinvoice | OEINVOICE |
Required
| ||||||||||||||||||||||||||||||
Offset Account | GLMASTER |
Required
| ||||||||||||||||||||||||||||||
Sales Account | GLMASTER |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Oedist | OEDIST |
| ||||||||||||||||||||||||||||||||||||
Oeinvctax | OEINVCTAX |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.