PO_LN_PAYVCH_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT PL.BUSINESS_UNIT , PL.RFQ_ID , PV.BANK_SETID , PV.BANK_CD , PV.BANK_ACCT_KEY , PV.PYMNT_ID , P.PYMNT_ID_REF FROM PS_PYMNT_VCHR_XREF PV , PS_VOUCHER_LINE V , PS_PO_LINE PL , PS_PAYMENT_TBL P WHERE PV.PYMNT_SELCT_STATUS = 'P' AND PV.BUSINESS_UNIT = V.BUSINESS_UNIT AND PV.VOUCHER_ID = V.VOUCHER_ID AND V.BUSINESS_UNIT_PO = PL.BUSINESS_UNIT AND V.PO_ID = PL.PO_ID AND V.LINE_NBR = PL.LINE_NBR AND P.BANK_SETID = PV.BANK_SETID AND P.BANK_CD = PV.BANK_CD AND P.BANK_ACCT_KEY = PV.BANK_ACCT_KEY AND P.PYMNT_ID = PV.PYMNT_ID AND P.PYMNT_STATUS <> 'X' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | RFQ_ID | Character(10) | VARCHAR2(10) NOT NULL | RFQ ID |
| 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 | PYMNT_ID_REF | Character(20) | VARCHAR2(20) NOT NULL | Payment Reference |