Customer Order Misc Charges

This file stores customer order add-on charges. These add-on charges can be added to an order during entry or any time during the processing stage until the order has been processed through OE129 (Daily Shipment Journal).
UPDATED BY

WH20.7

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
OEM-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.
OEM-MISC Element: 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 Element: Currency Code	Alpha 5 The currency code indicating the currency that will be used when the add-on charge is assessed.
OEM-DESCRIPTION Element: 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 Element: 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 Element: 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 Element: 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 Element: Intl Cost	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 Element: Cost 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 Element: Intl Amt	Signed 18.2 The flat monetary amount to be charged to the customer.
OEM-UNIT-COST Element: Intl 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 Element: 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 Element: Intl Cost	Signed 18.5 The flat monetary amount to be posted to cost of goods sold.
OEM-UPD-SA-FL Element: All Flag	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 Element: 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 Element: 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 Element: Major Class	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 Element: Minor Class	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 Element: Prod Tax Cat	Alpha 15 The product's tax category. Used to override taxability by specific taxing authority.
OEM-SLS-ACCT-UNIT Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: Active Flag	Alpha 1 Indicates the active status of the add-on charge. A = Active I = Inactive
OEM-USED-FL Element: Used Fl	Alpha 1 Indicates whether the add-on charge has ever been used. Y = Yes N = No	WH20.7
OEM-TRACK-TYPE Element: Aoc Type	Alpha 1 " " = Other AOC I = Insurance F = Freight C = Customs Charges

OEMISC FILE INDEX

OEMISC FILE RELATIONS

ONE TO ONE RELATIONS

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