PYMNT_ADVHDR_VW(SQL View) |
Index Back |
|---|---|
Expense Payment Sheet View |
| SELECT W.BENEFICIARY_BANK , W.BENEF_BRANCH , W.BANK_ACCOUNT_NUM , W.EMPLID , W.EMPL_RCD , W.BANK_ACCT_SEQ_NBR , X.ADVANCE_ID FROM PS_EX_EE_PYMNT_DTL W , PS_EX_ADV_HDR X WHERE W.EMPLID=X.EMPLID AND W.EMPL_RCD = X.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 | ADVANCE_ID | Character(10) | VARCHAR2(10) NOT NULL | Advance ID |