XM_TIMESHEET_LINE_ITEM

Entity Name XM_TIMESHEET_LINE_ITEM
Entity Type Independent
Definition This table has one row for each timesheet line item.
Attribute Datatype Width Definition
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