The Project Substitute Part (PROJ_SUBST_PART) table stores substitute part information (i.e., parts that can be used instead of the original part) at a project level.
The application cannot process Substitute Part Line Types unless the Item and Project ID exist.
This Line Type will not be processed if the item is a Service or Good. Only "P" (part) item types will be processed.
If the Substitute Flag column (in the Part Project table) is "N" (No), you cannot insert rows in the Project Part Substitute table, and an error will return if you attempt to process this table.
You can view or update the information stored in this table in the Part Project Data screen (Substitute Project Parts subtask) 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 |
"PSP" is used to indicate Project Substitute Part information. |
|
Part ID |
PART_ID |
Character 30 |
4 - 33 |
Yes |
If Part ID / Part Revision ID / Project ID / Substitute Part ID / Substitute Part Revision ID exists, Project Substitute 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 / Project ID / Substitute Part ID / Substitute Part Revision ID exists, Project Substitute 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. |
|
Project ID |
PROJ_ID |
Character 30 |
37 - 66 |
Yes |
Project ID must exist in Project (PROJ) table (established in the Maintain Project Master screen in Costpoint Project Setup). Must exist for user's company ID. |
|
Substitute Part ID |
SUBST_ PART_ID |
Character 30 |
67 - 96 |
Yes |
Substitute Part ID / Substitute Part Revision ID must exist in the Part table. If the Separate Items by Company checkbox is selected in the Product Definition Corporate Settings subtask of the Product Definition Settings screen, this field's value must exist for the user's company ID. If you did not select the Allow Multilple Revisions for Each Item checkbox in Product Definition Settings, the revision will not be checked. |
|
Substitute Part Revision ID |
SUBST_PART_ RVSN_ID |
Character 3 |
97 - 99 |
No |
Substitute Part ID / Substitute Part Revision ID must exist in the Part table. Default is space. If you did not select the Allow Multilple Revisions for Each Item checkbox in Product Definition Settings, the revision will not be checked. |
|
Usage Sequence Number |
USAGE_SEQ_ NO |
Integer 2 (maximum input file length - 4) |
100 - 103 |
Yes |
Input file format is "9999" (maximum four characters). Maximum value is "9999." No embedded commas or decimal points are allowed. |
|
Interchangeable Flag |
*INTERCH_FL |
Character 1 |
104 |
No |
Value must be "N" (No) or "Y" (Yes). Default is "Y." |
|
User ID last modified by |
*MODIFIED_BY |
Character 18 |
105 - 122 |
No |
If value is not provided, the program will modify 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.