PRODUCT PRICE SCHEDULE (PPS)

Product Price Schedule Line Layout

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 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/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 in the Set Up Product Price Catalogs screen in Costpoint Product Definition. Some of the columns included in this table are accessible via the pushbuttons located on this screen.

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 Item ID / Item Revision ID / Price Catalog Code / From Quantity / To Quantity /End Date exists, Product Price Schedule table will be updated. The field value will default to Item ID if no applied. It must be a valid part/rev if not null. If you did not select the Allow Multiple Revisions for Each Item checkbox in Product Definition Settings, the revision will not be checked.

Item Revision ID

ITEM_RVSN_ID

Character 3

34 - 36

No

If Item ID / Item Revision ID / Price Catalog Code / From Quantity / To Quantity /End Date exists, Product Price Schedule table will be updated. Defaults to Item ID value if not applied. Must be a valid part/rev if not null. If you did not select the Allow Multiple Revisions for Each Item checkbox in Product Definition Settings, the revision will not be checked.

Price Catalog Code

PRICE_ CATLG_CD

Character 10

37 - 46

Yes

Value must exist in the Product Price Catalog table.

Start Date

START_DT

Date (Maximum input file length - 10)

47 - 56

Yes

Value must be valid date format YYYY-MM-DD.

End Date

*END_DT

Date (Maximum input file length - 10)

57 - 66

Yes

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

Input file format is -9999999999.9999 (maximum 16 characters including the decimal point and optional minus sign (indicating a negative number)).  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

Default .0001.  Input file format is 9999999999.9999 (maximum 15 characters including the decimal point).  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

Default 9999999999.9999.  Input file format is 9999999999.9999 (maximum 15 characters including the decimal point).  Maximum value is 9999999999.9999.  No embedded commas are allowed.

User ID last modified by

*MODIFIED_BY

Character 18

113 - 130

No

If a value is not provided, the program will modify 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.