ICMANUF

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
Element: Manuf Id
Numeric 4
A unique idenitifier for a manufacturer
IC34.1
ICM-ITEM-GROUP
Element: Item Group
Alpha 5
This field contains the identifier for a group of items that can be shared by one or more companies.
IC34.1
ICM-NAME
Element: Name
Alpha 30 (Lower Case)
Displays the company description.
IC34.1
ICM-EDI-NBR
Element: Edi Nbr
Alpha 15
IC34.1
ICM-RPT-FREQ
Element: Rpt Freq
Numeric 1
Identifies the frequency or time boundry for reporting
0 = Daily
1 = Weekly
2 = Monthly
IC34.1
ICM-NXT-RPT-DT
Element: Nxt Rpt Dt
Numeric 8 (yyyymmdd)
Contains the last date that will be reported.
IC153 IC34.1
ICM-NON-INV-ITEM
Element: Non Inv Item
Numeric 1

0 = Exclude
1 = Include
IC34.1
ICM-DETAIL-OPTION
Element: Detail Option
Numeric 1
Provides the option to select the level of detail(or roll up) that will be reported.
0 = Net Daily
1 = Net Period
2 = Detail
IC34.1
ICM-SORT-SEQ
Element: Sort Seq
Numeric 1
Establishes the report detail sort sequence.
0 = By Date
1 = By Item
IC34.1
ICM-UOM-OPTION
Element: Uom Option
Numeric 1
Determies which Unit of measure will be used fro reporting purposes.
0 = Issue Uom
1 = Buy Uom
IC34.1
ICM-DECIMAL-HNDL
Element: Decimal Hndl
Numeric 1
Identifies option for handling decimal values that may be calculated for a quantity.
0 = Report Decimal
1 = Truuncate
IC34.1
ICM-CURRENCY-CD
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
IC34.1


ICMANUF FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICMSET1 ITEM-GROUP
MANUF-ID
IC153 IC34.1
IC34.2 IC34.3
PO00.1


ICMANUF FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Mfgshpfac MFGSHPFAC
ICM-ITEM-GROUP->MFG-ITEM-GROUP
ICM-MANUF-ID->MFG-MANUF-ID
  MFG-ST-FACILITY


File created: Thu Jun 09 11:17:03 2016

Home
Contact Us



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