| 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 |