[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 618 > < TAKE 48 >
48 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO69448_8 | 26BF-4CA1-97 | PO11020118669 | 19 | 284 | 547 | 336 | 6 | 2024-07-04 | 97.19 | 2.43 | 2024-06-22 | 2 | 35.96 | 1 | 97.19 | 8 | SO69448 | 2024-06-29 | 7.78 | 71.92 | 48.59 | |||
SO49855_1 | 0C94-4D84-A4 | PO18473166459 | 19 | 291 | 367 | 442 | 6 | 2023-06-04 | 1943.98 | 48.60 | 2023-05-23 | 3 | 598.44 | 1 | 1943.98 | 1 | SO49855 | 2023-05-30 | 155.52 | 1795.31 | 647.99 | |||
SO47366_58 | DD3E-4DAA-BA | PO17545115575 | 19 | 291 | 216 | 155 | 6 | 2022-11-04 | 201.87 | 5.05 | 2022-10-23 | 10 | 13.88 | 1 | 201.87 | 58 | SO47366 | 2022-10-30 | 16.15 | 138.78 | 20.19 | |||
SO58925_23 | ACBD-43C3-A2 | PO15544139465 | 19 | 284 | 576 | 282 | 6 | 2024-02-03 | 1430.44 | 35.76 | 2024-01-22 | 1 | 1481.94 | 1 | 1430.44 | 23 | SO58925 | 2024-01-29 | 114.44 | 1481.94 | 1430.44 | |||
SO53481_1 | 4F63-4DE7-BB | PO14935112810 | 19 | 291 | 467 | 443 | 6 | 2023-11-04 | 14.69 | 0.37 | 2023-10-23 | 1 | 9.16 | 1 | 14.69 | 1 | SO53481 | 2023-10-30 | 1.18 | 9.16 | 14.69 | |||
SO44750_20 | B71E-4BBF-B5 | PO17574147002 | 19 | 288 | 212 | 678 | 6 | 2022-02-03 | 60.56 | 1.51 | 2022-01-22 | 3 | 12.03 | 1 | 60.56 | 20 | SO44750 | 2022-01-29 | 4.84 | 36.08 | 20.19 | |||
SO47663_31 | 1B17-4C63-B6 | PO18444192283 | 19 | 291 | 381 | 227 | 6 | 2022-12-04 | 2401.05 | 60.03 | 2022-11-22 | 4 | 605.65 | 1 | 2401.05 | 31 | SO47663 | 2022-11-29 | 192.08 | 2422.60 | 600.26 | |||
SO46086_2 | 56A8-4607-A0 | PO4901123378 | 19 | 284 | 314 | 84 | 6 | 2022-07-04 | 17175.70 | 429.39 | 2022-06-22 | 8 | 2171.29 | 1 | 17175.70 | 2 | SO46086 | 2022-06-29 | 1374.06 | 17370.35 | 2146.96 | |||
SO47008_19 | FD36-4D89-AB | PO1595170889 | 19 | 284 | 335 | 426 | 6 | 2022-10-04 | 469.79 | 11.74 | 2022-09-22 | 1 | 486.71 | 1 | 469.79 | 19 | SO47008 | 2022-09-29 | 37.58 | 486.71 | 469.79 | |||
SO55245_20 | B5AD-476D-B4 | PO14732112185 | 19 | 291 | 605 | 2 | 514 | 6 | 75.17 | 2023-12-04 | 3758.33 | 92.08 | 2023-11-22 | 12 | 343.65 | 1 | 3683.16 | 20 | SO55245 | 2023-11-29 | 294.65 | 4123.80 | 313.19 | 0.02 |
SO49072_7 | B98C-4814-B1 | PO2146179731 | 19 | 284 | 354 | 354 | 6 | 2023-04-06 | 3728.56 | 93.21 | 2023-03-25 | 3 | 1117.86 | 1 | 3728.56 | 7 | SO49072 | 2023-04-01 | 298.28 | 3353.57 | 1242.85 | |||
SO51160_9 | 3F3F-4135-B0 | PO4495157262 | 19 | 291 | 359 | 496 | 6 | 2023-09-03 | 6884.97 | 172.12 | 2023-08-22 | 5 | 1251.98 | 1 | 6884.97 | 9 | SO51160 | 2023-08-29 | 550.80 | 6259.91 | 1376.99 | |||
SO69397_6 | 1339-46CA-AC | PO18879152551 | 19 | 291 | 566 | 64 | 6 | 2024-07-04 | 1336.23 | 33.41 | 2024-06-22 | 3 | 461.44 | 1 | 1336.23 | 6 | SO69397 | 2024-06-29 | 106.90 | 1384.33 | 445.41 | |||
SO71847_7 | 3A74-467E-8B | PO18502143784 | 19 | 291 | 573 | 154 | 6 | 2024-08-04 | 5721.77 | 143.04 | 2024-07-23 | 4 | 1481.94 | 1 | 5721.77 | 7 | SO71847 | 2024-07-30 | 457.74 | 5927.75 | 1430.44 | |||
SO50245_43 | 28E4-4CC9-BF | PO1914152990 | 19 | 284 | 433 | 66 | 6 | 2023-07-04 | 1297.81 | 32.45 | 2023-06-22 | 4 | 300.12 | 1 | 1297.81 | 43 | SO50245 | 2023-06-29 | 103.82 | 1200.48 | 324.45 | |||
SO58911_7 | C991-4920-91 | PO19401135315 | 19 | 291 | 606 | 173 | 6 | 2024-02-03 | 323.99 | 8.10 | 2024-01-22 | 1 | 343.65 | 1 | 323.99 | 7 | SO58911 | 2024-01-29 | 25.92 | 343.65 | 323.99 | |||
SO50204_28 | 4453-4267-A1 | PO16733169352 | 19 | 291 | 383 | 533 | 6 | 2023-07-04 | 600.26 | 15.01 | 2023-06-22 | 1 | 605.65 | 1 | 600.26 | 28 | SO50204 | 2023-06-29 | 48.02 | 605.65 | 600.26 | |||
SO55297_18 | 2455-4B60-A5 | PO4495126679 | 19 | 291 | 353 | 496 | 6 | 2023-12-04 | 9743.96 | 243.60 | 2023-11-22 | 7 | 1265.62 | 1 | 9743.96 | 18 | SO55297 | 2023-11-29 | 779.52 | 8859.34 | 1391.99 | |||
SO51818_5 | B8CE-4C91-A9 | PO9077115532 | 19 | 291 | 359 | 100 | 6 | 2023-10-04 | 2753.99 | 68.85 | 2023-09-22 | 2 | 1251.98 | 1 | 2753.99 | 5 | SO51818 | 2023-09-29 | 220.32 | 2503.96 | 1376.99 | |||
SO47663_27 | 1B17-4C63-B6 | PO18444192283 | 19 | 291 | 339 | 227 | 6 | 2022-12-04 | 2348.97 | 58.72 | 2022-11-22 | 5 | 486.71 | 1 | 2348.97 | 27 | SO47663 | 2022-11-29 | 187.92 | 2433.53 | 469.79 | |||
SO69520_36 | 654B-484B-8F | PO4466144794 | 19 | 291 | 592 | 16 | 352 | 6 | 45.20 | 2024-07-04 | 113.00 | 1.70 | 2024-06-22 | 1 | 308.22 | 1 | 67.80 | 36 | SO69520 | 2024-06-29 | 5.42 | 308.22 | 113.00 | 0.40 |
SO47365_29 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 453 | 678 | 6 | 2022-11-04 | 251.96 | 6.30 | 2022-10-23 | 7 | 24.75 | 1 | 251.96 | 29 | SO47365 | 2022-10-30 | 20.16 | 173.22 | 35.99 | |||
SO44504_25 | CFE2-4C08-B0 | PO16733198490 | 19 | 288 | 316 | 533 | 6 | 2022-01-04 | 1749.59 | 43.74 | 2021-12-23 | 2 | 884.71 | 1 | 1749.59 | 25 | SO44504 | 2021-12-30 | 139.97 | 1769.42 | 874.79 | |||
SO43677_4 | 8E3A-4564-99 | PO11049174786 | 19 | 284 | 342 | 679 | 6 | 2021-09-03 | 419.46 | 10.49 | 2021-08-22 | 1 | 413.15 | 1 | 419.46 | 4 | SO43677 | 2021-08-29 | 33.56 | 413.15 | 419.46 | |||
SO47980_3 | 4C76-4276-8E | PO17603160708 | 19 | 284 | 448 | 12 | 6 | 2023-01-04 | 23.99 | 0.60 | 2022-12-23 | 2 | 8.25 | 1 | 23.99 | 3 | SO47980 | 2022-12-30 | 1.92 | 16.49 | 11.99 | |||
SO65238_11 | 896A-4ED1-B1 | PO10875188169 | 19 | 291 | 214 | 281 | 6 | 2024-05-04 | 146.96 | 3.67 | 2024-04-22 | 7 | 13.09 | 1 | 146.96 | 11 | SO65238 | 2024-04-29 | 11.76 | 91.60 | 20.99 | |||
SO71788_3 | E55C-4CCA-85 | PO17951176595 | 19 | 284 | 217 | 637 | 6 | 2024-08-04 | 20.99 | 0.52 | 2024-07-23 | 1 | 13.09 | 1 | 20.99 | 3 | SO71788 | 2024-07-30 | 1.68 | 13.09 | 20.99 | |||
SO49855_39 | 0C94-4D84-A4 | PO18473166459 | 19 | 291 | 456 | 2 | 442 | 6 | 9.57 | 2023-06-04 | 478.44 | 11.72 | 2023-05-23 | 11 | 30.93 | 1 | 468.87 | 39 | SO49855 | 2023-05-30 | 37.51 | 340.27 | 43.49 | 0.02 |
SO46360_5 | 00EC-47DF-BB | PO1885143134 | 19 | 284 | 350 | 7 | 588 | 6 | 590.62 | 2022-08-04 | 1687.50 | 27.42 | 2022-07-23 | 2 | 1898.09 | 1 | 1096.87 | 5 | SO46360 | 2022-07-30 | 87.75 | 3796.19 | 843.75 | 0.35 |
SO57103_13 | DAE3-4B11-97 | PO18357137706 | 19 | 284 | 561 | 138 | 6 | 2024-01-04 | 5721.77 | 143.04 | 2023-12-23 | 4 | 1481.94 | 1 | 5721.77 | 13 | SO57103 | 2023-12-30 | 457.74 | 5927.75 | 1430.44 | |||
SO53509_17 | 4718-4C12-86 | PO11107182902 | 19 | 284 | 465 | 156 | 6 | 2023-11-04 | 88.16 | 2.20 | 2023-10-23 | 6 | 9.16 | 1 | 88.16 | 17 | SO53509 | 2023-10-30 | 7.05 | 54.96 | 14.69 | |||
SO50242_11 | A651-4343-86 | PO1595193228 | 19 | 284 | 273 | 426 | 6 | 2023-07-04 | 202.33 | 5.06 | 2023-06-22 | 1 | 187.16 | 1 | 202.33 | 11 | SO50242 | 2023-06-29 | 16.19 | 187.16 | 202.33 | |||
SO53513_33 | 5E21-438C-B3 | PO10875194431 | 19 | 291 | 566 | 13 | 281 | 6 | 50.11 | 2023-11-04 | 334.06 | 7.10 | 2023-10-23 | 1 | 461.44 | 1 | 283.95 | 33 | SO53513 | 2023-10-30 | 22.72 | 461.44 | 334.06 | 0.15 |
SO48321_22 | FA9B-4026-BF | PO14790154902 | 19 | 291 | 221 | 497 | 6 | 2023-02-03 | 121.12 | 3.03 | 2023-01-22 | 6 | 13.88 | 1 | 121.12 | 22 | SO48321 | 2023-01-29 | 9.69 | 83.27 | 20.19 | |||
SO63290_2 | 0F43-405E-B8 | PO9077159728 | 19 | 291 | 476 | 100 | 6 | 2024-04-05 | 167.98 | 4.20 | 2024-03-24 | 4 | 26.18 | 1 | 167.98 | 2 | SO63290 | 2024-03-31 | 13.44 | 104.71 | 41.99 | |||
SO49855_16 | 0C94-4D84-A4 | PO18473166459 | 19 | 291 | 396 | 442 | 6 | 2023-06-04 | 74.84 | 1.87 | 2023-05-23 | 1 | 55.38 | 1 | 74.84 | 16 | SO49855 | 2023-05-30 | 5.99 | 55.38 | 74.84 | |||
SO57188_16 | BA1D-4480-AA | PO9077120275 | 19 | 291 | 513 | 100 | 6 | 2024-01-04 | 218.45 | 5.46 | 2023-12-23 | 1 | 199.38 | 1 | 218.45 | 16 | SO57188 | 2023-12-30 | 17.48 | 199.38 | 218.45 | |||
SO51704_47 | 13FA-4729-A9 | PO17661178081 | 19 | 284 | 222 | 264 | 6 | 2023-10-04 | 125.96 | 3.15 | 2023-09-22 | 6 | 13.09 | 1 | 125.96 | 47 | SO51704 | 2023-09-29 | 10.08 | 78.52 | 20.99 | |||
SO46940_40 | 6ADC-4363-B3 | PO18705126181 | 19 | 291 | 329 | 479 | 6 | 2022-10-04 | 469.79 | 11.74 | 2022-09-22 | 1 | 486.71 | 1 | 469.79 | 40 | SO46940 | 2022-09-29 | 37.58 | 486.71 | 469.79 | |||
SO46639_13 | 7CDF-4BF8-8E | PO10527141970 | 19 | 284 | 271 | 480 | 6 | 2022-09-03 | 202.33 | 5.06 | 2022-08-22 | 1 | 187.16 | 1 | 202.33 | 13 | SO46639 | 2022-08-29 | 16.19 | 187.16 | 202.33 | |||
SO65218_20 | 582E-4D6F-9C | PO15544112763 | 19 | 284 | 572 | 282 | 6 | 2024-05-04 | 890.82 | 22.27 | 2024-04-22 | 2 | 461.44 | 1 | 890.82 | 20 | SO65218 | 2024-04-29 | 71.27 | 922.89 | 445.41 | |||
SO50284_38 | F8D1-49E1-A5 | PO4901178867 | 19 | 284 | 254 | 84 | 6 | 2023-07-04 | 367.88 | 9.20 | 2023-06-22 | 2 | 170.14 | 1 | 367.88 | 38 | SO50284 | 2023-06-29 | 29.43 | 340.29 | 183.94 | |||
SO51100_4 | A159-4950-A0 | PO13862191766 | 19 | 291 | 475 | 119 | 6 | 2023-09-03 | 167.98 | 4.20 | 2023-08-22 | 4 | 26.18 | 1 | 167.98 | 4 | SO51100 | 2023-08-29 | 13.44 | 104.71 | 41.99 | |||
SO49496_2 | 1BAD-4D34-B0 | PO10614179686 | 19 | 291 | 385 | 461 | 6 | 2023-05-04 | 3001.31 | 75.03 | 2023-04-22 | 5 | 605.65 | 1 | 3001.31 | 2 | SO49496 | 2023-04-29 | 240.11 | 3028.25 | 600.26 | |||
SO63140_6 | 0582-4EB7-B7 | PO17661112720 | 19 | 284 | 555 | 264 | 6 | 2024-04-05 | 127.80 | 3.20 | 2024-03-24 | 2 | 47.29 | 1 | 127.80 | 6 | SO63140 | 2024-03-31 | 10.22 | 94.57 | 63.90 | |||
SO57073_3 | 6481-4651-B6 | PO10498143051 | 19 | 291 | 476 | 316 | 6 | 2024-01-04 | 167.98 | 4.20 | 2023-12-23 | 4 | 26.18 | 1 | 167.98 | 3 | SO57073 | 2023-12-30 | 13.44 | 104.71 | 41.99 | |||
SO71851_51 | AABE-4443-91 | PO18299133687 | 19 | 291 | 488 | 118 | 6 | 2024-08-04 | 32.39 | 0.81 | 2024-07-23 | 1 | 41.57 | 1 | 32.39 | 51 | SO71851 | 2024-07-30 | 2.59 | 41.57 | 32.39 | |||
SO69396_14 | 210F-43F3-97 | PO19227139814 | 19 | 284 | 605 | 210 | 6 | 2024-07-04 | 647.99 | 16.20 | 2024-06-22 | 2 | 343.65 | 1 | 647.99 | 14 | SO69396 | 2024-06-29 | 51.84 | 687.30 | 323.99 |
Generated 2024-09-21 05:18:08.935 UTC