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 in 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.
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.
|
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 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/User-Defined Label combination exists, the Item User-Defined 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 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 and Validated 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 associated User-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 associated User-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.