OPRIDRUN_CNTL_IDPrompt Table: SP_BU_RE_NONVW
Prompt Table: RE_LS
Default Value: N
Default Value: N
C=Current Date
D=Custom Date
S=Schedule Date
Default Value: C
RE_TXN_INTFC(SQL Table) |
Index Back |
|---|---|
Transaction InterfaceTo store the run control parameters of TBP |
| # | 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 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_RE_NONVW |
| 4 | LS_KEY | Number(15,0) | DECIMAL(15) NOT NULL |
Lease Key, Unique Key
Prompt Table: RE_LS |
| 5 | AP | Character(1) | VARCHAR2(1) NOT NULL |
Payables
Default Value: N |
| 6 | BI | Character(1) | VARCHAR2(1) NOT NULL |
Billing
Default Value: N |
| 7 | RE_INV_DT_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Invoice Date Option
C=Current Date D=Custom Date S=Schedule Date Default Value: C |