Export_line_id |
N/A |
int |
N |
A unique sequence number that serves as the primary key for the row. This is not the line item ID of the alts_line_item table. |
ts_line_item_id |
alts_line_item - ts_line_item_id |
int |
N |
Unique identifier of this timesheet line item. |
export_hdr_id |
N/A |
int |
N |
The ID of the corresponding header row in the alts_export_header table. |
export_line_status |
N/A |
smallint |
N |
Status of the export document. |
line_item_date |
alts_line_item - ts_date |
datetime |
N |
Date associated with this charge. |
top_project_code |
alco_project_number - top_project_code |
VARCHAR (255) |
N |
Top project code of the project to which this timesheet line is charged. Reference from: alts_line_item. project_number_id The top-level project code. |
project_code |
alco_project_number - project_code |
VARCHAR (255) |
N |
Project code of the project to which this timesheet line is charged. Reference from: alts_line_item. project_number_id The detailed project code the hours are billed for. |
Hours |
alts_line_item - ts_hours |
NUMERIC (20,10) |
N |
Hours associated with this charge. |
approved_hours |
alts_line_item - app_ts_hours |
NUMERIC (20,10) |
N |
Approved hours for this charge. |
hourly_charge_type |
alts_hourly_charge_ types - hourly_charge_ type_name |
VARCHAR (255) |
Y |
Hourly charge type of this timesheet line. Reference from: alts_line_item. app_hourly_charge_type_id. Hourly charge type, such as regular or overtime. |
app_hourly_charge_type |
alts_hourly_charge_ types - hourly_charge_ type_name |
VARCHAR (255) |
Y |
Approved hourly charge type of this timesheet line. Reference from: alts_line_item. hourly_charge_type_id. Approved hourly charge type. |
charge_type |
alco_charge_types - charge_name |
VARCHAR (255) |
Y |
Charge type of this timesheet line. Reference from: alts_line_item. charge_type_id. Charge type, like billable, and so on. |
Location |
alco_location Bob element : Location.locationName |
VARCHAR (255) |
Y |
The location where the hours are billed. |
charge_role |
alco_charge_role. Charge_role_name |
VARCHAR (255) |
Y |
The role of the user for this charge. Reference from: alts_line_item. charge_role_id. Charge role, which could be "project manager" or the like. |
billable_rate |
alts_line_item. Ts_billable_rate |
NUMERIC (20,10) |
Y |
Billable rate for this timesheet line item. This can be overridden by the manager. |
billable_rate_ currency_ISO |
alco_currency_ format. Currency_code_iso |
char (3) |
Y |
Currency rate for the above billable rate. Reference from: alts_line_item. ts_billable_rate_id. Currency this line item is billing in. |
start_time |
alts_line_item. Ts_start_time |
datetime |
Y |
Starting time. |
end_time |
alts_line_item. Ts_end_time |
datetime |
Y |
Ending time. |
Note |
alts_line_item. Ts_note + alco_note_entry note type = "note" |
text |
Y |
Any line item note. |
COST_CENTER_ NAME |
alco_cost_center - cost_center_name |
VARCHAR (255) |
Y |
The name cost center to which this is charged. Default: creator's home cost center. Reference from: ALTS_LINE_ITEM.COST_CENTER_ ID |
COST_CENTER_ CODE |
alco_cost_center - cost_center_code |
VARCHAR (255) |
Y |
The cost center being charged to Default: creator's home cost center Reference from: ALTS_LINE_ITEM.COST_CENTER_ ID |
project_ekey |
alts_line_item - project_number_id |
VARCHAR (255) |
Y |
External key identifying the project charge code |
hourly_charge_type_ekey |
alts_line_item - hourly_charge_type_id |
VARCHAR (255) |
Y |
External key identifying the hourly charge type |
app_hourly_charge_type_ekey |
alts_line_item - app_hourly_charge_type_id |
VARCHAR (255) |
Y |
External key identifying the approved hourly charge type |
charge_type_ekey |
alts_line_item - charge_type_id |
VARCHAR (255) |
Y |
External key identifying the charge type |
location_ekey |
alts_line_item - location_id |
VARCHAR (255) |
Y |
External key identifying the location |
charge_role_ekey |
alts_line_item - charge_role_id |
VARCHAR (255) |
Y |
External key identifying the charge role |
billable_rate_ currency_ekey |
alts_line_item - currency_fmt_defn_ id |
VARCHAR (255) |
Y |
External key identifying the billable rate currency |
cost_center_ekey |
alts_line_item - cost_center_id |
VARCHAR (255) |
Y |
External key identifying the cost center |
Description |
alts_line_Item - description |
VARCHAR (255) |
Y |
Line item description |
attd_in1 |
alts_line_Item - attd_in1 |
datetime |
Y |
This is the start time of the first time period to support the HTML version of TS in Attendance mode. |
attd_out1 |
alts_line_Item - attd_out1 |
datetime |
Y |
This is the end time of the first time period to support the HTML version of TS in Attendance mode. |
attd_in2 |
alts_line_Item - attd_in2 |
datetime |
Y |
This is the start time of the second time period to support the HTML version of TS in Attendance mode. |
attd_out2 |
alts_line_Item - attd_out2 |
datetime |
Y |
This is the end time of the second time period to support the HTML version of TS in Attendance mode. |
attd_in3 |
alts_line_Item - attd_in3 |
datetime |
Y |
This is the start time of the third time period to support the HTML version of TS in Attendance mode. |
attd_out3 |
alts_line_Item - attd_out3 |
datetime |
Y |
This is the end time of the third time period to support the HTML version of TS in Attendance mode. |
attd_in4 |
alts_line_Item - attd_in4 |
datetime |
Y |
This is the start time of the fourth time period to support the HTML version of TS in Attendance mode. |
attd_out4 |
alts_line_Item - attd_out4 |
datetime |
Y |
This is the end time of the fourth time period to support the HTML version of TS in Attendance mode. |
attd_in5 |
alts_line_Item - attd_in5 |
datetime |
Y |
This is the start time of the fifth time period to support the HTML version of TS in Attendance mode. |
attd_out5 |
alts_line_Item - attd_out5 |
datetime |
Y |
This is the end time of the fifth time period to support the HTML version of TS in Attendance mode. |
attd_in6 |
alts_line_Item - attd_in6 |
datetime |
Y |
This is the start time of the sixth time period to support the HTML version of TS in Attendance mode. |
attd_out6 |
alts_line_Item - attd_out6 |
datetime |
Y |
This is the end time of the sixth time period to support the HTML version of TS in Attendance mode. |
attd_absence_ hours |
alts_line_Item - attd_absence_hours |
numeric (14, 4) |
Y |
The number of absence hours calculated by the HTML TS attendance mode. |
COMPANY_NAME |
alco_company - company_name |
VARCHAR(255) |
Y |
Company name of the cost center of this line item. |
COMPANY_CODE |
alco_company - company_code |
VARCHAR(255) |
Y |
Company code of the cost center of this line item. |
DIVISION_NAME |
alco_division - division_name |
VARCHAR(255) |
Y |
Division name of the cost center of this line item. |
DIVISION_CODE |
alco_division - division_code |
VARCHAR(255) |
Y |
Division code of the cost center of this line item. |
DEPARTMENT_NAME |
alco_department - department_name |
VARCHAR(255) |
Y |
Department name of the cost center of this line item. |
DEPARTMENT_CODE |
alco_department - department_code |
VARCHAR(255) |
Y |
Department code of the cost center of this line item. |
SEGMENT1_NAME |
alco_cost_center_segment - segment_name |
VARCHAR(255) |
Y |
Segment 1 name of line item cost center |
SEGMENT1_CODE |
alco_cost_center_segment - segment_code |
VARCHAR(255) |
Y |
Segment 1 code of line item cost center |
SEGMENT2_NAME |
alco_cost_center_segment - segment_name |
VARCHAR(255) |
Y |
Segment 2 name of line item cost center |
SEGMENT2_CODE |
alco_cost_center_segment - segment_code |
VARCHAR(255) |
Y |
Segment 2 code of line item cost center |
SEGMENT3_NAME |
alco_cost_center_segment - segment_name |
VARCHAR(255) |
Y |
Segment 3 name of line item cost center |
SEGMENT3_CODE |
alco_cost_center_segment - segment_code |
VARCHAR(255) |
Y |
Segment 3 code of line item cost center |
SEGMENT4_NAME |
alco_cost_center_segment - segment_name |
VARCHAR(255) |
Y |
Segment 4 name of line item cost center |
SEGMENT4_CODE |
alco_cost_center_segment - segment_code |
VARCHAR(255) |
Y |
Segment 4 code of line item cost center |
SEGMENT5_NAME |
alco_cost_center_segment - segment_name |
VARCHAR(255) |
Y |
Segment 5 name of line item cost center |
SEGMENT5_CODE |
alco_cost_center_segment - segment_code |
VARCHAR(255) |
Y |
Segment 5 code of line item cost center |
SEGMENT6_NAME |
alco_cost_center_segment - segment_name |
VARCHAR(255) |
Y |
Segment 6 name of line item cost center |
SEGMENT6_CODE |
alco_cost_center_segment - segment_code |
VARCHAR(255) |
Y |
Segment 6 code of line item cost center |
SEGMENT7_NAME |
alco_cost_center_segment - segment_name |
VARCHAR(255) |
Y |
Segment 7 name of line item cost center |
SEGMENT7_CODE |
alco_cost_center_segment - segment_code |
VARCHAR(255) |
Y |
Segment 7 code of line item cost center |
SEGMENT8_NAME |
alco_cost_center_segment - segment_name |
VARCHAR(255) |
Y |
Segment 8 name of line item cost center |
SEGMENT8_CODE |
alco_cost_center_segment - segment_code |
VARCHAR(255) |
Y |
Segment 8 code of line item cost center |
SEGMENT9_NAME |
alco_cost_center_segment - segment_name |
VARCHAR(255) |
Y |
Segment 9 name of line item cost center |
SEGMENT9_CODE |
alco_cost_center_segment - segment_code |
VARCHAR(255) |
Y |
Segment 9 code of line item cost center |
SEGMENT_COUNT |
alco_cost_center_config - segment_count |
INTEGER |
Y |
The number of segments in the cost center of this line item. |
REVIEW_SEGMENT_NAME |
alco_cost_center_rev_segment - segment_name |
VARCHAR(255) |
Y |
The review segment name of the cost center of this line item. |
REVIEW_SEGMENT_CODE |
alco_cost_center_rev_segment - segment_code |
VARCHAR(255) |
Y |
The review segment code of the cost center of this line item. |
EXPORT_LINE_STATUS_DATETIME |
|
DATETIME |
Y |
The date and time, the line status was updated |
EXPORT_STATUS |
alts_line_item – export_status |
INTEGER |
Y |
the export status (0=not exported, 1=exported, 2=marked for re-export) |
VOID_STATUS |
alts_line_item – void_status |
INTEGER |
Y |
the void status (0=not voided, 1=voided, 2=this is a reversal that cancels out a voided line item) |
REVERSAL_LINE_ITEM_ID |
alts_line_item – reversal_line_item_id |
INTEGER |
Y |
for voided/reversal line items, this is the matching reversal/voided line item |
EXPORT_DATE |
alts_line_item – export_date |
DATETIME |
Y |
The date the item was first exported to the financial system |