RUN_CNTL_EM(SQL Table) |
Index Back |
|---|---|
Run Control for eSettlementsRun Control record used to pass parameters to eSettlements processes. |
| # | 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 | REQUEST_ID | Character(10) | VARCHAR2(10) NOT NULL | Request ID |
| 4 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 5 | TEMPLATE_ID | Character(30) | VARCHAR2(30) NOT NULL |
Project Template
Prompt Table:
EM_BUY_TEMPLATE
|
| 6 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table: RT_TYPE_TBL |
| 7 | EM_BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | From Business Unit |
| 8 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 9 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 10 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 11 | PROPOSE_ID | Character(8) | VARCHAR2(8) NOT NULL | Propose ID |
| 12 | PYMNT_TERMS_CD | Character(5) | VARCHAR2(5) NOT NULL | Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers. |
| 13 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 14 | EM_VCHR_PROC | Character(1) | VARCHAR2(1) NOT NULL |
Voucher Processing
0=Specify Buyers 1=All Buyers Default Value: 1 |
| 15 | EXPIRE_DT | Date(10) | DATE |
Expiration Dt
Default Value: %Date |
| 16 | EM_PROPOSAL_PROC | Character(1) | VARCHAR2(1) NOT NULL |
Proposal Processing
C=Cancelled Only E=All Expired Proposals Default Value: E |
| 17 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 18 | BASIS_DATE | Date(10) | DATE | Basis Date |
| 19 | EM_VENDOR_PROC | Character(1) | VARCHAR2(1) NOT NULL |
Supplier Processing
A=All S=Specify Default Value: A |
| 20 | EM_REPORT_PROC | Character(1) | VARCHAR2(1) NOT NULL |
Report Processing
B=Delete and Generate Report D=Delete Report Only R=Report Only Default Value: B |
| 21 | URL_1 | Character(254) | VARCHAR2(254) NOT NULL | URL #1 |
| 22 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |