[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 320 > < TAKE 24 >
24 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO57137_27 | 9401-4518-A4 | PO6438194874 | 100 | 281 | 363 | 309 | 4 | 2024-01-03 | 5507.98 | 137.70 | 2023-12-22 | 4 | 1251.98 | 1 | 5507.98 | 27 | SO57137 | 2023-12-29 | 440.64 | 5007.93 | 1376.99 | |||
| SO57131_22 | 635E-4BF2-B9 | PO4611148036 | 100 | 287 | 603 | 131 | 4 | 2024-01-03 | 72.89 | 1.82 | 2023-12-22 | 1 | 53.94 | 1 | 72.89 | 22 | SO57131 | 2023-12-29 | 5.83 | 53.94 | 72.89 | |||
| SO51809_49 | F690-4F1D-B1 | PO6438145374 | 100 | 281 | 471 | 309 | 4 | 2023-10-03 | 304.80 | 7.62 | 2023-09-21 | 8 | 23.75 | 1 | 304.80 | 49 | SO51809 | 2023-09-28 | 24.38 | 189.99 | 38.10 | |||
| SO58984_11 | 5D72-43BF-AB | PO16153135798 | 100 | 282 | 586 | 186 | 4 | 2024-02-02 | 1336.23 | 33.41 | 2024-01-21 | 3 | 461.44 | 1 | 1336.23 | 11 | SO58984 | 2024-01-28 | 106.90 | 1384.33 | 445.41 | |||
| SO47427_23 | 61AA-44CA-99 | PO4640137176 | 100 | 287 | 468 | 648 | 4 | 2022-11-03 | 45.59 | 1.14 | 2022-10-22 | 2 | 15.67 | 1 | 45.59 | 23 | SO47427 | 2022-10-29 | 3.65 | 31.34 | 22.79 | |||
| SO69536_12 | 9646-48B3-9E | PO3654177498 | 100 | 281 | 290 | 435 | 4 | 2024-07-03 | 1637.40 | 40.94 | 2024-06-21 | 2 | 747.20 | 1 | 1637.40 | 12 | SO69536 | 2024-06-28 | 130.99 | 1494.40 | 818.70 | |||
| SO49498_19 | D9E7-4090-86 | PO16472151816 | 100 | 287 | 286 | 239 | 4 | 2023-05-03 | 183.94 | 4.60 | 2023-04-21 | 1 | 170.14 | 1 | 183.94 | 19 | SO49498 | 2023-04-28 | 14.72 | 170.14 | 183.94 | |||
| SO51795_25 | 30DF-4333-9E | PO15921146523 | 100 | 287 | 222 | 77 | 4 | 2023-10-03 | 83.98 | 2.10 | 2023-09-21 | 4 | 13.09 | 1 | 83.98 | 25 | SO51795 | 2023-09-28 | 6.72 | 52.35 | 20.99 | |||
| SO45317_21 | 92DD-46A2-8D | PO2523164373 | 100 | 272 | 313 | 167 | 4 | 2022-04-05 | 12881.77 | 322.04 | 2022-03-24 | 6 | 2171.29 | 1 | 12881.77 | 21 | SO45317 | 2022-03-31 | 1030.54 | 13027.77 | 2146.96 | |||
| SO63180_3 | B8CD-47BA-8C | PO2523117609 | 100 | 287 | 234 | 167 | 4 | 2024-04-04 | 119.98 | 3.00 | 2024-03-23 | 4 | 38.49 | 1 | 119.98 | 3 | SO63180 | 2024-03-30 | 9.60 | 153.97 | 29.99 | |||
| SO48758_12 | 709A-4AE0-B1 | PO13688180139 | 100 | 282 | 354 | 475 | 4 | 2023-03-05 | 3728.56 | 93.21 | 2023-02-21 | 3 | 1117.86 | 1 | 3728.56 | 12 | SO48758 | 2023-02-28 | 298.28 | 3353.57 | 1242.85 | |||
| SO58979_7 | A35B-403A-A4 | PO18038174164 | 100 | 287 | 554 | 509 | 4 | 2024-02-02 | 164.83 | 4.12 | 2024-01-21 | 3 | 40.66 | 1 | 164.83 | 7 | SO58979 | 2024-01-28 | 13.19 | 121.97 | 54.94 | |||
| SO45536_5 | 260C-4755-B2 | PO15167166424 | 100 | 283 | 319 | 273 | 4 | 2022-05-03 | 874.79 | 21.87 | 2022-04-21 | 1 | 884.71 | 1 | 874.79 | 5 | SO45536 | 2022-04-28 | 69.98 | 884.71 | 874.79 | |||
| SO51845_12 | 6AB8-4CEA-A9 | PO3799111961 | 100 | 282 | 474 | 3 | 312 | 4 | 32.72 | 2023-10-03 | 654.41 | 15.54 | 2023-09-21 | 17 | 26.18 | 1 | 621.69 | 12 | SO51845 | 2023-09-28 | 49.73 | 445.00 | 38.49 | 0.05 |
| SO53533_23 | B8B0-46C0-AF | PO18038134377 | 100 | 287 | 507 | 509 | 4 | 2023-11-03 | 200.05 | 5.00 | 2023-10-22 | 1 | 199.85 | 1 | 200.05 | 23 | SO53533 | 2023-10-29 | 16.00 | 199.85 | 200.05 | |||
| SO59027_26 | C142-4AAA-AB | PO6757122081 | 100 | 281 | 355 | 21 | 4 | 2024-02-02 | 4175.98 | 104.40 | 2024-01-21 | 3 | 1265.62 | 1 | 4175.98 | 26 | SO59027 | 2024-01-28 | 334.08 | 3796.86 | 1391.99 | |||
| SO49538_32 | CB52-4E7E-9B | PO6786132021 | 100 | 281 | 381 | 3 | 4 | 2023-05-03 | 1200.53 | 30.01 | 2023-04-21 | 2 | 605.65 | 1 | 1200.53 | 32 | SO49538 | 2023-04-28 | 96.04 | 1211.30 | 600.26 | |||
| SO65269_17 | 999D-45C9-AA | PO4640162431 | 100 | 287 | 590 | 648 | 4 | 2024-05-03 | 2770.16 | 69.25 | 2024-04-21 | 6 | 419.78 | 1 | 2770.16 | 17 | SO65269 | 2024-04-28 | 221.61 | 2518.67 | 461.69 | |||
| SO50272_11 | E0A6-4CFA-90 | PO11745174916 | 100 | 282 | 460 | 97 | 4 | 2023-07-03 | 107.99 | 2.70 | 2023-06-21 | 2 | 37.12 | 1 | 107.99 | 11 | SO50272 | 2023-06-28 | 8.64 | 74.24 | 53.99 | |||
| SO47369_27 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 221 | 239 | 4 | 2022-11-03 | 161.49 | 4.04 | 2022-10-22 | 8 | 13.88 | 1 | 161.49 | 27 | SO47369 | 2022-10-29 | 12.92 | 111.03 | 20.19 | |||
| SO51855_50 | 8551-4CDF-A1 | PO3480115731 | 100 | 281 | 582 | 436 | 4 | 2023-10-03 | 3061.78 | 76.54 | 2023-09-21 | 3 | 1082.51 | 1 | 3061.78 | 50 | SO51855 | 2023-09-28 | 244.94 | 3247.53 | 1020.59 | |||
| SO47436_9 | 4AA1-4884-91 | PO5510133089 | 100 | 287 | 271 | 5 | 4 | 2022-11-03 | 809.33 | 20.23 | 2022-10-22 | 4 | 187.16 | 1 | 809.33 | 9 | SO47436 | 2022-10-29 | 64.75 | 748.63 | 202.33 | |||
| SO45813_6 | 36A5-446C-96 | PO7859120230 | 100 | 287 | 275 | 221 | 4 | 2022-06-03 | 2141.39 | 53.53 | 2022-05-22 | 6 | 352.14 | 1 | 2141.39 | 6 | SO45813 | 2022-05-29 | 171.31 | 2112.84 | 356.90 | |||
| SO48375_10 | B5F1-4C2A-94 | PO5597156214 | 100 | 283 | 308 | 75 | 4 | 2023-02-02 | 744.27 | 18.61 | 2023-01-21 | 1 | 660.91 | 1 | 744.27 | 10 | SO48375 | 2023-01-28 | 59.54 | 660.91 | 744.27 |
Generated 2024-09-20 15:27:40.243 UTC