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 Contract Line Item Number Line Layout (CLN)

The Project CLIN (PROJ_CLIN) table stores CLIN information by project. 

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

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

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 CLN is used to indicate Project CLIN information.
Project ID PROJ_ID Character 30 4 - 33 Yes If the Project ID / CLIN ID combination exists, the Project CLIN table is updated. The Project ID must exist in the Project table. This must exist for your company ID.
CLIN ID CLIN_ID Character 10 34 - 43 Yes
CLIN Description *CLIN_DESC Character 30 44 - 73 Required if new. NOT required for updates.
Inventory Abbreviation Code *INVT_ABBRV_CD Character 6 74 - 79 No The value must exist in the Inventory Abbreviation Code table.  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.

Sales Group Abbreviation Code *SALES_ABBRV_CD Character 6 80 - 85 No The value must exist in the Sales Group Abbreviation table.  This value must exist for your company ID.
Country Code *COUNTRY_CD Character 8 86 - 93 No The value must exist in the Country table.
Currency Code *S_CRNCY_CD Character 3 94 - 96 No The value must exist in the Currency table. The default is the Default Transaction currency code (on the Configure Multicurrency Settings screen).
User ID last modified by *MODIFIED_BY Character 18 97 - 114 No The default is UPLOAD. If a value is not provided, the program modifies the MODIFIED_BY column using the current user ID as the default.
*ROW_VERSION 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.