[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > SHUFFLE SKIP 2000 < SKIP 219 > < TAKE 31 >
31 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48392_31 | B9C7-4F4D-82 | PO9483147187 | 100 | 281 | 458 | 54 | 2 | 2023-02-01 | 134.98 | 3.37 | 2023-01-20 | 3 | 30.93 | 1 | 134.98 | 31 | SO48392 | 2023-01-27 | 10.80 | 92.80 | 44.99 |
SO63200_1 | E73D-4A02-88 | PO11658161535 | 100 | 283 | 603 | 233 | 2 | 2024-04-03 | 145.79 | 3.64 | 2024-03-22 | 2 | 53.94 | 1 | 145.79 | 1 | SO63200 | 2024-03-29 | 11.66 | 107.88 | 72.89 |
SO51111_34 | 5E49-4F77-BB | PO11484190487 | 100 | 283 | 592 | 594 | 2 | 2023-09-01 | 1016.98 | 25.42 | 2023-08-20 | 3 | 308.22 | 1 | 1016.98 | 34 | SO51111 | 2023-08-27 | 81.36 | 924.65 | 338.99 |
SO49169_21 | 73B1-4F93-B6 | PO10121138908 | 100 | 283 | 381 | 684 | 2 | 2023-04-04 | 1200.53 | 30.01 | 2023-03-23 | 2 | 605.65 | 1 | 1200.53 | 21 | SO49169 | 2023-03-30 | 96.04 | 1211.30 | 600.26 |
SO47395_45 | 98F1-44B4-97 | PO11455133549 | 100 | 281 | 369 | 72 | 2 | 2022-11-02 | 2932.02 | 73.30 | 2022-10-21 | 2 | 1518.79 | 1 | 2932.02 | 45 | SO47395 | 2022-10-28 | 234.56 | 3037.57 | 1466.01 |
SO44114_18 | 3082-4C08-AA | PO3190199320 | 100 | 281 | 334 | 575 | 2 | 2021-11-02 | 1258.38 | 31.46 | 2021-10-21 | 3 | 413.15 | 1 | 1258.38 | 18 | SO44114 | 2021-10-28 | 100.67 | 1239.44 | 419.46 |
SO44559_13 | 8618-4A1B-AD | PO6641148111 | 100 | 281 | 253 | 342 | 2 | 2022-01-02 | 357.16 | 8.93 | 2021-12-21 | 2 | 176.20 | 1 | 357.16 | 13 | SO44559 | 2021-12-28 | 28.57 | 352.40 | 178.58 |
SO53567_32 | 2385-4ADE-B6 | PO9628113784 | 100 | 283 | 555 | 179 | 2 | 2023-11-02 | 255.60 | 6.39 | 2023-10-21 | 4 | 47.29 | 1 | 255.60 | 32 | SO53567 | 2023-10-28 | 20.45 | 189.14 | 63.90 |
SO46095_11 | A60D-4721-BF | PO6641179809 | 100 | 281 | 253 | 342 | 2 | 2022-07-02 | 357.16 | 8.93 | 2022-06-20 | 2 | 176.20 | 1 | 357.16 | 11 | SO46095 | 2022-06-27 | 28.57 | 352.40 | 178.58 |
SO47421_6 | ECD3-4E13-8E | PO3190135008 | 100 | 281 | 441 | 575 | 2 | 2022-11-02 | 780.82 | 19.52 | 2022-10-21 | 1 | 722.26 | 1 | 780.82 | 6 | SO47421 | 2022-10-28 | 62.47 | 722.26 | 780.82 |
SO50727_38 | 5DD5-4A9A-B1 | PO9483181443 | 100 | 283 | 233 | 54 | 2 | 2023-08-02 | 230.72 | 5.77 | 2023-07-21 | 8 | 29.08 | 1 | 230.72 | 38 | SO50727 | 2023-07-28 | 18.46 | 232.65 | 28.84 |
SO50683_2 | 8EBE-4D2C-AB | PO11455112273 | 100 | 283 | 422 | 72 | 2 | 2023-08-02 | 270.16 | 6.75 | 2023-07-21 | 4 | 49.98 | 1 | 270.16 | 2 | SO50683 | 2023-07-28 | 21.61 | 199.92 | 67.54 |
SO63219_19 | E19D-4F90-91 | PO7453184328 | 100 | 283 | 477 | 108 | 2 | 2024-04-03 | 11.98 | 0.30 | 2024-03-22 | 4 | 1.87 | 1 | 11.98 | 19 | SO63219 | 2024-03-29 | 0.96 | 7.47 | 2.99 |
SO47976_6 | 1D33-4555-83 | PO18183173367 | 100 | 281 | 354 | 667 | 2 | 2023-01-02 | 8699.96 | 217.50 | 2022-12-21 | 7 | 1117.86 | 1 | 8699.96 | 6 | SO47976 | 2022-12-28 | 696.00 | 7824.99 | 1242.85 |
SO59012_29 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 556 | 539 | 2 | 2024-02-01 | 631.76 | 15.79 | 2024-01-20 | 6 | 77.92 | 1 | 631.76 | 29 | SO59012 | 2024-01-27 | 50.54 | 467.51 | 105.29 |
SO69442_43 | 9833-459C-A2 | PO11658194725 | 100 | 283 | 237 | 233 | 2 | 2024-07-02 | 59.99 | 1.50 | 2024-06-20 | 2 | 38.49 | 1 | 59.99 | 43 | SO69442 | 2024-06-27 | 4.80 | 76.98 | 29.99 |
SO48026_25 | E497-4BCF-A5 | PO10121196875 | 100 | 281 | 327 | 684 | 2 | 2023-01-02 | 1409.38 | 35.23 | 2022-12-21 | 3 | 486.71 | 1 | 1409.38 | 25 | SO48026 | 2022-12-28 | 112.75 | 1460.12 | 469.79 |
SO50683_42 | 8EBE-4D2C-AB | PO11455112273 | 100 | 283 | 263 | 72 | 2 | 2023-08-02 | 1213.99 | 30.35 | 2023-07-21 | 6 | 187.16 | 1 | 1213.99 | 42 | SO50683 | 2023-07-28 | 97.12 | 1122.94 | 202.33 |
SO47011_11 | 808A-4138-A9 | PO1769173090 | 100 | 281 | 263 | 540 | 2 | 2022-10-02 | 404.66 | 10.12 | 2022-09-20 | 2 | 187.16 | 1 | 404.66 | 11 | SO47011 | 2022-09-27 | 32.37 | 374.31 | 202.33 |
SO57065_16 | B68A-407E-99 | PO11658151711 | 100 | 283 | 542 | 233 | 2 | 2024-01-02 | 24.29 | 0.61 | 2023-12-21 | 1 | 17.98 | 1 | 24.29 | 16 | SO57065 | 2023-12-28 | 1.94 | 17.98 | 24.29 |
SO69526_2 | E43D-4369-A8 | PO7453115394 | 100 | 283 | 234 | 108 | 2 | 2024-07-02 | 179.96 | 4.50 | 2024-06-20 | 6 | 38.49 | 1 | 179.96 | 2 | SO69526 | 2024-06-27 | 14.40 | 230.95 | 29.99 |
SO46610_19 | B7D1-4895-B6 | PO17197125590 | 100 | 281 | 428 | 125 | 2 | 2022-09-01 | 837.02 | 20.93 | 2022-08-20 | 4 | 185.82 | 1 | 837.02 | 19 | SO46610 | 2022-08-27 | 66.96 | 743.28 | 209.26 |
SO50727_19 | 5DD5-4A9A-B1 | PO9483181443 | 100 | 283 | 415 | 54 | 2 | 2023-08-02 | 396.07 | 9.90 | 2023-07-21 | 2 | 146.55 | 1 | 396.07 | 19 | SO50727 | 2023-07-28 | 31.69 | 293.09 | 198.04 |
SO47975_25 | 5E8C-4BD8-B5 | PO18386179371 | 100 | 281 | 213 | 558 | 2 | 2023-01-02 | 60.56 | 1.51 | 2022-12-21 | 3 | 13.88 | 1 | 60.56 | 25 | SO47975 | 2022-12-28 | 4.84 | 41.63 | 20.19 |
SO44522_10 | B9A9-4D27-B7 | PO12006113976 | 100 | 281 | 310 | 270 | 2 | 2022-01-02 | 2146.96 | 53.67 | 2021-12-21 | 1 | 2171.29 | 1 | 2146.96 | 10 | SO44522 | 2021-12-28 | 171.76 | 2171.29 | 2146.96 |
SO48026_4 | E497-4BCF-A5 | PO10121196875 | 100 | 281 | 415 | 684 | 2 | 2023-01-02 | 198.04 | 4.95 | 2022-12-21 | 1 | 146.55 | 1 | 198.04 | 4 | SO48026 | 2022-12-28 | 15.84 | 146.55 | 198.04 |
SO71873_1 | 0140-467E-A2 | PO12325121185 | 100 | 283 | 579 | 53 | 2 | 2024-08-02 | 728.91 | 18.22 | 2024-07-21 | 1 | 755.15 | 1 | 728.91 | 1 | SO71873 | 2024-07-28 | 58.31 | 755.15 | 728.91 |
SO45053_8 | 1527-4B4C-8B | PO13775163879 | 100 | 281 | 318 | 618 | 2 | 2022-03-04 | 874.79 | 21.87 | 2022-02-20 | 1 | 884.71 | 1 | 874.79 | 8 | SO45053 | 2022-02-27 | 69.98 | 884.71 | 874.79 |
SO46948_42 | B040-4261-B3 | PO18386128096 | 100 | 281 | 343 | 558 | 2 | 2022-10-02 | 939.59 | 23.49 | 2022-09-20 | 2 | 486.71 | 1 | 939.59 | 42 | SO46948 | 2022-09-27 | 75.17 | 973.41 | 469.79 |
SO47055_12 | BF62-4954-A7 | PO7453164163 | 100 | 281 | 254 | 108 | 2 | 2022-10-02 | 183.94 | 4.60 | 2022-09-20 | 1 | 170.14 | 1 | 183.94 | 12 | SO47055 | 2022-09-27 | 14.72 | 170.14 | 183.94 |
SO45302_4 | 485F-48BA-86 | PO12006146340 | 100 | 281 | 334 | 270 | 2 | 2022-04-04 | 1258.38 | 31.46 | 2022-03-23 | 3 | 413.15 | 1 | 1258.38 | 4 | SO45302 | 2022-03-30 | 100.67 | 1239.44 | 419.46 |
Generated 2024-09-19 23:56:29.869 UTC