1. Tables and Views for Sales and Fusion Service
  2. Tables and Views for CX Sales and Fusion Service

Tables and Views for CX Sales and Fusion Service

This Tables and Views guide contains the information about tables within Oracle Sales and Fusion Service and their columns, primary keys, and indexes. The Tables and Views guide also includes the information about views within Oracle Sales and Fusion Service along with the columns and queries associated with each view. For your reference:

  • Tables are the basic unit of data storage in Oracle Sales and Fusion Service, where data is stored in rows and columns. For example, the OKC_PRICING_TERMS table stores information about the pricing terms for parent entities such as Sales Agreements, Promotions or Discount Lists. This table stores attributes like pricing term identifier, adjustment type code, and adjustment amount.

  • A view is a logical representation of a table or combination of tables. A view is a stored query that derives its data from the tables on which it is based. For example, the HZ_CUST_ACCOUNTS_SEC view shows attributes like the party identifier, account number, and customer account identifier.