PYMNT_SHEET_VW(SQL View) |
Index Back |
|---|---|
Expense Payment Sheet View |
| SELECT P.BENEFICIARY_BANK , P.BENEF_BRANCH , P.BANK_ACCOUNT_NUM , P.EMPLID , P.EMPL_RCD , P.BANK_ACCT_SEQ_NBR , Q.SHEET_ID FROM PS_EX_EE_PYMNT_DTL P , PS_EX_SHEET_HDR Q WHERE P.EMPLID=Q.EMPLID AND P.EMPL_RCD = Q.EMPL_RCD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BENEFICIARY_BANK | Character(30) | VARCHAR2(30) NOT NULL | The bank/counterparty associated with a given beneficiary. |
| 2 | BENEF_BRANCH | Character(30) | VARCHAR2(30) NOT NULL | Beneficiary Branch field |
| 3 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 6 | BANK_ACCT_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Bank Account Sequence Number |
| 7 | SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Report ID |