TD_PMCNTRCT_VW1

(SQL View)
 Index Back

Promo Contract VW - No Formula


SELECT A.SETID , A.PPRC_PROMO_CD , A.DESCR , B.CUST_ID , B.UNIT_OF_MEASURE , B.SHIP_UNIT_PL , B.FIRST_ORDER_DATE , B.LAST_ORDER_DATE , B.FIRST_SHIP_DATE , B.LAST_SHIP_DATE , B.FIRST_DELIVERY_DT , B.LAST_DELIVERY_DT , B.FIRST_PERFORM_DT , B.LAST_PERFORM_DT , B.DESCR254_MIXED , B.CONTACT_ID , D.MERCH_TYPE_SYN , E.MERCH_TYPE , E.MERCH_SUB_TYPE , E.MERCH_COST , E.LUMPSUM_COST , E.INSERT_COST , E.UNIT_VALUE , E.UNIT_HANDLING , E.UNITS_REDEEMED , E.TD_ADJUST_TYPE , 0 , 0 , 0 , ' ' , 0 , ' ' , 0 , D.MERCH_ACTIVITY , B.DESCR254_MIXED , 0 , '01' , E.EOEP_MAX_QUANTITY , 0 , E.EOEP_ACTION_TYPE , E.EOEP_PTD_FLG , E.EOEP_TIERED_FLG , E.EOEP_MEPR_FLG , E.EOEP_ONETIME_FLG , E.EOEP_BAUSE_FLG , E.OVERHEAD_COST FROM PS_PPRC_PROMO_TBL A , PS_TD_PROMO_CUST B , PS_TD_MERCH_TYPE D , PS_TD_PRO_MERC_CUS E WHERE A.SETID = B.SETID AND A.PPRC_PROMO_CD = B.PPRC_PROMO_CD AND D.EFFDT = ( SELECT MAX(D_ED.EFFDT) FROM PS_TD_MERCH_TYPE D_ED WHERE D.SETID = D_ED.SETID AND D_ED.EFFDT <= %CurrentDateIn AND D.MERCH_TYPE = D_ED.MERCH_TYPE) AND A.SETID = E.SETID AND A.PPRC_PROMO_CD = E.PPRC_PROMO_CD AND E.CUST_ID = B.CUST_ID AND D.MERCH_TYPE = E.MERCH_TYPE

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 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.
5 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
6 SHIP_UNIT_PL Number(16,4) DECIMAL(15,4) NOT NULL Planned Ship Qty
7 FIRST_ORDER_DATE Date(10) DATE First Order Date
8 LAST_ORDER_DATE Date(10) DATE Last Order Date
9 FIRST_SHIP_DATE Date(10) DATE First Scheduled Ship Date
10 LAST_SHIP_DATE Date(10) DATE Last Scheduled Ship Date
11 FIRST_DELIVERY_DT Date(10) DATE Physical date of position.
12 LAST_DELIVERY_DT Date(10) DATE Last delivery date for a contract .
13 FIRST_PERFORM_DT Date(10) DATE First Peformance Date
14 LAST_PERFORM_DT Date(10) DATE Last Performance Date
15 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
16 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
17 MERCH_TYPE_SYN Character(2) VARCHAR2(2) NOT NULL Syndicated Merch Type
DP=Display
FD=Feature & Display
FE=Feature
FS=Frequent Shopper
TP=Temporary Price Reduction
18 MERCH_TYPE Character(10) VARCHAR2(10) NOT NULL Merchandising Type
19 MERCH_SUB_TYPE Character(10) VARCHAR2(10) NOT NULL Merchandising Subtype
20 MERCH_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Merchandising Cost
21 LUMPSUM_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Lump Sum Cost
22 INSERT_COST Number(15,4) DECIMAL(14,4) NOT NULL Insertion Costs
23 UNIT_VALUE Number(15,4) DECIMAL(14,4) NOT NULL Unit Value
24 UNIT_HANDLING Number(15,4) DECIMAL(14,4) NOT NULL Unit Handling Cost
25 UNITS_REDEEMED Number(16,4) DECIMAL(15,4) NOT NULL Units Redeemed
26 TD_ADJUST_TYPE Character(3) VARCHAR2(3) NOT NULL Adjustment Type
AC=Bill Back
GV=Giveaway
LS=Lump Sum
OI=Off-Invoice
27 BREAK_QTY_LOW Number(15,4) DECIMAL(14,4) NOT NULL Low Quantity/Amount
28 BREAK_QTY_HIGH Number(15,4) DECIMAL(14,4) NOT NULL Upper Quantity/Amount
29 DISCOUNT Signed Number(16,4) DECIMAL(14,4) NOT NULL This is price per unit for calculating the service charge.
30 FG_PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product Add
31 FG_QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity/BOGO Factor
32 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
33 PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL This is price per unit for calculating the service charge.
34 MERCH_ACTIVITY Character(1) VARCHAR2(1) NOT NULL Merchandising Activity type
C=Consumption
P=Purchasing
35 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
36 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
37 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
38 EOEP_MAX_QUANTITY Number(16,4) DECIMAL(15,4) NOT NULL Max Quantity
39 FG_DISCOUNT Signed Number(16,4) DECIMAL(14,4) NOT NULL This is price per unit for calculating the service charge.
40 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
41 EOEP_PTD_FLG Character(1) VARCHAR2(1) NOT NULL Period To Date flag
N=No
R=By Rule
Y=By Customer
42 EOEP_TIERED_FLG Character(1) VARCHAR2(1) NOT NULL Tiered Pricing Flag
N=No
Y=Yes
43 EOEP_MEPR_FLG Character(1) VARCHAR2(1) NOT NULL Mutually Exclusive Pricing Rule
N=No
Y=Yes
44 EOEP_ONETIME_FLG Character(1) VARCHAR2(1) NOT NULL One-Time Flag
1=No
2=Per Customer
3=Per Rule
45 EOEP_BAUSE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether to use with buying agreement.
N=No
Y=Yes
46 OVERHEAD_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Overhead Cost