OI_LED_GRP_VW

(SQL View)
 Index Back

Ledger Group

OTBI Ledger Group View

SELECT A.SETID , A.LEDGER_GROUP , A.DESCR , A.LEDGER_TEMPLATE , A.LEDGER_GROUP_TYPE , A.LEDGERS_SYNC , A.SECOND_LEDGERS , A.GEN_BAL_ENTRIES FROM %Table(LED_GRP_TBL) A UNION SELECT B.SETID , ' ' , ' ' , '-' , '-' , '-' , '-' , '-' FROM %Table(SETID_TBL) B UNION SELECT ' ' , ' ' , '-' , '-' , '-' , '-' , '-' , '-' FROM %Table(INSTALLATION) C

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 LEDGER_TEMPLATE Character(10) VARCHAR2(10) NOT NULL Ledger Template
5 LEDGER_GROUP_TYPE Character(1) VARCHAR2(1) NOT NULL Ledger Group Type
A=Average Daily Balance
B=Budget
E=Commitment Control Expense
R=Commitment Control Revenue
S=Standard
T=Translation
6 LEDGERS_SYNC Character(1) VARCHAR2(1) NOT NULL Keep Ledgers in Sync
7 SECOND_LEDGERS Character(1) VARCHAR2(1) NOT NULL Secondary Ledgers Exist
8 GEN_BAL_ENTRIES Character(1) VARCHAR2(1) NOT NULL IntraUnit Balancing Entries