SP_BOOKB1_OPRVW

(SQL View)
 Index Back

Business Unit Financial Books


SELECT D.OPRID , 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.LEDGER_GROUP , a.LEDGER , a.BUD_LEDGER_GROUP , a.CAL_DEPR_PD , a.RT_TYPE , a.GROUP_PROC_SW , b.SETID , b.DESCR , b.LC_CNTRY , a.CHILD_TK_PARENT_SW , A.COST_LIMIT_CD , A.DEROGATORY_SW , A.ROUND_TYPE , A.ROUND_RULE_AM , A.ROUND_PRECISION , A.ROUND_FACTOR , A.TRUNCATE_FLAG , A.STORE_DEPR_BY_PD , A.Infl_Adj_sw , A.LOW_VALUE_SW FROM PS_BU_BOOK_TBL a , PS_BOOK_DEFN_TBL b , PS_SP_BOOK_OPRVW D WHERE b.SetID = ( SELECT SetID FROM ps_Set_Cntrl_Rec c WHERE c.SetCntrlValue= a.Business_Unit AND c.RecName='BOOK_DEFN_TBL') AND a.Book = b.Book AND D.SETID = B.SETID AND D.BOOK = B.BOOK

  • Related Language Record: BU_BOOK_LAN_VW

  • Parent record: BUS_UNIT_TBL_AM

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_AM_NONVW

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

    Prompt Table: SP_BOOK_NONVW

    4 ACCT_ENT_TMPL_ID Character(10) VARCHAR2(10) NOT NULL Account Entry Template ID

    Prompt Table: AMAE_TMPLID_TBL

    5 REQUIRED_SW Character(1) VARCHAR2(1) NOT NULL Book is Required

    Y/N Table Edit

    Default Value: Y

    6 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

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

    Prompt Table: CURRENCY_CD_TBL

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

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: SP_BU_GL_NONVW

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

    Prompt Table: CAL_DEFN_DPR_VW

    17 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

    18 GROUP_PROC_SW Character(1) VARCHAR2(1) NOT NULL Group Asset Processing
    19 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    20 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    21 LC_CNTRY Character(3) VARCHAR2(3) NOT NULL The local country.
    22 CHILD_TK_PARENT_SW Character(1) VARCHAR2(1) NOT NULL Child Inherits Parent's Life

    Y/N Table Edit

    Default Value: N

    23 COST_LIMIT_CD Character(10) VARCHAR2(10) NOT NULL Cost Limit Code
    24 DEROGATORY_SW Character(1) VARCHAR2(1) NOT NULL Derogatory Depreciation
    25 ROUND_TYPE Character(1) VARCHAR2(1) NOT NULL Round Type
    C=Currency
    G=Generic

    Default Value: C

    26 ROUND_RULE_AM Character(1) VARCHAR2(1) NOT NULL Rounding Rule
    D=Round Down
    N=Natural Round
    U=Round Up

    Default Value: N

    27 ROUND_PRECISION Signed Number(4,0) DECIMAL(3) NOT NULL Rounding Precision
    28 ROUND_FACTOR Number(15,7) DECIMAL(14,7) NOT NULL Rounding Factor
    29 TRUNCATE_FLAG Character(1) VARCHAR2(1) NOT NULL Used for Round Up. 'Y'es - truncate 1 decimal place past the round precision. 'N' - do not truncate

    Y/N Table Edit

    30 STORE_DEPR_BY_PD Character(1) VARCHAR2(1) NOT NULL Store Depr By Period
    31 INFL_ADJ_SW Character(1) VARCHAR2(1) NOT NULL Inflation Processing
    N=No
    Y=Yes
    32 LOW_VALUE_SW Character(1) VARCHAR2(1) NOT NULL Low Value Asset Only