[Home] [Help] [Dependency Information]
Object Name: | HZ_CUST_ACCT_SITES_ALL |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.HZ_CUST_ACCT_SITES_ALL |
Subobject Name: | |
Status: | VALID |
The HZ_CUST_ACCT_SITES_ALL table stores all customer account sites across all operating units. Customer account sites are addresses, for customer accounts, where the deploying company does business with its customers. One customer account can have multiple customer account sites, and customer account sites for one customer account can belong to multiple operating units.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HZ_CUST_ACCT_SITES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CUST_ACCT_SITE_ID |
HZ_CUST_ACCT_SITES_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ORIG_SYSTEM_REFERENCE
ORG_ID |
HZ_CUST_ACCT_SITES_U3 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TP_HEADER_ID |
SYS_IL0000028661C00071$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
HZ_CUST_ACCT_SITES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PARTY_SITE_ID |
HZ_CUST_ACCT_SITES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CUST_ACCOUNT_ID
STATUS BILL_TO_FLAG |
HZ_CUST_ACCT_SITES_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CUST_ACCOUNT_ID
STATUS SHIP_TO_FLAG |
HZ_CUST_ACCT_SITES_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ECE_TP_LOCATION_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUST_ACCT_SITE_ID | NUMBER | (15) | Yes | Customer site identifier |
CUST_ACCOUNT_ID | NUMBER | (15) | Yes | Identifier for a customer account. Foreign key to the HZ_CUST_ACCOUNTS table |
PARTY_SITE_ID | NUMBER | (15) | Yes | Identifier for a party site. Foreign key to the HZ_PARTY_SITES table |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |
PROGRAM_ID | NUMBER | (15) | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
WH_UPDATE_DATE | DATE | No longer used | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
ORIG_SYSTEM_REFERENCE | VARCHAR2 | (240) | Yes | Address identifier from foreign system |
STATUS | VARCHAR2 | (1) | Yes | Customer Status flag. Receivables lookup code for CODE_STATUS |
ORG_ID | NUMBER | (15) | Organization identifier | |
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. | |
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. | |
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. | |
CUSTOMER_CATEGORY_CODE | VARCHAR2 | (30) | User-definable category. The lookup type is ADDRESS_CATEGORY. | |
LANGUAGE | VARCHAR2 | (4) | No Longer Used. | |
KEY_ACCOUNT_FLAG | VARCHAR2 | (1) | Key account for sales representatives | |
TP_HEADER_ID | NUMBER | Trading partner header identifier | ||
ECE_TP_LOCATION_CODE | VARCHAR2 | (40) | Stores the EDI location code. It should be unique for a customer. The column accepts free-form text. | |
SERVICE_TERRITORY_ID | NUMBER | (15) | No longer used | |
PRIMARY_SPECIALIST_ID | NUMBER | (15) | Used for the service personnel dispatching feature in Incident Tracking. Foreign key to the PER_PEOPLE table | |
SECONDARY_SPECIALIST_ID | NUMBER | (15) | Used for the service personnel dispatching feature in Incident Tracking. Foreign key to the PER_PEOPLE table. | |
TERRITORY_ID | NUMBER | (15) | Identifier for the territory | |
ADDRESS_TEXT | CLOB | (4000) | Address text used for context search | |
TERRITORY | VARCHAR2 | (30) | Not Currently Used. The Territory column should be used to store a NLS Territory as defined in Oracle database. It will be used for future mulitple language support enhancements. | |
TRANSLATED_CUSTOMER_NAME | VARCHAR2 | (50) | Translated customer name | |
OBJECT_VERSION_NUMBER | NUMBER | This column is used for locking purposes | ||
CREATED_BY_MODULE | VARCHAR2 | (150) | TCA Who column | |
APPLICATION_ID | NUMBER | TCA Who column |
Cut, paste (and edit) the following text to query this object:
SELECT CUST_ACCT_SITE_ID
, CUST_ACCOUNT_ID
, PARTY_SITE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, WH_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, ORIG_SYSTEM_REFERENCE
, STATUS
, ORG_ID
, BILL_TO_FLAG
, MARKET_FLAG
, SHIP_TO_FLAG
, CUSTOMER_CATEGORY_CODE
, LANGUAGE
, KEY_ACCOUNT_FLAG
, TP_HEADER_ID
, ECE_TP_LOCATION_CODE
, SERVICE_TERRITORY_ID
, PRIMARY_SPECIALIST_ID
, SECONDARY_SPECIALIST_ID
, TERRITORY_ID
, ADDRESS_TEXT
, TERRITORY
, TRANSLATED_CUSTOMER_NAME
, OBJECT_VERSION_NUMBER
, CREATED_BY_MODULE
, APPLICATION_ID
FROM AR.HZ_CUST_ACCT_SITES_ALL;
AR.HZ_CUST_ACCT_SITES_ALL does not reference any database object
AR.HZ_CUST_ACCT_SITES_ALL is referenced by following:
|
|
|