Share this page
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.
