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 Price Schedule Line Layout (PPS)

The Product Price Schedule (PROD_PRICE_SCH) table stores pricing information.

To process Product Price Schedule Line Types, information from the Item, Item Product and Product Price Catalog tables (or input files for new records) must exist. This Line Type is required if a new Product Price Catalog line is provided.

The table can have multiple Product Price Schedule rows per Item/Catalog, but all quantities (.0001 - 9999999999.9999) must be accounted for in the provided date range. Quantities cannot interfere with existing rows.

The date range cannot contain gaps, and no new date range can overlap any existing rows. Each new row must have a start date either 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 in the From Quantity, To Quantity, Start Date, and End Date fields.

If the From Quantity, To Quantity, and End Date values exist, the application 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/2002 12/31/2004 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/2002 12/31/2004 549.16

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

FROM_QTY TO_QTY START_DT END_DT UNIT_PRICE_AMT
.0001 9999999999.9999 01/01/2002 03/31/2002 516.97
.0001 9999999999.9999 04/01/2002 12/31/2004 549.16

You can view or update the information stored in this table n the Manage Product Price Catalogs screen in Costpoint Product Definition. Some of the columns included in this table are accessible via the subtasks on this screen.

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 f 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 PPS is used to indicate Product Price Schedule information.
Item ID ITEM_ID Character 30 4 - 33 Yes If the Item ID/Item Revision ID/Price Catalog Code/From Quantity/To Quantity/End Date combination exists, the Product Price Schedule table is updated. The field value defaults to the Item ID if not applied. It must be a valid part/rev 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/Price Catalog Code/From Quantity/To Quantity/End Date combination exists, the Product Price Schedule table is updated. The field value defaults to the Item ID if not applied. It must be a valid part/rev 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 Product Price Catalog table.
Start Date START_DT Date (Maximum input file length - 10) 47 - 56 Yes The value must be valid date format YYYY-MM-DD.
End Date *END_DT Date (Maximum input file length - 10) 57 - 66 Yes The value must be valid date format YYYY-MM-DD.
Transaction Unit Price Amount *TRN_UNIT_PRICE_AMT Decimal 14.4 (maximum input file length - 16) 67 - 82 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.
From Quantity FROM_QTY Decimal 14.4 (maximum input file length - 15) 83 - 97 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) 98 - 112 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 113 - 130 No The default is UPLOAD. If a value is not provided, the program modifies the MODIFIED_BY column using the current user ID as the default.

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