Differences

This shows you the differences between two versions of the page.

adminhelp:productadministration:customtables [2019/02/08 06:20]
bdjordje
adminhelp:productadministration:customtables [2019/05/31 07:49] (current)
bdjordje
Line 145: Line 145:
 When hidden, custom tables are displayed in the configuration they look the same as other custom tables //(Figure K)//. Admins can edit them, delete them or change their content.  When hidden, custom tables are displayed in the configuration they look the same as other custom tables //(Figure K)//. Admins can edit them, delete them or change their content. 
  
 +====== Custom Tables Logging ======
 +
 +The timestamp and the performer of actions performed on custom tables are logged for each individual row in the columns **CpqTableEntryDateModified** and **CpqTableEntryModifiedBy**. From the administrator side, the columns are visible in **Setup > Product Catalog > Custom Tables > View Entries**, and from the user side, they are visible in **User Menu >  Manage Tables > View Entries**. The columns are automatically populated with the date and time the table was modified, and the username and the full name of the person that modified it. The action itself is not logged. The columns are populated after the following actions are performed:
 +  * add table
 +  * add row
 +  * edit row
 +  * copy row
 +  * import entries
 +  * import custom table
 +  * add column to the table
 +  * any actions affecting custom tables in **Deploy/Send Changes**
 +
 +Moreover, the new columns are also populated when the following actions are performed via SOAP API:
 +  * CREATETABLE
 +  * DELETETABLE
 +  * EXPORTROWS
 +  * EXPORTTABLE
 +  * INSERTROWS
 +  * UPDATEROWS
 +  * UPSERTROWS
 +  * DELETEROWS 
 +
 +However, the following actions in custom tables are logged in the **Admin Action Audit Trail**:
 +  * add new table (via SOAP API, Excel, IP script or manually; also logged in the new columns)
 +  * add column to the table (also logged in the new columns)
 +  * changing the **PII** and **Sensitive Data** flags
 +  * delete row
 +  * delete table.
 +
 +=== More Information ===
 +\\
 +[[limitsandtroubleshooting:troubleshooting:setup_troubleshooting|Setup Troubleshooting]]
You are here: SAP Sales Cloud CPQ Online HelpAdmin Page HelpProduct AdministrationCustom Tables