OPRCLASSBUSINESS_UNIT_GLLEDGER_GROUPSP_CMLGRP_CLSVW(SQL View) |
Index Back |
|---|---|
Sec View - CM Ledger Group11/30/01 8.4 added for row level security - copy of CM_LED_GRP_VW |
| SELECT G.OPRCLASS , %Substring(S.SETCNTRLVALUE, 1, 5) ,LG.LEDGER_GROUP ,LG.DESCR ,LG.SETID FROM PS_LED_GRP_TBL LG ,PS_LED_TMPLT_TBL LT ,PS_SET_CNTRL_REC S ,PS_SEC_LEDGER_CLS G WHERE LG.LEDGER_TEMPLATE=LT.LEDGER_TEMPLATE AND LT.DEFAULT_LEDGER<>'C' AND S.RECNAME = 'LED_GRP_TBL' AND LG.SETID = S.SETID AND LG.LEDGER_GROUP = G.LEDGER_GROUP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRCLASS |
Character(30) | VARCHAR2(30) NOT NULL | Operator Class |
| 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |