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 in the 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 Project ID / CLIN ID exists, Project CLIN table will be 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 |
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 |
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 |
Value must exist in the Country table (in the System Codes menu in Costpoint System Administration). |
|
Currency Code |
*S_CRNCY_CD |
Character 3 |
94 - 96 |
No |
Value must exist in the Currency table (in Costpoint Multicurrency). Default to the Default Transaction Currency Code (in the Multicurrency Settings screen). |
|
User ID last modified by |
*MODIFIED_BY |
Character 18 |
97 - 114 |
No |
If a value is not provided, the program will modify 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.