| Table Name: | productbin |
| Table Number: | 109 |
| Group: | Product Mgr |
| Description: | Product bin object: used to group parts at a site; e.g., could define a specific user's configuration |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| bin_level | LONG | int | DIRECT | Level of bin within a hierarchy of bins | ||||
| description | CHAR | varchar | 255 | Product bin long description | ||||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| last_modified | CLK_TIME | datetime | Date and time last modified | |||||
| loc_path | CHAR | varchar | 255 | Location of bin in the hierarchy of bins | ||||
| name | CHAR | varchar | 30 | Product bin name | ||||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (1) | ||
| parent_id | LONG | int | DIRECT | Objid of parent site (if parent_type=52) or productbin (if parent_type=109) | Search (1) | |||
| parent_type | LONG | smallint | DIRECT | Indicates whether the parent is a site or a bin by holding the type ID of the parent object type; e.g., 52=Installed under site; 109=Installed under another productbin, 0=Deinstalled productbin | ||||
| quantity | LONG | int | DIRECT | Number of products and bins under the bin |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| productbin2primary | MTO | employee | primary2productbin | Primary employee | |||
| productbin2backup | MTO | employee | backup2productbin | Backup employee | |||
| prnt_child2productbin | OTM | productbin | child_prnt2productbin | Related child bins in a bin hierarchy | |||
| child_prnt2productbin | MTO | productbin | prnt_child2productbin | Related parent for the child bin | |||
| direct_prdbin2site | MTO | site | prd_lst2productbin | Site for the top-level product bin | Search (1) | ||
| prdbin2site | MTO | site | h_prd_lst2productbin | Site the bin is located at | |||
| productbin2site_part | OTM | site_part | site_part2productbin | Parts located in the bin |
| Index Name | Fields | Flags |
|---|---|---|
| name_ind | parent_type:parent_id:name | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| ind_child_prnt2productbin | child_prnt2productbin | nonclustered located on PRIMARY |
| ind_direct_prdbin2site | direct_prdbin2site, name | nonclustered located on PRIMARY |
| ind_prdbin2site | prdbin2site | nonclustered located on PRIMARY |
| name_ind | parent_type, parent_id, name | nonclustered, unique located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 5744 | sitepart_prodbin_vw | productbin, site_part, site_part_extern |
| productbin | |||