SP_LGRP2AC_LANG(SQL View) |
Index Back |
---|---|
Sec Vw - All Ledger Groups |
SELECT DISTINCT l.oprclass ,a.setid ,a.ledger_group ,a.language_cd ,a.descr FROM ps_led_grp_lang a ,PS_SEC_LEDGER_CLS l WHERE l.ledger_group = a.ledger_group |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRCLASS2 | Character(30) | VARCHAR2(30) NOT NULL | Operator Class |
2 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
3 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
4 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |