[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 760 > < TAKE 56 >
56 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO48049_12 | C09A-49F5-80 | PO3799136256 | 100 | 282 | 456 | 312 | 4 | 2023-02-23 | 224.97 | 5.62 | 2023-02-11 | 5 | 30.93 | 1 | 224.97 | 12 | SO48049 | 2023-02-18 | 18.00 | 154.67 | 44.99 | |||
| SO58914_9 | 8547-437A-B2 | PO17545129441 | 19 | 291 | 547 | 155 | 6 | 2024-03-24 | 242.97 | 6.07 | 2024-03-12 | 5 | 35.96 | 1 | 242.97 | 9 | SO58914 | 2024-03-19 | 19.44 | 179.80 | 48.59 | |||
| SO47365_33 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 412 | 678 | 6 | 2022-12-24 | 900.65 | 22.52 | 2022-12-12 | 5 | 133.30 | 1 | 900.65 | 33 | SO47365 | 2022-12-19 | 72.05 | 666.48 | 180.13 | |||
| SO53560_62 | 3D25-4203-A4 | PO7685199983 | 100 | 283 | 521 | 539 | 2 | 2023-12-24 | 32.54 | 0.81 | 2023-12-12 | 2 | 12.04 | 1 | 32.54 | 62 | SO53560 | 2023-12-19 | 2.60 | 24.08 | 16.27 | |||
| SO48327_3 | 2906-4A58-AF | PO13717142928 | 100 | 287 | 254 | 473 | 4 | 2023-03-25 | 183.94 | 4.60 | 2023-03-13 | 1 | 170.14 | 1 | 183.94 | 3 | SO48327 | 2023-03-20 | 14.72 | 170.14 | 183.94 | |||
| SO55257_8 | 979F-4AAF-9E | PO12412154112 | 100 | 281 | 378 | 670 | 3 | 2024-01-23 | 1466.01 | 36.65 | 2024-01-11 | 1 | 1554.95 | 1 | 1466.01 | 8 | SO55257 | 2024-01-18 | 117.28 | 1554.95 | 1466.01 | |||
| SO47442_1 | A001-44B5-B6 | PO7395183872 | 100 | 286 | 445 | 542 | 1 | 2022-12-24 | 35.99 | 0.90 | 2022-12-12 | 1 | 24.75 | 1 | 35.99 | 1 | SO47442 | 2022-12-19 | 2.88 | 24.75 | 35.99 | |||
| SO51733_3 | 5E45-4EBB-89 | PO13108175772 | 100 | 292 | 559 | 103 | 7 | 2023-11-23 | 24.29 | 0.61 | 2023-11-11 | 2 | 8.99 | 1 | 24.29 | 3 | SO51733 | 2023-11-18 | 1.94 | 17.97 | 12.14 | |||
| SO50747_11 | A59F-46DA-BE | PO5597196496 | 100 | 281 | 391 | 75 | 4 | 2023-09-23 | 177.86 | 4.45 | 2023-09-11 | 2 | 65.81 | 1 | 177.86 | 11 | SO50747 | 2023-09-18 | 14.23 | 131.62 | 88.93 | |||
| SO58914_3 | 8547-437A-B2 | PO17545129441 | 19 | 291 | 545 | 155 | 6 | 2024-03-24 | 97.18 | 2.43 | 2024-03-12 | 4 | 17.98 | 1 | 97.18 | 3 | SO58914 | 2024-03-19 | 7.77 | 71.91 | 24.29 | |||
| SO55295_12 | 7757-4CE3-A1 | PO7105140110 | 100 | 293 | 606 | 668 | 1 | 2024-01-23 | 323.99 | 8.10 | 2024-01-11 | 1 | 343.65 | 1 | 323.99 | 12 | SO55295 | 2024-01-18 | 25.92 | 343.65 | 323.99 | |||
| SO53620_4 | 26BF-4157-B2 | PO9019121680 | 100 | 283 | 544 | 576 | 2 | 2023-12-24 | 48.59 | 1.21 | 2023-12-12 | 1 | 35.96 | 1 | 48.59 | 4 | SO53620 | 2023-12-19 | 3.89 | 35.96 | 48.59 | |||
| SO50297_43 | 5199-40AD-90 | PO4727113542 | 100 | 293 | 373 | 343 | 1 | 2023-08-23 | 6544.69 | 163.62 | 2023-08-11 | 5 | 1320.68 | 1 | 6544.69 | 43 | SO50297 | 2023-08-18 | 523.58 | 6603.42 | 1308.94 | |||
| SO67327_19 | 2D2C-4C57-A2 | PO6467126287 | 100 | 283 | 382 | 660 | 3 | 2024-07-24 | 672.29 | 16.81 | 2024-07-12 | 1 | 713.08 | 1 | 672.29 | 19 | SO67327 | 2024-07-19 | 53.78 | 713.08 | 672.29 | |||
| SO49527_5 | BFD0-4AA2-AF | PO4640129987 | 100 | 287 | 352 | 648 | 4 | 2023-06-23 | 8699.96 | 217.50 | 2023-06-11 | 7 | 1117.86 | 1 | 8699.96 | 5 | SO49527 | 2023-06-18 | 696.00 | 7824.99 | 1242.85 | |||
| SO50683_14 | 8EBE-4D2C-AB | PO11455112273 | 100 | 283 | 457 | 72 | 2 | 2023-09-23 | 134.98 | 3.37 | 2023-09-11 | 3 | 30.93 | 1 | 134.98 | 14 | SO50683 | 2023-09-18 | 10.80 | 92.80 | 44.99 | |||
| SO50321_17 | 6B3D-47E0-99 | PO8816191637 | 100 | 289 | 341 | 218 | 1 | 2023-08-23 | 469.79 | 11.74 | 2023-08-11 | 1 | 486.71 | 1 | 469.79 | 17 | SO50321 | 2023-08-18 | 37.58 | 486.71 | 469.79 | |||
| SO46035_6 | F6D4-48D1-A2 | PO18270199753 | 19 | 288 | 351 | 11 | 6 | 2022-08-23 | 4049.99 | 101.25 | 2022-08-11 | 2 | 1898.09 | 1 | 4049.99 | 6 | SO46035 | 2022-08-18 | 324.00 | 3796.19 | 2024.99 | |||
| SO53508_9 | 38E7-428D-9B | PO11194139565 | 19 | 284 | 499 | 48 | 6 | 2023-12-24 | 3614.08 | 90.35 | 2023-12-12 | 6 | 601.74 | 1 | 3614.08 | 9 | SO53508 | 2023-12-19 | 289.13 | 3610.46 | 602.35 | |||
| SO50195_11 | F28B-4548-99 | PO19198175870 | 19 | 291 | 364 | 653 | 6 | 2023-08-23 | 2591.98 | 64.80 | 2023-08-11 | 4 | 598.44 | 1 | 2591.98 | 11 | SO50195 | 2023-08-18 | 207.36 | 2393.74 | 647.99 | |||
| SO50668_18 | A5FC-4831-B4 | PO17574113752 | 19 | 291 | 428 | 678 | 6 | 2023-09-23 | 1046.28 | 26.16 | 2023-09-11 | 5 | 185.82 | 1 | 1046.28 | 18 | SO50668 | 2023-09-18 | 83.70 | 929.10 | 209.26 | |||
| SO47976_3 | 1D33-4555-83 | PO18183173367 | 100 | 281 | 401 | 667 | 2 | 2023-02-23 | 131.20 | 3.28 | 2023-02-11 | 2 | 48.55 | 1 | 131.20 | 3 | SO47976 | 2023-02-18 | 10.50 | 97.09 | 65.60 | |||
| SO57180_15 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 577 | 520 | 10 | 2024-02-23 | 2186.73 | 54.67 | 2024-02-11 | 3 | 755.15 | 1 | 2186.73 | 15 | SO57180 | 2024-02-18 | 174.94 | 2265.45 | 728.91 | |||
| SO50252_42 | B5DA-491E-A9 | PO2523194031 | 100 | 287 | 333 | 167 | 4 | 2023-08-23 | 3288.56 | 82.21 | 2023-08-11 | 7 | 486.71 | 1 | 3288.56 | 42 | SO50252 | 2023-08-18 | 263.08 | 3406.95 | 469.79 | |||
| SO69418_26 | D0CE-41AD-AA | PO15370180703 | 100 | 281 | 306 | 381 | 3 | 2024-08-23 | 2429.28 | 60.73 | 2024-08-11 | 3 | 739.04 | 1 | 2429.28 | 26 | SO69418 | 2024-08-18 | 194.34 | 2217.12 | 809.76 | |||
| SO48776_18 | 81D9-4651-84 | PO3828123354 | 100 | 283 | 305 | 414 | 2 | 2023-04-25 | 2208.44 | 55.21 | 2023-04-13 | 3 | 653.70 | 1 | 2208.44 | 18 | SO48776 | 2023-04-20 | 176.67 | 1961.09 | 736.15 | |||
| SO63209_22 | 1C23-4681-BF | PO11223142410 | 100 | 292 | 524 | 632 | 7 | 2024-05-25 | 633.72 | 15.84 | 2024-05-13 | 4 | 144.59 | 1 | 633.72 | 22 | SO63209 | 2024-05-20 | 50.70 | 578.38 | 158.43 | |||
| SO50272_32 | E0A6-4CFA-90 | PO11745174916 | 100 | 282 | 323 | 97 | 4 | 2023-08-23 | 939.59 | 23.49 | 2023-08-11 | 2 | 486.71 | 1 | 939.59 | 32 | SO50272 | 2023-08-18 | 75.17 | 973.41 | 469.79 | |||
| SO44129_6 | CE0D-4824-A6 | PO9483186106 | 100 | 281 | 324 | 54 | 2 | 2021-12-24 | 2936.21 | 73.41 | 2021-12-12 | 7 | 413.15 | 1 | 2936.21 | 6 | SO44129 | 2021-12-19 | 234.90 | 2892.02 | 419.46 | |||
| SO46990_2 | 330A-4243-8E | PO11919154763 | 100 | 286 | 412 | 73 | 1 | 2022-11-23 | 180.13 | 4.50 | 2022-11-11 | 1 | 133.30 | 1 | 180.13 | 2 | SO46990 | 2022-11-18 | 14.41 | 133.30 | 180.13 | |||
| SO69475_16 | F74A-4967-BA | PO18618162557 | 100 | 286 | 472 | 605 | 1 | 2024-08-23 | 304.80 | 7.62 | 2024-08-11 | 8 | 23.75 | 1 | 304.80 | 16 | SO69475 | 2024-08-18 | 24.38 | 189.99 | 38.10 | |||
| SO57122_2 | 048F-465A-A8 | PO4901112587 | 19 | 284 | 418 | 84 | 6 | 2024-02-23 | 356.90 | 8.92 | 2024-02-11 | 1 | 360.94 | 1 | 356.90 | 2 | SO57122 | 2024-02-18 | 28.55 | 360.94 | 356.90 | |||
| SO51814_5 | A4D8-45E5-BB | PO7801116238 | 6 | 296 | 506 | 87 | 9 | 2023-11-23 | 400.10 | 10.00 | 2023-11-11 | 2 | 199.85 | 1 | 400.10 | 5 | SO51814 | 2023-11-18 | 32.01 | 399.70 | 200.05 | |||
| SO50748_14 | 5FBE-4B52-B2 | PO6786143310 | 100 | 281 | 462 | 3 | 4 | 2023-09-23 | 70.64 | 1.77 | 2023-09-11 | 5 | 9.71 | 1 | 70.64 | 14 | SO50748 | 2023-09-18 | 5.65 | 48.57 | 14.13 | |||
| SO46368_23 | BF32-47A9-90 | PO4408111909 | 100 | 281 | 334 | 143 | 2 | 2022-09-23 | 838.92 | 20.97 | 2022-09-11 | 2 | 413.15 | 1 | 838.92 | 23 | SO46368 | 2022-09-18 | 67.11 | 826.29 | 419.46 | |||
| SO44795_14 | 629B-45A2-8B | PO7569171528 | 100 | 287 | 220 | 608 | 4 | 2022-03-25 | 80.75 | 2.02 | 2022-03-13 | 4 | 12.03 | 1 | 80.75 | 14 | SO44795 | 2022-03-20 | 6.46 | 48.11 | 20.19 | |||
| SO51160_56 | 3F3F-4135-B0 | PO4495157262 | 19 | 291 | 480 | 496 | 6 | 2023-10-23 | 1.37 | 0.03 | 2023-10-11 | 1 | 0.86 | 1 | 1.37 | 56 | SO51160 | 2023-10-18 | 0.11 | 0.86 | 1.37 | |||
| SO46960_3 | F05E-41EB-90 | PO16762181648 | 100 | 282 | 271 | 259 | 4 | 2022-11-23 | 404.66 | 10.12 | 2022-11-11 | 2 | 187.16 | 1 | 404.66 | 3 | SO46960 | 2022-11-18 | 32.37 | 374.31 | 202.33 | |||
| SO50260_6 | 9FEF-4E9E-B1 | PO18560172242 | 100 | 285 | 325 | 531 | 5 | 2023-08-23 | 1409.38 | 35.23 | 2023-08-11 | 3 | 486.71 | 1 | 1409.38 | 6 | SO50260 | 2023-08-18 | 112.75 | 1460.12 | 469.79 | |||
| SO51818_2 | B8CE-4C91-A9 | PO9077115532 | 19 | 291 | 598 | 100 | 6 | 2023-11-23 | 971.98 | 24.30 | 2023-11-11 | 3 | 294.58 | 1 | 971.98 | 2 | SO51818 | 2023-11-18 | 77.76 | 883.74 | 323.99 | |||
| SO55264_7 | 80F3-4A7B-A2 | PO10730163005 | 100 | 287 | 388 | 491 | 4 | 2024-01-23 | 4033.76 | 100.84 | 2024-01-11 | 6 | 713.08 | 1 | 4033.76 | 7 | SO55264 | 2024-01-18 | 322.70 | 4278.48 | 672.29 | |||
| SO46983_6 | 7464-4EB3-B6 | PO13311118060 | 100 | 292 | 329 | 301 | 7 | 2022-11-23 | 1879.18 | 46.98 | 2022-11-11 | 4 | 486.71 | 1 | 1879.18 | 6 | SO46983 | 2022-11-18 | 150.33 | 1946.83 | 469.79 | |||
| SO58927_38 | BEF7-43AF-A2 | PO15515112432 | 100 | 292 | 547 | 481 | 7 | 2024-03-24 | 242.97 | 6.07 | 2024-03-12 | 5 | 35.96 | 1 | 242.97 | 38 | SO58927 | 2024-03-19 | 19.44 | 179.80 | 48.59 | |||
| SO47008_42 | FD36-4D89-AB | PO1595170889 | 19 | 284 | 343 | 426 | 6 | 2022-11-23 | 3758.35 | 93.96 | 2022-11-11 | 8 | 486.71 | 1 | 3758.35 | 42 | SO47008 | 2022-11-18 | 300.67 | 3893.65 | 469.79 | |||
| SO51157_16 | 927E-4DB1-A3 | PO3828155781 | 100 | 283 | 463 | 2 | 414 | 2 | 3.41 | 2023-10-23 | 170.45 | 4.18 | 2023-10-11 | 12 | 9.16 | 1 | 167.04 | 16 | SO51157 | 2023-10-18 | 13.36 | 109.91 | 14.20 | 0.02 |
| SO57097_2 | 9A9E-444B-B1 | PO18328123706 | 19 | 284 | 481 | 552 | 6 | 2024-02-23 | 32.36 | 0.81 | 2024-02-11 | 6 | 3.36 | 1 | 32.36 | 2 | SO57097 | 2024-02-18 | 2.59 | 20.17 | 5.39 | |||
| SO53475_2 | FFE3-4820-88 | PO15515192405 | 100 | 292 | 490 | 3 | 481 | 7 | 28.21 | 2023-12-24 | 564.20 | 13.40 | 2023-12-12 | 19 | 41.57 | 1 | 535.99 | 2 | SO53475 | 2023-12-19 | 42.88 | 789.87 | 29.69 | 0.05 |
| SO69449_15 | 457F-4A9C-96 | PO10266117370 | 6 | 296 | 560 | 393 | 9 | 2024-08-23 | 1457.82 | 36.45 | 2024-08-11 | 2 | 755.15 | 1 | 1457.82 | 15 | SO69449 | 2024-08-18 | 116.63 | 1510.30 | 728.91 | |||
| SO50214_30 | 97D5-41D3-8F | PO15196120916 | 100 | 282 | 325 | 258 | 4 | 2023-08-23 | 469.79 | 11.74 | 2023-08-11 | 1 | 486.71 | 1 | 469.79 | 30 | SO50214 | 2023-08-18 | 37.58 | 486.71 | 469.79 | |||
| SO50683_2 | 8EBE-4D2C-AB | PO11455112273 | 100 | 283 | 422 | 72 | 2 | 2023-09-23 | 270.16 | 6.75 | 2023-09-11 | 4 | 49.98 | 1 | 270.16 | 2 | SO50683 | 2023-09-18 | 21.61 | 199.92 | 67.54 | |||
| SO50315_6 | EDB3-4074-A9 | PO7598160779 | 100 | 285 | 407 | 45 | 5 | 2023-08-23 | 328.01 | 8.20 | 2023-08-11 | 5 | 48.55 | 1 | 328.01 | 6 | SO50315 | 2023-08-18 | 26.24 | 242.73 | 65.60 | |||
| SO47066_4 | 5E42-48DE-80 | PO8816154123 | 100 | 289 | 375 | 218 | 1 | 2022-11-23 | 7853.63 | 196.34 | 2022-11-11 | 6 | 1320.68 | 1 | 7853.63 | 4 | SO47066 | 2022-11-18 | 628.29 | 7924.10 | 1308.94 | |||
| SO71940_2 | 4BC8-4D3A-A4 | PO9019196796 | 100 | 283 | 543 | 576 | 2 | 2024-09-23 | 37.25 | 0.93 | 2024-09-11 | 1 | 27.57 | 1 | 37.25 | 2 | SO71940 | 2024-09-18 | 2.98 | 27.57 | 37.25 | |||
| SO45322_1 | 83B9-4E36-B7 | PO3857182032 | 100 | 283 | 332 | 256 | 4 | 2022-05-26 | 838.92 | 20.97 | 2022-05-14 | 2 | 413.15 | 1 | 838.92 | 1 | SO45322 | 2022-05-21 | 67.11 | 826.29 | 419.46 | |||
| SO50313_32 | B452-44E9-91 | PO7656143984 | 100 | 282 | 371 | 403 | 4 | 2023-08-23 | 3926.81 | 98.17 | 2023-08-11 | 3 | 1320.68 | 1 | 3926.81 | 32 | SO50313 | 2023-08-18 | 314.15 | 3962.05 | 1308.94 | |||
| SO47721_4 | 1629-4338-BE | PO8410190478 | 98 | 288 | 414 | 538 | 10 | 2023-01-23 | 298.06 | 7.45 | 2023-01-11 | 2 | 110.28 | 1 | 298.06 | 4 | SO47721 | 2023-01-18 | 23.85 | 220.57 | 149.03 |
Generated 2024-11-10 15:48:32.266 UTC