TD_ACC_PRD_VW

(SQL View)
 Index Back

Product For Accrual Override

Selected Products for Accruals with a product override

SELECT DISTINCT X.SETID , X.TD_FUND_CODE , X.ACCRUAL_NAME , D.PRODUCT_ID , A.TD_NODE_ID FROM PS_PROD_ITEM D , PS_TD_FUND_ACC_PRD C , PS_TD_TREE_NODE A , PS_TD_FUND_ACCRUAL X , PS_SET_CNTRL_REC SC WHERE SC.SETCNTRLVALUE = X.SETID AND SC.RECNAME = 'PROD_ITEM' AND SC.SETID = D.SETID AND X.SETID = C.SETID AND X.TD_FUND_CODE = C.TD_FUND_CODE AND X.ACCRUAL_NAME = C.ACCRUAL_NAME AND D.SETID = A.SETID AND X.TD_TREE_ID_PROD = A.TD_TREE_ID AND X.TD_TREE_EFFDT_PROD = A.EFFDT AND (A.PROMO_GROUP = C.PROMO_GROUP OR A.PRODUCT_ID = C.PRODUCT_ID) AND D.PRODUCT_ID = A.PRODUCT_ID

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

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 TD_FUND_CODE Character(10) VARCHAR2(10) NOT NULL Promotions Management Fund Code

Prompt Table: TD_FUND_MASTER

3 ACCRUAL_NAME Character(10) VARCHAR2(10) NOT NULL Accrual Name
4 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
5 TD_NODE_ID Character(8) VARCHAR2(8) NOT NULL Node ID