BUSINESS_UNITBUS_UNIT_VW1_AM(SQL View) |
Index Back |
|---|---|
AM Business Unit for Journ Gen |
| SELECT BUSINESS_UNIT, BUSINESS_UNIT_GL, LEDGER_GROUP, LEDGER FROM PS_BU_BOOK_TBL WHERE DISTRIBUTION_SW = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 3 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 4 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |