TX_SPA_PROPCOMM_CD Character N/A Year(TX_AUDIT_ASSET.PRODUCTION_DT) / TX_SPA_MODEL_YR Character Year(ASSET.PRODUCTION_DT) TX_AUDIT_ASSET.SERIAL_ID / COMP_SERIAL_ID Character ASSET.SERIL_ID TX_AUDIT_ASSET.MANUFACTURER/ TX_SPA_MANUFACTR Character ASSET.MANUFACTURER TX_CAP_FLAG Character N/A TX_AUDIT_BOOK.LIFE/ TX_SPA_USEFUL_LIFE Character BOOK.LIFE TX_SPA_CMP_COM_TXT Character "See CAPPS system for comments" TX_AUDIT_ASSET.TX_ASSET_COND_CODE / TX_SPA_COND_CD Character ASSET.TX_ASSET_COND_CODE TX_SPA_REASSIGN_CD Character "N" TX_SPA_COUNTY Character LOCATION_TBL.COUNTY / TX_AUDIT_ASSET.TX_TRANS_FROM_AGY / TX_TRANS_FROM_AGY Character " " TX_AUDIT_ASSET.TX_PREV_PROP_NUM / TX_SPA_PREV_PROP_N Character ASSET.TX_PREV_PROP_NUM TX_AUDIT_ASSET.PROD_VERSION/ TX_SPA_CMP_SW_VER Character TX_AUDIT_COST.FUND_CODE / TX_SPA_FUND_NUM Character PSTREENODE.PARENT_NODE_NAME TX_AUDIT_ASSET.TX_AGENCY_ACQ_CD / TX_SPA_ACQ_MTHD_CD Character ASSET.TX_AGENCY_AQC_CD TX_SPA_APPROP_NUM Character " " TX_SPA_PROJECT_NUM Character " " TX_SPA_GRANT_NUM Character " " ASSET_CLASS_TBL.TX_CON_COBJ/ TX_SPA_COMP_OBJ Character ASSET_CLASS_TBL.TX_CAP_COBJ TX_SPA_AGY_OBJ_CD Character N/A
TX_SPA_PROPCOMM_CD Character N/A TX_SPA_MODEL_YR Character Year(TX_AUDIT_ASSET.PRODUCTION_DT) / Year(ASSET.PRODUCTION_DT) COMP_SERIAL_ID Character TX_AUDIT_ASSET.SERIAL_ID / ASSET.SERIL_ID TX_SPA_MANUFACTR Character TX_AUDIT_ASSET.MANUFACTURER/ ASSET.MANUFACTURER TX_CAP_FLAG Character N/A TX_SPA_USEFUL_LIFE Character TX_AUDIT_BOOK.LIFE/ BOOK.LIFE TX_SPA_CMP_COM_TXT Character "See CAPPS system for comments" TX_SPA_COND_CD Character TX_AUDIT_ASSET.TX_ASSET_COND_CODE / ASSET.TX_ASSET_COND_CODE TX_SPA_REASSIGN_CD Character "N" TX_SPA_COUNTY Character LOCATION_TBL.COUNTY TX_TRANS_FROM_AGY Character / TX_AUDIT_ASSET.TX_TRANS_FROM_AGY / " " TX_SPA_PREV_PROP_N Character TX_AUDIT_ASSET.TX_PREV_PROP_NUM / ASSET.TX_PREV_PROP_NUM TX_SPA_CMP_SW_VER Character TX_AUDIT_ASSET.PROD_VERSION/ TX_SPA_FUND_NUM Character TX_AUDIT_COST.FUND_CODE / PSTREENODE.PARENT_NODE_NAME TX_SPA_ACQ_MTHD_CD Character TX_AUDIT_ASSET.TX_AGENCY_ACQ_CD / ASSET.TX_AGENCY_AQC_CD TX_SPA_APPROP_NUM Character " " TX_SPA_PROJECT_NUM Character " " TX_SPA_GRANT_NUM Character " " TX_SPA_COMP_OBJ Character ASSET_CLASS_TBL.TX_CON_COBJ/ ASSET_CLASS_TBL.TX_CAP_COBJ TX_SPA_AGY_OBJ_CD Character N/A