EXTERNAL_ACCOUNT

Table: EXTERNAL_ACCOUNT

Table Name

EXTERNAL_ACCOUNT

Table Description

The EXTERNAL_ACCOUNT table represents an external account or a postpaid account link in a subscriber account.

Tablespace

SUBSCRIBER_DATA

Database

Partitioned

Yes

Columns

The EXTERNAL_ACCOUNT database table is defined by the following columns.

Value Type	BIGINT, NOT NULL
Key(s)	-	Foreign K.: Foreign table: SUBSCRIBER_ACCOUNT Foreign field(s): OID
Index(es)	IX_EXAC_SUAC IX_EXAC_SUAC_G (unique) (oracle)
Column Description	The identifier of the subscriber account containing the account.

Value Type	VARCHAR(2000)
Column Description	The description of the account.

Value Type	VARCHAR(5)
Column Description	The currency code of the account.

Value Type	VARCHAR(256)
Column Description	The external system that handles the account.

Value Type	VARCHAR(256)
Column Description	The code of the external account in the external billing system.

Value Type	DECIMAL(1), NOT NULL
Column Description	The type of account. Possible values are: -1: undefined 0: payable 1: receivable

Value Type	DECIMAL(1), NOT NULL
Column Description	The IS_DEFAULT field indicates if the account is the default account for the subscriber account. Possible values are: 0: no 1: yes

Value Type

DECIMAL(1), NOT NULL

Column Description

The IS_DEFAULT field indicates if the account is the default account for the subscriber account.

Possible values are:

Value Type	DATE
Column Description	The date until which this account is valid. If this field NULL, this is the current version of the account. Note that this value is used for rerating.

Value Type	SMALLINT, NOT NULL
Column Description	The partition of the subscriber account.

Document Version: SP04 and later