ICMANUF FILE
The manufacturer table is used to identify entites requesting the product
transfer and resale report. In addition this table is used to establish
reporting options.
REFERENCED BY
PO00.1
UPDATED BY
IC153 IC34.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICM-MANUF-ID Numeric 4 IC34.1
Element: Manuf Id A unique idenitifier for a manufacturer
ICM-ITEM-GROUP Alpha 5 IC34.1
Element: Item Group This field contains the identifier for
a group of items that can be shared by
one or more companies.
ICM-NAME Alpha 30 (Lower Case) IC34.1
Element: Name Displays the company description.
ICM-EDI-NBR Alpha 15 IC34.1
Element: EDI Number
ICM-RPT-FREQ Numeric 1 IC34.1
Element: Rpt Freq Identifies the frequency or time boundry
for reporting
0 = Daily
1 = Weekly
2 = Monthly
ICM-NXT-RPT-DT Numeric 8 (yyyymmdd) IC153 IC34.1
Element: Nxt Rpt Dt Contains the last date that will be
reported.
ICM-NON-INV-ITEM Numeric 1 IC34.1
Element: Non Inv Item 0 = Exclude
1 = Include
ICM-DETAIL-OPTION Numeric 1 IC34.1
Element: Detail Option Provides the option to select the level
of detail(or roll up) that will be
reported.
0 = Net Daily
1 = Net Period
2 = Detail
ICM-SORT-SEQ Numeric 1 IC34.1
Element: Sort Seq Establishes the report detail sort
sequence.
0 = By Date
1 = By Item
ICM-UOM-OPTION Numeric 1 IC34.1
Element: Uom Option Determies which Unit of measure will be
used fro reporting purposes.
0 = Issue Uom
1 = Buy Uom
ICM-DECIMAL-HNDL Numeric 1 IC34.1
Element: Decimal Hndl Identifies option for handling decimal
values that may be calculated for a
quantity.
0 = Report Decimal
1 = Truuncate
ICM-CURRENCY-CD Alpha 5 IC34.1
Element: Currency Code
ICMANUF FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICMSET1 ITEM-GROUP IC153 IC34.1
MANUF-ID IC34.2 IC34.3
PO00.1
ICMANUF FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Mfgshpfac MFGSHPFAC
ICM-ITEM-GROUP -> MFG-ITEM-GROUP
ICM-MANUF-ID -> MFG-MANUF-ID
MFG-ST-FACILITY
|
