TD_PRM_COST_VW2

(SQL View)
 Index Back

Promo Group View for Pagelet

Promo Group records for use with Pagelets - referenced only by standalone SQL.TD_GET_DATA_FOR_PRO_COST

SELECT A.SETID , A.PPRC_PROMO_CD , A.CUST_ID , A.MERCH_TYPE , C.MERCH_ACTIVITY , B.DISCOUNT , B.BREAK_QTY_HIGH , B.FG_QUANTITY , A.TD_ADJUST_TYPE , A.LUMPSUM_COST , A.EOEP_ACTION_TYPE , A.EOEP_PTD_FLG , D.SHIP_UNIT_PL , A.PRICE_TYPE , A.INSERT_COST , A.UNIT_VALUE , A.UNITS_REDEEMED , B.EOEP_ADJST_FLG , B.FG_DISCOUNT , B.TD_FG_PCT_AMT_TYPE , B.FG_PRICE , A.UNIT_HANDLING , A.OVERHEAD_COST , A.PRODUCT_ID , A.PROMO_GROUP FROM PS_TD_PRO_MERC_CUS A , PS_TD_PRO_MERBRK_C B , PS_TD_MERCH_TYPE C , PS_TD_PRO_CUST_PRI D WHERE A.SETID = B.SETID AND A.PPRC_PROMO_CD = B.PPRC_PROMO_CD AND A.CUST_ID = B.CUST_ID AND A.MERCH_TYPE = B.MERCH_TYPE AND C.EFFDT = ( SELECT MAX(C_ED.EFFDT) FROM PS_TD_MERCH_TYPE C_ED WHERE C.SETID = C_ED.SETID AND C_ED.EFFDT <= %CurrentDateIn AND C.MERCH_TYPE = C_ED.MERCH_TYPE) AND A.MERCH_TYPE = C.MERCH_TYPE AND A.SETID = D.SETID AND A.PPRC_PROMO_CD = D.PPRC_PROMO_CD AND A.CUST_ID = D.CUST_ID AND A.PRODUCT_ID <> D.PRODUCT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 PPRC_PROMO_CD Character(20) VARCHAR2(20) NOT NULL Price Promotion Code
3 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
4 MERCH_TYPE Character(10) VARCHAR2(10) NOT NULL Merchandising Type
5 MERCH_ACTIVITY Character(1) VARCHAR2(1) NOT NULL Merchandising Activity type
C=Consumption
P=Purchasing
6 DISCOUNT Signed Number(16,4) DECIMAL(14,4) NOT NULL This is price per unit for calculating the service charge.
7 BREAK_QTY_HIGH Number(15,4) DECIMAL(14,4) NOT NULL Upper Quantity/Amount
8 FG_QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity/BOGO Factor
9 TD_ADJUST_TYPE Character(3) VARCHAR2(3) NOT NULL Adjustment Type
AC=Bill Back
GV=Giveaway
LS=Lump Sum
OI=Off-Invoice
10 LUMPSUM_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Lump Sum Cost
11 EOEP_ACTION_TYPE Character(2) VARCHAR2(2) NOT NULL Action Type
1=Discount/Surcharge
10=CRM Free Period Promotion
11=CRM Product Add
12=Pricing Base
13=Rollup Only Rule
14=Min/Max Margin
2=Price Override
3=Product Add
4=Total Order Discount/Surcharge
5=Min/Max Target Price
6=Min/Max Target Discount
7=Min/Max Target Surcharge
8=Related Busines Objects
9=Price List Only Condition
99=Standard Discount
12 EOEP_PTD_FLG Character(1) VARCHAR2(1) NOT NULL Period To Date flag
N=No
R=By Rule
Y=By Customer
13 SHIP_UNIT_PL Number(16,4) DECIMAL(15,4) NOT NULL Planned Ship Qty
14 PRICE_TYPE Character(2) VARCHAR2(2) NOT NULL Price Type
P=Extended Price
Q=Quantity
V=Volume
W=Weight
15 INSERT_COST Number(15,4) DECIMAL(14,4) NOT NULL Insertion Costs
16 UNIT_VALUE Number(15,4) DECIMAL(14,4) NOT NULL Unit Value
17 UNITS_REDEEMED Number(16,4) DECIMAL(15,4) NOT NULL Units Redeemed
18 EOEP_ADJST_FLG Character(2) VARCHAR2(2) NOT NULL Adjustment Flag
01=Amount
02=Percentage
03=Price
04=External Class
05=Math Expression
06=Quantity
07=BOGO Factor
08=Quantity with Price
09=BOGO with Price
10=Quantity Expression
11=Amount And Math Expression
12=Percentage And Math Expression
13=Price And Math Expression
19 FG_DISCOUNT Signed Number(16,4) DECIMAL(14,4) NOT NULL This is price per unit for calculating the service charge.
20 TD_FG_PCT_AMT_TYPE Character(1) VARCHAR2(1) NOT NULL Product Add Percent/Amount
A=Amount
P=Percent
21 FG_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Product Add Price/Cost
22 UNIT_HANDLING Number(15,4) DECIMAL(14,4) NOT NULL Unit Handling Cost
23 OVERHEAD_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Overhead Cost
24 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
25 PROMO_GROUP Character(10) VARCHAR2(10) NOT NULL Promotional Group