The CLIN Price Schedule (CLIN_PRICE_SCH) table stores Pricing information.
You cannot process CLIN Price Schedule Line Types unless Item and Project CLIN Product information exists. This Line Type is required if a new CLIN Price Catalog line is provided.
The table can have multiple CLIN Price Schedule rows per Item/CLIN, but all quantities (.0001 - 9999999999.9999) must be accounted for in the provided date range.
There cannot be any gaps in the date range, and each new date range must not overlap any existing rows. Each new row must have a start date one day later than the latest end date (or earlier than all existing start dates).
The Unit Price Amount can be updated if values exist for the From Quantity, To Quantity, Start Date, and End Date fields.
If the From Quantity, To Quantity, Start Date, and End Date values exist, the program updates the existing From Quantity, To Quantity, and End Date values by changing the current End Date value to one day before the provided Start Date.
For example, if a row currently exists with the following values:
|
FROM_QTY |
TO_QTY |
START_DT |
END_DT |
UNIT_PRICE_AMT |
|
.0001 |
9999999999.9999 |
01/01/2006 |
12/31/2007 |
516.97 |
A line is encountered in the input file with the following values:
|
FROM_QTY |
TO_QTY |
START_DT |
END_DT |
UNIT_PRICE_AMT |
|
.0001 |
9999999999.9999 |
04/01/2006 |
12/31/2007 |
549.16 |
The End Date of the existing row will be modified and a new row will be inserted. The two rows will contain the following values:
|
FROM_QTY |
TO_QTY |
START_DT |
END_DT |
UNIT_PRICE_AMT |
|
.0001 |
9999999999.9999 |
01/01/2006 |
03/31/2006 |
516.97 |
|
.0001 |
9999999999.9999 |
04/01/2006 |
12/31/2007 |
549.16 |
You can view or update the information stored in this table on the Manage CLIN Information screen in Costpoint Project Setup. Some of the columns included in this table are accessible via the subtasks located on this screen.
|
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 |
CPS indicates CLIN Price Schedule information. |
|
Item ID |
ITEM_ID |
Character 30 |
4 - 33 |
Yes |
If the Item ID / Item Revision ID / Project ID / CLIN ID / From Quantity / To Quantity / End Date combination exists, the Product Price Schedule 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 |
No |
If the Item ID / Item Revision ID / Project ID / CLIN ID / From Quantity / To Quantity / End Date combination exists, the Product Price Schedule 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 a 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 CLIN Product 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 Product table. |
|
Starting Date |
START_DT |
Date (Maximum input file length - 10) |
77 - 86 |
Yes |
The value must be in valid date format YYYY-MM-DD. |
|
Ending Date |
*END_DT |
Date (Maximum input file length - 10) |
87 - 96 |
Yes |
The value must be in valid date format YYYY-MM-DD. |
|
Transaction Unit Price Amount |
*TRN_UNIT_ PRICE_AMT |
Decimal 14.4 (maximum input file length - 15) |
97 - 111 |
No |
The input file format is -9999999999.9999 (maximum 16 characters including the decimal point and optional minus sign (indicating a negative number)). The maximum value is 9999999999.9999. No embedded commas are allowed. Default to Unit Price Amount. |
|
From Quantity |
FROM_QTY |
Decimal 14.4 (maximum input file length - 15) |
112 - 126 |
No |
The default is .0001. The input file format is 9999999999.9999 (maximum 15 characters including the decimal point). The maximum value is 9999999999.9999. No embedded commas are allowed. |
|
To Quantity |
TO_QTY |
Decimal 14.4 (maximum input file length - 15) |
127 - 141 |
No |
The default is 9999999999.9999. The input file format is 9999999999.9999 (maximum 15 characters including the decimal point). The maximum value is 9999999999.9999. No embedded commas are allowed. |
|
User ID last modified by |
*MODIFIED_ BY |
Character 18 |
142 - 159 |
No |
The default is UPLOAD. If a value is not provided, the program updates the MODIFIED_BY column 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. |
|
|
CLIN_PRICE_SCH_KEY |
Integer 4 |
|
No |
For new records, this is system-generated. 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. |
|
|
|
UNIT_PRICE_AMT |
Decimal 14.4 |
No |
If the functional unit currency (GL_CONFIG. FUNC_S_CRNCY_CD) and the Project CLIN currency (PROJ_CLIN. S_CRNCY_CD) are the same, set to TRN_UNIT_PRICE_AMT, otherwise, set to 0. |
* Indicates columns that may be updated when changing an existing record with this preprocessor.