TD_PRM_MRCUS_VW(SQL View) |
Index Back |
---|---|
Promotion MerchTable by CustPromotion 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
|
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
|
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 |