ITEMGROUP

Item Group

The Item Group file stores the names of valid item groups. This file allows companies to share Item Master records or to keep them separate by company.

REFERENCED 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 AP510 API1.1
API2.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 DR100
IC05.1 IC06.1 IC07.1 IC08.1 IC10.1 IC10.2
IC11.1 IC11.2 IC11.3 IC11.4 IC11.5 IC11.6
IC11.7 IC110 IC13.1 IC14.1 IC140 IC141
IC142 IC153 IC16.1 IC18.1 IC191 IC210
IC211 IC212 IC213 IC216 IC218 IC260
IC30.1 IC30.2 IC330 IC36.1 IC503 IC511
IC512 IC558 IC56.1 IC60.1 IC60.2 IC60.3
IC61.1 IC64.1 IC64.2 IC64.3 IC64.4 IC64.5
IC64.6 IC64.7 IC64.8 IC64.9 IC65.1 IC66.1
IC811 IC83.1 IC91.1 ICI4.1 ICI5.1 ICI6.1
ICI7.1 ICI8.1 ICI9.1 ICIC.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 PO130 PO131 PO136
PO137 PO150 PO190 PO20.1 PO20.6 PO20.9
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO22.3 PO22.4 PO220 PO23.1 PO230 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO26.4 PO26.5
PO27.2 PO28.1 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 PO560 POCP.1 POI3.1
POID.1 POII.1 POIJ.1 RQ10.1 RQ10.2 RQ10.3
RQ10.4 RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ250
RQ35.1 RQ500 RQIA.1 RQID.1 RQIF.1 RQIH.1
RQIJ.1 WH130 WH132 WH190 WH20.2 WH20.7
WH222 WH224 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 IC01.1 IC01.4 IC09.1 IC200
IC201 IC205 IC206 IC207 IC208 IC209
IC236 IC258 IC34.1 IC35.1 IC39.1 IC58.1
IC58.2 ICIG.1 PC08.1 PO00.1 POA2.3 WH02.1


UPDATED BY
IC00.1 IC00.2 IC00.3 IC00.5

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITG-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.
IC00.1 IC00.2
IC00.3
ITG-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field contains the description of the item group.
IC00.1
ITG-AUDIT-ITEM-FL
Element: All Flag
Alpha 1
This field contains the option to audit all changes made to items in the Item Master file for an item group.
N = No
Y = Yes
IC00.1
ITG-DEF-DEC-COST
Element: Def Dec Cost
Numeric 1
This field contains the default value for the number of decimal places in cost fields.
0
1
2
3
4
5
IC00.1
ITG-DEF-DEC-PRICE
Element: Def Dec Cost
Numeric 1
This field contains the default value for the number of decimal places in the price fields.
0
1
2
3
4
5
IC00.1
ITG-COM-TYPE
Element: Com Type
Alpha 1 Occurs 10 Times
This field contains valid item comment types for this item group.
IC00.2
ITG-COM-TYPE-DESC
Element: Bin Type Desc
Alpha 10 (Lower Case)
Occurs 10 Times
This field contains descriptions of comment types.
IC00.2
ITG-COM-OPT-IC210
Element: Com Opt Ic110
Alpha 1 Occurs 10 Times
These fields determine which comment types are printed on Item Master Listing (IC210).
X = Print Comments
IC00.3
ITG-COM-OPT-IC211
Element: Com Opt Ic110
Alpha 1 Occurs 10 Times
These fields determine which comment types are printed on Item Location Listing (IC211).
X = Print Comments
IC00.3
ITG-COM-OPT-IC110
Element: Com Opt Ic110
Alpha 1 Occurs 10 Times
These fields determine which comment types are printed on Intransit Shipping (IC110).
X = Print Comments
IC00.3
ITG-DEF-ITEM-CR-FL
Element: Def Item Cr Fl
Alpha 1
Default item create flag is needed for the creation of new item numbers when importing vendor catalogs in PO536 or manually entering price agreements in PO25. If no Item Create Flag is supplied during the creation of an agreement, this value will default. Valid values are, 1 to create the next sequential item number, 2 to assign the item number from another field, and 3 to manually input the new item number.
1 = Sequential
2 = Assign
3 = Manual Input
IC00.1
ITG-DEF-ITEM-AS-FL
Element: Item Asgn Fld
Alpha 1
If the item create flag is set to assign, this indicates the field from which the new item number is assigned.
" " = None
1 = VENDOR-ITEM
2 = MFG-ITEM
3 = UPC
4 = SKU
5 = HIBCC-UPN
6 = UCCEAN-UPN
7 = NDC
ITG-COMM-STRUCTURE
Element: Comm Structure
Alpha 20
IC00.1


ITEMGROUP FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ITGSET1 ITEM-GROUP
...
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


ITEMGROUP FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company ICCOMPANY Delete Restricted
ITG-ITEM-GROUP->ICC-ITEM-GROUP
  ICC-COMPANY
Glnloc GLNLOC
ITG-ITEM-GROUP->GLO-ITEM-GROUP
  GLO-GLN-NBR
Hazardcode HAZARD Delete Restricted
ITG-ITEM-GROUP->HAZ-ITEM-GROUP
  HAZ-HAZARD-CODE
Icvaluom ICVALUOM
ITG-ITEM-GROUP->ICV-ITEM-GROUP
  ICV-VALID-UOM
Inv Class MAJORCL Delete Restricted
ITG-ITEM-GROUP->MAJ-ITEM-GROUP
"I"->MAJ-CLASS-TYPE
  MAJ-MAJOR-CLASS
Itemmaster ITEMMAST Delete Restricted
ITG-ITEM-GROUP->ITE-ITEM-GROUP
  ITE-ITEM
Purch Class MAJORCL Delete Restricted
ITG-ITEM-GROUP->MAJ-ITEM-GROUP
"P"->MAJ-CLASS-TYPE
  MAJ-MAJOR-CLASS
Sales Class MAJORCL Delete Restricted
ITG-ITEM-GROUP->MAJ-ITEM-GROUP
"S"->MAJ-CLASS-TYPE
  MAJ-MAJOR-CLASS


File created: Thu Jun 09 11:17:13 2016

Home
Contact Us



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