[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 9 > < TAKE 60 >
60 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO53475_15 | FFE3-4820-88 | PO15515192405 | 100 | 292 | 404 | 481 | 7 | 2023-11-03 | 53.45 | 1.34 | 2023-10-22 | 2 | 19.78 | 1 | 53.45 | 15 | SO53475 | 2023-10-29 | 4.28 | 39.55 | 26.72 | |||
SO46959_45 | 9007-4F97-9C | PO16733197949 | 19 | 291 | 460 | 533 | 6 | 2022-10-03 | 53.99 | 1.35 | 2022-09-21 | 1 | 37.12 | 1 | 53.99 | 45 | SO46959 | 2022-09-28 | 4.32 | 37.12 | 53.99 | |||
SO65193_1 | 59C0-42E7-8F | PO13021128161 | 100 | 282 | 372 | 276 | 4 | 2024-05-03 | 1466.01 | 36.65 | 2024-04-21 | 1 | 1554.95 | 1 | 1466.01 | 1 | SO65193 | 2024-04-28 | 117.28 | 1554.95 | 1466.01 | |||
SO58908_22 | A429-40BA-96 | PO19285116289 | 98 | 290 | 507 | 448 | 10 | 2024-02-02 | 1200.31 | 30.01 | 2024-01-21 | 6 | 199.85 | 1 | 1200.31 | 22 | SO58908 | 2024-01-28 | 96.03 | 1199.11 | 200.05 | |||
SO58987_4 | 9A04-4070-80 | PO18241161045 | 100 | 285 | 552 | 477 | 5 | 2024-02-02 | 54.89 | 1.37 | 2024-01-21 | 1 | 40.62 | 1 | 54.89 | 4 | SO58987 | 2024-01-28 | 4.39 | 40.62 | 54.89 | |||
SO46323_4 | 3AF8-4F1A-97 | PO20155112356 | 100 | 289 | 346 | 7 | 92 | 1 | 297.50 | 2022-08-03 | 850.00 | 13.81 | 2022-07-22 | 1 | 1912.15 | 1 | 552.50 | 4 | SO46323 | 2022-07-29 | 44.20 | 1912.15 | 850.00 | 0.35 |
SO51806_11 | 644D-4C45-8E | PO9425112104 | 6 | 296 | 477 | 519 | 9 | 2023-10-03 | 8.98 | 0.22 | 2023-09-21 | 3 | 1.87 | 1 | 8.98 | 11 | SO51806 | 2023-09-28 | 0.72 | 5.60 | 2.99 | |||
SO45062_18 | 017E-486E-BC | PO1189166374 | 100 | 285 | 319 | 423 | 5 | 2022-03-05 | 1749.59 | 43.74 | 2022-02-21 | 2 | 884.71 | 1 | 1749.59 | 18 | SO45062 | 2022-02-28 | 139.97 | 1769.42 | 874.79 | |||
SO51146_3 | FC91-4E19-86 | PO7076128836 | 100 | 293 | 573 | 505 | 1 | 2023-09-02 | 2860.88 | 71.52 | 2023-08-21 | 2 | 1481.94 | 1 | 2860.88 | 3 | SO51146 | 2023-08-28 | 228.87 | 2963.88 | 1430.44 | |||
SO53611_9 | 700F-4823-BC | PO7018155391 | 100 | 281 | 214 | 695 | 3 | 2023-11-03 | 83.98 | 2.10 | 2023-10-22 | 4 | 13.09 | 1 | 83.98 | 9 | SO53611 | 2023-10-29 | 6.72 | 52.35 | 20.99 | |||
SO51691_5 | 8F72-4342-A4 | PO19923122474 | 100 | 283 | 309 | 18 | 3 | 2023-10-03 | 1637.40 | 40.94 | 2023-09-21 | 2 | 747.20 | 1 | 1637.40 | 5 | SO51691 | 2023-09-28 | 130.99 | 1494.40 | 818.70 | |||
SO58974_22 | FB64-4792-81 | PO2813115918 | 100 | 283 | 418 | 90 | 5 | 2024-02-02 | 2498.29 | 62.46 | 2024-01-21 | 7 | 360.94 | 1 | 2498.29 | 22 | SO58974 | 2024-01-28 | 199.86 | 2526.60 | 356.90 | |||
SO48778_9 | 4F83-4D59-87 | PO4495173571 | 19 | 291 | 360 | 496 | 6 | 2023-03-05 | 9835.67 | 245.89 | 2023-02-21 | 8 | 1105.81 | 1 | 9835.67 | 9 | SO48778 | 2023-02-28 | 786.85 | 8846.48 | 1229.46 | |||
SO47384_28 | 8780-4D54-85 | PO14268113342 | 100 | 283 | 323 | 418 | 3 | 2022-11-03 | 1879.18 | 46.98 | 2022-10-22 | 4 | 486.71 | 1 | 1879.18 | 28 | SO47384 | 2022-10-29 | 150.33 | 1946.83 | 469.79 | |||
SO43693_1 | EC62-4BB3-9B | PO8120182325 | 100 | 281 | 235 | 485 | 5 | 2021-09-02 | 86.52 | 2.16 | 2021-08-21 | 3 | 31.72 | 1 | 86.52 | 1 | SO43693 | 2021-08-28 | 6.92 | 95.17 | 28.84 | |||
SO45294_6 | 2F48-482E-A9 | PO14500175708 | 100 | 282 | 345 | 650 | 1 | 2022-04-05 | 4079.99 | 102.00 | 2022-03-24 | 2 | 1912.15 | 1 | 4079.99 | 6 | SO45294 | 2022-03-31 | 326.40 | 3824.31 | 2039.99 | |||
SO50663_50 | 286E-4915-89 | PO19343130555 | 100 | 282 | 453 | 24 | 4 | 2023-08-03 | 287.95 | 7.20 | 2023-07-22 | 8 | 24.75 | 1 | 287.95 | 50 | SO50663 | 2023-07-29 | 23.04 | 197.97 | 35.99 | |||
SO61184_5 | F33C-4C57-BD | PO16298116527 | 100 | 287 | 570 | 599 | 4 | 2024-03-04 | 2227.05 | 55.68 | 2024-02-21 | 5 | 461.44 | 1 | 2227.05 | 5 | SO61184 | 2024-02-28 | 178.16 | 2307.22 | 445.41 | |||
SO67316_51 | 6F7E-4455-9E | PO4495115494 | 19 | 291 | 487 | 496 | 6 | 2024-06-03 | 131.98 | 3.30 | 2024-05-22 | 4 | 20.57 | 1 | 131.98 | 51 | SO67316 | 2024-05-29 | 10.56 | 82.27 | 32.99 | |||
SO50301_16 | 94B2-4C2F-8C | PO5684190027 | 100 | 282 | 362 | 385 | 4 | 2023-07-03 | 4917.84 | 122.95 | 2023-06-21 | 4 | 1105.81 | 1 | 4917.84 | 16 | SO50301 | 2023-06-28 | 393.43 | 4423.24 | 1229.46 | |||
SO67268_2 | 9708-4E22-A4 | PO15312122688 | 19 | 291 | 287 | 299 | 6 | 2024-06-03 | 404.66 | 10.12 | 2024-05-22 | 2 | 204.63 | 1 | 404.66 | 2 | SO67268 | 2024-05-29 | 32.37 | 409.25 | 202.33 | |||
SO71801_15 | 0DBE-43DA-9A | PO15515173664 | 100 | 292 | 471 | 481 | 7 | 2024-08-03 | 342.90 | 8.57 | 2024-07-22 | 9 | 23.75 | 1 | 342.90 | 15 | SO71801 | 2024-07-29 | 27.43 | 213.74 | 38.10 | |||
SO51081_23 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 463 | 676 | 5 | 2023-09-02 | 58.78 | 1.47 | 2023-08-21 | 4 | 9.16 | 1 | 58.78 | 23 | SO51081 | 2023-08-28 | 4.70 | 36.64 | 14.69 | |||
SO46940_2 | 6ADC-4363-B3 | PO18705126181 | 19 | 291 | 230 | 479 | 6 | 2022-10-03 | 86.52 | 2.16 | 2022-09-21 | 3 | 29.08 | 1 | 86.52 | 2 | SO46940 | 2022-09-28 | 6.92 | 87.24 | 28.84 | |||
SO48761_1 | E39C-4A4E-A3 | PO15312195795 | 19 | 291 | 464 | 299 | 6 | 2023-03-05 | 70.64 | 1.77 | 2023-02-21 | 5 | 9.71 | 1 | 70.64 | 1 | SO48761 | 2023-02-28 | 5.65 | 48.57 | 14.13 | |||
SO44530_18 | 46CE-47C5-B3 | PO10440138648 | 100 | 283 | 292 | 623 | 3 | 2022-01-03 | 2456.10 | 61.40 | 2021-12-22 | 3 | 706.81 | 1 | 2456.10 | 18 | SO44530 | 2021-12-29 | 196.49 | 2120.43 | 818.70 | |||
SO69444_31 | C494-47D6-AF | PO11368134457 | 36 | 295 | 359 | 687 | 8 | 2024-07-03 | 2753.99 | 68.85 | 2024-06-21 | 2 | 1251.98 | 1 | 2753.99 | 31 | SO69444 | 2024-06-28 | 220.32 | 2503.96 | 1376.99 | |||
SO69442_34 | 9833-459C-A2 | PO11658194725 | 100 | 283 | 398 | 233 | 2 | 2024-07-03 | 80.17 | 2.00 | 2024-06-21 | 3 | 19.78 | 1 | 80.17 | 34 | SO69442 | 2024-06-28 | 6.41 | 59.33 | 26.72 | |||
SO51691_7 | 8F72-4342-A4 | PO19923122474 | 100 | 283 | 524 | 18 | 3 | 2023-10-03 | 792.15 | 19.80 | 2023-09-21 | 5 | 144.59 | 1 | 792.15 | 7 | SO51691 | 2023-09-28 | 63.37 | 722.97 | 158.43 | |||
SO51739_49 | AF60-4F2F-9B | PO12702124697 | 100 | 292 | 363 | 175 | 7 | 2023-10-03 | 4130.98 | 103.27 | 2023-09-21 | 3 | 1251.98 | 1 | 4130.98 | 49 | SO51739 | 2023-09-28 | 330.48 | 3755.94 | 1376.99 | |||
SO46042_7 | FE13-4E1B-A4 | PO16646156443 | 100 | 286 | 253 | 1 | 1 | 2022-07-03 | 357.16 | 8.93 | 2022-06-21 | 2 | 176.20 | 1 | 357.16 | 7 | SO46042 | 2022-06-28 | 28.57 | 352.40 | 178.58 | |||
SO53505_29 | B522-40FD-B5 | PO11397144048 | 36 | 295 | 483 | 176 | 8 | 2023-11-03 | 504.00 | 12.60 | 2023-10-22 | 7 | 44.88 | 1 | 504.00 | 29 | SO53505 | 2023-10-29 | 40.32 | 314.16 | 72.00 | |||
SO48734_1 | F5F8-4E2A-98 | PO12644188680 | 100 | 285 | 356 | 530 | 5 | 2023-03-05 | 3728.56 | 93.21 | 2023-02-21 | 3 | 1117.86 | 1 | 3728.56 | 1 | SO48734 | 2023-02-28 | 298.28 | 3353.57 | 1242.85 | |||
SO51137_13 | A47F-4FEF-94 | PO9889144162 | 100 | 285 | 309 | 494 | 5 | 2023-09-02 | 1637.40 | 40.94 | 2023-08-21 | 2 | 747.20 | 1 | 1637.40 | 13 | SO51137 | 2023-08-28 | 130.99 | 1494.40 | 818.70 | |||
SO58908_31 | A429-40BA-96 | PO19285116289 | 98 | 290 | 568 | 448 | 10 | 2024-02-02 | 3563.28 | 89.08 | 2024-01-21 | 8 | 461.44 | 1 | 3563.28 | 31 | SO58908 | 2024-01-28 | 285.06 | 3691.56 | 445.41 | |||
SO51084_23 | 3C77-43D1-83 | PO19575195218 | 98 | 288 | 556 | 34 | 10 | 2023-09-02 | 315.88 | 7.90 | 2023-08-21 | 3 | 77.92 | 1 | 315.88 | 23 | SO51084 | 2023-08-28 | 25.27 | 233.75 | 105.29 | |||
SO50272_37 | E0A6-4CFA-90 | PO11745174916 | 100 | 282 | 224 | 97 | 4 | 2023-07-03 | 20.75 | 0.52 | 2023-06-21 | 4 | 5.23 | 1 | 20.75 | 37 | SO50272 | 2023-06-28 | 1.66 | 20.92 | 5.19 | |||
SO57061_28 | C48C-4776-A7 | PO12702183787 | 100 | 292 | 525 | 175 | 7 | 2024-01-03 | 158.43 | 3.96 | 2023-12-22 | 1 | 144.59 | 1 | 158.43 | 28 | SO57061 | 2023-12-29 | 12.67 | 144.59 | 158.43 | |||
SO71936_10 | 95F1-4758-A0 | PO8671170385 | 98 | 288 | 512 | 502 | 10 | 2024-08-03 | 436.91 | 10.92 | 2024-07-22 | 2 | 199.38 | 1 | 436.91 | 10 | SO71936 | 2024-07-29 | 34.95 | 398.75 | 218.45 | |||
SO44285_13 | 33BA-457C-B7 | PO16617120120 | 100 | 286 | 307 | 397 | 1 | 2021-12-03 | 2890.38 | 72.26 | 2021-11-21 | 4 | 623.84 | 1 | 2890.38 | 13 | SO44285 | 2021-11-28 | 231.23 | 2495.36 | 722.59 | |||
SO50738_27 | 531C-4E52-80 | PO3915159731 | 100 | 281 | 456 | 130 | 4 | 2023-08-03 | 449.94 | 11.25 | 2023-07-22 | 10 | 30.93 | 1 | 449.94 | 27 | SO50738 | 2023-07-29 | 36.00 | 309.33 | 44.99 | |||
SO59008_4 | 4EE7-43A3-A6 | PO5713164207 | 98 | 288 | 562 | 52 | 10 | 2024-02-02 | 8582.65 | 214.57 | 2024-01-21 | 6 | 1481.94 | 1 | 8582.65 | 4 | SO59008 | 2024-01-28 | 686.61 | 8891.63 | 1430.44 | |||
SO43877_4 | 4ECF-42F2-A7 | PO11919119101 | 100 | 286 | 344 | 73 | 1 | 2021-10-03 | 6119.98 | 153.00 | 2021-09-21 | 3 | 1912.15 | 1 | 6119.98 | 4 | SO43877 | 2021-09-28 | 489.60 | 5736.46 | 2039.99 | |||
SO50322_33 | 4BC2-4C6D-83 | PO8845166508 | 100 | 282 | 421 | 546 | 3 | 2023-07-03 | 196.33 | 4.91 | 2023-06-21 | 1 | 145.28 | 1 | 196.33 | 33 | SO50322 | 2023-06-28 | 15.71 | 145.28 | 196.33 | |||
SO45063_5 | B8A8-4744-87 | PO1566189373 | 100 | 281 | 326 | 486 | 2 | 2022-03-05 | 1258.38 | 31.46 | 2022-02-21 | 3 | 413.15 | 1 | 1258.38 | 5 | SO45063 | 2022-02-28 | 100.67 | 1239.44 | 419.46 | |||
SO50301_15 | 94B2-4C2F-8C | PO5684190027 | 100 | 282 | 399 | 385 | 4 | 2023-07-03 | 67.55 | 1.69 | 2023-06-21 | 2 | 24.99 | 1 | 67.55 | 15 | SO50301 | 2023-06-28 | 5.40 | 49.99 | 33.77 | |||
SO47067_3 | DDEC-4319-8A | PO9512118933 | 100 | 285 | 415 | 135 | 5 | 2022-10-03 | 396.07 | 9.90 | 2022-09-21 | 2 | 146.55 | 1 | 396.07 | 3 | SO47067 | 2022-09-28 | 31.69 | 293.09 | 198.04 | |||
SO51822_48 | EEEE-45C1-87 | PO8845178563 | 100 | 282 | 600 | 546 | 3 | 2023-10-03 | 1943.96 | 48.60 | 2023-09-21 | 6 | 294.58 | 1 | 1943.96 | 48 | SO51822 | 2023-09-28 | 155.52 | 1767.48 | 323.99 | |||
SO44514_3 | 7135-4E3F-B3 | PO14500153038 | 100 | 282 | 293 | 650 | 1 | 2022-01-03 | 722.59 | 18.06 | 2021-12-22 | 1 | 623.84 | 1 | 722.59 | 3 | SO44514 | 2021-12-29 | 57.81 | 623.84 | 722.59 | |||
SO47725_37 | 2501-4A1D-99 | PO9831133395 | 100 | 285 | 385 | 81 | 5 | 2022-12-03 | 1200.53 | 30.01 | 2022-11-21 | 2 | 605.65 | 1 | 1200.53 | 37 | SO47725 | 2022-11-28 | 96.04 | 1211.30 | 600.26 | |||
SO51090_50 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 217 | 11 | 475 | 4 | 18.89 | 2023-09-02 | 125.96 | 2.68 | 2023-08-21 | 8 | 13.09 | 1 | 107.07 | 50 | SO51090 | 2023-08-28 | 8.57 | 104.69 | 15.75 | 0.15 |
SO47663_26 | 1B17-4C63-B6 | PO18444192283 | 19 | 291 | 271 | 227 | 6 | 2022-12-03 | 202.33 | 5.06 | 2022-11-21 | 1 | 187.16 | 1 | 202.33 | 26 | SO47663 | 2022-11-28 | 16.19 | 187.16 | 202.33 | |||
SO50297_22 | 5199-40AD-90 | PO4727113542 | 100 | 293 | 464 | 343 | 1 | 2023-07-03 | 42.39 | 1.06 | 2023-06-21 | 3 | 9.71 | 1 | 42.39 | 22 | SO50297 | 2023-06-28 | 3.39 | 29.14 | 14.13 | |||
SO58905_6 | 79BE-4713-94 | PO19604111681 | 98 | 288 | 359 | 340 | 10 | 2024-02-02 | 1376.99 | 34.42 | 2024-01-21 | 1 | 1251.98 | 1 | 1376.99 | 6 | SO58905 | 2024-01-28 | 110.16 | 1251.98 | 1376.99 | |||
SO57137_30 | 9401-4518-A4 | PO6438194874 | 100 | 281 | 598 | 309 | 4 | 2024-01-03 | 971.98 | 24.30 | 2023-12-22 | 3 | 294.58 | 1 | 971.98 | 30 | SO57137 | 2023-12-29 | 77.76 | 883.74 | 323.99 | |||
SO53512_28 | 6AC2-4C2F-81 | PO10353157108 | 98 | 290 | 532 | 88 | 10 | 2023-11-03 | 599.50 | 14.99 | 2023-10-22 | 4 | 136.79 | 1 | 599.50 | 28 | SO53512 | 2023-10-29 | 47.96 | 547.14 | 149.87 | |||
SO47452_3 | 79C0-49E8-B3 | PO8903162839 | 100 | 286 | 325 | 235 | 1 | 2022-11-03 | 469.79 | 11.74 | 2022-10-22 | 1 | 486.71 | 1 | 469.79 | 3 | SO47452 | 2022-10-29 | 37.58 | 486.71 | 469.79 | |||
SO49085_4 | 7265-4D98-80 | PO19198152404 | 19 | 291 | 308 | 653 | 6 | 2023-04-05 | 2977.09 | 74.43 | 2023-03-24 | 4 | 660.91 | 1 | 2977.09 | 4 | SO49085 | 2023-03-31 | 238.17 | 2643.66 | 744.27 | |||
SO53562_34 | 9FC2-4D08-A7 | PO8468156175 | 98 | 288 | 545 | 16 | 10 | 2023-11-03 | 72.88 | 1.82 | 2023-10-22 | 3 | 17.98 | 1 | 72.88 | 34 | SO53562 | 2023-10-29 | 5.83 | 53.93 | 24.29 | |||
SO47037_15 | C1AE-48A5-9F | PO4901170321 | 19 | 284 | 267 | 84 | 6 | 2022-10-03 | 607.00 | 15.17 | 2022-09-21 | 3 | 187.16 | 1 | 607.00 | 15 | SO47037 | 2022-09-28 | 48.56 | 561.47 | 202.33 |
Generated 2024-09-20 08:50:09.787 UTC