What Is The Hz_cust_site_uses_all Table

Asked By John M Bartell 0 points N/A Posted on - 07/04/2019

I am new to Oracle sales cloud. I found a long list of tables I do not understand. I got hold of one particular table. It is the hz_cust_site_uses_all table. What is this table used for? What are some columns in this table?

• Status: Open
• Question Views: 201
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database
• Question Tags: Oracle

Answered By Laurie W Carpenter 0 points N/A #319443

What Is The Hz_cust_site_uses_all Table

The Oracle cloud hz_cust_site_uses_all table is a table that stores all business purposes assigned to customer account sites with multiple purposes. The foreign key is CUST_ACCT_SITE_ID and is of the Fusion schema.

The primary key for the table is HZ_CUST_SITE_USES_PK. Some other columns in this table are:

● SITE_USE_ID
● LAST_UPDATE_DATE
● LAST_UPDATED_BY
● CREATION_DATE
● CREATED_BY
Some foreign keys are:
● HES_BILL_REQUEST_ALL
● AR_PAYMENT_SCHEDULES_ALL
● HZ_CUST_PROFILE_AMTS_F
● IEX_DELINQUENCIES_ALL

The foreign tables for the same can be found on the Oracle website.

About Laurie W Carpenter

Questions
7

Answers
11

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 07/04/2019
• Question Category: Oracle Database