| Table Name: | prt_domain |
| Table Number: | 331 |
| Group: | Product Mgr |
| Description: | Determines system-handling rules for parts, which govern; e.g., uniqueness of serial numbers, installation at sites, inclusion in BOM and catalogs |
| Flags: | |
| Baseline/Custom: | Baseline |
(double-click a column header to select column text)
Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| at_domain | LONG | int | DIRECT | Restricts parts in the domain to be installed only under parts in the domain specified by inc_domain; i.e., 0=no, 1=yes | ||||
| at_part | LONG | int | DIRECT | Allow parts in the domain to be installed under other parts in the Site Configuration Manager; i.e., 0=no, 1=yes | ||||
| at_site | LONG | int | DIRECT | Allow parts in the domain to be installed at the top level of the Site Configuration Manager; i.e., 0=no, 1=yes | ||||
| boms | LONG | int | DIRECT | Allow parts in the domain to be included in BOMs; i.e., 0=no, 1=yes | ||||
| catalogs | LONG | int | DIRECT | Allow parts in the domain to be included in catalogs; i.e., 0=no, 1=yes | ||||
| description | CHAR | varchar | 255 | A description of the domain | ||||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| inc_domain | CHAR | varchar | 40 | Parts with at_domain=1 can only be installed under parts in the domain in Site Configuration Manager | ||||
| is_at_bus_org | LONG | tinyint | 0 | DIRECT, ALLOW_NULL | Indicates group level products, to allow parts in the domain to be related to a bus_org. 1=Yes, 0=No; Default=0 | |||
| is_service | LONG | int | DIRECT | Indicates the part is a service part, if selected, sit_prt_role will be set when installed; i.e., 0=not a service, 1=a service | ||||
| literature | LONG | tinyint | 0 | DIRECT | Indicates whether part is a literature part; 0=no, 1=yes. Marketing collateral is an example of a literature part | |||
| name | CHAR | varchar | 40 | The name of the domain | ||||
| objid | LONG | int | 3 | DIRECT | Internal record number | |||
| pt_used_bom | LONG | int | DIRECT | During parts used transactions, force part installation to conform to BOM; i.e., 0=no, 1=yes | ||||
| pt_used_dom | LONG | int | DIRECT | Apply domain rules during parts-used transactions; i.e., 0=no, 1=yes | ||||
| pt_used_warn | LONG | int | DIRECT | Reserved; not used | ||||
| serialno | LONG | int | DIRECT | Degree of uniqueness of part serial number; i.e., 0=no serial numbers, tracked only by quantity, 1=unique serial numbers across all part numbers, 2=unique serial numbers only within a part number, 3=serial numbers don't need to be unique | ||||
| unique_sn | LONG | int | DIRECT | For any given site, serial number must be unique for all part numbers; i.e., 0=no, 1=yes |
Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| domain2part_num | OTM | part_num | part_num2domain | Parts which belong to the domain | |||
| to_domain2domain | MTM | prt_domain | from_domain2domain | Related included domain; builds parent-child relationships between domains; this is the parent | mtm_prt_domain2_ prt_domain1 | ||
| from_domain2domain | MTM | prt_domain | to_domain2domain | Related included parts; builds parent-child relationships between domains; this is the child | mtm_prt_domain1_ prt_domain2 |
Index Name | Fields | Flags |
|---|---|---|
| name_index | name | UNIQUE |
Index Name | Fields | Additional Information |
|---|---|---|
| name_index | name | nonclustered, unique located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
View ID | View Name | Tables |
|---|
| prt_domain | |||