SUBSCRIBER_ACCOUNT

Table: SUBSCRIBER_ACCOUNT

Table Name

SUBSCRIBER_ACCOUNT

Table Description

The SUBSCRIBER_ACCOUNT table contains the subscriber account data. A subscriber account represents a set of subscriptions belonging to a subscriber.

Tablespace

SUBSCRIBER_DATA

Database

Core Database

Partitioned

Yes

Columns

OID
CODE
SUBSCRIBER
SERVICE_PROVIDER
DESCRIPTION
TAXATION_MODULE
TAX_CODE
TAXATION_MODE
TAX_DATA
PREPAID_TAXATION_TYPE
PREPAID_TRANSAC_PARTITION_ID
PARTITION_ID

Columns of the Table

The SUBSCRIBER_ACCOUNT database table is defined by the following columns.

Column: OID

Value Type	BIGINT, NOT NULL
Key(s)	Primary Key: PK_SUBSCRIBER_ACCOUNT
Index(es)	IX_SUAC_OID (sqlserver)
Column Description	The subscriber account unique identifier.

Column: CODE

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

Column: SUBSCRIBER

Value Type	VARCHAR(256), NOT NULL
Column Description	The subscriber of the subscriber account.

Column: SERVICE_PROVIDER

Value Type	VARCHAR(256), NOT NULL
Index(es)	IX_SUAC_CODE (unique) (oracle) IX_SUAC_CODE (unique) (sqlserver)
Column Description	The service provider for the subscriber account.

Column: DESCRIPTION

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

Column: TAXATION_MODULE

Value Type	DECIMAL(1), NOT NULL
Default Value	0
Column Description	The taxation module for the subscriber account. Possible values are: 0: VAT 1: EZTAX 2: NOP

Value Type

DECIMAL(1), NOT NULL

Default Value

Column Description

The taxation module for the subscriber account.

Possible values are:

0: VAT
1: EZTAX
2: NOP

Column: TAX_CODE

Value Type	VARCHAR(256), NOT NULL
Column Description	The code of the tax used for the subscriber account. Possible values are: NO_TAX /EZTAX_AREA/ if using EZTax The following syntax for VAT taxation /<country code>/<sort of tax>#<timestamp> where: <country code> is the ISO code of the country <sort of tax> gives the tax rate to apply: 0 for NORMAL_TAX_RATE 1 for INTERMEDIARY_TAX_RATE 2 for REDUCED_TAX_RATE 3 for SUPER_REDUCED_TAX_RATE 4 for ZERO_TAX_RATE 5 for SPECIAL_TAX_RATE <timestamp> is the number of days before applying the tax rate from the 1st of january 1970.

Value Type

VARCHAR(256), NOT NULL

Column Description

The code of the tax used for the subscriber account.

Possible values are:

NO_TAX
/EZTAX_AREA/ if using EZTax
The following syntax for VAT taxation /<country code>/<sort of tax>#<timestamp> where:
- <country code> is the ISO code of the country
- <sort of tax> gives the tax rate to apply:
  - 0 for NORMAL_TAX_RATE
  - 1 for INTERMEDIARY_TAX_RATE
  - 2 for REDUCED_TAX_RATE
  - 3 for SUPER_REDUCED_TAX_RATE
  - 4 for ZERO_TAX_RATE
  - 5 for SPECIAL_TAX_RATE
- <timestamp> is the number of days before applying the tax rate from the 1st of january 1970.

Column: TAXATION_MODE

Value Type	DECIMAL(1), NOT NULL
Default Value	0
Column Description	The taxation mode for the subscriber account. Possible values are: 0: VENDOR_SUBJECT_TO_PAY 1: BUYER_SUBJECT_TO_PAY 2: BUYER_EXEMPTED 3: NOBODY_SUBJECT_TO_PAY

Value Type

DECIMAL(1), NOT NULL

Default Value

Column Description

The taxation mode for the subscriber account.

Possible values are:

0: VENDOR_SUBJECT_TO_PAY
1: BUYER_SUBJECT_TO_PAY
2: BUYER_EXEMPTED
3: NOBODY_SUBJECT_TO_PAY

Column: TAX_DATA

Value Type	VARCHAR(256)
Column Description	The TAX_DATA field gives additional information about taxes in a csv string. This information can be needed when using VAT or EZTax.

Column: PREPAID_TAXATION_TYPE

Value Type	DECIMAL(1), NOT NULL
Default Value	0
Column Description	The prepaid balance taxation type. Possible values are: 0: tax excluded 1: tax included

Value Type

DECIMAL(1), NOT NULL

Default Value

Column Description

The prepaid balance taxation type.

Possible values are:

0: tax excluded
1: tax included

Column: PREPAID_TRANSAC_PARTITION_ID

Value Type	DECIMAL(3), NOT NULL
Default Value	-1
Column Description	The partition ID for the prepaid transactions.

Column: PARTITION_ID

Value Type	SMALLINT, NOT NULL
Index(es)	IX_SUAC_CODE (unique) (sqlserver)
Column Description	The partition of the subscriber account.

Top of the list

SAP Convergent Charging 3.0

Document Version: SP04 and later