CAPA

Table: CAPA

Table Name

CAPA

Table Description

The CAPA table contains the description of the charge plan.

Tablespace

CATALOG_DATA

Database

Columns

The CAPA database table is defined by the following columns.

Value Type	BIGINT, NOT NULL
Key(s)	Primary Key: PK_CAPA
Column Description	The unique identifier of the charge plan. It is generated by the system.

Value Type	VARCHAR(256), NOT NULL
Column Description	The external identifier of the charge plan, corresponding to the name of the charge plan in the Core Tool.

Value Type	DECIMAL(1), NOT NULL
Column Description	The type of the charge plan. Possible values are: 0: charge plan 1: refill plan

Value Type

DECIMAL(1), NOT NULL

Column Description

The type of the charge plan.

Possible values are:

Value Type	DECIMAL(1), NOT NULL
Column Description	The status of the charge plan. Possible values are: 0: open 1: released 2: obsolete

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

Document Version: SP04 and later