VCHR_PPAY_VW(SQL View) |
Index Back |
|---|
| SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , B.PYMNT_CNT , A.VENDOR_SETID , A.VENDOR_ID , A.TXN_CURRENCY_CD , A.INVOICE_ID , A.GROSS_AMT , C.REMIT_VENDOR , A.VNDR_LOC , C.CURRENCY_PYMNT , C.PYMNT_ID , C.PYMNT_SELCT_STATUS , C.PAID_AMT , C.PYMNT_HANDLING_CD , C.RATE_MULT , C.RATE_DIV , C.RT_TYPE , C.CUR_RT_TYPE_PYMNT , B.WTHD_AMT , A.WTHD_PREPAY_OPT , A.BASE_CURRENCY , C.CUR_RT_TYPE_PAID , C.BANK_SETID , C.BANK_CD , C.BANK_ACCT_KEY , C.PYMNT_RATE_MULT , C.PYMNT_RATE_DIV , C.PAID_RATE_MULT , C.PAID_RATE_DIV , C.CUR_RT_TYPE_BNK , C.BNK_RATE_MULT , C.BNK_RATE_DIV , A.VCHR_SRC , A.PREPAID_REF FROM PS_VOUCHER A , PS_VCHR_PPAY_XREF B , PS_PYMNT_VCHR_XREF C WHERE A.VOUCHER_STYLE = 'PPAY' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.VOUCHER_ID = C.VOUCHER_ID AND B.PYMNT_CNT = C.PYMNT_CNT AND C.PYMNT_SELCT_STATUS = 'P' AND B.PREPAID_STATUS IN ('P', 'F') AND C.PYMNT_ACTION NOT IN('W','X') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_AP_NONVW |
| 2 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 3 | PYMNT_CNT |
Number(5,0) | INTEGER NOT NULL | Payments |
| 4 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 5 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: VENDOR_VW |
| 6 | TXN_CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 7 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 8 | GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Invoice Amount |
| 9 | REMIT_VENDOR | Character(10) | VARCHAR2(10) NOT NULL | Remit Vendor |
| 10 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 11 | CURRENCY_PYMNT | Character(3) | VARCHAR2(3) NOT NULL | Payment Currency |
| 12 | PYMNT_ID | Character(10) | VARCHAR2(10) NOT NULL | Payment Number |
| 13 | PYMNT_SELCT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payment Selection Status
C=Closed D=Negative Voucher Sum E=Externally Paid F=Federal Sanctions Error I=In Process - EFT N=Not Selected for Payment O=Financial Sanctions Review P=Paid R=Requested for Payment S=Settlement Payment V=Convert Error X=Canceled Y=Prepaid |
| 14 | PAID_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Paid Amount |
| 15 | PYMNT_HANDLING_CD | Character(2) | VARCHAR2(2) NOT NULL | Payment Handling |
| 16 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 17 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 18 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
| 19 | CUR_RT_TYPE_PYMNT | Character(5) | VARCHAR2(5) NOT NULL | Payment Currency Rate Type |
| 20 | WTHD_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 21 | WTHD_PREPAY_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Signifies if Withholding applies to the prepayment
N=Not Applicable V=Postpone to regular voucher Default Value: N |
| 22 | 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. " |
| 23 | CUR_RT_TYPE_PAID | Character(5) | VARCHAR2(5) NOT NULL | Payment Rate Type |
| 24 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 25 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 26 | 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 |
| 27 | PYMNT_RATE_MULT | Number(16,8) | DECIMAL(15,8) NOT NULL | An internal convention utilized for determining whether a currency exchange rate is stored |
| 28 | PYMNT_RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | An internal convention utilized for determining whether a currency exchange rate is store |
| 29 | PAID_RATE_MULT | Number(16,8) | DECIMAL(15,8) NOT NULL | An internal convention utilized for determing whether a currency exchange spot rate is stored either as |
| 30 | PAID_RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | An internal convention utilized for determing whether a currency exchange spot rate is store |
| 31 | CUR_RT_TYPE_BNK | Character(5) | VARCHAR2(5) NOT NULL | Currency Rate Type |
| 32 | BNK_RATE_MULT | Number(16,8) | DECIMAL(15,8) NOT NULL | An internal convention utilized for determining whether a currency exchange spot rate is stored either as |
| 33 | BNK_RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | An internal convention utilized for determining whether a currency exchange spot rate is store |
| 34 | VCHR_SRC | Character(4) | VARCHAR2(4) NOT NULL | Voucher Source |
| 35 | PREPAID_REF | Character(10) | VARCHAR2(10) NOT NULL | Prepayment Reference |