SPF_RUNCTL_CINP(SQL Table) |
Index Back |
|---|---|
Run Control Table forPrint InvRun Control Table for Print Invoice AppEngine |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPR_DEF_TBL_FS |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_SP_NONVW |
| 4 | INVOICE_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Invoice Status
0=Submitted to Enterprise 1=Generated 10=Canceled 11=Adjusted 2=Approved 3=Processed 4=Paid 5=Submitted 6=Denied 7=Submitted to Supplier 8=Approved by Supplier 9=Denied by Supplier |
| 5 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: SPM_BU_SNW_VW |
| 6 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 7 | END_DATE | Date(10) | DATE | End Date |
| 8 | INVOICE_ID_FROM | Character(30) | VARCHAR2(30) NOT NULL |
Invoice Number
Prompt Table: SPF_INV_ID_VW |
| 9 | INVOICE_ID_TO | Character(30) | VARCHAR2(30) NOT NULL |
Invoice Number
Prompt Table: SPF_INV_ID_VW |
| 10 | SPF_CURRENCY | Character(1) | VARCHAR2(1) NOT NULL |
Display Currency Selection
B=Base Currency S=Work Order Currency |