ICITEMGTIN

This table contains the Global Trade Item Numbers (GTIN) and related information.

REFERENCED BY
IC00.1 MA278 PO130 PO132 PO137 PO223
PO254 POIE.1 RQ111


UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 API2.1
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CXCP.1 DR100 IC11.1
IC11.7 IC140 IC218 IC30.2 IC511 IC66.1
IC800 IC83.1 ICI9.1 MA180 MA41.1 MA41.2
MA41.4 MA41.7 MA42.2 MA43.2 MA43.7 MA44.1
MA44.2 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA66.2 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1
PD10.2 PD130 PD20.1 PD20.2 PD20.3 PO100
PO101 PO122 PO131 PO136 PO150 PO16.1
PO16.2 PO190 PO20.1 PO20.6 PO20.9 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO22.3
PO22.4 PO23.1 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO26.4 PO26.5 PO26.8 PO27.2 PO28.2
PO29.1 PO30.1 PO30.2 PO30.3 PO30.4 PO300
PO31.1 PO31.2 PO32.2 PO32.4 PO33.1 PO34.1
PO35.1 PO36.1 PO36.2 PO38.1 PO39.1 PO39.2
PO44.1 PO50.1 PO52.1 PO520 PO536 PO54.5
PO550 PO560 POCP.1 POI3.1 POID.1 POII.1
POIJ.1 RQ10.1 RQ10.2 RQ10.4 RQ12.1 RQ13.1
RQ13.2 RQ35.1 RQ500 RQIC.1 RQID.1 RQIF.1
RQIG.1 RQIJ.1 WH130 WH132 WH190 WH20.2
WH20.7 WH222 WH30.1 WH30.2 WH30.3 WH30.4
WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2
WH32.3 WH32.4 WH32.5 WH33.1 WH33.2 WH33.3
WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1
WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520
WH830 ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GTI-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.
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO26.8 PO28.2
PO36.2 PO536
GTI-ITEM
Element: Item
Alpha 32
This field contains the item identifier.
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO26.8 PO28.2
PO36.2 PO536
GTI-GTIN
Element: Gtin
Numeric 14
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO26.8 PO28.2
PO36.2 PO536
GTI-UOM
Element: Uom
Alpha 4
This field contains the unit of measure associated with this trade item. This must be a valid UOM for the associated item on the item master.
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO26.8 PO28.2
PO36.2 PO536
GTI-STATUS
Element: Status
Numeric 1
This is status of this trade item.
0 = Active
1 = Inactive
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-GTIN-STRUCTURE
Element: Gtin Structure
Numeric 1

0 = GTIN-8
1 = GTIN-12
2 = GTIN-13
3 = GTIN-14
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-COUNTRY-CODE
Element: Country Code
Alpha 2
This is the country code that identifies the target market. The target market is at country level or higher geographical definition and is where a trade item is intended to be sold.
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-GPC-SEGMENT
Element: Gpc Segment
Alpha 2
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-GPC-FAMILY
Element: Gpc Family
Alpha 2
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-GPC-CLASS
Element: Gpc Class
Alpha 2
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-GPC-BRICK
Element: Gpc Brick
Alpha 8
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-ICSEGMENT
Element: Icsegment
Alpha 2
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-ICFAMILY
Element: Icfamily
Alpha 2
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-ICCLASS
Element: Icclass
Alpha 2
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-ICCOMMODITY
Element: Iccommodity
Alpha 2
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-BRAND-NAME
Element: Brand Name
Alpha 35 (Lower Case)
The recognizable name used by a brand owner to uniquely identify a line of trade items or services. This is recognizable by the consumer.
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-FUNCTIONAL-NME
Element: Functional Nme
Alpha 35 (Lower Case)
This describes the use of the product or service by the consumer.
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-ABBREV-DESC
Element: Abbrev Desc
Alpha 30 (Lower Case)
This is a free-form abbreviated description of the trade item that can be used to identify the trade item at point-of-sale or robotic distribution systems.
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO26.8 PO28.2
PO36.2 PO536
GTI-FULL-DESC
Element: Full Desc
Alpha 40 (Lower Case)
This is the full description of the trade item, including variants.
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO26.8 PO28.2
PO36.2 PO536
GTI-HEIGHT-MEASURE
Element: Measurement
Signed 14.4
This is measurement of the height of the trade item, the vertical dimension from the lowest extremity to the highest extremity, including packaging. At a pallet level the trade item height will include the height of the pallet itself. Business Rules: Measurements are relative to how the customer normally views the trade item. This needs to be associated with a valid UOM.
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-HEIGHT-UOM
Element: Uom
Alpha 4
This is the unit of measure for the height dimension of the trade item.
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-WIDTH-MEASURE
Element: Measurement
Signed 14.4
This is measurement from left to right of the trade item. Measurements are relative to how the customer normally views the trade item. This needs to be associated with a valid UOM.
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-WIDTH-UOM
Element: Uom
Alpha 4
This is the unit of measure for the width dimension of the trade item.
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-DEPTH-MEASURE
Element: Measurement
Signed 14.4
This is measurement from front to back of the trade item. Measurements are relative to how the customer normally views the trade item. This needs to be associated with a valid UOM.
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-DEPTH-UOM
Element: Uom
Alpha 4
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-NET-CONTENT
Element: Measurement
Signed 14.4
This is the amount of the trade item contained by a package, usually as claimed on the label. In the case of multi-packs, it indicates the net content of the total trade item. For fixed value trade items, it is the value claimed on the package, to avoid variable fill rate issues that arise with some trade items which are sold by volume or weight and whose actual content may vary slightly from batch to batch. In the case of variable quantity trade items, it indicates the average quantity. This needs to be associated with a valid UOM.
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-CONTENT-UOM
Element: Uom
Alpha 4
This is the unit of measure for the net content amount of the trade item.
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-GROSS-WEIGHT
Element: Measurement
Signed 14.4
This is used to identify the gross weight of the trade item. The gross weight includes all packaging materials of the trade item. At pallet level the trade item gross weight includes the weight of the pallet itself. This needs to be associated with a valid UOM.
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-GR-WEIGHT-UOM
Element: Uom
Alpha 4
This is the unit of measure for the gross weight of the trade item.
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-NET-WEIGHT
Element: Measurement
Signed 14.4
This is used to identify the net weight of the trade item and applies to all levels but the base level. The net weight excludes all packaging materials of the trade item. For the base unit, the net content measure replaces the net weight. This needs to be associated with a valid UOM.
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-NET-WEIGHT-UOM
Element: Uom
Alpha 4
This is the unit of measure for the net weight of the trade item.
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-CONSUMER-UNIT
Element: Boolean
Numeric 1
This identifies whether the current hierarchy level of a trade item is intended for ultimate consumption. For retail, this trade item will be scanned at point-of-sale. At retail, this data is commonly used to select which GTINs should be used for shelf planning and for front end POS databases. This value reflects the intention of the Information Provider which may not necessarily be reflected by the retailer. This is Boolean where Yes (1) indicates the trade item is a consumer unit.
0 = No
1 = Yes
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-ORDERABLE-UNIT
Element: Boolean
Numeric 1
This is an indicator identifying that the information provider considers this trade item to be at a hierarchy level where they will accept orders from customers. This may be different from what the information provider identifies as a dispatch unit. This may be a relationship dependent based on channel of trade or other point to point agreement. This is a Boolean where Yes (1) indicates the trade item is an ordering unit.
0 = No
1 = Yes
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-INVOICE-UNIT
Element: Boolean
Numeric 1
This is an indicator identifying that the information provider will include this trade item on their billing or invoice. This may be relationship dependent based on channel of trade or other point-to-point agreement. This is a Boolean where Yes (1) indicates the trade item is an invoicing unit.
0 = No
1 = Yes
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-SHIPPING-UNIT
Element: Boolean
Numeric 1
This is an indicator identifying that the information provider considers the trade item as a dispatch (shipping) unit. This may be relationship dependent based on channel of trade or other point to point agreement. This is Boolean where Yes (1) indicates the trade item is a dispatch unit.
0 = No
1 = Yes
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-BASE-UNIT
Element: Boolean
Numeric 1
This is an indicator identifying the trade item as the base unit level of the trade item hierarchy. This is a Boolean where Yes (1) indicates the trade item is a base unit.
0 = No
1 = Yes
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-VARIABLE-UNIT
Element: Boolean
Numeric 1
This indicates that an article is not a fixed quantity, but that the quantity is variable. It can be weight, length or volume. The trade item is used or traded in continuous rather than discrete quantities. This is a Boolean where Yes (1) indicates the trade item is a variable unit.
0 = No
1 = Yes
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-BAR-CODE-TYPE
Element: Bar Code Type
Numeric 2
This is an indication if the trade item is physically bar-coded with the primary trade item identification number.
00 = No Barcode
01 = Composite Component A
02 = Composite Component B
03 = Composite Component C
04 = EAN/UCC 13 Symbol
05 = EAN/UCC 14 Symbol
06 = EAM/UCC 8 Symbol
07 = ITF 14 Symbol
08 = RSS 14
09 = RSS 14 Stacked
10 = RSS14 Stacked Omni-Directional
11 = RSS 14 Truncated
12 = RSS Expanded
13 = RSS Expanded Stacked
14 = RSS Limited
15 = UCC EAM 128 Symbol
16 = UPC A Symbol
17 = UPC E Symbol
99 = Other
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-BATCH-LOT-REQ
Element: Batch Lot Req
Numeric 1

0 = No Batch/Lot Number Required
1 = Batch/Lot Exists & Req by law
2 = Batch/Lot Exists But Not Req
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-RETURNABLE
Element: Boolean
Numeric 1
This is an indication whether the trade item has returnable packaging. This is a Boolean where Yes (1) applies to returnable packaging with or without deposit.
0 = No
1 = Yes
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-DIET-ALLERGEN
Element: Diet Allergen
Numeric 2

00 = None
01 = Approved for Tube Feeding
02 = Contains PVC
03 = Contains PVC with Phthalates
04 = Contains PVC W/O Phthalates
05 = Diet Product - 450-800 KCAL
06 = Diet Product - 800-1200 KCAL
07 = Lactase Enzyme
08 = Low on Phenylalanine
09 = Low Sugar
10 = Mothers Milk Substitute
11 = Nutrition Supplement
12 = Contains Latex
99 = Other
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-STERILE-IND
Element: Sterile Ind
Numeric 2

00 = None
01 = Sterile
02 = Extremely Clean
99 = Other
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-PARENT-GTIN
Element: Gtin
Numeric 14
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-DATE-AVAILABLE
Element: Date
Numeric 8 (yyyymmdd)
This is the date from which the trade item becomes available from the supplier, including seasonal or temporary trade items and services. This does not address backorder situations.
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-TIME-AVAILABLE
Element: Time
Numeric 8
This is the time at which the trade item becomes available from the supplier, including seasonal or temporary trade item and services.
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-EFFECTIVE-DATE
Element: Date
Numeric 8 (yyyymmdd)
This is the date on which the information contents of the master data version are valid. The effective date can be used for initial trade item offering or to mark a change in the information related to an existing trade item. This date would indicate when these changes take effect.
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-EFFECTIVE-TIME
Element: Time
Numeric 8
This is the time at which the information contents of the master data version are valid. The effective time can be used for initial trade item offering or to mark a change in the information related to an existing trade item. This time would indicate when these changes take effect.
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-PUBLICATION-DT
Element: Date
Numeric 8 (yyyymmdd)
This is the date on which all static data associated with the trade item becomes available for viewing and synchronization.
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-PUBLICATION-TM
Element: Time
Numeric 8
This is the time at which all static data associated with the trade item becomes available for viewing and synchronization.
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-BRAND-OWNR-GLN
Element: Gln Nbr
Alpha 13
This is the GLN for the brand owner of the trade item.
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-PROVIDER-GLN
Element: Gln Nbr
Alpha 13
This is the GLN for the information provider of the trade item. The information provider refers to the trading partner who is responsible for the GTIN message/information. GTINs may be published by multiple partners depending on their trading relationship.
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-MANUF-CODE
Element: Manuf Code
Alpha 4
This field contains a user defined code that indicates the manufacturer of an item.
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO26.8 PO28.2
PO36.2 PO536
GTI-MANUF-DIVISION
Element: Manuf Division
Alpha 4
This is a user defined code that indicates which division of a manufacturer is tied to an item.
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO26.8 PO28.2
PO36.2 PO536
GTI-MANUF-NBR
Element: Manuf Nbr
Alpha 35
This is the identifier that the manufacturer has assigned to an item.
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO26.8 PO28.2
PO36.2 PO536
GTI-SHELF-LIFE-PRD
Element: Shelf Life
Numeric 4
GTI-SHELF-LIFE-DEL
Element: Shelf Life
Numeric 4
GTI-RECYCLABLE
Element: Boolean
Numeric 1
GTI-RETURN-UNSOLD
Element: Boolean
Numeric 1


ICITEMGTIN FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GTISET1 ITEM-GROUP
ITEM
GTIN
IC00.1 IC11.1
IC11.7 IC218
IC511 IC800
ICI9.1 MA278
PO130 PO132
PO137 PO150
PO223 PO25.6
PO25.7 PO254
PO26.4 PO26.5
PO26.8 PO28.2
PO33.1 PO34.1
PO36.2 PO536
PO54.3 PO54.4
POIE.1 RQ111
RQIC.1 RQIG.1
GTISET2 ITEM-GROUP
GTIN
ITEM
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC11.7
GTISET3 ITEM-GROUP
ITEM
UOM
GTIN
IC11.1 ICI9.1
PO150 PO16.1
PO16.2 PO20.1
PO23.1 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO30.1 PO36.2
PO536 PO550
RQ10.1
GTISET4 ITEM-GROUP
PARENT-GTIN
GTIN
ITEM
Subset
WherePARENT-GTIN !=Zeroes
IC30.2 ICI9.1
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
GTISET5 ITEM-GROUP
ICSEGMENT
ICFAMILY
ICCLASS
ICCOMMODITY
GTIN
ITEM
Subset
WhereICSEGMENT !=Spaces
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTISET6 ITEM-GROUP
GPC-SEGMENT
GPC-FAMILY
GPC-CLASS
GPC-BRICK
ITEM
GTIN
Subset
WhereGPC-SEGMENT !=Spaces
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTISET7 ITEM-GROUP
MANUF-CODE
MANUF-DIVISION
MANUF-NBR
ITEM
UOM
GTIN
Subset
WhereMANUF-CODE !=Spaces
AndMANUF-NBR !=Spaces
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536 RQIC.1
RQID.1 RQIF.1
RQIG.1 RQIJ.1


ICITEMGTIN FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Brandownergln GLNLOC Not Required
Valid When GTI-BRAND-OWNR-GLN !=Spaces
GTI-ITEM-GROUP->GLO-ITEM-GROUP
GTI-BRAND-OWNR-GLN->GLO-GLN-NBR
Icitemcode ICITEMCODE Not Required
Valid When GTI-ICSEGMENT !=Spaces
GTI-ITEM-GROUP->IIC-ITEM-GROUP
GTI-ICSEGMENT->IIC-ICSEGMENT
GTI-ICFAMILY->IIC-ICFAMILY
GTI-ICCLASS->IIC-ICCLASS
GTI-ICCOMMODITY->IIC-ICCOMMODITY
Icmanfcode ICMANFCODE Not Required
GTI-ITEM-GROUP->IMC-ITEM-GROUP
GTI-MANUF-CODE->IMC-MANUF-CODE
GTI-MANUF-DIVISION->IMC-MANUF-DIVISION
Instctrycd INSTCTRYCD Not Required
GTI-COUNTRY-CODE->INT-COUNTRY-CODE
Itemgroup ITEMGROUP Required
GTI-ITEM-GROUP->ITG-ITEM-GROUP
Itemmast ITEMMAST Required
GTI-ITEM-GROUP->ITE-ITEM-GROUP
GTI-ITEM->ITE-ITEM
Parentgtin ICITEMGTIN Not Required, Delete Cascades
GTI-ITEM-GROUP->GTI-ITEM-GROUP
GTI-PARENT-GTIN->GTI-PARENT-GTIN
GTI-GTIN->GTI-GTIN
GTI-ITEM->GTI-ITEM
Procuregrp PROCUREGRP Required
GTI-ITEM-GROUP->PCG-ITEM-GROUP
Providergln GLNLOC Not Required
Valid When GTI-PROVIDER-GLN !=Spaces
GTI-ITEM-GROUP->GLO-ITEM-GROUP
GTI-PROVIDER-GLN->GLO-GLN-NBR


ICITEMGTIN FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Icitemgpc ICITEMGPC
Valid When GTI-GPC-SEGMENT !=Spaces
GTI-ITEM-GROUP->GPC-ITEM-GROUP
GTI-GPC-SEGMENT->GPC-SEGMENT
GTI-GPC-FAMILY->GPC-FAMILY
GTI-GPC-CLASS->GPC-CLASS
GTI-GPC-BRICK->GPC-BRICK
  GPC-ATTRIBUTE-TYPE
  GPC-ATTRIBUTE-VAL
Poitemven POITEMVEN
Valid When GTI-MANUF-CODE !=Spaces
AndGTI-MANUF-NBR !=Spaces
PCG-PROCURE-GROUP->PIV-PROCURE-GROUP
GTI-MANUF-CODE->PIV-MANUF-CODE
GTI-MANUF-DIVISION->PIV-MANUF-DIVISION
GTI-MANUF-NBR->PIV-MANUF-NBR
GTI-ITEM->PIV-ITEM
  PIV-VBUY-UOM
  PIV-VENDOR
  PIV-VEN-ITEM


File created: Thu Jun 09 11:16:58 2016

Home
Contact Us



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