BUSINESS_UNITBU_LGRP_DEF_VW(SQL View) |
Index Back |
|---|---|
Deflt led group for bus units |
| SELECT BUSINESS_UNIT ,LEDGER_GROUP ,DEFAULT_LEDGER_GRP FROM PS_BU_LED_GRP_TBL WHERE DEFAULT_LEDGER_GRP = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 3 | DEFAULT_LEDGER_GRP | Character(1) | VARCHAR2(1) NOT NULL | Jrnl Generator Dflt Ledger Grp |