Table Name:offering_grp
Table Number:5760
Group:Morder
Description:A group of products within an offering
Flags: 
Baseline/Custom:Baseline
Fields:
Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsCommentField Used in Views
descriptionCHARvarchar 255  Marketing text used to describe offering presented to the customer. Typically used as help to the agent or presented to the customer  
devLONGint151 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
idCHARvarchar 40  Id of offering group, populated from the numbering scheme  
is_commonLONGtinyint  DIRECT, ALLOW_NULL Indicates that the offering group can be shared between offerings; 1=Yes, 0=No;Default=0 Search (6)
is_exclusiveLONGtinyint  DIRECT Whether the items in the group are exclusive of each other; 1=exclusive, 0=non exclusive; default 0 Search (3)
is_finalLONGtinyint  DIRECT, ALLOW_NULL Indicates whether the offering group is final or can be edited; 1=Yes, 0=No;Default= 0)  
is_mandatoryLONGtinyint  DIRECT Whether customer has to select something from the group; 1=Yes, 0=No; default=0 Search (3)
last_updateCLK_TIMEdatetime46   Date time of last update  
max_itemsLONGint  DIRECT The maximum number of different items that can be selected from the group;default = 1 Search (3)
min_itemsLONGint  DIRECT The minimum number of different items that must be selected from the group;default = 1 Search (3)
nameCHARvarchar 30  Name of an offering group Search (3)
objidLONGint3  DIRECT Internal record number Search (8)
versionLONGint   DIRECT, ALLOW_NULL The version of the offering, starting at 1 Search (3)
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in Views
offering_grp2offeringMTOofferingoffering2offering_grpOffering related to an offering group. Replaced by role table. Reserved, obsolete   Search (2)
child2offering_grpMTOoffering_grpparent2offering_grpChild offer group. Replaced by role table. Reserved, obsolete    
parent2offering_grpOTMoffering_grpchild2offering_grpParent offer group. Replaced by role table. Reserved, obsolete    
parent2offr_grp_grp_roleOTMoffr_grp_grp_roleparent_grp2offering_grpSubgroups of the offering group    
child2offr_grp_grp_roleOTMoffr_grp_grp_rolechild_grp2offering_grpGroups containing the group    
offr_grp2offr_grp_roleOTMoffr_grp_roleoffr_grp_role2offering_grpOfferings that use the group    
offering_grp2offr_prodOTMoffr_prodoffr_prod2offering_grpProducts in the group    
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
Indexes (Defined in Database):
Index NameFieldsAdditional Information
id5760idnonclustered located on PRIMARY
objindexobjidclustered, unique located on PRIMARY
My Recent Objects
offering_grp