Appendix A Data Mapping CAPPS to SPA Integration – All fields are located on Record: TX_SPA002B_DTL FIELDNAME FIELD TYPE SOURCE TX_SPA_DTTM_STAGED DateTime Current Date TX_LINE_NBR Number TX_LINE_NBR +1 TX_SPA_TCODE Character A, I, D, E, R, " " Substring(TX_AUDIT_ASSET.BUSINESS_UNIT, TX_AGENCY Character 1, 3) TX_ASSET_COMP.ASSET_ID / TX_ASSET_COMP.PARENT_ID / TX_ASSET_AUDIT.PARENT_ID / TX_ASSET_AUDIT.ASSET_ID/ TX_AUDT_ACQ_DET.ASSET_ID/ TX_AUDIT_DBT_FN.ASSET_ID/ TX_AUDIT_A_LOC.ASSET_ID/ TX_SPA_PROP_NUM Character TX_AUDIT_BOOK.ASSET_ID TX_ASSET_COMP.TX_ASSET_COMP_ID / TX_SPA_COMPNT_NUM Character "01" "00001"/ ASSET_ACQ_DET.TX_SPA_QUANTITY/ TX_SPA_QUANTITY Character "*"
Appendix A – Data Mapping CAPPS to SPA Integration All fields are located on Record: TX_SPA002B_DTL FIELDNAME FIELD TYPE SOURCE TX_SPA_DTTM_STAGED DateTime Current Date TX_LINE_NBR Number TX_LINE_NBR +1 TX_SPA_TCODE Character A, I, D, E, R, " " TX_AGENCY Character Substring(TX_AUDIT_ASSET.BUSINESS_UNIT, 1, 3) TX_SPA_PROP_NUM Character TX_ASSET_COMP.ASSET_ID / TX_ASSET_COMP.PARENT_ID / TX_ASSET_AUDIT.PARENT_ID / TX_ASSET_AUDIT.ASSET_ID/ TX_AUDT_ACQ_DET.ASSET_ID/ TX_AUDIT_DBT_FN.ASSET_ID/ TX_AUDIT_A_LOC.ASSET_ID/ TX_AUDIT_BOOK.ASSET_ID TX_SPA_COMPNT_NUM Character TX_ASSET_COMP.TX_ASSET_COMP_ID / "01" TX_SPA_QUANTITY Character "00001"/ ASSET_ACQ_DET.TX_SPA_QUANTITY/ "*"
capps-asset-management-to-spa-user-guide-july-2017.docx