PREPAID_ACCOUNT

Table: PREPAID_ACCOUNT

Table Name

PREPAID_ACCOUNT

Table Description

The PREPAID_ACCOUNT table represents a prepaid account in a subscriber account.

Tablespace

SUBSCRIBER_DATA

Database

Core Database

Partitioned

Yes

Columns

SUAC_OID
CODE
DESCRIPTION
CURRENCY_CODE
EMPTY_LIMIT_AMOUNT
OVERRUN_CODE
OVERRUN_TYPE
CLIENT_ID
IS_DEFAULT
COUN_KEY
BLOCKED_DATE_KEY
LOCKED_DATE_KEY
CLOSED_DATE_KEY
PARTITION_ID

Columns of the Table

The PREPAID_ACCOUNT database table is defined by the following columns.

Column: SUAC_OID

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

Column: CODE

Value Type	VARCHAR(256), NOT NULL
Index(es)	IX_PRAC_SUAC_G (unique) (oracle)
Column Description	The code of the prepaid account.

Column: DESCRIPTION

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

Column: CURRENCY_CODE

Value Type	VARCHAR(5), NOT NULL
Column Description	The currency code of the prepaid account.

Column: EMPTY_LIMIT_AMOUNT

Value Type	DECIMAL(28,6)
Column Description	The empty limit of the prepaid account. If the balance comes under this amount, the usage is not authorized.

Column: OVERRUN_CODE

Value Type	VARCHAR(256)
Column Description	The code of the account (prepaid or external) to charge in case of overrun.

Column: OVERRUN_TYPE

Value Type	DECIMAL(1)
Column Description	The type of the account (prepaid or external) to charge in case of overrun. Possible values are: 0: undefined 1: prepaid account 2: external account

Value Type

DECIMAL(1)

Column Description

The type of the account (prepaid or external) to charge in case of overrun.

Possible values are:

0: undefined
1: prepaid account
2: external account

Column: CLIENT_ID

Value Type	VARCHAR(256)
Column Description	The identifier of the owner of the prepaid account.

Column: IS_DEFAULT

Value Type	DECIMAL(1), NOT NULL
Column Description	The IS_DEFAULT field indicates if the prepaid 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 prepaid account is the default account for the subscriber account.

Possible values are:

0: no
1: yes

Column: COUN_KEY

Value Type	DECIMAL(6), NOT NULL
Column Description	The key of the counter that contains the value of the balance of the prepaid account.

Column: BLOCKED_DATE_KEY

Value Type	DECIMAL(6), NOT NULL
Column Description	The key of the counter containing the date when the account is blocked.

Column: LOCKED_DATE_KEY

Value Type	DECIMAL(6), NOT NULL
Column Description	The key of the counter containing the date when the account is locked.

Column: CLOSED_DATE_KEY

Value Type	DECIMAL(6), NOT NULL
Column Description	The key of the counter containing the date when the account is closed.

Column: PARTITION_ID

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

Top of the list

SAP Convergent Charging 3.0

Document Version: SP04 and later