| Table Name: | rollup |
| Table Number: | 5236 |
| Group: | Info Retrieval |
| Description: | Idenfities a hierarchical structure e.g., organization chart, inventory location chart, which may be used to summarize information |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| description | CHAR | varchar | 255 | Description of the rollup | ||||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile50 distribution purposes | ||
| focus_type | LONG | smallint | DIRECT | Object type ID of the object type for the rollup; e.g., 173=bus_org, 228=inv_locatn, 5002=territory | ||||
| is_default | LONG | tinyint | 22 | 0 | DIRECT | Determines, within focus_type, if the rollup is the default i.e., 0=no, 1=yes, default=0 | ||
| name | CHAR | varchar | 80 | Name of the rollup | Search (7) | |||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (9) | ||
| rollup_ind | LONG | int | DIRECT, ALLOW_NULL | Used for read-only account hierarchy | Search (3) | |||
| rollup_type | LONG | tinyint | 1 | DIRECT | Contraints on the rollup, i.e., 1=only single parent allowed, 2=multiple parents allowed, 3=duplicate indirect children allowed | Search (4) | ||
| use_type | LONG | smallint | DIRECT | Used within focus_type to signal how a rollup on a particular object is used by the application; e.g., for inventory locations (228) 1=counting for inventory counts, 2=physical - for zone management, 3=reporting for reporting operational metrics | Search (1) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| dflt_blg_hrchy2bus_org | OTM | bus_org | dflt_blg_hrchy2rollup | This will enable us to retrieve all accounts associated with a hierarchy and use that as a filter for other objects of interest | |||
| rollup2bus_rol_itm | OTM | bus_rol_itm | bus_itm2rollup | Bus_org items used in the rollup | |||
| rollup2con_rol_itm | OTM | con_rol_itm | con_itm2rollup | Contact items used in the rollup | |||
| rollup2cycle_count | OTM | cycle_count | ccount2rollup | Cycle counts which are using the rollup | |||
| rollup2loc_rol_itm | OTM | loc_rol_itm | loc_itm2rollup | Inventory location items used in the rollup | |||
| rollup2opp_rol_itm | OTM | opp_rol_itm | opp_itm2rollup | Opportunity items used in the rollup | |||
| cyc_rollup2part_auth | OTM | part_auth | part_auth2rollup | For rollups servicing zone management, the primary part_auth (for a part authorization and inv_bin) for the entire zone | |||
| rollup2ter_rol_itm | OTM | ter_rol_itm | ter_itm2rollup | Territory items used in the rollup |
| Index Name | Fields | Flags |
|---|---|---|
| rollup_ind | name:focus_type | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| objindex | objid | clustered, unique located on PRIMARY |
| rollup_ind | name, focus_type | nonclustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 5290 | loc_rollup_v | inv_locatn, loc_rol_itm, rollup |
| 5303 | cc_params_v | cycle_count, cycle_setup, rollup |
| 5305 | cc_info_v | biz_cal_hdr, cycle_count, rollup |
| 5352 | sfa_bus_rol | bus_org, bus_rol_itm, rollup |
| 5353 | sfa_ter_rol | rollup, ter_rol_itm, territory |
| 5727 | vw_bi_bus_rol | bus_org, bus_rol_itm, rollup |
| 5729 | bus_org_hrc_vw | bus_org, bus_org_extern, bus_rol_itm, rollup |
| 5850 | fc_rol_contct | address, bus_org, contact, contact_role, country, rollup, site |
| 6071 | bus_org_view | bus_org, rollup |
| rollup | |||