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 in the Item User-Defined Labels screen under the Product Definition Controls menu, and is assigned to items in the User-Defined Info subtask of the Basic Part Data screen (for parts), or in the Services or 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 Item ID / Item Revision ID / User-Defined Label combination exists, Item User-Defined 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 / User-Defined Label combination exists, Item User-Defined 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. |
|
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. Needed for retrieving 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 associated User-Defined Label row's Data Type (S_DATA_TYPE) is "T" (Text) and Validated Text (VALIDATE_FL) is "N" (No). Do not load if 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 associated User-Defined Label row's Data Type (S_DATA_TYPE) is "T." Do not load if 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 associated User-Defined Label row's Data Type (S_DATA_TYPE) is "D." Do not load if associated User-Defined Label row'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 associated User-Defined Label row's Data Type (S_DATA_TYPE) is "N." Do not load if associated User-Defined Label row's Data Type is not "N." Input file format is "‑9999999999.9999" (maximum 16 characters including the decimal point and optional minus sign (indicating a negative number)). Maximum value is "9999999999.9999." Minimum value is "‑9999999999.9999." No embedded commas are allowed. |
|
User ID last modified by |
*MODIFIED_BY |
Character 18 |
128 - 145 |
No |
If a value is not provided, the system will update 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.