The CLIN Warranty Cost Schedule (CLIN_WARR_CST_SCH) table stores information used to calculate the warranty costs.
You cannot process CLIN Warranty Cost Schedule Line Types unless Item and Project CLIN Product information exists.
This Line Type is required if the Warranty Cost Calculation Code is C (Cost Schedule). Otherwise, the record is rejected.
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 Warranty Unit Cost Amount can be updated if values exist for the Start Date and End Date.
If the End Date values exist, Costpoint updates the existing End Date value 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:
|
START_DT |
END_DT |
WARR_UNIT_CST_AMT |
|
01/01/2006 |
12/31/2007 |
516.97 |
A line is encountered in the input file with the following values:
|
START_DT |
END_DT |
WARR_UNIT_CST_AMT |
|
04/01/2006 |
12/31/2006 |
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:
|
START_DT |
END_DT |
WARR_UNIT_CST_AMT |
|
01/01/2006 |
03/31/2006 |
516.97 |
|
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.
|
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 |
CWS indicates Product Warranty Cost Schedule information. |
|
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 Warranty Cost Schedule table is updated. This field defaults to the Item ID 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 |
|
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 Warranty Cost Schedule table is updated. This field defaults to the Item ID 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 CLIN Product 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 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. |
|
Warranty Unit Cost Amount |
*WARR_UNIT_ CST_AMT |
Decimal 14.4 (maximum input file length - 16) |
97 - 112 |
Yes |
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. |
|
User ID last modified by |
*MODIFIED_ BY |
Character 18 |
113 - 129 |
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.