1. Customer Hub (UCM) Master Data Management Reference
  2. S_UCM_ASSET Table

S_UCM_ASSET Table

The following table shows details of the S_UCM_ASSET table which is used for Financial Account Source Data and History (SDH).

Column Name Data Type Comments

ACCNT_CATEGORY_CD

Varchar (30)

The account category of a financial account. Example values include Asset, and Liability.

PAR_UCM_ACCNT_ID

Varchar (15)

Parent Oracle Customer Hub (UCM) Account ID. The foreign key table is S_UCM_ORG_EXT.

TRANSACTION_ID

Varchar

Oracle Customer Hub (UCM) asset for the S_ASSET table.