[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '3' > SHUFFLE < SKIP 849 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48735_12 | BFBE-46B9-A1 | PO12412161905 | 100 | 281 | 379 | 670 | 3 | 2023-04-29 | 3926.81 | 98.17 | 2023-04-17 | 3 | 1320.68 | 1 | 3926.81 | 12 | SO48735 | 2023-04-24 | 314.15 | 3962.05 | 1308.94 | |||
SO51149_2 | E0BD-412F-A7 | PO6235137860 | 100 | 283 | 605 | 431 | 3 | 2023-10-27 | 971.98 | 24.30 | 2023-10-15 | 3 | 343.65 | 1 | 971.98 | 2 | SO51149 | 2023-10-22 | 77.76 | 1030.95 | 323.99 | |||
SO44517_16 | 47C8-4635-A6 | PO13572181174 | 100 | 287 | 319 | 527 | 3 | 2022-02-27 | 874.79 | 21.87 | 2022-02-15 | 1 | 884.71 | 1 | 874.79 | 16 | SO44517 | 2022-02-22 | 69.98 | 884.71 | 874.79 | |||
SO57186_50 | EF93-4946-97 | PO8845159326 | 100 | 282 | 591 | 546 | 3 | 2024-02-27 | 1355.98 | 33.90 | 2024-02-15 | 4 | 308.22 | 1 | 1355.98 | 50 | SO57186 | 2024-02-22 | 108.48 | 1232.87 | 338.99 | |||
SO50675_24 | 4D87-4C93-9C | PO15341172035 | 100 | 281 | 297 | 327 | 3 | 2023-09-27 | 1472.29 | 36.81 | 2023-09-15 | 2 | 653.70 | 1 | 1472.29 | 24 | SO50675 | 2023-09-22 | 117.78 | 1307.39 | 736.15 | |||
SO49837_16 | C136-4536-9D | PO12412160791 | 100 | 281 | 422 | 670 | 3 | 2023-07-28 | 337.70 | 8.44 | 2023-07-16 | 5 | 49.98 | 1 | 337.70 | 16 | SO49837 | 2023-07-23 | 27.02 | 249.89 | 67.54 | |||
SO46358_15 | 3BC7-40F4-99 | PO1624111969 | 100 | 283 | 340 | 579 | 3 | 2022-09-27 | 419.46 | 10.49 | 2022-09-15 | 1 | 413.15 | 1 | 419.46 | 15 | SO46358 | 2022-09-22 | 33.56 | 413.15 | 419.46 | |||
SO51749_1 | 07A6-4731-B2 | PO11252196302 | 100 | 281 | 520 | 606 | 3 | 2023-11-27 | 94.75 | 2.37 | 2023-11-15 | 3 | 23.37 | 1 | 94.75 | 1 | SO51749 | 2023-11-22 | 7.58 | 70.12 | 31.58 | |||
SO45547_1 | BE3F-40B0-95 | PO10382198471 | 100 | 283 | 350 | 453 | 3 | 2022-06-27 | 4049.99 | 101.25 | 2022-06-15 | 2 | 1898.09 | 1 | 4049.99 | 1 | SO45547 | 2022-06-22 | 324.00 | 3796.19 | 2024.99 | |||
SO67262_3 | 5BD7-455E-9A | PO19314114641 | 100 | 281 | 217 | 622 | 3 | 2024-07-28 | 41.99 | 1.05 | 2024-07-16 | 2 | 13.09 | 1 | 41.99 | 3 | SO67262 | 2024-07-23 | 3.36 | 26.17 | 20.99 | |||
SO45539_5 | B54E-42F9-AB | PO13920158775 | 100 | 281 | 346 | 180 | 3 | 2022-06-27 | 4079.99 | 102.00 | 2022-06-15 | 2 | 1912.15 | 1 | 4079.99 | 5 | SO45539 | 2022-06-22 | 326.40 | 3824.31 | 2039.99 | |||
SO59058_31 | 98B6-49AA-A5 | PO7047118388 | 100 | 281 | 531 | 544 | 3 | 2024-03-28 | 149.87 | 3.75 | 2024-03-16 | 1 | 136.79 | 1 | 149.87 | 31 | SO59058 | 2024-03-23 | 11.99 | 136.79 | 149.87 | |||
SO44550_18 | 0BDF-4CBE-88 | PO5191121845 | 100 | 283 | 319 | 364 | 3 | 2022-02-27 | 874.79 | 21.87 | 2022-02-15 | 1 | 884.71 | 1 | 874.79 | 18 | SO44550 | 2022-02-22 | 69.98 | 884.71 | 874.79 | |||
SO44296_17 | DE85-42AB-AC | PO12412194442 | 100 | 283 | 223 | 670 | 3 | 2022-01-27 | 20.75 | 0.52 | 2022-01-15 | 4 | 5.71 | 1 | 20.75 | 17 | SO44296 | 2022-01-22 | 1.66 | 22.82 | 5.19 | |||
SO47020_1 | 60D5-4798-AF | PO3074119112 | 100 | 283 | 411 | 237 | 3 | 2022-11-27 | 125.42 | 3.14 | 2022-11-15 | 1 | 92.81 | 1 | 125.42 | 1 | SO47020 | 2022-11-22 | 10.03 | 92.81 | 125.42 | |||
SO46980_25 | FAA2-449B-99 | PO13572170679 | 100 | 287 | 433 | 527 | 3 | 2022-11-27 | 648.91 | 16.22 | 2022-11-15 | 2 | 300.12 | 1 | 648.91 | 25 | SO46980 | 2022-11-22 | 51.91 | 600.24 | 324.45 | |||
SO71803_32 | 9C57-4821-9B | PO15341174104 | 100 | 281 | 524 | 327 | 3 | 2024-09-27 | 316.86 | 7.92 | 2024-09-15 | 2 | 144.59 | 1 | 316.86 | 32 | SO71803 | 2024-09-22 | 25.35 | 289.19 | 158.43 | |||
SO69416_10 | 780C-4219-8A | PO15254137054 | 100 | 283 | 606 | 377 | 3 | 2024-08-27 | 323.99 | 8.10 | 2024-08-15 | 1 | 343.65 | 1 | 323.99 | 10 | SO69416 | 2024-08-22 | 25.92 | 343.65 | 323.99 | |||
SO50304_18 | 9338-4FCD-A5 | PO5771132420 | 100 | 282 | 230 | 79 | 3 | 2023-08-27 | 86.52 | 2.16 | 2023-08-15 | 3 | 29.08 | 1 | 86.52 | 18 | SO50304 | 2023-08-22 | 6.92 | 87.24 | 28.84 | |||
SO46026_9 | 4EE4-41C6-BC | PO19923199302 | 100 | 281 | 218 | 18 | 3 | 2022-08-27 | 17.10 | 0.43 | 2022-08-15 | 3 | 3.40 | 1 | 17.10 | 9 | SO46026 | 2022-08-22 | 1.37 | 10.19 | 5.70 | |||
SO44780_1 | EE26-4C8F-95 | PO4147150441 | 100 | 282 | 340 | 222 | 3 | 2022-03-29 | 419.46 | 10.49 | 2022-03-17 | 1 | 413.15 | 1 | 419.46 | 1 | SO44780 | 2022-03-24 | 33.56 | 413.15 | 419.46 | |||
SO48786_37 | D12C-42C5-83 | PO6467115913 | 100 | 283 | 456 | 660 | 3 | 2023-04-29 | 89.99 | 2.25 | 2023-04-17 | 2 | 30.93 | 1 | 89.99 | 37 | SO48786 | 2023-04-24 | 7.20 | 61.87 | 44.99 | |||
SO49147_30 | B753-40C9-A6 | PO5771172608 | 100 | 282 | 373 | 79 | 3 | 2023-05-30 | 3926.81 | 98.17 | 2023-05-18 | 3 | 1320.68 | 1 | 3926.81 | 30 | SO49147 | 2023-05-25 | 314.15 | 3962.05 | 1308.94 | |||
SO55294_33 | D314-4552-B5 | PO6467116955 | 100 | 283 | 217 | 2 | 660 | 3 | 5.28 | 2024-01-27 | 263.82 | 6.46 | 2024-01-15 | 13 | 13.09 | 1 | 258.55 | 33 | SO55294 | 2024-01-22 | 20.68 | 170.12 | 20.29 | 0.02 |
SO55324_33 | 35BE-456A-B8 | PO8787146999 | 100 | 282 | 214 | 523 | 3 | 2024-01-27 | 125.96 | 3.15 | 2024-01-15 | 6 | 13.09 | 1 | 125.96 | 33 | SO55324 | 2024-01-22 | 10.08 | 78.52 | 20.99 | |||
SO49870_47 | 7E0A-4D6E-9E | PO6467181139 | 100 | 283 | 213 | 660 | 3 | 2023-07-28 | 100.93 | 2.52 | 2023-07-16 | 5 | 13.88 | 1 | 100.93 | 47 | SO49870 | 2023-07-23 | 8.07 | 69.39 | 20.19 | |||
SO63257_3 | B81B-4565-85 | PO5771197507 | 100 | 282 | 490 | 79 | 3 | 2024-05-29 | 129.58 | 3.24 | 2024-05-17 | 4 | 41.57 | 1 | 129.58 | 3 | SO63257 | 2024-05-24 | 10.37 | 166.29 | 32.39 | |||
SO43899_7 | 79F2-434F-97 | PO5191115657 | 100 | 283 | 314 | 364 | 3 | 2021-11-27 | 2146.96 | 53.67 | 2021-11-15 | 1 | 2171.29 | 1 | 2146.96 | 7 | SO43899 | 2021-11-22 | 171.76 | 2171.29 | 2146.96 |
Generated 2024-11-14 08:04:37.094 UTC