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.
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 |
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. |
|
Item Revision ID |
ITEM_ RVSN_ID |
Character 3 |
34 - 36 |
No |
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. |
|
Project ID |
PROJ_ID |
Character 30 |
37 - 66 |
Yes |
The value must exist in the Project table. Must exist for user's 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. Must exist for user's company ID. |
|
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. Must exist for user's 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 is P. |
|
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 |
If a value is not provided, the MODIFIED_BY column is updated using the current user ID as the default. |
* Indicates columns that may be updated when changing an existing record with this preprocessor.