[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 926 > < TAKE 28 >
28 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47422_41 | 9D8D-4481-B6 | PO3915123127 | 100 | 283 | 221 | 130 | 4 | 2022-12-24 | 121.12 | 3.03 | 2022-12-12 | 6 | 13.88 | 1 | 121.12 | 41 | SO47422 | 2022-12-19 | 9.69 | 83.27 | 20.19 | |||
SO50298_26 | 2A9C-4236-85 | PO4843196377 | 100 | 287 | 433 | 257 | 4 | 2023-08-23 | 324.45 | 8.11 | 2023-08-11 | 1 | 300.12 | 1 | 324.45 | 26 | SO50298 | 2023-08-18 | 25.96 | 300.12 | 324.45 | |||
SO57157_8 | 2435-487B-AC | PO4843135815 | 100 | 287 | 418 | 257 | 4 | 2024-02-23 | 356.90 | 8.92 | 2024-02-11 | 1 | 360.94 | 1 | 356.90 | 8 | SO57157 | 2024-02-18 | 28.55 | 360.94 | 356.90 | |||
SO65160_9 | 9375-44FE-94 | PO19343172976 | 100 | 282 | 605 | 24 | 4 | 2024-06-23 | 1943.96 | 48.60 | 2024-06-11 | 6 | 343.65 | 1 | 1943.96 | 9 | SO65160 | 2024-06-18 | 155.52 | 2061.90 | 323.99 | |||
SO49111_1 | FF3D-423F-98 | PO15921116106 | 100 | 287 | 327 | 77 | 4 | 2023-05-26 | 469.79 | 11.74 | 2023-05-14 | 1 | 486.71 | 1 | 469.79 | 1 | SO49111 | 2023-05-21 | 37.58 | 486.71 | 469.79 | |||
SO48373_30 | 4C9A-49DD-BA | PO5539129597 | 100 | 282 | 456 | 61 | 4 | 2023-03-25 | 89.99 | 2.25 | 2023-03-13 | 2 | 30.93 | 1 | 89.99 | 30 | SO48373 | 2023-03-20 | 7.20 | 61.87 | 44.99 | |||
SO71889_17 | 79BB-4639-B8 | PO6786144643 | 100 | 281 | 436 | 3 | 4 | 2024-09-23 | 1070.69 | 26.77 | 2024-09-11 | 3 | 360.94 | 1 | 1070.69 | 17 | SO71889 | 2024-09-18 | 85.66 | 1082.83 | 356.90 | |||
SO50298_3 | 2A9C-4236-85 | PO4843196377 | 100 | 287 | 254 | 257 | 4 | 2023-08-23 | 183.94 | 4.60 | 2023-08-11 | 1 | 170.14 | 1 | 183.94 | 3 | SO50298 | 2023-08-18 | 14.72 | 170.14 | 183.94 | |||
SO47677_31 | 2C43-407F-B3 | PO13688179339 | 100 | 282 | 297 | 475 | 4 | 2023-01-23 | 1472.29 | 36.81 | 2023-01-11 | 2 | 653.70 | 1 | 1472.29 | 31 | SO47677 | 2023-01-18 | 117.78 | 1307.39 | 736.15 | |||
SO69546_9 | A1BC-4567-82 | PO3219164489 | 100 | 282 | 418 | 493 | 4 | 2024-08-23 | 356.90 | 8.92 | 2024-08-11 | 1 | 360.94 | 1 | 356.90 | 9 | SO69546 | 2024-08-18 | 28.55 | 360.94 | 356.90 | |||
SO47422_34 | 9D8D-4481-B6 | PO3915123127 | 100 | 283 | 213 | 2 | 130 | 4 | 5.46 | 2022-12-24 | 273.19 | 6.69 | 2022-12-12 | 14 | 13.88 | 1 | 267.73 | 34 | SO47422 | 2022-12-19 | 21.42 | 194.29 | 19.51 | 0.02 |
SO69545_17 | 2C06-44D9-96 | PO3480123333 | 100 | 272 | 390 | 436 | 4 | 2024-08-23 | 2689.18 | 67.23 | 2024-08-11 | 4 | 713.08 | 1 | 2689.18 | 17 | SO69545 | 2024-08-18 | 215.13 | 2852.32 | 672.29 | |||
SO46642_24 | 0A4E-465C-BB | PO551133122 | 100 | 283 | 370 | 4 | 4 | 2022-10-23 | 4398.03 | 109.95 | 2022-10-11 | 3 | 1518.79 | 1 | 4398.03 | 24 | SO46642 | 2022-10-18 | 351.84 | 4556.36 | 1466.01 | |||
SO44751_1 | A39F-4D72-AC | PO15863190988 | 100 | 287 | 229 | 545 | 4 | 2022-03-25 | 115.36 | 2.88 | 2022-03-13 | 4 | 31.72 | 1 | 115.36 | 1 | SO44751 | 2022-03-20 | 9.23 | 126.90 | 28.84 | |||
SO47056_1 | 53BF-4950-9E | PO7656118289 | 100 | 282 | 375 | 403 | 4 | 2022-11-23 | 1308.94 | 32.72 | 2022-11-11 | 1 | 1320.68 | 1 | 1308.94 | 1 | SO47056 | 2022-11-18 | 104.72 | 1320.68 | 1308.94 | |||
SO61184_20 | F33C-4C57-BD | PO16298116527 | 100 | 287 | 499 | 599 | 4 | 2024-04-24 | 602.35 | 15.06 | 2024-04-12 | 1 | 601.74 | 1 | 602.35 | 20 | SO61184 | 2024-04-19 | 48.19 | 601.74 | 602.35 | |||
SO65184_9 | B75D-4335-96 | PO16153178099 | 100 | 282 | 572 | 186 | 4 | 2024-06-23 | 445.41 | 11.14 | 2024-06-11 | 1 | 461.44 | 1 | 445.41 | 9 | SO65184 | 2024-06-18 | 35.63 | 461.44 | 445.41 | |||
SO49890_40 | 9B22-4240-83 | PO7859114282 | 100 | 272 | 230 | 221 | 4 | 2023-07-24 | 86.52 | 2.16 | 2023-07-12 | 3 | 29.08 | 1 | 86.52 | 40 | SO49890 | 2023-07-19 | 6.92 | 87.24 | 28.84 | |||
SO61220_3 | DC8A-47BA-BE | PO14413152509 | 100 | 287 | 481 | 383 | 4 | 2024-04-24 | 16.18 | 0.40 | 2024-04-12 | 3 | 3.36 | 1 | 16.18 | 3 | SO61220 | 2024-04-19 | 1.29 | 10.09 | 5.39 | |||
SO47045_6 | 9DDC-4176-90 | PO6438144434 | 100 | 283 | 356 | 309 | 4 | 2022-11-23 | 3728.56 | 93.21 | 2022-11-11 | 3 | 1117.86 | 1 | 3728.56 | 6 | SO47045 | 2022-11-18 | 298.28 | 3353.57 | 1242.85 | |||
SO43872_3 | 52FF-45CD-9B | PO12557127067 | 100 | 282 | 319 | 240 | 4 | 2021-11-23 | 2624.38 | 65.61 | 2021-11-11 | 3 | 884.71 | 1 | 2624.38 | 3 | SO43872 | 2021-11-18 | 209.95 | 2654.12 | 874.79 | |||
SO47458_13 | 5D5A-47FC-AE | PO9686113121 | 100 | 282 | 410 | 457 | 4 | 2022-12-24 | 72.89 | 1.82 | 2022-12-12 | 2 | 26.97 | 1 | 72.89 | 13 | SO47458 | 2022-12-19 | 5.83 | 53.94 | 36.45 | |||
SO47400_52 | F0B3-44C1-8F | PO10701186775 | 100 | 282 | 428 | 133 | 4 | 2022-12-24 | 2092.56 | 52.31 | 2022-12-12 | 10 | 185.82 | 1 | 2092.56 | 52 | SO47400 | 2022-12-19 | 167.40 | 1858.19 | 209.26 | |||
SO51827_19 | B106-4221-AD | PO4611117026 | 100 | 287 | 558 | 131 | 4 | 2023-11-23 | 242.99 | 6.07 | 2023-11-11 | 1 | 179.82 | 1 | 242.99 | 19 | SO51827 | 2023-11-18 | 19.44 | 179.82 | 242.99 | |||
SO50289_50 | 0809-4DE4-93 | PO3480117331 | 100 | 281 | 464 | 436 | 4 | 2023-08-23 | 14.13 | 0.35 | 2023-08-11 | 1 | 9.71 | 1 | 14.13 | 50 | SO50289 | 2023-08-18 | 1.13 | 9.71 | 14.13 | |||
SO50746_8 | 1B61-4F3B-85 | PO5510129653 | 100 | 287 | 233 | 5 | 4 | 2023-09-23 | 86.52 | 2.16 | 2023-09-11 | 3 | 29.08 | 1 | 86.52 | 8 | SO50746 | 2023-09-18 | 6.92 | 87.24 | 28.84 | |||
SO48775_9 | E56E-4C8C-AA | PO10817145980 | 100 | 287 | 389 | 203 | 4 | 2023-04-25 | 1800.79 | 45.02 | 2023-04-13 | 3 | 605.65 | 1 | 1800.79 | 9 | SO48775 | 2023-04-20 | 144.06 | 1816.95 | 600.26 | |||
SO63283_36 | 5DCA-44B0-BB | PO3799140598 | 100 | 282 | 474 | 312 | 4 | 2024-05-25 | 377.95 | 9.45 | 2024-05-13 | 9 | 26.18 | 1 | 377.95 | 36 | SO63283 | 2024-05-20 | 30.24 | 235.59 | 41.99 |
Generated 2024-11-10 19:21:09.052 UTC