BUSINESS_UNITLEDGER_GROUPA=Average Daily Balance
B=Budget
E=Commitment Control Expense
R=Commitment Control Revenue
S=Standard
T=Translation
LEDGERD=Detail Ledger
K=Commitment Control Ledger
S=Summary Ledger
Y/N Table Edit
Default Value: N
GL_BU_LG_VW(SQL View) |
Index Back |
|---|---|
GL BU assigned ledger group |
| SELECT A.BUSINESS_UNIT , B.LEDGER_GROUP , B.LEDGER_GROUP_TYPE , C.LEDGER , A.LEDGER_TYPE , B.DESCR , A.CALENDAR_ID , A.DEFAULT_LEDGER_GRP FROM PS_BU_LED_GRP_TBL A , PS_LED_GRP_TBL B , PS_LED_GRP_LED_TBL C , PS_SET_CNTRL_REC D WHERE D.SETCNTRLVALUE = A.BUSINESS_UNIT AND D.RECNAME = 'LED_GRP_TBL' AND B.SETID = D.SETID AND B.LEDGER_GROUP = A.LEDGER_GROUP AND B.SETID = C.SETID AND B.LEDGER_GROUP = C.LEDGER_GROUP AND C.PRIMARY_LEDGER = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | LEDGER_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 3 | 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 |
| 4 | LEDGER |
Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 5 | LEDGER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Ledger Type
D=Detail Ledger K=Commitment Control Ledger S=Summary Ledger |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 8 | DEFAULT_LEDGER_GRP | Character(1) | VARCHAR2(1) NOT NULL |
Jrnl Generator Dflt Ledger Grp
Y/N Table Edit Default Value: N |