[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE < SKIP 218 > < TAKE 30 >
30 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49149_31 | D41E-4EFF-A5 | PO5858123072 | 100 | 285 | 393 | 566 | 5 | 2023-04-05 | 275.39 | 6.88 | 2023-03-24 | 2 | 101.89 | 1 | 275.39 | 31 | SO49149 | 2023-03-31 | 22.03 | 203.79 | 137.69 |
SO51137_7 | A47F-4FEF-94 | PO9889144162 | 100 | 285 | 532 | 494 | 5 | 2023-09-02 | 899.24 | 22.48 | 2023-08-21 | 6 | 136.79 | 1 | 899.24 | 7 | SO51137 | 2023-08-28 | 71.94 | 820.71 | 149.87 |
SO49487_3 | 3BC2-4234-86 | PO9048166119 | 100 | 285 | 468 | 652 | 5 | 2023-05-03 | 22.79 | 0.57 | 2023-04-21 | 1 | 15.67 | 1 | 22.79 | 3 | SO49487 | 2023-04-28 | 1.82 | 15.67 | 22.79 |
SO44506_2 | CD67-4B07-B6 | PO16327113845 | 100 | 285 | 212 | 584 | 5 | 2022-01-03 | 60.56 | 1.51 | 2021-12-22 | 3 | 12.03 | 1 | 60.56 | 2 | SO44506 | 2021-12-29 | 4.84 | 36.08 | 20.19 |
SO51081_3 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 597 | 676 | 5 | 2023-09-02 | 971.98 | 24.30 | 2023-08-21 | 3 | 294.58 | 1 | 971.98 | 3 | SO51081 | 2023-08-28 | 77.76 | 883.74 | 323.99 |
SO55328_6 | 577D-4DE9-B6 | PO9831188161 | 100 | 285 | 480 | 81 | 5 | 2023-12-03 | 8.24 | 0.21 | 2023-11-21 | 6 | 0.86 | 1 | 8.24 | 6 | SO55328 | 2023-11-28 | 0.66 | 5.14 | 1.37 |
SO48359_46 | BFAE-4CA5-83 | PO2813116854 | 100 | 272 | 453 | 90 | 5 | 2023-02-02 | 107.98 | 2.70 | 2023-01-21 | 3 | 24.75 | 1 | 107.98 | 46 | SO48359 | 2023-01-28 | 8.64 | 74.24 | 35.99 |
SO50701_5 | B67A-4C0A-B3 | PO2407199018 | 100 | 285 | 407 | 225 | 5 | 2023-08-03 | 131.20 | 3.28 | 2023-07-22 | 2 | 48.55 | 1 | 131.20 | 5 | SO50701 | 2023-07-29 | 10.50 | 97.09 | 65.60 |
SO49836_21 | 0E32-48F7-89 | PO12644185975 | 100 | 285 | 421 | 530 | 5 | 2023-06-03 | 196.33 | 4.91 | 2023-05-22 | 1 | 145.28 | 1 | 196.33 | 21 | SO49836 | 2023-05-29 | 15.71 | 145.28 | 196.33 |
SO69533_8 | AC2B-4C39-84 | PO3596133486 | 100 | 285 | 359 | 476 | 5 | 2024-07-03 | 4130.98 | 103.27 | 2024-06-21 | 3 | 1251.98 | 1 | 4130.98 | 8 | SO69533 | 2024-06-28 | 330.48 | 3755.94 | 1376.99 |
SO51718_1 | 27D3-4968-89 | PO15051113417 | 100 | 285 | 490 | 207 | 5 | 2023-10-03 | 64.79 | 1.62 | 2023-09-21 | 2 | 41.57 | 1 | 64.79 | 1 | SO51718 | 2023-09-28 | 5.18 | 83.14 | 32.39 |
SO67277_22 | 9AB3-4F34-85 | PO12644174121 | 100 | 272 | 398 | 530 | 5 | 2024-06-03 | 26.72 | 0.67 | 2024-05-22 | 1 | 19.78 | 1 | 26.72 | 22 | SO67277 | 2024-05-29 | 2.14 | 19.78 | 26.72 |
SO50756_15 | C414-447C-84 | PO9570119689 | 100 | 285 | 399 | 585 | 5 | 2023-08-03 | 135.10 | 3.38 | 2023-07-22 | 4 | 24.99 | 1 | 135.10 | 15 | SO50756 | 2023-07-29 | 10.81 | 99.97 | 33.77 |
SO51147_46 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 482 | 81 | 5 | 2023-09-02 | 5.39 | 0.13 | 2023-08-21 | 1 | 3.36 | 1 | 5.39 | 46 | SO51147 | 2023-08-28 | 0.43 | 3.36 | 5.39 |
SO45796_12 | 8929-4623-95 | PO11861125955 | 100 | 281 | 347 | 17 | 5 | 2022-06-03 | 6119.98 | 153.00 | 2022-05-22 | 3 | 1912.15 | 1 | 6119.98 | 12 | SO45796 | 2022-05-29 | 489.60 | 5736.46 | 2039.99 |
SO43861_11 | 0CC0-4166-9E | PO16327172067 | 100 | 285 | 334 | 584 | 5 | 2021-10-03 | 838.92 | 20.97 | 2021-09-21 | 2 | 413.15 | 1 | 838.92 | 11 | SO43861 | 2021-09-28 | 67.11 | 826.29 | 419.46 |
SO71844_10 | 410D-4079-9E | PO2813198985 | 100 | 283 | 390 | 90 | 5 | 2024-08-03 | 2016.88 | 50.42 | 2024-07-22 | 3 | 713.08 | 1 | 2016.88 | 10 | SO71844 | 2024-07-29 | 161.35 | 2139.24 | 672.29 |
SO51864_5 | 2389-4E32-92 | PO5568126648 | 100 | 285 | 511 | 422 | 5 | 2023-10-03 | 1092.27 | 27.31 | 2023-09-21 | 5 | 199.38 | 1 | 1092.27 | 5 | SO51864 | 2023-09-28 | 87.38 | 996.88 | 218.45 |
SO48068_4 | 6A25-48DB-95 | PO6293173223 | 100 | 285 | 337 | 612 | 5 | 2023-01-03 | 469.79 | 11.74 | 2022-12-22 | 1 | 486.71 | 1 | 469.79 | 4 | SO48068 | 2022-12-29 | 37.58 | 486.71 | 469.79 |
SO50691_1 | 9ADD-40B5-92 | PO435179132 | 100 | 285 | 254 | 651 | 5 | 2023-08-03 | 183.94 | 4.60 | 2023-07-22 | 1 | 170.14 | 1 | 183.94 | 1 | SO50691 | 2023-07-29 | 14.72 | 170.14 | 183.94 |
SO44552_8 | 79A1-4836-9F | PO5858149301 | 100 | 285 | 348 | 566 | 5 | 2022-01-03 | 12149.96 | 303.75 | 2021-12-22 | 6 | 1898.09 | 1 | 12149.96 | 8 | SO44552 | 2021-12-29 | 972.00 | 11388.57 | 2024.99 |
SO55328_27 | 577D-4DE9-B6 | PO9831188161 | 100 | 285 | 234 | 81 | 5 | 2023-12-03 | 179.96 | 4.50 | 2023-11-21 | 6 | 38.49 | 1 | 179.96 | 27 | SO55328 | 2023-11-28 | 14.40 | 230.95 | 29.99 |
SO50260_7 | 9FEF-4E9E-B1 | PO18560172242 | 100 | 285 | 327 | 531 | 5 | 2023-07-03 | 1879.18 | 46.98 | 2023-06-21 | 4 | 486.71 | 1 | 1879.18 | 7 | SO50260 | 2023-06-28 | 150.33 | 1946.83 | 469.79 |
SO50726_11 | A80B-408E-B3 | PO9599192861 | 100 | 285 | 339 | 170 | 5 | 2023-08-03 | 939.59 | 23.49 | 2023-07-22 | 2 | 486.71 | 1 | 939.59 | 11 | SO50726 | 2023-07-29 | 75.17 | 973.41 | 469.79 |
SO49473_10 | EAA2-43E2-87 | PO2813142084 | 100 | 283 | 263 | 90 | 5 | 2023-05-03 | 202.33 | 5.06 | 2023-04-21 | 1 | 187.16 | 1 | 202.33 | 10 | SO49473 | 2023-04-28 | 16.19 | 187.16 | 202.33 |
SO63220_6 | 25AE-42A1-80 | PO9773177410 | 100 | 285 | 564 | 8 | 5 | 2024-04-04 | 1430.44 | 35.76 | 2024-03-23 | 1 | 1481.94 | 1 | 1430.44 | 6 | SO63220 | 2024-03-30 | 114.44 | 1481.94 | 1430.44 |
SO47693_19 | 3962-4A1A-93 | PO522165713 | 100 | 285 | 427 | 676 | 5 | 2022-12-03 | 418.51 | 10.46 | 2022-11-21 | 2 | 185.82 | 1 | 418.51 | 19 | SO47693 | 2022-11-28 | 33.48 | 371.64 | 209.26 |
SO46971_5 | 5CEA-463B-A2 | PO15051144269 | 100 | 285 | 360 | 207 | 5 | 2022-10-03 | 3688.38 | 92.21 | 2022-09-21 | 3 | 1105.81 | 1 | 3688.38 | 5 | SO46971 | 2022-09-28 | 295.07 | 3317.43 | 1229.46 |
SO45779_2 | 983F-42E3-90 | PO522162183 | 100 | 285 | 350 | 676 | 5 | 2022-06-03 | 4049.99 | 101.25 | 2022-05-22 | 2 | 1898.09 | 1 | 4049.99 | 2 | SO45779 | 2022-05-29 | 324.00 | 3796.19 | 2024.99 |
SO46673_17 | 578D-4F7B-A6 | PO9657163155 | 100 | 285 | 230 | 315 | 5 | 2022-09-02 | 115.36 | 2.88 | 2022-08-21 | 4 | 29.08 | 1 | 115.36 | 17 | SO46673 | 2022-08-28 | 9.23 | 116.32 | 28.84 |
Generated 2024-09-20 09:58:16.304 UTC