| objid | child_offr_prod(offr_prod) | objid | Offering product internal record number | 3 (UNIQUE) |
| min_number | child_offr_prod(offr_prod) | min_number | Minimum number of product / option that must be taken up in the offering. Default=1 | |
| max_number | child_offr_prod(offr_prod) | max_number | Maximum number of product / option that must be taken up in the offering. Default=1 | |
| description | child_offr_prod(offr_prod) | description | Offering product description | |
| parent_objid | parent_offr_prod(offr_prod) | objid | Offering product internal record number | |
| part_num_objid | part_num | objid | Part_num internal record number | |
| part_number | part_num | part_number | Part number/name | |
| dom_at_bus_org | part_num | is_dom_at_bus_org | Part_num internal record number | |
| price_qty_objid | price_qty | objid | Price_qty internal record number | |
| mod_level | child_mod_level(mod_level) | mod_level | Name of part revision | |
| child_mod_level_objid | child_mod_level(mod_level) | objid | Child mod_level internal record number | |
| offering_grp_objid | child_offering_grp(offering_grp) | objid | Offering group internal record number | |
| offering_grp_grp_objid | offr_grp_grp_role | objid | Offering group internal record number | |
| parent_group_objid | parent_offering_grp(offering_grp) | objid | Offering group internal record number | |
| is_mandatory | child_offr_prod(offr_prod) | is_mandatory | Whether product is mandatory in the group;1=Yes, 0=No;default=0 | |
| is_common | child_offering_grp(offering_grp) | is_common | Indicates that the offering group can be shared between offering | |