Combined report columns

Every column of combined_report_data_v1, in the order Power BI shows them.

Turn on Dockets & costs to read this table. Money columns are blank unless the connection’s Prices switch is on.

Rows come in report order within each date range. Empty values are blank. Lacroo_Row_Key is unique in one refresh; it is not a record id.

Refresh in full. Leave Incremental refresh off so every change, including to older records, comes through.

#	Column	Power BI name	Type	Core type	Differs from Core
1	`_id`	`_id`	Text	built-in	The Core id of the row’s docket line, material line or docket, else its Lacroo id. Split shares of one line carry the same id.
2	`Created Date`	`Created_Date`	Date/Time/Timezone	built-in	When the docket was created.
3	`Modified Date`	`Modified_Date`	Date/Time/Timezone	built-in	The docket’s last change in Lacroo.
4	`Created By`	`Created_By`	Text	built-in	The Lacroo id of the person who created the docket.
5	`Activity Cost Code`	`Activity_Cost_Code`	Text	text
6	`Activity Description`	`Activity_Description`	Text	text
7	`Activity Program Code`	`Activity_Program_Code`	Text	text
8	`Activity Sub Code`	`Activity_Sub_Code`	Text	text
9	`Amount`	`Amount`	Decimal number	number
10	`Approved By`	`Approved_By`	Text	text
11	`Approved On`	`Approved_On`	Date/Time/Timezone	date
12	`Billing Rate`	`Billing_Rate`	Decimal number	number
13	`Billing Unit`	`Billing_Unit`	Text	text
14	`Break Duration (minutes)`	`Break_Duration_minutes`	Decimal number	number
15	`Break Start Time`	`Break_Start_Time`	Date/Time/Timezone	date	The first unpaid break’s clock time on the docket date, in the project’s time zone.
16	`Checked By`	`Checked_By`	Text	text
17	`Checked On`	`Checked_On`	Date/Time/Timezone	date
18	`Diary`	`Diary`	Text	Diary	The Core diary id, else the Lacroo diary id.
19	`Docket`	`Docket`	Text	Plant & Labour Docket	The Core docket id, else the Lacroo docket id.
20	`Docket Date`	`Docket_Date`	Date	date	A calendar date, with no time or zone.
21	`Docket Note`	`Docket_Note`	Text	text
22	`Docket Number`	`Docket_Number`	Text	text
23	`Docket Status`	`Docket_Status`	Text	text	Open while the docket is a draft, else Close.
24	`Docket Type`	`Docket_Type`	Text	text
25	`Finish Time`	`Finish_Time`	Date/Time/Timezone	date	The shift’s finish, in the project’s time zone.
26	`Internal Rate Card Description`	`Internal_Rate_Card_Description`	Text	text
27	`Lacroo Unique ID`	`Lacroo_Unique_ID`	Text	text	The Lacroo docket id.
28	`Linked Attachment`	`Linked_Attachment`	Text	Docket Attachment	The Core attachment id, else the Lacroo id of the attachment line.
29	`Linked Material Receipt`	`Linked_Material_Receipt`	Text	Material Receipt	The Core material receipt id, else the Lacroo id of its docket.
30	`PO/Contract Line Description`	`PO_Contract_Line_Description`	Text	text
31	`PO/Contract Line Number`	`PO_Contract_Line_Number`	Decimal number	number
32	`PO/Contract Number`	`PO_Contract_Number`	Text	text
33	`Prestart Duration (minutes)`	`Prestart_Duration_minutes`	Decimal number	number
34	`Prestart PO/Contract Description`	`Prestart_PO_Contract_Description`	Text	text
35	`Prestart PO/Contract Line Number`	`Prestart_PO_Contract_Line_Number`	Decimal number	number
36	`Prestart PO/Contract Number`	`Prestart_PO_Contract_Number`	Text	text
37	`Project Contract No.`	`Project_Contract_No`	Text	text	The contract number of the docket’s stage, else the project’s first live stage.
38	`Project`	`Project`	Text	Project	The Core project id, else the Lacroo project id.
39	`Project Name`	`Project_Name`	Text	text
40	`Rates Data Source`	`Rates_Data_Source`	Text	text
41	`Resource`	`Resource`	Text	text
42	`Start Time`	`Start_Time`	Text	text
43	`Subcontractor Upload ID`	`Subcontractor_Upload_ID`	Text	text
44	`Submitted By`	`Submitted_By`	Text	text
45	`Submitted On`	`Submitted_On`	Date/Time/Timezone	date
46	`Supervisor`	`Supervisor`	Text	text
47	`Supplier Name`	`Supplier_Name`	Text	text
48	`Tagged Issue ID`	`Tagged_Issue_ID`	Text	text
49	`Type`	`Type`	Text	text
50	`Qty`	`Qty`	Decimal number	number
51	`Uploaded to ERP`	`Uploaded_to_ERP`	True/False	boolean
52	`Linked Work Item`	`Linked_Work_Item`	Text	Work Item	The Core work item id, else the Lacroo id of the work item line.
53	—	`Report_Date`	Date	—
54	—	`Lacroo_Project_ID`	Text	—
55	—	`Lacroo_Row_Key`	Text	—

Keep your Core column names

Add this step in Power Query’s Advanced Editor after the source step, so reports built on the Core names keep working.

Renamed = Table.RenameColumns(Source, {
    {"Created_Date", "Created Date"},
    {"Modified_Date", "Modified Date"},
    {"Created_By", "Created By"},
    {"Activity_Cost_Code", "Activity Cost Code"},
    {"Activity_Description", "Activity Description"},
    {"Activity_Program_Code", "Activity Program Code"},
    {"Activity_Sub_Code", "Activity Sub Code"},
    {"Approved_By", "Approved By"},
    {"Approved_On", "Approved On"},
    {"Billing_Rate", "Billing Rate"},
    {"Billing_Unit", "Billing Unit"},
    {"Break_Duration_minutes", "Break Duration (minutes)"},
    {"Break_Start_Time", "Break Start Time"},
    {"Checked_By", "Checked By"},
    {"Checked_On", "Checked On"},
    {"Docket_Date", "Docket Date"},
    {"Docket_Note", "Docket Note"},
    {"Docket_Number", "Docket Number"},
    {"Docket_Status", "Docket Status"},
    {"Docket_Type", "Docket Type"},
    {"Finish_Time", "Finish Time"},
    {"Internal_Rate_Card_Description", "Internal Rate Card Description"},
    {"Lacroo_Unique_ID", "Lacroo Unique ID"},
    {"Linked_Attachment", "Linked Attachment"},
    {"Linked_Material_Receipt", "Linked Material Receipt"},
    {"PO_Contract_Line_Description", "PO/Contract Line Description"},
    {"PO_Contract_Line_Number", "PO/Contract Line Number"},
    {"PO_Contract_Number", "PO/Contract Number"},
    {"Prestart_Duration_minutes", "Prestart Duration (minutes)"},
    {"Prestart_PO_Contract_Description", "Prestart PO/Contract Description"},
    {"Prestart_PO_Contract_Line_Number", "Prestart PO/Contract Line Number"},
    {"Prestart_PO_Contract_Number", "Prestart PO/Contract Number"},
    {"Project_Contract_No", "Project Contract No."},
    {"Project_Name", "Project Name"},
    {"Rates_Data_Source", "Rates Data Source"},
    {"Start_Time", "Start Time"},
    {"Subcontractor_Upload_ID", "Subcontractor Upload ID"},
    {"Submitted_By", "Submitted By"},
    {"Submitted_On", "Submitted On"},
    {"Supplier_Name", "Supplier Name"},
    {"Tagged_Issue_ID", "Tagged Issue ID"},
    {"Uploaded_to_ERP", "Uploaded to ERP"},
    {"Linked_Work_Item", "Linked Work Item"}
})

Workforce log columns Activity log columns