[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE SKIP 2000 < SKIP 531 > < TAKE 28 >
28 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50218_30 | B8E9-4FE2-8B | PO14442144367 | 100 | 293 | 289 | 127 | 1 | 2023-07-03 | 744.27 | 18.61 | 2023-06-21 | 1 | 660.91 | 1 | 744.27 | 30 | SO50218 | 2023-06-28 | 59.54 | 660.91 | 744.27 | |||
SO48757_16 | C817-44D2-B4 | PO16588132026 | 100 | 289 | 362 | 146 | 1 | 2023-03-05 | 12294.59 | 307.36 | 2023-02-21 | 10 | 1105.81 | 1 | 12294.59 | 16 | SO48757 | 2023-02-28 | 983.57 | 11058.10 | 1229.46 | |||
SO63249_2 | ABDD-4795-8F | PO4727178983 | 100 | 293 | 606 | 343 | 1 | 2024-04-04 | 647.99 | 16.20 | 2024-03-23 | 2 | 343.65 | 1 | 647.99 | 2 | SO63249 | 2024-03-30 | 51.84 | 687.30 | 323.99 | |||
SO61182_15 | C1B1-4DBF-A9 | PO16588179661 | 100 | 289 | 593 | 146 | 1 | 2024-03-04 | 1016.98 | 25.42 | 2024-02-21 | 3 | 308.22 | 1 | 1016.98 | 15 | SO61182 | 2024-02-28 | 81.36 | 924.65 | 338.99 | |||
SO51800_1 | A082-4BC8-96 | PO14181145795 | 100 | 293 | 400 | 307 | 1 | 2023-10-03 | 37.15 | 0.93 | 2023-09-21 | 1 | 27.49 | 1 | 37.15 | 1 | SO51800 | 2023-09-28 | 2.97 | 27.49 | 37.15 | |||
SO51728_17 | 5481-42D0-8C | PO14558119777 | 100 | 289 | 472 | 2 | 1 | 2023-10-03 | 76.20 | 1.91 | 2023-09-21 | 2 | 23.75 | 1 | 76.20 | 17 | SO51728 | 2023-09-28 | 6.10 | 47.50 | 38.10 | |||
SO48079_11 | A42B-43D5-B0 | PO7627191699 | 100 | 293 | 335 | 433 | 1 | 2023-01-03 | 1409.38 | 35.23 | 2022-12-22 | 3 | 486.71 | 1 | 1409.38 | 11 | SO48079 | 2022-12-29 | 112.75 | 1460.12 | 469.79 | |||
SO49105_12 | B762-4BA5-A0 | PO14500175804 | 100 | 282 | 364 | 650 | 1 | 2023-04-05 | 647.99 | 16.20 | 2023-03-24 | 1 | 598.44 | 1 | 647.99 | 12 | SO49105 | 2023-03-31 | 51.84 | 598.44 | 647.99 | |||
SO46944_21 | 7854-48E8-92 | PO18676186070 | 100 | 282 | 469 | 697 | 1 | 2022-10-03 | 113.97 | 2.85 | 2022-09-21 | 5 | 15.67 | 1 | 113.97 | 21 | SO46944 | 2022-09-28 | 9.12 | 78.35 | 22.79 | |||
SO51089_28 | A635-4BAF-BC | PO16588151558 | 100 | 289 | 599 | 146 | 1 | 2023-09-02 | 1619.97 | 40.50 | 2023-08-21 | 5 | 294.58 | 1 | 1619.97 | 28 | SO51089 | 2023-08-28 | 129.60 | 1472.90 | 323.99 | |||
SO51789_13 | A5AF-4504-83 | PO18618169495 | 100 | 286 | 560 | 605 | 1 | 2023-10-03 | 2186.73 | 54.67 | 2023-09-21 | 3 | 755.15 | 1 | 2186.73 | 13 | SO51789 | 2023-09-28 | 174.94 | 2265.45 | 728.91 | |||
SO69406_41 | E101-486C-A5 | PO16675181672 | 100 | 293 | 577 | 361 | 1 | 2024-07-03 | 1457.82 | 36.45 | 2024-06-21 | 2 | 755.15 | 1 | 1457.82 | 41 | SO69406 | 2024-06-28 | 116.63 | 1510.30 | 728.91 | |||
SO53518_32 | 5712-444B-BC | PO841197199 | 100 | 286 | 398 | 2 | 254 | 1 | 5.68 | 2023-11-03 | 284.17 | 6.96 | 2023-10-22 | 11 | 19.78 | 1 | 278.48 | 32 | SO53518 | 2023-10-29 | 22.28 | 217.53 | 25.83 | 0.02 |
SO58917_5 | 0658-4A38-93 | PO17487197562 | 100 | 293 | 471 | 692 | 1 | 2024-02-02 | 76.20 | 1.91 | 2024-01-21 | 2 | 23.75 | 1 | 76.20 | 5 | SO58917 | 2024-01-28 | 6.10 | 47.50 | 38.10 | |||
SO45549_8 | E477-44D2-B0 | PO783111978 | 100 | 286 | 320 | 91 | 1 | 2022-05-03 | 838.92 | 20.97 | 2022-04-21 | 2 | 413.15 | 1 | 838.92 | 8 | SO45549 | 2022-04-28 | 67.11 | 826.29 | 419.46 | |||
SO55278_3 | BE79-4B26-B3 | PO2929120111 | 100 | 289 | 361 | 380 | 1 | 2023-12-03 | 1376.99 | 34.42 | 2023-11-21 | 1 | 1251.98 | 1 | 1376.99 | 3 | SO55278 | 2023-11-28 | 110.16 | 1251.98 | 1376.99 | |||
SO45294_8 | 2F48-482E-A9 | PO14500175708 | 100 | 282 | 307 | 650 | 1 | 2022-04-05 | 722.59 | 18.06 | 2022-03-24 | 1 | 623.84 | 1 | 722.59 | 8 | SO45294 | 2022-03-31 | 57.81 | 623.84 | 722.59 | |||
SO65312_24 | 19D1-4059-B8 | PO6815121334 | 100 | 293 | 234 | 109 | 1 | 2024-05-03 | 29.99 | 0.75 | 2024-04-21 | 1 | 38.49 | 1 | 29.99 | 24 | SO65312 | 2024-04-28 | 2.40 | 38.49 | 29.99 | |||
SO51789_16 | A5AF-4504-83 | PO18618169495 | 100 | 286 | 569 | 13 | 605 | 1 | 200.43 | 2023-10-03 | 1336.23 | 28.39 | 2023-09-21 | 4 | 461.44 | 1 | 1135.80 | 16 | SO51789 | 2023-09-28 | 90.86 | 1845.78 | 334.06 | 0.15 |
SO59031_14 | 15F5-4B32-AC | PO5017142991 | 100 | 289 | 554 | 308 | 1 | 2024-02-02 | 54.94 | 1.37 | 2024-01-21 | 1 | 40.66 | 1 | 54.94 | 14 | SO59031 | 2024-01-28 | 4.40 | 40.66 | 54.94 | |||
SO47698_12 | 3841-4995-8C | PO2552129685 | 100 | 286 | 221 | 506 | 1 | 2022-12-03 | 80.75 | 2.02 | 2022-11-21 | 4 | 13.88 | 1 | 80.75 | 12 | SO47698 | 2022-11-28 | 6.46 | 55.51 | 20.19 | |||
SO69406_24 | E101-486C-A5 | PO16675181672 | 100 | 293 | 496 | 361 | 1 | 2024-07-03 | 602.35 | 15.06 | 2024-06-21 | 1 | 601.74 | 1 | 602.35 | 24 | SO69406 | 2024-06-28 | 48.19 | 601.74 | 602.35 | |||
SO49161_3 | 0377-44E6-AA | PO7627157444 | 100 | 293 | 368 | 433 | 1 | 2023-04-05 | 2932.02 | 73.30 | 2023-03-24 | 2 | 1518.79 | 1 | 2932.02 | 3 | SO49161 | 2023-03-31 | 234.56 | 3037.57 | 1466.01 | |||
SO46646_10 | A64B-4F46-92 | PO1421164577 | 100 | 286 | 468 | 325 | 1 | 2022-09-02 | 45.59 | 1.14 | 2022-08-21 | 2 | 15.67 | 1 | 45.59 | 10 | SO46646 | 2022-08-28 | 3.65 | 31.34 | 22.79 | |||
SO50209_28 | D138-4E7C-86 | PO15573136083 | 100 | 293 | 399 | 487 | 1 | 2023-07-03 | 168.87 | 4.22 | 2023-06-21 | 5 | 24.99 | 1 | 168.87 | 28 | SO50209 | 2023-06-28 | 13.51 | 124.97 | 33.77 | |||
SO71835_2 | EBBF-4B16-99 | PO870120974 | 100 | 286 | 586 | 621 | 1 | 2024-08-03 | 2227.05 | 55.68 | 2024-07-22 | 5 | 461.44 | 1 | 2227.05 | 2 | SO71835 | 2024-07-29 | 178.16 | 2307.22 | 445.41 | |||
SO51145_3 | BBD2-4A22-8C | PO7105118870 | 100 | 293 | 434 | 668 | 1 | 2023-09-02 | 1070.69 | 26.77 | 2023-08-21 | 3 | 360.94 | 1 | 1070.69 | 3 | SO51145 | 2023-08-28 | 85.66 | 1082.83 | 356.90 | |||
SO71836_35 | E41E-40C1-84 | PO841118259 | 100 | 286 | 475 | 254 | 1 | 2024-08-03 | 83.99 | 2.10 | 2024-07-22 | 2 | 26.18 | 1 | 83.99 | 35 | SO71836 | 2024-07-29 | 6.72 | 52.35 | 41.99 |
Generated 2024-09-20 05:24:57.616 UTC