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. Must exist for user's 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. Must exist for user's company ID. |
|
Sales Group Abbreviation Code |
*SALES_ ABBRV_CD |
Character 6 |
80 - 85 |
No |
The value must exist in the Sales Group Abbreviation table. Must exist for user's 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 |
If a value is not provided, the program modifies the MODIFIED_BY column using the current user ID as the default. |
* Indicates columns that may be updated when changing an existing record with this preprocessor.