RUN_GL_BAL(SQL Table) |
Index Back |
|---|---|
GL Balance Run ControlGL Balance Run Control |
| # | 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: OPRID_VW |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL |
Ledger
Prompt Table: SP_BULEDD_NONVW |
| 5 | LEDGER_CODE | Character(10) | VARCHAR2(10) NOT NULL |
Ledger Code
Prompt Table: LEDGER_CODE_TBL |
| 6 | BAL_SHEET_IND | Character(2) | VARCHAR2(2) NOT NULL |
Balance Sheet Indicator
BS=Balance Sheet OB=Off Balance Sheet |
| 7 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 8 | PERIOD_FROM | Number(3,0) | SMALLINT NOT NULL | From Period |
| 9 | PERIOD_TO | Number(3,0) | SMALLINT NOT NULL | To Period |
| 10 | CURRENCY_OPTION2 | Character(1) | VARCHAR2(1) NOT NULL |
Currency Option
B=Base F=All Frgn S=Selected Frgn Default Value: B |
| 11 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 12 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: STAT_RPT_LBL_VW |
| 13 | ACCT_FR | Character(10) | VARCHAR2(10) NOT NULL |
From
Prompt Table: %EDITTABLE |
| 14 | ACCT_TO | Character(10) | VARCHAR2(10) NOT NULL |
To
Prompt Table: %EDITTABLE |
| 15 | TEXT_LABEL | Character(1) | VARCHAR2(1) NOT NULL | Text Label |
| 16 | SUB_TOTAL_OPT1 | Number(1,0) | SMALLINT NOT NULL | Subtotalling Option 1 |
| 17 | SUB_TOTAL_OPT2 | Number(1,0) | SMALLINT NOT NULL | Subtotalling Option 2 |
| 18 | DISPLAY_26_DIGITS | Character(1) | VARCHAR2(1) NOT NULL |
Display Full Numeric Field
N=No Y=Yes Y/N Table Edit Default Value: N |
| 19 | SUB_TOTAL_PD | Character(1) | VARCHAR2(1) NOT NULL |
Subtotals by Period
Y/N Table Edit Default Value: N |
| 20 | ADJ_PER_FROM | Number(3,0) | SMALLINT NOT NULL | Adjustment Period From |
| 21 | ADJ_PER_TO | Number(3,0) | SMALLINT NOT NULL | Adjustment Period To |
| 22 | PB_SELECT_CF | Character(1) | VARCHAR2(1) NOT NULL | Select ChartFields |
| 23 | ZERO_BEG_BAL_ADJ | Character(1) | VARCHAR2(1) NOT NULL |
Zero Beginning Bal for Adj Per
Y/N Table Edit Default Value: Y |
| 24 | SHOW_NET_INCOME | Character(1) | VARCHAR2(1) NOT NULL |
Show Net Income
Y/N Table Edit Default Value: N |