ICITEMGTIN

Inventory Item for GTIN

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

REFERENCED BY
IC00.1 IC11.1 IC11.7 IC20.2 IC21.2 IC218
IC22.2 IC24.2 IC26.2 IC511 IC800 MA278
PO130 PO132 PO137 PO223 PO254 PO33.1
PO34.1 PO54.3 PO54.4 PO54.5 POIE.1 RQ111
RQIC.1 RQIG.1 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
AP510 API1.1 API2.1 CX100 CX20.1 CX20.2
CX20.4 CX20.5 CX220 CX30.1 CX300 CX506
CXCP.1 DR100 IC12.1 IC140 IC141 IC142
IC145 IC243 IC30.2 IC330 IC500 IC64.1
IC64.2 IC64.3 IC64.4 IC64.5 IC64.6 IC64.7
IC64.8 IC64.9 IC66.1 IC83.1 MA180 MA41.1
MA41.2 MA41.4 MA41.7 MA42.2 MA43.2 MA43.7
MA44.1 MA44.2 MA53.1 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 PD570 PO04.1 PO04.2 PO10.1 PO10.2
PO100 PO101 PO115 PO120 PO122 PO131
PO136 PO15.1 PO15.2 PO15.4 PO16.1 PO16.2
PO17.1 PO190 PO20.1 PO20.6 PO20.9 PO204
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO22.3 PO22.4 PO220 PO222 PO224 PO225
PO229 PO23.1 PO230 PO234 PO24.1 PO251
PO27.2 PO27.3 PO27.4 PO275 PO276 PO277
PO280 PO29.1 PO30.1 PO30.2 PO30.3 PO30.4
PO300 PO31.1 PO31.2 PO32.2 PO32.4 PO35.1
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 PO560 POCP.1 POI3.1 POID.1 POII.1
POIJ.1 RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ10.4
RQ10.5 RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ35.1
RQ44.1 RQ500 RQ810 RQIB.1 RQIF.1 RQII.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
IC522 IC523 IC524 IC525 IC526 IC527
PO550 RQID.1


UPDATED BY
ICI9.1 PO150 PO25.6 PO25.7 PO26.4 PO26.5
PO26.8 PO28.2 PO36.2 PO536

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 the 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 the 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 the 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
This is the unit of measure for the depth dimension of the trade item.
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. For example, Water 750ml - net content = "750 MLT"; 20 count pack of diapers, net content = "20 ea.". In cases of multi-pack, this indicates the net content of the total trade item. For fixed value trade items use the value claimed on the package, to avoid variable fill rate issue that arises with some trade item which are sold by volume or weight, and whose actual content may vary slightly from batch to batch. In cases of variable quantity trade items, this indicates the average quantity.
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
Ths is used to identify the gross weight of the trade item. The gross weight includes all packaging materials of the trade item. At the pallet level the trade item gross weight includes the weight of the pallet itself. For example, "200 grm", value - total pounds, total grams, etc. This has 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 despatch 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 isa n 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 isa n 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 a 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, volume. The trade item is used or traded in continuous rather than discrete quantities.
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
This is an indication whether the base trade item is batch or lot number requested by law, not batch or lot number requested by law but batch or lot number allocated, or not batch or lot number allocated. A batch or lot number is a manufacturer assigned code used to identify a trade item's trade item on batch or lot. This differs from Serial Number which is a manufacturer assigned code during the trade item on cycle to identify a unique trade item.
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
This is the GTIN of the parent trade item of the current item in a GTIN hierarchy.
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 on which the information contents of the master data version are valid. This 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 mark 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 data provider is not necessarily the source of the data, but has the responsibility to provide and maintain the data in the catalogue.
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
This is period of days, guaranteed by the manufacturer, before the expiration date of the product, based on the production.
GTI-SHELF-LIFE-DEL
Element: Shelf Life
Numeric 4
This is period of days, guaranteed by the manufacturer, before the expiration date of the trade item, based on arrival to a mutually agreed to point in the buyers distribution system.
GTI-RECYCLABLE
Element: Boolean
Numeric 1
This indicates whether the trade item has a recyclable indication marked on it. This may be a symbol from one of many regional agencies.
GTI-RETURN-UNSOLD
Element: Boolean
Numeric 1
This indicates whether the trade item has returnable packaging. This is a yes/no (Boolean) where yes equals package can be returned. This attribute applies to returnable packaging with or without deposit.
GTI-LATEX-IND
Element: Boolean
Numeric 1
This indicates whether a trade item is made from or contains latex which refers generically to a stable dispersion (emulsion) of polymer microparticles in an aqueous medium.
0 = Unspecified
1 = Package indicates Latex
2 = Package doesn't indicate Latex
3 = Not Applicable
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-REUSABILITY-CD
Element: Reusability Cd
Numeric 1

0 = Undefined
1 = Single Use
2 = Reusable
3 = Limited Reuse
4 = Reusable for Same Patient
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
GTI-LONG-DESC
Element: Description3
Alpha 350 (Lower Case)
ICI9.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536


ICITEMGTIN FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GTISET1 ITEM-GROUP
ITEM
GTIN
...
IC00.1 IC11.1
IC11.7 IC20.2
IC21.2 IC218
IC22.2 IC24.2
IC26.2 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
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
GTISET3 ITEM-GROUP
ITEM
UOM
GTIN
IC11.1 IC20.2
IC21.2 IC22.2
IC24.2 IC522
IC523 IC524
IC525 IC526
IC527 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 02:18:41 2016

Home
Contact Us



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