DIST_TMPL_TBL

(SQL Table)
Index Back

AM Distribution Templates

  • Parent Record Of DIST_TMPLLN_TBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 CATEGORY Character(5) VARCHAR2(5) NOT NULL Asset Category

    Prompt Table: CATEGORY_TBL

    3 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type

    Prompt Table: COST_TYPE_TBL

    4 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

    Prompt Table: DIST_TT_VW

    5 TRANS_CODE Character(5) VARCHAR2(5) NOT NULL Transaction Code

    Prompt Table: TRANS_CODE_VW

    6 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

    7 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template

    Prompt Table: JRNLGEN_APPL_ID

    8 APPL_JRNL_ID_BUD Character(10) VARCHAR2(10) NOT NULL Budget Journal Template ID

    Prompt Table: JRNLGEN_APPL_ID