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