[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE < SKIP 1572 > < TAKE 28 >
28 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44284_11 | 2A6B-46DE-96 | PO16588183754 | 100 | 289 | 349 | 146 | 1 | 2021-12-04 | 20249.94 | 506.25 | 2021-11-22 | 10 | 1898.09 | 1 | 20249.94 | 11 | SO44284 | 2021-11-29 | 1620.00 | 18980.94 | 2024.99 |
SO48741_18 | 5AA4-4194-B9 | PO899196006 | 100 | 289 | 368 | 290 | 1 | 2023-03-06 | 4398.03 | 109.95 | 2023-02-22 | 3 | 1518.79 | 1 | 4398.03 | 18 | SO48741 | 2023-03-01 | 351.84 | 4556.36 | 1466.01 |
SO49826_9 | 2EBD-4312-9C | PO16588178669 | 100 | 289 | 428 | 146 | 1 | 2023-06-04 | 1046.28 | 26.16 | 2023-05-23 | 5 | 185.82 | 1 | 1046.28 | 9 | SO49826 | 2023-05-30 | 83.70 | 929.10 | 209.26 |
SO57036_3 | A71E-4FC0-8D | PO15631137127 | 100 | 282 | 475 | 43 | 1 | 2024-01-04 | 41.99 | 1.05 | 2023-12-23 | 1 | 26.18 | 1 | 41.99 | 3 | SO57036 | 2023-12-30 | 3.36 | 26.18 | 41.99 |
SO55269_10 | C087-4A55-8D | PO899192335 | 100 | 289 | 490 | 290 | 1 | 2023-12-04 | 64.79 | 1.62 | 2023-11-22 | 2 | 41.57 | 1 | 64.79 | 10 | SO55269 | 2023-11-29 | 5.18 | 83.14 | 32.39 |
SO53518_57 | 5712-444B-BC | PO841197199 | 100 | 286 | 512 | 254 | 1 | 2023-11-04 | 1529.18 | 38.23 | 2023-10-23 | 7 | 199.38 | 1 | 1529.18 | 57 | SO53518 | 2023-10-30 | 122.33 | 1395.63 | 218.45 |
SO45283_18 | 07F7-44C2-BA | PO16646111452 | 100 | 286 | 317 | 1 | 1 | 2022-04-06 | 1749.59 | 43.74 | 2022-03-25 | 2 | 884.71 | 1 | 1749.59 | 18 | SO45283 | 2022-04-01 | 139.97 | 1769.42 | 874.79 |
SO71893_12 | 9AE1-416A-8F | PO7482196160 | 100 | 293 | 568 | 163 | 1 | 2024-08-04 | 890.82 | 22.27 | 2024-07-23 | 2 | 461.44 | 1 | 890.82 | 12 | SO71893 | 2024-07-30 | 71.27 | 922.89 | 445.41 |
SO51089_37 | A635-4BAF-BC | PO16588151558 | 100 | 289 | 593 | 146 | 1 | 2023-09-03 | 1016.98 | 25.42 | 2023-08-22 | 3 | 308.22 | 1 | 1016.98 | 37 | SO51089 | 2023-08-29 | 81.36 | 924.65 | 338.99 |
SO47694_7 | 8253-4E13-9D | PO899122764 | 100 | 289 | 263 | 290 | 1 | 2022-12-04 | 607.00 | 15.17 | 2022-11-22 | 3 | 187.16 | 1 | 607.00 | 7 | SO47694 | 2022-11-29 | 48.56 | 561.47 | 202.33 |
SO69525_15 | 9DCD-4F42-9E | PO4727119266 | 100 | 293 | 582 | 343 | 1 | 2024-07-04 | 3061.78 | 76.54 | 2024-06-22 | 3 | 1082.51 | 1 | 3061.78 | 15 | SO69525 | 2024-06-29 | 244.94 | 3247.53 | 1020.59 |
SO63157_16 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 357 | 650 | 1 | 2024-04-05 | 4175.98 | 104.40 | 2024-03-24 | 3 | 1265.62 | 1 | 4175.98 | 16 | SO63157 | 2024-03-31 | 334.08 | 3796.86 | 1391.99 |
SO71791_9 | AB1B-4CE2-BA | PO17139191080 | 100 | 293 | 376 | 644 | 1 | 2024-08-04 | 1466.01 | 36.65 | 2024-07-23 | 1 | 1554.95 | 1 | 1466.01 | 9 | SO71791 | 2024-07-30 | 117.28 | 1554.95 | 1466.01 |
SO46957_25 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 216 | 236 | 1 | 2022-10-04 | 80.75 | 2.02 | 2022-09-22 | 4 | 13.88 | 1 | 80.75 | 25 | SO46957 | 2022-09-29 | 6.46 | 55.51 | 20.19 |
SO51721_2 | 9429-430D-89 | PO14500124798 | 100 | 282 | 542 | 650 | 1 | 2023-10-04 | 145.76 | 3.64 | 2023-09-22 | 6 | 17.98 | 1 | 145.76 | 2 | SO51721 | 2023-09-29 | 11.66 | 107.87 | 24.29 |
SO51145_10 | BBD2-4A22-8C | PO7105118870 | 100 | 293 | 488 | 668 | 1 | 2023-09-03 | 129.58 | 3.24 | 2023-08-22 | 4 | 41.57 | 1 | 129.58 | 10 | SO51145 | 2023-08-29 | 10.37 | 166.29 | 32.39 |
SO63224_14 | 668F-4A18-A0 | PO7627111844 | 100 | 293 | 545 | 433 | 1 | 2024-04-05 | 121.47 | 3.04 | 2024-03-24 | 5 | 17.98 | 1 | 121.47 | 14 | SO63224 | 2024-03-31 | 9.72 | 89.89 | 24.29 |
SO51802_3 | E6D2-476E-93 | PO14007177602 | 100 | 289 | 605 | 56 | 1 | 2023-10-04 | 323.99 | 8.10 | 2023-09-22 | 1 | 343.65 | 1 | 323.99 | 3 | SO51802 | 2023-09-29 | 25.92 | 343.65 | 323.99 |
SO46053_8 | E530-47A7-9A | PO14471143194 | 100 | 286 | 349 | 145 | 1 | 2022-07-04 | 10124.97 | 253.12 | 2022-06-22 | 5 | 1898.09 | 1 | 10124.97 | 8 | SO46053 | 2022-06-29 | 810.00 | 9490.47 | 2024.99 |
SO51726_3 | 9BC5-4281-AF | PO14587157005 | 100 | 293 | 575 | 199 | 1 | 2023-10-04 | 1430.44 | 35.76 | 2023-09-22 | 1 | 1481.94 | 1 | 1430.44 | 3 | SO51726 | 2023-09-29 | 114.44 | 1481.94 | 1430.44 |
SO71893_9 | 9AE1-416A-8F | PO7482196160 | 100 | 293 | 572 | 163 | 1 | 2024-08-04 | 890.82 | 22.27 | 2024-07-23 | 2 | 461.44 | 1 | 890.82 | 9 | SO71893 | 2024-07-30 | 71.27 | 922.89 | 445.41 |
SO44483_4 | 678B-447B-A1 | PO19981138202 | 100 | 286 | 342 | 271 | 1 | 2022-01-04 | 838.92 | 20.97 | 2021-12-23 | 2 | 413.15 | 1 | 838.92 | 4 | SO44483 | 2021-12-30 | 67.11 | 826.29 | 419.46 |
SO50321_6 | 6B3D-47E0-99 | PO8816191637 | 100 | 289 | 271 | 218 | 1 | 2023-07-04 | 607.00 | 15.17 | 2023-06-22 | 3 | 187.16 | 1 | 607.00 | 6 | SO50321 | 2023-06-29 | 48.56 | 561.47 | 202.33 |
SO71943_16 | E676-4002-A7 | PO9309168525 | 100 | 293 | 574 | 55 | 1 | 2024-08-04 | 2860.88 | 71.52 | 2024-07-23 | 2 | 1481.94 | 1 | 2860.88 | 16 | SO71943 | 2024-07-30 | 228.87 | 2963.88 | 1430.44 |
SO47999_21 | DF06-4F6A-9D | PO14500121568 | 100 | 282 | 360 | 650 | 1 | 2023-01-04 | 4917.84 | 122.95 | 2022-12-23 | 4 | 1105.81 | 1 | 4917.84 | 21 | SO47999 | 2022-12-30 | 393.43 | 4423.24 | 1229.46 |
SO46382_2 | 77BE-428E-92 | PO7946151517 | 100 | 282 | 326 | 438 | 1 | 2022-08-04 | 419.46 | 10.49 | 2022-07-23 | 1 | 413.15 | 1 | 419.46 | 2 | SO46382 | 2022-07-30 | 33.56 | 413.15 | 419.46 |
SO58991_1 | D7E6-4630-81 | PO16530115443 | 100 | 282 | 552 | 601 | 1 | 2024-02-03 | 109.79 | 2.74 | 2024-01-22 | 2 | 40.62 | 1 | 109.79 | 1 | SO58991 | 2024-01-29 | 8.78 | 81.24 | 54.89 |
SO67266_3 | 3CFE-46C9-88 | PO16588161069 | 100 | 289 | 590 | 146 | 1 | 2024-06-04 | 923.39 | 23.08 | 2024-05-23 | 2 | 419.78 | 1 | 923.39 | 3 | SO67266 | 2024-05-30 | 73.87 | 839.56 | 461.69 |
Generated 2024-09-21 14:16:28.621 UTC