Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Alternate Part Line Layout (APT)

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 are not processed if the item is a Service or a 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 on the Manage Alternate Parts screen in Costpoint Product Definition.

Note: The application uses default values for INSERTS ONLY if the input file field value is not provided. The exception is MODIFIED_BY, which is 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 APT is used to indicate Alternate Part information.
Part ID PART_ID Character 30 4 - 33 Yes If a Part ID / Part Revision ID / Sequence Number combination exists, the Alternate 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 No If a Part ID / Part Revision ID / Sequence Number combination exists, the Alternate 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 a space.

The fixed length file format accepts 3 characters while delimited file format accepts up to 10 characters.

Sequence Number SEQ_NO Integer 4 (maximum input file length - 10) 37 - 46 Yes The input file format is -999999999 (maximum 10 characters including the optional minus sign (indicating a negative number)). The maximum value is 999999999. The minimum value is -999999999. No embedded commas or decimal points are allowed.
Manufacturer ID *MANUF_ID Character 10 47 - 56 Yes (if a Vendor ID is not provided) If provided, the Manufacturer ID must exist in the Manufacturers table. The default is null.
Manufacturer Part ID *MANUF_ PART_ID Character 30 57 - 86 Yes (if a Manufacturer ID is provided) The default is null.
Manufacturer Part Revision ID *MANUF_ PART_RVSN_ID Character 3 87 - 89 No The default is a space.
Vendor ID *VEND_ID Character 12 90 - 101 Yes (if a Manufacturer ID not provided) If provided, the Vendor ID must exist in the Vendor table. The default is null. This field's value must exist for your company ID.
Vendor Part ID *VEND_PART_ ID Character 30 102 - 131 Yes (if a Vendor ID is provided) The default is a space.
Vendor Part Revision ID *VEND_PART_ RVSN_ID Character 3 132 - 134 No The default is a space.
Part Preference Type *PART_PREF_ TYPE Character 1 135 No If provided, the Part Preference Type must exist in the Part Preference Type table. The default is null.
Part Preference Flag *PREF_FL Character 1 136 No The value must be Y (Yes) or N (No). The 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 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.