BU_LED_GRP_VW

(SQL View)
 Index Back

BU Ledger Group View


SELECT A.BUSINESS_UNIT , A.LEDGER_GROUP , A.LEDGER_TYPE , B.DESCR , B.LEDGERS_SYNC , A.DEFAULT_LEDGER_GRP , A.BALANCED_LEDGER , A.SEPARATE_DRCR , A.SEPARATE_DRCR_AMT , A.CALENDAR_ID , D.OPEN_YEAR_FROM , D.OPEN_PERIOD_FROM , E.OPEN_YEAR_TO , E.OPEN_PERIOD_TO , E.OPEN_CLOSING_YEAR , E.ADJUSTING_PERIOD , A.JRNL_BALANCE_OPTN , A.JRNL_EDIT_ERR_OPTN , A.CONTROL_TOTAL_OPTN , A.ADB_REPORTING , A.CALENDAR_ID_ADB , A.CURRENCY_BAL_OPTN , A.BASE_CUR_ADJ_OPTN , A.JRNL_FOREIGN_OPTN , A.ALTACCT_OPTN , A.ACCT_ALT_SUSPENSE , A.ALT_ACCT_SUSPENSE , A.DOC_TYPE , A.COMMITMENT_CNTL , A.NO_POST_FUTURE_DT FROM PS_BU_LED_GRP_TBL A , PS_LED_GRP_TBL B , PS_SET_CNTRL_REC C , PS_FIN_OPEN_MIN_VW D , PS_FIN_OPEN_MAX_VW E WHERE A.LEDGER_GROUP = B.LEDGER_GROUP AND B.SETID = C.SETID AND C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.RECNAME = 'LED_GRP_TBL' AND D.BUSINESS_UNIT = A.BUSINESS_UNIT AND E.BUSINESS_UNIT = A.BUSINESS_UNIT AND ((A.LEDGER_TYPE <> 'K' AND D.LEDGER_GROUP = A.LEDGER_GROUP AND E.LEDGER_GROUP = A.LEDGER_GROUP) OR (A.LEDGER_TYPE = 'K' AND D.LEDGER_GROUP = A.ASSOCIATED_LED_GRP AND E.LEDGER_GROUP = A.ASSOCIATED_LED_GRP))

  • Related Language Record: BU_LGRP_LANG

    • # 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_TYPE Character(1) VARCHAR2(1) NOT NULL Ledger Type
    D=Detail Ledger
    K=Commitment Control Ledger
    S=Summary Ledger
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 LEDGERS_SYNC Character(1) VARCHAR2(1) NOT NULL Keep Ledgers in Sync
    6 DEFAULT_LEDGER_GRP Character(1) VARCHAR2(1) NOT NULL Jrnl Generator Dflt Ledger Grp
    7 BALANCED_LEDGER Character(1) VARCHAR2(1) NOT NULL Balanced Ledger
    8 SEPARATE_DRCR Character(1) VARCHAR2(1) NOT NULL Enable Separate Debit/Credit
    9 SEPARATE_DRCR_AMT Character(1) VARCHAR2(1) NOT NULL Separate DR/CR Amount Fields
    10 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
    11 OPEN_YEAR_FROM Number(4,0) SMALLINT NOT NULL Open Year From
    12 OPEN_PERIOD_FROM Number(3,0) SMALLINT NOT NULL Open Period From
    13 OPEN_YEAR_TO Number(4,0) SMALLINT NOT NULL Open Year To
    14 OPEN_PERIOD_TO Number(3,0) SMALLINT NOT NULL Open Period To
    15 OPEN_CLOSING_YEAR Number(4,0) SMALLINT NOT NULL Adjustment Year
    16 ADJUSTING_PERIOD Number(3,0) SMALLINT NOT NULL Adjustment Period
    17 JRNL_BALANCE_OPTN Character(1) VARCHAR2(1) NOT NULL Journal Balance Option
    D=Default to Higher Level Value
    R=Recycle
    S=Suspend
    18 JRNL_EDIT_ERR_OPTN Character(1) VARCHAR2(1) NOT NULL Journal Edit Errors Option
    D=Default to Higher Level Value
    R=Recycle
    S=Suspend
    19 CONTROL_TOTAL_OPTN Character(1) VARCHAR2(1) NOT NULL Control Total Option
    D=Default to Higher Level Value
    N=N/A
    R=Recycle
    20 ADB_REPORTING Character(1) VARCHAR2(1) NOT NULL Report Average Balances
    21 CALENDAR_ID_ADB Character(2) VARCHAR2(2) NOT NULL ADB Calendar
    22 CURRENCY_BAL_OPTN Character(1) VARCHAR2(1) NOT NULL Currency Balancing Option
    A=Balance by All Currencies
    B=Balance by Base Currency Only
    D=Default to Higher Level Value
    23 BASE_CUR_ADJ_OPTN Character(1) VARCHAR2(1) NOT NULL Base Currency Adjust Option
    D=Default to Higher Level Value
    N=Disallow Base Curr Adjustments
    Y=Allow Base Curr Adjustments
    24 JRNL_FOREIGN_OPTN Character(1) VARCHAR2(1) NOT NULL Foreign Currencies per Journal
    D=Default to Higher Level Value
    M=Multiple Foreign Currencies
    N=No Foreign Currencies
    O=Only One Foreign Currency
    25 ALTACCT_OPTN Character(1) VARCHAR2(1) NOT NULL Enable Alternate Account
    26 ACCT_ALT_SUSPENSE Character(10) VARCHAR2(10) NOT NULL Acct->Alt Suspense
    27 ALT_ACCT_SUSPENSE Character(10) VARCHAR2(10) NOT NULL Alt->Acct Suspense
    28 DOC_TYPE Character(8) VARCHAR2(8) NOT NULL Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
    29 COMMITMENT_CNTL Character(1) VARCHAR2(1) NOT NULL Enable Commitment Control
    30 NO_POST_FUTURE_DT Character(1) VARCHAR2(1) NOT NULL Yes/No Indicator