Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Product Warranty Cost Schedule Line Layout (PWS)

The Product Warranty Cost Schedule (PROD_WARR_CST_SCH) table stores information used to calculate the warranty costs.

You cannot process Product Warranty Cost Schedule Line Types unless information from the Item, Item Product, and Product Price Catalog tables (or input files for new records) 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 Unit Cost Amount can be updated if values exist for the Start Date and End Date fields.

If the End Date value exists, the program 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 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 UNIT_CST_AMT
04/01/2006 12/31/2007 549.16

The End Date of the existing row is modified and a new row is inserted. The two rows contain the following values:

START_DT END_DT 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 Warranty Information subtask of the Manage Product Price Catalogs screen in Costpoint Product Definition.

Note: The application uses defaults for INSERTS ONLY if the input file field value is not provided. The exception is MODIFIED_BY, which is updated using the default value if no value is provided.
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 PWS is used to indicate Product Warranty Cost Schedule information.
Item ID ITEM_ID Character 30 4 - 33 Yes If the Item ID/Item Revision ID/Price Catalog Code/End Date combination exists, the Product Warranty Cost 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 Yes (If revisions are used) If the Item ID/Item Revision ID/Price Catalog Code/End Date combination exists, the Product Warranty Cost Schedule table is updated. Defaults to 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.

Price Catalog Code PRICE_CATLG_CD Character 10 37 - 46 Yes The value must exist in the Price Catalog table.
Unit Cost Amount *UNIT_CST_AMT Decimal 14.4 (maximum input file length - 16) 47 - 62 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.
Starting Date START_DT Date (maximum input file length - 10) 63 - 72 Yes The value must be valid date format YYYY-MM-DD.
Ending Date *END_DT Date (maximum input file length - 10) 73 - 82 Yes The value must be valid date format YYYY-MM-DD.
User ID last modified by *MODIFIED_BY Character 18 83 - 100 No The default 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.
PROD_WARR_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.

* Indicates columns that may be updated when changing an existing record with this preprocessor.