[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > SHUFFLE < SKIP 335 > < TAKE 32 >
32 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49169_3 | 73B1-4F93-B6 | PO10121138908 | 100 | 283 | 375 | 684 | 2 | 2023-04-06 | 1308.94 | 32.72 | 2023-03-25 | 1 | 1320.68 | 1 | 1308.94 | 3 | SO49169 | 2023-04-01 | 104.72 | 1320.68 | 1308.94 | |||
SO57065_2 | B68A-407E-99 | PO11658151711 | 100 | 283 | 398 | 233 | 2 | 2024-01-04 | 53.45 | 1.34 | 2023-12-23 | 2 | 19.78 | 1 | 53.45 | 2 | SO57065 | 2023-12-30 | 4.28 | 39.55 | 26.72 | |||
SO48077_21 | 02FD-483D-8C | PO7453110437 | 100 | 281 | 325 | 108 | 2 | 2023-01-04 | 939.59 | 23.49 | 2022-12-23 | 2 | 486.71 | 1 | 939.59 | 21 | SO48077 | 2022-12-30 | 75.17 | 973.41 | 469.79 | |||
SO44313_10 | 6613-4427-84 | PO5365138960 | 100 | 281 | 322 | 161 | 2 | 2021-12-04 | 419.46 | 10.49 | 2021-11-22 | 1 | 413.15 | 1 | 419.46 | 10 | SO44313 | 2021-11-29 | 33.56 | 413.15 | 419.46 | |||
SO44311_4 | 1B1A-46AE-93 | PO4959115826 | 100 | 281 | 336 | 269 | 2 | 2021-12-04 | 838.92 | 20.97 | 2021-11-22 | 2 | 413.15 | 1 | 838.92 | 4 | SO44311 | 2021-11-29 | 67.11 | 826.29 | 419.46 | |||
SO49518_22 | AF02-4E4D-BA | PO9483189305 | 100 | 283 | 335 | 54 | 2 | 2023-05-04 | 939.59 | 23.49 | 2023-04-22 | 2 | 486.71 | 1 | 939.59 | 22 | SO49518 | 2023-04-29 | 75.17 | 973.41 | 469.79 | |||
SO67263_10 | EFEC-4A80-8F | PO17197178016 | 100 | 283 | 512 | 125 | 2 | 2024-06-04 | 218.45 | 5.46 | 2024-05-23 | 1 | 199.38 | 1 | 218.45 | 10 | SO67263 | 2024-05-30 | 17.48 | 199.38 | 218.45 | |||
SO48739_6 | D31C-4E9E-A0 | PO10092156492 | 100 | 283 | 470 | 252 | 2 | 2023-03-06 | 113.97 | 2.85 | 2023-02-22 | 5 | 15.67 | 1 | 113.97 | 6 | SO48739 | 2023-03-01 | 9.12 | 78.35 | 22.79 | |||
SO47450_43 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 239 | 54 | 2 | 2022-11-04 | 3123.27 | 78.08 | 2022-10-23 | 4 | 722.26 | 1 | 3123.27 | 43 | SO47450 | 2022-10-30 | 249.86 | 2889.03 | 780.82 | |||
SO48392_24 | B9C7-4F4D-82 | PO9483147187 | 100 | 281 | 331 | 54 | 2 | 2023-02-03 | 469.79 | 11.74 | 2023-01-22 | 1 | 486.71 | 1 | 469.79 | 24 | SO48392 | 2023-01-29 | 37.58 | 486.71 | 469.79 | |||
SO44293_25 | A1AE-48E7-A4 | PO13775127212 | 100 | 281 | 313 | 618 | 2 | 2021-12-04 | 4293.92 | 107.35 | 2021-11-22 | 2 | 2171.29 | 1 | 4293.92 | 25 | SO44293 | 2021-11-29 | 343.51 | 4342.59 | 2146.96 | |||
SO43673_7 | 260F-4DCF-A1 | PO13775141242 | 100 | 281 | 342 | 618 | 2 | 2021-09-03 | 838.92 | 20.97 | 2021-08-22 | 2 | 413.15 | 1 | 838.92 | 7 | SO43673 | 2021-08-29 | 67.11 | 826.29 | 419.46 | |||
SO48017_44 | 40DA-4972-BB | PO11658177389 | 100 | 281 | 356 | 233 | 2 | 2023-01-04 | 3728.56 | 93.21 | 2022-12-23 | 3 | 1117.86 | 1 | 3728.56 | 44 | SO48017 | 2022-12-30 | 298.28 | 3353.57 | 1242.85 | |||
SO53560_34 | 3D25-4203-A4 | PO7685199983 | 100 | 283 | 569 | 13 | 539 | 2 | 200.43 | 2023-11-04 | 1336.23 | 28.39 | 2023-10-23 | 4 | 461.44 | 1 | 1135.80 | 34 | SO53560 | 2023-10-30 | 90.86 | 1845.78 | 334.06 | 0.15 |
SO45277_10 | 0ED8-411E-88 | PO18386174353 | 100 | 281 | 322 | 558 | 2 | 2022-04-06 | 419.46 | 10.49 | 2022-03-25 | 1 | 413.15 | 1 | 419.46 | 10 | SO45277 | 2022-04-01 | 33.56 | 413.15 | 419.46 | |||
SO51762_23 | E7DC-4AC1-AD | PO10121132749 | 100 | 283 | 240 | 684 | 2 | 2023-10-04 | 2576.70 | 64.42 | 2023-09-22 | 3 | 868.63 | 1 | 2576.70 | 23 | SO51762 | 2023-09-29 | 206.14 | 2605.90 | 858.90 | |||
SO67282_25 | 50CB-4642-B1 | PO11687162635 | 100 | 283 | 577 | 691 | 2 | 2024-06-04 | 1457.82 | 36.45 | 2024-05-23 | 2 | 755.15 | 1 | 1457.82 | 25 | SO67282 | 2024-05-30 | 116.63 | 1510.30 | 728.91 | |||
SO47450_8 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 325 | 3 | 54 | 2 | 322.98 | 2022-11-04 | 6459.67 | 153.42 | 2022-10-23 | 15 | 486.71 | 1 | 6136.68 | 8 | SO47450 | 2022-10-30 | 490.93 | 7300.60 | 430.64 | 0.05 |
SO46043_14 | 1230-4EA4-83 | PO16791123625 | 100 | 281 | 285 | 36 | 2 | 2022-07-04 | 357.16 | 8.93 | 2022-06-22 | 2 | 176.20 | 1 | 357.16 | 14 | SO46043 | 2022-06-29 | 28.57 | 352.40 | 178.58 | |||
SO48371_8 | AD41-4927-9B | PO4756123920 | 100 | 281 | 329 | 126 | 2 | 2023-02-03 | 1409.38 | 35.23 | 2023-01-22 | 3 | 486.71 | 1 | 1409.38 | 8 | SO48371 | 2023-01-29 | 112.75 | 1460.12 | 469.79 | |||
SO67314_49 | 6653-491A-80 | PO3828116396 | 100 | 283 | 488 | 414 | 2 | 2024-06-04 | 161.97 | 4.05 | 2024-05-23 | 5 | 41.57 | 1 | 161.97 | 49 | SO67314 | 2024-05-30 | 12.96 | 207.86 | 32.39 | |||
SO57141_6 | 5DE1-45D6-8B | PO3625112721 | 100 | 283 | 481 | 666 | 2 | 2024-01-04 | 5.39 | 0.13 | 2023-12-23 | 1 | 3.36 | 1 | 5.39 | 6 | SO57141 | 2023-12-30 | 0.43 | 3.36 | 5.39 | |||
SO47975_6 | 5E8C-4BD8-B5 | PO18386179371 | 100 | 281 | 339 | 558 | 2 | 2023-01-04 | 1879.18 | 46.98 | 2022-12-23 | 4 | 486.71 | 1 | 1879.18 | 6 | SO47975 | 2022-12-30 | 150.33 | 1946.83 | 469.79 | |||
SO44800_6 | 3119-4CF3-BF | PO9019144492 | 100 | 281 | 351 | 576 | 2 | 2022-02-03 | 4049.99 | 101.25 | 2022-01-22 | 2 | 1898.09 | 1 | 4049.99 | 6 | SO44800 | 2022-01-29 | 324.00 | 3796.19 | 2024.99 | |||
SO65262_2 | 2D76-4C33-96 | PO8352189306 | 100 | 283 | 547 | 636 | 2 | 2024-05-04 | 145.78 | 3.64 | 2024-04-22 | 3 | 35.96 | 1 | 145.78 | 2 | SO65262 | 2024-04-29 | 11.66 | 107.88 | 48.59 | |||
SO53560_48 | 3D25-4203-A4 | PO7685199983 | 100 | 283 | 567 | 13 | 539 | 2 | 50.11 | 2023-11-04 | 334.06 | 7.10 | 2023-10-23 | 1 | 461.44 | 1 | 283.95 | 48 | SO53560 | 2023-10-30 | 22.72 | 461.44 | 334.06 | 0.15 |
SO44797_1 | 4297-4DF9-A8 | PO9483142524 | 100 | 281 | 332 | 54 | 2 | 2022-02-03 | 2516.75 | 62.92 | 2022-01-22 | 6 | 413.15 | 1 | 2516.75 | 1 | SO44797 | 2022-01-29 | 201.34 | 2478.88 | 419.46 | |||
SO63200_23 | E73D-4A02-88 | PO11658161535 | 100 | 283 | 222 | 233 | 2 | 2024-04-05 | 83.98 | 2.10 | 2024-03-24 | 4 | 13.09 | 1 | 83.98 | 23 | SO63200 | 2024-03-31 | 6.72 | 52.35 | 20.99 | |||
SO57123_3 | BB1E-492D-A7 | PO6670124664 | 100 | 283 | 440 | 432 | 2 | 2024-01-04 | 2576.70 | 64.42 | 2023-12-23 | 3 | 868.63 | 1 | 2576.70 | 3 | SO57123 | 2023-12-30 | 206.14 | 2605.90 | 858.90 | |||
SO46994_27 | 5E92-4A19-9E | PO11629171210 | 100 | 281 | 428 | 396 | 2 | 2022-10-04 | 418.51 | 10.46 | 2022-09-22 | 2 | 185.82 | 1 | 418.51 | 27 | SO46994 | 2022-09-29 | 33.48 | 371.64 | 209.26 | |||
SO50727_35 | 5DD5-4A9A-B1 | PO9483181443 | 100 | 283 | 335 | 54 | 2 | 2023-08-04 | 469.79 | 11.74 | 2023-07-23 | 1 | 486.71 | 1 | 469.79 | 35 | SO50727 | 2023-07-30 | 37.58 | 486.71 | 469.79 | |||
SO63200_18 | E73D-4A02-88 | PO11658161535 | 100 | 283 | 231 | 233 | 2 | 2024-04-05 | 119.98 | 3.00 | 2024-03-24 | 4 | 38.49 | 1 | 119.98 | 18 | SO63200 | 2024-03-31 | 9.60 | 153.97 | 29.99 |
Generated 2024-09-21 12:52:04.586 UTC