[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | HZ_CUST_ACCOUNTS_M |
|---|---|
| Object Type: | TABLE |
| Owner: | AR |
| FND Design Data: |  AR.HZ_CUST_ACCOUNTS_M
|
| Subobject Name: | |
| Status: | VALID |
The HZ_CUST_ACCOUNTS_M table stores information, from the HZ_CUST_ACCOUNTS
table, about a customer account before an account merge occurs. The primary key for this table is CUST_ACCOUNT_ID.
| Tablespace: |  APPS_TS_ARCHIVE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| HZ_CUST_ACCOUNTS_M_U1 | NORMAL | UNIQUE |
APPS_TS_ARCHIVE
|
 CUST_ACCOUNT_ID
CUSTOMER_MERGE_HEADER_ID
MERGE_REQUEST_ID
|
| 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). | ||
| 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) | Primary sales rep identifier | |
| SALES_CHANNEL_CODE | VARCHAR2 | (30) | Order Management lookup code for the SALES_CHANNEL attribute. | |
| ORDER_TYPE_ID | NUMBER | (15) | Order type identifier | |
| PRICE_LIST_ID | NUMBER | (15) | Price list identifier | |
| TAX_CODE | VARCHAR2 | (50) | Tax code for this 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) | Indicates if this customer accepts partial shipments. Y for customer accepts partial shipments, N for customer will not accept partial shipments. | |
| SHIP_VIA | VARCHAR2 | (30) | The name of the preferred ship method. | |
| WAREHOUSE_ID | NUMBER | (15) | Warehouse identifier | |
| 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) | Indicates if the account is liable for other customer accounts. Y for customers accounts that are responsible for the liabiliities of other customer accounts, N for an account that is not liable for other accounts. | |
| CURRENT_BALANCE | NUMBER | Total balance on the account | ||
| ACCOUNT_ESTABLISHED_DATE | DATE | Date when the account was established | ||
| ACCOUNT_TERMINATION_DATE | DATE | Date when the account was terminated | ||
| ACCOUNT_ACTIVATION_DATE | DATE | Date when account was activated | ||
| DEPARTMENT | VARCHAR2 | (30) | Customer department responsible for this account | |
| 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. | |
| REALTIME_RATE_FLAG | VARCHAR2 | (1) | Real time rate flag | |
| ACCT_LIFE_CYCLE_STATUS | VARCHAR2 | (30) | A state of the account from the point of view of the orginator of the account. | |
| 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) | Indicates if the account is considered to be dormant. Y for accounts that are considered dormant, N for active accounts. | |
| NPA_NUMBER | VARCHAR2 | (60) | Identifies an account with a Number Plan Area (NPA) used in telecommunications. | |
| SUSPENSION_DATE | DATE | Date when the account was suspended | ||
| SOURCE_CODE | VARCHAR2 | (150) | Promotion that was used to make the party a customer | |
| COMPETITOR_TYPE | VARCHAR2 | (150) | A short term that identifies the type of competitor | |
| 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) | Event at which to price orders. For example, at entry, at shipping, or at invoicing. | |
| STATUS_UPDATE_DATE | DATE | Last status update date | ||
| AUTOPAY_FLAG | VARCHAR2 | (1) | Autopay flag | |
| NOTIFY_FLAG | VARCHAR2 | (1) | Notify flag | |
| LAST_BATCH_ID | NUMBER | Last active batch | ||
| ORG_ID | NUMBER | (15) | Organization identifier | |
| 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. | |
| CUSTOMER_MERGE_HEADER_ID | NUMBER | (15) | Yes | Customer merge header record identifier |
| MERGE_REQUEST_ID | NUMBER | (15) | Yes | Request identifier of the concurrent program for this record |
| FEDERAL_ENTITY_TYPE | VARCHAR2 | (30) | Identifies the type of entity involved in transactions with the reporting entity: other Federal entities or non-Federal entities such as private/local/state/tribal/foreign governments or exceptions for other non-Federal partners. 'Code' is being stored. | |
| TRADING_PARTNER_AGENCY_ID | VARCHAR2 | (3) | The ID which Identifies the other Federal agency involved in transactions with the reporting entity. Is used in conjunction with a Federal Entity type of 'Federal' . | |
| DUNS_EXTENSION | VARCHAR2 | (4) | A 4 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 to identify two separate bank accounts. | |
| ADVANCE_PAYMENT_INDICATOR | VARCHAR2 | (30) | This is the indicator for Advance payment. |
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
, 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
, TAX_CODE
, FOB_POINT
, FREIGHT_TERM
, SHIP_PARTIAL
, SHIP_VIA
, WAREHOUSE_ID
, TAX_HEADER_LEVEL_FLAG
, TAX_ROUNDING_RULE
, COTERMINATE_DAY_MONTH
, PRIMARY_SPECIALIST_ID
, SECONDARY_SPECIALIST_ID
, ACCOUNT_LIABLE_FLAG
, CURRENT_BALANCE
, ACCOUNT_ESTABLISHED_DATE
, ACCOUNT_TERMINATION_DATE
, ACCOUNT_ACTIVATION_DATE
, DEPARTMENT
, HELD_BILL_EXPIRATION_DATE
, HOLD_BILL_FLAG
, REALTIME_RATE_FLAG
, ACCT_LIFE_CYCLE_STATUS
, ACCOUNT_NAME
, DEPOSIT_REFUND_METHOD
, DORMANT_ACCOUNT_FLAG
, NPA_NUMBER
, SUSPENSION_DATE
, 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
, STATUS_UPDATE_DATE
, AUTOPAY_FLAG
, NOTIFY_FLAG
, LAST_BATCH_ID
, ORG_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY_MODULE
, APPLICATION_ID
, SELLING_PARTY_ID
, CUSTOMER_MERGE_HEADER_ID
, MERGE_REQUEST_ID
, FEDERAL_ENTITY_TYPE
, TRADING_PARTNER_AGENCY_ID
, DUNS_EXTENSION
, ADVANCE_PAYMENT_INDICATOR
FROM AR.HZ_CUST_ACCOUNTS_M;
AR.HZ_CUST_ACCOUNTS_M does not reference any database object
AR.HZ_CUST_ACCOUNTS_M is referenced by following:
AR
HZ_CUST_ACCOUNTS_M#
|
|
|
|