[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE < SKIP 3341 > < TAKE 30 >
30 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO55299_14 | 0B56-423B-B7 | PO6612171212 | 100 | 286 | 559 | 110 | 1 | 2023-12-03 | 48.58 | 1.21 | 2023-11-21 | 4 | 8.99 | 1 | 48.58 | 14 | SO55299 | 2023-11-28 | 3.89 | 35.95 | 12.14 | |||
SO65175_1 | E1A8-440E-94 | PO17139119772 | 100 | 293 | 382 | 644 | 1 | 2024-05-03 | 2689.18 | 67.23 | 2024-04-21 | 4 | 713.08 | 1 | 2689.18 | 1 | SO65175 | 2024-04-28 | 215.13 | 2852.32 | 672.29 | |||
SO69422_3 | BF3A-4F54-82 | PO14500139823 | 100 | 282 | 400 | 650 | 1 | 2024-07-03 | 74.30 | 1.86 | 2024-06-21 | 2 | 27.49 | 1 | 74.30 | 3 | SO69422 | 2024-06-28 | 5.94 | 54.99 | 37.15 | |||
SO46612_2 | 8645-4FD3-B4 | PO16443150420 | 100 | 289 | 236 | 398 | 1 | 2022-09-02 | 28.84 | 0.72 | 2022-08-21 | 1 | 29.08 | 1 | 28.84 | 2 | SO46612 | 2022-08-28 | 2.31 | 29.08 | 28.84 | |||
SO63157_4 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 477 | 650 | 1 | 2024-04-04 | 11.98 | 0.30 | 2024-03-23 | 4 | 1.87 | 1 | 11.98 | 4 | SO63157 | 2024-03-30 | 0.96 | 7.47 | 2.99 | |||
SO67297_30 | 58AA-422C-BB | PO2552176926 | 100 | 286 | 542 | 506 | 1 | 2024-06-03 | 48.59 | 1.21 | 2024-05-22 | 2 | 17.98 | 1 | 48.59 | 30 | SO67297 | 2024-05-29 | 3.89 | 35.96 | 24.29 | |||
SO45344_10 | 166F-4C74-85 | PO8816179390 | 100 | 289 | 320 | 218 | 1 | 2022-04-05 | 419.46 | 10.49 | 2022-03-24 | 1 | 413.15 | 1 | 419.46 | 10 | SO45344 | 2022-03-31 | 33.56 | 413.15 | 419.46 | |||
SO50217_11 | 6AE5-491F-B6 | PO14500116814 | 100 | 282 | 364 | 650 | 1 | 2023-07-03 | 1943.98 | 48.60 | 2023-06-21 | 3 | 598.44 | 1 | 1943.98 | 11 | SO50217 | 2023-06-28 | 155.52 | 1795.31 | 647.99 | |||
SO53584_5 | BB5C-4DD6-B2 | PO7192178651 | 100 | 289 | 217 | 20 | 1 | 2023-11-03 | 83.98 | 2.10 | 2023-10-22 | 4 | 13.09 | 1 | 83.98 | 5 | SO53584 | 2023-10-29 | 6.72 | 52.35 | 20.99 | |||
SO48322_1 | 74D7-4570-92 | PO14152190618 | 100 | 293 | 385 | 37 | 1 | 2023-02-02 | 600.26 | 15.01 | 2023-01-21 | 1 | 605.65 | 1 | 600.26 | 1 | SO48322 | 2023-01-28 | 48.02 | 605.65 | 600.26 | |||
SO49092_23 | 72CE-4E29-82 | PO14442163644 | 100 | 293 | 366 | 127 | 1 | 2023-04-05 | 1943.98 | 48.60 | 2023-03-24 | 3 | 598.44 | 1 | 1943.98 | 23 | SO49092 | 2023-03-31 | 155.52 | 1795.31 | 647.99 | |||
SO57135_5 | E865-46A0-81 | PO5742119554 | 100 | 293 | 591 | 541 | 1 | 2024-01-03 | 338.99 | 8.47 | 2023-12-22 | 1 | 308.22 | 1 | 338.99 | 5 | SO57135 | 2023-12-29 | 27.12 | 308.22 | 338.99 | |||
SO48741_11 | 5AA4-4194-B9 | PO899196006 | 100 | 289 | 339 | 290 | 1 | 2023-03-05 | 469.79 | 11.74 | 2023-02-21 | 1 | 486.71 | 1 | 469.79 | 11 | SO48741 | 2023-02-28 | 37.58 | 486.71 | 469.79 | |||
SO49494_2 | 81A4-4876-94 | PO17139199930 | 100 | 293 | 254 | 644 | 1 | 2023-05-03 | 183.94 | 4.60 | 2023-04-21 | 1 | 170.14 | 1 | 183.94 | 2 | SO49494 | 2023-04-28 | 14.72 | 170.14 | 183.94 | |||
SO58961_41 | 0848-4E9B-81 | PO10411162031 | 100 | 289 | 586 | 182 | 1 | 2024-02-02 | 890.82 | 22.27 | 2024-01-21 | 2 | 461.44 | 1 | 890.82 | 41 | SO58961 | 2024-01-28 | 71.27 | 922.89 | 445.41 | |||
SO67266_2 | 3CFE-46C9-88 | PO16588161069 | 100 | 289 | 474 | 4 | 146 | 1 | 132.98 | 2024-06-03 | 1329.81 | 29.92 | 2024-05-22 | 38 | 26.18 | 1 | 1196.83 | 2 | SO67266 | 2024-05-29 | 95.75 | 994.70 | 35.00 | 0.10 |
SO51146_7 | FC91-4E19-86 | PO7076128836 | 100 | 293 | 554 | 505 | 1 | 2023-09-02 | 109.88 | 2.75 | 2023-08-21 | 2 | 40.66 | 1 | 109.88 | 7 | SO51146 | 2023-08-28 | 8.79 | 81.31 | 54.94 | |||
SO51138_6 | 685D-4916-A6 | PO9338137293 | 100 | 293 | 576 | 451 | 1 | 2023-09-02 | 4291.33 | 107.28 | 2023-08-21 | 3 | 1481.94 | 1 | 4291.33 | 6 | SO51138 | 2023-08-28 | 343.31 | 4445.81 | 1430.44 | |||
SO47444_13 | 4361-4317-91 | PO7946191257 | 100 | 282 | 221 | 438 | 1 | 2022-11-03 | 100.93 | 2.52 | 2022-10-22 | 5 | 13.88 | 1 | 100.93 | 13 | SO47444 | 2022-10-29 | 8.07 | 69.39 | 20.19 | |||
SO47986_16 | 3373-4C22-A9 | PO16414116972 | 100 | 289 | 236 | 236 | 1 | 2023-01-03 | 57.68 | 1.44 | 2022-12-22 | 2 | 29.08 | 1 | 57.68 | 16 | SO47986 | 2022-12-29 | 4.61 | 58.16 | 28.84 | |||
SO59010_16 | 2350-42CD-B1 | PO6815132533 | 100 | 293 | 543 | 109 | 1 | 2024-02-02 | 37.25 | 0.93 | 2024-01-21 | 1 | 27.57 | 1 | 37.25 | 16 | SO59010 | 2024-01-28 | 2.98 | 27.57 | 37.25 | |||
SO71880_11 | B0C7-4858-91 | PO7395117544 | 100 | 286 | 357 | 542 | 1 | 2024-08-03 | 6959.97 | 174.00 | 2024-07-22 | 5 | 1265.62 | 1 | 6959.97 | 11 | SO71880 | 2024-07-29 | 556.80 | 6328.10 | 1391.99 | |||
SO44541_6 | 64BA-409F-A1 | PO2958192556 | 100 | 286 | 218 | 559 | 1 | 2022-01-03 | 17.10 | 0.43 | 2021-12-22 | 3 | 3.40 | 1 | 17.10 | 6 | SO44541 | 2021-12-29 | 1.37 | 10.19 | 5.70 | |||
SO50671_5 | 9526-4D73-83 | PO17139132177 | 100 | 293 | 414 | 644 | 1 | 2023-08-03 | 149.03 | 3.73 | 2023-07-22 | 1 | 110.28 | 1 | 149.03 | 5 | SO50671 | 2023-07-29 | 11.92 | 110.28 | 149.03 | |||
SO57160_5 | 86C3-4E21-9D | PO4727197868 | 100 | 293 | 583 | 343 | 1 | 2024-01-03 | 5102.97 | 127.57 | 2023-12-22 | 5 | 1082.51 | 1 | 5102.97 | 5 | SO57160 | 2023-12-29 | 408.24 | 5412.55 | 1020.59 | |||
SO65199_10 | F8B4-4F74-87 | PO870111351 | 100 | 286 | 570 | 621 | 1 | 2024-05-03 | 890.82 | 22.27 | 2024-04-21 | 2 | 461.44 | 1 | 890.82 | 10 | SO65199 | 2024-04-28 | 71.27 | 922.89 | 445.41 | |||
SO53469_1 | 9CB4-402C-94 | PO17139199092 | 100 | 293 | 258 | 644 | 1 | 2023-11-03 | 607.00 | 15.17 | 2023-10-22 | 3 | 204.63 | 1 | 607.00 | 1 | SO53469 | 2023-10-29 | 48.56 | 613.88 | 202.33 | |||
SO44284_2 | 2A6B-46DE-96 | PO16588183754 | 100 | 289 | 232 | 146 | 1 | 2021-12-03 | 28.84 | 0.72 | 2021-11-21 | 1 | 31.72 | 1 | 28.84 | 2 | SO44284 | 2021-11-28 | 2.31 | 31.72 | 28.84 | |||
SO46957_52 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 409 | 236 | 1 | 2022-10-03 | 418.51 | 10.46 | 2022-09-21 | 2 | 185.82 | 1 | 418.51 | 52 | SO46957 | 2022-09-28 | 33.48 | 371.64 | 209.26 | |||
SO44788_3 | 4CD8-41D6-AE | PO5220181334 | 100 | 282 | 345 | 169 | 1 | 2022-02-02 | 10199.97 | 255.00 | 2022-01-21 | 5 | 1912.15 | 1 | 10199.97 | 3 | SO44788 | 2022-01-28 | 816.00 | 9560.77 | 2039.99 |
Generated 2024-09-20 21:27:12.223 UTC