The Product Cost Schedule (PROD_CST_SCH) table stores information used to calculate the Cost of Goods Sold.
You cannot process Product 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 Cost of Sales Calculation Code is "C" (Cost Schedule). Otherwise, the record will be rejected.
The table can have multiple Product Cost Schedule rows per Item/Catalog, but all quantities (.0001 - 9999999999.9999) must be accounted for in the provided date range. Quantities must not interfere with existing rows.
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 less than all existing start dates).
The Unit Cost 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 system will update 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_CST_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_CST_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_CST_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 (Cost Information subtask) in Costpoint Product Definition.
|
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 |
"PCS" is used to indicate Product Cost 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 Cost 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. |
|
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 Cost 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. |
|
Starting Date |
START_DT |
Date (maximum input file length - 10) |
47 - 56 |
Yes |
Value must be valid date format YYYY-MM-DD. |
|
Ending Date |
*END_DT |
Date (maximum input file length - 10) |
57 - 66 |
Yes |
Value must be valid date format YYYY-MM-DD. |
|
Unit Cost Amount |
*UNIT_CST_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.