Manufacturer Relationship
This table is used to associate defined ship to facilities (ICFACILITY) with a manufacturer for the purpose of generating the product transfer and resale report.
REFERENCED BY
IC34.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
MFG-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. |
|
||
MFG-MANUF-ID Element: Manuf Id | Numeric 4 A unique idenitifier for a manufacturer |
|
||
MFG-ST-FACILITY Element: St Facility | Alpha 15 A unique identifier for a ship to facility. |
|
||
MFG-NAME Element: Name | Alpha 30 (Lower Case) Displays the company description. |
|
||
MFG-MANUF-FAC-ID Element: Manuf Fac Id | Alpha 15 Stores a manufacturer supplied ship to facility id for use on the product transfer and resale report EDI transaction N1 segment. |
|
||
MFG-ADDR1 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||
MFG-ADDR2 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||
MFG-ADDR3 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||
MFG-ADDR4 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||
MFG-CITY-ADDR5 Element: City | Alpha 18 (Lower Case) This field contains the city of the address. |
|
||
MFG-STATE-PROV Element: State Prov | Alpha 2 The state or province. |
|
||
MFG-POSTAL-CODE Element: Postal Code | Alpha 10 (Lower Case) This field contains the postal code. |
|
||
MFG-COUNTRY-CODE Element: Country Code | Alpha 2 The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance). |
|
||
MFG-COUNTY Element: County | Alpha 25 (Lower Case) The county for the company address. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
MFGSET1 |
ITEM-GROUP MANUF-ID ST-FACILITY |
|
|||||||||
MFGSET2 |
ITEM-GROUP ST-FACILITY MANUF-ID |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
---|---|---|---|---|---|---|---|---|
Icmanuf | ICMANUF |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Icfacility | ICFACILITY |
|
All trademarks and registered trademarks are the property of their
respective owners.