TD_FUND_CST_VW

(SQL View)
 Index Back

Valid funds for a customer


SELECT A.SETID , C.CUST_ID , A.CURRENCY_CD , A.TD_FUND_CODE , B.DESCR , B.FUND_START_DT , B.FUND_END_DT , SUM(A.BUDGETED_AMT) - SUM(A.DISTRIB_AMT) , B.FUND_METHOD , B.BUSINESS_UNIT_GL FROM PS_TD_FUND_DISTRIB A , PS_TD_FUND_MASTER B , PS_TD_TREE_NODE C , PS_SET_CNTRL_REC D WHERE A.SETID = B.SETID AND A.TD_FUND_CODE = B.TD_FUND_CODE AND A.SETID = D.SETCNTRLVALUE AND D.RECNAME = 'CUSTOMER' AND D.SETID = C.SETID AND A.TD_NODE_ID = C.TD_NODE_ID AND B.TD_TREE_ID_CUST = C.TD_TREE_ID AND B.TD_TREE_EFFDT_CUST = C.EFFDT AND B.FUND_TYPE = 'D' AND B.TD_STATUS = 'A' AND b.status = 'A' GROUP BY A.SETID , C.CUST_ID , A.CURRENCY_CD , A.TD_FUND_CODE , B.DESCR , B.FUND_START_DT , B.FUND_END_DT , B.FUND_METHOD , B.BUSINESS_UNIT_GL

  • Related Language Record: TD_FUNDCUST_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    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 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    4 TD_FUND_CODE Character(10) VARCHAR2(10) NOT NULL Promotions Management Fund Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 FUND_START_DT Date(10) DATE Start Date
    7 FUND_END_DT Date(10) DATE End Date
    8 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
    9 FUND_METHOD Character(1) VARCHAR2(1) NOT NULL Funding Method
    F=Fixed Accrual
    R=Rolling Accrual
    T=Top Down
    Z=Zero-Based Accrual
    10 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit