[Home] [Help] [Dependency Information]
Object Name: | CSC_HZ_PARTY_ACCOUNTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CSC.CSC_HZ_PARTY_ACCOUNTS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
CSC_PARTY_ACCOUNTS_V stores information about customes. If a party becomes a customer, information about the customer account and the account role is stored in this view. You can establish multiple customer relationships with a single party, so each party can have multiple customer account records. Each account can have multiple roles defined against it.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row identifier | |
PARTY_ID | NUMBER | (15) | Yes | Identifier of the party who is associated with this account. Foreign Key to HZ_PARTIES |
PARTY_NUMBER | VARCHAR2 | (30) | Yes | Party number of the party associated with this account. |
PARTY_NAME | VARCHAR2 | (360) | Yes | Name of the party associated with this account. |
PARTY_TYPE | VARCHAR2 | (30) | Yes | Party type of the party who is assocaited with this account. Organization or Person or Group or Party Relationship. |
PRIMARY_FLAG | VARCHAR2 | (1) | Indicates if this party occupies the primary role for this account. Y for a party in the primary role for this account, N for all other parties. | |
ROLE | VARCHAR2 | (30) | Role played by the party in the customer account. | |
CUST_ACCOUNT_ID | NUMBER | (15) | Yes | Customer Account Identifier. |
ACCOUNT_NUMBER | VARCHAR2 | (30) | Yes | Account Number |
ACCOUNT_NAME | VARCHAR2 | (240) | Description chosen by external party (but can be entered internally on behalf on the customer) | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
COUNTRY | VARCHAR2 | (60) | The country listed in the TERRITORY_CODE column of the FND_TERRITORY table for the Identifying address of the Party associated with the account. | |
STATUS | VARCHAR2 | (1) | Yes | Customer status flag. Lookup code for CODE_STATUS |
ACCOUNT_TERMINATION_DATE | DATE | Date when the account was terminated | ||
ACCOUNT_ACTIVATION_DATE | DATE | Date when account was activated |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, PARTY_ID
, PARTY_NUMBER
, PARTY_NAME
, PARTY_TYPE
, PRIMARY_FLAG
, ROLE
, CUST_ACCOUNT_ID
, ACCOUNT_NUMBER
, ACCOUNT_NAME
, LAST_UPDATE_DATE
, COUNTRY
, STATUS
, ACCOUNT_TERMINATION_DATE
, ACCOUNT_ACTIVATION_DATE
FROM APPS.CSC_HZ_PARTY_ACCOUNTS_V;
APPS.CSC_HZ_PARTY_ACCOUNTS_V is not referenced by any database object
|
|
|