RUN_AMAEMASS_02

(SQL Table)
Index Back

Run COntrol for AE AMAEMASS

  • Parent record: RUN_AMAEMASS
  • # 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 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
    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
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    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