Project Client Line Item Number Product Layout (PCP)
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.
If the Cost of Sales Calculation Code is updated to P (Percentage), the application deletes all existing CLIN Cost Schedule rows for the item. If the Warranty Cost Calculation Code is updated to P, the application deletes all existing CLIN Warranty Cost Schedule rows for the item.
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.
The fixed length file format accepts 30 characters while delimited file format accepts up to 50 characters. |
| Item Revision ID | ITEM_RVSN_ID | Character 3 | 34 - 36 | (Yes (If revisions are used)) | 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. The default is space.
The fixed length file format accepts 3 characters while delimited file format accepts up to 10 characters. |
| Project ID | PROJ_ID | Character 30 | 37 - 66 | Yes | The value must exist in the Project table. This value must exist for your 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. 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. |
| 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. This must exist for your 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 isP. |
| 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 | The default value is UPLOAD. If a value is not provided, the MODIFIED_BY column is updated using the current user ID as the default. |
| ITEM_KEY | Integer 4 | No | For new records, this is system-generated value from ITEM.ITEM_KEY. Otherwise, value is retrieved from existing record. | ||
| *ROWVERSION | 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.