ADVANCE_IDA=Alignment
E=ACH/EFT Prenote
L=Stale Dated Payment
N=Reprinted with same ref number
O=Overflow
P=Paid
R=Replaced
S=Stopped
T=Undo Escheatment
U=Undo Cancel
V=Void
W=Escheated Check
X=Deleted
EX_EE_A_PYMT_VW(SQL View) |
Index Back |
|---|---|
Advance Payment View |
| SELECT DISTINCT A.ADVANCE_ID , B.BANK_SETID , B.BANK_CD , B.BANK_ACCT_KEY , B.PYMNT_ID , C.PYMNT_ID_REF , C.PYMNT_STATUS FROM PS_EX_ADV_HDR A , PS_EX_ADVNCE_PYMNT B , PS_PAYMENT_TBL C WHERE A.ADVANCE_ID = B.ADVANCE_ID AND B.SEQ_NBR = ( SELECT MAX(X.SEQ_NBR) FROM PS_EX_ADVNCE_PYMNT X WHERE X.ADVANCE_ID = A.ADVANCE_ID) AND C.BANK_SETID = B.BANK_SETID AND C.BANK_CD = B.BANK_CD AND C.BANK_ACCT_KEY = B.BANK_ACCT_KEY AND C.PYMNT_ID = B.PYMNT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ADVANCE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Advance ID |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 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 | PYMNT_ID | Character(10) | VARCHAR2(10) NOT NULL | Payment Number |
| 6 | PYMNT_ID_REF | Character(20) | VARCHAR2(20) NOT NULL | Payment Reference |
| 7 | PYMNT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payment Status
A=Alignment E=ACH/EFT Prenote L=Stale Dated Payment N=Reprinted with same ref number O=Overflow P=Paid R=Replaced S=Stopped T=Undo Escheatment U=Undo Cancel V=Void W=Escheated Check X=Deleted |