BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_FS_NONVW
LEDGERPrompt Table: SP_BUL_BD_NONVW
BD_LED_BUDG_VW(SQL View) |
Index Back |
|---|---|
Budget Detail Ledgers Vw |
| SELECT a.business_unit ,a.ledger ,e.descr ,g.ledger_group ,c.recname ,b.calendar_id ,h.open_year_from ,h.open_period_from ,i.open_year_to ,i.open_period_to ,f.base_currency ,b.ALLOW_WF_UPDATE FROM ps_bu_led_tbl a , PS_BU_LED_GRP_TBL b , ps_led_tmplt_tbl c , ps_led_defn_tbl e , ps_bus_unit_tbl_gl f , ps_led_grp_tbl g , ps_fin_open_min_vw h , ps_fin_open_max_vw i WHERE e.setid = ( SELECT setid FROM ps_set_cntrl_rec d WHERE d.setcntrlvalue = a.business_unit AND d.recname = 'LED_DEFN_TBL') AND b.business_unit = a.business_unit AND b.ALLOW_WF_UPDATE='Y' AND b.ledger_group = a.ledger_group AND b.ledger_type = 'D' AND c.ledger_template=e.ledger_template AND c.recname='LEDGER_BUDG' AND a.ledger = e.ledger AND f.business_unit=b.business_unit AND g.ledger_group=b.ledger_group AND g.LEDGERS_SYNC='N' AND h.business_unit = b.business_unit AND h.ledger_group = b.ledger_group AND i.business_unit = b.business_unit AND i.ledger_group = b.ledger_group |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_FS_NONVW |
| 2 | LEDGER |
Character(10) | VARCHAR2(10) NOT NULL |
Ledger
Prompt Table: SP_BUL_BD_NONVW |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 5 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 6 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 7 | OPEN_YEAR_FROM | Number(4,0) | SMALLINT NOT NULL | Open Year From |
| 8 | OPEN_PERIOD_FROM | Number(3,0) | SMALLINT NOT NULL | Open Period From |
| 9 | OPEN_YEAR_TO | Number(4,0) | SMALLINT NOT NULL | Open Year To |
| 10 | OPEN_PERIOD_TO | Number(3,0) | SMALLINT NOT NULL | Open Period To |
| 11 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. " |
| 12 | ALLOW_WF_UPDATE | Character(1) | VARCHAR2(1) NOT NULL | Direct Budgets Ledger Updates |