[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE < SKIP 250 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51148_11 | 1D20-490E-98 | PO6612158387 | 100 | 286 | 503 | 110 | 1 | 2023-09-18 | 400.10 | 10.00 | 2023-09-06 | 2 | 199.85 | 1 | 400.10 | 11 | SO51148 | 2023-09-13 | 32.01 | 399.70 | 200.05 | |||
SO51726_4 | 9BC5-4281-AF | PO14587157005 | 100 | 293 | 579 | 2 | 199 | 1 | 169.11 | 2023-10-19 | 8455.36 | 207.16 | 2023-10-07 | 12 | 755.15 | 1 | 8286.25 | 4 | SO51726 | 2023-10-14 | 662.90 | 9061.81 | 704.61 | 0.02 |
SO51707_3 | 7D56-4720-B0 | PO16878130700 | 100 | 282 | 598 | 115 | 1 | 2023-10-19 | 323.99 | 8.10 | 2023-10-07 | 1 | 294.58 | 1 | 323.99 | 3 | SO51707 | 2023-10-14 | 25.92 | 294.58 | 323.99 | |||
SO44570_9 | 4132-4AE3-99 | PO8816195785 | 100 | 289 | 314 | 218 | 1 | 2022-01-19 | 8587.85 | 214.70 | 2022-01-07 | 4 | 2171.29 | 1 | 8587.85 | 9 | SO44570 | 2022-01-14 | 687.03 | 8685.18 | 2146.96 | |||
SO46643_12 | 49E8-4C7A-85 | PO899110603 | 100 | 289 | 339 | 290 | 1 | 2022-09-18 | 3758.35 | 93.96 | 2022-09-06 | 8 | 486.71 | 1 | 3758.35 | 12 | SO46643 | 2022-09-13 | 300.67 | 3893.65 | 469.79 | |||
SO47387_5 | 4FFC-4663-AC | PO13543169662 | 100 | 287 | 362 | 293 | 1 | 2022-11-19 | 1229.46 | 30.74 | 2022-11-07 | 1 | 1105.81 | 1 | 1229.46 | 5 | SO47387 | 2022-11-14 | 98.36 | 1105.81 | 1229.46 | |||
SO59031_3 | 15F5-4B32-AC | PO5017142991 | 100 | 289 | 574 | 308 | 1 | 2024-02-18 | 7152.21 | 178.81 | 2024-02-06 | 5 | 1481.94 | 1 | 7152.21 | 3 | SO59031 | 2024-02-13 | 572.18 | 7409.69 | 1430.44 | |||
SO57026_33 | CD5A-4300-81 | PO16675118038 | 100 | 293 | 571 | 361 | 1 | 2024-01-19 | 445.41 | 11.14 | 2024-01-07 | 1 | 461.44 | 1 | 445.41 | 33 | SO57026 | 2024-01-14 | 35.63 | 461.44 | 445.41 | |||
SO51148_9 | 1D20-490E-98 | PO6612158387 | 100 | 286 | 554 | 110 | 1 | 2023-09-18 | 219.77 | 5.49 | 2023-09-06 | 4 | 40.66 | 1 | 219.77 | 9 | SO51148 | 2023-09-13 | 17.58 | 162.63 | 54.94 | |||
SO47452_17 | 79C0-49E8-B3 | PO8903162839 | 100 | 286 | 343 | 235 | 1 | 2022-11-19 | 469.79 | 11.74 | 2022-11-07 | 1 | 486.71 | 1 | 469.79 | 17 | SO47452 | 2022-11-14 | 37.58 | 486.71 | 469.79 | |||
SO71904_11 | DBF0-4665-A7 | PO5017189568 | 100 | 289 | 492 | 308 | 1 | 2024-08-19 | 602.35 | 15.06 | 2024-08-07 | 1 | 601.74 | 1 | 602.35 | 11 | SO71904 | 2024-08-14 | 48.19 | 601.74 | 602.35 | |||
SO58962_4 | 12B1-4451-9A | PO870180310 | 100 | 286 | 559 | 621 | 1 | 2024-02-18 | 12.14 | 0.30 | 2024-02-06 | 1 | 8.99 | 1 | 12.14 | 4 | SO58962 | 2024-02-13 | 0.97 | 8.99 | 12.14 | |||
SO47387_13 | 4FFC-4663-AC | PO13543169662 | 100 | 287 | 393 | 293 | 1 | 2022-11-19 | 550.78 | 13.77 | 2022-11-07 | 4 | 101.89 | 1 | 550.78 | 13 | SO47387 | 2022-11-14 | 44.06 | 407.57 | 137.69 | |||
SO65175_6 | E1A8-440E-94 | PO17139119772 | 100 | 293 | 376 | 644 | 1 | 2024-05-19 | 2932.02 | 73.30 | 2024-05-07 | 2 | 1554.95 | 1 | 2932.02 | 6 | SO65175 | 2024-05-14 | 234.56 | 3109.90 | 1466.01 | |||
SO47999_5 | DF06-4F6A-9D | PO14500121568 | 100 | 282 | 399 | 650 | 1 | 2023-01-19 | 33.77 | 0.84 | 2023-01-07 | 1 | 24.99 | 1 | 33.77 | 5 | SO47999 | 2023-01-14 | 2.70 | 24.99 | 33.77 | |||
SO69508_12 | 387A-4EC2-A7 | PO7627176234 | 100 | 293 | 376 | 433 | 1 | 2024-07-19 | 8796.06 | 219.90 | 2024-07-07 | 6 | 1554.95 | 1 | 8796.06 | 12 | SO69508 | 2024-07-14 | 703.68 | 9329.69 | 1466.01 | |||
SO69406_3 | E101-486C-A5 | PO16675181672 | 100 | 293 | 231 | 361 | 1 | 2024-07-19 | 149.97 | 3.75 | 2024-07-07 | 5 | 38.49 | 1 | 149.97 | 3 | SO69406 | 2024-07-14 | 12.00 | 192.46 | 29.99 | |||
SO45782_6 | D609-4F2A-9B | PO16588186502 | 100 | 289 | 220 | 146 | 1 | 2022-06-19 | 40.37 | 1.01 | 2022-06-07 | 2 | 12.03 | 1 | 40.37 | 6 | SO45782 | 2022-06-14 | 3.23 | 24.06 | 20.19 | |||
SO46356_25 | 30BA-40DA-B4 | PO783139385 | 100 | 286 | 328 | 91 | 1 | 2022-08-19 | 838.92 | 20.97 | 2022-08-07 | 2 | 413.15 | 1 | 838.92 | 25 | SO46356 | 2022-08-14 | 67.11 | 826.29 | 419.46 | |||
SO57130_18 | 2182-4ADD-88 | PO6148161629 | 100 | 289 | 548 | 693 | 1 | 2024-01-19 | 48.59 | 1.21 | 2024-01-07 | 1 | 35.96 | 1 | 48.59 | 18 | SO57130 | 2024-01-14 | 3.89 | 35.96 | 48.59 | |||
SO43877_7 | 4ECF-42F2-A7 | PO11919119101 | 100 | 286 | 351 | 73 | 1 | 2021-10-19 | 2024.99 | 50.62 | 2021-10-07 | 1 | 1898.09 | 1 | 2024.99 | 7 | SO43877 | 2021-10-14 | 162.00 | 1898.09 | 2024.99 | |||
SO50217_23 | 6AE5-491F-B6 | PO14500116814 | 100 | 282 | 395 | 650 | 1 | 2023-07-19 | 245.50 | 6.14 | 2023-07-07 | 4 | 45.42 | 1 | 245.50 | 23 | SO50217 | 2023-07-14 | 19.64 | 181.67 | 61.37 | |||
SO53500_29 | BEF0-4525-AF | PO12470126979 | 100 | 287 | 499 | 672 | 1 | 2023-11-19 | 2409.38 | 60.23 | 2023-11-07 | 4 | 601.74 | 1 | 2409.38 | 29 | SO53500 | 2023-11-14 | 192.75 | 2406.97 | 602.35 | |||
SO47033_15 | 2797-46ED-BB | PO4727113716 | 100 | 286 | 375 | 343 | 1 | 2022-10-19 | 2617.88 | 65.45 | 2022-10-07 | 2 | 1320.68 | 1 | 2617.88 | 15 | SO47033 | 2022-10-14 | 209.43 | 2641.37 | 1308.94 | |||
SO46030_3 | 8D5D-4CBC-8F | PO18908181698 | 100 | 289 | 349 | 164 | 1 | 2022-07-19 | 4049.99 | 101.25 | 2022-07-07 | 2 | 1898.09 | 1 | 4049.99 | 3 | SO46030 | 2022-07-14 | 324.00 | 3796.19 | 2024.99 | |||
SO43895_3 | 5233-4CB8-BC | PO2900121738 | 100 | 286 | 307 | 469 | 1 | 2021-10-19 | 1445.19 | 36.13 | 2021-10-07 | 2 | 623.84 | 1 | 1445.19 | 3 | SO43895 | 2021-10-14 | 115.62 | 1247.68 | 722.59 | |||
SO53467_21 | BE84-4F9B-8E | PO17487177251 | 100 | 293 | 490 | 692 | 1 | 2023-11-19 | 64.79 | 1.62 | 2023-11-07 | 2 | 41.57 | 1 | 64.79 | 21 | SO53467 | 2023-11-14 | 5.18 | 83.14 | 32.39 | |||
SO49494_18 | 81A4-4876-94 | PO17139199930 | 100 | 293 | 375 | 644 | 1 | 2023-05-19 | 1308.94 | 32.72 | 2023-05-07 | 1 | 1320.68 | 1 | 1308.94 | 18 | SO49494 | 2023-05-14 | 104.72 | 1320.68 | 1308.94 | |||
SO65312_21 | 19D1-4059-B8 | PO6815121334 | 100 | 293 | 363 | 109 | 1 | 2024-05-19 | 8261.96 | 206.55 | 2024-05-07 | 6 | 1251.98 | 1 | 8261.96 | 21 | SO65312 | 2024-05-14 | 660.96 | 7511.89 | 1376.99 | |||
SO55291_2 | 4FAB-4BAB-88 | PO7076160432 | 100 | 293 | 500 | 505 | 1 | 2023-12-19 | 602.35 | 15.06 | 2023-12-07 | 1 | 601.74 | 1 | 602.35 | 2 | SO55291 | 2023-12-14 | 48.19 | 601.74 | 602.35 | |||
SO58910_24 | A209-4ADD-98 | PO19169152738 | 100 | 289 | 532 | 272 | 1 | 2024-02-18 | 149.87 | 3.75 | 2024-02-06 | 1 | 136.79 | 1 | 149.87 | 24 | SO58910 | 2024-02-13 | 11.99 | 136.79 | 149.87 |
Generated 2024-10-06 11:08:15.210 UTC