The Item Cost (ITEM_CST) table stores cost information for the item that is being processed.
The application cannot process Item Cost Line Types unless the Item exists. You can process multiple lines per item. The Item ID, Item Revision ID, and Item Cost Type combination must be unique.
You can view or update the information stored in this table on the Manage Item Costs screen in Costpoint Product Definition.
|
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 |
CST is used to indicate Item Cost information. |
|
Item ID |
ITEM_ID |
Character 30 |
4 - 33 |
Yes |
If the Item ID/Item Revision ID/Item Cost Type combination exists, the Item Cost 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. |
|
Item Revision ID |
ITEM_RVSN_ ID |
Character 3 |
34 - 36 |
No |
If the Item ID/Item Revision ID/Item Cost Type combination exists, the Item Cost 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. |
|
Item Cost Type |
S_ITEM_CST_ TYPE |
Character 1 |
37 |
Yes |
The value must be R (Reference), S (Standard), or L (Last). |
|
Labor Burden Cost Amount |
*LAB_BURD_ CST_ AMT |
Decimal 14.4 (maximum input file length - 15) |
38 - 52 |
No |
The default is 0. The input file format is 999999999999.99 (maximum 15 characters including the decimal point). The maximum value is 999999999999.99. No embedded commas are allowed. |
|
Labor Cost Amount |
*LAB_CST_ AMT |
Decimal 14.4 (maximum input file length - 15) |
53 - 67 |
No |
The default is 0. The input file format is 999999999999.99 (maximum 15 characters including the decimal point). The maximum value is 999999999999.99. No embedded commas are allowed. |
|
Material Burden Cost Amount |
*MATL_BURD_CST_AMT |
Decimal 14.4 (maximum input file length - 15) |
68 - 82 |
No |
The default is 0. The input file format is 999999999999.99 (maximum 15 characters including the decimal point). The maximum value is 999999999999.99. No embedded commas are allowed. |
|
Material Cost Amount |
*MATL_CST_ AMT |
Decimal 14.4 (maximum input file length - 15) |
83 - 97 |
No |
The default is 0. The input file format is 999999999999.99 (maximum 15 characters including the decimal point). The maximum value is 999999999999.99. No embedded commas are allowed. |
|
Miscellaneous 1 Burden Cost Amount |
*MISC1_BURD_CST_AMT |
Decimal 14.4 (maximum input file length - 15) |
98 - 112 |
No |
The default is 0. The input file format is 999999999999.99 (maximum 15 characters including the decimal point). The maximum value is 999999999999.99. No embedded commas are allowed. |
|
Miscellaneous 1 Cost Amount |
*MISC1_CST_ AMT |
Decimal 14.4 (maximum input file length - 15) |
113 - 127 |
No |
The default is 0. The input file format is 999999999999.99 (maximum 15 characters including the decimal point). The maximum value is 999999999999.99. No embedded commas are allowed. |
|
Miscellaneous 2 Burden Cost Amount |
*MISC2_BURD_CST_ |
Decimal 14.4 (maximum input file length - 15) |
128 - 142 |
No |
The default is 0. The input file format is 999999999999.99 (maximum 15 characters including the decimal point). The maximum value is 999999999999.99. No embedded commas are allowed. |
|
Miscellaneous 2 Cost Amount |
*MISC2_CST_ AMT |
Decimal 14.4 (maximum input file length - 15) |
143 - 157 |
No |
The default is 0. The input file format is 999999999999.99 (maximum 15 characters including the decimal point). The maximum value is 999999999999.99. No embedded commas are allowed. |
|
Subcontractor Burden Cost Amount |
*SUBCT_BURD_CST_AMT |
Decimal 14.4 (maximum input file length - 15) |
158 - 172 |
No |
The default is 0. The input file format is 999999999999.99 (maximum 15 characters including the decimal point). The maximum value is 999999999999.99. No embedded commas are allowed. |
|
Subcontractor Cost Amount |
*SUBCT_CST_AMT |
Decimal 14.4 (maximum input file length - 15) |
173 - 187 |
No |
The default is 0. The input file format is 999999999999.99 (maximum 15 characters including the decimal point). The maximum value is 999999999999.99. No embedded commas are allowed. |
|
This Level Labor Burden Cost Amount |
*TL_LAB_BRD_CST_ |
Decimal 14.4 (maximum input file length - 15) |
188 - 202 |
No |
The default is 0. The input file format is 999999999999.99 (maximum 15 characters including the decimal point). The maximum value is 999999999999.99. No embedded commas are allowed. |
|
This Level Labor Cost Amount |
*TL_LAB_CST_AMT |
Decimal 14.4 (maximum input file length - 15) |
203 - 217 |
No |
The default is 0. The input file format is 999999999999.99 (maximum 15 characters including the decimal point). The maximum value is 999999999999.99. No embedded commas are allowed. |
|
This Level Material Burden Cost Amount |
*TL_MAT_BRD_CST_AMT |
Decimal 14.4 (maximum input file length - 15) |
218 - 232 |
No |
The default is 0. The input file format is 999999999999.99 (maximum 15 characters including the decimal point). The maximum value is 999999999999.99. No embedded commas are allowed. |
|
This Level Material Cost Amount |
*TL_MATL_ CST_AMT |
Decimal 14.4 (maximum input file length - 15) |
233 - 247 |
No |
The default is 0. The input file format is 999999999999.99 (maximum 15 characters including the decimal point). The maximum value is 999999999999.99. No embedded commas are allowed. |
|
This Level Miscellaneous 1 Burden Cost Amount |
*TL_MS1_BRD_CST_AMT |
Decimal 14.4 (maximum input file length - 15) |
248 - 262 |
No |
The default is 0. The input file format is 999999999999.99 (maximum 15 characters including the decimal point). The maximum value is 999999999999.99. No embedded commas are allowed. |
|
This Level Miscellaneous 1 Cost Amount |
*TL_MISC1_ CST_AMT |
Decimal 14.4 (maximum input file length - 15) |
263 - 277 |
No |
The default is 0. The input file format is 999999999999.99 (maximum 15 characters including the decimal point). The maximum value is 999999999999.99. No embedded commas are allowed. |
|
This Level Miscellaneous 2 Burden Cost Amount |
*TL_MS2_BRD_CST_AMT |
Decimal 14.4 (maximum input file length - 15) |
278 - 292 |
No |
The default is 0. The input file format is 999999999999.99 (maximum 15 characters including the decimal point). The maximum value is 999999999999.99. No embedded commas are allowed. |
|
This Level Miscellaneous 2 Cost Amount |
*TL_MISC2_ CST_AMT |
Decimal 14.4 (maximum input file length - 15) |
293 - 307 |
No |
The default is 0. The input file format is 999999999999.99 (maximum 15 characters including the decimal point). The maximum value is 999999999999.99. No embedded commas are allowed. |
|
This Level Subcontractor Burden Cost Amount |
*TL_SUB_BRD_CST_AMT |
Decimal 14.4 (maximum input file length - 15) |
308 - 322 |
No |
The default is 0. The input file format is 999999999999.99 (maximum 15 characters including the decimal point). The maximum value is 999999999999.99. No embedded commas are allowed. |
|
This Level Subcontractor Cost Amount |
*TL_SUBCT_ CST_ AMT |
Decimal 14.4 (maximum input file length - 15) |
323 - 337 |
No |
The default is 0. The input file format is 999999999999.99 (maximum 15 characters including the decimal point). The maximum value is 999999999999.99. No embedded commas are allowed. |
|
User ID last modified by |
*MODIFIED_ BY |
Character 18 |
338 - 355 |
No |
If a value is not provided, the MODIFIED_BY column is updated using the current user ID as the default. |
* Indicates columns that may be updated when changing an existing record with this preprocessor.