SII_PAY_AP_VW(SQL View) |
Index Back |
|---|---|
SII_PAY_AP_VW |
| SELECT P.business_unit , P.voucher_id , P.pymnt_cnt , P.pymnt_method , B.pymnt_dt , P.PAID_AMT , P.PAID_AMT_BSE , P.bank_setid , P.bank_cd , P.bank_acct_key , P.currency_pymnt , P.base_currency , P.CUR_RT_TYPE_PAID , H.VAT_ENTITY ,H.invoice_id %Concat P.voucher_id ,H.invoice_dt , S.SETID , H.VENDOR_ID FROM PS_PYMNT_VCHR_XREF P , PS_VOUCHER H , ps_PAYMENT_TBL B , PS_SET_CNTRL_REC S WHERE P.POST_STATUS_AP = 'P' AND B.bank_setId = P.bank_setid AND B.bank_cd = P.bank_cd AND b.BANK_ACCT_KEY = P.BANK_ACCT_KEY AND b.PYMNT_ID = p.PYMNT_ID AND P.business_unit = H.business_unit AND P.voucher_id = H.voucher_id AND H.VAT_DCLRTN_POINT = 'P' AND H.POST_STATUS_AP = 'P' AND S.SETCNTRLVALUE = H.BUSINESS_UNIT AND S.RECNAME = 'VENDOR' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 3 | PYMNT_CNT |
Number(5,0) | INTEGER NOT NULL | Payments |
| 4 | 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 |
| 5 | PYMNT_DT | Date(10) | DATE | Payment Date |
| 6 | PYMNT_GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Payment Amount |
| 7 | GROSS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Gross Amount |
| 8 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 9 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table: %EDITTABLE23 |
| 10 | 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
Prompt Table: BANK_VACCT_VW11 |
| 11 | CURRENCY_PYMNT | Character(3) | VARCHAR2(3) NOT NULL | Payment Currency |
| 12 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. " |
| 13 | CUR_RT_TYPE_PYMNT | Character(5) | VARCHAR2(5) NOT NULL | Payment Currency Rate Type |
| 14 | VAT_ENTITY | Character(20) | VARCHAR2(20) NOT NULL | Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements. |
| 15 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 16 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 17 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 18 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |