TD_FUND_CUS1_VW (SQL View)	Index Back
Valid funds for an Allowance Valid Non-discretionary funds for a National allowance

TD_FUND_CUS1_VW

(SQL View)

Valid funds for an Allowance

Valid Non-discretionary funds for a National allowance

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) , 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 , PS_TD_FUND_CUST E WHERE A.SETID = B.SETID AND A.TD_FUND_CODE = B.TD_FUND_CODE AND A.SETID = E.SETID AND A.TD_FUND_CODE = E.TD_FUND_CODE AND A.CUST_ID = E.CUST_ID 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 = 'N' AND B.TD_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

# 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

#	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