[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 2220 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47045_1 | 9DDC-4176-90 | PO6438144434 | 100 | 283 | 366 | 309 | 4 | 2022-11-27 | 2591.98 | 64.80 | 2022-11-15 | 4 | 598.44 | 1 | 2591.98 | 1 | SO47045 | 2022-11-22 | 207.36 | 2393.74 | 647.99 | |||
SO51745_11 | C261-441D-A5 | PO11745132954 | 100 | 282 | 547 | 97 | 4 | 2023-11-27 | 242.97 | 6.07 | 2023-11-15 | 5 | 35.96 | 1 | 242.97 | 11 | SO51745 | 2023-11-22 | 19.44 | 179.80 | 48.59 | |||
SO51842_9 | 2A39-4E97-9A | PO4843199898 | 100 | 287 | 243 | 257 | 4 | 2023-11-27 | 1717.80 | 42.95 | 2023-11-15 | 2 | 868.63 | 1 | 1717.80 | 9 | SO51842 | 2023-11-22 | 137.42 | 1737.27 | 858.90 | |||
SO71787_13 | 94A7-4406-B3 | PO18038111279 | 100 | 287 | 496 | 509 | 4 | 2024-09-27 | 1204.69 | 30.12 | 2024-09-15 | 2 | 601.74 | 1 | 1204.69 | 13 | SO71787 | 2024-09-22 | 96.38 | 1203.49 | 602.35 | |||
SO46663_14 | 0EA2-42AA-A4 | PO6409112370 | 100 | 283 | 456 | 292 | 4 | 2022-10-27 | 179.98 | 4.50 | 2022-10-15 | 4 | 30.93 | 1 | 179.98 | 14 | SO46663 | 2022-10-22 | 14.40 | 123.73 | 44.99 | |||
SO45532_10 | 1342-4F90-B0 | PO15834119448 | 100 | 283 | 332 | 417 | 4 | 2022-06-27 | 1677.84 | 41.95 | 2022-06-15 | 4 | 413.15 | 1 | 1677.84 | 10 | SO45532 | 2022-06-22 | 134.23 | 1652.59 | 419.46 | |||
SO46988_10 | 2D2E-4EC3-AC | PO12499171502 | 100 | 282 | 457 | 78 | 4 | 2022-11-27 | 269.96 | 6.75 | 2022-11-15 | 6 | 30.93 | 1 | 269.96 | 10 | SO46988 | 2022-11-22 | 21.60 | 185.60 | 44.99 | |||
SO45301_20 | 0BA8-4928-A7 | PO12499190711 | 100 | 282 | 285 | 78 | 4 | 2022-05-30 | 357.16 | 8.93 | 2022-05-18 | 2 | 176.20 | 1 | 357.16 | 20 | SO45301 | 2022-05-25 | 28.57 | 352.40 | 178.58 | |||
SO50688_1 | C55C-41B0-92 | PO10701178438 | 100 | 282 | 308 | 133 | 4 | 2023-09-27 | 2977.09 | 74.43 | 2023-09-15 | 4 | 660.91 | 1 | 2977.09 | 1 | SO50688 | 2023-09-22 | 238.17 | 2643.66 | 744.27 | |||
SO69546_9 | A1BC-4567-82 | PO3219164489 | 100 | 282 | 418 | 493 | 4 | 2024-08-27 | 356.90 | 8.92 | 2024-08-15 | 1 | 360.94 | 1 | 356.90 | 9 | SO69546 | 2024-08-22 | 28.55 | 360.94 | 356.90 | |||
SO50724_7 | E9DD-40CA-B2 | PO9686154363 | 100 | 282 | 352 | 457 | 4 | 2023-09-27 | 3728.56 | 93.21 | 2023-09-15 | 3 | 1117.86 | 1 | 3728.56 | 7 | SO50724 | 2023-09-22 | 298.28 | 3353.57 | 1242.85 | |||
SO57077_2 | DC1F-45CA-BA | PO609170534 | 100 | 282 | 471 | 492 | 4 | 2024-02-27 | 266.70 | 6.67 | 2024-02-15 | 7 | 23.75 | 1 | 266.70 | 2 | SO57077 | 2024-02-22 | 21.34 | 166.24 | 38.10 | |||
SO44776_4 | 289E-464B-BE | PO2697147596 | 100 | 282 | 235 | 187 | 4 | 2022-03-29 | 86.52 | 2.16 | 2022-03-17 | 3 | 31.72 | 1 | 86.52 | 4 | SO44776 | 2022-03-24 | 6.92 | 95.17 | 28.84 | |||
SO61218_35 | 8441-4C6F-89 | PO13688193778 | 100 | 282 | 487 | 475 | 4 | 2024-04-28 | 131.98 | 3.30 | 2024-04-16 | 4 | 20.57 | 1 | 131.98 | 35 | SO61218 | 2024-04-23 | 10.56 | 82.27 | 32.99 | |||
SO46660_25 | CF24-45E2-9D | PO5626129733 | 100 | 283 | 343 | 3 | 166 | 4 | 452.18 | 2022-10-27 | 9043.53 | 214.78 | 2022-10-15 | 21 | 486.71 | 1 | 8591.36 | 25 | SO46660 | 2022-10-22 | 687.31 | 10220.84 | 430.64 | 0.05 |
SO49076_16 | 8DE0-4335-95 | PO2523199507 | 100 | 287 | 333 | 167 | 4 | 2023-05-30 | 2348.97 | 58.72 | 2023-05-18 | 5 | 486.71 | 1 | 2348.97 | 16 | SO49076 | 2023-05-25 | 187.92 | 2433.53 | 469.79 | |||
SO50272_36 | E0A6-4CFA-90 | PO11745174916 | 100 | 282 | 230 | 97 | 4 | 2023-08-27 | 86.52 | 2.16 | 2023-08-15 | 3 | 29.08 | 1 | 86.52 | 36 | SO50272 | 2023-08-22 | 6.92 | 87.24 | 28.84 | |||
SO46642_2 | 0A4E-465C-BB | PO551133122 | 100 | 283 | 341 | 4 | 4 | 2022-10-27 | 4697.94 | 117.45 | 2022-10-15 | 10 | 486.71 | 1 | 4697.94 | 2 | SO46642 | 2022-10-22 | 375.84 | 4867.07 | 469.79 | |||
SO45798_10 | 3FA4-4459-BD | PO10817199969 | 100 | 287 | 317 | 203 | 4 | 2022-07-28 | 2624.38 | 65.61 | 2022-07-16 | 3 | 884.71 | 1 | 2624.38 | 10 | SO45798 | 2022-07-23 | 209.95 | 2654.12 | 874.79 | |||
SO44566_9 | 482A-4537-98 | PO7830134580 | 100 | 283 | 350 | 40 | 4 | 2022-02-27 | 4049.99 | 101.25 | 2022-02-15 | 2 | 1898.09 | 1 | 4049.99 | 9 | SO44566 | 2022-02-22 | 324.00 | 3796.19 | 2024.99 | |||
SO63240_21 | AC0A-4F08-91 | PO4611157476 | 100 | 287 | 552 | 131 | 4 | 2024-05-29 | 109.79 | 2.74 | 2024-05-17 | 2 | 40.62 | 1 | 109.79 | 21 | SO63240 | 2024-05-24 | 8.78 | 81.24 | 54.89 | |||
SO71782_35 | CA08-4A9B-8D | PO19372114749 | 100 | 282 | 499 | 582 | 4 | 2024-09-27 | 602.35 | 15.06 | 2024-09-15 | 1 | 601.74 | 1 | 602.35 | 35 | SO71782 | 2024-09-22 | 48.19 | 601.74 | 602.35 | |||
SO44299_25 | AFF1-4CD9-9A | PO10817117580 | 100 | 287 | 317 | 203 | 4 | 2022-01-27 | 874.79 | 21.87 | 2022-01-15 | 1 | 884.71 | 1 | 874.79 | 25 | SO44299 | 2022-01-22 | 69.98 | 884.71 | 874.79 | |||
SO65269_10 | 999D-45C9-AA | PO4640162431 | 100 | 287 | 476 | 648 | 4 | 2024-06-27 | 419.94 | 10.50 | 2024-06-15 | 10 | 26.18 | 1 | 419.94 | 10 | SO65269 | 2024-06-22 | 33.60 | 261.76 | 41.99 | |||
SO44520_17 | 5BE0-436B-8C | PO12499152870 | 100 | 282 | 276 | 78 | 4 | 2022-02-27 | 356.90 | 8.92 | 2022-02-15 | 1 | 352.14 | 1 | 356.90 | 17 | SO44520 | 2022-02-22 | 28.55 | 352.14 | 356.90 | |||
SO46638_41 | 9659-44CE-A2 | PO10817110834 | 100 | 287 | 230 | 203 | 4 | 2022-10-27 | 115.36 | 2.88 | 2022-10-15 | 4 | 29.08 | 1 | 115.36 | 41 | SO46638 | 2022-10-22 | 9.23 | 116.32 | 28.84 | |||
SO50702_10 | 6D0A-413E-BE | PO2697119650 | 100 | 282 | 364 | 187 | 4 | 2023-09-27 | 647.99 | 16.20 | 2023-09-15 | 1 | 598.44 | 1 | 647.99 | 10 | SO50702 | 2023-09-22 | 51.84 | 598.44 | 647.99 | |||
SO45291_10 | 3865-4B93-A6 | PO15689110696 | 100 | 283 | 324 | 328 | 4 | 2022-05-30 | 1258.38 | 31.46 | 2022-05-18 | 3 | 413.15 | 1 | 1258.38 | 10 | SO45291 | 2022-05-25 | 100.67 | 1239.44 | 419.46 | |||
SO48295_50 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 461 | 24 | 4 | 2023-03-29 | 485.95 | 12.15 | 2023-03-17 | 9 | 37.12 | 1 | 485.95 | 50 | SO48295 | 2023-03-24 | 38.88 | 334.09 | 53.99 | |||
SO57034_9 | 57D0-46D3-B7 | PO15689142548 | 100 | 281 | 372 | 328 | 4 | 2024-02-27 | 8796.06 | 219.90 | 2024-02-15 | 6 | 1554.95 | 1 | 8796.06 | 9 | SO57034 | 2024-02-22 | 703.68 | 9329.69 | 1466.01 | |||
SO50272_16 | E0A6-4CFA-90 | PO11745174916 | 100 | 282 | 325 | 97 | 4 | 2023-08-27 | 939.59 | 23.49 | 2023-08-15 | 2 | 486.71 | 1 | 939.59 | 16 | SO50272 | 2023-08-22 | 75.17 | 973.41 | 469.79 |
Generated 2024-11-14 04:32:25.405 UTC