CLASSBUSINESS_UNITBUDG_TYPEE=Expense
R=Revenue
LEDGER_GROUPSP_KLDGRP_CLSVW(SQL View) |
Index Back |
|---|
| SELECT E.LEDGER_GROUP ,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 ,PS_SEC_LEDGER_CLS E WHERE A.BUSINESS_UNIT = C.SETCNTRLVALUE AND E.LEDGER_GROUP = A.LEDGER_GROUP 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 | CLASS |
Character(30) | VARCHAR2(30) NOT NULL | Class of Service |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | BUDG_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Budget Type
E=Expense R=Revenue |
| 4 | LEDGER_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |