ITEM PROJECT COST (IPC)

Item Project Cost Line Layout

The Item Project Cost (ITEM_PROJ_CST) table stores project-specific cost information for the item being processed.

The application cannot process Item Project Cost Line Types unless the Item exists.  You can process multiple lines per item. The Item ID, Item Revision ID, Project ID, and Item Cost Type combination must be unique.

For Parts without a bill of material (BOM), the This Level Amounts column valuess will default to the Total Cost Amounts column values if the This Level Amounts values are not provided.

You can view or update the information stored in this table in the Maintain Project Item Cost screen in Costpoint Product Definition.

The application uses default values for INSERTS ONLY if the input file field value is not provided. The exception is 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

"IPC" is used to indicate Item Project Cost information.

Item ID

ITEM_ID

Character 30

4 - 33

Yes

If the Item ID / Item Revision ID / Project ID / Item Cost Type combination exists, the Item Project Cost 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 the Item ID / Item Revision ID / Project ID / Item Cost Type combination exists, the Item Project Cost 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.

Project ID

PROJ_ID

Character 30

37 - 66

Yes

Project ID must exist in the Project table (in Maintain Project Master in Project Setup). Must exist for your company ID.

Item Cost Type

S_ITEM_CST_ TYPE

Character 1

67

Yes

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)

68 - 82

No

Default is 0.  Input file format is 9999999999.9999 (maximum 15 characters including the decimal point).  Maximum value is 9999999999.9999.  No embedded commas are allowed.

Labor Cost Amount

*LAB_CST_ AMT

Decimal 14.4 (maximum input file length - 15)

83 - 97

No

Default is 0.  Input file format is 9999999999.9999 (maximum 15 characters including the decimal point).  Maximum value is 9999999999.9999.  No embedded commas are allowed.

Material Burden Cost Amount

*MATL_BURD_CST_ AMT

Decimal 14.4 (Maximum input file length - 15)

98 - 112

No

Default is 0.  Input file format is 9999999999.9999 (maximum 15 characters including the decimal point).  Maximum value is 9999999999.9999.  No embedded commas are allowed.

Material Cost Amount

*MATL_CST_ AMT

Decimal 14.4 (maximum input file length - 15)

113 - 127

No

Default is 0.  Input file format is 9999999999.9999 (maximum 15 characters including the decimal point).  Maximum value is 9999999999.9999.  No embedded commas are allowed.

Miscellaneous 1 Burden Cost Amount

*MISC1_BURD_ CST_AMT

Decimal 14.4 (maximum input file length - 15)

128 - 142

No

Default is 0.  Input file format is 9999999999.9999 (maximum 15 characters including the decimal point).  Maximum value is 9999999999.9999.  No embedded commas are allowed.

Miscellaneous 1 Cost Amount

*MISC1_CST_ AMT

Decimal 14.4 (maximum input file length - 15)

143 - 157

No

Default is 0.  Input file format is 9999999999.9999 (maximum 15 characters including the decimal point).  Maximum value is 9999999999.9999.  No embedded commas are allowed.

Miscellaneous 2 Burden Cost Amount

*MISC2_BURD_ CST_AMT

Decimal 14.4 (maximum input file length - 15)

158 - 172

No

Default is 0.  Input file format is 9999999999.9999 (maximum 15 characters including the decimal point).  Maximum value is 9999999999.9999.  No embedded commas are allowed.

Miscellaneous 2 Cost Amount

*MISC2_CST_ AMT

Decimal 14.4 (maximum input file length - 15)

173 - 187

No

Default is 0.  Input file format is 9999999999.9999 (maximum 15 characters including the decimal point).  Maximum value is 9999999999.9999.  No embedded commas are allowed.

Subcontractor Burden Cost Amount

*SUBCT_BURD_ CST_AMT

Decimal 14.4 (maximum input file length - 15)

188 - 202

No

Default is 0.  Input file format is 9999999999.9999 (maximum 15 characters including the decimal point).  Maximum value is 9999999999.9999.  No embedded commas are allowed.

Subcontractor Cost Amount

*SUBCT_CST_ AMT

Decimal 14.4 (maximum input file length - 15)

203 - 217

No

Default is 0.  Input file format is 9999999999.9999 (maximum 15 characters including the decimal point).  Maximum value is 9999999999.9999.  No embedded commas are allowed.

This Level Labor Burden Cost Amount

*TL_LAB_BRD_ CST_AMT

Decimal 14.4 (maximum input file length - 15)

218 - 232

No

Default is 0.  Input file format is 9999999999.9999 (maximum 15 characters including the decimal point).  Maximum value is 9999999999.9999.  No embedded commas are allowed.

This Level Labor Cost Amount

*TL_LAB_ CST_ AMT

Decimal 14.4 (maximum input file length - 15)

233 - 247

No

Default is 0.  Input file format is 9999999999.9999 (maximum 15 characters including the decimal point).  Maximum value is 9999999999.9999.  No embedded commas are allowed.

This Level Material Burden Cost Amount

*TL_MAT_BRD_ CST_AMT

Decimal 14.4 (maximum input file length - 15)

248 - 262

No

Default is 0.  Input file format is 9999999999.9999 (maximum 15 characters including the decimal point).  Maximum value is 9999999999.9999.  No embedded commas are allowed.

This Level Material Cost Amount

*TL_MATL_ CST_ AMT

Decimal 14.4 (maximum input file length - 15)

263 - 277

No

Default is 0.  Input file format is 9999999999.9999 (maximum 15 characters including the decimal point).  Maximum value is 9999999999.9999.  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)

278 - 292

No

Default is 0.  Input file format is 9999999999.9999 (maximum 15 characters including the decimal point).  Maximum value is 9999999999.9999.  No embedded commas are allowed.

This Level Miscellaneous 1 Cost Amount

*TL_MISC1_ CST_ AMT

Decimal 14.4 (maximum input file length - 15)

293 - 307

No

Default is 0.  Input file format is 9999999999.9999 (maximum 15 characters including the decimal point).  Maximum value is 9999999999.9999.  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)

308 - 322

No

Default is 0.  Input file format is 9999999999.9999 (maximum 15 characters including the decimal point).  Maximum value is 9999999999.9999.  No embedded commas are allowed.

This Level Miscellaneous 2 Cost Amount

*TL_MISC2_ CST_ AMT

Decimal 14.4 (maximum input file length - 15)

323 - 337

No

Default is 0.  Input file format is 9999999999.9999 (maximum 15 characters including the decimal point).  Maximum value is 9999999999.9999.  No embedded commas are allowed.

This Level Subcontractor Burden Cost Amount

*TL_SUB_BRD_ CST_AMT

Decimal 14.4 (maximum input file length - 15)

338 - 352

No

Default is 0.  Input file format is 9999999999.9999 (maximum 15 characters including the decimal point).  Maximum value is 9999999999.9999.  No embedded commas are allowed.

This Level Subcontractor Cost Amount

*TL_SUBCT_ CST_ AMT

Decimal 14.4 (maximum input file length - 15)

353 - 367

No

Default is 0.  Input file format is 9999999999.9999 (maximum 15 characters including the decimal point).  Maximum value is 9999999999.9999.  No embedded commas are allowed.

User ID last modified by

*MODIFIED_ BY

Character 18

368 - 385

No

If not provided, MODIFIED_BY column will be updated using the current user ID as the default.

 

* Indicates columns that may be updated by this preprocessor.