BU_BOOK_TEO2

(SQL Table)
 Index Back

Business Unit Financial Books

  • Parent record: BUS_UNIT_TBL_AM

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EO_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
    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 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

    Y/N Table Edit

    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 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
    13 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
    14 BUD_LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Budget Ledger Group
    15 BUDGET_LEDGER Character(10) VARCHAR2(10) NOT NULL Budget Ledger
    16 ACCT_ENT_TMPL_ID Character(10) VARCHAR2(10) NOT NULL Account Entry Template ID

    Default Value: INSTALLATION_AM.ACCT_ENT_TMPL_ID

    Prompt Table: AMAE_TMPLID_TBL

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

    Prompt Table: CAL_DEFN_DPR_VW

    18 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

    19 COMMENTS Long Character CLOB Comment
    20 GROUP_PROC_SW Character(1) VARCHAR2(1) NOT NULL Group Asset Processing

    Y/N Table Edit

    21 CHILD_TK_PARENT_SW Character(1) VARCHAR2(1) NOT NULL Child Inherits Parent's Life

    Y/N Table Edit

    Default Value: N

    22 INFL_ADJ_SW Character(1) VARCHAR2(1) NOT NULL Inflation Processing
    N=No
    Y=Yes

    Default Value: N

    23 CALC_TYPE_INFL Character(1) VARCHAR2(1) NOT NULL Calculation Type
    A=Argentina Adjustment
    B=Brazil Adjustment
    C=Mexico Adjustments

    Default Value: C

    24 DAY_CALC Character(1) VARCHAR2(1) NOT NULL Daily Calculation
    N=No
    Y=Yes

    Default Value: N

    25 COST_LIMIT_CD Character(10) VARCHAR2(10) NOT NULL Cost Limit Code

    Prompt Table: DEPR_CAP_TBL

    26 DEROGATORY_SW Character(1) VARCHAR2(1) NOT NULL Derogatory Depreciation

    Y/N Table Edit

    Default Value: N

    27 BOOK_STATUTORY Character(10) VARCHAR2(10) NOT NULL Statutory Book

    Prompt Table: SP_BOOK_NONVW

    28 ROUND_TYPE Character(1) VARCHAR2(1) NOT NULL Round Type
    C=Currency
    G=Generic

    Default Value: C

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

    Default Value: N

    30 ROUND_PRECISION Signed Number(4,0) DECIMAL(3) NOT NULL Rounding Precision
    31 ROUND_FACTOR Number(15,7) DECIMAL(14,7) NOT NULL Rounding Factor
    32 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

    Default Value: Y

    33 STORE_DEPR_BY_PD Character(1) VARCHAR2(1) NOT NULL Store Depr By Period

    Y/N Table Edit

    Default Value: N

    34 ALLOW_AUTO_RET_SW Character(1) VARCHAR2(1) NOT NULL Auto-Retire Fully Depr Assets
    N=No
    Y=Yes

    Y/N Table Edit

    35 LOW_VALUE_SW Character(1) VARCHAR2(1) NOT NULL Low Value Asset Only

    Y/N Table Edit

    36 ONLINE_RPT_SW Character(1) VARCHAR2(1) NOT NULL On-Line Reporting

    Y/N Table Edit

    37 TRANSLATE_GL_SW Character(1) VARCHAR2(1) NOT NULL Translate Gain/Loss

    Y/N Table Edit

    38 TRANSLATE_ACCOUNT Character(10) VARCHAR2(10) NOT NULL Translate Account

    Prompt Table: GL_ACCT_CUR_VW

    39 BKC_DIST_GRP Character(10) VARCHAR2(10) NOT NULL Book Code Distribution Code
    40 IMPAIR_FLG Character(1) VARCHAR2(1) NOT NULL Impairment Process
    41 IMP_REVERSE_FLG Character(1) VARCHAR2(1) NOT NULL Impairment Reversal
    42 IMP_COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type For Impairment Loss
    43 REVERSE_COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type for Imp Reversal
    44 NEG_DEPR_SW Character(1) VARCHAR2(1) NOT NULL Stop Depr when NBV < Salvage
    45 REVALUE_FLG Character(1) VARCHAR2(1) NOT NULL Revaluation Process
    46 REVAL_WRT_OFF_FLG Character(1) VARCHAR2(1) NOT NULL Revaluation Write-Off
    47 REVAL_REVERSAL_FLG Character(1) VARCHAR2(1) NOT NULL Revaluation Reversal
    48 REVAL_COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type for Revaluation
    49 REVAL_WRTOFF_CS_TY Character(1) VARCHAR2(1) NOT NULL Cost Type for Reval Write-Off
    50 IMP_REVER_CST_TY Character(1) VARCHAR2(1) NOT NULL Cost Type For Reval Reversal
    51 REVALUE_METHOD Character(1) VARCHAR2(1) NOT NULL Revaluation Method
    C=Cost Based
    D=Depr. Write-Off
    I=Investment Property
    52 REVAL_TRANS_CODE Character(5) VARCHAR2(5) NOT NULL Rev. Trans. Code
    53 INVEST_PROPERTY Character(1) VARCHAR2(1) NOT NULL Investment Property
    54 INV_PROP_TRANS_CD Character(5) VARCHAR2(5) NOT NULL Investment Property Trans Code
    55 CHART_EDIT_OPTION Character(1) VARCHAR2(1) NOT NULL Chartfield Edit Option
    D=Default from Higher Level
    K=Reject w/ edit error
    N=No Edits
    R=Recycle
    S=Use suspense account
    W=Warning
    56 EO_FROM_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code