[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 592 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO69417_10 | 6746-4842-AD | PO15196165910 | 100 | 282 | 382 | 258 | 4 | 2024-07-04 | 672.29 | 16.81 | 2024-06-22 | 1 | 713.08 | 1 | 672.29 | 10 | SO69417 | 2024-06-29 | 53.78 | 713.08 | 672.29 | |||
SO45339_12 | 1F94-40D0-86 | PO7656113434 | 100 | 282 | 317 | 403 | 4 | 2022-04-06 | 1749.59 | 43.74 | 2022-03-25 | 2 | 884.71 | 1 | 1749.59 | 12 | SO45339 | 2022-04-01 | 139.97 | 1769.42 | 874.79 | |||
SO71901_4 | A2D5-443F-A5 | PO3886195400 | 100 | 281 | 390 | 165 | 4 | 2024-08-04 | 672.29 | 16.81 | 2024-07-23 | 1 | 713.08 | 1 | 672.29 | 4 | SO71901 | 2024-07-30 | 53.78 | 713.08 | 672.29 | |||
SO47400_48 | F0B3-44C1-8F | PO10701186775 | 100 | 282 | 362 | 133 | 4 | 2022-11-04 | 9835.67 | 245.89 | 2022-10-23 | 8 | 1105.81 | 1 | 9835.67 | 48 | SO47400 | 2022-10-30 | 786.85 | 8846.48 | 1229.46 | |||
SO48375_14 | B5F1-4C2A-94 | PO5597156214 | 100 | 283 | 464 | 75 | 4 | 2023-02-03 | 28.26 | 0.71 | 2023-01-22 | 2 | 9.71 | 1 | 28.26 | 14 | SO48375 | 2023-01-29 | 2.26 | 19.43 | 14.13 | |||
SO69515_18 | D9C1-4837-A7 | PO6351170694 | 100 | 281 | 382 | 255 | 4 | 2024-07-04 | 1344.59 | 33.61 | 2024-06-22 | 2 | 713.08 | 1 | 1344.59 | 18 | SO69515 | 2024-06-29 | 107.57 | 1426.16 | 672.29 | |||
SO55264_34 | 80F3-4A7B-A2 | PO10730163005 | 100 | 287 | 214 | 2 | 491 | 4 | 4.87 | 2023-12-04 | 243.53 | 5.97 | 2023-11-22 | 12 | 13.09 | 1 | 238.66 | 34 | SO55264 | 2023-11-29 | 19.09 | 157.04 | 20.29 | 0.02 |
SO55251_6 | 2481-4FF1-80 | PO13659159365 | 100 | 287 | 532 | 437 | 4 | 2023-12-04 | 299.75 | 7.49 | 2023-11-22 | 2 | 136.79 | 1 | 299.75 | 6 | SO55251 | 2023-11-29 | 23.98 | 273.57 | 149.87 | |||
SO46049_8 | 2C79-41BD-8A | PO15689114654 | 100 | 283 | 223 | 328 | 4 | 2022-07-04 | 15.56 | 0.39 | 2022-06-22 | 3 | 5.71 | 1 | 15.56 | 8 | SO46049 | 2022-06-29 | 1.24 | 17.12 | 5.19 | |||
SO46988_7 | 2D2E-4EC3-AC | PO12499171502 | 100 | 282 | 462 | 78 | 4 | 2022-10-04 | 42.39 | 1.06 | 2022-09-22 | 3 | 9.71 | 1 | 42.39 | 7 | SO46988 | 2022-09-29 | 3.39 | 29.14 | 14.13 | |||
SO49541_15 | B736-4142-A1 | PO7569133326 | 100 | 287 | 395 | 608 | 4 | 2023-05-04 | 368.24 | 9.21 | 2023-04-22 | 6 | 45.42 | 1 | 368.24 | 15 | SO49541 | 2023-04-29 | 29.46 | 272.50 | 61.37 | |||
SO59027_31 | C142-4AAA-AB | PO6757122081 | 100 | 281 | 531 | 21 | 4 | 2024-02-03 | 299.75 | 7.49 | 2024-01-22 | 2 | 136.79 | 1 | 299.75 | 31 | SO59027 | 2024-01-29 | 23.98 | 273.57 | 149.87 | |||
SO45046_1 | C2BD-43A4-90 | PO14413152179 | 100 | 287 | 342 | 383 | 4 | 2022-03-06 | 419.46 | 10.49 | 2022-02-22 | 1 | 413.15 | 1 | 419.46 | 1 | SO45046 | 2022-03-01 | 33.56 | 413.15 | 419.46 | |||
SO65315_12 | 0FFB-4EB5-A3 | PO6757194680 | 100 | 281 | 295 | 21 | 4 | 2024-05-04 | 2456.10 | 61.40 | 2024-04-22 | 3 | 747.20 | 1 | 2456.10 | 12 | SO65315 | 2024-04-29 | 196.49 | 2241.60 | 818.70 | |||
SO57137_51 | 9401-4518-A4 | PO6438194874 | 100 | 281 | 214 | 309 | 4 | 2024-01-04 | 20.99 | 0.52 | 2023-12-23 | 1 | 13.09 | 1 | 20.99 | 51 | SO57137 | 2023-12-30 | 1.68 | 13.09 | 20.99 | |||
SO45060_5 | 39B0-42BB-92 | PO10817172372 | 100 | 287 | 338 | 203 | 4 | 2022-03-06 | 419.46 | 10.49 | 2022-02-22 | 1 | 413.15 | 1 | 419.46 | 5 | SO45060 | 2022-03-01 | 33.56 | 413.15 | 419.46 | |||
SO47677_47 | 2C43-407F-B3 | PO13688179339 | 100 | 282 | 216 | 2 | 475 | 4 | 4.29 | 2022-12-04 | 214.65 | 5.26 | 2022-11-22 | 11 | 13.88 | 1 | 210.36 | 47 | SO47677 | 2022-11-29 | 16.83 | 152.66 | 19.51 | 0.02 |
SO44521_17 | E46D-4692-AC | PO12557171689 | 100 | 282 | 319 | 240 | 4 | 2022-01-04 | 874.79 | 21.87 | 2021-12-23 | 1 | 884.71 | 1 | 874.79 | 17 | SO44521 | 2021-12-30 | 69.98 | 884.71 | 874.79 | |||
SO46083_7 | 9B96-4D38-AE | PO3857186802 | 100 | 283 | 315 | 256 | 4 | 2022-07-04 | 874.79 | 21.87 | 2022-06-22 | 1 | 884.71 | 1 | 874.79 | 7 | SO46083 | 2022-06-29 | 69.98 | 884.71 | 874.79 | |||
SO53601_1 | B41F-4FBB-87 | PO3770165104 | 100 | 282 | 471 | 151 | 4 | 2023-11-04 | 114.30 | 2.86 | 2023-10-23 | 3 | 23.75 | 1 | 114.30 | 1 | SO53601 | 2023-10-30 | 9.14 | 71.25 | 38.10 | |||
SO49523_3 | 852E-47A8-A9 | PO3915144057 | 100 | 281 | 224 | 130 | 4 | 2023-05-04 | 25.93 | 0.65 | 2023-04-22 | 5 | 5.23 | 1 | 25.93 | 3 | SO49523 | 2023-04-29 | 2.07 | 26.15 | 5.19 | |||
SO48066_18 | F00E-4B06-9D | PO5684167807 | 100 | 282 | 356 | 385 | 4 | 2023-01-04 | 8699.96 | 217.50 | 2022-12-23 | 7 | 1117.86 | 1 | 8699.96 | 18 | SO48066 | 2022-12-30 | 696.00 | 7824.99 | 1242.85 | |||
SO44787_3 | CFC8-46AC-A7 | PO5597180446 | 100 | 283 | 347 | 75 | 4 | 2022-02-03 | 2039.99 | 51.00 | 2022-01-22 | 1 | 1912.15 | 1 | 2039.99 | 3 | SO44787 | 2022-01-29 | 163.20 | 1912.15 | 2039.99 | |||
SO47456_7 | 840E-4252-B7 | PO9715175233 | 100 | 283 | 356 | 490 | 4 | 2022-11-04 | 8699.96 | 217.50 | 2022-10-23 | 7 | 1117.86 | 1 | 8699.96 | 7 | SO47456 | 2022-10-30 | 696.00 | 7824.99 | 1242.85 | |||
SO69532_4 | 27FB-4A86-85 | PO3799165791 | 100 | 282 | 234 | 312 | 4 | 2024-07-04 | 89.98 | 2.25 | 2024-06-22 | 3 | 38.49 | 1 | 89.98 | 4 | SO69532 | 2024-06-29 | 7.20 | 115.48 | 29.99 | |||
SO51745_16 | C261-441D-A5 | PO11745132954 | 100 | 282 | 418 | 97 | 4 | 2023-10-04 | 1070.69 | 26.77 | 2023-09-22 | 3 | 360.94 | 1 | 1070.69 | 16 | SO51745 | 2023-09-29 | 85.66 | 1082.83 | 356.90 | |||
SO47405_1 | F397-4649-8A | PO348128434 | 100 | 282 | 239 | 609 | 4 | 2022-11-04 | 780.82 | 19.52 | 2022-10-23 | 1 | 722.26 | 1 | 780.82 | 1 | SO47405 | 2022-10-30 | 62.47 | 722.26 | 780.82 | |||
SO50313_16 | B452-44E9-91 | PO7656143984 | 100 | 282 | 447 | 403 | 4 | 2023-07-04 | 105.00 | 2.63 | 2023-06-22 | 7 | 10.31 | 1 | 105.00 | 16 | SO50313 | 2023-06-29 | 8.40 | 72.19 | 15.00 |
Generated 2024-09-21 04:48:34.307 UTC