|
AR_TRANSACTION_HISTORY_ALL
|
Life cycle of a
transaction
|
|
AR_TRANSMISSIONS_ALL
|
Lockbox transmission
information
|
|
AR_TRANSMISSION_FORMATS
|
Lockbox transmission
formats
|
|
AR_TRANS_FIELD_FORMATS
|
Format of each field
in a Lockbox transmission format
|
|
AR_TRANS_RECORD_FORMATS
|
Format of a record
within a Lockbox transmission format
|
|
AR_TRX_BAL_SUMMARY
|
This table stores the
fields, such as 'Total Invoices Value', 'Total Invoices Count', 'Total Cash
Receipts Value', etc., that require summarization for a specified period of
time. The lowest level of granularity
at which the data can be st
|
|
AR_TRX_COGS_GT
|
|
|
AR_TRX_HEADER_GT
|
|
|
AR_TRX_HEADER_TMP_GT
|
|
|
AR_TRX_LINES_GT
|
|
|
AR_TRX_LINES_TMP_GT
|
|
|
AR_TRX_SUMMARY
|
This table stores the
fields, such as 'Total Invoices Value', 'Total Invoices Count', 'Total Cash
Receipts Value', etc., that require summarization for a specified period of
time. The lowest level of granularity
at which the data can be st
|
|
AR_TRX_SUMMARY_HIST
|
This table stores the
history of all the modifications, performed on different transactions, which
would affect the data in the summary tables.
|
|
AR_UPG_120_CONTROL
|
This table is used to
control ar 12.0 upgrade scripts
|
|
AR_VAT_TAX_ALL_B
|
Tax codes defined in
the Tax Codes and Rates window
|
|
AR_VAT_TAX_ALL_TL
|
Multi-lingual support
(MLS) for each tax code that you define
|
|
AR_XLA_HEADERS_EXTRACT
|
|
|
AR_XLA_LINES_EXTRACT
|
|
|
BATCH_NUMBER_CONTROL
|
|
|
HZ_ADAPTERS
|
The HZ_ADAPTERS table
stores information about the adapters that are configured to provide data
integration services
|
|
HZ_ADAPTER_LOGS
|
The HZ_ADAPTER_LOGS
table tracks requests for service from data integration services providers
|
|
HZ_ADAPTER_TERRITORIES
|
The
HZ_ADAPTER_TERRITORIES table stores information about the countries or
territories that are supported for a particular data integration service
adapter
|
|
HZ_ADAPTER_USERS
|
Stores user
information for adapters
|
|
HZ_ADDRESS_USAGES
|
Contains the address
usages per country
|
|
HZ_ADDRESS_USAGE_DTLS
|
Contains the required
geography
|
|
HZ_BILLING_PREFERENCES
|
Invoicing format
|
|
HZ_BUS_OBJ_DEFINITIONS
|
Stores definitions of
TCA business objects
|
|
HZ_BUS_OBJ_TRACKING
|
Tracks granular (V2)
entities for raising Business Object events
|
|
HZ_CERTIFICATIONS
|
Certifications given
to parties
|
|
HZ_CITIZENSHIP
|
Person's claimed
nationality
|
|
HZ_CLASS_CATEGORIES
|
Classification categories
for classifying parties and related entities
|
|
HZ_CLASS_CATEGORY_USES
|
Usage of class
categories by owner tables
|
|
HZ_CLASS_CODE_DENORM
|
Denormalization of the
classification code hierarchy
|
|
HZ_CLASS_CODE_RELATIONS
|
Relationships between
classification codes
|
|
HZ_CODE_ASSIGNMENTS
|
Intersection table
linking industrial classification codes to parties or related entities
|
|
HZ_CONTACT_POINTS
|
Electronic methods of
communicating with parties
|
|
HZ_CONTACT_PREFERENCES
|
Stores contact
preference information for parties or their addresses and contact points
|
|
HZ_CONTACT_RESTRICTIONS
|
Restrictions on
contacting parties
|
|
HZ_CREDIT_PROFILES
|
Profiles about a
party's credit policy
|
|
HZ_CREDIT_PROFILE_AMTS
|
Credit limits in
specified currency
|
|
HZ_CREDIT_RATINGS
|
Credit ratings of
parties
|
|
HZ_CREDIT_RATINGS_EXT_B
|
Stores extensible
attributes for credit ratings.
|
|
HZ_CREDIT_RATINGS_EXT_TL
|
Provides multilingual
support for extensible credit rating attributes.
|
|
HZ_CREDIT_USAGES
|
Association between
credit limit and credit usage rule set
|
|
HZ_CREDIT_USAGE_RULES
|
Usage rules assigned
to each credit limit
|
|
HZ_CREDIT_USAGE_RULE_SETS_B
|
Sets of credit usage
rules in the base language
|
|
HZ_CREDIT_USAGE_RULE_SETS_TL
|
Sets of credit usage
rules translated into multiple languages
|
|
HZ_CUSTOMER_MERGE_LOG
|
This table is used to
record account merge audit history
|
|
HZ_CUSTOMER_PROFILES
|
Credit information for
customer accounts and customer account sites
|
|
HZ_CUSTOMER_PROFILES_M
|
This table is used to
store the deleted records for hz_customer_profiles during account merge
|
|
HZ_CUST_ACCOUNTS
|
Stores information
about customer accounts.
|
|
HZ_CUST_ACCOUNTS_M
|
This table is used to
store the deleted records for HZ_CUST_ACCOUNTS during account merge
|
|
HZ_CUST_ACCOUNT_ROLES
|
Roles that parties
perform in customer accounts
|
|
HZ_CUST_ACCOUNT_ROLES_M
|
This table stores the
information of a customer account role
from HZ_CUST_ACCOUNT_ROLES table before the account merge happens. The primary key for
this table is CUST_ACCOUNT_ROLE_ID, CUSTOMER_MERGE_HEADER_ID.
|
|
HZ_CUST_ACCT_RELATE_ALL
|
Relationships between
customer accounts
|
|
HZ_CUST_ACCT_RELATE_ALL_M
|
This table is used to
store the deleted records for HZ_CUST_ACCT_RELATE_ALL during account merge
|
|
HZ_CUST_ACCT_SITES_ALL
|
Stores all customer
account sites across all operating units
|
|
HZ_CUST_ACCT_SITES_ALL_M
|
The HZ_CUST_ACCT_SITES_ALL_M
table stores the information of
customer profile amounts from HZ_CUST_ACCT_SITES_ALL table before
the account merge happens. The primary
key for this table is CUST_ACCT_SITE_ID , CUSTOMER_MERGE_HEADER_ID.
|
|
HZ_CUST_CONTACT_POINTS
|
This table is no
longer used
|
|
HZ_CUST_MERGE_LOG_DICT
|
This table is used to
define the data in hz_customer_merge_log
|
|
HZ_CUST_PROFILE_AMTS
|
Stores information
about the credit limits specified for a customer's profile.
|
|
HZ_CUST_PROFILE_AMTS_M
|
The HZ_CUST_PROFILE_AMTS_M
table stores the information of
customer profile amounts from HZ_CUST_PROFILE_AMTS table before
the account merge happens.The primary
key for this table is CUST_ACCT_PROFILE_AMT_ID, CUSTOMER_MERGE_HEADER_ID.
|
|
HZ_CUST_PROFILE_CLASSES
|
Standard credit
profile classes
|
|
HZ_CUST_PROF_CLASS_AMTS
|
Customer profile class
amount limits for each currency
|
|
HZ_CUST_SITE_USES_ALL
|
Stores business
purposes assigned to customer account sites.
|
|
HZ_CUST_SITE_USES_ALL_M
|
The HZ_CUST_SITE_USES_ALL_M
table stores the information of
customer site uses from HZ_CUST_SITE_USES_ALL table before the account merge happens. The primary key for
this table is CUST_SITE_USE_ID , CUSTOMER_MERGE_HEADER_ID.
|
|
HZ_DL_SELECTED_CRITERIA
|
Stores criteria for
selecting parties to include in batches
|
|
HZ_DNB_REQUEST_LOG
|
Requests for
information from Dun & Bradstreet
|
|
HZ_DQM_SETUP_DIAGNOSTICS
|
Table for storing the
Diagnostic Data for reports
|
|
HZ_DQM_SH_SYNC_INTERFACE
|
Stores the list of
entities that have been created or updated by the DQM API since the DQM
Shadow Staging Program concurrent program was last run.
|
|
HZ_DQM_STAGE_LOG
|
This table logs the
phases that the DQM Staging Program is at
|
|
HZ_DQM_SYNC_INTERFACE
|
Stores the list of
entities that have been updated by the DQM API.
|
|
HZ_DSS_ASSIGNMENTS
|
Data sharing group
assignments
|
|
HZ_DSS_CRITERIA
|
Data sharing group
criteria
|
|
HZ_DSS_ENTITIES
|
Entities that can be
secured
|
|
HZ_DSS_GROUPS_B
|
Data Sharing Groups
|
|
HZ_DSS_GROUPS_TL
|
Translation table for
HZ_DSS_GROUPS_TL
|
|
HZ_DSS_SCHEME_FUNCTIONS
|
Functions that are
used by a particular data security scheme
|
|
HZ_DSS_SECURED_ENTITIES
|
Entities that are
secured by a particular data sharing group
|
|
HZ_DUP_BATCH
|
Duplicate
Identification Batch
|
|
HZ_DUP_EXCLUSIONS
|
Duplicate Exclusions
|
|
HZ_DUP_MATCH_DETAILS
|
Match Details
|
|
HZ_DUP_MERGE_PARTIES
|
Parties to be Merged
|
|
HZ_DUP_RESULTS
|
The HZ_DUP_RESULTS
table temporarily stores duplicate identification data during the duplicate
identification of interface tables. The table includes information about the
potential from and to parties. Data in this table is only used for t
|
|
HZ_DUP_SETS
|
Duplicate Party Sets
|
|
HZ_DUP_SET_PARTIES
|
Parties belonging to a
Duplicate Party Set
|
|
HZ_EBI_CUST_LOAD_LOG
|
|
|
HZ_EDUCATION
|
Person's education
information
|
|
HZ_EMAIL_DOMAINS
|
Entity that holds
email domains of organization parties.
|
|
HZ_EMPLOYMENT_HISTORY
|
Person's employment
information
|
|
HZ_ENTITY_ATTRIBUTES
|
Entities and Attribute
information used by Third Party Data Integration.
|
|
HZ_EXT_DATA_RULES_TL
|
Rule Name translation
table for Third Party Data Integration.
|
|
HZ_FINANCIAL_NUMBERS
|
Details of financial
reports
|
|
HZ_FINANCIAL_PROFILE
|
Financial accounts of
parties
|
|
HZ_FINANCIAL_REPORTS
|
Financial reports of
parties
|
|
HZ_FIN_NUMBERS_EXT_B
|
Stores extensible
attributes for financial numbers.
|
|
HZ_FIN_NUMBERS_EXT_TL
|
Provides multilingual
support for extensible financial number attributes.
|
|
HZ_FIN_REPORTS_EXT_B
|
Stores extensible
attributes for financial reports.
|
|
HZ_FIN_REPORTS_EXT_TL
|
Provides multilingual
support for extensible financial report attributes.
|
|
HZ_GEOGRAPHIES
|
The HZ_GEOGRPHIES
table stores data representing physical geographies.
|
|
HZ_GEOGRAPHY_IDENTIFIERS
|
HZ_GEOGRPHY_IDENTIFIERS
stores multiple identifiers used to describe the same geography.
|
|
HZ_GEOGRAPHY_RANGES
|
Stores ranges
associated with a given geography.
|
|
HZ_GEOGRAPHY_TYPES_B
|
HZ_GEOGRPHY_TYPES_B
stores Geography Type classification for geographies: both Master Reference Geography
Types and non-Master Reference Geography Types.
|
|
HZ_GEOGRAPHY_TYPES_TL
|
HZ_GEOGRPHY_TYPES_TL
stores Geography Types in MLS languages.
|
|
HZ_GEO_NAME_REFERENCES
|
Stores the mapping
between location elements and Master Reference geography elements based on
Geography Name Matching.
|
|
HZ_GEO_NAME_REFERENCE_LOG
|
Stores the mapping log
between location elements and Master Reference geography elements based on
Geography Name Matching.
|
|
HZ_GEO_STRUCTURE_LEVELS
|
Stores the
geographical hierarchical structures.
|
|
HZ_GEO_STRUCT_MAP
|
The HZ_GEO_STRUCT_MAP
table stores the map attributes for which a mapping of location components
and geography types are defined.
|
|
HZ_GEO_STRUCT_MAP_DTL
|
The
HZ_GEO_STRUCT_MAP_DTL table stores the actual mapping of location component
and geography type for the details defined in the HZ_GEO_STRUCT_MAP table.
|
|
HZ_HIERARCHY_NODES
|
Contains denormalized
data for hierarchical relationships.
|
|
HZ_IMP_ADAPTERS
|
The HZ_IMP_ADAPTERS
table stores information about using location services adapters to validate
addresses in the interface tables before importing to the TCA Registry. The
table includes the countries that the user chooses to validate, the
|
|
HZ_IMP_ADDRESSES_INT
|
TCA import table for
HZ_LOCATIONS and HZ_PARTY_SITES
|
|
HZ_IMP_ADDRESSES_SG
|
TCA internal table for
processing information loaded into the HZ_IMP_ADDRESSES_INT
|
|
HZ_IMP_ADDRESSUSES_INT
|
TCA import table for
HZ_PARTY_SITE_USES
|
|
HZ_IMP_ADDRESSUSES_SG
|
TCA internal table for
processing information loaded into the HZ_IMP_ADDRESSUSES_INT
|
|
HZ_IMP_BATCH_DETAILS
|
The
HZ_IMP_BATCH_DETAILS table stores detail information about imports of records
from the interface tables to the TCA Registry. The table includes the number
of times that the batch has run, the import status, and the request
identifier of
|
|
HZ_IMP_BATCH_SUMMARY
|
The
HZ_IMP_BATCH_SUMMARY table stores information about import batches
|
|
HZ_IMP_CLASSIFICS_INT
|
TCA import table for
HZ_CODE_ASSIGNMENTS
|
|
HZ_IMP_CLASSIFICS_SG
|
TCA internal table for
processing information loaded into the HZ_IMP_CLASSIFICS_INT
|
|
HZ_IMP_CONTACTPTS_INT
|
TCA import table for
HZ_CONTACT_POINTS
|
|
HZ_IMP_CONTACTPTS_SG
|
TCA internal table for
processing information loaded into the HZ_IMP_CONTACTPTS_INT
|
|
HZ_IMP_CONTACTROLES_INT
|
TCA import table for
HZ_ORG_CONTACT_ROLES
|
|
HZ_IMP_CONTACTROLES_SG
|
TCA internal table for
processing information loaded into the HZ_IMP_CONTACTROLES_INT
|
|
HZ_IMP_CONTACTS_INT
|
TCA import table for
HZ_PARTIES, HZ_RELATIONSHIPS and HZ_ORG_CONTACTS
|
|
HZ_IMP_CONTACTS_SG
|
TCA internal table for
processing information loaded into the HZ_IMP_CONTACTS_INT
|
|
HZ_IMP_CREDITRTNGS_INT
|
TCA import table for
HZ_CREDIT_RATINGS
|
|
HZ_IMP_CREDITRTNGS_SG
|
TCA internal table for
processing information loaded into the HZ_IMP_CREDITRTNGS_INT
|
|
HZ_IMP_DUP_DETAILS
|
No Comments
|
|
HZ_IMP_DUP_PARTIES
|
This table holds the
ID's of the parties that matched the given match rule criteria, along with
their scores, and if any party crossed the auto merge threshold and should be
auto merged
|
|
HZ_IMP_ERRORS
|
TCA import table used
to record error found during the import process
|
|
HZ_IMP_FINNUMBERS_INT
|
TCA import table for
HZ_FINANCIAL_NUMBERS
|
|
HZ_IMP_FINNUMBERS_SG
|
TCA internal table for
processing information loaded into the HZ_IMP_FINNUMBERS_INT
|
|
HZ_IMP_FINREPORTS_INT
|
TCA import table for
HZ_FINANCIAL_REPORTS
|
|
HZ_IMP_FINREPORTS_SG
|
TCA internal table for
processing information loaded into the HZ_IMP_FINREPORTS_INT
|
|
HZ_IMP_INT_DEDUP_RESULTS
|
The HZ_IMP_INT_DEDEUP_RESULTS
table stores the set of duplicates identified as part of the duplicate
identification of interface tables. Each set is identified by a unique
"winner" record that should remain if the other duplicates in the
se
|
|
HZ_IMP_OSR_CHANGE
|
TCA internal table for
processing information loaded into the
|
|
HZ_IMP_PARTIES_INT
|
TCA import table for
HZ_PARTIES, HZ_PERSON_PROFILES and HZ_ORG_PROFILES
|
|
HZ_IMP_PARTIES_SG
|
TCA internal table for
processing information loaded into the HZ_IMP_PARTIES_INT
|
|
HZ_IMP_RELSHIPS_INT
|
TCA import table for
HZ_PARTIES, HZ_PERSON_PROFILES and HZ_ORG_PROFILES
|
|
HZ_IMP_RELSHIPS_SG
|
TCA internal table for
processing information loaded into the HZ_IMP_RELSHIPS_INT
|
|
HZ_IMP_TMP_ERRORS
|
TCA import table used
during runtime to record errors found
during import process
|
|
HZ_IMP_TMP_REL_END_DATE
|
TCA internal table for
storing relationships to be end dated during bulk import
|
|
HZ_IMP_WORK_UNITS
|
TCA import table used
to manage work units during the import process
|
|
HZ_INDUSTRIAL_CLASSES
|
|
|
HZ_INDUSTRIAL_CLASS_APP
|
|
|
HZ_INDUSTRIAL_REFERENCE
|
Industrial references
for organizations
|
|
HZ_INT_DUP_RESULTS
|
The HZ_INT_DUP_RESULTS
table temporarily stores duplicate identification data during the duplicate
identification of interface tables. The table includes information about the
source identifiers and source systems of the party records in th
|
|
HZ_LOCATIONS
|
Physical addresses
|
|
HZ_LOCATIONS_EXT_B
|
Stores extensible
attributes for locations.
|
|
HZ_LOCATIONS_EXT_TL
|
Provides multilingual
support for extensible location attributes.
|
|
HZ_LOCATION_PROFILES
|
The
HZ_LOCATION_PROFILES table stores information, including a history of any
changes and address validations for a subset of attributes from the
HZ_LOCATIONS table
|
|
HZ_LOC_ASSIGNMENTS
|
Relationship between a
location and a tax authority defined in AR_LOCATION_COMBINATIONS
|
|
HZ_LOC_ASSIGNMENTS_OBS
|
No longer used in R12.
|
|
HZ_LOG2
|
No longer used.
|
|
HZ_MATCH_RULES_B
|
Stores information
about match rules.
|
|
HZ_MATCH_RULES_TL
|
Stores translated
information about match rules.
|
|
HZ_MATCH_RULE_CONDITIONS
|
Stores information
conditions and match rules in match rule sets
|
|
HZ_MATCH_RULE_PRIMARY
|
Stores information
about primary attributes in a match rule.
|
|
HZ_MATCH_RULE_SECONDARY
|
Stores information
about secondary attributes in a match rule.
|
|
HZ_MERGE_BATCH
|
Party Merge batch
header information
|
|
HZ_MERGE_DICTIONARY
|
Tables affected by
party merge concurrent program
|
|
HZ_MERGE_ENTITY_ATTRIBUTES
|
Attribute level merge
information for Party Merge
|
|
HZ_MERGE_PARTIES
|
Party Merge batch
detail information
|
|
HZ_MERGE_PARTIES_SUGG
|
Suggested default
information of party merge batch details
|
|
HZ_MERGE_PARTYDTLS_SUGG
|
Suggested default
details for operations performed on the records for merge
|
|
HZ_MERGE_PARTY_DETAILS
|
Details regarding
operations performed on the records
|
|
HZ_MERGE_PARTY_HISTORY
|
History of records
affected by Party Merge operation
|
|
HZ_MERGE_PARTY_LOG
|
Information about the
Party Merge operation
|
|
HZ_MOBILE_PREFIXES
|
Mobile telephone
number prefixes based on country
|
|
HZ_NON_PURGE_CANDIDATES
|
Stores the parties
that have not been identified for purge along with denormalized information
about the parties.
|
|
HZ_ORGANIZATION_INDICATORS
|
Indicators related to
finance, legal, and business standing for business sites
|
|
HZ_ORGANIZATION_PROFILES
|
Detailed information
about organizations
|
|
HZ_ORG_CONTACTS
|
People as contacts for
parties
|
|
HZ_ORG_CONTACT_ROLES
|
Roles played by
organization contacts
|
|
HZ_ORG_PROFILES_EXT_B
|
Stores extensible
attributes for organizations.
|
|
HZ_ORG_PROFILES_EXT_SG
|
Staging table for
copying extensions data for organization profile versioning.
|
|
HZ_ORG_PROFILES_EXT_TL
|
Provides multilingual
support for extensible organization attributes.
|
|
HZ_ORIG_SYSTEMS_B
|
Stores basic source
system information
|
|
HZ_ORIG_SYSTEMS_TL
|
Provides multilingual
support for source system information
|
|
HZ_ORIG_SYS_MAPPING
|
The HZ_ORIG_SYS_MAPPING
table stores the mapping among source systems and owner table names.
|
|
HZ_ORIG_SYS_REFERENCES
|
The
HZ_ORIG_SYSTEM_REFERENCES table stores the mapping between source system
references and the owner tables.
|
|
HZ_PARAM_TAB
|
No longer used
|
|
HZ_PARTIES
|
Information about
parties such as organizations, people, and groups
|
|
HZ_PARTY_INTERFACE
|
Information about
party retrieved from external source
|
|
HZ_PARTY_INTERFACE_ERRORS
|
Information about API
errors
|
|
HZ_PARTY_PREFERENCES
|
Party Preferences
|
|
HZ_PARTY_RELATIONSHIPS
|
Relationships between
parties
|
|
HZ_PARTY_SITES
|
Links party to
physical locations
|
|
HZ_PARTY_SITES_EXT_B
|
Stores extensible
attributes for party sites.
|
|
HZ_PARTY_SITES_EXT_TL
|
Provides multilingual
support for extensible party site attributes.
|
|
HZ_PARTY_SITE_USES
|
The way that a party
uses a particular site or address
|
|
HZ_PARTY_USAGES_B
|
Stores party usage
definition.
|
|
HZ_PARTY_USAGES_TL
|
Provides multilingual
support for party usage definitions.
|
|
HZ_PARTY_USAGE_RULES
|
Stores party usage
rules.
|
|
HZ_PARTY_USG_ASSIGNMENTS
|
Stores information
about party usage assignments.
|
|
HZ_PERSON_INTEREST
|
Information about a
person's personal interests
|
|
HZ_PERSON_LANGUAGE
|
Languages that a
person speaks, reads, or writes
|
|
HZ_PERSON_PROFILES
|
Detailed information
about people
|
|
HZ_PER_PROFILES_EXT_B
|
Stores extensible
attributes for persons.
|
|
HZ_PER_PROFILES_EXT_SG
|
Staging table for
copying extensions data for person profile versioning.
|
|
HZ_PER_PROFILES_EXT_TL
|
Provides multilingual
support for extensible person attributes.
|
|
HZ_PHONE_AREA_CODES
|
Telephone number area
codes based on country
|
|
HZ_PHONE_COUNTRY_CODES
|
Country-specific phone
number information
|
|
HZ_PHONE_FORMATS
|
Country-specific phone
number formats
|
|
HZ_PRIMARY_TRANS
|
Stores information
about transformation for the primary attributes.
|
|
HZ_PURGE_BATCHES
|
Stores the Batches
that have been created for purge.
|
|
HZ_PURGE_CANDIDATES
|
Stores the parties
that have been identified for purge along with denormalized information about
the parties.
|
|
HZ_REFERENCES
|
References given for
parties
|
|
HZ_REGISTRATIONS
|
Stores registration
attempts for each unique user and access domain combination.
|
|
HZ_REG_VERIFICATIONS
|
HZ_REG_VERIFICATIONS
serves as an audit table for each access verification question generated
during the registration process.
|
|
HZ_RELATIONSHIPS
|
Relationships between
entities
|
|
HZ_RELATIONSHIP_TYPES
|
Relationship types
|
|
HZ_ROLE_RESPONSIBILITY
|
Responsibilities for
parties related to their roles in the accounts
|
|
HZ_SECONDARY_TRANS
|
Stores information
about transformation for the secondary attributes.
|
|
HZ_SECURITY_ISSUED
|
Financial instruments
issued by an organization
|
|
HZ_SELECT_DATA_SOURCES
|
Selected data sources
for Third Party Data Integration.
|
|
HZ_SHADOW_ST_CONTACTS
|
|
|
HZ_SHADOW_ST_CPTS
|
|
|
HZ_SHADOW_ST_PARTIES
|
|
|
HZ_SHADOW_ST_PSITES
|
|
|
HZ_SRCH_CONTACTS
|
This table stores the
transformed data for the contacts in the interface tables.
|
|
HZ_SRCH_CPTS
|
This table stores the
transformed data for the contact points in the interface tables.
|
|
HZ_SRCH_PARTIES
|
This table stores the
transformed data for the parties in the interface tables.
|
|
HZ_SRCH_PSITES
|
This table stores the
transformed data for the addresses in the interface tables.
|
|
HZ_STAGED_CONTACTS
|
Contact information
that is staged for DQM.
|
|
HZ_STAGED_CONTACT_POINTS
|
Contact point
information that is staged for DQM.
|
|
HZ_STAGED_PARTIES
|
Party information that
is staged for DQM.
|
|
HZ_STAGED_PARTY_SITES
|
Party Site information
that is staged for DQM.
|
|
HZ_STOCK_MARKETS
|
Exchanges for buying
and selling financial instruments
|
|
HZ_STYLES_B
|
Styles to classify
formats.
|
|
HZ_STYLES_TL
|
Translation table for
HZ_STYLES_B
|
|
HZ_STYLE_FMT_LAYOUTS_B
|
Layout of particular
style format Variation components.
|
|
HZ_STYLE_FMT_LAYOUTS_TL
|
Translation table for
HZ_STYLE_FMT_LAYOUTS_B
|
|
HZ_STYLE_FMT_LOCALES
|
Specific locations for
style formats.
|
|
HZ_STYLE_FMT_VARIATIONS
|
Variations in layout
for style formats.
|
|
HZ_STYLE_FORMATS_B
|
Specific formats valid
for one or more locations.
|
|
HZ_STYLE_FORMATS_TL
|
Translation table for
HZ_STYLE_FORMATS_B.
|
|
HZ_SUSPENSION_ACTIVITY
|
The point in time that
a service is no longer provided
|
|
HZ_THIN_ST_CONTACTS
|
|
|
HZ_THIN_ST_CPTS
|
|
|
HZ_THIN_ST_PARTIES
|
|
|
HZ_THIN_ST_PSITES
|
|
|
HZ_THIRDPARTY_EXCEPS
|
Exceptions to
overwrite rules for specific attributes of specific parties for Third Party
Data Integration.
|
|
HZ_THIRDPARTY_RULE
|
Overwrite rules for
specific attributes for Third Party Data Integration.
|
|
HZ_TIMEZONES
|
Time zone information
|
|
HZ_TIMEZONES_TL
|
Time zone translations
|
|
HZ_TIMEZONE_MAPPING
|
Mapping of address
elements to time zones
|
|
HZ_TRANS_ATTRIBUTES_B
|
Stores information
about the transformations on attributes.
|
|
HZ_TRANS_ATTRIBUTES_TL
|
Stores translated
information about the transformations on attributes.
|
|
HZ_TRANS_FUNCTIONS_B
|
Stores transformation
functions.
|
|
HZ_TRANS_FUNCTIONS_TL
|
Stores translated
transformation functions.
|
|
HZ_USER_CREATE_RULES
|
User data creation
rules for Third Party Data Integration.
|
|
HZ_USER_OVERWRITE_RULES
|
User overwrite rules
for Third Party Data Integration.
|
|
HZ_WIN_SOURCE_EXCEPS
|
Stores attribute
exception information if data are overwritten contrary to the Third Party Data
Integration data source ranking.
|
|
HZ_WORD_LISTS
|
Word Replacement Lists
for Data Quality Management.
|
|
HZ_WORD_REPLACEMENTS
|
Word replacement rules
for Fuzzy Find functionality
|
|
HZ_WORD_RPL_CONDS_B
|
Stores information
about conditions in word replacement lists
|
|
HZ_WORD_RPL_CONDS_TL
|
Provides multilingual
support for word replacement conditions.
|
|
HZ_WORD_RPL_COND_ATTRIBS
|
Stores attributes
associated with word replacement conditions.
|
|
HZ_WORK_CLASS
|
Classifications or
groupings of work activities
|
|
NEXDESC_TBL
|
|
|
NEXLOCLNEXUS
|
|
|
NEXMERCHANT_DETAIL
|
|
|
NEXMERCHANT_HEADER
|
|
|
NEXSTNEXUS
|
|
|
RA_ACCOUNT_COMBINATIONS
|
Account information
for internal Oracle users
|
|
RA_ACCOUNT_DEFAULTS_ALL
|
AutoAccounting
information
|
|
RA_ACCOUNT_DEFAULT_SEGMENTS
|
AutoAccounting segment
information
|
|
RA_ADDRESSES_ALL
|
Customer address
information
|
|
RA_AR_AMOUNTS_GT
|
|
|
RA_AR_GT
|
|
|
RA_BATCHES_ALL
|
Invoice batch
information
|
|
RA_BATCH_SOURCES_ALL
|
Sources of invoice,
credit memo and commitments
|
|
RA_CM_REQUESTS_ALL
|
Pending and approved
credit memo requests
|
|
RA_CM_REQUEST_LINES_ALL
|
Pending and approved
credit memo request lines
|
|
RA_CONTACTS
|
|
|
RA_CONTACT_PHONES_INT_ALL
|
Used by Customer
Interface to import contact and telephone information
|
|
RA_CONTACT_ROLES
|
Contact roles
|
|
RA_CUSTOMERS
|
Customer information
|
|
RA_CUSTOMERS_INTERFACE_ALL
|
Customer Interface
table
|
|
RA_CUSTOMER_BANKS_INT_ALL
|
Customer Interface
table for customer banks
|
|
RA_CUSTOMER_MERGES
|
Information about
customers, addresses, and site uses that are being merged or moved
|
|
RA_CUSTOMER_MERGE_HEADERS
|
This table is used to
store the high level information about an account merge request.
|
|
RA_CUSTOMER_PROFILES_INT_ALL
|
Customer Interface
table for customer profile information
|
|
RA_CUSTOMER_RELATIONSHIPS_ALL
|
Information about
customer relationships
|
|
RA_CUSTOMER_TRX_ALL
|
Header-level
information about invoices, debit memos, chargebacks, commitments and credit
memos
|
|
RA_CUSTOMER_TRX_LINES_ALL
|
Invoice, debit memo,
chargeback, credit memo and commitment lines
|
|
RA_CUST_PAY_METHOD_INT_ALL
|
Customer Interface
table for Payment Methods
|
|
RA_CUST_RECEIPT_METHODS
|
Payment Methods
assigned to a customer and/or customer site
|
|
RA_CUST_TRX_LINE_GL_DIST_ALL
|
Accounting records for
revenue, unearned revenue and unbilled receivables
|
|
RA_CUST_TRX_LINE_SALESREPS_ALL
|
Sales credit
assignments for transactions
|
|
RA_CUST_TRX_TYPES_ALL
|
Transaction type for
invoices, commitments and credit memos
|
|
RA_GROUPING_RULES
|
AutoInvoice grouping
rules
|
|
RA_GROUPING_TRX_TYPES
|
Transaction types associated
with AutoInvoice grouping rules
|
|
RA_GROUP_BYS
|
Columns to group by
for each grouping rule and transaction type
|
|
RA_GROUP_BY_COLUMNS
|
Table of columns to
group by for AutoInvoice grouping rules
|
|
RA_INTERFACE_DISTRIBUTIONS_ALL
|
Accounting
distributions for transactions imported using AutoInvoice
|
|
RA_INTERFACE_ERRORS_ALL
|
Interface data that
failed AutoInvoice validation
|
|
RA_INTERFACE_LINES_ALL
|
Information for each
invoice line imported using AutoInvoice
|
|
RA_INTERFACE_REQID_GT
|
|
|
RA_INTERFACE_SALESCREDITS_ALL
|
Sales credit
information for transactions imported using AutoInvoice
|
|
RA_ITEM_EXCEPTION_RATES
|
Product tax rate
exceptions
|
|
RA_LINE_ORDERING_RULES
|
AutoInvoice line
ordering rules
|
|
RA_LINE_ORDER_BYS
|
Columns to order by
for each AutoInvoice line ordering rule
|
|
RA_LINE_ORDER_BY_COLUMNS
|
Table of columns to
order by for AutoInvoice line ordering rules
|
|
RA_MC_BATCHES
|
Currency-related
information about invoice batches for each reporting set of books
|
|
RA_MC_CUSTOMER_TRX
|
Currency-related
information about invoice, debit memo, commitment, and credit memo header
information
|
|
RA_MC_CUSTOMER_TRX_LINES
|
Stores
currency-related information about transaction lines for each reporting set
of books that is associated with the parent record
|
|
RA_MC_TRX_LINE_GL_DIST
|
Currency and
accounting records for revenue, unearned revenue and unbilled receivables
|
|
RA_PHONES
|
Telephone and
communications information
|
|
RA_RECUR_INTERIM
|
Temporary table that
holds invoices to be copied
|
|
RA_REMIT_TOS_ALL
|
Links remit-to
addresses with state and country
|
|
RA_RULES
|
Invoicing and
accounting rules
|
|
RA_RULE_SCHEDULES
|
Accounting schedules
for invoices with rules
|
|
RA_SALESREPS_ALL
|
Information about
salespeople
|
|
RA_SALESREP_TERRITORIES
|
Territory information
for salespeople
|
|
RA_SITE_USES_ALL
|
Business purpose of a
customer address
|
|
RA_TAX_EXEMPTIONS_ALL
|
Percentage that a
customer, site, or item is exempt from a tax code
|
|
RA_TERMS_B
|
Payment Term
information
|
|
RA_TERMS_LINES
|
Line information for
Payment Terms
|
|
RA_TERMS_LINES_DISCOUNTS
|
Discount information
for Payment Terms
|
|
RA_TERMS_TL
|
Multi-lingual support
(MLS) for Payment Terms
|
|
RA_TERRITORIES
|
Territory information
|