TD_PRM_MRCUS_VW

(SQL View)
Index Back

Promotion MerchTable by Cust

Promotion merchandizing table by customer

SELECT SETID , PPRC_PROMO_CD , CUST_ID , MERCH_TYPE , MERCH_SUB_TYPE , TD_ADJUST_TYPE , CURRENCY_CD , MERCH_COST , UNIT_OF_MEASURE , PAYMENT_METHOD_PL , UNIT_VALUE , UNITS_REDEEMED , UNIT_OF_MEASURE_SL , UNIT_HANDLING , REDEMPTION_PCT , COUPON_CD , INSERT_COST , START_DT , PERFORM_WEEKS , DST_ID , TD_INT_STATUS , EOEP_ACTION_TYPE , EOEP_ADJ_METHOD , PRICE_TYPE , OVERHEAD_COST , LUMPSUM_COST , PRODUCT_ID , PROMO_GROUP , CUST_ID2 , DESCR254_MIXED , EOEP_TIERED_FLG , EOEP_TIERED_INCRE , EOEP_ONETIME_FLG , EOEP_BAUSE_FLG , EOEP_MEPR_FLG , EOEP_MAX_QUANTITY , EOEP_PTD_FLG , EOEP_ALTCSTUSE_FLG , EOEP_COSTUSE_FLG , EOEP_LISTUSE_FLG , NUM_OF_ORDERS , RETURN_FLAG , EOEP_PRC_MATCH_FLG , TD_RMA_FLG FROM PS_TD_PRO_MERC_CUS

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

Default Value: TD_PROMO_CUST.SETID

Prompt Table: SP_SETTD_NONVW

2 TO_PPRC_PROMO_CD Character(20) VARCHAR2(20) NOT NULL To 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.

Default Value: TD_PROMO_CUST.CUST_ID

Prompt Table: %EDITTABLE

4 MERCH_TYPE Character(10) VARCHAR2(10) NOT NULL Merchandising Type

Default Value: TD_PROMO_MERCH.MERCH_TYPE

Prompt Table: TD_MERCH_TYP_VW
Set Control Field: SETID

5 MERCH_SUB_TYPE Character(10) VARCHAR2(10) NOT NULL Merchandising Subtype

Default Value: TD_PROMO_MERCH.MERCH_SUB_TYPE

Prompt Table: TD_MRCH_STYP_VW
Set Control Field: SETID

6 TD_ADJUST_TYPE Character(3) VARCHAR2(3) NOT NULL Adjustment Type
AC=Bill Back
GV=Giveaway
LS=Lump Sum
OI=Off-Invoice
7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: TD_PROMO_CUST.CURRENCY_CD

Prompt Table: CURRENCY_CD_TBL

8 MERCH_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Merchandising Cost
9 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Default Value: TD_PROMO_CUST.UNIT_OF_MEASURE

Prompt Table: UNITS_TBL

10 PAYMENT_METHOD_PL Character(1) VARCHAR2(1) NOT NULL Planned Payment Method
1=Deduction
2=Check
3=Field Draft
4=Credit Memo
6=Chargeback

Default Value: 2

11 UNIT_VALUE Number(15,4) DECIMAL(14,4) NOT NULL Unit Value
12 UNITS_REDEEMED Number(16,4) DECIMAL(15,4) NOT NULL Units Redeemed
13 UNIT_OF_MEASURE_SL Character(3) VARCHAR2(3) NOT NULL Selling Unit of Measure

Default Value: TD_SETID_TBL.UOM_PER

Prompt Table: UNITS_TBL

14 UNIT_HANDLING Number(15,4) DECIMAL(14,4) NOT NULL Unit Handling Cost
15 REDEMPTION_PCT Number(6,2) DECIMAL(5,2) NOT NULL Redemption Percent

Default Value: 100

16 COUPON_CD Character(10) VARCHAR2(10) NOT NULL Coupon Code
17 INSERT_COST Number(15,4) DECIMAL(14,4) NOT NULL Insertion Costs
18 START_DT Date(10) DATE Start Date
19 PERFORM_WEEKS Number(3,0) SMALLINT NOT NULL Performance weeks
20 DST_ID Character(10) VARCHAR2(10) NOT NULL Distribution Code

Default Value: TD_PROMO_CUST.DST_ID

Prompt Table: DSTCD_DIS_OM_VW

21 TD_INT_STATUS Character(1) VARCHAR2(1) NOT NULL Interface Status
A=Not Applicable
C=Changed
D=Deleted
M=Complete
N=New

Default Value: N

22 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
23 EOEP_ADJ_METHOD Character(1) VARCHAR2(1) NOT NULL Adjustment Method
1=Cascading
2=Summed
24 PRICE_TYPE Character(2) VARCHAR2(2) NOT NULL Price Type
P=Extended Price
Q=Quantity
V=Volume
W=Weight

Default Value: TD_SETID_TBL.PRICE_TYPE

25 OVERHEAD_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Overhead Cost
26 LUMPSUM_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Lump Sum Cost
27 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
28 PROMO_GROUP Character(10) VARCHAR2(10) NOT NULL Promotional Group
29 CUST_ID2 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.
30 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
31 EOEP_TIERED_FLG Character(1) VARCHAR2(1) NOT NULL Tiered Pricing Flag
N=No
Y=Yes
32 EOEP_TIERED_INCRE Signed Number(19,4) DECIMAL(17,4) NOT NULL Numeric Value
33 EOEP_ONETIME_FLG Character(1) VARCHAR2(1) NOT NULL One-Time Flag
1=No
2=Per Customer
3=Per Rule
34 EOEP_BAUSE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether to use with buying agreement.
N=No
Y=Yes
35 EOEP_MEPR_FLG Character(1) VARCHAR2(1) NOT NULL Mutually Exclusive Pricing Rule
N=No
Y=Yes
36 EOEP_MAX_QUANTITY Number(16,4) DECIMAL(15,4) NOT NULL Max Quantity
37 EOEP_PTD_FLG Character(1) VARCHAR2(1) NOT NULL Period To Date flag
N=No
R=By Rule
Y=By Customer
38 EOEP_ALTCSTUSE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether to apply to alternate cost base.
N=No
Y=Yes
39 EOEP_COSTUSE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether to use cost.
N=No
Y=Yes
40 EOEP_LISTUSE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether to use list price.
N=No
Y=Yes
41 NUM_OF_ORDERS Number(7,0) INTEGER NOT NULL Number of Orders
42 RETURN_FLAG Character(1) VARCHAR2(1) NOT NULL Can be returned
43 EOEP_PRC_MATCH_FLG Character(1) VARCHAR2(1) NOT NULL Indicate what to use to match price break
B=Base Price
N=Net Price
44 TD_RMA_FLG Character(1) VARCHAR2(1) NOT NULL Applicable to RMA
N=No
Y=Yes