ITEM TEXT (TXT)

Item Text Line Layout

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 in the Standard Text screen in the Product Definition Controls menu. 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 in the Assign Standard Text screen in Costpoint Product Definition.

Set up the standard text code and its applicable content in the 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 STANDARD TEXT SCREEN) INCLUDING THE CASE TYPE (UPPER OR LOWER).

The application will use defaults for INSERTS ONLY if the input file field is not provided (blank). The exception is MODIFIED_BY, which will be 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 Item ID / Item Revision ID / Text Code combination exists, the Item Text 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.
Item Revision ID	ITEM_RVSN_ID	Character 3	34 - 36	No	If Item ID / Item Revision ID / Text Code combination exists, the Item Text 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.
Text Code	TEXT_CD	Character 10	37 - 46	Yes	Must exist in Standard Text table (in the Product Definition Controls menu). Must exist for user's company ID.
Active Flag	*ACTIVE_FL	Character 1	47	No	Value must be "Y" (Yes) or "N" (No). Default is "Y."
User ID last modified by	*MODIFIED_BY	Character 18	48 - 65	No	If a 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.