R365DataSets

Restaurant 365 OData Connector Datasets

These are sample datasets pulled from the Restaurant365 OData Connector API

Transactions (Journal Entries, AP Invoices, AP Credits Memos, Inventories)

Between 1/1/2024 and 1/3/2024

https://odata.restaurant365.net/api/v2/views/Transaction?$filter=date%20ge%202024-01-01T00:00:00Z%20and%20date%20lt%202024-01-03T00:00:00Z

transactionDF <- getDFFromEndpoint(txBetween)

transactionDF %>%
  head(10) %>%
  gt() %>%
  tab_options(table.font.size = 10)
document.id transactionId locationId locationName date transactionNumber name type companyId rowVersion isApproved createdOn modifiedOn createdBy modifiedBy
1 03f10b50-4da9-ee11-a8ef-002248470496 f0808e2c-880a-426d-bb03-2db7a2bdc78e OK Café 2024-01-01T00:00:00Z NJ00001282 Journal Entry - NJ00001282 Journal Entry NA 4541725 TRUE 2024-01-02T09:00:05.127Z 2024-01-02T20:12:58.513Z R365 Import Jon Frontier
2 04f10b50-4da9-ee11-a8ef-002248470496 32a6eae8-7a87-40f1-aa06-c71633bb18e1 Bones 2024-01-01T00:00:00Z NJ00001283 Journal Entry - NJ00001283 Journal Entry NA 4541737 TRUE 2024-01-02T09:00:05.127Z 2024-01-02T20:13:21.463Z R365 Import Jon Frontier
3 05f10b50-4da9-ee11-a8ef-002248470496 2cd5cddd-8b98-4207-8ade-e9e160d761c1 Blue Ridge Grill 2024-01-01T00:00:00Z NJ00001284 Journal Entry - NJ00001284 Journal Entry NA 4541749 TRUE 2024-01-02T09:00:05.127Z 2024-01-02T20:14:04.847Z R365 Import Jon Frontier
4 c8f10b50-4da9-ee11-a8ef-002248470496 f0808e2c-880a-426d-bb03-2db7a2bdc78e OK Café 2024-01-01T00:00:00Z NJ00001285 Journal Entry - NJ00001285 Journal Entry NA 4541721 TRUE 2024-01-02T09:00:06.09Z 2024-01-02T09:00:06.09Z R365 Import R365 Import
5 c9f10b50-4da9-ee11-a8ef-002248470496 32a6eae8-7a87-40f1-aa06-c71633bb18e1 Bones 2024-01-01T00:00:00Z NJ00001286 Journal Entry - NJ00001286 Journal Entry NA 4541733 TRUE 2024-01-02T09:00:06.09Z 2024-01-02T09:00:06.09Z R365 Import R365 Import
6 caf10b50-4da9-ee11-a8ef-002248470496 2cd5cddd-8b98-4207-8ade-e9e160d761c1 Blue Ridge Grill 2024-01-01T00:00:00Z NJ00001287 Journal Entry - NJ00001287 Journal Entry NA 4541745 TRUE 2024-01-02T09:00:06.09Z 2024-01-02T09:00:06.09Z R365 Import R365 Import
7 9fda3f85-60a9-ee11-a8ef-002248470496 f0808e2c-880a-426d-bb03-2db7a2bdc78e OK Café 2024-01-02T00:00:00Z 0926300 AP Invoice - US FOODS, INC - 0926300 AP Invoice 521f8ffb-e83c-4f73-9331-b9a99a3cefdd 4541156 FALSE 2024-01-02T11:17:32.523Z 2024-01-02T11:17:32.523Z R365 Import R365 Import
8 a0da3f85-60a9-ee11-a8ef-002248470496 f0808e2c-880a-426d-bb03-2db7a2bdc78e OK Café 2024-01-02T00:00:00Z 0926299 AP Invoice - US FOODS, INC - 0926299 AP Invoice 521f8ffb-e83c-4f73-9331-b9a99a3cefdd 4541157 FALSE 2024-01-02T11:17:32.523Z 2024-01-02T11:17:32.523Z R365 Import R365 Import
9 a1da3f85-60a9-ee11-a8ef-002248470496 32a6eae8-7a87-40f1-aa06-c71633bb18e1 Bones 2024-01-02T00:00:00Z 0925299 AP Invoice - US FOODS, INC - 0925299 AP Invoice 521f8ffb-e83c-4f73-9331-b9a99a3cefdd 4541158 FALSE 2024-01-02T11:17:32.523Z 2024-01-02T11:17:32.523Z R365 Import R365 Import
10 9a036cc0-b8a9-ee11-a8ef-002248470496 32a6eae8-7a87-40f1-aa06-c71633bb18e1 Bones 2024-01-02T00:00:00Z 107639 AP Invoice - HEMISPHERES GLOBAL WINES - 107639 AP Invoice b34ca3db-e4d8-486a-a254-c7524139095d 4758238 FALSE 2024-01-02T21:49:07.55Z 2024-01-04T04:36:34Z R365 Import Martin Donovan

Transaction Details

Invoice INC - 0925299 - Bones

document.id transactionDetailAutoId transactionDetailId transactionId locationId glAccountId itemId credit debit amount quantity previousCountTotal adjustment unitOfMeasureName bankReconciliation bankDeposit comment rowType rowVersion createdOn modifiedOn createdBy modifiedBy
1 NA a2da3f85-60a9-ee11-a8ef-002248470496 a1da3f85-60a9-ee11-a8ef-002248470496 32a6eae8-7a87-40f1-aa06-c71633bb18e1 04417306-7c67-ee11-a8ec-002248470496 NA 98.79 0.00 98.79 0.00 0 0 NA NA NA Offset 4541162 2024-01-02T11:17:33.05Z 2024-01-02T11:17:33.05Z R365 Import R365 Import
2 NA a2da3f85-60a9-ee11-a8ef-002248470496 a1da3f85-60a9-ee11-a8ef-002248470496 32a6eae8-7a87-40f1-aa06-c71633bb18e1 00000000-0000-0000-0000-000000000000 NA 0.00 98.79 98.79 1.00 0 0 NA NA NA CHEESE AMER LOAF PROCD YLW EX Detail 4541162 2024-01-02T11:17:33.05Z 2024-01-02T11:17:33.05Z R365 Import R365 Import
3 NA a3da3f85-60a9-ee11-a8ef-002248470496 a1da3f85-60a9-ee11-a8ef-002248470496 32a6eae8-7a87-40f1-aa06-c71633bb18e1 04417306-7c67-ee11-a8ec-002248470496 NA 439.40 0.00 439.40 0.00 0 0 NA NA NA Offset 4541163 2024-01-02T11:17:33.05Z 2024-01-02T11:17:33.05Z R365 Import R365 Import
4 NA a3da3f85-60a9-ee11-a8ef-002248470496 a1da3f85-60a9-ee11-a8ef-002248470496 32a6eae8-7a87-40f1-aa06-c71633bb18e1 00000000-0000-0000-0000-000000000000 NA 0.00 439.40 439.40 20.00 0 0 NA NA NA BEEF STK STRIP LOIN CC NO F2F Detail 4541163 2024-01-02T11:17:33.05Z 2024-01-02T11:17:33.05Z R365 Import R365 Import
5 NA a4da3f85-60a9-ee11-a8ef-002248470496 a1da3f85-60a9-ee11-a8ef-002248470496 32a6eae8-7a87-40f1-aa06-c71633bb18e1 00000000-0000-0000-0000-000000000000 NA 0.00 665.47 665.47 30.29 0 0 NA NA NA BEEF STK STRIP LOIN CC NO F2F Detail 4541164 2024-01-02T11:17:33.05Z 2024-01-02T11:17:33.05Z R365 Import R365 Import
6 NA a4da3f85-60a9-ee11-a8ef-002248470496 a1da3f85-60a9-ee11-a8ef-002248470496 32a6eae8-7a87-40f1-aa06-c71633bb18e1 04417306-7c67-ee11-a8ec-002248470496 NA 665.47 0.00 665.47 0.00 0 0 NA NA NA Offset 4541164 2024-01-02T11:17:33.05Z 2024-01-02T11:17:33.05Z R365 Import R365 Import

Checks

For BRG 1/2/2024

https://odata.restaurant365.net/api/v2/views/SalesEmployee?$filter=date%20ge%202024-01-02T19:30:00Z%20and%20location%20eq%20(2cd5cddd-8b98-4207-8ade-e9e160d761c1)

document.id salesId receiptNumber checkNumber comment date dayOfWeek dayPart netSales numberofGuests orderHour salesAmount taxAmount tipAmount totalAmount totalPayment void server location grossSales createdOn modifiedOn serviceType dailySalesSummaryId createdBy modifiedBy
1 65f09bae-20aa-ee11-a8ef-002248470496 10037 - 2 - 01/02/2024 10037 2024-01-02T20:04:00Z Tuesday Dinner 270 4 20 270 24.03 0 294.03 294.03 FALSE JENNIFER JARVIE 2cd5cddd-8b98-4207-8ade-e9e160d761c1 270 2024-01-03T10:13:07.083Z 2024-01-03T10:13:07.083Z SEND - Dinner 20f09bae-20aa-ee11-a8ef-002248470496
2 66f09bae-20aa-ee11-a8ef-002248470496 10039 - 2 - 01/02/2024 10039 2024-01-02T19:48:00Z Tuesday Dinner 24 0 19 24 0.00 0 24.00 24.00 FALSE Jesse Otero 2cd5cddd-8b98-4207-8ade-e9e160d761c1 24 2024-01-03T10:13:07.083Z 2024-01-03T10:13:07.083Z SEND - Dinner 20f09bae-20aa-ee11-a8ef-002248470496
3 67f09bae-20aa-ee11-a8ef-002248470496 10048 - 2 - 01/02/2024 10048 2024-01-02T22:08:00Z Tuesday Dinner 0 0 22 0 0.00 42 42.00 42.00 FALSE JENNIFER JARVIE 2cd5cddd-8b98-4207-8ade-e9e160d761c1 0 2024-01-03T10:13:07.083Z 2024-01-03T10:13:07.083Z SEND - Dinner 20f09bae-20aa-ee11-a8ef-002248470496
4 72f09bae-20aa-ee11-a8ef-002248470496 20014 - 2 - 01/02/2024 20014 2024-01-02T19:54:00Z Tuesday Dinner 316 4 19 316 28.13 40 384.13 384.13 FALSE BIJOY DAS 2cd5cddd-8b98-4207-8ade-e9e160d761c1 316 2024-01-03T10:13:07.083Z 2024-01-03T10:13:07.083Z SEND - Dinner 20f09bae-20aa-ee11-a8ef-002248470496
5 82f09bae-20aa-ee11-a8ef-002248470496 40033 - 2 - 01/02/2024 40033 2024-01-02T19:37:00Z Tuesday Dinner 129 0 19 129 15.35 30 174.35 174.35 FALSE JURGITA VELICKAITE 2cd5cddd-8b98-4207-8ade-e9e160d761c1 129 2024-01-03T10:13:07.083Z 2024-01-03T10:13:07.083Z SEND - Dinner 20f09bae-20aa-ee11-a8ef-002248470496

Check Details

1/1/2024 Check Number 10073

https://odata.restaurant365.net/api/v2/views/SalesDetail?$filter=salesID eq (72f09bae-20aa-ee11-a8ef-002248470496)

document.id salesdetailID menuitem amount customerPOSText date quantity void company location salesID salesAccount category houseAccountTransaction transactionDetailID cateringEvent createdOn modifiedOn dailySalesSummaryId menuItemId createdBy modifiedBy
1 36f19bae-20aa-ee11-a8ef-002248470496 Blue Ridge Grill - American Wagyu Burger 20.00 2024-01-02T19:54:00Z 1 FALSE 00000000-0000-0000-0000-000000000000 2cd5cddd-8b98-4207-8ade-e9e160d761c1 72f09bae-20aa-ee11-a8ef-002248470496 SEND - Dinner - FOOD FOOD NA NA NA 2024-01-03T10:13:07.197Z 2024-01-03T10:13:07.197Z 20f09bae-20aa-ee11-a8ef-002248470496 3285
2 29f29bae-20aa-ee11-a8ef-002248470496 Blue Ridge Grill - Coffee 4.00 2024-01-02T19:54:00Z 1 FALSE 00000000-0000-0000-0000-000000000000 2cd5cddd-8b98-4207-8ade-e9e160d761c1 72f09bae-20aa-ee11-a8ef-002248470496 SEND - Dinner - N/A BEV N/A BEV NA NA NA 2024-01-03T10:13:07.197Z 2024-01-03T10:13:07.197Z 20f09bae-20aa-ee11-a8ef-002248470496 3248
3 36f29bae-20aa-ee11-a8ef-002248470496 Blue Ridge Grill - Creme Brulee 11.00 2024-01-02T19:54:00Z 1 FALSE 00000000-0000-0000-0000-000000000000 2cd5cddd-8b98-4207-8ade-e9e160d761c1 72f09bae-20aa-ee11-a8ef-002248470496 SEND - Dinner - FOOD FOOD NA NA NA 2024-01-03T10:13:07.197Z 2024-01-03T10:13:07.197Z 20f09bae-20aa-ee11-a8ef-002248470496 3384
4 51f29bae-20aa-ee11-a8ef-002248470496 Blue Ridge Grill - DEFERRED TIP 40.00 2024-01-02T19:54:00Z 1 FALSE 00000000-0000-0000-0000-000000000000 2cd5cddd-8b98-4207-8ade-e9e160d761c1 72f09bae-20aa-ee11-a8ef-002248470496 SEND - Dinner - DEFERRED TIP DEFERRED TIP NA NA NA 2024-01-03T10:13:07.197Z 2024-01-03T10:13:07.197Z 20f09bae-20aa-ee11-a8ef-002248470496 3595
5 aaf29bae-20aa-ee11-a8ef-002248470496 Blue Ridge Grill - Espresso 4.00 2024-01-02T19:54:00Z 1 FALSE 00000000-0000-0000-0000-000000000000 2cd5cddd-8b98-4207-8ade-e9e160d761c1 72f09bae-20aa-ee11-a8ef-002248470496 SEND - Dinner - N/A BEV N/A BEV NA NA NA 2024-01-03T10:13:07.197Z 2024-01-03T10:13:07.197Z 20f09bae-20aa-ee11-a8ef-002248470496 2968
6 abf29bae-20aa-ee11-a8ef-002248470496 Blue Ridge Grill - Espresso 4.00 2024-01-02T19:54:00Z 1 FALSE 00000000-0000-0000-0000-000000000000 2cd5cddd-8b98-4207-8ade-e9e160d761c1 72f09bae-20aa-ee11-a8ef-002248470496 SEND - Dinner - N/A BEV N/A BEV NA NA NA 2024-01-03T10:13:07.197Z 2024-01-03T10:13:07.197Z 20f09bae-20aa-ee11-a8ef-002248470496 2968
7 adf29bae-20aa-ee11-a8ef-002248470496 Blue Ridge Grill - Filet Mignon 59.00 2024-01-02T19:54:00Z 1 FALSE 00000000-0000-0000-0000-000000000000 2cd5cddd-8b98-4207-8ade-e9e160d761c1 72f09bae-20aa-ee11-a8ef-002248470496 SEND - Dinner - FOOD FOOD NA NA NA 2024-01-03T10:13:07.197Z 2024-01-03T10:13:07.197Z 20f09bae-20aa-ee11-a8ef-002248470496 3573
8 c8f29bae-20aa-ee11-a8ef-002248470496 Blue Ridge Grill - GL BRG Pinot 19.00 2024-01-02T19:54:00Z 1 FALSE 00000000-0000-0000-0000-000000000000 2cd5cddd-8b98-4207-8ade-e9e160d761c1 72f09bae-20aa-ee11-a8ef-002248470496 SEND - Dinner - GLASS WINE GLASS WINE NA NA NA 2024-01-03T10:13:07.197Z 2024-01-03T10:13:07.197Z 20f09bae-20aa-ee11-a8ef-002248470496 3339
9 cbf29bae-20aa-ee11-a8ef-002248470496 Blue Ridge Grill - Gl Cahors 15.00 2024-01-02T19:54:00Z 1 FALSE 00000000-0000-0000-0000-000000000000 2cd5cddd-8b98-4207-8ade-e9e160d761c1 72f09bae-20aa-ee11-a8ef-002248470496 SEND - Dinner - GLASS WINE GLASS WINE NA NA NA 2024-01-03T10:13:07.197Z 2024-01-03T10:13:07.197Z 20f09bae-20aa-ee11-a8ef-002248470496 3253
10 31f39bae-20aa-ee11-a8ef-002248470496 Blue Ridge Grill - Grilled Georgia Trout 34.00 2024-01-02T19:54:00Z 1 FALSE 00000000-0000-0000-0000-000000000000 2cd5cddd-8b98-4207-8ade-e9e160d761c1 72f09bae-20aa-ee11-a8ef-002248470496 SEND - Dinner - FOOD FOOD NA NA NA 2024-01-03T10:13:07.197Z 2024-01-03T10:13:07.197Z 20f09bae-20aa-ee11-a8ef-002248470496 2945
11 3df39bae-20aa-ee11-a8ef-002248470496 Blue Ridge Grill - Grilled Lamb 69.00 2024-01-02T19:54:00Z 1 FALSE 00000000-0000-0000-0000-000000000000 2cd5cddd-8b98-4207-8ade-e9e160d761c1 72f09bae-20aa-ee11-a8ef-002248470496 SEND - Dinner - FOOD FOOD NA NA NA 2024-01-03T10:13:07.197Z 2024-01-03T10:13:07.197Z 20f09bae-20aa-ee11-a8ef-002248470496 3499
12 42f39bae-20aa-ee11-a8ef-002248470496 Blue Ridge Grill - Grilled Octopus 20.00 2024-01-02T19:54:00Z 1 FALSE 00000000-0000-0000-0000-000000000000 2cd5cddd-8b98-4207-8ade-e9e160d761c1 72f09bae-20aa-ee11-a8ef-002248470496 SEND - Dinner - FOOD FOOD NA NA NA 2024-01-03T10:13:07.197Z 2024-01-03T10:13:07.197Z 20f09bae-20aa-ee11-a8ef-002248470496 3295
13 9cf39bae-20aa-ee11-a8ef-002248470496 Blue Ridge Grill - LG Brussels Sprouts 15.00 2024-01-02T19:54:00Z 1 FALSE 00000000-0000-0000-0000-000000000000 2cd5cddd-8b98-4207-8ade-e9e160d761c1 72f09bae-20aa-ee11-a8ef-002248470496 SEND - Dinner - FOOD FOOD NA NA NA 2024-01-03T10:13:07.197Z 2024-01-03T10:13:07.197Z 20f09bae-20aa-ee11-a8ef-002248470496 3596
14 e2f39bae-20aa-ee11-a8ef-002248470496 Blue Ridge Grill - Medium 0.00 2024-01-02T19:54:00Z 1 FALSE 00000000-0000-0000-0000-000000000000 2cd5cddd-8b98-4207-8ade-e9e160d761c1 72f09bae-20aa-ee11-a8ef-002248470496 SEND - Dinner - FOOD FOOD NA NA NA 2024-01-03T10:13:07.197Z 2024-01-03T10:13:07.197Z 20f09bae-20aa-ee11-a8ef-002248470496 3207
15 0af49bae-20aa-ee11-a8ef-002248470496 Blue Ridge Grill - Medium Well 0.00 2024-01-02T19:54:00Z 1 FALSE 00000000-0000-0000-0000-000000000000 2cd5cddd-8b98-4207-8ade-e9e160d761c1 72f09bae-20aa-ee11-a8ef-002248470496 SEND - Dinner - FOOD FOOD NA NA NA 2024-01-03T10:13:07.197Z 2024-01-03T10:13:07.197Z 20f09bae-20aa-ee11-a8ef-002248470496 3510
16 2bf49bae-20aa-ee11-a8ef-002248470496 Blue Ridge Grill - Oscar 23.00 2024-01-02T19:54:00Z 1 FALSE 00000000-0000-0000-0000-000000000000 2cd5cddd-8b98-4207-8ade-e9e160d761c1 72f09bae-20aa-ee11-a8ef-002248470496 SEND - Dinner - FOOD FOOD NA NA NA 2024-01-03T10:13:07.197Z 2024-01-03T10:13:07.197Z 20f09bae-20aa-ee11-a8ef-002248470496 3087
17 41f49bae-20aa-ee11-a8ef-002248470496 Blue Ridge Grill - Poached Salmon Dip 19.00 2024-01-02T19:54:00Z 1 FALSE 00000000-0000-0000-0000-000000000000 2cd5cddd-8b98-4207-8ade-e9e160d761c1 72f09bae-20aa-ee11-a8ef-002248470496 SEND - Dinner - FOOD FOOD NA NA NA 2024-01-03T10:13:07.197Z 2024-01-03T10:13:07.197Z 20f09bae-20aa-ee11-a8ef-002248470496 3149
18 dbf49bae-20aa-ee11-a8ef-002248470496 Blue Ridge Grill - TAX 25.10 2024-01-02T19:54:00Z 1 FALSE 00000000-0000-0000-0000-000000000000 2cd5cddd-8b98-4207-8ade-e9e160d761c1 72f09bae-20aa-ee11-a8ef-002248470496 SEND - Dinner - TAX TAX NA NA NA 2024-01-03T10:13:07.197Z 2024-01-03T10:13:07.197Z 20f09bae-20aa-ee11-a8ef-002248470496 3086
19 dcf49bae-20aa-ee11-a8ef-002248470496 Blue Ridge Grill - TAX 3.03 2024-01-02T19:54:00Z 1 FALSE 00000000-0000-0000-0000-000000000000 2cd5cddd-8b98-4207-8ade-e9e160d761c1 72f09bae-20aa-ee11-a8ef-002248470496 SEND - Dinner - TAX TAX NA NA NA 2024-01-03T10:13:07.197Z 2024-01-03T10:13:07.197Z 20f09bae-20aa-ee11-a8ef-002248470496 3086
20 9cf59bae-20aa-ee11-a8ef-002248470496 Blue Ridge Grill - W/Cold 0.00 2024-01-02T19:54:00Z 1 FALSE 00000000-0000-0000-0000-000000000000 2cd5cddd-8b98-4207-8ade-e9e160d761c1 72f09bae-20aa-ee11-a8ef-002248470496 SEND - Dinner - FOOD FOOD NA NA NA 2024-01-03T10:13:07.197Z 2024-01-03T10:13:07.197Z 20f09bae-20aa-ee11-a8ef-002248470496 3085
21 b9f59bae-20aa-ee11-a8ef-002248470496 Blue Ridge Grill - W/Hot 0.00 2024-01-02T19:54:00Z 1 FALSE 00000000-0000-0000-0000-000000000000 2cd5cddd-8b98-4207-8ade-e9e160d761c1 72f09bae-20aa-ee11-a8ef-002248470496 SEND - Dinner - FOOD FOOD NA NA NA 2024-01-03T10:13:07.197Z 2024-01-03T10:13:07.197Z 20f09bae-20aa-ee11-a8ef-002248470496 3558
22 d3f59bae-20aa-ee11-a8ef-002248470496 Blue Ridge Grill - Well Done 0.00 2024-01-02T19:54:00Z 1 FALSE 00000000-0000-0000-0000-000000000000 2cd5cddd-8b98-4207-8ade-e9e160d761c1 72f09bae-20aa-ee11-a8ef-002248470496 SEND - Dinner - FOOD FOOD NA NA NA 2024-01-03T10:13:07.197Z 2024-01-03T10:13:07.197Z 20f09bae-20aa-ee11-a8ef-002248470496 3568

Job Titles

document.id jobTitleId name description jobCode payRate payRate_Base posid glAccount_Id location_Id rating excludeFromSchedule excludeFromPOSImport createdBy createdOn modifiedBy modifiedOn
1 ba24fff8-b663-ee11-a8ec-002248470496 Server NA NA 0 NA 10 de417306-7c67-ee11-a8ec-002248470496 32a6eae8-7a87-40f1-aa06-c71633bb18e1 NA FALSE FALSE 2023-10-05T19:40:04.297Z Chris Biesiadecki 2023-11-20T16:42:29.897Z
2 bb24fff8-b663-ee11-a8ec-002248470496 Gen Managr NA NA 0 NA 51 cf417306-7c67-ee11-a8ec-002248470496 32a6eae8-7a87-40f1-aa06-c71633bb18e1 NA FALSE FALSE 2023-10-05T19:40:04.297Z Chris Biesiadecki 2023-11-20T16:43:59.983Z
3 bc24fff8-b663-ee11-a8ec-002248470496 Wine Stwrd NA NA 0 NA 25 ed417306-7c67-ee11-a8ec-002248470496 32a6eae8-7a87-40f1-aa06-c71633bb18e1 NA FALSE FALSE 2023-10-05T19:40:04.297Z Chris Biesiadecki 2023-11-20T16:40:11.683Z
4 bd24fff8-b663-ee11-a8ec-002248470496 Manager NA NA 0 NA 50 cf417306-7c67-ee11-a8ec-002248470496 32a6eae8-7a87-40f1-aa06-c71633bb18e1 NA FALSE FALSE 2023-10-05T19:40:04.297Z Chris Biesiadecki 2023-11-20T16:43:41.19Z
5 be24fff8-b663-ee11-a8ec-002248470496 Sous Chef NA NA 0 NA 36 cf417306-7c67-ee11-a8ec-002248470496 32a6eae8-7a87-40f1-aa06-c71633bb18e1 NA FALSE FALSE 2023-10-05T19:40:04.297Z Chris Biesiadecki 2023-11-20T16:42:05.53Z

Employees

document.id employeeId fullName address1 address2 allowTextMessaging birthdayDay birthdayMonth city firstName hireDate lastName middleName mobilePhone multipleLocations payrollID phoneNumber posid state zipCode employeeLink primaryLocation_id inactive email birthday createdBy createdOn modifiedBy modifiedOn
1 cc23fff8-b663-ee11-a8ec-002248470496 Aaron Pareigis NA NA NA Aaron 2001-01-03T00:00:00Z Pareigis NA 191 NA 191 NA 32a6eae8-7a87-40f1-aa06-c71633bb18e1 FALSE NA NA 2023-10-05T19:40:04.213Z 2023-10-05T19:40:04.213Z
2 cd23fff8-b663-ee11-a8ec-002248470496 Alexi Bagrov NA NA NA Alexi 2002-10-07T00:00:00Z Bagrov NA 594 NA 594 NA 32a6eae8-7a87-40f1-aa06-c71633bb18e1 FALSE NA NA 2023-10-05T19:40:04.213Z 2023-10-05T19:40:04.213Z
3 ce23fff8-b663-ee11-a8ec-002248470496 Ali Zarbashi NA NA NA Ali 2023-03-06T00:00:00Z Zarbashi NA 868 NA 868 NA 32a6eae8-7a87-40f1-aa06-c71633bb18e1 FALSE NA NA 2023-10-05T19:40:04.213Z 2023-10-05T19:40:04.213Z
4 cf23fff8-b663-ee11-a8ec-002248470496 Alom Ahmed NA NA NA Alom 2015-07-06T00:00:00Z Ahmed NA 270 NA 270 NA 32a6eae8-7a87-40f1-aa06-c71633bb18e1 FALSE NA NA 2023-10-05T19:40:04.213Z 2023-10-05T19:40:04.213Z
5 d023fff8-b663-ee11-a8ec-002248470496 AM Bar NA NA NA AM 2001-01-01T00:00:00Z Bar NA 123 NA 123 NA 32a6eae8-7a87-40f1-aa06-c71633bb18e1 FALSE NA NA 2023-10-05T19:40:04.213Z 2023-10-05T19:40:04.213Z

Labor Details

document.id laborId labor dateWorked endTime hours payRate payrate_Base payrollStatus startTime total total_Base employee_ID employeeJobTitle_ID jobTitle_ID location_ID cateringEvent tipDeclaredAmount employee payrollID jobTitle dateWorkedDateText location dailySalesSummaryId createdBy createdOn modifiedBy modifiedOn
1 660694e3-e9aa-ee11-a8ef-002248470496 NA 2024-01-02T00:00:00Z 2024-01-02T15:00:00Z 7.63 21 NA 0 2024-01-02T07:22:00Z 160.23 NA 7e9e896c-6164-ee11-a8ec-002248470496 e53ad12d-2b1a-4dff-badb-15ed3ea1f18d 4106d600-6064-ee11-a8ec-002248470496 2cd5cddd-8b98-4207-8ade-e9e160d761c1 NA 0 BALTAZAR DE LA PAZ 7694 Dish 2024-01-02T00:00:00Z Blue Ridge Grill 20f09bae-20aa-ee11-a8ef-002248470496 2024-01-04T10:13:32.18Z 2024-01-04T10:13:32.18Z
2 b70694e3-e9aa-ee11-a8ef-002248470496 NA 2024-01-03T00:00:00Z 2024-01-03T15:01:00Z 7.43 21 NA 0 2024-01-03T07:35:00Z 156.03 NA 7e9e896c-6164-ee11-a8ec-002248470496 e53ad12d-2b1a-4dff-badb-15ed3ea1f18d 4106d600-6064-ee11-a8ec-002248470496 2cd5cddd-8b98-4207-8ade-e9e160d761c1 NA 0 BALTAZAR DE LA PAZ 7694 Dish 2024-01-03T00:00:00Z Blue Ridge Grill ebec93e3-e9aa-ee11-a8ef-002248470496 2024-01-04T10:13:32.18Z 2024-01-04T10:13:32.18Z

Sales Payment

document.id salespaymentId name amount comment customerPOSText date isException missingreceipt company location paymenttype salesID houseAccountTransaction transactionDetailID cateringEvent exclude createdOn modifiedOn dailySalesSummaryId createdBy modifiedBy
1 60237f80-16aa-ee11-a8ef-002248470496 M/C - 54.08000 54.08 NA 2024-01-02T13:10:00Z FALSE NA NA f0808e2c-880a-426d-bb03-2db7a2bdc78e M/C 0e047f80-16aa-ee11-a8ef-002248470496 NA NA NA NA 2024-01-03T09:00:17.51Z 2024-01-03T09:00:17.51Z 9191457a-16aa-ee11-a8ef-002248470496
2 61237f80-16aa-ee11-a8ef-002248470496 Guest Taste - 7.99000 7.99 NA 2024-01-02T12:48:00Z FALSE NA NA f0808e2c-880a-426d-bb03-2db7a2bdc78e Guest Taste 0c047f80-16aa-ee11-a8ef-002248470496 NA NA NA NA 2024-01-03T09:00:17.51Z 2024-01-03T09:00:17.51Z 9191457a-16aa-ee11-a8ef-002248470496
3 62237f80-16aa-ee11-a8ef-002248470496 Server Error - 4.75000 4.75 NA 2024-01-02T12:15:00Z FALSE NA NA f0808e2c-880a-426d-bb03-2db7a2bdc78e Server Error 01047f80-16aa-ee11-a8ef-002248470496 NA NA NA NA 2024-01-03T09:00:17.51Z 2024-01-03T09:00:17.51Z 9191457a-16aa-ee11-a8ef-002248470496
4 63237f80-16aa-ee11-a8ef-002248470496 Guest Change - 10.49000 10.49 NA 2024-01-02T07:32:00Z FALSE NA NA f0808e2c-880a-426d-bb03-2db7a2bdc78e Guest Change 0c037f80-16aa-ee11-a8ef-002248470496 NA NA NA NA 2024-01-03T09:00:17.51Z 2024-01-03T09:00:17.51Z 9191457a-16aa-ee11-a8ef-002248470496
5 64237f80-16aa-ee11-a8ef-002248470496 Guest Change - 4.75000 4.75 NA 2024-01-02T12:58:00Z FALSE NA NA f0808e2c-880a-426d-bb03-2db7a2bdc78e Guest Change a9037f80-16aa-ee11-a8ef-002248470496 NA NA NA NA 2024-01-03T09:00:17.51Z 2024-01-03T09:00:17.51Z 9191457a-16aa-ee11-a8ef-002248470496

Items

document.id itemId name itemNumber category1 category2 category3 createdBy createdOn modifiedBy modifiedOn
1 4e05e2ff-076a-434c-a29f-00a7403569b3 PEPPER RED CRUSHED 958 Food Spices NA R365 2023-10-11T20:40:41.16Z R365 2024-01-03T23:54:36.723Z
2 95c493f1-4fe4-4136-bca1-00b388509747 TURKEY BREAST RAW 86 Food Poultry NA R365 2023-10-11T20:45:43.067Z R365 2024-01-03T23:55:40.417Z
3 14b51edf-19be-4e2f-860c-00c96013d666 MUSHROOM FRESH HEDGEHOG 8212 Food Produce NA R365 2023-10-11T20:23:08.93Z R365 2024-01-03T23:54:18.813Z
4 e291de1d-9493-4667-ae59-00e143f2cf66 PEPPER BLACK CRACKED 1025 Food Spices NA R365 2023-10-11T20:40:40.16Z R365 2024-01-03T23:54:35.803Z
5 e8f90974-7e51-4fe3-aec1-0153c13d9d5d LAMB RACK 1161 Food Meat NA R365 2023-10-11T20:23:05.543Z R365 2024-01-03T23:54:08.05Z
6 432d261c-ae68-4fa2-bd65-02df3728e9ec LOBSTER TAILS 2153 Food Seafood NA R365 2023-10-11T20:23:07.177Z R365 2024-01-03T23:54:13.66Z
7 b78e28ad-6929-4820-a40e-0334e84e217c HERB BASIL FRESH 99 Food Produce NA R365 2023-10-11T20:40:02.547Z R365 2024-01-03T23:53:55.653Z
8 513313ed-596b-4bb3-842d-03a385a47d94 MUSHROOMS CHEF MIX 184 Food Produce NA R365 2023-10-11T20:40:21.517Z R365 2024-01-03T23:54:19.513Z
9 e92d9396-5fdb-4092-bcd6-03c26f3946a4 SYRUP PANCAKE SUGAR FREE IND 3436 Food Groceries NA R365 2023-10-11T20:45:40.113Z R365 2024-01-03T23:55:30.12Z
10 277b26c9-f7f0-47c6-a3f0-04285eb51025 BREAD SOURDOUGH OBL 286 Food Baked NA R365 2023-10-11T20:38:32.743Z R365 2024-01-03T23:53:19.183Z

Payroll Summary