TD_OM_INQ_VW

(SQL View)
 Index Back

SELECT DISTINCT A.SETID , A.CUST_ID , A.PPRC_PROMO_CD , C.MERCH_TYPE , A.PRODUCT_ID , B.STATUS_TD , B.GRACE_DAYS , B.BUSINESS_UNIT_GL , B.TD_STOP_SEARCH , B.CONTACT_ID , 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.DESCR254_MIXED , A.TD_SEND_PRICE , A.PRICE , A.CURRENCY_CD , A.UNIT_OF_MEASURE , C.MERCH_SUB_TYPE , C.DST_ID , A.SHIP_UNIT_PL , C.TD_ADJUST_TYPE , C.EOEP_PTD_FLG , C.EOEP_ACTION_TYPE , C.EOEP_ADJ_METHOD , C.EOEP_MAX_QUANTITY , C.EOEP_TIERED_FLG , C.EOEP_TIERED_INCRE , C.EOEP_MEPR_FLG , C.EOEP_BAUSE_FLG , C.EOEP_COSTUSE_FLG , C.EOEP_ALTCSTUSE_FLG , C.EOEP_LISTUSE_FLG , C.EOEP_ONETIME_FLG FROM PS_TD_PRO_CUST_PRI A , PS_TD_PROMO_CUST B , PS_TD_PRO_MERC_CUS C WHERE A.SETID = B.SETID AND A.SETID = C.SETID AND A.PPRC_PROMO_CD = B.PPRC_PROMO_CD AND A.PPRC_PROMO_CD = C.PPRC_PROMO_CD AND A.CUST_ID = B.CUST_ID AND A.CUST_ID = C.CUST_ID

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

Prompt Table: SP_SETID_NONVW

2 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.
3 PPRC_PROMO_CD Character(20) VARCHAR2(20) NOT NULL Price Promotion Code
4 MERCH_TYPE Character(10) VARCHAR2(10) NOT NULL Merchandising Type
5 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
6 STATUS_TD Character(2) VARCHAR2(2) NOT NULL Promotion Status
CA=Customer Approved
CE=Customer Cancelled
CL=Closed
CR=Customer Rejected
MA=Management Approved
MR=Management Rejected
PA=Pending Approval
PL=Planned
RE=Recalled
RL=Released
7 GRACE_DAYS Number(3,0) SMALLINT NOT NULL Grace Days
8 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
9 TD_STOP_SEARCH Character(1) VARCHAR2(1) NOT NULL Stop Applying Discounts
10 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
11 FIRST_ORDER_DATE Date(10) DATE First Order Date
12 LAST_ORDER_DATE Date(10) DATE Last Order Date
13 FIRST_SHIP_DATE Date(10) DATE First Scheduled Ship Date
14 LAST_SHIP_DATE Date(10) DATE Last Scheduled Ship Date
15 FIRST_DELIVERY_DT Date(10) DATE Physical date of position.
16 LAST_DELIVERY_DT Date(10) DATE Last delivery date for a contract .
17 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
18 TD_SEND_PRICE Character(1) VARCHAR2(1) NOT NULL Send To Pricing
19 PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL This is price per unit for calculating the service charge.
20 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
21 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
22 MERCH_SUB_TYPE Character(10) VARCHAR2(10) NOT NULL Merchandising Subtype
23 DST_ID Character(10) VARCHAR2(10) NOT NULL Distribution Code
24 SHIP_UNIT_PL Number(16,4) DECIMAL(15,4) NOT NULL Planned Ship Qty
25 TD_ADJUST_TYPE Character(3) VARCHAR2(3) NOT NULL Adjustment Type
AC=Bill Back
GV=Giveaway
LS=Lump Sum
OI=Off-Invoice
26 EOEP_PTD_FLG Character(1) VARCHAR2(1) NOT NULL Period To Date flag
N=No
R=By Rule
Y=By Customer
27 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
28 EOEP_ADJ_METHOD Character(1) VARCHAR2(1) NOT NULL Adjustment Method
1=Cascading
2=Summed
29 EOEP_MAX_QUANTITY Number(16,4) DECIMAL(15,4) NOT NULL Max Quantity
30 EOEP_TIERED_FLG Character(1) VARCHAR2(1) NOT NULL Tiered Pricing Flag
N=No
Y=Yes
31 EOEP_TIERED_INCRE Signed Number(19,4) DECIMAL(17,4) NOT NULL Numeric Value
32 EOEP_MEPR_FLG Character(1) VARCHAR2(1) NOT NULL Mutually Exclusive Pricing Rule
N=No
Y=Yes
33 EOEP_BAUSE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether to use with buying agreement.
N=No
Y=Yes
34 EOEP_COSTUSE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether to use cost.
N=No
Y=Yes
35 EOEP_ALTCSTUSE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether to apply to alternate cost base.
N=No
Y=Yes
36 EOEP_LISTUSE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether to use list price.
N=No
Y=Yes
37 EOEP_ONETIME_FLG Character(1) VARCHAR2(1) NOT NULL One-Time Flag
1=No
2=Per Customer
3=Per Rule