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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICM-MANUF-ID
Element: Manuf Id
Numeric 4
A unique idenitifier for a manufacturer
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.
ICM-NAME
Element: Name
Alpha 30 (Lower Case)
Displays the company description.
ICM-EDI-NBR
Element: Edi Nbr
Alpha 15
ICM-RPT-FREQ
Element: Rpt Freq
Numeric 1
Identifies the frequency or time boundry for reporting
0 = Daily
1 = Weekly
2 = Monthly
ICM-NXT-RPT-DT
Element: Nxt Rpt Dt
Numeric 8 (yyyymmdd)
Contains the last date that will be reported.
ICM-NON-INV-ITEM
Element: Non Inv Item
Numeric 1

0 = Exclude
1 = Include
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
ICM-SORT-SEQ
Element: Sort Seq
Numeric 1
Establishes the report detail sort sequence.
0 = By Date
1 = By Item
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
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
ICM-CURRENCY-CD
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).


ICMANUF FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICMSET1 ITEM-GROUP
MANUF-ID
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: Wed Jun 08 20:49:38 2016

Home
Contact Us



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