[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > SHUFFLE < SKIP 31 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48076_30 | C38A-4C0F-BD | PO7424167037 | 100 | 281 | 221 | 642 | 2 | 2023-01-19 | 40.37 | 1.01 | 2023-01-07 | 2 | 13.88 | 1 | 40.37 | 30 | SO48076 | 2023-01-14 | 3.23 | 27.76 | 20.19 |
SO46368_21 | BF32-47A9-90 | PO4408111909 | 100 | 281 | 342 | 143 | 2 | 2022-08-19 | 1258.38 | 31.46 | 2022-08-07 | 3 | 413.15 | 1 | 1258.38 | 21 | SO46368 | 2022-08-14 | 100.67 | 1239.44 | 419.46 |
SO69526_22 | E43D-4369-A8 | PO7453115394 | 100 | 283 | 480 | 108 | 2 | 2024-07-19 | 1.37 | 0.03 | 2024-07-07 | 1 | 0.86 | 1 | 1.37 | 22 | SO69526 | 2024-07-14 | 0.11 | 0.86 | 1.37 |
SO67263_23 | EFEC-4A80-8F | PO17197178016 | 100 | 283 | 353 | 125 | 2 | 2024-06-19 | 5567.98 | 139.20 | 2024-06-07 | 4 | 1265.62 | 1 | 5567.98 | 23 | SO67263 | 2024-06-14 | 445.44 | 5062.48 | 1391.99 |
SO58950_12 | E67E-435E-9F | PO11455199372 | 100 | 283 | 374 | 72 | 2 | 2024-02-18 | 4398.03 | 109.95 | 2024-02-06 | 3 | 1554.95 | 1 | 4398.03 | 12 | SO58950 | 2024-02-13 | 351.84 | 4664.84 | 1466.01 |
SO69462_10 | 05B6-4501-9B | PO1769122113 | 100 | 283 | 546 | 540 | 2 | 2024-07-19 | 74.51 | 1.86 | 2024-07-07 | 2 | 27.57 | 1 | 74.51 | 10 | SO69462 | 2024-07-14 | 5.96 | 55.14 | 37.25 |
SO47664_15 | 4F8A-4646-B5 | PO17197195500 | 100 | 281 | 358 | 125 | 2 | 2022-12-19 | 4917.84 | 122.95 | 2022-12-07 | 4 | 1105.81 | 1 | 4917.84 | 15 | SO47664 | 2022-12-14 | 393.43 | 4423.24 | 1229.46 |
SO51770_1 | 9F77-4259-BE | PO1769187686 | 100 | 283 | 605 | 540 | 2 | 2023-10-19 | 1943.96 | 48.60 | 2023-10-07 | 6 | 343.65 | 1 | 1943.96 | 1 | SO51770 | 2023-10-14 | 155.52 | 2061.90 | 323.99 |
SO46368_19 | BF32-47A9-90 | PO4408111909 | 100 | 281 | 336 | 143 | 2 | 2022-08-19 | 838.92 | 20.97 | 2022-08-07 | 2 | 413.15 | 1 | 838.92 | 19 | SO46368 | 2022-08-14 | 67.11 | 826.29 | 419.46 |
SO61209_7 | C31E-48AE-AF | PO11484136165 | 100 | 283 | 591 | 594 | 2 | 2024-03-20 | 677.99 | 16.95 | 2024-03-08 | 2 | 308.22 | 1 | 677.99 | 7 | SO61209 | 2024-03-15 | 54.24 | 616.44 | 338.99 |
SO48751_12 | 1B86-4985-89 | PO13775132235 | 100 | 283 | 321 | 618 | 2 | 2023-03-21 | 939.59 | 23.49 | 2023-03-09 | 2 | 486.71 | 1 | 939.59 | 12 | SO48751 | 2023-03-16 | 75.17 | 973.41 | 469.79 |
SO44494_12 | 8EF7-4B3A-A4 | PO18386158045 | 100 | 281 | 340 | 558 | 2 | 2022-01-19 | 838.92 | 20.97 | 2022-01-07 | 2 | 413.15 | 1 | 838.92 | 12 | SO44494 | 2022-01-14 | 67.11 | 826.29 | 419.46 |
SO45556_8 | A9AB-44F3-9F | PO3190111178 | 100 | 281 | 330 | 575 | 2 | 2022-05-19 | 419.46 | 10.49 | 2022-05-07 | 1 | 413.15 | 1 | 419.46 | 8 | SO45556 | 2022-05-14 | 33.56 | 413.15 | 419.46 |
SO46655_21 | F5D5-409B-94 | PO3828139841 | 100 | 281 | 305 | 414 | 2 | 2022-09-18 | 2208.44 | 55.21 | 2022-09-06 | 3 | 653.70 | 1 | 2208.44 | 21 | SO46655 | 2022-09-13 | 176.67 | 1961.09 | 736.15 |
SO47450_49 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 461 | 54 | 2 | 2022-11-19 | 215.98 | 5.40 | 2022-11-07 | 4 | 37.12 | 1 | 215.98 | 49 | SO47450 | 2022-11-14 | 17.28 | 148.48 | 53.99 |
SO49877_21 | 493D-497C-AB | PO3828147687 | 100 | 283 | 469 | 414 | 2 | 2023-06-19 | 91.18 | 2.28 | 2023-06-07 | 4 | 15.67 | 1 | 91.18 | 21 | SO49877 | 2023-06-14 | 7.29 | 62.68 | 22.79 |
SO47450_19 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 414 | 54 | 2 | 2022-11-19 | 149.03 | 3.73 | 2022-11-07 | 1 | 110.28 | 1 | 149.03 | 19 | SO47450 | 2022-11-14 | 11.92 | 110.28 | 149.03 |
SO48076_27 | C38A-4C0F-BD | PO7424167037 | 100 | 281 | 216 | 642 | 2 | 2023-01-19 | 100.93 | 2.52 | 2023-01-07 | 5 | 13.88 | 1 | 100.93 | 27 | SO48076 | 2023-01-14 | 8.07 | 69.39 | 20.19 |
SO57140_1 | 5E5D-46A1-94 | PO3161152145 | 100 | 283 | 481 | 359 | 2 | 2024-01-19 | 32.36 | 0.81 | 2024-01-07 | 6 | 3.36 | 1 | 32.36 | 1 | SO57140 | 2024-01-14 | 2.59 | 20.17 | 5.39 |
SO47055_27 | BF62-4954-A7 | PO7453164163 | 100 | 281 | 447 | 108 | 2 | 2022-10-19 | 60.00 | 1.50 | 2022-10-07 | 4 | 10.31 | 1 | 60.00 | 27 | SO47055 | 2022-10-14 | 4.80 | 41.25 | 15.00 |
SO59075_6 | 1ED6-419E-AF | PO9628136689 | 100 | 283 | 554 | 179 | 2 | 2024-02-18 | 54.94 | 1.37 | 2024-02-06 | 1 | 40.66 | 1 | 54.94 | 6 | SO59075 | 2024-02-13 | 4.40 | 40.66 | 54.94 |
SO45277_15 | 0ED8-411E-88 | PO18386174353 | 100 | 281 | 223 | 558 | 2 | 2022-04-21 | 15.56 | 0.39 | 2022-04-09 | 3 | 5.71 | 1 | 15.56 | 15 | SO45277 | 2022-04-16 | 1.24 | 17.12 | 5.19 |
SO46059_3 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 336 | 270 | 2 | 2022-07-19 | 838.92 | 20.97 | 2022-07-07 | 2 | 413.15 | 1 | 838.92 | 3 | SO46059 | 2022-07-14 | 67.11 | 826.29 | 419.46 |
SO71949_9 | D52C-4E65-AA | PO9483195097 | 100 | 283 | 255 | 54 | 2 | 2024-08-19 | 202.33 | 5.06 | 2024-08-07 | 1 | 204.63 | 1 | 202.33 | 9 | SO71949 | 2024-08-14 | 16.19 | 204.63 | 202.33 |
SO48361_4 | EC7D-4984-95 | PO3190190749 | 100 | 281 | 414 | 575 | 2 | 2023-02-18 | 149.03 | 3.73 | 2023-02-06 | 1 | 110.28 | 1 | 149.03 | 4 | SO48361 | 2023-02-13 | 11.92 | 110.28 | 149.03 |
SO47055_41 | BF62-4954-A7 | PO7453164163 | 100 | 281 | 236 | 108 | 2 | 2022-10-19 | 86.52 | 2.16 | 2022-10-07 | 3 | 29.08 | 1 | 86.52 | 41 | SO47055 | 2022-10-14 | 6.92 | 87.24 | 28.84 |
SO58976_9 | 3BF9-484F-A1 | PO20213146485 | 100 | 283 | 483 | 216 | 2 | 2024-02-18 | 360.00 | 9.00 | 2024-02-06 | 5 | 44.88 | 1 | 360.00 | 9 | SO58976 | 2024-02-13 | 28.80 | 224.40 | 72.00 |
SO50312_1 | 89ED-4505-8D | PO7424134798 | 100 | 283 | 468 | 642 | 2 | 2023-07-19 | 45.59 | 1.14 | 2023-07-07 | 2 | 15.67 | 1 | 45.59 | 1 | SO50312 | 2023-07-14 | 3.65 | 31.34 | 22.79 |
SO48017_5 | 40DA-4972-BB | PO11658177389 | 100 | 281 | 297 | 233 | 2 | 2023-01-19 | 736.15 | 18.40 | 2023-01-07 | 1 | 653.70 | 1 | 736.15 | 5 | SO48017 | 2023-01-14 | 58.89 | 653.70 | 736.15 |
SO51778_14 | 420A-4268-A8 | PO3161175221 | 100 | 283 | 472 | 359 | 2 | 2023-10-19 | 76.20 | 1.91 | 2023-10-07 | 2 | 23.75 | 1 | 76.20 | 14 | SO51778 | 2023-10-14 | 6.10 | 47.50 | 38.10 |
SO49117_19 | 9786-4FB8-81 | PO11629122690 | 100 | 283 | 470 | 396 | 2 | 2023-04-21 | 136.76 | 3.42 | 2023-04-09 | 6 | 15.67 | 1 | 136.76 | 19 | SO49117 | 2023-04-16 | 10.94 | 94.03 | 22.79 |
Generated 2024-10-06 13:13:58.404 UTC