PYMNT_UFFEC_ST2(SQL View) |
Index Back |
|---|---|
EDI Manager Pymt Intrmd Bank3Payments view for BANK CD type intermediate bank information derived from Treasury settlement instructions used for outbound payment file created through EDI manager "PAYMENT" map ID. |
| SELECT A.PAY_CYCLE , A.PAY_CYCLE_SEQ_NUM , A.BANK_SETID , A.BANK_CD , A.BANK_ACCT_KEY , A.PYMNT_METHOD , K.INTRMED_SEQ_NO , K.INTRMED_BANK_CD , K.INTRMED_ACCT_KEY , K.INTRMED_PYMNT_MSG , J.DFI_ID_NUM , J.BANK_ACCOUNT_NUM , J.CHECK_DIGIT , J.DFI_ID_QUAL , J.BRANCH_ID , J.BANK_ACCT_TYPE , J.BANK_ID_QUAL , J.BNK_ID_NBR , J.BENEF_BRANCH , J.ADDRESS1 , J.ADDRESS2 , J.ADDRESS3 , J.ADDRESS4 , J.CITY , J.IN_CITY_LIMIT , J.COUNTY , J.STATE , J.GEO_CODE , J.POSTAL , C.COUNTRY_2CHAR FROM PS_PAYMENT_TBL A , PS_PYCYCL_DATA B , PS_COUNTRY_TBL C , PS_STL_INSTRUCTION J , PS_STL_INTERM K WHERE A.PAY_CYCLE = B.PAY_CYCLE AND A.PAY_CYCLE_SEQ_NUM = B.PAY_CYCLE_SEQ_NUM AND A.BANK_SETID = B.BANK_SETID AND A.BANK_CD = B.BANK_CD AND A.BANK_ACCT_KEY = B.BANK_ACCT_KEY AND A.PYMNT_ID = B.PYMNT_ID AND C.COUNTRY = J.COUNTRY AND B.REMIT_BANK_SETID = K.SETID AND B.REMIT_BANK_CD = K.SETTLEMENT_ID AND B.CURRENCY_PYMNT = K.CURRENCY_CD AND K.SETID = J.SETID AND K.SETTLEMENT_ID = J.SETTLEMENT_ID AND K.CURRENCY_CD = J.CURRENCY_CD |
| # | 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_METHOD | Character(3) | VARCHAR2(3) NOT NULL |
Payment Method
ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Draft - Customer Initiated CHK=System Check D=Deposit DD=Direct Debit DFT=Draft - Supplier Initiated DRA=Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire WIR=Wire Transfer |
| 7 | INTRMED_SEQ_NO | Number(3,0) | SMALLINT NOT NULL | A numeric value that sequentially identifiers the series of banks utilized for a given m |
| 8 | INTRMED_BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | The intermediary transit bank utilized for multibank settlements. |
| 9 | INTRMED_ACCT_KEY | Character(4) | VARCHAR2(4) NOT NULL | The intermediary transit bank account utilized for multibank settlements. |
| 10 | INTRMED_PYMNT_MSG | Character(30) | VARCHAR2(30) NOT NULL | An internal work field that contains messaging associated with settlements subject to |
| 11 | DFI_ID_NUM | Character(12) | VARCHAR2(12) NOT NULL | A banking industry convention identifier utilized to drive electronic settlements processing for a given bank/coun |
| 12 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 13 | CHECK_DIGIT | Character(2) | VARCHAR2(2) NOT NULL | Check Digit |
| 14 | DFI_ID_QUAL | Character(2) | VARCHAR2(2) NOT NULL |
A banking industry convention identifier utilized to drive data validation for a given bank/counterparty.
01=Transit Number 02=Swift ID/BIC 03=CHIPS Participant ID 04=Canadian Bank Branch/Institute 05=CHIPS Universal ID ZZ=Mutually Defined |
| 15 | BRANCH_ID | Character(10) | VARCHAR2(10) NOT NULL | The local branch office identifier associated with a given bank/counterparty. |
| 16 | BANK_ACCT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
An account attribute that describes the ostensible purposes of a given bank/counterparty account.
01=Time Deposit 03=Checking Account 05=Stock 06=Bond 07=Life Insurance Value 08=Retirement Account 10=Business Account 11=Trust Fund Account 12=Stock & Bond Account 13=Life Insurance Acct CA=Current Account CH=Charges Account DA=Demand Deposit LN=Loan RD=Return Items on DDA RS=Return Items-Savings SA=Settlement Account SV=Savings Account Z=Mutually Defined |
| 17 | BANK_ID_QUAL | Character(3) | VARCHAR2(3) NOT NULL | "A bank/counterparty attribute that determines |
| 18 | BNK_ID_NBR | Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
| 19 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 20 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 21 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 22 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 23 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 24 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 25 | IN_CITY_LIMIT | Character(1) | VARCHAR2(1) NOT NULL | In City Limit |
| 26 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 27 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 28 | GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Geo Code |
| 29 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 30 | COUNTRY_TPRT_2CHAR | Character(2) | VARCHAR2(2) NOT NULL | Trading Partner 2-Char Country |