Share this page

# TM_LINE_CHARGE_CODES

This many-to-many cross reference table joins charge codes to the time sheet items that use them.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KTMG_CHARGE_CODES_NLS | CHARGE_CODE_ID | CHARGE_CODE_ID
TM_TIME_SHEET_LINES | TIME_SHEET_LINE_ID | TIME_SHEET_LINE_ID
KNTA_USERS | USER_ID | CREATED_BY
KNTA_USERS | USER_ID | LAST_UPDATED_BY

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
LINE_CHARGE_CODE_ID | NOT NULL | NUMBER | System-generated identifier
VERSION | NOT NULL | NUMBER | System-generated version for the entity. This column must not be updated manually
CHARGE_CODE_ID | NOT NULL | NUMBER | Indicates the charge code in KTMG_CHARGE_CODES which is used by a time sheet item.
CHARGE_PERCENT | NULLABLE | FLOAT | Indicates the current charge percent for the charge code identified by CHARGE_CODE_ID
CREATED_BY | NOT NULL | NUMBER | Identifier for the user who created the record
CREATION_DATE | NOT NULL | DATE | Date record was created
LAST_UPDATED_BY | NOT NULL | NUMBER | Identifier for the user who last updated the record
LAST_UPDATE_DATE | NOT NULL | DATE | Date record was last updated
TIME_SHEET_LINE_ID | NULLABLE | NUMBER | Identifies the time sheet item that the charge code is associated with.
TIME_SHEET_LINE_CC_SEQ | NULLABLE | NUMBER | Captures the internal ordering of the rows for each time sheet item.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
FKA003B1002DB42636_I | NONUNIQUE | 1 | CHARGE_CODE_ID
FKA003B100E2408E7_I | NONUNIQUE | 1 | TIME_SHEET_LINE_ID
SYS_C005201595 | UNIQUE | 1 | LINE_CHARGE_CODE_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
TM_LINE_CHARGE_CODES_S | LINE_CHARGE_CODE_ID

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: