BUSINESS_UNITPrompt Table: SP_BUS_AP_NONVW
VOUCHER_IDPrompt Table: VCHR_ID_VW3
Prompt Table: VNDR_ACT_VW
Prompt Table: CURRENCY_CD_TBL
Prompt Table: OPRID_VW
Prompt Table: OPRID_VW
Prompt Table: ORIGIN_AP_EFFVW
AP_PAVL_FLTR_VW(SQL View) |
Index Back |
|---|---|
Filter View for AP WorkCenterFilter View for AP WorkCenter |
| SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.VENDOR_ID , A.INVOICE_DT , A.AVAILABLE_AMT , A.CURRENCY_PYMNT , A.OPRID , A.OPRID_LAST_UPDT , A.ORIGIN , A.VCHR_SRC , A.ENTERED_DT FROM PS_AP_WC_PPYAVL_VW A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUS_AP_NONVW |
| 2 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL |
Voucher ID
Prompt Table: VCHR_ID_VW3 |
| 3 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: VNDR_ACT_VW |
| 4 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 5 | AVAILABLE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Prepayment Available Amount |
| 6 | CURRENCY_PYMNT | Character(3) | VARCHAR2(3) NOT NULL |
Payment Currency
Prompt Table: CURRENCY_CD_TBL |
| 7 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW |
| 8 | OPRID_LAST_UPDT | Character(30) | VARCHAR2(30) NOT NULL |
Last User to Update
Prompt Table: OPRID_VW |
| 9 | ORIGIN | Character(3) | VARCHAR2(3) NOT NULL |
Origin
Prompt Table: ORIGIN_AP_EFFVW |
| 10 | VCHR_SRC | Character(4) | VARCHAR2(4) NOT NULL | Voucher Source |
| 11 | ENTERED_DT | Date(10) | DATE | Entered on |