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

Project Client Line Item Number Product Layout (PCP)

The Project CLIN Product (PROJ_CLIN_PROD) table stores Item CLIN information by Project. 

Items that are available to be used and invoiced for a particular project can be grouped together.

You cannot process Project CLIN Product Line Types unless Item and Project information exists.

If the Cost of Sales Calculation Code is C (Cost Schedule), a line for the CLIN Cost Schedule must exist or must be provided. If the Warranty Cost Calculation Code is C (Cost Schedule), a line for the CLIN Warranty Cost Schedule must exist or be provided.

If the Cost of Sales Calculation Code is updated to P (Percentage), the application deletes all existing CLIN Cost Schedule rows for the item. If the Warranty Cost Calculation Code is updated to P, the application deletes all existing CLIN Warranty Cost Schedule rows for the item.

You can view or update the information stored in this table on the Manage CLIN Information screen in Costpoint Project Setup.

Note: 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 PCP is used to indicate Project CLIN Product information.
Item ID ITEM_ID Character 30 4 - 33 Yes If the Item ID/Item Revision ID/Project ID/CLIN ID combination exists, the Project CLIN Product table is updated. Defaults to the Item ID value if not applied. Must be a valid part/revision if not null. 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 (Yes (If revisions are used)) If the Item ID/Item Revision ID/Project ID/CLIN ID combination exists, the Project CLIN Product table is updated. Defaults to the Item ID value if not applied. Must be a valid part/revision if not null. 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 default is space.

The fixed length file format accepts 3 characters while delimited file format accepts up to 10 characters.

Project ID PROJ_ID Character 30 37 - 66 Yes The value must exist in the Project table. This value must exist for your company ID.
CLIN ID CLIN_ID Character 10 67 - 76 Yes The value must exist in the Project CLIN table.
Automatic Billing Quantity *AUTO_ BILL_ QTY Decimal 14.4 (maximum input file length - 15) 77 - 91 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.
Ceiling Quantity *CEIL_QTY Decimal 14.4 (maximum input file length - 15) 92 - 106 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.
Certificate of Conformance Flag *CERT_OF_ CONF_FL Character 1 107 No The value must be Y (Yes) or N (No). The default is retrieved from Item Product table.
Cost of Sales Percentage Rate *COGS_PCT_ RT Decimal 5.4 (maximum input file length - 6) 108 - 113 No. Required for inserted records if the Cost of Sales Calculated Code is P. The value is accepted only if the Cost of Sales Calculated Code is P (insert records). The default is zero. The input file format is 9.9999 (maximum six characters including the decimal point). The maximum value is 9.9999. No embedded commas are allowed.

Note: The Cost of Sales Percentage Rate is updated to zero if the Cost of Sales Calculation Code is updated to C.

Defer Revenue Flag *DEFER_ REV_FL Character 1 114 No The value must be Y (Yes) or N (No). The default is retrieved from Item Product table.
External Warranty Code *EXT_ WARR_CD Character 6 115 - 120 No If provided, the value must exist in the Warranty table. The default is NULL.
Installment Bill Flag *INSTALL_ BILL_ FL Character 1 121 No The value must be Y (Yes) or N (No). The default is retrieved from Item Product table.
Internal Warranty Code *INT_ WARR_CD Character 6 122 - 127 No If provided, the value must exist in the Warranty table. The default is NULL.
Inventory Abbreviation Code *INVT_ ABBRV_CD Character 6 128 - 133 No If provided, the value must exist in the Inventory Abbreviation table. The default is NULL.  This value must exist for your company ID.

The fixed length file format accepts 6 characters while delimited file format accepts up to 20 characters.

Quantity On Order *ON_ ORDER_ QTY Decimal 14.4 (maximum input file length - 15) 134 - 148 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.
Sales Group Abbreviation Code *SALES_ ABBRV_CD Character 6 149 - 154 No If provided, the value must exist in the Sales Group Abbreviation table. The default is NULL.  This must exist for your company ID.
Sold To Date Quantity *SOLD_TO_ DT_ QTY Decimal 14.4 (maximum input file length - 15) 155 - 169 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.
Source Inspection Flag *SRCE_ INSP_ FL Character 1 170 No The value must be Y (Yes) or N (No). The default is N.
Cost of Sales Calculation Code *S_COGS_ CALC_CD Character 1 171 No The value can be P (Percentage) or C (Cost Schedule). The default is P.
PRC Basis Code *S_PRC_ BASIS_ CD Character 1 172 No The value can be B (Billings), R (Revenue), A (Both), or N (Neither). The default is N.
Sales Order Line Type Code *S_PROD_ LN_TYPE_ CD Character 6 173 - 178 No The value can be DRP (Drop Shipment), INT (In Transit), INO (Invoice), INV (Inventory), or REC (Recurring). The default is retrieved from the Item Product table.
RBA Code *S_RBA_CD Character 1 179 No The value can be I (Incremental) or T (Total). The default is I.
Warranty Cost Calculation Code *S_WARR_CST_CALC_CD Character 1 180 No The value can be P (Percentage) or C (Cost Schedule). The default isP.
Warranty Percentage Rate *WARR_PCT_RT Decimal 5.4 (maximum input file length - 6) 181 - 186 No. Required for inserts if the Warranty Cost Calculation Code is P. The value is accepted only if the Warranty Cost Calculated Code is P.  The default is 0. The input file format is 9.9999 (maximum six characters including the decimal point). The maximum value is 9.9999. No embedded commas are allowed.

Note: The Warranty Percentage Rate is updated to zero if the Warranty Cost Calculation Code is updated to C.

User ID last modified by *MODIFIED_ BY Character 18 187 - 204 No The default value is UPLOAD. If a value is not provided, the MODIFIED_BY column is updated using the current user ID as the default.
ITEM_KEY Integer 4 No For new records, this is system-generated value from ITEM.ITEM_KEY. Otherwise, value is retrieved from existing record.
*ROWVERSION Integer 2 No This is system-generated. The default is 0 and increments by 1 when updated.
*TIME_STAMP Timestamp No This is a system date.

* Indicates columns that may be updated when changing an existing record with this preprocessor.