[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 30 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO43913_1 | AD88-49ED-90 | PO7830112696 | 100 | 283 | 349 | 40 | 4 | 2021-10-04 | 8099.98 | 202.50 | 2021-09-22 | 4 | 1898.09 | 1 | 8099.98 | 1 | SO43913 | 2021-09-29 | 648.00 | 7592.38 | 2024.99 | |||
SO61218_11 | 8441-4C6F-89 | PO13688193778 | 100 | 282 | 476 | 475 | 4 | 2024-03-05 | 251.96 | 6.30 | 2024-02-22 | 6 | 26.18 | 1 | 251.96 | 11 | SO61218 | 2024-02-29 | 20.16 | 157.06 | 41.99 | |||
SO44768_17 | 18BD-48B8-95 | PO261164909 | 100 | 283 | 272 | 647 | 4 | 2022-02-03 | 183.94 | 4.60 | 2022-01-22 | 1 | 181.49 | 1 | 183.94 | 17 | SO44768 | 2022-01-29 | 14.72 | 181.49 | 183.94 | |||
SO45799_1 | 4DE8-4B9B-A1 | PO10730195041 | 100 | 287 | 326 | 491 | 4 | 2022-06-04 | 419.46 | 10.49 | 2022-05-23 | 1 | 413.15 | 1 | 419.46 | 1 | SO45799 | 2022-05-30 | 33.56 | 413.15 | 419.46 | |||
SO48069_24 | 60CF-43B6-82 | PO6438117188 | 100 | 283 | 458 | 309 | 4 | 2023-01-04 | 224.97 | 5.62 | 2022-12-23 | 5 | 30.93 | 1 | 224.97 | 24 | SO48069 | 2022-12-30 | 18.00 | 154.67 | 44.99 | |||
SO46342_8 | 9BA4-4F6E-96 | PO14964115309 | 100 | 287 | 348 | 7 | 581 | 4 | 885.93 | 2022-08-04 | 2531.24 | 41.13 | 2022-07-23 | 3 | 1898.09 | 1 | 1645.31 | 8 | SO46342 | 2022-07-30 | 131.62 | 5694.28 | 843.75 | 0.35 |
SO48295_17 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 327 | 2 | 24 | 4 | 127.16 | 2023-02-03 | 6357.88 | 155.77 | 2023-01-22 | 14 | 486.71 | 1 | 6230.72 | 17 | SO48295 | 2023-01-29 | 498.46 | 6813.89 | 454.13 | 0.02 |
SO48066_7 | F00E-4B06-9D | PO5684167807 | 100 | 282 | 358 | 385 | 4 | 2023-01-04 | 3688.38 | 92.21 | 2022-12-23 | 3 | 1105.81 | 1 | 3688.38 | 7 | SO48066 | 2022-12-30 | 295.07 | 3317.43 | 1229.46 | |||
SO63285_3 | 6316-44BB-8E | PO3480176259 | 100 | 281 | 484 | 436 | 4 | 2024-04-05 | 19.08 | 0.48 | 2024-03-24 | 4 | 2.97 | 1 | 19.08 | 3 | SO63285 | 2024-03-31 | 1.53 | 11.89 | 4.77 | |||
SO50663_17 | 286E-4915-89 | PO19343130555 | 100 | 282 | 327 | 2 | 24 | 4 | 99.91 | 2023-08-04 | 4995.48 | 122.39 | 2023-07-23 | 11 | 486.71 | 1 | 4895.57 | 17 | SO50663 | 2023-07-30 | 391.65 | 5353.77 | 454.13 | 0.02 |
SO57137_4 | 9401-4518-A4 | PO6438194874 | 100 | 281 | 231 | 309 | 4 | 2024-01-04 | 89.98 | 2.25 | 2023-12-23 | 3 | 38.49 | 1 | 89.98 | 4 | SO57137 | 2023-12-30 | 7.20 | 115.48 | 29.99 | |||
SO45299_4 | 0D55-4B85-AD | PO12557162961 | 100 | 282 | 338 | 240 | 4 | 2022-04-06 | 2097.29 | 52.43 | 2022-03-25 | 5 | 413.15 | 1 | 2097.29 | 4 | SO45299 | 2022-04-01 | 167.78 | 2065.73 | 419.46 | |||
SO43912_15 | 69B6-46F8-A4 | PO7656175368 | 100 | 282 | 285 | 403 | 4 | 2021-10-04 | 178.58 | 4.46 | 2021-09-22 | 1 | 176.20 | 1 | 178.58 | 15 | SO43912 | 2021-09-29 | 14.29 | 176.20 | 178.58 | |||
SO51809_32 | F690-4F1D-B1 | PO6438145374 | 100 | 281 | 465 | 309 | 4 | 2023-10-04 | 73.47 | 1.84 | 2023-09-22 | 5 | 9.16 | 1 | 73.47 | 32 | SO51809 | 2023-09-29 | 5.88 | 45.80 | 14.69 | |||
SO50707_5 | C071-42D6-B3 | PO16124195115 | 100 | 282 | 433 | 649 | 4 | 2023-08-04 | 324.45 | 8.11 | 2023-07-23 | 1 | 300.12 | 1 | 324.45 | 5 | SO50707 | 2023-07-30 | 25.96 | 300.12 | 324.45 | |||
SO67320_20 | 771C-4E57-91 | PO5626199373 | 100 | 281 | 583 | 166 | 4 | 2024-06-04 | 9185.35 | 229.63 | 2024-05-23 | 9 | 1082.51 | 1 | 9185.35 | 20 | SO67320 | 2024-05-30 | 734.83 | 9742.59 | 1020.59 | |||
SO46970_15 | 01AF-420A-B9 | PO15196114472 | 100 | 282 | 387 | 258 | 4 | 2022-10-04 | 600.26 | 15.01 | 2022-09-22 | 1 | 605.65 | 1 | 600.26 | 15 | SO46970 | 2022-09-29 | 48.02 | 605.65 | 600.26 | |||
SO63240_21 | AC0A-4F08-91 | PO4611157476 | 100 | 287 | 552 | 131 | 4 | 2024-04-05 | 109.79 | 2.74 | 2024-03-24 | 2 | 40.62 | 1 | 109.79 | 21 | SO63240 | 2024-03-31 | 8.78 | 81.24 | 54.89 | |||
SO44564_12 | 142F-443C-90 | PO7656157194 | 100 | 282 | 319 | 403 | 4 | 2022-01-04 | 874.79 | 21.87 | 2021-12-23 | 1 | 884.71 | 1 | 874.79 | 12 | SO44564 | 2021-12-30 | 69.98 | 884.71 | 874.79 | |||
SO50738_25 | 531C-4E52-80 | PO3915159731 | 100 | 281 | 224 | 130 | 4 | 2023-08-04 | 41.49 | 1.04 | 2023-07-23 | 8 | 5.23 | 1 | 41.49 | 25 | SO50738 | 2023-07-30 | 3.32 | 41.84 | 5.19 | |||
SO55264_45 | 80F3-4A7B-A2 | PO10730163005 | 100 | 287 | 418 | 491 | 4 | 2023-12-04 | 356.90 | 8.92 | 2023-11-22 | 1 | 360.94 | 1 | 356.90 | 45 | SO55264 | 2023-11-29 | 28.55 | 360.94 | 356.90 | |||
SO45059_3 | C618-4998-BE | PO10730115502 | 100 | 287 | 232 | 491 | 4 | 2022-03-06 | 57.68 | 1.44 | 2022-02-22 | 2 | 31.72 | 1 | 57.68 | 3 | SO45059 | 2022-03-01 | 4.61 | 63.45 | 28.84 | |||
SO48375_37 | B5F1-4C2A-94 | PO5597156214 | 100 | 283 | 470 | 75 | 4 | 2023-02-03 | 182.35 | 4.56 | 2023-01-22 | 8 | 15.67 | 1 | 182.35 | 37 | SO48375 | 2023-01-29 | 14.59 | 125.37 | 22.79 | |||
SO55282_20 | A72A-4D3A-BA | PO16298125578 | 100 | 287 | 570 | 599 | 4 | 2023-12-04 | 890.82 | 22.27 | 2023-11-22 | 2 | 461.44 | 1 | 890.82 | 20 | SO55282 | 2023-11-29 | 71.27 | 922.89 | 445.41 | |||
SO53614_23 | A1C5-4C4D-9C | PO6757196330 | 100 | 281 | 599 | 21 | 4 | 2023-11-04 | 1295.98 | 32.40 | 2023-10-23 | 4 | 294.58 | 1 | 1295.98 | 23 | SO53614 | 2023-10-30 | 103.68 | 1178.32 | 323.99 | |||
SO48396_2 | F55B-45AE-8B | PO9715142000 | 100 | 283 | 469 | 490 | 4 | 2023-02-03 | 227.94 | 5.70 | 2023-01-22 | 10 | 15.67 | 1 | 227.94 | 2 | SO48396 | 2023-01-29 | 18.24 | 156.71 | 22.79 | |||
SO71952_11 | 9490-4552-81 | PO9715163911 | 100 | 281 | 543 | 490 | 4 | 2024-08-04 | 74.51 | 1.86 | 2024-07-23 | 2 | 27.57 | 1 | 74.51 | 11 | SO71952 | 2024-07-30 | 5.96 | 55.14 | 37.25 | |||
SO51855_16 | 8551-4CDF-A1 | PO3480115731 | 100 | 281 | 483 | 436 | 4 | 2023-10-04 | 576.00 | 14.40 | 2023-09-22 | 8 | 44.88 | 1 | 576.00 | 16 | SO51855 | 2023-09-29 | 46.08 | 359.04 | 72.00 | |||
SO65193_1 | 59C0-42E7-8F | PO13021128161 | 100 | 282 | 372 | 276 | 4 | 2024-05-04 | 1466.01 | 36.65 | 2024-04-22 | 1 | 1554.95 | 1 | 1466.01 | 1 | SO65193 | 2024-04-29 | 117.28 | 1554.95 | 1466.01 | |||
SO48370_11 | 2BBA-46FF-BD | PO4640118571 | 100 | 287 | 409 | 648 | 4 | 2023-02-03 | 209.26 | 5.23 | 2023-01-22 | 1 | 185.82 | 1 | 209.26 | 11 | SO48370 | 2023-01-29 | 16.74 | 185.82 | 209.26 | |||
SO48071_4 | E6F7-41F8-92 | PO6525193011 | 100 | 283 | 421 | 345 | 4 | 2023-01-04 | 1177.97 | 29.45 | 2022-12-23 | 6 | 145.28 | 1 | 1177.97 | 4 | SO48071 | 2022-12-30 | 94.24 | 871.70 | 196.33 | |||
SO57137_48 | 9401-4518-A4 | PO6438194874 | 100 | 281 | 476 | 309 | 4 | 2024-01-04 | 293.96 | 7.35 | 2023-12-23 | 7 | 26.18 | 1 | 293.96 | 48 | SO57137 | 2023-12-30 | 23.52 | 183.23 | 41.99 | |||
SO51855_38 | 8551-4CDF-A1 | PO3480115731 | 100 | 281 | 434 | 436 | 4 | 2023-10-04 | 1427.59 | 35.69 | 2023-09-22 | 4 | 360.94 | 1 | 1427.59 | 38 | SO51855 | 2023-09-29 | 114.21 | 1443.77 | 356.90 | |||
SO44315_3 | 286E-40C7-A5 | PO6409154434 | 100 | 283 | 232 | 292 | 4 | 2021-12-04 | 28.84 | 0.72 | 2021-11-22 | 1 | 31.72 | 1 | 28.84 | 3 | SO44315 | 2021-11-29 | 2.31 | 31.72 | 28.84 | |||
SO50289_4 | 0809-4DE4-93 | PO3480117331 | 100 | 281 | 459 | 436 | 4 | 2023-07-04 | 215.98 | 5.40 | 2023-06-22 | 4 | 37.12 | 1 | 215.98 | 4 | SO50289 | 2023-06-29 | 17.28 | 148.48 | 53.99 | |||
SO46069_7 | 29F6-4D30-91 | PO609194739 | 100 | 282 | 223 | 492 | 4 | 2022-07-04 | 10.37 | 0.26 | 2022-06-22 | 2 | 5.71 | 1 | 10.37 | 7 | SO46069 | 2022-06-29 | 0.83 | 11.41 | 5.19 | |||
SO65209_18 | B869-4DFD-AB | PO2697179473 | 100 | 282 | 398 | 187 | 4 | 2024-05-04 | 53.45 | 1.34 | 2024-04-22 | 2 | 19.78 | 1 | 53.45 | 18 | SO65209 | 2024-04-29 | 4.28 | 39.55 | 26.72 | |||
SO63212_4 | B54D-4C63-85 | PO5684113881 | 100 | 282 | 476 | 3 | 385 | 4 | 28.87 | 2024-04-05 | 577.42 | 13.71 | 2024-03-24 | 15 | 26.18 | 1 | 548.55 | 4 | SO63212 | 2024-03-31 | 43.88 | 392.64 | 38.49 | 0.05 |
SO55251_16 | 2481-4FF1-80 | PO13659159365 | 100 | 287 | 309 | 437 | 4 | 2023-12-04 | 818.70 | 20.47 | 2023-11-22 | 1 | 747.20 | 1 | 818.70 | 16 | SO55251 | 2023-11-29 | 65.50 | 747.20 | 818.70 | |||
SO46364_10 | BC3C-4FE8-AC | PO3248115921 | 100 | 282 | 347 | 7 | 366 | 4 | 595.00 | 2022-08-04 | 1700.00 | 27.62 | 2022-07-23 | 2 | 1912.15 | 1 | 1105.00 | 10 | SO46364 | 2022-07-30 | 88.40 | 3824.31 | 850.00 | 0.35 |
SO46076_6 | E898-4203-B0 | PO2523131751 | 100 | 287 | 317 | 167 | 4 | 2022-07-04 | 1749.59 | 43.74 | 2022-06-22 | 2 | 884.71 | 1 | 1749.59 | 6 | SO46076 | 2022-06-29 | 139.97 | 1769.42 | 874.79 | |||
SO47400_39 | F0B3-44C1-8F | PO10701186775 | 100 | 282 | 457 | 133 | 4 | 2022-11-04 | 314.96 | 7.87 | 2022-10-23 | 7 | 30.93 | 1 | 314.96 | 39 | SO47400 | 2022-10-30 | 25.20 | 216.53 | 44.99 | |||
SO63180_17 | B8CD-47BA-8C | PO2523117609 | 100 | 287 | 382 | 167 | 4 | 2024-04-05 | 672.29 | 16.81 | 2024-03-24 | 1 | 713.08 | 1 | 672.29 | 17 | SO63180 | 2024-03-31 | 53.78 | 713.08 | 672.29 | |||
SO55276_25 | 81AA-41E5-B0 | PO2755182998 | 100 | 282 | 560 | 205 | 4 | 2023-12-04 | 4373.46 | 109.34 | 2023-11-22 | 6 | 755.15 | 1 | 4373.46 | 25 | SO55276 | 2023-11-29 | 349.88 | 4530.90 | 728.91 | |||
SO47369_11 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 233 | 2 | 239 | 4 | 6.69 | 2022-11-04 | 334.55 | 8.20 | 2022-10-23 | 12 | 29.08 | 1 | 327.86 | 11 | SO47369 | 2022-10-30 | 26.23 | 348.97 | 27.88 | 0.02 |
SO51090_33 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 465 | 475 | 4 | 2023-09-03 | 117.55 | 2.94 | 2023-08-22 | 8 | 9.16 | 1 | 117.55 | 33 | SO51090 | 2023-08-29 | 9.40 | 73.27 | 14.69 | |||
SO65183_2 | 4E49-448C-93 | PO16269127603 | 100 | 287 | 581 | 624 | 4 | 2024-05-04 | 3061.78 | 76.54 | 2024-04-22 | 3 | 1082.51 | 1 | 3061.78 | 2 | SO65183 | 2024-04-29 | 244.94 | 3247.53 | 1020.59 | |||
SO51126_10 | 7A9E-43B4-B3 | PO2755153471 | 100 | 282 | 498 | 205 | 4 | 2023-09-03 | 602.35 | 15.06 | 2023-08-22 | 1 | 601.74 | 1 | 602.35 | 10 | SO51126 | 2023-08-29 | 48.19 | 601.74 | 602.35 | |||
SO49523_7 | 852E-47A8-A9 | PO3915144057 | 100 | 281 | 389 | 130 | 4 | 2023-05-04 | 600.26 | 15.01 | 2023-04-22 | 1 | 605.65 | 1 | 600.26 | 7 | SO49523 | 2023-04-29 | 48.02 | 605.65 | 600.26 | |||
SO48356_12 | 3E64-467F-90 | PO2697152207 | 100 | 282 | 354 | 187 | 4 | 2023-02-03 | 1242.85 | 31.07 | 2023-01-22 | 1 | 1117.86 | 1 | 1242.85 | 12 | SO48356 | 2023-01-29 | 99.43 | 1117.86 | 1242.85 | |||
SO44520_27 | 5BE0-436B-8C | PO12499152870 | 100 | 282 | 320 | 78 | 4 | 2022-01-04 | 419.46 | 10.49 | 2021-12-23 | 1 | 413.15 | 1 | 419.46 | 27 | SO44520 | 2021-12-30 | 33.56 | 413.15 | 419.46 | |||
SO57145_42 | 4C59-4193-B1 | PO3654153385 | 100 | 281 | 551 | 435 | 4 | 2024-01-04 | 316.86 | 7.92 | 2023-12-23 | 2 | 144.59 | 1 | 316.86 | 42 | SO57145 | 2023-12-30 | 25.35 | 289.19 | 158.43 | |||
SO51131_20 | D489-4DF3-A2 | PO16298169856 | 100 | 287 | 575 | 599 | 4 | 2023-09-03 | 5721.77 | 143.04 | 2023-08-22 | 4 | 1481.94 | 1 | 5721.77 | 20 | SO51131 | 2023-08-29 | 457.74 | 5927.75 | 1430.44 | |||
SO47417_24 | 1CE8-4651-A9 | PO2697165938 | 100 | 282 | 305 | 187 | 4 | 2022-11-04 | 1472.29 | 36.81 | 2022-10-23 | 2 | 653.70 | 1 | 1472.29 | 24 | SO47417 | 2022-10-30 | 117.78 | 1307.39 | 736.15 | |||
SO63271_1 | 0CB4-42F0-B3 | PO4553157746 | 100 | 282 | 482 | 313 | 4 | 2024-04-05 | 32.36 | 0.81 | 2024-03-24 | 6 | 3.36 | 1 | 32.36 | 1 | SO63271 | 2024-03-31 | 2.59 | 20.17 | 5.39 | |||
SO49489_4 | 7419-48A5-B8 | PO16182158783 | 100 | 287 | 468 | 23 | 4 | 2023-05-04 | 113.97 | 2.85 | 2023-04-22 | 5 | 15.67 | 1 | 113.97 | 4 | SO49489 | 2023-04-29 | 9.12 | 78.35 | 22.79 | |||
SO71849_11 | D1AA-4C46-B9 | PO18125130930 | 100 | 287 | 376 | 311 | 4 | 2024-08-04 | 2932.02 | 73.30 | 2024-07-23 | 2 | 1554.95 | 1 | 2932.02 | 11 | SO71849 | 2024-07-30 | 234.56 | 3109.90 | 1466.01 | |||
SO46638_47 | 9659-44CE-A2 | PO10817110834 | 100 | 287 | 254 | 203 | 4 | 2022-09-03 | 367.88 | 9.20 | 2022-08-22 | 2 | 170.14 | 1 | 367.88 | 47 | SO46638 | 2022-08-29 | 29.43 | 340.29 | 183.94 | |||
SO47045_12 | 9DDC-4176-90 | PO6438144434 | 100 | 283 | 352 | 309 | 4 | 2022-10-04 | 12428.52 | 310.71 | 2022-09-22 | 10 | 1117.86 | 1 | 12428.52 | 12 | SO47045 | 2022-09-29 | 994.28 | 11178.56 | 1242.85 | |||
SO48769_16 | A39E-4380-A6 | PO7859190388 | 100 | 287 | 458 | 221 | 4 | 2023-03-06 | 134.98 | 3.37 | 2023-02-22 | 3 | 30.93 | 1 | 134.98 | 16 | SO48769 | 2023-03-01 | 10.80 | 92.80 | 44.99 |
Generated 2024-09-21 07:29:44.231 UTC