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: TableAR.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: HZ_CUST_ACCOUNTS_PK
  1. ColumnCUST_ACCOUNT_ID
Indexes
Index Type Uniqueness Tablespace Column
HZ_CUST_ACCOUNTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUST_ACCOUNT_ID
HZ_CUST_ACCOUNTS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnACCOUNT_NUMBER
HZ_CUST_ACCOUNTS_U3 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORIG_SYSTEM_REFERENCE
HZ_CUST_ACCOUNTS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTY_ID
HZ_CUST_ACCOUNTS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnACCOUNT_NAME
HZ_CUST_ACCOUNTS_N4 FUNCTION-BASED NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnUPPER("ACCOUNT_NAME")
HZ_CUST_ACCOUNTS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSELLING_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.
FEDERAL_ENTITY_TYPE VARCHAR2 (30)
This column identifies the type of entity involved in transactions with the reporting entity: Federal entities or non-Federal entities such as private/local/state/tribal/foreign governments or exceptionsfor other non-Federal partners. This column stores the code from FV_LOOKUP_CODES which is associated with lookup type FV_FED_NON_FED_CODE.
TRADING_PARTNER_AGENCY_ID VARCHAR2 (3)
This column stores the identifier for the other Federal agency involved in transactions with the reporting entity. It is used in conjunction with a Federal Entity type of "Federal". This column is foreign key to FV_TP_TREASURY_SYMBOLS.AGENCY_ID.
DUNS_EXTENSION VARCHAR2 (4)
A four character extension to DUNS number, used to identify registrants and is limited to different CCR (Central Contractor Registration) records for the same registrant at the same physical location. For example, a registrant could have two records for themselves at the same physical location to identify two separate bank accounts.
ADVANCE_PAYMENT_INDICATOR VARCHAR2 (30)
This is the indicator for Advance payment. This column stores the code from FV_LOOKUP_CODES which are associated with lookup type FV_ADV_PMT_INDICATOR.
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
,      FEDERAL_ENTITY_TYPE
,      TRADING_PARTNER_AGENCY_ID
,      DUNS_EXTENSION
,      ADVANCE_PAYMENT_INDICATOR
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:

SchemaAPPS
Materialized ViewOZF_CUST_FUND_SUMMARY_MV
SchemaAR
ViewHZ_CUST_ACCOUNTS#