RUN_CNTL_DM_DSP(SQL Table) |
Index Back |
|---|
| # | 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 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | BU_SELECT_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Define BU selection
A=All Business Units S=Single Business Unit Default Value: A |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_AP_NONVW |
| 5 | VCHR_SELECT_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Vouchers Select Option
A=All Vouchers S=Single Voucher ID Default Value: A |
| 6 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL |
Voucher ID
Prompt Table: AP_DM_VCHR_VW |
| 7 | VENDOR_SELECT_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Vendor Selection option
A=Select All Suppliers S=Specify Supplier(s) Default Value: A |
| 8 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Vendor SetID
Prompt Table: SP_SETVND_NONVW |
| 9 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: AP_DM_VNDR_VW |
| 10 | DT_SELECT_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Select Range of Dates
A=All Dates S=Specify Date Range Default Value: A |
| 11 | FROM_DATE | Date(10) | DATE | From Date |
| 12 | THRU_DATE | Date(10) | DATE | Through Date |
| 13 | PRINT_DISP | Character(1) | VARCHAR2(1) NOT NULL |
Print Method
Y/N Table Edit |
| 14 | FAX_DISP | Character(1) | VARCHAR2(1) NOT NULL |
FAX Method
Y/N Table Edit |
| 15 | EMAIL_DISP | Character(1) | VARCHAR2(1) NOT NULL |
E-Mail Method
Y/N Table Edit |
| 16 | EDI_DISP | Character(1) | VARCHAR2(1) NOT NULL |
EDX Method
Y/N Table Edit |
| 17 | PHONE_DISP | Character(1) | VARCHAR2(1) NOT NULL |
Phone Method
Y/N Table Edit |
| 18 | REPRINT_DM | Character(1) | VARCHAR2(1) NOT NULL |
Include Dispatched Debit Memos
Y/N Table Edit Default Value: N |