OEINVCMISC

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.


OEINVCMISC FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OIMSET1 COMPANY
INVC-PREFIX
INVC-NUMBER
LINE-NBR
SEQ
TX101
OIMSET2 ATN-OBJ-ID
KeyChange, Subset
WhereATN-OBJ-ID !=Zeroes
OIMSET3 ATN-OBJ-ID-C
KeyChange, Subset
WhereATN-OBJ-ID-C !=Zeroes
OIMSET4 COMPANY
INVC-PREFIX
INVC-NUMBER
TAX-CODE
PROD-TAX-CAT
LINE-NBR
SEQ
KeyChange
OIMSET5 COMPANY
INVC-PREFIX
INVC-NUMBER
SEQ
LINE-NBR


OEINVCMISC FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Cogs Account GLMASTER Required
When OIM-CGS-ACCT-UNIT !=Spaces
OrOIM-CGS-ACCOUNT !=Zeroes
OrOIM-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
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
Offset Account GLMASTER Required
When OIM-OFF-ACCT-UNIT !=Spaces
OrOIM-OFF-ACCOUNT !=Zeroes
OrOIM-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
OrOIM-SLS-ACCOUNT !=Zeroes
OrOIM-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
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


File created: Wed Jun 08 20:48:01 2016

Home
Contact Us



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