OPRIDPrompt Table: %EDITTABLE2
Prompt Table: %EDITTABLE3
Prompt Table: EM_VNDR_LOC_VW3
Prompt Table: %EDITTABLE
Prompt Table: %EDITTABLE
1=By Date and Status
2=By Alternative Filters
Default Value: 300
SSI_SEL_OPT(SQL Table) |
Index Back |
|---|---|
My Invoices Filter OptionsMain Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | ENTERED_DT | Date(10) | DATE | Entered on |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: %EDITTABLE2 |
| 4 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: %EDITTABLE3 |
| 5 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table: EM_VNDR_LOC_VW3 |
| 6 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL |
Invoice Number
Prompt Table: %EDITTABLE |
| 7 | INVOICE_ID_TO | Character(30) | VARCHAR2(30) NOT NULL |
Invoice ID To
Prompt Table: %EDITTABLE |
| 8 | VCHR_SRC | Character(4) | VARCHAR2(4) NOT NULL | Voucher Source |
| 9 | ASOFDATE | Date(10) | DATE | As of Date |
| 10 | PR_FILTER_OPTIONS | Character(1) | VARCHAR2(1) NOT NULL |
Filter Options
1=By Date and Status 2=By Alternative Filters |
| 11 | MAX_ROWS | Number(3,0) | SMALLINT NOT NULL |
Maximum Rows retrieved
Default Value: 300 |
| 12 | FROM_DT | Date(10) | DATE | From Date |
| 13 | TO_DT | Date(10) | DATE | To Date |