[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 5593 > < TAKE 31 >
31 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47422_8 | 9D8D-4481-B6 | PO3915123127 | 100 | 283 | 224 | 2 | 130 | 4 | 1.20 | 2022-12-24 | 60.16 | 1.47 | 2022-12-12 | 12 | 5.23 | 1 | 58.96 | 8 | SO47422 | 2022-12-19 | 4.72 | 62.76 | 5.01 | 0.02 |
SO47024_14 | F254-4053-A3 | PO3654136382 | 100 | 283 | 397 | 435 | 4 | 2022-11-23 | 121.47 | 3.04 | 2022-11-11 | 5 | 17.98 | 1 | 121.47 | 14 | SO47024 | 2022-11-18 | 9.72 | 89.89 | 24.29 | |||
SO44551_2 | 5A94-49FB-8D | PO5684111258 | 100 | 282 | 348 | 385 | 4 | 2022-02-23 | 6074.98 | 151.87 | 2022-02-11 | 3 | 1898.09 | 1 | 6074.98 | 2 | SO44551 | 2022-02-18 | 486.00 | 5694.28 | 2024.99 | |||
SO63285_11 | 6316-44BB-8E | PO3480176259 | 100 | 281 | 547 | 436 | 4 | 2024-05-25 | 97.19 | 2.43 | 2024-05-13 | 2 | 35.96 | 1 | 97.19 | 11 | SO63285 | 2024-05-20 | 7.78 | 71.92 | 48.59 | |||
SO44790_1 | C8CF-4ECD-A1 | PO5974142949 | 100 | 282 | 328 | 330 | 4 | 2022-03-25 | 838.92 | 20.97 | 2022-03-13 | 2 | 413.15 | 1 | 838.92 | 1 | SO44790 | 2022-03-20 | 67.11 | 826.29 | 419.46 | |||
SO45813_10 | 36A5-446C-96 | PO7859120230 | 100 | 287 | 319 | 221 | 4 | 2022-07-24 | 4373.97 | 109.35 | 2022-07-12 | 5 | 884.71 | 1 | 4373.97 | 10 | SO45813 | 2022-07-19 | 349.92 | 4423.54 | 874.79 | |||
SO47372_11 | 70B5-428B-86 | PO16124198007 | 100 | 282 | 323 | 649 | 4 | 2022-12-24 | 1409.38 | 35.23 | 2022-12-12 | 3 | 486.71 | 1 | 1409.38 | 11 | SO47372 | 2022-12-19 | 112.75 | 1460.12 | 469.79 | |||
SO47687_31 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 233 | 203 | 4 | 2023-01-23 | 144.20 | 3.61 | 2023-01-11 | 5 | 29.08 | 1 | 144.20 | 31 | SO47687 | 2023-01-18 | 11.54 | 145.40 | 28.84 | |||
SO48049_30 | C09A-49F5-80 | PO3799136256 | 100 | 282 | 362 | 312 | 4 | 2023-02-23 | 3688.38 | 92.21 | 2023-02-11 | 3 | 1105.81 | 1 | 3688.38 | 30 | SO48049 | 2023-02-18 | 295.07 | 3317.43 | 1229.46 | |||
SO61218_40 | 8441-4C6F-89 | PO13688193778 | 100 | 282 | 237 | 475 | 4 | 2024-04-24 | 89.98 | 2.25 | 2024-04-12 | 3 | 38.49 | 1 | 89.98 | 40 | SO61218 | 2024-04-19 | 7.20 | 115.48 | 29.99 | |||
SO44127_7 | E778-471D-8A | PO7569162058 | 100 | 287 | 351 | 608 | 4 | 2021-12-24 | 6074.98 | 151.87 | 2021-12-12 | 3 | 1898.09 | 1 | 6074.98 | 7 | SO44127 | 2021-12-19 | 486.00 | 5694.28 | 2024.99 | |||
SO53621_29 | 9324-4A3D-83 | PO9715186811 | 100 | 281 | 513 | 490 | 4 | 2023-12-24 | 655.36 | 16.38 | 2023-12-12 | 3 | 199.38 | 1 | 655.36 | 29 | SO53621 | 2023-12-19 | 52.43 | 598.13 | 218.45 | |||
SO55233_10 | 1590-499E-95 | PO551184455 | 100 | 281 | 434 | 4 | 4 | 2024-01-23 | 2141.39 | 53.53 | 2024-01-11 | 6 | 360.94 | 1 | 2141.39 | 10 | SO55233 | 2024-01-18 | 171.31 | 2165.66 | 356.90 | |||
SO51131_42 | D489-4DF3-A2 | PO16298169856 | 100 | 287 | 487 | 599 | 4 | 2023-10-23 | 197.96 | 4.95 | 2023-10-11 | 6 | 20.57 | 1 | 197.96 | 42 | SO51131 | 2023-10-18 | 15.84 | 123.40 | 32.99 | |||
SO45060_11 | 39B0-42BB-92 | PO10817172372 | 100 | 287 | 336 | 203 | 4 | 2022-04-25 | 419.46 | 10.49 | 2022-04-13 | 1 | 413.15 | 1 | 419.46 | 11 | SO45060 | 2022-04-20 | 33.56 | 413.15 | 419.46 | |||
SO53586_6 | 37CB-4A82-96 | PO4002170204 | 100 | 282 | 234 | 674 | 4 | 2023-12-24 | 89.98 | 2.25 | 2023-12-12 | 3 | 38.49 | 1 | 89.98 | 6 | SO53586 | 2023-12-19 | 7.20 | 115.48 | 29.99 | |||
SO46660_17 | CF24-45E2-9D | PO5626129733 | 100 | 283 | 245 | 166 | 4 | 2022-10-23 | 3123.27 | 78.08 | 2022-10-11 | 4 | 722.26 | 1 | 3123.27 | 17 | SO46660 | 2022-10-18 | 249.86 | 2889.03 | 780.82 | |||
SO46057_25 | 6F2B-45A4-9C | PO12499164653 | 100 | 282 | 316 | 78 | 4 | 2022-08-23 | 5248.76 | 131.22 | 2022-08-11 | 6 | 884.71 | 1 | 5248.76 | 25 | SO46057 | 2022-08-18 | 419.90 | 5308.25 | 874.79 | |||
SO44757_7 | C27A-4D15-8C | PO14964184059 | 100 | 287 | 293 | 581 | 4 | 2022-03-25 | 722.59 | 18.06 | 2022-03-13 | 1 | 623.84 | 1 | 722.59 | 7 | SO44757 | 2022-03-20 | 57.81 | 623.84 | 722.59 | |||
SO44290_4 | 5A38-4334-8E | PO14413160229 | 100 | 287 | 326 | 383 | 4 | 2022-01-23 | 1258.38 | 31.46 | 2022-01-11 | 3 | 413.15 | 1 | 1258.38 | 4 | SO44290 | 2022-01-18 | 100.67 | 1239.44 | 419.46 | |||
SO44120_7 | E001-437D-A1 | PO5597155510 | 100 | 283 | 349 | 75 | 4 | 2021-12-24 | 6074.98 | 151.87 | 2021-12-12 | 3 | 1898.09 | 1 | 6074.98 | 7 | SO44120 | 2021-12-19 | 486.00 | 5694.28 | 2024.99 | |||
SO50292_4 | E329-4164-85 | PO3654177485 | 100 | 281 | 308 | 435 | 4 | 2023-08-23 | 1488.55 | 37.21 | 2023-08-11 | 2 | 660.91 | 1 | 1488.55 | 4 | SO50292 | 2023-08-18 | 119.08 | 1321.83 | 744.27 | |||
SO46638_19 | 9659-44CE-A2 | PO10817110834 | 100 | 287 | 383 | 203 | 4 | 2022-10-23 | 1800.79 | 45.02 | 2022-10-11 | 3 | 605.65 | 1 | 1800.79 | 19 | SO46638 | 2022-10-18 | 144.06 | 1816.95 | 600.26 | |||
SO44768_14 | 18BD-48B8-95 | PO261164909 | 100 | 283 | 253 | 647 | 4 | 2022-03-25 | 178.58 | 4.46 | 2022-03-13 | 1 | 176.20 | 1 | 178.58 | 14 | SO44768 | 2022-03-20 | 14.29 | 176.20 | 178.58 | |||
SO49541_22 | B736-4142-A1 | PO7569133326 | 100 | 287 | 360 | 608 | 4 | 2023-06-23 | 4917.84 | 122.95 | 2023-06-11 | 4 | 1105.81 | 1 | 4917.84 | 22 | SO49541 | 2023-06-18 | 393.43 | 4423.24 | 1229.46 | |||
SO50745_28 | 02DB-4CC5-85 | PO5539140407 | 100 | 282 | 233 | 61 | 4 | 2023-09-23 | 115.36 | 2.88 | 2023-09-11 | 4 | 29.08 | 1 | 115.36 | 28 | SO50745 | 2023-09-18 | 9.23 | 116.32 | 28.84 | |||
SO53586_8 | 37CB-4A82-96 | PO4002170204 | 100 | 282 | 471 | 674 | 4 | 2023-12-24 | 76.20 | 1.91 | 2023-12-12 | 2 | 23.75 | 1 | 76.20 | 8 | SO53586 | 2023-12-19 | 6.10 | 47.50 | 38.10 | |||
SO49152_14 | 52FC-4E8F-B0 | PO6525119586 | 100 | 272 | 308 | 345 | 4 | 2023-05-26 | 744.27 | 18.61 | 2023-05-14 | 1 | 660.91 | 1 | 744.27 | 14 | SO49152 | 2023-05-21 | 59.54 | 660.91 | 744.27 | |||
SO47056_12 | 53BF-4950-9E | PO7656118289 | 100 | 282 | 254 | 403 | 4 | 2022-11-23 | 551.81 | 13.80 | 2022-11-11 | 3 | 170.14 | 1 | 551.81 | 12 | SO47056 | 2022-11-18 | 44.15 | 510.43 | 183.94 | |||
SO47355_26 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 267 | 24 | 4 | 2022-12-24 | 202.33 | 5.06 | 2022-12-12 | 1 | 187.16 | 1 | 202.33 | 26 | SO47355 | 2022-12-19 | 16.19 | 187.16 | 202.33 | |||
SO65315_28 | 0FFB-4EB5-A3 | PO6757194680 | 100 | 281 | 353 | 21 | 4 | 2024-06-23 | 2783.99 | 69.60 | 2024-06-11 | 2 | 1265.62 | 1 | 2783.99 | 28 | SO65315 | 2024-06-18 | 222.72 | 2531.24 | 1391.99 |
Generated 2024-11-10 16:12:56.116 UTC