eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: AR.HZ_CUST_ACCOUNTS

Object Details

Object Name:	HZ_CUST_ACCOUNTS
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.HZ_CUST_ACCOUNTS
Subobject Name:
Status:	VALID

The HZ_CUST_ACCOUNTS table stores information about customer accounts , or business relationships that the deploying company establishes with a party of type Organization or Person. This table focuses on business relationships and how transactions are conducted in the relationship.
Since a party can have multiple customer accounts, this table might contain several records for a single party. For example, an individual person can establish a personal account, family account, and a professional account for a consulting practice.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: HZ_CUST_ACCOUNTS_PK

CUST_ACCOUNT_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
HZ_CUST_ACCOUNTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CUST_ACCOUNT_ID
HZ_CUST_ACCOUNTS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACCOUNT_NUMBER
HZ_CUST_ACCOUNTS_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORIG_SYSTEM_REFERENCE
HZ_CUST_ACCOUNTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARTY_ID
HZ_CUST_ACCOUNTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACCOUNT_NAME
HZ_CUST_ACCOUNTS_N4	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UPPER("ACCOUNT_NAME")
HZ_CUST_ACCOUNTS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SELLING_PARTY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CUST_ACCOUNT_ID	NUMBER	(15)	Yes	Customer account identifier
PARTY_ID	NUMBER	(15)	Yes	A foreign key to the HZ_PARTY table.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
ACCOUNT_NUMBER	VARCHAR2	(30)	Yes	Account Number
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	Unique customer identifier from foreign or legacy system
STATUS	VARCHAR2	(1)	Yes	Customer status flag. Lookup code for CODE_STATUS
CUSTOMER_TYPE	VARCHAR2	(30)		Receivables lookup code for the CUSTOMER_TYPE attribute. I for internal customers, R for revenue generating external customers.
CUSTOMER_CLASS_CODE	VARCHAR2	(30)		Customer class indentifier
PRIMARY_SALESREP_ID	NUMBER	(15)		No longer used
SALES_CHANNEL_CODE	VARCHAR2	(30)		Order Management lookup code for the SALES_CHANNEL attribute.
ORDER_TYPE_ID	NUMBER	(15)		No longer used
PRICE_LIST_ID	NUMBER	(15)		Price list identifier
SUBCATEGORY_CODE	VARCHAR2	(30)		No longer used
TAX_CODE	VARCHAR2	(50)		Tax Code for the Customer
FOB_POINT	VARCHAR2	(30)		The point in a shipment at which title to the goods is transferred. Examples include, FOB delivered (the title changes hands at the point of delivery).
FREIGHT_TERM	VARCHAR2	(30)		Order Management lookup code for the FREIGHT_TERMS attribute.
SHIP_PARTIAL	VARCHAR2	(1)		No longer used
SHIP_VIA	VARCHAR2	(30)		The name of the preferred ship method.
WAREHOUSE_ID	NUMBER	(15)		Warehouse identifier
PAYMENT_TERM_ID	NUMBER	(15)		No longer used
TAX_HEADER_LEVEL_FLAG	VARCHAR2	(1)		Indicate if item is tax header or a line item. Y for records that are headers for tax purposes, N for records that are lines.
TAX_ROUNDING_RULE	VARCHAR2	(30)		Tax amount rounding rule
COTERMINATE_DAY_MONTH	VARCHAR2	(6)		Identifies the date when services ordered by the customer will end. Values for this column will take the form DD-MON.
PRIMARY_SPECIALIST_ID	NUMBER	(15)		This column is for the service personnel dispatching feature in Incident Tracking and is a foreign key to the PER_PEOPLE table
SECONDARY_SPECIALIST_ID	NUMBER	(15)		This column is for the service personnel dispatching feature in Incident Tracking and is a foreign key to the PER_PEOPLE table
ACCOUNT_LIABLE_FLAG	VARCHAR2	(1)		No longer used
RESTRICTION_LIMIT_AMOUNT	NUMBER			No longer used
CURRENT_BALANCE	NUMBER			No longer used
PASSWORD_TEXT	VARCHAR2	(60)		No longer used
HIGH_PRIORITY_INDICATOR	VARCHAR2	(1)		No longer used
ACCOUNT_ESTABLISHED_DATE	DATE			Date when the customer account was originally established through either an Oracle Application or a legacy system
ACCOUNT_TERMINATION_DATE	DATE			No longer used
ACCOUNT_ACTIVATION_DATE	DATE			No longer used
CREDIT_CLASSIFICATION_CODE	VARCHAR2	(30)		No longer used
DEPARTMENT	VARCHAR2	(30)		No longer used
MAJOR_ACCOUNT_NUMBER	VARCHAR2	(30)		No longer used
HOTWATCH_SERVICE_FLAG	VARCHAR2	(1)		No longer used
HOTWATCH_SVC_BAL_IND	VARCHAR2	(30)		No longer used
HELD_BILL_EXPIRATION_DATE	DATE			Held bill expiration date
HOLD_BILL_FLAG	VARCHAR2	(1)		Indicates if the bill receivable should be held or not. Y for holding the bill, N for bills receivable should not be held.
HIGH_PRIORITY_REMARKS	VARCHAR2	(80)		No longer used
PO_EFFECTIVE_DATE	DATE			No longer used
PO_EXPIRATION_DATE	DATE			No longer used
REALTIME_RATE_FLAG	VARCHAR2	(1)		No longer used
SINGLE_USER_FLAG	VARCHAR2	(1)		No longer used
WATCH_ACCOUNT_FLAG	VARCHAR2	(1)		No longer used
WATCH_BALANCE_INDICATOR	VARCHAR2	(1)		No longer used
GEO_CODE	VARCHAR2	(30)		No longer used
ACCT_LIFE_CYCLE_STATUS	VARCHAR2	(30)		No longer used
ACCOUNT_NAME	VARCHAR2	(240)		Description chosen by external party (but can be entered internally on behalf on the customer)
DEPOSIT_REFUND_METHOD	VARCHAR2	(20)		Refund Method
DORMANT_ACCOUNT_FLAG	VARCHAR2	(1)		No longer used
NPA_NUMBER	VARCHAR2	(60)		Identifies an account with a Number Plan Area (NPA) used in telecommunications.
PIN_NUMBER	NUMBER	(16)		No longer used
SUSPENSION_DATE	DATE			No longer used
WRITE_OFF_ADJUSTMENT_AMOUNT	NUMBER			No longer used
WRITE_OFF_PAYMENT_AMOUNT	NUMBER			No longer used
WRITE_OFF_AMOUNT	NUMBER			No longer used
SOURCE_CODE	VARCHAR2	(150)		Promotion that was used to make the party a customer
COMPETITOR_TYPE	VARCHAR2	(150)		No longer used
COMMENTS	VARCHAR2	(240)		Free format information about the customer
DATES_NEGATIVE_TOLERANCE	NUMBER			Maximum number of days prior to a date
DATES_POSITIVE_TOLERANCE	NUMBER			Maximum number of days after a date
DATE_TYPE_PREFERENCE	VARCHAR2	(20)		Preference for ship or arrival dates
OVER_SHIPMENT_TOLERANCE	NUMBER			Percentage tolerance for over shipment
UNDER_SHIPMENT_TOLERANCE	NUMBER			Percentage tolerance for under shipment
OVER_RETURN_TOLERANCE	NUMBER			Percentage tolerance for over return
UNDER_RETURN_TOLERANCE	NUMBER			Percentage tolerance for under return
ITEM_CROSS_REF_PREF	VARCHAR2	(30)		Lookup for item cross reference preference for placing orders
SHIP_SETS_INCLUDE_LINES_FLAG	VARCHAR2	(1)		Indicates if lines should automatically be included in ship sets. Y for lines included in ship sets, N for lines not included in ship sets.
ARRIVALSETS_INCLUDE_LINES_FLAG	VARCHAR2	(1)		Indicates if lines include arrival sets. Y for lines included on arrival sets, N for lines not automatically included in arrival sets
SCHED_DATE_PUSH_FLAG	VARCHAR2	(1)		Indicates if the group schedule date should automatically be pushed. Y for pushing the schedule dates, N for not pushing the schedule date.
INVOICE_QUANTITY_RULE	VARCHAR2	(30)		Rule to indicate whether to invoice for ordered quantity or fulfilled quantity
PRICING_EVENT	VARCHAR2	(30)		No longer used
ACCOUNT_REPLICATION_KEY	NUMBER	(15)		No longer used
STATUS_UPDATE_DATE	DATE			Last status update date
AUTOPAY_FLAG	VARCHAR2	(1)		Autopay flag
NOTIFY_FLAG	VARCHAR2	(1)		No longer used
LAST_BATCH_ID	NUMBER			Last active batch
ORG_ID	NUMBER	(15)
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
SELLING_PARTY_ID	NUMBER	(15)		Identifier of the party entering a business relationship as a seller. A selling party can be an individual or an organization. The Selling Party represents the external facing organization with which the customer is doing business, and is not necessarily a Legal Entity or Operating Unit. Its usage within the ebusiness suite will be phased: Phase 1:Products can join to HZ_PARTIES using the SELLING_PARTY_ID to retrieve the PARTY_NAME for use in a UI. eg a call center application may run on behalf of several internal organizations - displaying the selling party will allow the user to see context for the customer Phase 2:Products can use SELLING_PARTY_ID as a filtering mechanism. eg a profile controls the selling_party_id that a user has access to. The UI would then show accounts matching this party.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CUST_ACCOUNT_ID
,      PARTY_ID
,      LAST_UPDATE_DATE
,      ACCOUNT_NUMBER
,      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
,      CUSTOMER_TYPE
,      CUSTOMER_CLASS_CODE
,      PRIMARY_SALESREP_ID
,      SALES_CHANNEL_CODE
,      ORDER_TYPE_ID
,      PRICE_LIST_ID
,      SUBCATEGORY_CODE
,      TAX_CODE
,      FOB_POINT
,      FREIGHT_TERM
,      SHIP_PARTIAL
,      SHIP_VIA
,      WAREHOUSE_ID
,      PAYMENT_TERM_ID
,      TAX_HEADER_LEVEL_FLAG
,      TAX_ROUNDING_RULE
,      COTERMINATE_DAY_MONTH
,      PRIMARY_SPECIALIST_ID
,      SECONDARY_SPECIALIST_ID
,      ACCOUNT_LIABLE_FLAG
,      RESTRICTION_LIMIT_AMOUNT
,      CURRENT_BALANCE
,      PASSWORD_TEXT
,      HIGH_PRIORITY_INDICATOR
,      ACCOUNT_ESTABLISHED_DATE
,      ACCOUNT_TERMINATION_DATE
,      ACCOUNT_ACTIVATION_DATE
,      CREDIT_CLASSIFICATION_CODE
,      DEPARTMENT
,      MAJOR_ACCOUNT_NUMBER
,      HOTWATCH_SERVICE_FLAG
,      HOTWATCH_SVC_BAL_IND
,      HELD_BILL_EXPIRATION_DATE
,      HOLD_BILL_FLAG
,      HIGH_PRIORITY_REMARKS
,      PO_EFFECTIVE_DATE
,      PO_EXPIRATION_DATE
,      REALTIME_RATE_FLAG
,      SINGLE_USER_FLAG
,      WATCH_ACCOUNT_FLAG
,      WATCH_BALANCE_INDICATOR
,      GEO_CODE
,      ACCT_LIFE_CYCLE_STATUS
,      ACCOUNT_NAME
,      DEPOSIT_REFUND_METHOD
,      DORMANT_ACCOUNT_FLAG
,      NPA_NUMBER
,      PIN_NUMBER
,      SUSPENSION_DATE
,      WRITE_OFF_ADJUSTMENT_AMOUNT
,      WRITE_OFF_PAYMENT_AMOUNT
,      WRITE_OFF_AMOUNT
,      SOURCE_CODE
,      COMPETITOR_TYPE
,      COMMENTS
,      DATES_NEGATIVE_TOLERANCE
,      DATES_POSITIVE_TOLERANCE
,      DATE_TYPE_PREFERENCE
,      OVER_SHIPMENT_TOLERANCE
,      UNDER_SHIPMENT_TOLERANCE
,      OVER_RETURN_TOLERANCE
,      UNDER_RETURN_TOLERANCE
,      ITEM_CROSS_REF_PREF
,      SHIP_SETS_INCLUDE_LINES_FLAG
,      ARRIVALSETS_INCLUDE_LINES_FLAG
,      SCHED_DATE_PUSH_FLAG
,      INVOICE_QUANTITY_RULE
,      PRICING_EVENT
,      ACCOUNT_REPLICATION_KEY
,      STATUS_UPDATE_DATE
,      AUTOPAY_FLAG
,      NOTIFY_FLAG
,      LAST_BATCH_ID
,      ORG_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY_MODULE
,      APPLICATION_ID
,      SELLING_PARTY_ID
FROM AR.HZ_CUST_ACCOUNTS;

Dependencies

[top of page]

AR.HZ_CUST_ACCOUNTS does not reference any database object

AR.HZ_CUST_ACCOUNTS is referenced by following:

APPS: HZ_CUST_ACCOUNTS; JAI_AR_RC_ARIUD_T1; OZF_CUST_FUND_SUMMARY_MV