|
|
OEMISC FILE
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).
REFERENCED BY
AC15.1 BL10.1 BL121 BL122 BL123 BL16.1
BL209 BL210 BL215 BL220 BL230 BL231
BL232 BL290 BL30.2 BL30.5 BL330 BL331
BL34.1 BL45.1 BL46.1 BL47.1 BL720 BL80.1
BL96D OE294 SA100 SA300
UPDATED BY
BL09.1 BL120 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL31.1 BL31.2 BL31.3
BL31.5 BL31.7 BL32.3 BL32.4 BL520 BL820
BL92.1 BL940 OE10.1 OE10.2 OE10.3 OE10.4
OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4
OE11.8 OE11.9 OE110 OE113 OE114 OE129
OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5
OE15.7 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5
OE30.6 OE30.7 OE30.9 OE510 OE810 OE830
OE920 OE950 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OEM-COMPANY Numeric 4 BL09.1
Company The company number represents an
established company and is entered on
all function codes.
OEM-MISC Alpha 16 BL09.1
Miscellaneous 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 Alpha 5 BL09.1
Currency Code The currency code indicating the
currency that will be used when the
add-on charge is assessed.
OEM-DESCRIPTION Alpha 30 (Lower Case) BL09.1 BL230
Description The description of the add-on charge. BL232 BL45.1
When the add-on charge is added to the BL46.1 BL47.1
order, this description will display on OE11.1 OE114
the form and print on invoices. OE129
OEM-ORD-DISC-FL Alpha 1 BL09.1
Order Discount Flag 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 Numeric 1 BL09.1
Charge Type 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 Alpha 2 BL09.1
Add On Cost Code 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 Signed 13.5 BL09.1
Unit Price 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 Percent 5.3 (Percent) BL09.1
Price Pct 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 Signed 15.2 BL09.1
Price The flat monetary amount to be charged
to the customer.
OEM-UNIT-COST Signed 13.5 BL09.1
Unit Cost 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 Percent 5.3 (Percent) BL09.1
Cost Pct 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 Signed 11.2 BL09.1
Cost The flat monetary amount to be posted
to cost of goods sold.
OEM-UPD-SA-FL Alpha 1 BL09.1
Upd Sa-Fl Determines whether the add-on charge
should update the Sales Analysis system
for reporting purposes.
N = No
Y = Yes
OEM-TAX-EXEMPT-CD Alpha 1 BL09.1
Tax Exempt Code 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 Alpha 10 BL09.1
Tax Code 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 Alpha 4 BL09.1
Sales Major Class 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 Alpha 4 BL09.1
Sales Minor Class 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 Alpha 15 BL09.1
Product Tax Category The product's tax category. Used to
override taxability by specific taxing
authority.
OEM-SLS-ACCT-UNIT Alpha 15 BL09.1
Sales Accounting The general ledger account unit that
Unit will be credited as the revenue account
when the add-on charge is assessed.
OEM-SLS-ACCOUNT Numeric 6 BL09.1
Sales Account 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 Numeric 4 BL09.1
Sales Subaccount The general ledger subaccount number
that is credited as revenue when an
add-on charge is assessed.
OEM-OFF-ACCT-UNIT Alpha 15 BL09.1
Offset Accounting The general ledger account unit that
Unit will be credited as the offset to COGS
when the add-on charge is assessed.
OEM-OFF-ACCOUNT Numeric 6 BL09.1
Offset Account The general ledger account number that
is credited as the offset to COGS when
the add-on charge is assessed.
OEM-OFF-SUB-ACCT Numeric 4 BL09.1
Offset Subaccount 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 Alpha 15 BL09.1
Cost Of Goods Sold The account unit that will be debited
Acct Unit as the COGS account unit when an add-on
charge is assessed.
OEM-CGS-ACCOUNT Numeric 6 BL09.1
Cost Of Goods Sold The general ledger account number that
Account will be debited as the COGS account when
the add-on charge is assessed.
OEM-CGS-SUB-ACCT Numeric 4 BL09.1
Cost Of Goods Sold The subaccount number that will be
Subaccount debited as the COGS subaccount number
when an add-on charge is assessed.
OEM-ACTIVE-FLAG Alpha 1 BL09.1
Status Indicates the active status of the
add-on charge.
A = Active
I = Inactive
OEM-USED-FL Alpha 1 BL09.1 BL120
Used Indicates whether the add-on charge has BL130 BL20.1
ever been used. BL20.3 BL21.2
Y = Yes BL21.5 BL29.1
N = No BL29.2 BL31.1
BL31.2 BL31.3
BL31.5 BL31.7
BL32.3 BL32.4
BL520 BL820
BL92.1 BL940
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
WH20.7
OEMISC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OEMSET1 COMPANY AC15.1 BL09.1
MISC BL10.1 BL120
CURRENCY-CODE BL121 BL122
BL123 BL130
BL16.1 BL20.1
BL20.3 BL209
BL21.2 BL21.5
BL210 BL215
BL220 BL230
BL231 BL232
BL29.1 BL29.2
BL290 BL30.2
BL30.5 BL31.1
BL31.2 BL31.3
BL31.5 BL31.7
...
OEMSET2 COMPANY
CURRENCY-CODE
MISC
OEMISC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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 -> x u� u� �( -SUMRY-ACCT-ID
OEM-CGS-ACCOUNT -> x u� u� �( -ACCOUNT
OEM-CGS-SUB-ACCT -> x u� u� �( -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
|