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 User-Defined Line Layout (UDF)

The Item User-Defined (ITEM_UDEF) table stores the key to link an item to all user-defined labels. 

You cannot process Item User-Defined Line Types unless the Item exists.

The information stored in this table is established on the Manage Item User-Defined Labels screen, and is assigned to items on the User-Defined Info subtask of the Manage Parts screen (for parts), or on the Manage Services or Manage Goods screens, respectively, in Costpoint Product Definition.

Note: Before executing this process, set up the label to be associated with the item (that is, in the ITEM table) in the Manage Item User-Defined Labels screen. The value in the input file must exactly match the existing value.

You must enter at least one user-defined field value (User-Defined Text, User-Defined ID, User-Defined Date, User-Defined Amount) on each input file row. You can link user-defined fields to other Costpoint tables. If the matching user-defined label row has a case label, the value in the input file must exist in the table associated with that case label. 

Note: The application uses default values for INSERTS ONLY if the input file field value is not provided, except for the 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 UDF is used to indicate User-Defined Amount information.
Item ID ITEM_ID Character 30 4 - 33 Yes If an Item ID/Item Revision ID/User-Defined Label combination exists, the Item User-Defined 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.

Item Revision ID ITEM_RVSN_ID Character 3 34 - 36 No If an Item ID/Item Revision ID/User-Defined Label combinationexists, the Item User-Defined table is updated. If you did not select the Allow Multiple Revisions for Each Itemcheck 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.

User-Defined Label Character 15 37 - 51 Yes If the matching User-Defined Label row has a case label, the value in the input file must exist in the table associated with that case label. It is needed for retrieving the User-Defined Label Key for the item. Must exist for user's Company ID.
User-Defined Text *UDEF_TXT Character 30 52 - 81 No Required if the associated User-Defined Label row's Data Type (S_DATA_TYPE) is T(Text) and the Validated Text (VALIDATE_FL) is N(No).

Do not load if the associated User-Defined Label row's Data Type(S_DATA_TYPE) is not T andValidated Text (VALIDATE_FL) is not N. If the matching User-Defined Label row has a case label, the value in the input file must exist in the table associated with that case label.

User-Defined ID *UDEF_ID Character 20 82 - 101 No Required if the associated User-Defined Label row's Data Type (S_DATA_TYPE) is T (Text).

Do not load if the associated User-Defined Label row's Data Type (S_DATA_TYPE) is not T and Validated Text (VALIDATE_FL) is not Y.

User-Defined Date *UDEF_DT Date (Maximum input file length - 10) 102 - 111 No Required if the associated User-Defined Label row's Data Type (S_DATA_TYPE) is D. Do not load if the associatedUser-Defined Label row's Data Type (S_DATA_TYPE) is not D. Value must be valid date format YYYY-MM-DD.
User-Defined Amount *UDEF_AMT Decimal 14.4 (maximum input file length - 16) 112 - 127 No Required if the associated User-Defined Label row's Data Type (S_DATA_TYPE) is N. Do not load if the associatedUser-Defined Label row's Data Type (S_DATA_TYPE) is not N.The input file format is-9999999999.9999(maximum 16 characters including the decimal point and optional minus sign (indicating a negative number)). The maximum value is 9999999999.9999. The minimum value is-9999999999.9999.  No embedded commas are allowed.
User ID last modified by *MODIFIED_BY Character 18 128 - 145 No The default is UPLOAD. If a value is not provided, the system 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.