FS_ALLC_LGRP_VW(SQL View) |
Index Back |
|---|---|
FS ALLC - ledger state recordFS ALLC - ledger state record |
| SELECT B.BUSINESS_UNIT , B.LEDGER_GROUP , T.RECNAME , T.RECNAME_JRNL_LN , B.CALENDAR_ID , G.SECOND_LEDGERS , G.LEDGERS_SYNC , G.GEN_BAL_ENTRIES , G.LEDGER_GROUP_TYPE , B.SEPARATE_DRCR , L.LEDGER , L.RT_TYPE , L.CUR_RT_TYPE_DFLT FROM PS_BU_LED_GRP_TBL B , PS_LED_GRP_TBL G , PS_LED_GRP_LED_TBL L , PS_LED_TMPLT_TBL T , PS_SET_CNTRL_REC SC WHERE G.SETID = SC.SETID AND G.LEDGER_GROUP = B.LEDGER_GROUP AND L.SETID = G.SETID AND L.LEDGER_GROUP = G.LEDGER_GROUP AND L.PRIMARY_LEDGER = 'Y' AND G.LEDGER_TEMPLATE = T.LEDGER_TEMPLATE AND SC.SETCNTRLVALUE = B.BUSINESS_UNIT AND SC.RECNAME = 'LED_DEFN_TBL' |
| # | 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 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 4 | RECNAME_JRNL_LN | Character(15) | VARCHAR2(15) NOT NULL | Journal Line |
| 5 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 6 | SECOND_LEDGERS | Character(1) | VARCHAR2(1) NOT NULL | Secondary Ledgers Exist |
| 7 | LEDGERS_SYNC | Character(1) | VARCHAR2(1) NOT NULL | Keep Ledgers in Sync |
| 8 | GEN_BAL_ENTRIES | Character(1) | VARCHAR2(1) NOT NULL | IntraUnit Balancing Entries |
| 9 | 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 |
| 10 | SEPARATE_DRCR | Character(1) | VARCHAR2(1) NOT NULL | Enable Separate Debit/Credit |
| 11 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 12 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
| 13 | CUR_RT_TYPE_DFLT | Character(5) | VARCHAR2(5) NOT NULL | Exchange Rate Type Default |