BUSINESS_UNITBUDG_TYPEE=Expense
R=Revenue
LEDGER_GROUPSP_KLDGRP_NONVW(SQL View) |
Index Back |
|---|
| SELECT A.BUSINESS_UNIT , F.LEDGER_GROUP_TYPE , A.LEDGER_GROUP FROM PS_BU_LED_GRP_TBL A , PS_SET_CNTRL_REC C , PS_LED_GRP_TBL F WHERE A.BUSINESS_UNIT = C.SETCNTRLVALUE AND A.LEDGER_GROUP = F.LEDGER_GROUP AND C.REC_GROUP_ID = 'FS_04' AND C.RECNAME = 'LED_GRP_LED_TBL' AND F.SETID = C.SETID AND LEDGER_GROUP_TYPE IN ('E','R') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | BUDG_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Budget Type
E=Expense R=Revenue |
| 3 | LEDGER_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |