SETIDPrompt Table: SP_SETID_NONVW
TD_FUND_CODEPrompt Table: TD_FUND_MASTER
ACCRUAL_NAMEPrompt Table: TD_FUND_ACCRUAL
CUST_IDPrompt Table: TD_CUST_OPRVW
TD_FUNDACCCUSVW(SQL View) |
Index Back |
|---|---|
Accrual customers for a fundAccrual customers for a fund |
| SELECT F.SETID , F.TD_FUND_CODE , F.ACCRUAL_NAME , F.CUST_ID , X.TD_NODE_ID , X.TD_SEQNO , F.ACCRUAL_RATE , F.CURRENCY_CD FROM PS_TD_FUND_ACC_CUS F , PS_TD_TREE_NODE X , PS_TD_FUND_ACCRUAL A , PS_SET_CNTRL_REC SC1 WHERE A.SETID=F.SETID AND A.TD_FUND_CODE = F.TD_FUND_CODE AND SC1.SETCNTRLVALUE = F.SETID AND SC1.RECNAME='CUSTOMER' AND SC1.SETID = X.SETID AND X.TD_TREE_ID = A.TD_TREE_ID_CUST AND X.EFFDT = A.TD_TREE_EFFDT_CUST AND X.CUST_ID = F.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 | 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
Prompt Table: TD_FUND_ACCRUAL |
| 4 | 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.
Prompt Table: TD_CUST_OPRVW |
| 5 | TD_NODE_ID | Character(8) | VARCHAR2(8) NOT NULL | Node ID |
| 6 | TD_SEQNO | Number(15,4) | DECIMAL(14,4) NOT NULL | Sequence Number |
| 7 | ACCRUAL_RATE | Number(14,3) | DECIMAL(13,3) NOT NULL | Accrual rate |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |