OEMISC – Customer Order Misc Charges

System: Billing (BL)
Prefix: OEM
Primary key: COMPANY, MISC, CURRENCY-CODE
Fields: 31
Updated by: 1 program
Referenced by: 0 programs

OEMISC is the Customer Order Misc Charges table in Lawson Billing (prefix OEM). It is indexed by COMPANY, MISC, CURRENCY-CODE (OEMSET1); alternate indexes: OEMSET2. It is related 1:1 to CUCODES, GLCHARTDTL, GLMASTER, GLSYSTEM, ICCOMPANY, MAJORCL, MINORCL, OECOMPANY and 2 more. It is updated by WH20.7. The table has 31 fields, 2 indexes and 14 documented relations.

About OEMISC

No description in the Lawson data dictionary.

Fields (31)

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

Field / column	Type	Description & values	Updated by
`OEM-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.	—
`OEM-MISC` PK MISC	Alpha 16	User-defined value that can be set up as an add-on charge and tied to either the order header or the individual lines on the order at entry time.	—
`OEM-CURRENCY-CODE` PK CURRENCY_CODE	Alpha 5	The currency code indicating the currency that will be used when the add-on charge is assessed.	—
`OEM-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	The description of the add-on charge. When the add-on charge is added to the order, this description will display on the form and print on invoices.	—
`OEM-ORD-DISC-FL` ORD_DISC_FL	Alpha 1	This flag indicates whether the add-on charge should be included in the order total when the system is assessing any order-level discounts. `N` No `Y` Yes	—
`OEM-CHARGE-TYPE` CHARGE_TYPE	Numeric 1	Indicates whether the charge is a flat monetary amount, an amount per unit, or a percentage. Amount per unit is based on stock unit of measure. `1` Flat Amount `2` Unit Price `3` Percentage	—
`OEM-AOC-CODE` AOC_CODE	Alpha 2	This field contains the purchase order add-on cost code to be used if an order line is causing a purchase order to be created. Purchase order add-on cost codes are added and maintained in the Invoice Matching system.	—
`OEM-UNIT-PRICE` UNIT_PRICE	Signed 18.5	The unit price. Only valid if attached to an order line. This is the amount to be charged per stock unit of measure sold on the order line.	—
`OEM-PRICE-PCT` PRICE_PCT	Percent 5.3 (Percent)	The price percent. This is the percent applied to the order line extension (if attached to an order line) or to the order total goods amount (if attached to an order) to determine the amount to be charged.	—
`OEM-PRICE` PRICE	Signed 18.2	The flat monetary amount to be charged to the customer.	—
`OEM-UNIT-COST` UNIT_COST	Signed 18.5	Only valid if attached to an order line. This is the cost amount and will be posted to cost of goods sold.	—
`OEM-COST-PCT` COST_PCT	Percent 5.3 (Percent)	Cost percent. The percent applied to either the order line extension (if attached to an order line) or to the total order goods amount (if attached to an order) to determine the amount to be charged.	—
`OEM-COST` COST	Signed 18.5	The flat monetary amount to be posted to cost of goods sold.	—
`OEM-UPD-SA-FL` UPD_SA_FL	Alpha 1	Determines whether the add-on charge should update the Sales Analysis system for reporting purposes. `N` No `Y` Yes	—
`OEM-TAX-EXEMPT-CD` TAX_EXEMPT_CD	Alpha 1	Determines whether the add-on charge amount will be included when the system calculates tax amounts for the order. `E` Exempt `T` Taxable	—
`OEM-TAX-CODE` TAX_CODE	Alpha 10	Tax code this charge is subject to. Only used for Value-Added Tax (VAT). Domestic sales tax does not differ by charge. Tax exempt flag is sufficient.	—
`OEM-SALES-MAJCL` SALES_MAJCL	Alpha 4	Sales major class code. If the add-on charge is passed to the Sales Analysis system for reporting purposes, the user can assign the charge to a sales major/minor class for subtotaling.	—
`OEM-SALES-MINCL` SALES_MINCL	Alpha 4	Sales minor class code within the major class. If the add-on charge is passed to the Sales Analysis system for reporting purposes, it can be assigned to a sales major/minor class for subtotaling.	—
`OEM-PROD-TAX-CAT` PROD_TAX_CAT	Alpha 15	The product's tax category. Used to override taxability by specific taxing authority.	—
`OEM-SLS-ACCT-UNIT` SLS_ACCT_UNIT	Alpha 15	The general ledger account unit that will be credited as the revenue account when the add-on charge is assessed.	—
`OEM-SLS-ACCOUNT` SLS_ACCOUNT	Numeric 6	This is the general ledger account number that will be credited as the revenue account when the add-on charge is assessed.	—
`OEM-SLS-SUB-ACCT` SLS_SUB_ACCT	Numeric 4	The general ledger subaccount number that is credited as revenue when an add-on charge is assessed.	—
`OEM-OFF-ACCT-UNIT` OFF_ACCT_UNIT	Alpha 15	The general ledger account unit that will be credited as the offset to COGS when the add-on charge is assessed.	—
`OEM-OFF-ACCOUNT` OFF_ACCOUNT	Numeric 6	The general ledger account number that is credited as the offset to COGS when the add-on charge is assessed.	—
`OEM-OFF-SUB-ACCT` OFF_SUB_ACCT	Numeric 4	The general ledger subaccount that is credited as the offset to COGS when the add-on charge is posted to general ledger.	—
`OEM-CGS-ACCT-UNIT` CGS_ACCT_UNIT	Alpha 15	The account unit that will be debited as the COGS account unit when an add-on charge is assessed.	—
`OEM-CGS-ACCOUNT` CGS_ACCOUNT	Numeric 6	The general ledger account number that will be debited as the COGS account when the add-on charge is assessed.	—
`OEM-CGS-SUB-ACCT` CGS_SUB_ACCT	Numeric 4	The subaccount number that will be debited as the COGS subaccount number when an add-on charge is assessed.	—
`OEM-ACTIVE-FLAG` ACTIVE_FLAG	Alpha 1	Indicates the active status of the add-on charge. `A` Active `I` Inactive	—
`OEM-USED-FL` USED_FL	Alpha 1	Indicates whether the add-on charge has ever been used. `Y` Yes `N` No	WH20.7
`OEM-TRACK-TYPE` TRACK_TYPE	Alpha 1	" " = Other AOC `I` Insurance `F` Freight `C` Customs Charges	—

Indexes (2)

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
`OEMSET1`	`COMPANY`, `MISC`, `CURRENCY-CODE`	Primary		WH20.2, WH20.7
`OEMSET2`	`COMPANY`, `CURRENCY-CODE`, `MISC`			—

Relations

One to one (14) — lookups and parents

Relation	Table	Rules	Condition	Field map
Cucodes	CUCODES	Required	When OEM-CURRENCY-CODE != Spaces	`OEM-CURRENCY-CODE` → `CUC-CURRENCY-CODE`
Glchartcogs	GLCHARTDTL	Not Required	Valid When OEM-CGS-ACCT-UNIT != Spaces Or OEM-CGS-ACCOUNT != Zeroes Or OEM-CGS-SUB-ACCT != Zeroes	`GLS-CHART-NAME` → `GDT-CHART-NAME`, `GLM-SUMM-ACCT-ID` → `GDT-SUMRY-ACCT-ID`, `OEM-CGS-ACCOUNT` → `GDT-ACCOUNT`, `OEM-CGS-SUB-ACCT` → `GDT-SUB-ACCOUNT`
Glchartoffset	GLCHARTDTL	Not Required	Valid When OEM-OFF-ACCT-UNIT != Spaces Or OEM-OFF-ACCOUNT != Zeroes Or OEM-OFF-SUB-ACCT != Zeroes	`GLS-CHART-NAME` → `GDT-CHART-NAME`, `GLM-SUMM-ACCT-ID` → `GDT-SUMRY-ACCT-ID`, `OEM-OFF-ACCOUNT` → `GDT-ACCOUNT`, `OEM-OFF-SUB-ACCT` → `GDT-SUB-ACCOUNT`
Glchartsales	GLCHARTDTL	Not Required	Valid When OEM-SLS-ACCT-UNIT != Spaces Or OEM-SLS-ACCOUNT != Zeroes Or OEM-SLS-SUB-ACCT != Zeroes	`GLS-CHART-NAME` → `GDT-CHART-NAME`, `GLM-SUMM-ACCT-ID` → `GDT-SUMRY-ACCT-ID`, `OEM-SLS-ACCOUNT` → `GDT-ACCOUNT`, `OEM-SLS-SUB-ACCT` → `GDT-SUB-ACCOUNT`
Glmaster Cogs	GLMASTER	Required	When OEM-CGS-ACCT-UNIT != Spaces Or OEM-CGS-ACCOUNT != Zeroes Or OEM-CGS-SUB-ACCT != Zeroes	`OEM-COMPANY` → `GLM-COMPANY`, `OEM-CGS-ACCT-UNIT` → `GLM-ACCT-UNIT`, `OEM-CGS-ACCOUNT` → `GLM-ACCOUNT`, `OEM-CGS-SUB-ACCT` → `GLM-SUB-ACCOUNT`
Glmaster Offst	GLMASTER	Required	When OEM-OFF-ACCT-UNIT != Spaces Or OEM-OFF-ACCOUNT != Zeroes Or OEM-OFF-SUB-ACCT != Zeroes	`OEM-COMPANY` → `GLM-COMPANY`, `OEM-OFF-ACCT-UNIT` → `GLM-ACCT-UNIT`, `OEM-OFF-ACCOUNT` → `GLM-ACCOUNT`, `OEM-OFF-SUB-ACCT` → `GLM-SUB-ACCOUNT`
Glmaster Sales	GLMASTER	Required	When OEM-SLS-ACCT-UNIT != Spaces Or OEM-SLS-ACCOUNT != Zeroes Or OEM-SLS-SUB-ACCT != Zeroes	`OEM-COMPANY` → `GLM-COMPANY`, `OEM-SLS-ACCT-UNIT` → `GLM-ACCT-UNIT`, `OEM-SLS-ACCOUNT` → `GLM-ACCOUNT`, `OEM-SLS-SUB-ACCT` → `GLM-SUB-ACCOUNT`
Glsystem	GLSYSTEM	Required		`OEM-COMPANY` → `GLS-COMPANY`
Iccompany	ICCOMPANY	Required	When OEM-SALES-MAJCL != Spaces Or OEM-SALES-MINCL != Spaces	`OEM-COMPANY` → `ICC-COMPANY`
Majorcl	MAJORCL	Required	When OEM-SALES-MAJCL != Spaces Or OEM-SALES-MINCL != Spaces	`ICC-ITEM-GROUP` → `MAJ-ITEM-GROUP`, `"S"` → `MAJ-CLASS-TYPE`, `OEM-SALES-MAJCL` → `MAJ-MAJOR-CLASS`
Minorcl	MINORCL	Required	When OEM-SALES-MINCL != Spaces	`ICC-ITEM-GROUP` → `MIN-ITEM-GROUP`, `"S"` → `MIN-CLASS-TYPE`, `OEM-SALES-MAJCL` → `MIN-MAJOR-CLASS`, `OEM-SALES-MINCL` → `MIN-MINOR-CLASS`
Oecompany	OECOMPANY	Required		`OEM-COMPANY` → `OEC-COMPANY`
Poaocmast	POAOCMAST	Required	When OEM-AOC-CODE != Spaces	`OEM-COMPANY` → `PAM-COMPANY`, `OEM-AOC-CODE` → `PAM-AOC-CODE`
Txtaxcode	TXTAXCODE	Required	When OEM-TAX-CODE != Spaces	`OEM-COMPANY` → `TAC-COMPANY`, `OEM-TAX-CODE` → `TAC-TAX-CODE`

Programs

Updated by (1)

WH20.7 Substitute Location