The Alternate Part (ALT_PART) table stores alternative part information by manufacturer and vendor that can is cross-referenced with the original part. Alternate Part Line Types will not be processed if the item is a Service or Good.
The application cannot process Alternate Part Line Types unless the item exists. You can process multiple lines per item, and the Part ID / Part Revision ID / Sequence Number combination must be unique.
You must provide either the Manufacturer ID/Manufacturer Part ID or Vendor ID/Vendor Part ID.
You can view or update the information stored in this table in the Alternate Parts screen in Costpoint Product Definition.
|
Input File Field |
Costpoint Column |
Column Type and Max Length |
Starting/Ending Position |
Required |
Values, Defaults, and Notes |
|
Line Type |
|
Character 3 |
1- 3 |
Yes |
"APT" is used to indicate Alternate Part information. |
|
Part ID |
PART_ID |
Character 30 |
4 - 33 |
Yes |
If Part ID / Part Revision ID / Sequence Number combination exists, Alternate Part table will be updated. If you did not select the Allow Multilple Revisions for Each Item checkbox in Product Definition Settings, the revision will not be checked. |
|
Part Revision ID |
PART_RVSN_ID |
Character 3 |
34 - 36 |
No |
If Part ID / Part Revision ID / Sequence Number combination exists, Alternate Part table will be updated. If you did not select the Allow Multilple Revisions for Each Item checkbox in Product Definition Settings, the revision will not be checked. |
|
Sequence Number |
SEQ_NO |
Integer 4 (maximum input file length - 10) |
37 - 46 |
Yes |
Input file format is ‑999999999 (maximum 10 characters including the optional minus sign (indicating a negative number)). Maximum value is 999999999. Minimum value is ‑999999999. No embedded commas or decimal points are allowed. |
|
Manufacturer ID |
*MANUF_ID |
Character 10 |
47 - 56 |
Yes (if Vendor ID not provided) |
If provided, Manufacturer ID must exist in the Manufacturers table (in the Product Definition Controls menu). Default is null. |
|
Manufacturer Part ID |
*MANUF_ PART_ID |
Character 30 |
57 - 86 |
Yes (if Manufacturer ID is provided) |
Default is space. |
|
Manufacturer Part Revision ID |
*MANUF_ PART_RVSN_ID |
Character 3 |
87 - 89 |
No |
Default is space. |
|
Vendor ID |
*VEND_ID |
Character 12 |
90 - 101 |
Yes (if Manufacturer ID not provided) |
If provided, Vendor ID must exist in the Vendor table (in Maintain Vendors screen in Costpoint Accounts Payable, Purchasing, and/or Procurement Planning). Default is null. Must exist for user's Company ID. |
|
Vendor Part ID |
*VEND_PART_ ID |
Character 30 |
102 - 131 |
Yes (if Vendor ID is provided) |
Default is space. |
|
Vendor Part Revision ID |
*VEND_PART_ RVSN_ID |
Character 3 |
132 - 134 |
No |
Default is space. |
|
Part Preference Type |
*PART_PREF_ TYPE |
Character 1 |
135 |
No |
If provided, Part Preference Type must exist in the Part Preference Type table (in the Product Definition Controls menu). Default is null. |
|
Part Preference Flag |
*PREF_FL |
Character 1 |
136 |
No |
Value must be "N" (No) or "Y" (Yes). Default is "N." You can designate only one Alternate Part as "Preferred" (have a value of "Y") per Part ID. |
|
User ID last modified by |
*MODIFIED_BY |
Character 18 |
137 - 154 |
No |
If a value is not provided, the system will update the MODIFIED_BY column using the current user ID as the default. |
* Indicates columns that may be updated when changing an existing record with this preprocessor.