LINE_ITEM_ID |
Integer |
38 |
PK |
DOCUMENT_ID |
Integer |
38 |
The parent document |
S_ATTENDANCE_LINE_ITEM |
Integer |
5 |
Not being used |
HOURS |
Number |
14,4 |
hours associated with this charge |
COST_CENTER_ID |
Integer |
38 |
The cost center that is charged. Default is creator home cost center |
WORK_DATE |
DateTime |
|
date associated with this charge |
END_TIME |
DateTime |
|
Ending time |
START_TIME |
DateTime |
|
Starting time |
CHANGE_TIMESTAMP |
DateTime |
|
|
PROJECT_NUMBER_ID |
Number |
38 |
identifies the charge code |
PROJECT_ACTIVITY_CODE |
Varchar |
255 |
Project activity code |
PROJECT_ACTIVITY_NAME |
varchar |
255 |
Project activity name |
APPROVED_HOURS |
Number |
14,4 |
Approved hours for this charge |
HOURLY_CHARGE_TYPE |
Char |
40 |
approved hourly charge type |
CHARGE_TYPE |
varchar |
255 |
charge type, like billable, etc |
LOCATION_ID |
Number |
38 |
The work location where the worker perfomed the job. |
CHARGE_ROLE |
Varchar |
255 |
It could be 'project manager' |
APPROVED_HOURLY_CHARGE_TYPE |
Char |
40 |
Approved hourly charge type |
BILLABLE_RATE |
Number |
28,10 |
billable rate for this time sheet line item, entered by manager |
BILLABLE_RATE CURRENCY |
Varchar |
3 |
Currency of billable rate |
DESCRIPTION |
Varchar |
255 |
A short note for the user to add additional information. |
ADJUSTED_HOURS |
Number |
7,2 |
Adjusted hours |
ATTD_IN1 |
DateTime |
|
Stores attendance in-out time pair 1 (in) |
ATTD_OUT1 |
DateTime |
|
Stores attendance in-out time pair 1 (out) |
ATTD_IN2 |
DateTime |
|
Stores attendance in-out time pair 2 (in) |
ATTD_OUT2 |
DateTime |
|
Stores attendance in-out time pair 2 (out) |
ATTD_IN3 |
DateTime |
|
Stores attendance in-out time pair 3 (in) |
ATTD_OUT3 |
DateTime |
|
Stores attendance in-out time pair 3 (out) |
ATTD_IN4 |
DateTime |
|
Stores attendance in-out time pair 4 (in) |
ATTD_OUT4 |
DateTime |
|
Stores attendance in-out time pair 4 (out) |
ATTD_IN5 |
Date Time |
|
Stores attendance in-out time pair 5 (in) |
ATTD_OUT5 |
DateTime |
|
Stores attendance in-out time pair 5 (out) |
ATTD_IN6 |
DateTime |
|
Stores attendance in-out time pair 6 (in) |
ATTD_OUT6 |
DateTime |
|
Stores attendance in-out time pair 6 (out) |
CREATER_CLIENT_TYPE |
Number |
38 |
the client that created the line item (1=HTML, 2=Mobile, 3=Voice,
4=DocumentImportBkg) |
EXPORT_STATUS |
Number |
38 |
the export status (0=not exported, 1=exported, 2=marked for re-export) |
VOID_STATUS |
Number |
38 |
the void status (0=not voided, 1=voided, 2=this is a reversal that cancels out a
voided line item) |
REVERSAL_LINE_ITEM_ID |
Number |
38 |
for voided/reversal line items, this is the matching reversal/ voided line item
|