PYMNT_IBANID_VW(SQL View) |
Index Back |
|---|---|
Payment - Supplier Bank AcountView used in query APY2030_TRIAL_PAYMENT_REGISTER. |
| SELECT A.PAY_CYCLE , A.PAY_CYCLE_SEQ_NUM , A.BANK_SETID , A.BANK_CD , A.BANK_ACCT_KEY , A.PYMNT_ID , A.SOURCE_TXN , A.PAY_DOC_ID , A.PAY_DOC_SEQ , A.EMPLID , A.EFT_KEY_FIELD6 , B.IBAN_ID FROM PS_PYCYCL_DATA A LEFT OUTER JOIN PS_VNDR_BANK_ACCT B ON A.REMIT_SETID = B.SETID AND A.VNDR_LOC = B.VNDR_LOC AND A.REMIT_VENDOR = B.VENDOR_ID AND ( A.SOURCE_TXN NOT IN ('EXAD' ,'EXPN') AND ( A.EFT_KEY_FIELD5 = 0 OR A.EFT_KEY_FIELD5 = B.BANK_ACCT_SEQ_NBR) OR A.SOURCE_TXN IN ('EXAD' ,'EXPN')) WHERE A.REMIT_SETID = ' ' OR ( A.REMIT_SETID <> ' ' AND (B.EFFDT IS NULL OR ( B.EFFDT = ( SELECT MAX(P_ED.EFFDT) FROM PS_VNDR_BANK_ACCT P_ED WHERE B.SETID = P_ED.SETID AND B.VENDOR_ID = P_ED.VENDOR_ID AND B.VNDR_LOC = P_ED.VNDR_LOC AND P_ED.EFFDT <= %CurrentDateIn)))) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PAY_CYCLE | Character(6) | VARCHAR2(6) NOT NULL | Pay Cycle |
| 2 | PAY_CYCLE_SEQ_NUM | Number(6,0) | INTEGER NOT NULL | Pay Cycle Sequence Number |
| 3 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 4 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 5 | 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 |
| 6 | PYMNT_ID | Character(10) | VARCHAR2(10) NOT NULL | Payment Number |
| 7 | SOURCE_TXN | Character(4) | VARCHAR2(4) NOT NULL | Source Transaction |
| 8 | PAY_DOC_ID | Character(20) | VARCHAR2(20) NOT NULL | Advice ID |
| 9 | PAY_DOC_SEQ | Number(5,0) | INTEGER NOT NULL | Advice Sequence |
| 10 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 11 | EFT_KEY_FIELD6 | Number(3,0) | SMALLINT NOT NULL | Bank Account Seq Number |
| 12 | IBAN_ID | Character(34) | VARCHAR2(34) NOT NULL | IBAN - Internation Bank Account Number is used in European countries to uniquely identify Bank accounts across borders |