| Table Name: | vendor_part |
| Table Number: | 5275 |
| Group: | Product Mgr |
| Description: | Vendor- and role-specific information about a part revision. Reserved; future |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| avg_cost | DECIMAL | decimal (19,4) | CURRENCY | Part's average cost | Search (2) | |||
| avg_lead_time | LONG | smallint | DIRECT | Part's average lead time for the role in seconds | Search (1) | |||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| lead_time | LONG | int | DIRECT | Lead time for the role in seconds | Search (1) | |||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (2) | ||
| part_status | CHAR | varchar | 20 | Vendor part status; from a user-defined popup list with default name _____ | Search (1) | |||
| preference | CHAR | varchar | 20 | Vender preference; from a user-defined popup list with default name ___ | Search (1) | |||
| role_name | CHAR | varchar | 80 | Role played by the vendor for the part, e.g., supplier, repair vendor, exchange vendor etc | Search (2) | |||
| vendor_part_no | CHAR | varchar | 30 | Vendor's part number | Search (2) | |||
| vendor_rev | CHAR | varchar | 10 | Vendor site's part number revision level | Search (2) | |||
| warranty | LONG | smallint | 0 | DIRECT | Warranty length in days for the role | Search (2) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| vendor_part2mod_level | MTO | mod_level | part_info2vendor_part | Part revision for the supplier information | Search (2) | ||
| vendor_part2price_qty | OTM | price_qty | priced2vendor_part | Price quantities for the vendor part | |||
| vendor_part2site | MTO | site | site2vendor_part | The vendor site for the part | Search (2) |
| Index Name | Fields | Flags |
|---|---|---|
| vendor_part_ind | vendor_part2mod_level:vendor_part2site:role_name | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| ind_vendor_part2mod_level | vendor_part2mod_level | nonclustered located on PRIMARY |
| ind_vendor_part2site | vendor_part2site | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| vendor_part_ind | vendor_part2mod_level, vendor_part2site, role_name | nonclustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 5276 | view_vpt | mod_level, part_num, site, vendor_part |
| 5277 | view_vpt_price | mod_level, price_inst, price_prog, price_qty, site, vendor_part |
| vendor_part | |||