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

HZ_CUST_ACCT_SITES_ALL_

The HZ_CUST_ACCT_SITES_ALL table stores all customer account sites across all operating units. Customer account sites are customer account addresses with which the deploying company does business. One customer account can have multiple customer account sites, and customer account sites for one customer account can belong to multiple operating units.

Details

  • Schema: FUSION

  • Object owner: HZ

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

HZ_CUST_ACCT_SITES_PK_

LAST_UPDATE_DATE, LAST_UPDATED_BY, CUST_ACCT_SITE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
CUST_ACCT_SITE_ID NUMBER 18 Yes Customer site identifier.
CUST_ACCOUNT_ID NUMBER 18 Identifier for a customer account. Foreign key to the HZ_CUST_ACCOUNTS table Active
PARTY_SITE_ID NUMBER 18 Identifier for a party site. Foreign key to the HZ_PARTY_SITES table
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ORIG_SYSTEM_REFERENCE VARCHAR2 240 Address identifier from foreign system
STATUS VARCHAR2 1 Customer Status flag. Receivables lookup code for CODE_STATUS Active
SET_ID NUMBER 18 Identifies a set of reference data shared across business units and other entities. Also known as Reference Data Sets, they are used to filter reference data in transactional UIs. Active
BILL_TO_FLAG VARCHAR2 1 Indicates if this is a Bill-To site. Y for a Bill-To site, P for the primary Bill-To site, and N for a site that is not a Bill-To site. Active
MARKET_FLAG VARCHAR2 1 Indicates if this is a Marketing site. Y for a Marketing site, P for the primary Marketing site, and N for a site that is not a Marketing site. Active
SHIP_TO_FLAG VARCHAR2 1 Indicates if this is a Ship-To site. Y for a Ship-To site, P for the primary Ship-To site, and N for a site that is not a Ship-To site. Active
CUSTOMER_CATEGORY_CODE VARCHAR2 30 User-definable category. The lookup type is ADDRESS_CATEGORY. Active
KEY_ACCOUNT_FLAG VARCHAR2 1 Key account for sales representatives Active
TP_HEADER_ID NUMBER Trading partner header identifier Active
ECE_TP_LOCATION_CODE VARCHAR2 40 Stores the EDI location code. It should be unique for a customer. The column accepts free-form text. Active
TRANSLATED_CUSTOMER_NAME VARCHAR2 360 Customer name in the language used at the account site. Active
OBJECT_VERSION_NUMBER NUMBER 9 Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATED_BY_MODULE VARCHAR2 30 TCA Who column Active
CONFLICT_ID NUMBER 18 Disconnected Mobile: this value is used to guarantee the uniqueness of the row when duplicates are created in different databases (i.e. mobile databases or the server). Active
USER_LAST_UPDATE_DATE TIMESTAMP Disconnected Mobile: indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database (i.e. a different mobile database or the server). Active
ATTRIBUTE21 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE22 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE23 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE24 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE25 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE26 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE27 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE28 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE29 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE30 VARCHAR2 255 Descriptive Flexfield: segment of the user descriptive flexfield. Active
START_DATE DATE Start date from which this site is valid for use. Active
END_DATE DATE Date from which this site is no longer valid. Active
CPDRF_VER_SOR NUMBER 9 Cross Pillar Data Replication Framework (CPDRF) system column for tracking record version in System of Record (SOR) pillar when a record change is replicated to subscribing pillars by the replication flows.
CPDRF_VER_PILLAR NUMBER 9 Cross Pillar Data Replication Framework (CPDRF) system column for tracking record version when a record is changed by replication flows
CPDRF_LAST_UPD VARCHAR2 15 Cross Pillar Data Replication Framework (CPDRF) system column for tracking source pillar name when a record is changed by the replication flows.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER11 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER12 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE6 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE7 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE8 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE9 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE10 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE11 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE12 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ACCT_SITE_LANGUAGE VARCHAR2 4 Operating Language for Acct Sites
AUDIT_ACTION_TYPE_ VARCHAR2 10 Action Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_ VARCHAR2 1000 Used to store a bit map of 1s and 0s for each column in the table.
AUDIT_IMPERSONATOR_ VARCHAR2 64 Original Impersonator User.
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 30 Global Descriptive Flexfield: structure definition of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE1 VARCHAR2 240 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE2 VARCHAR2 240 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE3 VARCHAR2 240 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE4 VARCHAR2 240 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE5 VARCHAR2 240 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE6 VARCHAR2 240 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE7 VARCHAR2 240 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE8 VARCHAR2 240 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE9 VARCHAR2 240 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE10 VARCHAR2 240 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE11 VARCHAR2 240 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE12 VARCHAR2 240 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE13 VARCHAR2 240 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE14 VARCHAR2 240 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE15 VARCHAR2 240 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE16 VARCHAR2 240 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE17 VARCHAR2 240 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE18 VARCHAR2 240 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE19 VARCHAR2 240 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE20 VARCHAR2 240 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE21 VARCHAR2 240 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE22 VARCHAR2 240 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE23 VARCHAR2 240 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE24 VARCHAR2 240 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE25 VARCHAR2 240 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE26 VARCHAR2 240 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE27 VARCHAR2 240 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE28 VARCHAR2 240 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE29 VARCHAR2 240 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE30 VARCHAR2 240 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_NUMBER1 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER2 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER3 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER4 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER5 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE1 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE2 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE3 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE4 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE5 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.

Indexes

Index Uniqueness Tablespace Columns
HZ_CUST_ACCT_SITES_ALLN1_ Non Unique Default CUST_ACCT_SITE_ID
HZ_CUST_ACCT_SITES_ALL_U1_ Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, SET_ID, CUST_ACCT_SITE_ID, CONFLICT_ID
HZ_CUST_ACCT_SITES_PK_ Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, CUST_ACCT_SITE_ID
HZ_CUST_ACCT_SITES_U1_ Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, SET_ID, ORIG_SYSTEM_REFERENCE, CONFLICT_ID