| View Name: | sitepart_prodbin_vw |
| View Number: | 5744 |
| Group: | Billing Manager |
| Description: | To check if a record exists in productbin where the site corresponds to the site where the Subscriber is installed for an external reference. Used in Billing Integrator save beans |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| prodbin_objid | productbin | objid | Productbin internal record number | 3 (UNIQUE) |
| sitepart_ext_ref | site_part_extern | ext_ref | The identifier of the customer from the external system | |
| sp_instance_name | site_part | instance_name | Default is the concatination of part name, part number, and part revision. May be customized | |
| sp_site_objid | site_part | site_objid | Site_part internal record number | |
| prdbin_site | productbin | parent_id | Objid of parent site (if parent_type=52) or productbin (if parent_type=109) | |
| site_part_ext_objid | site_part_extern | objid | Site_part_ext internal record number |
| Join From | Join To |
|---|---|
| (site_part_extern).site_part_extern2site_part | (site_part).site_part2site_part_extern |
| (site_part).all_site_part2site | (site).site2all_site_part |
| (productbin).direct_prdbin2site | (site).prd_lst2productbin |
| sitepart_prodbin_vw | |||