OPRIDRUN_CNTL_IDBUSINESS_UNITPrompt Table: RE_BUS_UNIT
SEQNODefault Value: 0
Prompt Table: RE_LS_STLN_SRCH
Prompt Table: RE_FISCAL_YEAR
Prompt Table: RE_FISC_YEAR_PD
Prompt Table: RE_FISC_YEAR_PD
RE_STGL_RUNCNTL(SQL Table) |
Index Back |
|---|---|
Post FASB Schedules to GLRun control record to Post FASB Schedules to GL. Accruals / Deferrals are posted to GL based on the Run Control Parameters |
| # | 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: RE_BUS_UNIT |
| 4 | SEQNO |
Number(5,0) | INTEGER NOT NULL |
Sequence Number
Default Value: 0 |
| 5 | LS_NBR | Character(10) | VARCHAR2(10) NOT NULL | Lease Number, User Enterable or Generated Sequence Number |
| 6 | LS_KEY | Number(15,0) | DECIMAL(15) NOT NULL |
Lease Key, Unique Key
Prompt Table: RE_LS_STLN_SRCH |
| 7 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 8 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL |
Fiscal Year
Prompt Table: RE_FISCAL_YEAR |
| 9 | ACCOUNTING_PD_FROM | Number(3,0) | SMALLINT NOT NULL |
From Accounting Period
Prompt Table: RE_FISC_YEAR_PD |
| 10 | ACCOUNTING_PD_TO | Number(3,0) | SMALLINT NOT NULL |
To Accounting Period
Prompt Table: RE_FISC_YEAR_PD |
| 11 | GL_BU | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 12 | ACCOUNTING_DT | Date(10) | DATE NOT NULL | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 13 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |