[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 907 > < TAKE 30 >
30 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimPromotionId | DimResellerId | DimSalesTerritoryId | DiscountAmount | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice | UnitPriceDiscountPct |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46608_51 | ACF1-4852-B7 | PO18473177913 | 19 | 291 | 216 | 8 | 442 | 6 | 16.82 | 2022-09-01 | 168.22 | 3.79 | 2022-08-20 | 10 | 13.88 | 1 | 151.40 | 51 | SO46608 | 2022-08-27 | 12.11 | 138.78 | 16.82 | 0.10 |
SO63174_15 | 0B72-4270-AC | PO1827182060 | 19 | 291 | 483 | 317 | 6 | 2024-04-03 | 504.00 | 12.60 | 2024-03-22 | 7 | 44.88 | 1 | 504.00 | 15 | SO63174 | 2024-03-29 | 40.32 | 314.16 | 72.00 | |||
SO59022_1 | F672-4E69-A9 | PO7366189433 | 19 | 284 | 522 | 372 | 6 | 2024-02-01 | 23.48 | 0.59 | 2024-01-20 | 1 | 17.38 | 1 | 23.48 | 1 | SO59022 | 2024-01-27 | 1.88 | 17.38 | 23.48 | |||
SO46029_3 | 7E04-4600-81 | PO19227152145 | 19 | 284 | 328 | 210 | 6 | 2022-07-02 | 419.46 | 10.49 | 2022-06-20 | 1 | 413.15 | 1 | 419.46 | 3 | SO46029 | 2022-06-27 | 33.56 | 413.15 | 419.46 | |||
SO47670_56 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 457 | 514 | 6 | 2022-12-02 | 179.98 | 4.50 | 2022-11-20 | 4 | 30.93 | 1 | 179.98 | 56 | SO47670 | 2022-11-27 | 14.40 | 123.73 | 44.99 | |||
SO69448_3 | 26BF-4CA1-97 | PO11020118669 | 19 | 284 | 436 | 336 | 6 | 2024-07-02 | 356.90 | 8.92 | 2024-06-20 | 1 | 360.94 | 1 | 356.90 | 3 | SO69448 | 2024-06-27 | 28.55 | 360.94 | 356.90 | |||
SO65235_17 | 0A92-4A75-90 | PO10962154595 | 19 | 284 | 532 | 685 | 6 | 2024-05-02 | 149.87 | 3.75 | 2024-04-20 | 1 | 136.79 | 1 | 149.87 | 17 | SO65235 | 2024-04-27 | 11.99 | 136.79 | 149.87 | |||
SO48059_38 | E21D-4968-B0 | PO4901134783 | 19 | 284 | 230 | 84 | 6 | 2023-01-02 | 201.88 | 5.05 | 2022-12-21 | 7 | 29.08 | 1 | 201.88 | 38 | SO48059 | 2022-12-28 | 16.15 | 203.56 | 28.84 | |||
SO67302_36 | E4B2-462D-AC | PO18473194134 | 19 | 291 | 290 | 442 | 6 | 2024-06-02 | 1637.40 | 40.94 | 2024-05-21 | 2 | 747.20 | 1 | 1637.40 | 36 | SO67302 | 2024-05-28 | 130.99 | 1494.40 | 818.70 | |||
SO59037_1 | 6750-45BB-93 | PO2233187258 | 19 | 291 | 482 | 3 | 262 | 6 | 4.20 | 2024-02-01 | 84.06 | 2.00 | 2024-01-20 | 17 | 3.36 | 1 | 79.85 | 1 | SO59037 | 2024-01-27 | 6.39 | 57.16 | 4.94 | 0.05 |
SO50677_3 | FA6C-40A6-9B | PO14239119929 | 19 | 291 | 224 | 550 | 6 | 2023-08-02 | 31.12 | 0.78 | 2023-07-21 | 6 | 5.23 | 1 | 31.12 | 3 | SO50677 | 2023-07-28 | 2.49 | 31.38 | 5.19 | |||
SO51698_9 | C8C8-43A4-AC | PO19227173300 | 19 | 284 | 487 | 210 | 6 | 2023-10-02 | 65.99 | 1.65 | 2023-09-20 | 2 | 20.57 | 1 | 65.99 | 9 | SO51698 | 2023-09-27 | 5.28 | 41.13 | 32.99 | |||
SO44744_22 | 6D80-4E9D-83 | PO19401124443 | 19 | 288 | 212 | 173 | 6 | 2022-02-01 | 20.19 | 0.50 | 2022-01-20 | 1 | 12.03 | 1 | 20.19 | 22 | SO44744 | 2022-01-27 | 1.61 | 12.03 | 20.19 | |||
SO45305_16 | AC1B-4242-9C | PO11600132440 | 19 | 288 | 285 | 569 | 6 | 2022-04-04 | 357.16 | 8.93 | 2022-03-23 | 2 | 176.20 | 1 | 357.16 | 16 | SO45305 | 2022-03-30 | 28.57 | 352.40 | 178.58 | |||
SO47415_10 | 4C47-41C8-B0 | PO2233131382 | 19 | 291 | 422 | 262 | 6 | 2022-11-02 | 270.16 | 6.75 | 2022-10-21 | 4 | 49.98 | 1 | 270.16 | 10 | SO47415 | 2022-10-28 | 21.61 | 199.92 | 67.54 | |||
SO49839_5 | 3123-41F3-9B | PO10527179463 | 19 | 284 | 343 | 480 | 6 | 2023-06-02 | 1409.38 | 35.23 | 2023-05-21 | 3 | 486.71 | 1 | 1409.38 | 5 | SO49839 | 2023-05-28 | 112.75 | 1460.12 | 469.79 | |||
SO71830_5 | DA2D-4B00-A4 | PO10875112195 | 19 | 291 | 499 | 281 | 6 | 2024-08-02 | 1204.69 | 30.12 | 2024-07-21 | 2 | 601.74 | 1 | 1204.69 | 5 | SO71830 | 2024-07-28 | 96.38 | 1203.49 | 602.35 | |||
SO46614_37 | 0B65-4374-89 | PO15312137226 | 19 | 291 | 453 | 299 | 6 | 2022-09-01 | 179.97 | 4.50 | 2022-08-20 | 5 | 24.75 | 1 | 179.97 | 37 | SO46614 | 2022-08-27 | 14.40 | 123.73 | 35.99 | |||
SO61204_11 | E810-4164-82 | PO15312134209 | 19 | 291 | 484 | 299 | 6 | 2024-03-03 | 19.08 | 0.48 | 2024-02-20 | 4 | 2.97 | 1 | 19.08 | 11 | SO61204 | 2024-02-27 | 1.53 | 11.89 | 4.77 | |||
SO71781_22 | 2FB9-4F05-82 | PO19401117806 | 19 | 291 | 482 | 173 | 6 | 2024-08-02 | 26.97 | 0.67 | 2024-07-21 | 5 | 3.36 | 1 | 26.97 | 22 | SO71781 | 2024-07-28 | 2.16 | 16.81 | 5.39 | |||
SO53465_68 | D859-4DF3-84 | PO17574192592 | 19 | 272 | 526 | 678 | 6 | 2023-11-02 | 475.29 | 11.88 | 2023-10-21 | 3 | 144.59 | 1 | 475.29 | 68 | SO53465 | 2023-10-28 | 38.02 | 433.78 | 158.43 | |||
SO69560_6 | B1B6-43F4-BC | PO9077167302 | 19 | 291 | 589 | 100 | 6 | 2024-07-02 | 923.39 | 23.08 | 2024-06-20 | 2 | 419.78 | 1 | 923.39 | 6 | SO69560 | 2024-06-27 | 73.87 | 839.56 | 461.69 | |||
SO45800_2 | 5B67-4FE2-B9 | PO10527156525 | 19 | 284 | 315 | 480 | 6 | 2022-06-02 | 3499.18 | 87.48 | 2022-05-21 | 4 | 884.71 | 1 | 3499.18 | 2 | SO45800 | 2022-05-28 | 279.93 | 3538.83 | 874.79 | |||
SO71841_17 | 1544-4561-AB | PO1798133189 | 19 | 291 | 477 | 10 | 6 | 2024-08-02 | 2.99 | 0.07 | 2024-07-21 | 1 | 1.87 | 1 | 2.99 | 17 | SO71841 | 2024-07-28 | 0.24 | 1.87 | 2.99 | |||
SO53456_18 | 9F7E-451F-8E | PO19401178762 | 19 | 291 | 547 | 173 | 6 | 2023-11-02 | 242.97 | 6.07 | 2023-10-21 | 5 | 35.96 | 1 | 242.97 | 18 | SO53456 | 2023-10-28 | 19.44 | 179.80 | 48.59 | |||
SO71871_6 | DD8F-4CAB-A1 | PO14239120760 | 19 | 291 | 483 | 550 | 6 | 2024-08-02 | 144.00 | 3.60 | 2024-07-21 | 2 | 44.88 | 1 | 144.00 | 6 | SO71871 | 2024-07-28 | 11.52 | 89.76 | 72.00 | |||
SO47008_12 | FD36-4D89-AB | PO1595170889 | 19 | 284 | 271 | 426 | 6 | 2022-10-02 | 404.66 | 10.12 | 2022-09-20 | 2 | 187.16 | 1 | 404.66 | 12 | SO47008 | 2022-09-27 | 32.37 | 374.31 | 202.33 | |||
SO43886_21 | CE58-49B5-82 | PO1827149671 | 19 | 288 | 232 | 317 | 6 | 2021-10-02 | 115.36 | 2.88 | 2021-09-20 | 4 | 31.72 | 1 | 115.36 | 21 | SO43886 | 2021-09-27 | 9.23 | 126.90 | 28.84 | |||
SO65156_13 | 3295-4FC6-BC | PO19401176373 | 19 | 291 | 581 | 173 | 6 | 2024-05-02 | 1020.59 | 25.51 | 2024-04-20 | 1 | 1082.51 | 1 | 1020.59 | 13 | SO65156 | 2024-04-27 | 81.65 | 1082.51 | 1020.59 | |||
SO46071_9 | 1563-4F33-9D | PO1827148074 | 19 | 288 | 212 | 317 | 6 | 2022-07-02 | 100.93 | 2.52 | 2022-06-20 | 5 | 12.03 | 1 | 100.93 | 9 | SO46071 | 2022-06-27 | 8.07 | 60.14 | 20.19 |
Generated 2024-09-20 02:46:37.730 UTC