Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
Manufacturer Part Number | ||||||||||
1 | ADPIC_HOLD_MPN | Store MPN subitems for MIGO hold / restore functionality | 14 | PICCAT | Interchangeable parts category | nvarchar | 2 | 0 | ||
Supersession Chains | ||||||||||
2 | PICHD | Parts Interchangeability Header Data (Sus+MPN) | 3 | PICCAT | Interchangeable parts category | nvarchar | 2 | 0 | ||
3 | PICIC | Parts Interchangeability Code | 3 | PICCAT | Interchangeable parts category | nvarchar | 2 | 0 |