SUBSTITUTE PART (SPT)

Substitute Part Line Layout

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 will be processed for Parts only; item types that are a Service or Good will not be processed.

You can view or update the information stored in this table in the Substitute Parts screen in Costpoint Product Definition.

The application uses defaults for INSERTS ONLY if the input file field value is not provided.  The exception is MODIFIED_BY, which will be updated using the default value if no value is provided.

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 Part ID / Part Revision ID / Substitute Part ID / Substitute Part Revision ID combination exists, 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 / Substitute Part ID / Substitute Part Revision ID exists, 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.

Substitute Part ID

SUBST_ PART_ID

Character 30

37 - 66

Yes

Substitute Part ID / Substitute Part Revision ID must exist in Part table. Must exist for user's company ID.

Substitute Part Revision ID

SUBST_ PART_RVSN_ID

Character 3

67 - 69

Yes (if revisions are used)

Substitute Part ID / Substitute Part Revision ID must exist in Part table. Default is space.

Usage Sequence Number

USAGE_SEQ_NO

Integer 2 (Maximum input file length - 4)

70 - 73

Yes

Input file format is 9999 (maximum 4 characters).  Maximum value is 9999.  No embedded commas or decimal points are allowed.

Interchangeable Flag

*INTERCH_ FL

Character 1

74

No

Value must be "N" (No) or "Y" (Yes).  Default is "Y."

User ID last modified by

*MODIFIED_BY

Character 18

75 - 92

No

If 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.