[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 280 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48080_33 | 4DC7-4772-87 | PO7656157590 | 100 | 282 | 337 | 403 | 4 | 2023-02-23 | 1879.18 | 46.98 | 2023-02-11 | 4 | 486.71 | 1 | 1879.18 | 33 | SO48080 | 2023-02-18 | 150.33 | 1946.83 | 469.79 | |||
SO44564_4 | 142F-443C-90 | PO7656157194 | 100 | 282 | 326 | 403 | 4 | 2022-02-23 | 419.46 | 10.49 | 2022-02-11 | 1 | 413.15 | 1 | 419.46 | 4 | SO44564 | 2022-02-18 | 33.56 | 413.15 | 419.46 | |||
SO71889_25 | 79BB-4639-B8 | PO6786144643 | 100 | 281 | 471 | 3 | 3 | 4 | 29.69 | 2024-09-23 | 593.73 | 14.10 | 2024-09-11 | 17 | 23.75 | 1 | 564.04 | 25 | SO71889 | 2024-09-18 | 45.12 | 403.73 | 34.93 | 0.05 |
SO45536_15 | 260C-4755-B2 | PO15167166424 | 100 | 283 | 328 | 273 | 4 | 2022-06-23 | 419.46 | 10.49 | 2022-06-11 | 1 | 413.15 | 1 | 419.46 | 15 | SO45536 | 2022-06-18 | 33.56 | 413.15 | 419.46 | |||
SO44787_17 | CFC8-46AC-A7 | PO5597180446 | 100 | 283 | 232 | 75 | 4 | 2022-03-25 | 173.04 | 4.33 | 2022-03-13 | 6 | 31.72 | 1 | 173.04 | 17 | SO44787 | 2022-03-20 | 13.84 | 190.35 | 28.84 | |||
SO48056_6 | 5868-43E3-AD | PO4843164827 | 100 | 287 | 453 | 257 | 4 | 2023-02-23 | 35.99 | 0.90 | 2023-02-11 | 1 | 24.75 | 1 | 35.99 | 6 | SO48056 | 2023-02-18 | 2.88 | 24.75 | 35.99 | |||
SO48769_2 | A39E-4380-A6 | PO7859190388 | 100 | 287 | 460 | 221 | 4 | 2023-04-25 | 161.98 | 4.05 | 2023-04-13 | 3 | 37.12 | 1 | 161.98 | 2 | SO48769 | 2023-04-20 | 12.96 | 111.36 | 53.99 | |||
SO48380_27 | 580B-4A1F-A4 | PO6757155119 | 100 | 283 | 394 | 21 | 4 | 2023-03-25 | 20.52 | 0.51 | 2023-03-13 | 1 | 15.18 | 1 | 20.52 | 27 | SO48380 | 2023-03-20 | 1.64 | 15.18 | 20.52 | |||
SO59049_4 | 7571-4CB5-B6 | PO174156394 | 100 | 282 | 482 | 277 | 4 | 2024-03-24 | 37.76 | 0.94 | 2024-03-12 | 7 | 3.36 | 1 | 37.76 | 4 | SO59049 | 2024-03-19 | 3.02 | 23.54 | 5.39 | |||
SO63180_20 | B8CD-47BA-8C | PO2523117609 | 100 | 287 | 482 | 167 | 4 | 2024-05-25 | 32.36 | 0.81 | 2024-05-13 | 6 | 3.36 | 1 | 32.36 | 20 | SO63180 | 2024-05-20 | 2.59 | 20.17 | 5.39 | |||
SO43913_2 | AD88-49ED-90 | PO7830112696 | 100 | 283 | 344 | 40 | 4 | 2021-11-23 | 4079.99 | 102.00 | 2021-11-11 | 2 | 1912.15 | 1 | 4079.99 | 2 | SO43913 | 2021-11-18 | 326.40 | 3824.31 | 2039.99 | |||
SO51773_18 | 14B1-48BF-A0 | PO2523163173 | 100 | 287 | 214 | 167 | 4 | 2023-11-23 | 62.98 | 1.57 | 2023-11-11 | 3 | 13.09 | 1 | 62.98 | 18 | SO51773 | 2023-11-18 | 5.04 | 39.26 | 20.99 | |||
SO65269_1 | 999D-45C9-AA | PO4640162431 | 100 | 287 | 591 | 648 | 4 | 2024-06-23 | 338.99 | 8.47 | 2024-06-11 | 1 | 308.22 | 1 | 338.99 | 1 | SO65269 | 2024-06-18 | 27.12 | 308.22 | 338.99 | |||
SO50688_37 | C55C-41B0-92 | PO10701178438 | 100 | 282 | 352 | 133 | 4 | 2023-09-23 | 6214.26 | 155.36 | 2023-09-11 | 5 | 1117.86 | 1 | 6214.26 | 37 | SO50688 | 2023-09-18 | 497.14 | 5589.28 | 1242.85 | |||
SO57134_20 | 040D-4B73-AD | PO6351190175 | 100 | 281 | 434 | 255 | 4 | 2024-02-23 | 356.90 | 8.92 | 2024-02-11 | 1 | 360.94 | 1 | 356.90 | 20 | SO57134 | 2024-02-18 | 28.55 | 360.94 | 356.90 | |||
SO47427_4 | 61AA-44CA-99 | PO4640137176 | 100 | 287 | 365 | 648 | 4 | 2022-12-24 | 1295.99 | 32.40 | 2022-12-12 | 2 | 598.44 | 1 | 1295.99 | 4 | SO47427 | 2022-12-19 | 103.68 | 1196.87 | 647.99 | |||
SO53580_25 | FFE9-4F36-B2 | PO4640164085 | 100 | 287 | 593 | 648 | 4 | 2023-12-24 | 677.99 | 16.95 | 2023-12-12 | 2 | 308.22 | 1 | 677.99 | 25 | SO53580 | 2023-12-19 | 54.24 | 616.44 | 338.99 | |||
SO43692_27 | BFA9-470E-B4 | PO7859187017 | 100 | 287 | 212 | 221 | 4 | 2021-10-23 | 80.75 | 2.02 | 2021-10-11 | 4 | 12.03 | 1 | 80.75 | 27 | SO43692 | 2021-10-18 | 6.46 | 48.11 | 20.19 | |||
SO69515_7 | D9C1-4837-A7 | PO6351170694 | 100 | 281 | 418 | 255 | 4 | 2024-08-23 | 1427.59 | 35.69 | 2024-08-11 | 4 | 360.94 | 1 | 1427.59 | 7 | SO69515 | 2024-08-18 | 114.21 | 1443.77 | 356.90 | |||
SO69505_6 | FE34-45B3-8D | PO5684197579 | 100 | 282 | 511 | 385 | 4 | 2024-08-23 | 218.45 | 5.46 | 2024-08-11 | 1 | 199.38 | 1 | 218.45 | 6 | SO69505 | 2024-08-18 | 17.48 | 199.38 | 218.45 | |||
SO47018_12 | E622-43B1-98 | PO2523197473 | 100 | 287 | 265 | 167 | 4 | 2022-11-23 | 202.33 | 5.06 | 2022-11-11 | 1 | 187.16 | 1 | 202.33 | 12 | SO47018 | 2022-11-18 | 16.19 | 187.16 | 202.33 | |||
SO43872_13 | 52FF-45CD-9B | PO12557127067 | 100 | 282 | 316 | 240 | 4 | 2021-11-23 | 874.79 | 21.87 | 2021-11-11 | 1 | 884.71 | 1 | 874.79 | 13 | SO43872 | 2021-11-18 | 69.98 | 884.71 | 874.79 | |||
SO50748_12 | 5FBE-4B52-B2 | PO6786143310 | 100 | 281 | 454 | 3 | 4 | 2023-09-23 | 179.97 | 4.50 | 2023-09-11 | 5 | 24.75 | 1 | 179.97 | 12 | SO50748 | 2023-09-18 | 14.40 | 123.73 | 35.99 | |||
SO45291_10 | 3865-4B93-A6 | PO15689110696 | 100 | 283 | 324 | 328 | 4 | 2022-05-26 | 1258.38 | 31.46 | 2022-05-14 | 3 | 413.15 | 1 | 1258.38 | 10 | SO45291 | 2022-05-21 | 100.67 | 1239.44 | 419.46 | |||
SO50658_1 | 9939-4D87-B1 | PO174172019 | 100 | 282 | 343 | 277 | 4 | 2023-09-23 | 1409.38 | 35.23 | 2023-09-11 | 3 | 486.71 | 1 | 1409.38 | 1 | SO50658 | 2023-09-18 | 112.75 | 1460.12 | 469.79 | |||
SO47400_43 | F0B3-44C1-8F | PO10701186775 | 100 | 282 | 399 | 133 | 4 | 2022-12-24 | 202.65 | 5.07 | 2022-12-12 | 6 | 24.99 | 1 | 202.65 | 43 | SO47400 | 2022-12-19 | 16.21 | 149.96 | 33.77 | |||
SO67287_23 | 3F1F-44DB-96 | PO10730119334 | 100 | 287 | 390 | 491 | 4 | 2024-07-24 | 3361.47 | 84.04 | 2024-07-12 | 5 | 713.08 | 1 | 3361.47 | 23 | SO67287 | 2024-07-19 | 268.92 | 3565.40 | 672.29 | |||
SO65209_5 | B869-4DFD-AB | PO2697179473 | 100 | 282 | 544 | 187 | 4 | 2024-06-23 | 97.19 | 2.43 | 2024-06-11 | 2 | 35.96 | 1 | 97.19 | 5 | SO65209 | 2024-06-18 | 7.78 | 71.92 | 48.59 | |||
SO46992_38 | C958-4FD6-A0 | PO11745117547 | 100 | 282 | 329 | 97 | 4 | 2022-11-23 | 1409.38 | 35.23 | 2022-11-11 | 3 | 486.71 | 1 | 1409.38 | 38 | SO46992 | 2022-11-18 | 112.75 | 1460.12 | 469.79 | |||
SO53470_23 | 932B-41E0-AF | PO17052111209 | 100 | 282 | 497 | 420 | 4 | 2023-12-24 | 602.35 | 15.06 | 2023-12-12 | 1 | 601.74 | 1 | 602.35 | 23 | SO53470 | 2023-12-19 | 48.19 | 601.74 | 602.35 |
Generated 2024-11-10 05:10:03.053 UTC