BOOK_GRP_RATE

(SQL Table)
 Index Back

Financial Book

  • Parent record: BOOK

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

    Prompt Table: SP_BU_AM_NONVW

    2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
    3 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name

    Prompt Table: SP_BU_BK_NONVW

    4 EFFDT Date(10) DATE Effective Date
    5 DEPR_PERCENT Number(10,8) DECIMAL(9,8) NOT NULL Depreciation Percent
    6 METHOD Character(2) VARCHAR2(2) NOT NULL Method
    DL=DB w/SL By Limit%
    DX=Declining Balance w/SL
    F1=France Derogatory Balance
    FL=Flat Rate %
    G1=Germany Staffel Method
    J1=Japan- Tangible/Declining Bal
    J2=Japan- Tangible/Strt Line
    J3=Japan- Intangible/Strt Line
    J4=Japan - Lease Depreciation
    J5=Japan-Changes DB to SL
    J6=Japan - Changes DB to SL 250
    J7=Japan-Tangible/Strt Line Rev
    J8=Japan - Changes DB to SL 200
    J9=JPN - Changes 200/250 DB to SL
    JE=Japan - Extended/Strt Line
    MN=Manual Depreciation
    PC=Declining Balance
    SC=Depreciation Schedule
    SL=Straight Line
    SP=Straight Line Percent
    SY=Sum of the Years
    UD=User Defined Method
    UP=Units of Production