ASSET_LANG

(SQL Table)
Index Back

Asset General Information

  • Related Language Record for AM_VAT_ATTR_SRC ASSET ASSETMETER_SRCH ASSET_ALL_VW ASSET_ALL_VW_OL ASSET_FIN_SRCH ASSET_FS_VW ASSET_GRPM_SRCH ASSET_GRP_SRCH ASSET_JV_VW ASSET_MTR_SRCH ASSET_NFLS_SRCH ASSET_NF_SRCH ASSET_NOGP_SRCH ASSET_NOGR_SRCH ASSET_PC_SRCH ASSET_SRCH ASSET_SS_TRF_VW ASSET_SS_VW AST_FINACT_SRCH AST_OPLACT_SRCH PARENTASSETSRCH PARENTASST_SRCH WM_ASSETBASE_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL 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

    Default Value: NEXT

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: ASSET.DESCR

    6 DESCR_LONG Character(254) VARCHAR2(254) NOT NULL Long Description