VCHR_APPL_VW(SQL View) |
Index Back |
|---|
| SELECT A.REMIT_SETID , A.REMIT_VENDOR , A.VNDR_LOC , A.PREPAID_STATUS , A.BUSINESS_UNIT , A.VOUCHER_ID , C.INVOICE_ID , A.PYMNT_CNT , A.PPAY_SEQNUM , A.PYMNT_GROSS_AMT , A.PYMNT_ID , A.BANK_SETID , A.BANK_CD , A.BANK_ACCT_KEY , A.PAID_AMT , A.CURRENCY_PYMNT , B.PYMNT_HANDLING_CD , B.RATE_MULT , B.RATE_DIV , B.CUR_RT_TYPE_PYMNT , A.APPLIED_AMT_PPAY , A.AVAILABLE_AMT , A.PREPAID_APPLIED_BU , A.PREPAID_APPL_VCHR , A.PREPAID_APPL_PYMNT , A.REV_POST_STATUS , A.CF_BAL_LINE_NUM FROM PS_VCHR_PPAY_XREF A , PS_PYMNT_VCHR_XREF B , PS_VOUCHER C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND A.PYMNT_CNT = B.PYMNT_CNT AND B.PYMNT_SELCT_STATUS = 'P' AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.VOUCHER_ID = C.VOUCHER_ID AND C.VOUCHER_STYLE = 'PPAY' AND C.ENTRY_STATUS = 'P' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REMIT_SETID | Character(5) | VARCHAR2(5) NOT NULL | Remit SetID |
| 2 | REMIT_VENDOR | Character(10) | VARCHAR2(10) NOT NULL | Remit Vendor |
| 3 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 4 | PREPAID_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Prepaid Status
A=Applied B=Pending Application C=Pending Unapply D=Pending Change F=Fully Applied I=Inactive P=Available Prepayment R=Restricted U=Unapplied X=Cancelled |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 7 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 8 | PYMNT_CNT | Number(5,0) | INTEGER NOT NULL | Payments |
| 9 | SEQ_NUM2 | Number(6,0) | INTEGER NOT NULL | Sequence Number |
| 10 | PYMNT_GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Payment Amount |
| 11 | PYMNT_ID | Character(10) | VARCHAR2(10) NOT NULL | Payment Number |
| 12 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 13 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 14 | 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 |
| 15 | PAID_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Paid Amount |
| 16 | CURRENCY_PYMNT | Character(3) | VARCHAR2(3) NOT NULL | Payment Currency |
| 17 | PYMNT_HANDLING_CD | Character(2) | VARCHAR2(2) NOT NULL | Payment Handling |
| 18 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 19 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 20 | PREPAID_CUR_RT_TYP | Character(5) | VARCHAR2(5) NOT NULL | Prepayment Bank Curr Rate Type |
| 21 | APPLIED_AMT_PPAY | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount Applied to Prepayment |
| 22 | AVAILABLE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Prepayment Available Amount |
| 23 | PREPAID_APPLIED_BU | Character(5) | VARCHAR2(5) NOT NULL | Applied Business Unit |
| 24 | PREPAID_APPL_VCHR | Character(8) | VARCHAR2(8) NOT NULL | Applied Voucher ID |
| 25 | PREPAID_APPL_PYMNT | Number(5,0) | INTEGER NOT NULL | Applied Payment Count |
| 26 | REV_POST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Reversal Posting Status
N=Payment Not Applied P=Posted U=Unposted |
| 27 | CF_BAL_LINE_NUM | Number(10,0) | DECIMAL(10) NOT NULL | Chart Field Balancing Line Num |