AM_FDRL_RUL_DTL

(SQL Table)
Index Back

AM Federal Asset Rule Detail

  • Parent record: AM_FDRL_RUL_HDR
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 AM_FDRL_RULE Character(10) VARCHAR2(10) NOT NULL AM Federal Asset Rules field
    3 EFFDT Date(10) DATE NOT NULL Effective Date
    4 CATEGORY Character(5) VARCHAR2(5) NOT NULL Asset Category

    Prompt Table: CATEGORY_TBL

    5 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    6 TRANS_TYPE Character(3) VARCHAR2(3) NOT NULL Types of Asset Management Transactions
    ACR=Accretion Expense
    ADD=Asset Addition
    ADJ=Asset Cost Adjustment
    BKS=Book Adjustment
    BUD=Budgeted Depreciation
    DPR=Depreciation
    INF=Inflation Adjustment
    LEX=Lease Expense
    LPB=Budgeted Lease Payments
    LPY=Lease Payment
    PDP=Prior Period Depreciation
    PLP=Prior Lease Payment
    RAD=Manual Reserve Adjustment
    RCT=Asset Recategorization
    REI=Asset Reinstatement
    RES=Resume Depreciation
    RET=Asset Retirement
    RRC=Retro rate change for grp ast
    SUS=Suspend Depreciation
    TRF=Asset Transfer
    7 DISTRIBUTION_TYPE Character(2) VARCHAR2(2) NOT NULL Distribution Type
    8 TRANS_IN_OUT Character(1) VARCHAR2(1) NOT NULL Transaction In/Out
    I=In
    M=IUT Proceeds Markup
    O=Out
    9 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

    Prompt Table: GL_ACCT_ALL_VW

    10 ACCOUNT_SIGN Signed Number(2,0) DECIMAL(1) NOT NULL Account Sign
    11 SIGN_ADJUSTER Signed Number(2,0) DECIMAL(1) NOT NULL Used to adjust sign for AM trn