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
IC01.1 IC01.4 IC02.1 IC05.1 IC06.1 IC07.1
IC08.1 IC09.1 IC10.1 IC10.2 IC11.1 IC11.2
IC11.3 IC11.4 IC11.5 IC11.6 IC11.7 IC110
IC12.1 IC13.1 IC14.1 IC140 IC141 IC142
IC145 IC15.2 IC153 IC16.1 IC175 IC18.1
IC183 IC191 IC196 IC20.1 IC20.2 IC200
IC201 IC205 IC206 IC207 IC208 IC209
IC21.1 IC21.2 IC210 IC211 IC212 IC213
IC216 IC218 IC22.1 IC22.2 IC223 IC23.1
IC236 IC24.1 IC24.2 IC243 IC25.1 IC258
IC260 IC30.1 IC30.2 IC320 IC330 IC331
IC34.1 IC35.1 IC36.1 IC39.1 IC500 IC503
IC511 IC512 IC524 IC558 IC56.1 IC58.1
IC58.2 IC60.1 IC60.2 IC60.3 IC61.1 IC62.1
IC64.1 IC64.2 IC64.3 IC64.4 IC64.5 IC64.6
IC64.7 IC64.8 IC64.9 IC65.1 IC66.1 IC81.1
IC811 IC812 IC82.1 IC83.1 IC840 IC91.1
IC91.4 ICI4.1 ICI5.1 ICI6.1 ICI7.1 ICI8.1
ICI9.1 ICIC.1 ICIG.1 PC08.1 MA180 MA278
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 PO00.1 PO04.1 PO04.2
PO10.1 PO10.2 PO100 PO101 PO115 PO120
PO122 PO130 PO131 PO132 PO136 PO137
PO15.1 PO15.2 PO15.4 PO150 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 PO25.1 PO25.5 PO25.6
PO25.7 PO251 PO26.3 PO26.4 PO26.5 PO26.7
PO26.9 PO27.2 PO27.3 PO27.4 PO275 PO276
PO277 PO28.1 PO28.2 PO280 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 POA2.3
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 RQ250 RQ35.1 RQ44.1
RQ500 RQ810 RQIA.1 RQIB.1 RQID.1 RQIF.1
RQIH.1 RQII.1 RQIJ.1 WH02.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


UPDATED BY
IC00.1 IC00.2 IC00.3

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
ITG-UOM-EDIT-FLAG
Element: Flag Num
Numeric 1

0 = Prevent UOM changes
1 = Allow UOM change
IC00.1
ITG-AUTO-UPD-GLN
Element: Flag Num
Numeric 1
Set this flag to 1 (Yes) to automatically create work units when a GLN is added, updated, or deleted.
0 = No
1 = Yes
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 02:18:57 2016

Home
Contact Us



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