PO_PAYVCNTRC_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT S.SETID , V.CNTRCT_ID , PV.PYMNT_ID , PV.BANK_SETID , PV.BANK_CD , PV.BANK_ACCT_KEY , PV.REMIT_SETID , PV.REMIT_VENDOR , PV.VNDR_LOC FROM PS_PYMNT_VCHR_XREF PV , PS_VOUCHER_LINE V , PS_SET_CNTRL_REC S WHERE PV.PYMNT_SELCT_STATUS = 'P' AND PV.BUSINESS_UNIT = V.BUSINESS_UNIT AND PV.VOUCHER_ID = V.VOUCHER_ID AND S.SETCNTRLVALUE = V.BUSINESS_UNIT AND S.RECNAME = 'CNTRCT_HDR' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CNTRCT_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CNTRCT_ID | Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
| 3 | PYMNT_ID | Character(10) | VARCHAR2(10) NOT NULL | Payment Number |
| 4 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 5 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 6 | 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 |
| 7 | REMIT_SETID | Character(5) | VARCHAR2(5) NOT NULL | Remit SetID |
| 8 | REMIT_VENDOR | Character(10) | VARCHAR2(10) NOT NULL | Remit Vendor |
| 9 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |