RPT_DIM_TM_CHARGE_CODES_MV
This table stores the definition of each PPM charge code.
Foreign Keys
This table does not have any foreign keys.
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
CHARGE_CODE_ID |
NOT NULL |
NUMBER |
ID derived from the PPM KTMG_CHARGE_CODES table. |
CHARGE_CODE_NAME |
NOT NULL |
VARCHAR2(80) |
Name of the charge code |
DESCRIPTION |
NOT NULL |
VARCHAR2(240) |
Description of the charge code |
CHARGE_CODE_CATEGORY |
NULLABLE |
VARCHAR2(150) |
Category of the charge code |
DEPARTMENT |
NULLABLE |
VARCHAR2(150) |
Department of the charge code |
CLIENT |
NULLABLE |
VARCHAR2(150) |
Client of the charge code |
ENABLED_FLAG |
NOT NULL |
VARCHAR2(1) |
Indicates whether the charge code is enabled. |
Indexes
This table uses no indexes.
Sequences
This table uses no sequences.