PC_AM_DEFN

(SQL Table)
Index Back

Projects Defined Assets

Assets Defined in the Projects system to be sent to Asset Management via the PC to AM integration.

  • Related Language Record: PC_AM_DEFN_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_AM_NONVW

    2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

    Prompt Table: PC_AM_DEFN_VW

    3 INTFC_ID Number(8,0) INTEGER NOT NULL Interface ID
    4 INTFC_LINE_NUM Number(8,0) INTEGER NOT NULL Interface Line Number
    5 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID

    Prompt Table: PROFILE_PCAM_VW

    6 GROUP_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Group Asset ID

    Prompt Table: %EDITTABLE6

    7 PARENT_ID Character(12) VARCHAR2(12) NOT NULL Parent ID

    Prompt Table: %EDITTABLE2

    8 PARENT_DESCR Character(30) VARCHAR2(30) NOT NULL Parent Asset Description
    9 AM_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL AM Distribution Status
    D=Distributed
    I=Ignore
    M=Modified
    N=Not Distributed
    P=Pending
    V=Reversed

    Default Value: N

    10 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name

    Prompt Table: %EDITTABLE3

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

    Prompt Table: %EDITTABLE4
    Set Control Field: BUSINESS_UNIT_AM

    12 QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Interface

    Default Value: 1

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

    Prompt Table: %EDITTABLE5
    Set Control Field: BUSINESS_UNIT_AM

    14 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: LOCATION_TBL
    Set Control Field: BUSINESS_UNIT_AM

    15 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
    16 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
    17 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
    18 ASSET_OPTION Character(3) VARCHAR2(3) NOT NULL Asset Creation Option
    ADD=Auto Assign New Asset ID
    ADJ=Adjust Existing Asset
    MAN=Manually Assign Asset ID

    Default Value: MAN

    19 GROUP_ASSET_FLAG Character(1) VARCHAR2(1) NOT NULL Group Asset Flag
    G=Group Asset
    M=Group Member
    N=None
    20 TRANS_DT Date(10) DATE Transaction Date

    Default Value: %DATE

    21 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

    Default Value: %DATE

    22 IN_SERVICE_DT Date(10) DATE In Service Date

    Default Value: %DATE

    23 RETIREMENT_DT Date(10) DATE Projected Retirement Date
    24 RETIRE_CONVENTION Character(2) VARCHAR2(2) NOT NULL Retirement Convention
    25 DISPOSAL_CODE Character(1) VARCHAR2(1) NOT NULL Retirement Type
    A=Abandonment
    C=Cannibalize for Other Assets
    D=Disappeared Assets
    E=Expensed
    F=Disposal Due to Theft
    I=Returned to Inventory
    L=Like Kind Exchange
    M=Missing Asset
    N=Donated to External Group
    O=ARO Settlement
    R=Scrapped Assets
    S=Retirement by Sale
    T=Traded In for another Asset
    V=Auto-Retire Fully Depr Assets
    Y=Casualty Loss

    Default Value: S

    26 RETIREMENT_TYPE Character(1) VARCHAR2(1) NOT NULL Retirement Type
    E=Extraordinary
    O=Ordinary Retirement

    Default Value: O

    27 RETIREMENT_STATUS Character(1) VARCHAR2(1) NOT NULL Retirement Status
    C=Depreciation Calculated
    N=New Retirement
    P=Posted to General Ledger
    R=Reinstated Retirement
    U=No Retirements Exist

    Default Value: U

    28 RETIRE_QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Retirement Quantity
    29 RETIREMENT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Retirement Amount
    30 PROCEEDS Signed Number(28,3) DECIMAL(26,3) NOT NULL Retirement Proceeds
    31 REMOVAL_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Removal Cost
    32 TRADE_IN_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Trade In Asset

    Prompt Table: ASSET

    33 TRADE_IN_DTTM_STMP DateTime(26) TIMESTAMP Trade In DateTime Stamp
    34 TRADE_IN_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Trade In Amount
    35 GAIN_LOSS Signed Number(28,3) DECIMAL(26,3) NOT NULL Retirement Gain/Loss
    36 CASH Signed Number(28,3) DECIMAL(26,3) NOT NULL Cash Received/Paid
    37 TRADE_IN_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Trade In value
    38 NON_LIKE_KIND Signed Number(28,3) DECIMAL(26,3) NOT NULL FMV Non Like Kind Property
    39 LIABILITY_ASSUMED Signed Number(28,3) DECIMAL(26,3) NOT NULL Liabilities Assumed
    40 FULLY_DEPR_SW Character(1) VARCHAR2(1) NOT NULL Retire As Fully Depreciated SW
    F=Fully Depr with Future Expense
    N=Calculate Gain/Loss
    Y=Fully Depr no Future Expense
    41 TXN_PROCEEDS Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Proceeds
    42 TXN_REMOVAL_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Removal Cost
    43 TXN_CASH Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Cash
    44 TXN_TRADE_IN_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Trade-In Value
    45 TXN_NON_LIKE_KIND Signed Number(28,3) DECIMAL(26,3) NOT NULL FMV Non Like-Kind
    46 TXN_LIAB_ASSUMED Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Liability Assumed
    47 TXN_CURRENCY_CD2 Character(3) VARCHAR2(3) NOT NULL Transaction Currency Display
    48 RATE_MULT_2 Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
    49 RATE_DIV_2 Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
    50 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    51 TAGGABLE_SW Character(1) VARCHAR2(1) NOT NULL Taggable Asset
    N=Non Taggable Asset
    Y=Taggable Asset
    52 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
    53 ASSET_STATUS Character(1) VARCHAR2(1) NOT NULL Asset Status
    A=Received (Not in Service)
    B=Budgeted
    C=Commitment
    D=Disposed
    I=In Service
    M=Suspended
    R=Requisitioned
    T=Transferred
    W=Work In Progress
    54 REPLACE_SW Character(1) VARCHAR2(1) NOT NULL Replacement Asset

    Default Value: N

    55 REPLACE_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Replaced Asset ID
    56 ACQUISITION_CD Character(1) VARCHAR2(1) NOT NULL Acquisition Code
    C=Constructed
    D=Donated
    I=Trade In
    K=Like Exchange
    L=Leased
    P=Purchased
    T=Transferred

    Default Value: C

    57 CUSTODIAN Character(30) VARCHAR2(30) NOT NULL Custodian
    58 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    59 DEFAULT_PROFILE_SW Character(1) VARCHAR2(1) NOT NULL Default Books from Profile

    Y/N Table Edit

    Default Value: Y

    60 INTFC_STATUS Character(3) VARCHAR2(3) NOT NULL Interface Status
    CON=Consolidated
    DON=Mass Changes Generated
    ERR=Error
    NEW=Mass Changes Not Generated
    REP=Replaced by Other Records (AP)
    UNI=Unitized

    Default Value: NEW

    61 INTFC_TYPE Character(3) VARCHAR2(3) NOT NULL Trans Load Type

    Default Value: FAD

    62 LOAD_STATUS Character(3) VARCHAR2(3) NOT NULL /* -> JMZ. PSOFT. 11-OCT-2002 */ New Status were added : HLD and INP for Asset Management. /* <- JMZ. PSOFT. 11-OCT-2002 */
    CON=Consolidated
    DON=Loaded
    ERR=Errored
    EXC=Excluded
    HLD=On Hold
    INP=In Process
    NEW=Pending
    PGI=PO Grp Incomplete
    REP=Replaced
    UNI=Unitized

    Default Value: NEW

    63 TRANS_CODE Character(5) VARCHAR2(5) NOT NULL Transaction Code
    64 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.

    Default Value: BPC

    65 OPEN_TRANS_ID Number(10,0) DECIMAL(10) NOT NULL Open Transaction ID
    66 APPROVAL_SW Character(1) VARCHAR2(1) NOT NULL Auto Approval Status

    Y/N Table Edit

    Default Value: Y

    67 BOOK_EFFDT Date(10) DATE Book Effective Date
    68 LOCATION_EFFDT Date(10) DATE Location Effective Date
    69 ASSET_ALLOC_QTY Signed Number(17,2) DECIMAL(15,2) NOT NULL Asset Allocation Basis Qty
    70 ASSET_ALLOC_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Asset Allocation Basis Amt
    71 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag
    72 BOOK_PROCESSING_SW Character(1) VARCHAR2(1) NOT NULL Enable Book Processing
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    73 PARENT_ASSET_SW Character(1) VARCHAR2(1) NOT NULL Parent Asset
    N=No
    Y=Yes

    Default Value: N

    74 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: %EDIT_DEPT
    Set Control Field: BUSINESS_UNIT_AM

    75 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    76 MANUFACTURER Character(60) VARCHAR2(60) NOT NULL Manufacturer Name

    Prompt Table: MANUF_FS_VW
    Set Control Field: BUSINESS_UNIT_AM

    77 MODEL Character(30) VARCHAR2(30) NOT NULL Model
    78 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
    79 FILTER_DTTM DateTime(26) TIMESTAMP Filter date time stamp
    80 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
    81 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance