[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '3' > SHUFFLE < SKIP 1001 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47716_34 | 619E-46D6-98 | PO6467148836 | 100 | 281 | 329 | 660 | 3 | 2022-12-04 | 939.59 | 23.49 | 2022-11-22 | 2 | 486.71 | 1 | 939.59 | 34 | SO47716 | 2022-11-29 | 75.17 | 973.41 | 469.79 | |||
SO47426_1 | 9D6D-42F0-A2 | PO4147153085 | 100 | 282 | 375 | 222 | 3 | 2022-11-04 | 1308.94 | 32.72 | 2022-10-23 | 1 | 1320.68 | 1 | 1308.94 | 1 | SO47426 | 2022-10-30 | 104.72 | 1320.68 | 1308.94 | |||
SO63191_4 | 0BB3-4473-A5 | PO15254189937 | 100 | 283 | 605 | 377 | 3 | 2024-04-05 | 323.99 | 8.10 | 2024-03-24 | 1 | 343.65 | 1 | 323.99 | 4 | SO63191 | 2024-03-31 | 25.92 | 343.65 | 323.99 | |||
SO69418_33 | D0CE-41AD-AA | PO15370180703 | 100 | 281 | 511 | 381 | 3 | 2024-07-04 | 655.36 | 16.38 | 2024-06-22 | 3 | 199.38 | 1 | 655.36 | 33 | SO69418 | 2024-06-29 | 52.43 | 598.13 | 218.45 | |||
SO46621_5 | DCA1-4F74-BD | PO13949117076 | 100 | 281 | 325 | 643 | 3 | 2022-09-03 | 469.79 | 11.74 | 2022-08-22 | 1 | 486.71 | 1 | 469.79 | 5 | SO46621 | 2022-08-29 | 37.58 | 486.71 | 469.79 | |||
SO49837_19 | C136-4536-9D | PO12412160791 | 100 | 281 | 325 | 670 | 3 | 2023-06-04 | 2818.76 | 70.47 | 2023-05-23 | 6 | 486.71 | 1 | 2818.76 | 19 | SO49837 | 2023-05-30 | 225.50 | 2920.24 | 469.79 | |||
SO67327_15 | 2D2C-4C57-A2 | PO6467126287 | 100 | 283 | 584 | 660 | 3 | 2024-06-04 | 323.99 | 8.10 | 2024-05-23 | 1 | 343.65 | 1 | 323.99 | 15 | SO67327 | 2024-05-30 | 25.92 | 343.65 | 323.99 | |||
SO65155_3 | 154D-4EBA-85 | PO19633122185 | 100 | 287 | 359 | 149 | 3 | 2024-05-04 | 5507.98 | 137.70 | 2024-04-22 | 4 | 1251.98 | 1 | 5507.98 | 3 | SO65155 | 2024-04-29 | 440.64 | 5007.93 | 1376.99 | |||
SO47419_8 | 7703-4F2C-92 | PO3103122578 | 100 | 283 | 271 | 147 | 3 | 2022-11-04 | 202.33 | 5.06 | 2022-10-23 | 1 | 187.16 | 1 | 202.33 | 8 | SO47419 | 2022-10-30 | 16.19 | 187.16 | 202.33 | |||
SO69503_12 | 559D-4568-82 | PO5771124379 | 100 | 282 | 390 | 79 | 3 | 2024-07-04 | 4033.76 | 100.84 | 2024-06-22 | 6 | 713.08 | 1 | 4033.76 | 12 | SO69503 | 2024-06-29 | 322.70 | 4278.48 | 672.29 | |||
SO71779_23 | CD9F-4322-BC | PO19633118218 | 100 | 272 | 592 | 16 | 149 | 3 | 90.40 | 2024-08-04 | 226.00 | 3.39 | 2024-07-23 | 2 | 308.22 | 1 | 135.60 | 23 | SO71779 | 2024-07-30 | 10.85 | 616.44 | 113.00 | 0.40 |
SO48349_14 | CD94-4B46-9E | PO1624135169 | 100 | 283 | 415 | 579 | 3 | 2023-02-03 | 198.04 | 4.95 | 2023-01-22 | 1 | 146.55 | 1 | 198.04 | 14 | SO48349 | 2023-01-29 | 15.84 | 146.55 | 198.04 | |||
SO47394_11 | 7FC9-4002-83 | PO12354143510 | 100 | 281 | 411 | 197 | 3 | 2022-11-04 | 376.25 | 9.41 | 2022-10-23 | 3 | 92.81 | 1 | 376.25 | 11 | SO47394 | 2022-10-30 | 30.10 | 278.42 | 125.42 | |||
SO63257_20 | B81B-4565-85 | PO5771197507 | 100 | 282 | 484 | 79 | 3 | 2024-04-05 | 4.77 | 0.12 | 2024-03-24 | 1 | 2.97 | 1 | 4.77 | 20 | SO63257 | 2024-03-31 | 0.38 | 2.97 | 4.77 | |||
SO43884_4 | 728A-44AB-A8 | PO10440182311 | 100 | 283 | 232 | 623 | 3 | 2021-10-04 | 288.40 | 7.21 | 2021-09-22 | 10 | 31.72 | 1 | 288.40 | 4 | SO43884 | 2021-09-29 | 23.07 | 317.24 | 28.84 | |||
SO46629_6 | E8D3-4649-8A | PO12412165004 | 100 | 283 | 339 | 670 | 3 | 2022-09-03 | 2348.97 | 58.72 | 2022-08-22 | 5 | 486.71 | 1 | 2348.97 | 6 | SO46629 | 2022-08-29 | 187.92 | 2433.53 | 469.79 | |||
SO48292_24 | 7546-4477-B2 | PO19633112676 | 100 | 287 | 356 | 149 | 3 | 2023-02-03 | 7457.11 | 186.43 | 2023-01-22 | 6 | 1117.86 | 1 | 7457.11 | 24 | SO48292 | 2023-01-29 | 596.57 | 6707.14 | 1242.85 | |||
SO51085_23 | EB9F-4A76-97 | PO19314178917 | 100 | 281 | 465 | 622 | 3 | 2023-09-03 | 29.39 | 0.73 | 2023-08-22 | 2 | 9.16 | 1 | 29.39 | 23 | SO51085 | 2023-08-29 | 2.35 | 18.32 | 14.69 | |||
SO48325_13 | 0A85-48D3-97 | PO14268111638 | 100 | 283 | 433 | 418 | 3 | 2023-02-03 | 324.45 | 8.11 | 2023-01-22 | 1 | 300.12 | 1 | 324.45 | 13 | SO48325 | 2023-01-29 | 25.96 | 300.12 | 324.45 | |||
SO45520_1 | 86A2-4B9B-8D | PO19488171523 | 100 | 283 | 330 | 57 | 3 | 2022-05-04 | 419.46 | 10.49 | 2022-04-22 | 1 | 413.15 | 1 | 419.46 | 1 | SO45520 | 2022-04-29 | 33.56 | 413.15 | 419.46 | |||
SO67332_7 | E97E-4BCF-92 | PO6235122123 | 100 | 283 | 605 | 431 | 3 | 2024-06-04 | 647.99 | 16.20 | 2024-05-23 | 2 | 343.65 | 1 | 647.99 | 7 | SO67332 | 2024-05-30 | 51.84 | 687.30 | 323.99 | |||
SO44287_2 | 74DB-49F5-90 | PO15428122091 | 100 | 283 | 350 | 646 | 3 | 2021-12-04 | 4049.99 | 101.25 | 2021-11-22 | 2 | 1898.09 | 1 | 4049.99 | 2 | SO44287 | 2021-11-29 | 324.00 | 3796.19 | 2024.99 | |||
SO47384_26 | 8780-4D54-85 | PO14268113342 | 100 | 283 | 368 | 418 | 3 | 2022-11-04 | 4398.03 | 109.95 | 2022-10-23 | 3 | 1518.79 | 1 | 4398.03 | 26 | SO47384 | 2022-10-30 | 351.84 | 4556.36 | 1466.01 | |||
SO45520_15 | 86A2-4B9B-8D | PO19488171523 | 100 | 283 | 223 | 57 | 3 | 2022-05-04 | 10.37 | 0.26 | 2022-04-22 | 2 | 5.71 | 1 | 10.37 | 15 | SO45520 | 2022-04-29 | 0.83 | 11.41 | 5.19 | |||
SO49093_18 | A0B1-4C01-8A | PO15370113221 | 100 | 281 | 367 | 381 | 3 | 2023-04-06 | 1943.98 | 48.60 | 2023-03-25 | 3 | 598.44 | 1 | 1943.98 | 18 | SO49093 | 2023-04-01 | 155.52 | 1795.31 | 647.99 | |||
SO48333_19 | 4838-404D-8A | PO12354194454 | 100 | 281 | 352 | 197 | 3 | 2023-02-03 | 1242.85 | 31.07 | 2023-01-22 | 1 | 1117.86 | 1 | 1242.85 | 19 | SO48333 | 2023-01-29 | 99.43 | 1117.86 | 1242.85 | |||
SO65221_1 | 0AC4-40AE-B6 | PO15341198427 | 100 | 281 | 217 | 327 | 3 | 2024-05-04 | 62.98 | 1.57 | 2024-04-22 | 3 | 13.09 | 1 | 62.98 | 1 | SO65221 | 2024-04-29 | 5.04 | 39.26 | 20.99 | |||
SO47409_10 | FC23-4384-86 | PO1624119173 | 100 | 283 | 321 | 579 | 3 | 2022-11-04 | 939.59 | 23.49 | 2022-10-23 | 2 | 486.71 | 1 | 939.59 | 10 | SO47409 | 2022-10-30 | 75.17 | 973.41 | 469.79 | |||
SO47716_9 | 619E-46D6-98 | PO6467148836 | 100 | 281 | 414 | 660 | 3 | 2022-12-04 | 447.09 | 11.18 | 2022-11-22 | 3 | 110.28 | 1 | 447.09 | 9 | SO47716 | 2022-11-29 | 35.77 | 330.85 | 149.03 | |||
SO49119_1 | 92B0-4959-B5 | PO15254156972 | 100 | 283 | 323 | 377 | 3 | 2023-04-06 | 1409.38 | 35.23 | 2023-03-25 | 3 | 486.71 | 1 | 1409.38 | 1 | SO49119 | 2023-04-01 | 112.75 | 1460.12 | 469.79 | |||
SO49880_2 | E43C-4D1F-9F | PO4350182387 | 100 | 281 | 233 | 274 | 3 | 2023-06-04 | 144.20 | 3.61 | 2023-05-23 | 5 | 29.08 | 1 | 144.20 | 2 | SO49880 | 2023-05-30 | 11.54 | 145.40 | 28.84 | |||
SO46066_1 | ADF8-444D-9C | PO10759115463 | 100 | 283 | 346 | 346 | 3 | 2022-07-04 | 6119.98 | 153.00 | 2022-06-22 | 3 | 1912.15 | 1 | 6119.98 | 1 | SO46066 | 2022-06-29 | 489.60 | 5736.46 | 2039.99 | |||
SO63152_10 | CCD6-4821-96 | PO15283111190 | 100 | 281 | 574 | 363 | 3 | 2024-04-05 | 2860.88 | 71.52 | 2024-03-24 | 2 | 1481.94 | 1 | 2860.88 | 10 | SO63152 | 2024-03-31 | 228.87 | 2963.88 | 1430.44 | |||
SO46367_19 | EF40-4AFF-B2 | PO4147155635 | 100 | 282 | 310 | 222 | 3 | 2022-08-04 | 4293.92 | 107.35 | 2022-07-23 | 2 | 2171.29 | 1 | 4293.92 | 19 | SO46367 | 2022-07-30 | 343.51 | 4342.59 | 2146.96 | |||
SO45308_8 | 81AA-4F3D-A7 | PO10440184078 | 100 | 283 | 223 | 623 | 3 | 2022-04-06 | 46.68 | 1.17 | 2022-03-25 | 9 | 5.71 | 1 | 46.68 | 8 | SO45308 | 2022-04-01 | 3.73 | 51.35 | 5.19 | |||
SO46931_23 | EE3D-4B0A-B6 | PO19923131204 | 100 | 281 | 469 | 18 | 3 | 2022-10-04 | 45.59 | 1.14 | 2022-09-22 | 2 | 15.67 | 1 | 45.59 | 23 | SO46931 | 2022-09-29 | 3.65 | 31.34 | 22.79 | |||
SO45343_16 | 9A71-4101-BA | PO8874137222 | 100 | 282 | 296 | 348 | 3 | 2022-04-06 | 1429.41 | 35.74 | 2022-03-25 | 2 | 617.03 | 1 | 1429.41 | 16 | SO45343 | 2022-04-01 | 114.35 | 1234.06 | 714.70 | |||
SO44528_11 | D619-4D58-9D | PO10759143910 | 100 | 283 | 350 | 346 | 3 | 2022-01-04 | 18224.95 | 455.62 | 2021-12-23 | 9 | 1898.09 | 1 | 18224.95 | 11 | SO44528 | 2021-12-30 | 1458.00 | 17082.85 | 2024.99 | |||
SO55242_3 | 9E27-4B65-8B | PO15399135038 | 100 | 281 | 483 | 220 | 3 | 2023-12-04 | 288.00 | 7.20 | 2023-11-22 | 4 | 44.88 | 1 | 288.00 | 3 | SO55242 | 2023-11-29 | 23.04 | 179.52 | 72.00 | |||
SO51085_21 | EB9F-4A76-97 | PO19314178917 | 100 | 281 | 482 | 622 | 3 | 2023-09-03 | 48.55 | 1.21 | 2023-08-22 | 9 | 3.36 | 1 | 48.55 | 21 | SO51085 | 2023-08-29 | 3.88 | 30.26 | 5.39 | |||
SO44550_18 | 0BDF-4CBE-88 | PO5191121845 | 100 | 283 | 319 | 364 | 3 | 2022-01-04 | 874.79 | 21.87 | 2021-12-23 | 1 | 884.71 | 1 | 874.79 | 18 | SO44550 | 2021-12-30 | 69.98 | 884.71 | 874.79 | |||
SO48292_8 | 7546-4477-B2 | PO19633112676 | 100 | 287 | 428 | 149 | 3 | 2023-02-03 | 627.77 | 15.69 | 2023-01-22 | 3 | 185.82 | 1 | 627.77 | 8 | SO48292 | 2023-01-29 | 50.22 | 557.46 | 209.26 | |||
SO59016_12 | C817-476A-BF | PO4785180874 | 100 | 282 | 572 | 223 | 3 | 2024-02-03 | 445.41 | 11.14 | 2024-01-22 | 1 | 461.44 | 1 | 445.41 | 12 | SO59016 | 2024-01-29 | 35.63 | 461.44 | 445.41 | |||
SO57037_7 | F0A9-4A16-B9 | PO15370120234 | 100 | 281 | 601 | 381 | 3 | 2024-01-04 | 32.39 | 0.81 | 2023-12-23 | 1 | 23.97 | 1 | 32.39 | 7 | SO57037 | 2023-12-30 | 2.59 | 23.97 | 32.39 | |||
SO44097_6 | 0F82-4F60-8B | PO14268131774 | 100 | 283 | 220 | 418 | 3 | 2021-11-04 | 80.75 | 2.02 | 2021-10-23 | 4 | 12.03 | 1 | 80.75 | 6 | SO44097 | 2021-10-30 | 6.46 | 48.11 | 20.19 | |||
SO49040_8 | 6653-43A9-8D | PO19923195099 | 100 | 283 | 297 | 18 | 3 | 2023-04-06 | 2208.44 | 55.21 | 2023-03-25 | 3 | 653.70 | 1 | 2208.44 | 8 | SO49040 | 2023-04-01 | 176.67 | 1961.09 | 736.15 | |||
SO49093_3 | A0B1-4C01-8A | PO15370113221 | 100 | 281 | 356 | 381 | 3 | 2023-04-06 | 2485.70 | 62.14 | 2023-03-25 | 2 | 1117.86 | 1 | 2485.70 | 3 | SO49093 | 2023-04-01 | 198.86 | 2235.71 | 1242.85 | |||
SO47378_33 | E766-4274-A7 | PO15341116216 | 100 | 283 | 453 | 327 | 3 | 2022-11-04 | 215.96 | 5.40 | 2022-10-23 | 6 | 24.75 | 1 | 215.96 | 33 | SO47378 | 2022-10-30 | 17.28 | 148.48 | 35.99 | |||
SO47419_2 | 7703-4F2C-92 | PO3103122578 | 100 | 283 | 333 | 147 | 3 | 2022-11-04 | 2348.97 | 58.72 | 2022-10-23 | 5 | 486.71 | 1 | 2348.97 | 2 | SO47419 | 2022-10-30 | 187.92 | 2433.53 | 469.79 | |||
SO46344_13 | BB3A-4D16-9E | PO14268133810 | 100 | 283 | 322 | 418 | 3 | 2022-08-04 | 1677.84 | 41.95 | 2022-07-23 | 4 | 413.15 | 1 | 1677.84 | 13 | SO46344 | 2022-07-30 | 134.23 | 1652.59 | 419.46 | |||
SO51140_20 | 0583-4C94-BA | PO6467148715 | 100 | 283 | 483 | 2 | 660 | 3 | 19.49 | 2023-09-03 | 974.40 | 23.87 | 2023-08-22 | 14 | 44.88 | 1 | 954.91 | 20 | SO51140 | 2023-08-29 | 76.39 | 628.32 | 69.60 | 0.02 |
SO46931_21 | EE3D-4B0A-B6 | PO19923131204 | 100 | 281 | 420 | 18 | 3 | 2022-10-04 | 566.46 | 14.16 | 2022-09-22 | 4 | 104.80 | 1 | 566.46 | 21 | SO46931 | 2022-09-29 | 45.32 | 419.18 | 141.62 | |||
SO48004_7 | DC8C-40DC-8F | PO13572118942 | 100 | 287 | 377 | 527 | 3 | 2023-01-04 | 2617.88 | 65.45 | 2022-12-23 | 2 | 1320.68 | 1 | 2617.88 | 7 | SO48004 | 2022-12-30 | 209.43 | 2641.37 | 1308.94 | |||
SO51822_14 | EEEE-45C1-87 | PO8845178563 | 100 | 282 | 359 | 546 | 3 | 2023-10-04 | 11015.95 | 275.40 | 2023-09-22 | 8 | 1251.98 | 1 | 11015.95 | 14 | SO51822 | 2023-09-29 | 881.28 | 10015.85 | 1376.99 | |||
SO63291_22 | 9B60-437E-88 | PO8845151318 | 100 | 282 | 225 | 546 | 3 | 2024-04-05 | 26.97 | 0.67 | 2024-03-24 | 5 | 6.92 | 1 | 26.97 | 22 | SO63291 | 2024-03-31 | 2.16 | 34.61 | 5.39 | |||
SO49502_11 | 6C08-4C4C-B8 | PO14268145224 | 100 | 281 | 458 | 418 | 3 | 2023-05-04 | 224.97 | 5.62 | 2023-04-22 | 5 | 30.93 | 1 | 224.97 | 11 | SO49502 | 2023-04-29 | 18.00 | 154.67 | 44.99 | |||
SO51691_28 | 8F72-4342-A4 | PO19923122474 | 100 | 283 | 474 | 18 | 3 | 2023-10-04 | 251.96 | 6.30 | 2023-09-22 | 6 | 26.18 | 1 | 251.96 | 28 | SO51691 | 2023-09-29 | 20.16 | 157.06 | 41.99 | |||
SO71819_34 | DBA3-430C-8B | PO12354153257 | 100 | 283 | 357 | 197 | 3 | 2024-08-04 | 6959.97 | 174.00 | 2024-07-23 | 5 | 1265.62 | 1 | 6959.97 | 34 | SO71819 | 2024-07-30 | 556.80 | 6328.10 | 1391.99 | |||
SO51151_26 | D7A9-4DF6-B9 | PO8787179219 | 100 | 282 | 491 | 3 | 523 | 3 | 26.73 | 2023-09-03 | 534.50 | 12.69 | 2023-08-22 | 18 | 41.57 | 1 | 507.78 | 26 | SO51151 | 2023-08-29 | 40.62 | 748.30 | 29.69 | 0.05 |
SO57113_2 | 160E-42A8-97 | PO12122117991 | 100 | 281 | 372 | 22 | 3 | 2024-01-04 | 1466.01 | 36.65 | 2023-12-23 | 1 | 1554.95 | 1 | 1466.01 | 2 | SO57113 | 2023-12-30 | 117.28 | 1554.95 | 1466.01 |
Generated 2024-09-21 04:22:19.111 UTC