PYFRCST_CYCLE_IDBANK_SETIDBANK_CDBANK_ACCT_KEYPYFRCST_AGE_BUCKETPYFRCST_LDG_VW1(SQL View) |
Index Back |
|---|
| select pyfrcst_cycle_id, bank_setid, bank_cd, bank_acct_key, pyfrcst_age_bucket, txn_currency_cd, sum(pymnt_amt), count(distinct voucher_id) from PS_PYFRCST_LEDGER group by pyfrcst_cycle_id, bank_setid, bank_cd, bank_acct_key, pyfrcst_age_bucket, txn_currency_cd |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PYFRCST_CYCLE_ID |
Character(5) | VARCHAR2(5) NOT NULL | Payment Forecast Cycle ID |
| 2 | BANK_SETID |
Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 3 | BANK_CD |
Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 4 | BANK_ACCT_KEY |
Character(4) | VARCHAR2(4) NOT NULL | A user defined unique identifier that facilitates the identification of a given account with a given bank |
| 5 | PYFRCST_AGE_BUCKET |
Number(3,0) | SMALLINT NOT NULL | Aging Bucket |
| 6 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 7 | PYMNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment Amount |
| 8 | PYMNT_REC_CNT | Number(10,0) | DECIMAL(10) NOT NULL | Number of vchr_pymnt recs |