Operational Data Store Schema Reference

Back Next

DX_ODS_ACCOUNT Table

The DX_ODS_ACCOUNT table contains information about accounts and the related partners in

B2B Data Exchange

The following table describes the columns and data types of the DX_ODS_ACCOUNT table in the Oracle server:

Column Name	data type	Description
PARTNER_ID	NUMBERPS(19,0), NOT NULL	Unique identifier for the related partner.
ACCOUNT_ID*	NUMBERPS(19,0), NOT NULL	Unique identifier for the related account.
ACCOUNT_NAME	VARCHAR2(255), NOT NULL	Name of the account.
ACCOUNT_NUMBER	VARCHAR2(255) NOT NULL	Number for the account.
* Primary key. Used in the DX_ODS_EVENT_FACTS table as a foreign key.

The following table describes the columns and data types of the DX_ODS_ACCOUNT table in the SQL server:

Column Name	data type	Description
PARTNER_ID	NUMBERIC(19,0), NOT NULL	Unique identifier for the related partner.
ACCOUNT_ID*	NUMBERIC(19,0), NOT NULL	Unique identifier for the related account.
ACCOUNT_NAME	VARCHAR(255), NOT NULL	Name of the account.
ACCOUNT_NUMBER	VARCHAR(255) NOT NULL	Number for the account.
* Primary key. Used in the DX_ODS_EVENT_FACTS table as a foreign key.