ICITEMGTIN – Inventory Item for GTIN

System: Inventory Control (IC)
Prefix: GTI
Primary key: ITEM-GROUP, ITEM, GTIN
Fields: 61
Updated by: 10 programs
Referenced by: 242 programs

ICITEMGTIN is the Inventory Item for GTIN table in Lawson Inventory Control (prefix GTI). It is indexed by ITEM-GROUP, ITEM, GTIN (GTISET1); alternate indexes: GTISET2, GTISET3, GTISET4, GTISET5, GTISET6 and GTISET7. It is related 1:1 to GLNLOC, ICITEMCODE, ICMANFCODE, INSTCTRYCD, ITEMGROUP, ITEMMAST, ICITEMGTIN and PROCUREGRP and 1:M to ICITEMGPC and POITEMVEN. It is updated by ICI9.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8, PO28.2 and 2 more and referenced by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 234 more. The table has 61 fields, 7 indexes and 11 documented relations.

About ICITEMGTIN

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

Fields (61)

Column = COBOL field name without the GTI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`GTI-ITEM-GROUP` PK 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 +2 more
`GTI-ITEM` PK ITEM	Alpha 32	This field contains the item identifier.	ICI9.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8, PO28.2 +2 more
`GTI-GTIN` PK GTIN	Numeric 14	—	ICI9.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8, PO28.2 +2 more
`GTI-UOM` 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 +2 more
`GTI-STATUS` 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 +1 more
`GTI-GTIN-STRUCTURE` 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 +1 more
`GTI-COUNTRY-CODE` 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 +1 more
`GTI-GPC-SEGMENT` GPC_SEGMENT	Alpha 2	—	ICI9.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2, PO36.2 +1 more
`GTI-GPC-FAMILY` GPC_FAMILY	Alpha 2	—	ICI9.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2, PO36.2 +1 more
`GTI-GPC-CLASS` GPC_CLASS	Alpha 2	—	ICI9.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2, PO36.2 +1 more
`GTI-GPC-BRICK` GPC_BRICK	Alpha 8	—	ICI9.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2, PO36.2 +1 more
`GTI-ICSEGMENT` ICSEGMENT	Alpha 2	—	ICI9.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2, PO36.2 +1 more
`GTI-ICFAMILY` ICFAMILY	Alpha 2	—	ICI9.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2, PO36.2 +1 more
`GTI-ICCLASS` ICCLASS	Alpha 2	—	ICI9.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2, PO36.2 +1 more
`GTI-ICCOMMODITY` ICCOMMODITY	Alpha 2	—	ICI9.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2, PO36.2 +1 more
`GTI-BRAND-NAME` 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 +1 more
`GTI-FUNCTIONAL-NME` 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 +1 more
`GTI-ABBREV-DESC` 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 +2 more
`GTI-FULL-DESC` 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 +2 more
`GTI-HEIGHT-MEASURE` HEIGHT_MEASURE	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 +1 more
`GTI-HEIGHT-UOM` HEIGHT_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 +1 more
`GTI-WIDTH-MEASURE` WIDTH_MEASURE	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 +1 more
`GTI-WIDTH-UOM` WIDTH_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 +1 more
`GTI-DEPTH-MEASURE` DEPTH_MEASURE	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 +1 more
`GTI-DEPTH-UOM` DEPTH_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 +1 more
`GTI-NET-CONTENT` NET_CONTENT	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 +1 more
`GTI-CONTENT-UOM` CONTENT_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 +1 more
`GTI-GROSS-WEIGHT` GROSS_WEIGHT	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 +1 more
`GTI-GR-WEIGHT-UOM` GR_WEIGHT_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 +1 more
`GTI-NET-WEIGHT` NET_WEIGHT	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 +1 more
`GTI-NET-WEIGHT-UOM` NET_WEIGHT_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 +1 more
`GTI-CONSUMER-UNIT` CONSUMER_UNIT	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 +1 more
`GTI-ORDERABLE-UNIT` ORDERABLE_UNIT	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 +1 more
`GTI-INVOICE-UNIT` INVOICE_UNIT	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 +1 more
`GTI-SHIPPING-UNIT` SHIPPING_UNIT	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 +1 more
`GTI-BASE-UNIT` BASE_UNIT	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 +1 more
`GTI-VARIABLE-UNIT` VARIABLE_UNIT	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 +1 more
`GTI-BAR-CODE-TYPE` 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 +1 more
`GTI-BATCH-LOT-REQ` 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 +1 more
`GTI-RETURNABLE` RETURNABLE	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 +1 more
`GTI-DIET-ALLERGEN` 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 +1 more
`GTI-STERILE-IND` 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 +1 more
`GTI-PARENT-GTIN` PARENT_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 +1 more
`GTI-DATE-AVAILABLE` DATE_AVAILABLE	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 +1 more
`GTI-TIME-AVAILABLE` TIME_AVAILABLE	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 +1 more
`GTI-EFFECTIVE-DATE` EFFECTIVE_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 +1 more
`GTI-EFFECTIVE-TIME` EFFECTIVE_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 +1 more
`GTI-PUBLICATION-DT` PUBLICATION_DT	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 +1 more
`GTI-PUBLICATION-TM` PUBLICATION_TM	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 +1 more
`GTI-BRAND-OWNR-GLN` BRAND_OWNR_GLN	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 +1 more
`GTI-PROVIDER-GLN` PROVIDER_GLN	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 +1 more
`GTI-MANUF-CODE` 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 +2 more
`GTI-MANUF-DIVISION` 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 +2 more
`GTI-MANUF-NBR` 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 +2 more
`GTI-SHELF-LIFE-PRD` SHELF_LIFE_PRD	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` SHELF_LIFE_DEL	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` RECYCLABLE	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` RETURN_UNSOLD	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` LATEX_IND	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 +1 more
`GTI-REUSABILITY-CD` 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 +1 more
`GTI-LONG-DESC` LONG_DESC	Alpha 350 (Lower Case)	—	ICI9.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2, PO36.2 +1 more

Indexes (7)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`GTISET1`	`ITEM-GROUP`, `ITEM`, `GTIN`	Primary		IC00.1, IC11.1, IC11.7, IC20.2, IC21.2, IC218, IC22.2, IC24.2 +22 more (list truncated in source)
`GTISET2`	`ITEM-GROUP`, `GTIN`, `ITEM`			AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
`GTISET3`	`ITEM-GROUP`, `ITEM`, `UOM`, `GTIN`			IC11.1, IC20.2, IC21.2, IC22.2, IC24.2, IC522, IC523, IC524 +19 more
`GTISET4`	`ITEM-GROUP`, `PARENT-GTIN`, `GTIN`, `ITEM`	Subset	Where PARENT-GTIN != Zeroes	IC30.2, ICI9.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2 +2 more
`GTISET5`	`ITEM-GROUP`, `ICSEGMENT`, `ICFAMILY`, `ICCLASS`, `ICCOMMODITY`, `GTIN`, `ITEM`	Subset	Where ICSEGMENT != Spaces	ICI9.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2, PO36.2 +1 more
`GTISET6`	`ITEM-GROUP`, `GPC-SEGMENT`, `GPC-FAMILY`, `GPC-CLASS`, `GPC-BRICK`, `ITEM`, `GTIN`	Subset	Where GPC-SEGMENT != Spaces	ICI9.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2, PO36.2 +1 more
`GTISET7`	`ITEM-GROUP`, `MANUF-CODE`, `MANUF-DIVISION`, `MANUF-NBR`, `ITEM`, `UOM`, `GTIN`	Subset	Where MANUF-CODE != Spaces And MANUF-NBR != Spaces	ICI9.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2, PO36.2 +6 more

Relations

One to one (9) — lookups and parents

Relation	Table	Rules	Condition	Field map
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`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
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 And GTI-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`

Programs

Updated by (10)

ICI9.1 Item GTIN Invoke Object
PO150 Bid Load to Contract or Catalog
PO25.6 Vendor Agreement Line
PO25.7 Service Agreement Line
PO26.4 Vendor Agreement Line Price Breaks
PO26.5 Vendor Agreement Line Price Breaks
PO26.8 Update Vendor Agreement Line for Special Item
PO28.2 Vendor Agreement Line Detail List
PO36.2 Vendor Agreement Import Manual Input
PO536 Vendor Price Agreement Load

Referenced by (242)

AP125 Batch Release
AP126 Mass Invoice Release
AP131 Chargeback
AP20.1 Basic Invoice
AP20.2 Taxed Invoice
AP20.3 Detail Invoice
AP20.4 Invoice Line Detail
AP20.5 Multiple Invoice
AP20.7 Distributions
AP21.1 View Distributions
AP23.1 Transit Invoice Entry
AP25.1 Batch Control
AP25.2 Batch Review
AP26.1 Invoice Release
AP27.1 Single Invoice Release
AP30.4 Invoice Cancel
AP510 Vendor Conversion
API1.1 Add Invoice
API2.1 Add Invoice
CX100 Pick List Print
CX20.1 Case Build
CX20.2 Case Detail
CX20.4 Substitute Items
CX20.5 Insert line
CX220 Case, Preference Listing
CX30.1 Case Completion Feedback
CX300 Preference List Purge
CX506 HL7 Schedules Import Interface
CXCP.1 Copy preference to case
DR100 Distribution Requirements Report
IC00.1 Corporate Item Group
IC11.1 Item Master
IC11.7 Global Trade Item Number
IC12.1 Item Location
IC140 Vendor Reorder Advice
IC141 Location Replenishment Report
IC142 Replenishment by Requisition PO's
IC145 Stock Status Report
IC20.2 Detail Receipts
IC21.2 Detail Issues
IC218 GTIN Listing
IC22.2 Detail Transfer
IC24.2 Detail Adjustments
IC243 Killed Item Report
IC26.2 Bin Transfer by Serial
IC30.2 GTIN Inquiry
IC330 Item Mass Change
IC500 Transaction Interface
IC511 Item Master-Item Location Extr
IC522 HL7 Item Master - Atwork
IC523 HL7 Item Master - OmniCell
IC524 CSV Item Master
IC525 HL7 Item Master Interface
IC526 HL7 Item Master - McKesson
IC527 HL7 Item Master - DeRoyal
IC64.1 Global Location Nbr Assignment GL/IC Company
IC64.2 Global Location Nbr Assignment IC Location
IC64.3 Global Location Number Assignment RQ Location
IC64.4 Global Location Number Assignment Manuf Code
IC64.5 Global Location Number Assignment Manuf Div
IC64.6 Global Location Number Assignment Vendor
IC64.7 Global Location Number Assignment Vendor Location
IC64.8 Global Location Number Assignment IC Bin
IC64.9 Global Location Number Assignment Buyer
IC66.1 Replenishment PO Worksheet
IC800 Keyword Search Load
IC83.1 Par Location Counts
MA180 Open Receipt Archive
MA278 Cost Variance Analysis
MA41.1 Add-On Cost Detail - Purchase Order
MA41.2 Add On Cost Lookup
MA41.4 Miscellaneous Add-On Cost
MA41.7 AOC Approval Entry
MA42.2 Memo Line AOC Detail
MA43.2 Purchase Order Lookup
MA43.7 GL Distribution
MA44.1 Invoice Line Detail - Purchase Order
MA44.2 Invoice Line Detail- Service
MA53.1 Receipt Interface
MA530 ERS Invoice Creation
MA531 Receipt Interface
MA60.2 Invoice Level Match
MA60.3 Detail Level Match
MA60.5 Receipt Match Reference Adjustment
MA61.1 Match Invoice Approval
MA66.2 Invoice Message - Details
MA67.2 Invoice Match from frontend
MA67.3 Detail Match from frontend
MA68.2 Invoice Level Match - Prepaid
MA68.3 Detail Level Match - Prepaid
MA68.5 Receipt Match Reference Adjustment
MA70.1 Invoice Unmatch
MA75.1 PO Invoice Cancel
MA80.1 Receipt Archive
MAI1.1 Invoke for MAMATCH Object
PD10.1 P-Card Card Request
PD10.2 P-Card Cardholder
PD130 P-Card Invoice and Release
PD20.1 P-Card Charge Approval
PD20.2 P-Card Charge Approval Level
PD20.3 P-Card Charge Approval SEA
PD570 P-Card Charge Import
PO04.1 Buyer
PO04.2 Buyer Purchasing Class
PO10.1 PO Vendor
PO10.2 Vendor Purchase From Location
PO100 Purchase Order Interface from Lawson Applications
PO101 Create Standing PO Release
PO115 Procurement Template Mass Changes
PO120 Mass PO Issue
PO122 Transmitted PO Acknowledgement
PO130 Receiving Document
PO131 Receiving Log
PO132 Print Vendor Return Material Authorization
PO136 Matched, Not Received Report
PO137 Agreement Cost Update
PO15.1 Procurement Templates
PO15.2 Procurement Template Participants
PO15.4 Procurement Template Line Detail
PO16.1 Bid
PO16.2 Bid Response
PO17.1 Purchase Order Approval Review
PO190 Close Purchase Order Header
PO20.1 Purchase Order Entry
PO20.6 Substitute Vendor Items
PO20.9 Multiple Lines
PO204 Buyer Master Listing
PO21.1 Select and Copy
PO21.2 Add-On Cost Spread
PO21.3 Account Distribution
PO21.4 Miscellaneous Add-On Cost
PO21.5 Item Add-On Cost
PO22.1 Authorization, Release
PO22.3 Mass Cancel or Delete Purchase Orders
PO22.4 Mass Cancel or Delete Purchase Order Lines
PO220 PO Status Report
PO222 Remaining PO Balance Report
PO223 Buyer Expediting Report
PO224 PO Revision Report
PO225 Vendor Agreement Listing
PO229 Vendor Agreement Format Print
PO23.1 Purchase Order Worksheet
PO230 Unreleased Receivings Listing
PO234 PO Interface Listing Report
PO24.1 Purchase Order Direct Approval
PO251 PO Buyer Message Listing
PO254 PO Inquiry Report
PO27.2 Select Blanket Lines
PO27.3 Create PO From Procurement Template
PO27.4 Select and Copy Template
PO275 Delivery Date Analysis
PO276 Deliver Quantity Analysis
PO277 Deliver Quality Analysis
PO280 Purchases By Class
PO29.1 Copy Purchase Order
PO30.1 PO Receiving
PO30.2 Substitute Item
PO30.3 Additional Tracking Numbers
PO30.4 PO Receiving Line Detail List
PO300 PO and Receipt Purge
PO31.1 Vendor Return
PO31.2 Vendor Return Item Selection
PO32.2 Item Detail
PO32.4 Cancel Detail
PO33.1 Receiving Adjustment
PO34.1 Inspection Accept or Reject
PO35.1 Receiving Approval and Release
PO38.1 Invoice AOC
PO39.1 Additional Receiving Entry
PO39.2 Additional Adjustment/Rejection Entry
PO44.1 PO Line Source
PO50.1 Buyer Message Entry
PO52.1 Buyer Message - Receiving
PO520 Purchase Order Interface from Non Lawson
PO54.3 Purchase Order Inquiry
PO54.4 Purchase Order Inquiry
PO54.5 PO Line Detail List
PO550 Bid Creation
PO560 Bid Response Load
POCP.1 POC Comments Copy
POI3.1 Invoke for POPI70PD
POID.1 PO Delivery Ticket Select
POIE.1 Delivery Ticket Report
POII.1 Invoke for POPCRUPD
POIJ.1 Invoke for POPLIUPD
RQ01.1 Requesting Locations
RQ10.1 Requisition
RQ10.2 Account Distribution
RQ10.3 Select and Copy
RQ10.4 Requisition Line Entry Detail
RQ10.5 Substitutes
RQ11.1 Kit Accessories
RQ111 Print Requisitions
RQ12.1 Approval Review
RQ13.1 Direct Approval
RQ13.2 Direct Line Approval
RQ35.1 Requisition Returns
RQ44.1 Requisition Inquiry
RQ500 Requisition Interface
RQ810 Request Location Load
RQIB.1 RQRQHUPD Invoke Object
RQIC.1 Get Item List Invoke Object
RQID.1 RQRQHUPD Invoke Object
RQIF.1 RQRLNUPD Invoke Object
RQIG.1 Get Shopping List Invoke Object
RQII.1 Invoke for Reqheader Inquiry
RQIJ.1 Requisition Copy
WH130 Pick List Print
WH132 Batch Feedback
WH190 Shipment Release
WH20.2 Nonstock and Special Allocation
WH20.7 Substitute Location
WH222 Shipments In Process
WH30.1 Picking Feedback by Document
WH30.2 Picking Feedback by Shipment
WH30.3 Picking by Batch
WH30.4 Bin Sequence Picking Feedback
WH31.1 Packing Feedback by Document
WH31.2 Packing Feedback by Shipment
WH31.3 Packing by Batch
WH31.4 Bin Sequence Packing Feedback
WH32.1 Shipping Feedback by Document
WH32.2 Shipping Feedback by Shipment
WH32.3 Shipping by Batch
WH32.4 Bin Sequence Shipping Feedback
WH32.5 Shipping Line Feedback
WH33.1 Bins
WH33.2 Lots
WH33.3 Serials
WH33.4 UOMs
WH33.5 Additional Shipment Information
WH33.6 Catch Weight
WH33.8 Preassembled Kits
WH33.9 Line Options
WH34.1 Component Bins
WH34.2 Component Lots
WH34.3 Component Serials
WH34.4 Component UOMs
WH40.1 Bill of Lading
WH40.2 Bill of Lading Feedback
WH520 Batch Feedback Interface
WH830 Shipment Load Program