EXTERNAL_ACCOUNT
External Postpaid Accounts (in Customer Master Data)
Description
The EXTERNAL_ACCOUNT table stores all the external (postpaid) accounts
defined in a subscriber account.
An external account is a reference to a postpaid account managed
in a third-party billing or accounting system.
Technical Data
| Schema Version |
4.5.13 |
| Segment |
SUBSCRIBER_DATA |
| Partitioned |
Yes, when you use the partitioning scheme and corresponding SQL scripts |
Summary
The EXTERNAL_ACCOUNT table is defined by the
following columns.
See the column details for more information.
Column Details
SUAC_OID
| Definition |
The identifier of the subscriber account containing the external account |
| Type |
DECIMAL(28), NOT NULL |
| Available Index |
IX_EXAC_SUAC |
CODE
| Definition |
The identification code (or codename) of the account in the subscriber account |
| Type |
NVARCHAR(256), NOT NULL |
DESCRIPTION
| Definition |
The comprehensive description of the account |
| Type |
NVARCHAR(2000), NULL |
CURRENCY_CODE
| Definition |
The currency code of the account |
| Type |
NVARCHAR(5), NULL |
EXTERNAL_ACCOUNT_SYSTEM
| Definition |
The external system that handles the account |
| Type |
NVARCHAR(256), NULL |
EXTERNAL_ACCOUNT_CODE
| Definition |
The code of the external account in the external billing or accounting system |
| Type |
NVARCHAR(256), NULL |
ACCOUNT_TYPE
| Definition |
The type of account |
| Format |
The possible values are:
-1: Undefined
0: Payable
1: Receivable
|
| Type |
DECIMAL(1), NOT NULL |
IS_DEFAULT
| Definition |
The IS_DEFAULT field indicates if the account is the default account for the subscriber
account
|
| Format |
The possible values are:
|
| Type |
DECIMAL(1), NOT NULL |
DELETION_DATE
| Definition |
The date until which this account is valid |
| 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.
|
| Type |
DATETIME, NULL |
PARTITION_ID
| Definition |
The partition of the subscriber account |
| Type |
DECIMAL(4), NOT NULL |
Index Details
The following database indexes are available in the
EXTERNAL_ACCOUNT database table to improve the speed of data retrieval operations during
the business processes of SAP Convergent Charging:
IX_EXAC_SUAC
| Indexed Column(s) |
SUAC_OID |
| Unique |
No |
| Partitioned |
Yes |
| Clustered |
No |
| Segment |
SUBSCRIBER_INDX |
