[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE SKIP 2000 < SKIP 688 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO57160_19 | 86C3-4E21-9D | PO4727197868 | 100 | 293 | 376 | 343 | 1 | 2024-01-03 | 1466.01 | 36.65 | 2023-12-22 | 1 | 1554.95 | 1 | 1466.01 | 19 | SO57160 | 2023-12-29 | 117.28 | 1554.95 | 1466.01 | |||
SO71943_10 | E676-4002-A7 | PO9309168525 | 100 | 293 | 565 | 55 | 1 | 2024-08-03 | 890.82 | 22.27 | 2024-07-22 | 2 | 461.44 | 1 | 890.82 | 10 | SO71943 | 2024-07-29 | 71.27 | 922.89 | 445.41 | |||
SO58910_22 | A209-4ADD-98 | PO19169152738 | 100 | 289 | 298 | 272 | 1 | 2024-02-02 | 809.76 | 20.24 | 2024-01-21 | 1 | 739.04 | 1 | 809.76 | 22 | SO58910 | 2024-01-28 | 64.78 | 739.04 | 809.76 | |||
SO71812_3 | 3257-4AE0-A8 | PO13543115747 | 100 | 287 | 532 | 293 | 1 | 2024-08-03 | 449.62 | 11.24 | 2024-07-22 | 3 | 136.79 | 1 | 449.62 | 3 | SO71812 | 2024-07-29 | 35.97 | 410.36 | 149.87 | |||
SO47997_4 | 2B6D-4DAC-9A | PO14558139554 | 100 | 289 | 360 | 2 | 1 | 2023-01-03 | 3688.38 | 92.21 | 2022-12-22 | 3 | 1105.81 | 1 | 3688.38 | 4 | SO47997 | 2022-12-29 | 295.07 | 3317.43 | 1229.46 | |||
SO45344_6 | 166F-4C74-85 | PO8816179390 | 100 | 289 | 314 | 218 | 1 | 2022-04-05 | 2146.96 | 53.67 | 2022-03-24 | 1 | 2171.29 | 1 | 2146.96 | 6 | SO45344 | 2022-03-31 | 171.76 | 2171.29 | 2146.96 | |||
SO45320_4 | D132-4E84-8E | PO2958131179 | 100 | 286 | 347 | 559 | 1 | 2022-04-05 | 4079.99 | 102.00 | 2022-03-24 | 2 | 1912.15 | 1 | 4079.99 | 4 | SO45320 | 2022-03-31 | 326.40 | 3824.31 | 2039.99 | |||
SO61199_11 | EFA0-4D12-A2 | PO2552199779 | 100 | 286 | 474 | 3 | 506 | 1 | 28.87 | 2024-03-04 | 577.42 | 13.71 | 2024-02-21 | 15 | 26.18 | 1 | 548.55 | 11 | SO61199 | 2024-02-28 | 43.88 | 392.64 | 38.49 | 0.05 |
SO61182_18 | C1B1-4DBF-A9 | PO16588179661 | 100 | 289 | 484 | 146 | 1 | 2024-03-04 | 33.39 | 0.83 | 2024-02-21 | 7 | 2.97 | 1 | 33.39 | 18 | SO61182 | 2024-02-28 | 2.67 | 20.81 | 4.77 | |||
SO69500_4 | 2AB8-4D0B-85 | PO5742135829 | 100 | 293 | 594 | 16 | 541 | 1 | 135.60 | 2024-07-03 | 338.99 | 5.08 | 2024-06-21 | 3 | 308.22 | 1 | 203.40 | 4 | SO69500 | 2024-06-28 | 16.27 | 924.65 | 113.00 | 0.40 |
SO57046_20 | 52CC-460F-B3 | PO14500161818 | 100 | 282 | 474 | 3 | 650 | 1 | 28.87 | 2024-01-03 | 577.42 | 13.71 | 2023-12-22 | 15 | 26.18 | 1 | 548.55 | 20 | SO57046 | 2023-12-29 | 43.88 | 392.64 | 38.49 | 0.05 |
SO51711_29 | 5CB8-480D-A1 | PO16414129790 | 100 | 289 | 543 | 236 | 1 | 2023-10-03 | 260.78 | 6.52 | 2023-09-21 | 7 | 27.57 | 1 | 260.78 | 29 | SO51711 | 2023-09-28 | 20.86 | 192.98 | 37.25 | |||
SO67297_11 | 58AA-422C-BB | PO2552176926 | 100 | 286 | 515 | 506 | 1 | 2024-06-03 | 48.82 | 1.22 | 2024-05-22 | 3 | 12.04 | 1 | 48.82 | 11 | SO67297 | 2024-05-29 | 3.91 | 36.12 | 16.27 | |||
SO46643_35 | 49E8-4C7A-85 | PO899110603 | 100 | 289 | 456 | 290 | 1 | 2022-09-02 | 89.99 | 2.25 | 2022-08-21 | 2 | 30.93 | 1 | 89.99 | 35 | SO46643 | 2022-08-28 | 7.20 | 61.87 | 44.99 | |||
SO48390_10 | 6BD0-40B2-87 | PO8903111856 | 100 | 293 | 343 | 235 | 1 | 2023-02-02 | 469.79 | 11.74 | 2023-01-21 | 1 | 486.71 | 1 | 469.79 | 10 | SO48390 | 2023-01-28 | 37.58 | 486.71 | 469.79 | |||
SO45804_5 | A72B-452A-BA | PO2552178124 | 100 | 289 | 350 | 506 | 1 | 2022-06-03 | 6074.98 | 151.87 | 2022-05-22 | 3 | 1898.09 | 1 | 6074.98 | 5 | SO45804 | 2022-05-29 | 486.00 | 5694.28 | 2024.99 | |||
SO69422_31 | BF3A-4F54-82 | PO14500139823 | 100 | 282 | 551 | 650 | 1 | 2024-07-03 | 792.15 | 19.80 | 2024-06-21 | 5 | 144.59 | 1 | 792.15 | 31 | SO69422 | 2024-06-28 | 63.37 | 722.97 | 158.43 | |||
SO65312_21 | 19D1-4059-B8 | PO6815121334 | 100 | 293 | 363 | 109 | 1 | 2024-05-03 | 8261.96 | 206.55 | 2024-04-21 | 6 | 1251.98 | 1 | 8261.96 | 21 | SO65312 | 2024-04-28 | 660.96 | 7511.89 | 1376.99 | |||
SO46051_9 | DF61-462A-87 | PO14500186228 | 100 | 282 | 293 | 650 | 1 | 2022-07-03 | 1445.19 | 36.13 | 2022-06-21 | 2 | 623.84 | 1 | 1445.19 | 9 | SO46051 | 2022-06-28 | 115.62 | 1247.68 | 722.59 | |||
SO58946_12 | F9DD-426F-9A | PO12470155874 | 100 | 287 | 522 | 672 | 1 | 2024-02-02 | 70.45 | 1.76 | 2024-01-21 | 3 | 17.38 | 1 | 70.45 | 12 | SO58946 | 2024-01-28 | 5.64 | 52.13 | 23.48 | |||
SO47349_1 | B3ED-4378-BA | PO20097150368 | 100 | 289 | 242 | 128 | 1 | 2022-11-03 | 780.82 | 19.52 | 2022-10-22 | 1 | 722.26 | 1 | 780.82 | 1 | SO47349 | 2022-10-29 | 62.47 | 722.26 | 780.82 | |||
SO53576_1 | 7638-4151-96 | PO7395119515 | 100 | 286 | 533 | 542 | 1 | 2023-11-03 | 299.75 | 7.49 | 2023-10-22 | 2 | 136.79 | 1 | 299.75 | 1 | SO53576 | 2023-10-29 | 23.98 | 273.57 | 149.87 | |||
SO46967_5 | 6486-4AF8-A6 | PO15573116583 | 100 | 286 | 393 | 487 | 1 | 2022-10-03 | 275.39 | 6.88 | 2022-09-21 | 2 | 101.89 | 1 | 275.39 | 5 | SO46967 | 2022-09-28 | 22.03 | 203.79 | 137.69 | |||
SO71818_21 | 2FCA-4131-BD | PO12470139718 | 100 | 287 | 500 | 672 | 1 | 2024-08-03 | 1807.04 | 45.18 | 2024-07-22 | 3 | 601.74 | 1 | 1807.04 | 21 | SO71818 | 2024-07-29 | 144.56 | 1805.23 | 602.35 | |||
SO46957_11 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 362 | 236 | 1 | 2022-10-03 | 3688.38 | 92.21 | 2022-09-21 | 3 | 1105.81 | 1 | 3688.38 | 11 | SO46957 | 2022-09-28 | 295.07 | 3317.43 | 1229.46 | |||
SO44771_19 | A78D-40A1-9E | PO783176074 | 100 | 286 | 212 | 91 | 1 | 2022-02-02 | 60.56 | 1.51 | 2022-01-21 | 3 | 12.03 | 1 | 60.56 | 19 | SO44771 | 2022-01-28 | 4.84 | 36.08 | 20.19 | |||
SO61267_12 | BCFD-47EE-BD | PO7076191943 | 100 | 293 | 576 | 505 | 1 | 2024-03-04 | 2860.88 | 71.52 | 2024-02-21 | 2 | 1481.94 | 1 | 2860.88 | 12 | SO61267 | 2024-02-28 | 228.87 | 2963.88 | 1430.44 | |||
SO47666_4 | 6551-4B29-BF | PO16588184420 | 100 | 289 | 308 | 146 | 1 | 2022-12-03 | 744.27 | 18.61 | 2022-11-21 | 1 | 660.91 | 1 | 744.27 | 4 | SO47666 | 2022-11-28 | 59.54 | 660.91 | 744.27 | |||
SO47986_39 | 3373-4C22-A9 | PO16414116972 | 100 | 289 | 420 | 236 | 1 | 2023-01-03 | 849.69 | 21.24 | 2022-12-22 | 6 | 104.80 | 1 | 849.69 | 39 | SO47986 | 2022-12-29 | 67.98 | 628.77 | 141.62 | |||
SO63149_12 | 7EF2-4565-86 | PO16414166653 | 100 | 289 | 555 | 236 | 1 | 2024-04-04 | 255.60 | 6.39 | 2024-03-23 | 4 | 47.29 | 1 | 255.60 | 12 | SO63149 | 2024-03-30 | 20.45 | 189.14 | 63.90 |
Generated 2024-09-20 05:44:40.543 UTC