VCHR_UNPST_ELIG(SQL View) |
Index Back |
|---|---|
Search view for Vchr Unpost |
| SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.INVOICE_ID , A.INVOICE_DT , A.VENDOR_SETID , A.VENDOR_ID , A.VOUCHER_STYLE , A.VCHR_SRC FROM PS_VOUCHER A , PS_BUS_UNIT_INTFC E WHERE A.POST_STATUS_AP = 'P' AND A.IN_PROCESS_FLG = 'N' AND A.PROCESS_MAN_CLOSE = 'N' AND A.VOUCHER_STYLE <> 'CLBK' AND E.BUSINESS_UNIT = A.BUSINESS_UNIT_GL AND NOT EXISTS ( SELECT 'X' FROM PS_VCHR_PPAY_XREF C WHERE A.VOUCHER_STYLE = 'PPAY' AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.VOUCHER_ID = C.VOUCHER_ID AND C.PREPAID_STATUS IN ('A','F')) AND ((E.UNPOST_PAID_VCHR = 'N' AND NOT EXISTS ( SELECT 'X' FROM PS_PYMNT_VCHR_XREF D WHERE A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.VOUCHER_ID = D.VOUCHER_ID AND D.PYMNT_SELCT_STATUS IN('P', 'S'))) OR (E.UNPOST_PAID_VCHR = 'Y' AND NOT EXISTS ( SELECT 'X' FROM PS_VCHR_LINE_WTHD WTHD WHERE A.BUSINESS_UNIT = WTHD.BUSINESS_UNIT AND A.VOUCHER_ID = WTHD.VOUCHER_ID AND WTHD.WTHD_APPL_FLG = 'V' AND EXISTS( SELECT 'X' FROM PS_PYMNT_VCHR_XREF XREF WHERE WTHD.BUSINESS_UNIT = XREF.BUSINESS_UNIT AND WTHD.VOUCHER_ID = XREF.VOUCHER_ID AND XREF.PYMNT_SELCT_STATUS IN('P', 'S'))))) |
| # | 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 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 4 | INVOICE_DT | Date(10) | DATE NOT NULL | Invoice Date |
| 5 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 6 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: VENDOR_PRIM_VW |
| 7 | VOUCHER_STYLE | Character(4) | VARCHAR2(4) NOT NULL |
Voucher Style
ADJ=Adjustments AMR=Amortization Voucher CLBK=Claim Voucher CORR=Reversal Voucher JRNL=Journal Voucher PPAY=Prepaid Voucher REG=Regular Voucher RGTR=Register Voucher SGLP=Single Payment Voucher THRD=Third Party Voucher TMPL=Template Voucher |
| 8 | VCHR_SRC | Character(4) | VARCHAR2(4) NOT NULL | Voucher Source |