GPFR_PAY_EMP_S(SQL View) |
Index Back |
|---|---|
View on GPFR_PAYMENTView on GPFR_PAYMENT - Not used (???) |
| SELECT SRC_BANK_ID , CURRENCY_CD , RECIPIENT_ID , PAY_ENTITY , PMT_TYPE , PAYMENT_MTHD , PMT_STATUS , GPFR_BANK_CD , GPFR_BRANCH_EC_CD , GPFR_ACCOUNT_EC_ID , BANK_TRANSFER_ID , GPFR_BANK_NAME , GPFR_BANK_PAY_DT FROM PS_GPFR_PAYMENT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SRC_BANK_ID |
Character(8) | VARCHAR2(8) NOT NULL | Source Bank ID |
| 2 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 3 | RECIPIENT_ID | Character(8) | VARCHAR2(8) NOT NULL | Payment recipient ID |
| 4 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 5 | PMT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Payment Type
01=Net Pay Distribution 02=General Recipient Deduction 03=Individual Recipient Deduction |
| 6 | PAYMENT_MTHD | Character(1) | VARCHAR2(1) NOT NULL |
Payment Method
A=Cash C=Check O=Pay Primary Account Only P=Postal Order T=Bank Transfer U=Use Normal Distribution W=Wire Transfer |
| 7 | PMT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status field for a generated payment transaction
F=Finalized M=Manually Paid N=No Active Allocations P=Prepared T=Payment Transferred V=Hold W=Void |
| 8 | GPFR_BANK_CD | Character(11) | VARCHAR2(11) NOT NULL | GPFR: Bank ID |
| 9 | GPFR_BRANCH_EC_CD | Character(17) | VARCHAR2(17) NOT NULL | GPFR: Bank Branch ID |
| 10 | GPFR_ACCOUNT_EC_ID | Character(35) | VARCHAR2(35) NOT NULL | GPFR: Account # |
| 11 | BANK_TRANSFER_ID | Character(15) | VARCHAR2(15) NOT NULL | Bank Transfer ID |
| 12 | GPFR_BANK_NAME | Character(24) | VARCHAR2(24) NOT NULL | GPFR: Receiver's Bank Name |
| 13 | GPFR_BANK_PAY_DT | Character(5) | VARCHAR2(5) NOT NULL | GPFR: Payment Date After Formating |