Substitute Part Line Layout (SPT)
The Substitute Part (SUBST_PART) table stores substitute part information that can be used in place of the original part.
The application cannot process Substitute Part Line Types unless the Item exists.
This Line Type is processed for Parts only; item types that are a Service or a Good are not processed.
You can view or update the information stored in this table on the Substitute Parts subtask of the Manage 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 | SPT is used to indicate Substitute Part information. | |
| Part ID | PART_ID | Character 30 | 4 - 33 | Yes | If a
Part ID/Part Revision ID/Substitute Part ID/Substitute Part Revision ID combination exists, the Substitute Part table is updated. If you did not select the
Allow Multiple Revisions for Each Item check box on the Configure Product Definition Settings screen, the revision is not checked.
The fixed length file format accepts 30 characters while delimited file format accepts up to 50 characters. |
| Part Revision ID | PART_RVSN_ID | Character 3 | 34 - 36 | Yes (if revisions are used) | If a
Part ID/Part Revision ID/Substitute Part ID/Substitute Part Revision ID combination exists, the Substitute Part table is updated. If you did not select the
Allow Multiple Revisions for Each Item check box on the Configure Product Definition Settings screen, the revision is not checked. The default is space.
The fixed length file format accepts 3 characters while delimited file format accepts up to 10 characters. |
| Substitute Part ID | SUBST_PART_ID | Character 30 | 37 - 66 | Yes | The
Substitute Part ID/Substitute Part Revision ID must exist in Part table. Must exist for user's company ID.
The fixed length file format accepts 30 characters while delimited file format accepts up to 50 characters. |
| Substitute Part Revision ID | SUBST_PART_RVSN_ID | Character 3 | 67 - 69 | Yes (if revisions are used) | The
Substitute Part ID/Substitute Part Revision ID must exist in Part table. The default is a space.
The fixed length file format accepts 3 characters while delimited file format accepts up to 10 characters. |
| Usage Sequence Number | USAGE_SEQ_NO | Integer 2 (Maximum input file length - 4) | 70 - 73 | Yes | The input file format is 9999 (maximum four characters). The maximum value is 9999. No embedded commas or decimal points are allowed. |
| Status | SUBST_PART.S_INTERCH_CD | Character 1 | 75 | Yes | Value must be U (Use-up/Interchangeable), I (Interchangeable), N (Non-interchangeable), X (Invalid Substitute) |
| User ID last modified by | *MODIFIED_BY | Character 18 | 76 - 93 | No | The default is UPLOAD. If a value is not provided, Costpoint updates 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.