BUSINESS_UNITLEDGERBU_LED_CAL_VW(SQL View) |
Index Back |
|---|---|
Ledger for a BU Cal Vw |
| select a.business_unit, b.ledger, a.calendar_id from PS_BU_LED_GRP_TBL a, ps_bu_led_tbl b where b.business_unit = a.business_unit and a.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 |
| 2 | LEDGER |
Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 3 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |