[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 2500 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51808_4 | 92BB-45C4-89 | PO7540152834 | 100 | 281 | 559 | 607 | 4 | 2023-10-02 | 24.29 | 0.61 | 2023-09-20 | 2 | 8.99 | 1 | 24.29 | 4 | SO51808 | 2023-09-27 | 1.94 | 17.97 | 12.14 |
SO47404_5 | E2CF-421C-A8 | PO261153700 | 100 | 283 | 424 | 647 | 4 | 2022-11-02 | 428.47 | 10.71 | 2022-10-21 | 2 | 158.53 | 1 | 428.47 | 5 | SO47404 | 2022-10-28 | 34.28 | 317.07 | 214.24 |
SO61227_24 | 9006-4208-8F | PO10730172247 | 100 | 287 | 217 | 491 | 4 | 2024-03-03 | 41.99 | 1.05 | 2024-02-20 | 2 | 13.09 | 1 | 41.99 | 24 | SO61227 | 2024-02-27 | 3.36 | 26.17 | 20.99 |
SO69545_29 | 2C06-44D9-96 | PO3480123333 | 100 | 272 | 214 | 436 | 4 | 2024-07-02 | 62.98 | 1.57 | 2024-06-20 | 3 | 13.09 | 1 | 62.98 | 29 | SO69545 | 2024-06-27 | 5.04 | 39.26 | 20.99 |
SO50672_46 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 329 | 239 | 4 | 2023-08-02 | 4228.15 | 105.70 | 2023-07-21 | 9 | 486.71 | 1 | 4228.15 | 46 | SO50672 | 2023-07-28 | 338.25 | 4380.36 | 469.79 |
SO48740_5 | 158B-4BBF-9F | PO551143768 | 100 | 281 | 335 | 4 | 4 | 2023-03-04 | 3288.56 | 82.21 | 2023-02-20 | 7 | 486.71 | 1 | 3288.56 | 5 | SO48740 | 2023-02-27 | 263.08 | 3406.95 | 469.79 |
SO48048_16 | B414-46CB-BA | PO3480117933 | 100 | 283 | 456 | 436 | 4 | 2023-01-02 | 89.99 | 2.25 | 2022-12-21 | 2 | 30.93 | 1 | 89.99 | 16 | SO48048 | 2022-12-28 | 7.20 | 61.87 | 44.99 |
SO65306_6 | 6B9B-439C-94 | PO5597142402 | 100 | 281 | 400 | 75 | 4 | 2024-05-02 | 37.15 | 0.93 | 2024-04-20 | 1 | 27.49 | 1 | 37.15 | 6 | SO65306 | 2024-04-27 | 2.97 | 27.49 | 37.15 |
SO50688_33 | C55C-41B0-92 | PO10701178438 | 100 | 282 | 453 | 133 | 4 | 2023-08-02 | 287.95 | 7.20 | 2023-07-21 | 8 | 24.75 | 1 | 287.95 | 33 | SO50688 | 2023-07-28 | 23.04 | 197.97 | 35.99 |
SO50272_9 | E0A6-4CFA-90 | PO11745174916 | 100 | 282 | 368 | 97 | 4 | 2023-07-02 | 2932.02 | 73.30 | 2023-06-20 | 2 | 1518.79 | 1 | 2932.02 | 9 | SO50272 | 2023-06-27 | 234.56 | 3037.57 | 1466.01 |
SO47658_6 | C574-484B-83 | PO551177057 | 100 | 283 | 337 | 4 | 4 | 2022-12-02 | 3288.56 | 82.21 | 2022-11-20 | 7 | 486.71 | 1 | 3288.56 | 6 | SO47658 | 2022-11-27 | 263.08 | 3406.95 | 469.79 |
SO55251_8 | 2481-4FF1-80 | PO13659159365 | 100 | 287 | 592 | 437 | 4 | 2023-12-02 | 1016.98 | 25.42 | 2023-11-20 | 3 | 308.22 | 1 | 1016.98 | 8 | SO55251 | 2023-11-27 | 81.36 | 924.65 | 338.99 |
SO46339_4 | 5794-4C65-A6 | PO15950135611 | 100 | 282 | 223 | 114 | 4 | 2022-08-02 | 20.75 | 0.52 | 2022-07-21 | 4 | 5.71 | 1 | 20.75 | 4 | SO46339 | 2022-07-28 | 1.66 | 22.82 | 5.19 |
SO50672_48 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 325 | 239 | 4 | 2023-08-02 | 3288.56 | 82.21 | 2023-07-21 | 7 | 486.71 | 1 | 3288.56 | 48 | SO50672 | 2023-07-28 | 263.08 | 3406.95 | 469.79 |
SO48295_18 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 407 | 24 | 4 | 2023-02-01 | 328.01 | 8.20 | 2023-01-20 | 5 | 48.55 | 1 | 328.01 | 18 | SO48295 | 2023-01-27 | 26.24 | 242.73 | 65.60 |
SO49082_1 | 55FD-4BF8-A2 | PO3219158857 | 100 | 282 | 381 | 493 | 4 | 2023-04-04 | 600.26 | 15.01 | 2023-03-23 | 1 | 605.65 | 1 | 600.26 | 1 | SO49082 | 2023-03-30 | 48.02 | 605.65 | 600.26 |
SO44566_2 | 482A-4537-98 | PO7830134580 | 100 | 283 | 215 | 40 | 4 | 2022-01-02 | 20.19 | 0.50 | 2021-12-21 | 1 | 12.03 | 1 | 20.19 | 2 | SO44566 | 2021-12-28 | 1.61 | 12.03 | 20.19 |
SO48069_4 | 60CF-43B6-82 | PO6438117188 | 100 | 283 | 213 | 309 | 4 | 2023-01-02 | 60.56 | 1.51 | 2022-12-21 | 3 | 13.88 | 1 | 60.56 | 4 | SO48069 | 2022-12-28 | 4.84 | 41.63 | 20.19 |
SO47374_20 | C6BE-481A-A0 | PO16182131046 | 100 | 287 | 352 | 23 | 4 | 2022-11-02 | 2485.70 | 62.14 | 2022-10-21 | 2 | 1117.86 | 1 | 2485.70 | 20 | SO47374 | 2022-10-28 | 198.86 | 2235.71 | 1242.85 |
SO69536_15 | 9646-48B3-9E | PO3654177498 | 100 | 281 | 511 | 435 | 4 | 2024-07-02 | 873.82 | 21.85 | 2024-06-20 | 4 | 199.38 | 1 | 873.82 | 15 | SO69536 | 2024-06-27 | 69.91 | 797.50 | 218.45 |
SO48056_28 | 5868-43E3-AD | PO4843164827 | 100 | 287 | 385 | 257 | 4 | 2023-01-02 | 3001.31 | 75.03 | 2022-12-21 | 5 | 605.65 | 1 | 3001.31 | 28 | SO48056 | 2022-12-28 | 240.11 | 3028.25 | 600.26 |
SO48363_12 | A9C9-4B7B-9B | PO3915186343 | 100 | 283 | 370 | 130 | 4 | 2023-02-01 | 1466.01 | 36.65 | 2023-01-20 | 1 | 1518.79 | 1 | 1466.01 | 12 | SO48363 | 2023-01-27 | 117.28 | 1518.79 | 1466.01 |
SO44301_8 | 34BE-4E85-85 | PO10730158868 | 100 | 287 | 330 | 491 | 4 | 2021-12-02 | 419.46 | 10.49 | 2021-11-20 | 1 | 413.15 | 1 | 419.46 | 8 | SO44301 | 2021-11-27 | 33.56 | 413.15 | 419.46 |
SO47369_51 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 383 | 239 | 4 | 2022-11-02 | 3001.31 | 75.03 | 2022-10-21 | 5 | 605.65 | 1 | 3001.31 | 51 | SO47369 | 2022-10-28 | 240.11 | 3028.25 | 600.26 |
SO46343_17 | 2DB3-460D-85 | PO15167181233 | 100 | 283 | 332 | 273 | 4 | 2022-08-02 | 838.92 | 20.97 | 2022-07-21 | 2 | 413.15 | 1 | 838.92 | 17 | SO46343 | 2022-07-28 | 67.11 | 826.29 | 419.46 |
SO50748_20 | 5FBE-4B52-B2 | PO6786143310 | 100 | 281 | 448 | 3 | 4 | 2023-08-02 | 11.99 | 0.30 | 2023-07-21 | 1 | 8.25 | 1 | 11.99 | 20 | SO50748 | 2023-07-28 | 0.96 | 8.25 | 11.99 |
SO63285_20 | 6316-44BB-8E | PO3480176259 | 100 | 281 | 483 | 436 | 4 | 2024-04-03 | 360.00 | 9.00 | 2024-03-22 | 5 | 44.88 | 1 | 360.00 | 20 | SO63285 | 2024-03-29 | 28.80 | 224.40 | 72.00 |
SO67318_3 | 5460-4BEE-A6 | PO6409141464 | 100 | 281 | 580 | 292 | 4 | 2024-06-02 | 2041.19 | 51.03 | 2024-05-21 | 2 | 1082.51 | 1 | 2041.19 | 3 | SO67318 | 2024-05-28 | 163.30 | 2165.02 | 1020.59 |
SO46377_6 | A45C-4A20-BA | PO6786151653 | 100 | 283 | 338 | 3 | 4 | 2022-08-02 | 838.92 | 20.97 | 2022-07-21 | 2 | 413.15 | 1 | 838.92 | 6 | SO46377 | 2022-07-28 | 67.11 | 826.29 | 419.46 |
SO57157_9 | 2435-487B-AC | PO4843135815 | 100 | 287 | 605 | 257 | 4 | 2024-01-02 | 971.98 | 24.30 | 2023-12-21 | 3 | 343.65 | 1 | 971.98 | 9 | SO57157 | 2023-12-28 | 77.76 | 1030.95 | 323.99 |
SO58995_3 | DA16-4097-96 | PO16269190750 | 100 | 287 | 436 | 624 | 4 | 2024-02-01 | 356.90 | 8.92 | 2024-01-20 | 1 | 360.94 | 1 | 356.90 | 3 | SO58995 | 2024-01-27 | 28.55 | 360.94 | 356.90 |
Generated 2024-09-19 13:10:37.360 UTC