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

Item Text Line Layout (TXT)

The Item Text (ITEM_TEXT) table stores the key to link an item to standard text.

The application cannot process Item Text Line Types unless the Item exists. Establish standard text codes and content on the Manage Standard Text screen. Use the Where-Used subtask to assign this standard text to print on purchase requisitions, purchase orders, and/or other specified documents. Additionally, you can assign standard text codes to parts, services, and goods on the Assigned Standard Text subtask of the Manage Parts, Manage Goods, and Manage Services screens in Costpoint Product Definition.

Set up the standard text code and its applicable content in the Manage Standard Text screen before you execute this process. THE TEXT CODE VALUE IN THE INPUT FILE MUST BE AN EXACT MATCH FOR THE EXISTING TEXT CODE (IN THE MANAGE STANDARD TEXT SCREEN) INCLUDING THE CASE TYPE (UPPER OR LOWER).

Note: The application uses defaults for INSERTS ONLY if the input file field is not provided (blank). The exception is MODIFIED_BY, which is updated using the default 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 TXT is used to indicate item text information.
Item ID ITEM_ID Character 30 4 - 33 Yes If an Item ID/Item Revision ID/Text Code combination exists, the Item Text table is updated. If you did not select the Allow Multilple 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.

Item Revision ID ITEM_RVSN_ID Character 3 34 - 36 No If an Item ID/Item Revision ID/Text Code combination exists, the Item Text 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.

Text Code TEXT_CD Character 10 37 - 46 Yes This must exist in the Standard Text table and your company ID.
Active Flag *ACTIVE_FL Character 1 47 No The value must be Y (Yes) or N (No). The default is Y.
User ID last modified by *MODIFIED_BY Character 18 48 - 65 No The default is UPLOAD. If a value is not provided, the program modifies 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.