Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Table Information for the Copy Transfer Data To Asset Audit Log Screen

Specific table results have already been detailed that are contingent upon the copy option you selected.

The following table results are consistent across all copy options:

  • FA_TRACKING.TRN_DT is written to ASSET_AUDIT_LOG.ENTR_DT.
  • FA_TRACKING.ENTR_USER_ID is written to ASSET_AUDIT_LOG.ENTR_USER_ID.
  • The user ID of person running the process is written to ASSET_AUDIT_LOG.MODIFIED_BY.
  • The date/time of the process is written to ASSET_AUDIT_LOG.TIME_STAMP.
  • FA_FY_INFO and FA_PD_INFO table data is used to translate FA_TRACKING.TRN_DT into appropriate information to write to ASSET_AUDIT_LOG.FY_CD and ASSET_AUDIT_LOG.PD_NO.
  • If there is no matching information for the FA_TRACKING.TRN_DT in the FA_FY_INFO and/or FA_PD_INFO table, the following defaults are written to the ASSET_AUDIT_LOG:
    • ASSET_AUDIT_LOG.FY_CD = NULL
    • ASSET_AUDIT_LOG.PD_NO = 0
    • ASSET_AUDIT_LOG.SUB_PD_NO = 0
  • ASSET_AUDIT_LOG.JE_REQD_FL should be set to "N."