TD_PROMO_PROD

(SQL Table)
Index Back

Promotion product relationship

This table define which products are valid for a promotion

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: TD_PROMO_MASTER.SETID

Prompt Table: SP_SETTD_NONVW

2 PPRC_PROMO_CD Character(20) VARCHAR2(20) NOT NULL Price Promotion Code

Default Value: TD_PROMO_MASTER.PPRC_PROMO_CD

Prompt Table: PPRC_PROMO_TBL

3 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: TD_PROM_P_OPRVW

4 PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL This is price per unit for calculating the service charge.
5 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: UNITS_TBL

6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
7 PROMO_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Promotional Price
8 SHELF_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Shelf Price
9 BASE_UNIT_WK Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Units Per Week
10 SHIP_UNIT_PL Number(16,4) DECIMAL(15,4) NOT NULL Planned Ship Qty
11 INCR_LIFT_PCT Number(5,1) DECIMAL(4,1) NOT NULL Increased Lift Percentage
12 PARTICIPATION_PCT Number(5,1) DECIMAL(4,1) NOT NULL Participation %
13 DISCOUNT_PCT Number(6,2) DECIMAL(5,2) NOT NULL Discount Percentage
14 PROTECT_PROMO Character(1) VARCHAR2(1) NOT NULL Protect Promotion

Default Value: N