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.
|
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.