[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE < SKIP 7002 > < TAKE 28 >
28 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO57030_36 | 373C-4C0F-88 | PO16414180321 | 100 | 289 | 290 | 236 | 1 | 2024-02-23 | 818.70 | 20.47 | 2024-02-11 | 1 | 747.20 | 1 | 818.70 | 36 | SO57030 | 2024-02-18 | 65.50 | 747.20 | 818.70 | |||
SO69408_39 | 8DF5-4377-9D | PO16414161428 | 100 | 289 | 599 | 236 | 1 | 2024-08-23 | 647.99 | 16.20 | 2024-08-11 | 2 | 294.58 | 1 | 647.99 | 39 | SO69408 | 2024-08-18 | 51.84 | 589.16 | 323.99 | |||
SO58961_3 | 0848-4E9B-81 | PO10411162031 | 100 | 289 | 601 | 182 | 1 | 2024-03-24 | 97.18 | 2.43 | 2024-03-12 | 3 | 23.97 | 1 | 97.18 | 3 | SO58961 | 2024-03-19 | 7.77 | 71.91 | 32.39 | |||
SO59010_31 | 2350-42CD-B1 | PO6815132533 | 100 | 293 | 357 | 109 | 1 | 2024-03-24 | 1391.99 | 34.80 | 2024-03-12 | 1 | 1265.62 | 1 | 1391.99 | 31 | SO59010 | 2024-03-19 | 111.36 | 1265.62 | 1391.99 | |||
SO50241_1 | ACB7-4116-A8 | PO18908114626 | 100 | 289 | 459 | 164 | 1 | 2023-08-23 | 107.99 | 2.70 | 2023-08-11 | 2 | 37.12 | 1 | 107.99 | 1 | SO50241 | 2023-08-18 | 8.64 | 74.24 | 53.99 | |||
SO59065_1 | C012-48E8-A5 | PO8903194371 | 100 | 293 | 483 | 235 | 1 | 2024-03-24 | 288.00 | 7.20 | 2024-03-12 | 4 | 44.88 | 1 | 288.00 | 1 | SO59065 | 2024-03-19 | 23.04 | 179.52 | 72.00 | |||
SO50314_14 | 5D9A-4B55-81 | PO7627146177 | 100 | 293 | 371 | 433 | 1 | 2023-08-23 | 1308.94 | 32.72 | 2023-08-11 | 1 | 1320.68 | 1 | 1308.94 | 14 | SO50314 | 2023-08-18 | 104.72 | 1320.68 | 1308.94 | |||
SO46967_13 | 6486-4AF8-A6 | PO15573116583 | 100 | 286 | 459 | 487 | 1 | 2022-11-23 | 53.99 | 1.35 | 2022-11-11 | 1 | 37.12 | 1 | 53.99 | 13 | SO46967 | 2022-11-18 | 4.32 | 37.12 | 53.99 | |||
SO59066_10 | 9FAA-410F-AB | PO9309141643 | 100 | 293 | 559 | 55 | 1 | 2024-03-24 | 24.29 | 0.61 | 2024-03-12 | 2 | 8.99 | 1 | 24.29 | 10 | SO59066 | 2024-03-19 | 1.94 | 17.97 | 12.14 | |||
SO61199_13 | EFA0-4D12-A2 | PO2552199779 | 100 | 286 | 353 | 506 | 1 | 2024-04-24 | 1391.99 | 34.80 | 2024-04-12 | 1 | 1265.62 | 1 | 1391.99 | 13 | SO61199 | 2024-04-19 | 111.36 | 1265.62 | 1391.99 | |||
SO69406_41 | E101-486C-A5 | PO16675181672 | 100 | 293 | 577 | 361 | 1 | 2024-08-23 | 1457.82 | 36.45 | 2024-08-11 | 2 | 755.15 | 1 | 1457.82 | 41 | SO69406 | 2024-08-18 | 116.63 | 1510.30 | 728.91 | |||
SO51783_41 | B7A2-49BC-89 | PO18676114917 | 100 | 282 | 474 | 4 | 697 | 1 | 139.98 | 2023-11-23 | 1399.80 | 31.50 | 2023-11-11 | 40 | 26.18 | 1 | 1259.82 | 41 | SO51783 | 2023-11-18 | 100.79 | 1047.05 | 35.00 | 0.10 |
SO44492_17 | 8AF8-4DDE-A8 | PO18676158978 | 100 | 282 | 215 | 697 | 1 | 2022-02-23 | 40.37 | 1.01 | 2022-02-11 | 2 | 12.03 | 1 | 40.37 | 17 | SO44492 | 2022-02-18 | 3.23 | 24.06 | 20.19 | |||
SO49826_23 | 2EBD-4312-9C | PO16588178669 | 100 | 289 | 366 | 146 | 1 | 2023-07-24 | 3239.97 | 81.00 | 2023-07-12 | 5 | 598.44 | 1 | 3239.97 | 23 | SO49826 | 2023-07-19 | 259.20 | 2992.18 | 647.99 | |||
SO50206_24 | 7656-4E84-B8 | PO16414158832 | 100 | 289 | 362 | 236 | 1 | 2023-08-23 | 2458.92 | 61.47 | 2023-08-11 | 2 | 1105.81 | 1 | 2458.92 | 24 | SO50206 | 2023-08-18 | 196.71 | 2211.62 | 1229.46 | |||
SO49092_35 | 72CE-4E29-82 | PO14442163644 | 100 | 293 | 458 | 127 | 1 | 2023-05-26 | 224.97 | 5.62 | 2023-05-14 | 5 | 30.93 | 1 | 224.97 | 35 | SO49092 | 2023-05-21 | 18.00 | 154.67 | 44.99 | |||
SO47054_15 | E4B1-4C58-AE | PO7627150376 | 100 | 286 | 373 | 433 | 1 | 2022-11-23 | 1308.94 | 32.72 | 2022-11-11 | 1 | 1320.68 | 1 | 1308.94 | 15 | SO47054 | 2022-11-18 | 104.72 | 1320.68 | 1308.94 | |||
SO65159_15 | DDDD-4736-9B | PO19169187435 | 100 | 289 | 363 | 272 | 1 | 2024-06-23 | 1376.99 | 34.42 | 2024-06-11 | 1 | 1251.98 | 1 | 1376.99 | 15 | SO65159 | 2024-06-18 | 110.16 | 1251.98 | 1376.99 | |||
SO59021_30 | A306-4E83-B7 | PO7395154426 | 100 | 286 | 400 | 542 | 1 | 2024-03-24 | 37.15 | 0.93 | 2024-03-12 | 1 | 27.49 | 1 | 37.15 | 30 | SO59021 | 2024-03-19 | 2.97 | 27.49 | 37.15 | |||
SO57105_32 | 3AE1-4A72-91 | PO18676113963 | 100 | 282 | 593 | 697 | 1 | 2024-02-23 | 1016.98 | 25.42 | 2024-02-11 | 3 | 308.22 | 1 | 1016.98 | 32 | SO57105 | 2024-02-18 | 81.36 | 924.65 | 338.99 | |||
SO47033_2 | 2797-46ED-BB | PO4727113716 | 100 | 286 | 435 | 343 | 1 | 2022-11-23 | 324.45 | 8.11 | 2022-11-11 | 1 | 300.12 | 1 | 324.45 | 2 | SO47033 | 2022-11-18 | 25.96 | 300.12 | 324.45 | |||
SO45542_9 | A757-4830-AE | PO13543153598 | 100 | 287 | 296 | 293 | 1 | 2022-06-23 | 714.70 | 17.87 | 2022-06-11 | 1 | 617.03 | 1 | 714.70 | 9 | SO45542 | 2022-06-18 | 57.18 | 617.03 | 714.70 | |||
SO57105_7 | 3AE1-4A72-91 | PO18676113963 | 100 | 282 | 298 | 697 | 1 | 2024-02-23 | 3239.04 | 80.98 | 2024-02-11 | 4 | 739.04 | 1 | 3239.04 | 7 | SO57105 | 2024-02-18 | 259.12 | 2956.16 | 809.76 | |||
SO69475_41 | F74A-4967-BA | PO18618162557 | 100 | 286 | 490 | 605 | 1 | 2024-08-23 | 64.79 | 1.62 | 2024-08-11 | 2 | 41.57 | 1 | 64.79 | 41 | SO69475 | 2024-08-18 | 5.18 | 83.14 | 32.39 | |||
SO59021_3 | A306-4E83-B7 | PO7395154426 | 100 | 286 | 544 | 542 | 1 | 2024-03-24 | 97.19 | 2.43 | 2024-03-12 | 2 | 35.96 | 1 | 97.19 | 3 | SO59021 | 2024-03-19 | 7.78 | 71.92 | 48.59 | |||
SO45344_17 | 166F-4C74-85 | PO8816179390 | 100 | 289 | 232 | 218 | 1 | 2022-05-26 | 173.04 | 4.33 | 2022-05-14 | 6 | 31.72 | 1 | 173.04 | 17 | SO45344 | 2022-05-21 | 13.84 | 190.35 | 28.84 | |||
SO50693_40 | 0DA5-4EE4-93 | PO841149385 | 100 | 286 | 462 | 254 | 1 | 2023-09-23 | 56.52 | 1.41 | 2023-09-11 | 4 | 9.71 | 1 | 56.52 | 40 | SO50693 | 2023-09-18 | 4.52 | 38.85 | 14.13 | |||
SO49464_1 | C383-45FE-83 | PO841195010 | 100 | 286 | 366 | 254 | 1 | 2023-06-23 | 647.99 | 16.20 | 2023-06-11 | 1 | 598.44 | 1 | 647.99 | 1 | SO49464 | 2023-06-18 | 51.84 | 598.44 | 647.99 |
Generated 2024-11-11 03:19:36.216 UTC