PRODUCT PRICE CATALOG (PPC)

Product Price Catalog Line Layout

The Product Price Catalog (PROD_PRICE_CATLG) table stores Catalog Product Unit Pricing information.

You cannot process Product Price Catalog Line Types unless the Item and Item Product tables exist. You must also provide information from the Product Price Schedule table, as outlined in the next section, "Product Price Schedule (PPS)." 

If the Product Price Schedule's Cost of Sales Calculation Code is "C" (Cost Schedule), a line type for the Product Cost Schedule must exist or must be provided (refer to the "Product Price Schedule (PPS)" section). If the Product Price Schedule's Warranty Cost Calculation Code is "C" (Cost Schedule), a line type for the Product Warranty Cost Schedule must exist or must be provided (refer to the "Product Warranty Cost Schedule (PWS)" section).

If the Product Price Schedule's Cost of Sales Calculation Code is updated to "P" (Percentage of Sales), all existing Product Cost Schedule rows for the item will be deleted. If the Product Price Schedule's Warranty Cost Calculation Code is updated to "P" (Percentage of Sales), all existing Product Warranty Cost Schedule rows for the item will be deleted.

You can view or update the information stored in this table in the Set Up Product Price Catalogs screen in Costpoint Product Definition.

The application uses default values 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

"PPC" is used to indicate Product Price Catalog information.

Item ID

ITEM_ID

Character 30

4 - 33

Yes

If Item ID / Item Revision ID/ Price Catalog Code combination exists, Product Price Catalog table will be updated. 

Item Revision ID

ITEM_RVSN_ ID

Character 3

34 - 36

Yes (if revisions are used)

If Item ID / Item Revision ID/ Price Catalog Code combination exists, Product Price Catalog table will be updated. Default is space.

Price Catalog Code

PRICE_ CATLG_CD

Character 10

37 - 46

Yes

Value must exist in the Price Catalog table.

Certificate of Conformance Flag

*CERT_OF_ CONF_ FL

Character 1

47

No

Value must be "Y" (Yes) or "N" (No).  Default retrieved from the Item Product table.

Cost of Sales Percentage Rate

*COGS_PCT_ RT

Decimal 5.4 (maximum input file length - 6)

48 - 53

No.  Required for inserted records if Cost of Sales Calculation Code is "P."

Value can be greater than zero if Cost of Sales Calculated Code is "P" (for inserted records). Default is "0."  Input file format is "9.9999" (maximum six characters including the decimal point).  Maximum value is "9.9999."  No embedded commas are allowed.

Note: Cost of Sales Percentage Rate will be updated to "0" if Cost of Sales Calculation Code is updated to "C."

Defer Revenue Flag

*DEFER_REV_FL

Character 1

54

No

Value must be "Y" (Yes) or "N" (No).  Default retrieved from Item Product table.

External Warranty Code

*EXT_WARR_CD

Character 6

55 - 60

No

If provided, value must exist in the Warranty table.  Default is null.

Installment Bill Flag

*INSTALL_ BILL_FL

Character 1

61

No

Value must be "Y" (Yes) or "N" (No).  Default retrieved from Item Product table.

Internal Warranty Code

*INT_WARR_ CD

Character 6

62 - 67

No

If provided, value must exist in the Warranty table.  Default NULL.

Inventory Abbreviation Code

*INVT_ ABBRV_CD

Character 6

68 - 73

No

If provided, value must exist in the Inventory Abbreviation code table (in Inventory Projects screen in the Inventory Controls menu).  Default is null. Must exist for user's Company ID.

Sales Group Abbreviation Code

*SALES_ ABBRV_CD

Character 6

74 - 79

No

If provided, value must exist in the Sales Group Abbreviation Code table (in Set Up Sales Group Abbreviations screen in Costpoint Product Definition). Default is null. Must exist for user's company ID.

Source Inspection Flag

*SRCE_INSP_ FL

Character 1

80

No

Value must be "Y" (Yes) or "N" (No).  Default is "N."

Cost of Sales Calculation Code

*S_COGS_ CALC_CD

Character 1

81

No

Value can be "P" (Percentage) or "C" (Cost Schedule).  Default is "P."

Sales Order Line Type Code

*S_PROD_LN_TYPE_
CD

Character 6

82 - 87

No

Value can be "DRP" (Drop Shipment), "INT" (In Transit), "INO" (Invoice), "INV" (Inventory), or "REC" (Recurring).  Default retrieved from Item Product table.

Warranty Cost Calculation Code

*S_WARR_CST_CALC_CD

Character 1

88

No

Value can be "P" (Percentage) or "C" (Cost Schedule).  Default is "P."

Warranty Percentage Rate

*WARR_PCT_RT

Decimal 5.4 (maximum input file length - 6)

89 - 94

No.  Required for inserts if Warranty Cost Calculation Code is "P."

Value can be greater than zero if Warranty Cost Calculation Code is "P."  Default is "0."  Input file format is "9.9999" (maximum six characters including the decimal point).  Maximum value is "9.9999."  No embedded commas are allowed.

Note: Warranty Percentage Rate will be updated to "0" if Warranty Cost Calculation Code is updated to "C."

User ID last modified by

*MODIFIED_ BY

Character 18

95 - 112

No

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