VENDOR_IDBUSINESS_UNITVOUCHER_IDC=Complete
D=Through batch defaults
E=Edited by Batch Voucher Module
L=Reviewed through Maintenance
M=Modified
O=Open
P=Postable
R=Recycle
S=Scheduled for Payment
T=Template Voucher
X=Deleted
EM_VCHR_CRT_VW(SQL View) |
Index Back |
|---|---|
View of Newly Created VOsView of Newly Created VOs RSR MarketPay Development |
| SELECT a.vendor_id , a.business_unit , a.voucher_id , b.descr , a.vendor_setid , A.VNDR_LOC , a.invoice_id , a.entered_dt , a.entry_status FROM ps_vchr_fs a , ps_bus_unit_tbl_fs b , PS_EM_BUY_REG_TBL C WHERE a.business_unit = b.business_unit AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND a.voucher_id NOT IN ( SELECT DISTINCT c.voucher_id FROM ps_em_vchr_load c WHERE a.business_unit=c.business_unit AND a.voucher_id = c.voucher_id) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 6 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 7 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 8 | ENTERED_DT | Date(10) | DATE | Entered on |
| 9 | ENTRY_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
If translate values are added or changed, modify the following code to make sure the values appear accurately in the dropdown list in the search dialog: VCHR_SRCH_DEL.ENTRY_STATUS.SearchInit. Template Voucher status should not be visibile in the drop down.
C=Complete D=Through batch defaults E=Edited by Batch Voucher Module L=Reviewed through Maintenance M=Modified O=Open P=Postable R=Recycle S=Scheduled for Payment T=Template Voucher X=Deleted |