BUSINESS_UNITVOUCHER_IDEM_VO_PNDAPR_VW(SQL View) |
Index Back |
|---|---|
MP - Supplier Pending ApprovlMP - Supplier Pending Approval View |
| SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.ENTERED_DT FROM PS_VOUCHER A WHERE A.ENTRY_STATUS = 'P' AND A.APPR_STATUS <> 'A' AND A.APPR_CHECK_FLG = 'N' AND A.VCHR_APPRVL_FLG = 'S' AND A.MATCH_STATUS_VCHR IN ('M','N') AND A.ENTERED_DT=( SELECT MAX(B.ENTERED_DT) FROM PS_VOUCHER B) |
| # | 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 | ENTERED_DT | Date(10) | DATE | Entered on |