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 ICI9.1 ICIG.1 MA41.1 MA41.2 MA41.4
MA41.7 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6
MA43.7 MAI1.1 PO00.1 PO136 PO190 PO300
PO520 POCP.1 POI3.1 POII.1 POIJ.1

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.
ITG-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field contains the description of the item group.
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
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
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
ITG-COM-TYPE
Element: Com Type
Alpha 1 Occurs 10 Times
This field contains valid item comment types for this item group.
ITG-COM-TYPE-DESC
Element: Bin Type Desc
Alpha 10 (Lower Case)
Occurs 10 Times
This field contains descriptions of comment types.
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
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
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
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
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


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 ICI9.1
ICIG.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6


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
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: Wed Jun 08 20:49:39 2016

Home
Contact Us



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