SP_BOOKB6_NONVW

(SQL View)
 Index Back

Bu Book excluding sec books

Business unit book view excluding secondary books for ledger in sync.

SELECT A.BUSINESS_UNIT , A.BOOK , A.ACCT_ENT_TMPL_ID , A.REQUIRED_SW , A.BOOK_TYPE , A.CURRENCY_CD , A.CAPITALIZATION_MIN , A.LEASE_CAP_MIN , A.DISTRIBUTION_SW , A.DISPOSAL_DIST_SW , A.BUSINESS_UNIT_GL , A.CAL_DEPR_PD , A.RT_TYPE , A.LEDGER_GROUP , A.LEDGER , A.BUD_LEDGER_GROUP FROM PS_BU_BOOK_TBL A WHERE NOT EXISTS ( SELECT 'X' FROM PS_SET_CNTRL_REC D , PS_LED_GRP_TBL E , PS_LED_GRP_LED_TBL F WHERE A.DISTRIBUTION_SW='Y' AND D.RECNAME = 'LED_GRP_TBL' AND D.SETCNTRLVALUE = A.BUSINESS_UNIT_GL AND E.SETID = D.SETID AND E.LEDGER_GROUP = A.LEDGER_GROUP AND F.SETID = E.SETID AND F.LEDGER_GROUP = E.LEDGER_GROUP AND (E.LEDGERS_SYNC = 'Y' AND F.PRIMARY_LEDGER <> 'Y' AND (F.LEDGER = A.LEDGER OR A.LEDGER = ' ')) )

  • Parent record: BUS_UNIT_TBL_AM

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_AM_NONVW

    2 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name

    Prompt Table: SP_BOOK_NONVW

    3 ACCT_ENT_TMPL_ID Character(10) VARCHAR2(10) NOT NULL Account Entry Template ID
    4 REQUIRED_SW Character(1) VARCHAR2(1) NOT NULL Book is Required

    Y/N Table Edit

    Default Value: Y

    5 BOOK_TYPE Character(1) VARCHAR2(1) NOT NULL Depreciation Book Type
    A=U.S. AMT Book
    F=Corporate Book
    P=Corporate w/Tax Info
    T=Main Tax Book

    Default Value: F

    6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    7 CAPITALIZATION_MIN Signed Number(28,3) DECIMAL(26,3) NOT NULL Capitalization Minimum
    8 LEASE_CAP_MIN Signed Number(28,3) DECIMAL(26,3) NOT NULL Lease Cap. Minimum
    9 DISTRIBUTION_SW Character(1) VARCHAR2(1) NOT NULL Distribution Switch
    N=No
    Y=Yes

    Default Value: N

    10 DISPOSAL_DIST_SW Character(1) VARCHAR2(1) NOT NULL Distribute by Disposal Code

    Y/N Table Edit

    Default Value: N

    11 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

    Prompt Table: SP_BU_GL_NONVW

    12 CAL_DEPR_PD Character(2) VARCHAR2(2) NOT NULL Calendar

    Prompt Table: CAL_DEFN_DPR_VW

    13 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.

    Prompt Table: RT_TYPE_TBL

    14 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
    15 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
    16 BUD_LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Budget Ledger Group