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
BL00.1 BL122 BL200 BL80.1 IC01.1 IC01.4
IC05.1 IC06.1 IC07.1 IC08.1 IC09.1 IC10.1
IC10.2 IC11.1 IC110 IC13.1 IC14.1 IC16.4
IC18.1 IC191 IC200 IC201 IC205 IC206
IC207 IC208 IC209 IC210 IC211 IC212
IC213 IC236 IC260 IC30.1 IC35.1 IC36.1
IC39.1 IC531 IC60.1 IC60.2 IC60.3 IC61.1
IC65.1 IC811 PC08.1 MA00.1 MA00.2 MA00.3
MA00.4 MA200 OE110 OE112 OE113 OE114
OE129 OE55.1 OE55.2 PO120 PO121 PO123
PO130 PO220 PO230 PO813 RQ250 SEA2.1
WH02.1 WH130 WH224 WO131
UPDATED BY
DR100 IC00.1 IC00.2 IC00.3 IC141 IC142
IC83.1 IC990 RQ10.1 RQ10.3 RQ11.1 RQ20.1
RQ35.1 RQ500 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITG-ITEM-GROUP Alpha 5 IC00.1 IC00.2
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
Description This field contains the description of
the item group.
ITG-AUDIT-ITEM-FL Alpha 1 IC00.1
Audit Item Master This field contains the option to audit
Flag 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
Default Nbr This field contains the default value
Decimals for Cost for the number of decimal places in cost
fields.
ITG-DEF-DEC-PRICE Numeric 1 IC00.1
Default Nbr This field contains the default value
Decimals for Price for the number of decimal places in the
price fields.
ITG-COM-TYPE Alpha 1 Occurs 10 Times IC00.2
Comment Type This field contains valid item comment
types for this item group.
ITG-COM-TYPE-DESC Alpha 10 (Lower Case) IC00.2
Comment Type Occurs 10 Times
Description This field contains descriptions of
comment types.
ITG-IC210.html">COM-OPT-IC210 Alpha 1 Occurs 10 Times IC00.3
Comment Option for These fields determine which comment
IC210 types are printed on Item Master Listing
(IC210).
X = Selected
ITG-IC211.html">COM-OPT-IC211 Alpha 1 Occurs 10 Times IC00.3
Comment Option for These fields determine which comment
IC211 types are printed on Item Location
Listing (IC211).
X = Selected
ITG-IC110.html">COM-OPT-IC110 Alpha 1 Occurs 10 Times IC00.3
Comment Option for These fields determine which comment
IC110 types are printed on Intransit Shipping
(IC110).
X = Selected
ITG-AUTO-REQ-FL Alpha 1 IC00.1 IC990
Automatic This flag specifies if the requisition
Requisitioning Flag numbers are to be assigned automatically
by the computer or manually entered.
Valid values are:
"Y" = Assigned automatically.
"N" = Manually entered.
ITG-LAST-REQ-NBR Numeric 7 DR100 IC00.1
Last Req Nbr This is the last automatically assigned IC141 IC142
requisition number. IC83.1 IC990
RQ10.1 RQ10.3
RQ11.1 RQ20.1
RQ35.1 RQ500
WH20.7
ITEMGROUP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ITGSET1 ITEM-GROUP BL00.1 BL122
BL200 BL80.1
DR100 IC00.1
IC00.2 IC00.3
IC01.1 IC01.4
IC05.1 IC06.1
IC07.1 IC08.1
IC09.1 IC10.1
IC10.2 IC11.1
IC110 IC13.1
IC14.1 IC141
IC142 IC16.4
IC18.1 IC191
IC200 IC201
IC205 IC206
...
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
|