[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE < SKIP 842 > < TAKE 28 >
28 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO67277_7 | 9AB3-4F34-85 | PO12644174121 | 100 | 272 | 525 | 530 | 5 | 2024-06-03 | 158.43 | 3.96 | 2024-05-22 | 1 | 144.59 | 1 | 158.43 | 7 | SO67277 | 2024-05-29 | 12.67 | 144.59 | 158.43 |
SO47455_35 | 41F3-48C2-B7 | PO9599169586 | 100 | 285 | 435 | 170 | 5 | 2022-11-03 | 1297.81 | 32.45 | 2022-10-22 | 4 | 300.12 | 1 | 1297.81 | 35 | SO47455 | 2022-10-29 | 103.82 | 1200.48 | 324.45 |
SO55260_5 | 0097-43FD-B7 | PO11861162351 | 100 | 283 | 483 | 17 | 5 | 2023-12-03 | 504.00 | 12.60 | 2023-11-21 | 7 | 44.88 | 1 | 504.00 | 5 | SO55260 | 2023-11-28 | 40.32 | 314.16 | 72.00 |
SO49159_6 | 15B4-4CCD-9A | PO7598122487 | 100 | 285 | 265 | 45 | 5 | 2023-04-05 | 607.00 | 15.17 | 2023-03-24 | 3 | 187.16 | 1 | 607.00 | 6 | SO49159 | 2023-03-31 | 48.56 | 561.47 | 202.33 |
SO48063_13 | AEA4-4489-90 | PO5858143254 | 100 | 285 | 230 | 566 | 5 | 2023-01-03 | 201.88 | 5.05 | 2022-12-22 | 7 | 29.08 | 1 | 201.88 | 13 | SO48063 | 2022-12-29 | 16.15 | 203.56 | 28.84 |
SO63245_12 | 1025-4AD1-A1 | PO5800120355 | 100 | 285 | 398 | 63 | 5 | 2024-04-04 | 26.72 | 0.67 | 2024-03-23 | 1 | 19.78 | 1 | 26.72 | 12 | SO63245 | 2024-03-30 | 2.14 | 19.78 | 26.72 |
SO53524_26 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 483 | 611 | 5 | 2023-11-03 | 648.00 | 16.20 | 2023-10-22 | 9 | 44.88 | 1 | 648.00 | 26 | SO53524 | 2023-10-29 | 51.84 | 403.92 | 72.00 |
SO58971_12 | 319A-4CAC-B1 | PO1537134870 | 100 | 285 | 487 | 611 | 5 | 2024-02-02 | 164.97 | 4.12 | 2024-01-21 | 5 | 20.57 | 1 | 164.97 | 12 | SO58971 | 2024-01-28 | 13.20 | 102.83 | 32.99 |
SO47725_30 | 2501-4A1D-99 | PO9831133395 | 100 | 285 | 454 | 81 | 5 | 2022-12-03 | 35.99 | 0.90 | 2022-11-21 | 1 | 24.75 | 1 | 35.99 | 30 | SO47725 | 2022-11-28 | 2.88 | 24.75 | 35.99 |
SO51775_23 | 5DF8-4C96-81 | PO2842127356 | 100 | 285 | 545 | 700 | 5 | 2023-10-03 | 72.88 | 1.82 | 2023-09-21 | 3 | 17.98 | 1 | 72.88 | 23 | SO51775 | 2023-09-28 | 5.83 | 53.93 | 24.29 |
SO51780_2 | 30C4-4B8F-AA | PO18560115626 | 100 | 285 | 487 | 531 | 5 | 2023-10-03 | 98.98 | 2.47 | 2023-09-21 | 3 | 20.57 | 1 | 98.98 | 2 | SO51780 | 2023-09-28 | 7.92 | 61.70 | 32.99 |
SO47042_44 | 42DB-4E2E-B9 | PO5858114009 | 100 | 285 | 397 | 566 | 5 | 2022-10-03 | 24.29 | 0.61 | 2022-09-21 | 1 | 17.98 | 1 | 24.29 | 44 | SO47042 | 2022-09-28 | 1.94 | 17.98 | 24.29 |
SO67260_29 | 6224-4229-B8 | PO522163557 | 100 | 285 | 517 | 676 | 5 | 2024-06-03 | 31.58 | 0.79 | 2024-05-22 | 1 | 23.37 | 1 | 31.58 | 29 | SO67260 | 2024-05-29 | 2.53 | 23.37 | 31.58 |
SO71802_20 | 6B80-41A7-89 | PO15457184141 | 100 | 285 | 556 | 297 | 5 | 2024-08-03 | 105.29 | 2.63 | 2024-07-22 | 1 | 77.92 | 1 | 105.29 | 20 | SO71802 | 2024-07-29 | 8.42 | 77.92 | 105.29 |
SO51824_41 | A1F7-477E-BA | PO5800114202 | 100 | 285 | 290 | 63 | 5 | 2023-10-03 | 2456.10 | 61.40 | 2023-09-21 | 3 | 747.20 | 1 | 2456.10 | 41 | SO51824 | 2023-09-28 | 196.49 | 2241.60 | 818.70 |
SO46033_8 | 253E-48E3-85 | PO18560157809 | 100 | 285 | 342 | 531 | 5 | 2022-07-03 | 1258.38 | 31.46 | 2022-06-21 | 3 | 413.15 | 1 | 1258.38 | 8 | SO46033 | 2022-06-28 | 100.67 | 1239.44 | 419.46 |
SO47042_29 | 42DB-4E2E-B9 | PO5858114009 | 100 | 285 | 308 | 566 | 5 | 2022-10-03 | 2232.82 | 55.82 | 2022-09-21 | 3 | 660.91 | 1 | 2232.82 | 29 | SO47042 | 2022-09-28 | 178.63 | 1982.74 | 744.27 |
SO47053_7 | 686D-414B-82 | PO7598127510 | 100 | 285 | 245 | 45 | 5 | 2022-10-03 | 2342.45 | 58.56 | 2022-09-21 | 3 | 722.26 | 1 | 2342.45 | 7 | SO47053 | 2022-09-28 | 187.40 | 2166.77 | 780.82 |
SO45805_6 | 4E35-406B-B7 | PO3393138494 | 100 | 285 | 315 | 549 | 5 | 2022-06-03 | 874.79 | 21.87 | 2022-05-22 | 1 | 884.71 | 1 | 874.79 | 6 | SO45805 | 2022-05-29 | 69.98 | 884.71 | 874.79 |
SO57104_2 | D4EE-4716-83 | PO18560117786 | 100 | 285 | 483 | 531 | 5 | 2024-01-03 | 216.00 | 5.40 | 2023-12-22 | 3 | 44.88 | 1 | 216.00 | 2 | SO57104 | 2023-12-29 | 17.28 | 134.64 | 72.00 |
SO45275_1 | 43C2-4392-A6 | PO18560176206 | 100 | 285 | 328 | 531 | 5 | 2022-04-05 | 1677.84 | 41.95 | 2022-03-24 | 4 | 413.15 | 1 | 1677.84 | 1 | SO45275 | 2022-03-31 | 134.23 | 1652.59 | 419.46 |
SO44133_8 | 4899-4DD6-93 | PO9599144193 | 100 | 285 | 328 | 170 | 5 | 2021-11-03 | 838.92 | 20.97 | 2021-10-22 | 2 | 413.15 | 1 | 838.92 | 8 | SO44133 | 2021-10-29 | 67.11 | 826.29 | 419.46 |
SO49868_2 | 6BF3-4FD0-B5 | PO11861146173 | 100 | 283 | 358 | 17 | 5 | 2023-06-03 | 1229.46 | 30.74 | 2023-05-22 | 1 | 1105.81 | 1 | 1229.46 | 2 | SO49868 | 2023-05-29 | 98.36 | 1105.81 | 1229.46 |
SO43902_14 | E3ED-44B5-B2 | PO5858178400 | 100 | 285 | 296 | 566 | 5 | 2021-10-03 | 714.70 | 17.87 | 2021-09-21 | 1 | 617.03 | 1 | 714.70 | 14 | SO43902 | 2021-09-28 | 57.18 | 617.03 | 714.70 |
SO67348_8 | 4BD1-4782-A3 | PO9889141767 | 100 | 285 | 309 | 494 | 5 | 2024-06-03 | 1637.40 | 40.94 | 2024-05-22 | 2 | 747.20 | 1 | 1637.40 | 8 | SO67348 | 2024-05-29 | 130.99 | 1494.40 | 818.70 |
SO46933_33 | 4D88-4B51-BF | PO19546168601 | 100 | 285 | 369 | 206 | 5 | 2022-10-03 | 1466.01 | 36.65 | 2022-09-21 | 1 | 1518.79 | 1 | 1466.01 | 33 | SO46933 | 2022-09-28 | 117.28 | 1518.79 | 1466.01 |
SO57088_18 | EA31-4951-8A | PO2842199218 | 100 | 285 | 481 | 700 | 5 | 2024-01-03 | 32.36 | 0.81 | 2023-12-22 | 6 | 3.36 | 1 | 32.36 | 18 | SO57088 | 2023-12-29 | 2.59 | 20.17 | 5.39 |
SO67277_5 | 9AB3-4F34-85 | PO12644174121 | 100 | 272 | 488 | 530 | 5 | 2024-06-03 | 64.79 | 1.62 | 2024-05-22 | 2 | 41.57 | 1 | 64.79 | 5 | SO67277 | 2024-05-29 | 5.18 | 83.14 | 32.39 |
Generated 2024-09-20 14:37:10.307 UTC