|
|
ITEMGROUP FILE
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 API1.1 BL00.1
BL120 BL122 BL130 BL20.1 BL20.3 BL200
BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL80.1
BL820 BL92.1 IC01.1 IC01.4 IC05.1 IC06.1
IC07.1 IC08.1 IC09.1 IC11.1 IC11.2 IC11.3
IC11.4 IC11.5 IC11.6 IC13.1 IC14.1 IC16.1
IC18.1 IC200 IC201 IC205 IC206 IC207
IC208 IC209 IC210 IC211 IC212 IC213
IC236 IC30.1 IC330 IC39.1 IC811 ICI4.1
ICI5.1 ICI6.1 ICI7.1 ICI8.1 ICIC.1 ICIG.1
MA180 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.7 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA66.2 MA66.3 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 PO00.1 PO100 PO101 PO122
PO130 PO131 PO137 PO150 PO20.1 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO220
PO23.1 PO230 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO27.2 PO28.1 PO29.1 PO30.1 PO30.2
PO30.3 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 PO560 POA2.3 POCP.1 POI3.1 POID.1
POII.1 POIJ.1 RQ10.1 RQ10.2 RQ10.3 RQ11.1
RQ250 RQ35.1 RQ500 RQIA.1 RQID.1 RQIF.1
RQIH.1 RQIJ.1 WH02.1 WH130 WH20.2 WH20.7
WH224
UPDATED BY
IC00.1 IC00.2 IC00.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITG-ITEM-GROUP Alpha 5 IC00.1 IC00.2
Element: Item Group This field contains the identifier for IC00.3
a group of items that can be shared by
one or more companies.
ITG-DESCRIPTION Alpha 30 (Lower Case) IC00.1
Element: Description This field contains the description of
the item group.
ITG-AUDIT-ITEM-FL Alpha 1 IC00.1
Element: All Flag 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
ITG-DEF-DEC-COST Numeric 1 IC00.1
Element: Def Dec Cost This field contains the default value
for the number of decimal places in cost
fields.
0
1
2
3
4
5
ITG-DEF-DEC-PRICE Numeric 1 IC00.1
Element: Def Dec Cost This field contains the default value
for the number of decimal places in the
price fields.
0
1
2
3
4
5
ITG-COM-TYPE Alpha 1 Occurs 10 Times IC00.2
Element: Com Type This field contains valid item comment
types for this item group.
ITG-COM-TYPE-DESC Alpha 10 (Lower Case) IC00.2
Element: Bin Type Desc Occurs 10 Times
This field contains descriptions of
comment types.
ITG-IC210.html">COM-OPT-IC210 Alpha 1 Occurs 10 Times IC00.3
Element: Com Opt Ic110 These fields determine which comment
types are printed on Item Master Listing
(IC210).
X = Print Comments
ITG-IC211.html">COM-OPT-IC211 Alpha 1 Occurs 10 Times IC00.3
Element: Com Opt Ic110 These fields determine which comment
types are printed on Item Location
Listing (IC211).
X = Print Comments
ITG-COM-OPT-IC110 Alpha 1 Occurs 10 Times IC00.3
Element: Com Opt Ic110 These fields determine which comment
types are printed on Intransit Shipping
(IC110).
X = Print Comments
ITG-DEF-ITEM-CR-FL Alpha 1 IC00.1
Element: Def Item Cr FlDefault 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
ITG-DEF-ITEM-AS-FL Alpha 1
Element: Item Asgn Fld 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 Alpha 20 IC00.1
Element: Comm Structure
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
API1.1 BL00.1
BL120 BL122
BL130 BL20.1
BL20.3 BL200
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL80.1
...
ITEMGROUP FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company ICCOMPANY Delete Restricted
ITG-ITEM-GROUP -> ICC-ITEM-GROUP
ICC-COMPANY
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
|
