[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE < SKIP 357 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO47965_23 | 953F-437D-84 | PO19546111394 | 100 | 285 | 371 | 206 | 5 | 2023-02-23 | 3926.81 | 98.17 | 2023-02-11 | 3 | 1320.68 | 1 | 3926.81 | 23 | SO47965 | 2023-02-18 | 314.15 | 3962.05 | 1308.94 | |||
| SO55331_25 | 4195-4A79-A3 | PO9889143385 | 100 | 285 | 532 | 494 | 5 | 2024-01-23 | 149.87 | 3.75 | 2024-01-11 | 1 | 136.79 | 1 | 149.87 | 25 | SO55331 | 2024-01-18 | 11.99 | 136.79 | 149.87 | |||
| SO46056_15 | 4B9A-4022-AA | PO12586180466 | 100 | 285 | 296 | 278 | 5 | 2022-08-23 | 1429.41 | 35.74 | 2022-08-11 | 2 | 617.03 | 1 | 1429.41 | 15 | SO46056 | 2022-08-18 | 114.35 | 1234.06 | 714.70 | |||
| SO69513_15 | 21F8-4626-B9 | PO7598121355 | 100 | 285 | 547 | 45 | 5 | 2024-08-23 | 97.19 | 2.43 | 2024-08-11 | 2 | 35.96 | 1 | 97.19 | 15 | SO69513 | 2024-08-18 | 7.78 | 71.92 | 48.59 | |||
| SO44549_10 | 2479-4173-87 | PO5568135148 | 100 | 285 | 346 | 422 | 5 | 2022-02-23 | 8159.98 | 204.00 | 2022-02-11 | 4 | 1912.15 | 1 | 8159.98 | 10 | SO44549 | 2022-02-18 | 652.80 | 7648.62 | 2039.99 | |||
| SO59073_3 | 2631-471F-81 | PO9222113702 | 100 | 285 | 547 | 171 | 5 | 2024-03-24 | 48.59 | 1.21 | 2024-03-12 | 1 | 35.96 | 1 | 48.59 | 3 | SO59073 | 2024-03-19 | 3.89 | 35.96 | 48.59 | |||
| SO55331_5 | 4195-4A79-A3 | PO9889143385 | 100 | 285 | 511 | 494 | 5 | 2024-01-23 | 655.36 | 16.38 | 2024-01-11 | 3 | 199.38 | 1 | 655.36 | 5 | SO55331 | 2024-01-18 | 52.43 | 598.13 | 218.45 | |||
| SO47416_31 | 6B45-44AB-84 | PO2813155355 | 100 | 281 | 375 | 90 | 5 | 2022-12-24 | 3926.81 | 98.17 | 2022-12-12 | 3 | 1320.68 | 1 | 3926.81 | 31 | SO47416 | 2022-12-19 | 314.15 | 3962.05 | 1308.94 | |||
| SO59073_8 | 2631-471F-81 | PO9222113702 | 100 | 285 | 481 | 171 | 5 | 2024-03-24 | 26.97 | 0.67 | 2024-03-12 | 5 | 3.36 | 1 | 26.97 | 8 | SO59073 | 2024-03-19 | 2.16 | 16.81 | 5.39 | |||
| SO51864_6 | 2389-4E32-92 | PO5568126648 | 100 | 285 | 487 | 422 | 5 | 2023-11-23 | 98.98 | 2.47 | 2023-11-11 | 3 | 20.57 | 1 | 98.98 | 6 | SO51864 | 2023-11-18 | 7.92 | 61.70 | 32.99 | |||
| SO47414_2 | 945A-493D-BF | PO2407179130 | 100 | 285 | 424 | 225 | 5 | 2022-12-24 | 214.24 | 5.36 | 2022-12-12 | 1 | 158.53 | 1 | 214.24 | 2 | SO47414 | 2022-12-19 | 17.14 | 158.53 | 214.24 | |||
| SO45802_10 | 8C6D-42B3-AA | PO1189157476 | 100 | 285 | 334 | 423 | 5 | 2022-07-24 | 838.92 | 20.97 | 2022-07-12 | 2 | 413.15 | 1 | 838.92 | 10 | SO45802 | 2022-07-19 | 67.11 | 826.29 | 419.46 | |||
| SO55253_46 | C58B-49D8-9F | PO12644132539 | 100 | 285 | 597 | 530 | 5 | 2024-01-23 | 647.99 | 16.20 | 2024-01-11 | 2 | 294.58 | 1 | 647.99 | 46 | SO55253 | 2024-01-18 | 51.84 | 589.16 | 323.99 | |||
| SO49516_1 | 7B9E-45A8-89 | PO9106137121 | 100 | 285 | 396 | 602 | 5 | 2023-06-23 | 74.84 | 1.87 | 2023-06-11 | 1 | 55.38 | 1 | 74.84 | 1 | SO49516 | 2023-06-18 | 5.99 | 55.38 | 74.84 | |||
| SO61228_28 | 06C7-43A1-85 | PO9831151400 | 100 | 285 | 214 | 81 | 5 | 2024-04-24 | 41.99 | 1.05 | 2024-04-12 | 2 | 13.09 | 1 | 41.99 | 28 | SO61228 | 2024-04-19 | 3.36 | 26.17 | 20.99 | |||
| SO46056_18 | 4B9A-4022-AA | PO12586180466 | 100 | 285 | 347 | 278 | 5 | 2022-08-23 | 14279.96 | 357.00 | 2022-08-11 | 7 | 1912.15 | 1 | 14279.96 | 18 | SO46056 | 2022-08-18 | 1142.40 | 13385.08 | 2039.99 | |||
| SO51718_8 | 27D3-4968-89 | PO15051113417 | 100 | 285 | 234 | 207 | 5 | 2023-11-23 | 89.98 | 2.25 | 2023-11-11 | 3 | 38.49 | 1 | 89.98 | 8 | SO51718 | 2023-11-18 | 7.20 | 115.48 | 29.99 | |||
| SO46361_1 | 904E-4D86-AC | PO1943193225 | 100 | 285 | 322 | 525 | 5 | 2022-09-23 | 1258.38 | 31.46 | 2022-09-11 | 3 | 413.15 | 1 | 1258.38 | 1 | SO46361 | 2022-09-18 | 100.67 | 1239.44 | 419.46 | |||
| SO57149_6 | C32D-4E78-97 | PO5568130124 | 100 | 285 | 474 | 422 | 5 | 2024-02-23 | 251.96 | 6.30 | 2024-02-11 | 6 | 26.18 | 1 | 251.96 | 6 | SO57149 | 2024-02-18 | 20.16 | 157.06 | 41.99 | |||
| SO61230_24 | B9F1-4FF8-B4 | PO12644163346 | 100 | 285 | 544 | 530 | 5 | 2024-04-24 | 48.59 | 1.21 | 2024-04-12 | 1 | 35.96 | 1 | 48.59 | 24 | SO61230 | 2024-04-19 | 3.89 | 35.96 | 48.59 | |||
| SO55234_25 | C6FC-46EE-88 | PO522140495 | 100 | 285 | 544 | 676 | 5 | 2024-01-23 | 48.59 | 1.21 | 2024-01-11 | 1 | 35.96 | 1 | 48.59 | 25 | SO55234 | 2024-01-18 | 3.89 | 35.96 | 48.59 | |||
| SO63246_4 | 5008-4978-B3 | PO7598198768 | 100 | 285 | 382 | 45 | 5 | 2024-05-25 | 1344.59 | 33.61 | 2024-05-13 | 2 | 713.08 | 1 | 1344.59 | 4 | SO63246 | 2024-05-20 | 107.57 | 1426.16 | 672.29 | |||
| SO61173_19 | 6B8D-47B8-8E | PO522171689 | 100 | 285 | 217 | 676 | 5 | 2024-04-24 | 41.99 | 1.05 | 2024-04-12 | 2 | 13.09 | 1 | 41.99 | 19 | SO61173 | 2024-04-19 | 3.36 | 26.17 | 20.99 | |||
| SO45540_2 | B193-41A9-87 | PO13746118798 | 100 | 285 | 345 | 567 | 5 | 2022-06-23 | 8159.98 | 204.00 | 2022-06-11 | 4 | 1912.15 | 1 | 8159.98 | 2 | SO45540 | 2022-06-18 | 652.80 | 7648.62 | 2039.99 | |||
| SO53530_9 | A31D-483D-A1 | PO2813121313 | 100 | 283 | 490 | 3 | 90 | 5 | 23.76 | 2023-12-24 | 475.11 | 11.28 | 2023-12-12 | 16 | 41.57 | 1 | 451.36 | 9 | SO53530 | 2023-12-19 | 36.11 | 665.16 | 29.69 | 0.05 |
| SO53551_18 | 8593-405C-AB | PO14297167079 | 100 | 285 | 567 | 13 | 627 | 5 | 50.11 | 2023-12-24 | 334.06 | 7.10 | 2023-12-12 | 1 | 461.44 | 1 | 283.95 | 18 | SO53551 | 2023-12-19 | 22.72 | 461.44 | 334.06 | 0.15 |
| SO45288_22 | D4D0-4662-A9 | PO16327170541 | 100 | 285 | 310 | 584 | 5 | 2022-05-26 | 4293.92 | 107.35 | 2022-05-14 | 2 | 2171.29 | 1 | 4293.92 | 22 | SO45288 | 2022-05-21 | 343.51 | 4342.59 | 2146.96 | |||
| SO69465_13 | B8B2-4B14-99 | PO2842153886 | 100 | 285 | 604 | 700 | 5 | 2024-08-23 | 1295.98 | 32.40 | 2024-08-11 | 4 | 343.65 | 1 | 1295.98 | 13 | SO69465 | 2024-08-18 | 103.68 | 1374.60 | 323.99 |
Generated 2024-11-10 10:18:05.901 UTC