[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE SKIP 2000 < SKIP 376 > < TAKE 31 >
31 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO53606_14 | 6A19-463C-B7 | PO5539128997 | 100 | 282 | 355 | 61 | 4 | 2023-12-24 | 5567.98 | 139.20 | 2023-12-12 | 4 | 1265.62 | 1 | 5567.98 | 14 | SO53606 | 2023-12-19 | 445.44 | 5062.48 | 1391.99 | |||
SO57137_47 | 9401-4518-A4 | PO6438194874 | 100 | 281 | 217 | 309 | 4 | 2024-02-23 | 41.99 | 1.05 | 2024-02-11 | 2 | 13.09 | 1 | 41.99 | 47 | SO57137 | 2024-02-18 | 3.36 | 26.17 | 20.99 | |||
SO51154_34 | 2A76-4451-99 | PO7859157852 | 100 | 287 | 231 | 2 | 221 | 4 | 8.12 | 2023-10-23 | 405.92 | 9.95 | 2023-10-11 | 14 | 38.49 | 1 | 397.80 | 34 | SO51154 | 2023-10-18 | 31.82 | 538.89 | 28.99 | 0.02 |
SO53470_17 | 932B-41E0-AF | PO17052111209 | 100 | 282 | 554 | 420 | 4 | 2023-12-24 | 54.94 | 1.37 | 2023-12-12 | 1 | 40.66 | 1 | 54.94 | 17 | SO53470 | 2023-12-19 | 4.40 | 40.66 | 54.94 | |||
SO50713_1 | 7FC4-488D-A0 | PO16269188475 | 100 | 287 | 407 | 624 | 4 | 2023-09-23 | 65.60 | 1.64 | 2023-09-11 | 1 | 48.55 | 1 | 65.60 | 1 | SO50713 | 2023-09-18 | 5.25 | 48.55 | 65.60 | |||
SO63280_22 | C73E-4203-80 | PO3654118854 | 100 | 281 | 511 | 435 | 4 | 2024-05-25 | 218.45 | 5.46 | 2024-05-13 | 1 | 199.38 | 1 | 218.45 | 22 | SO63280 | 2024-05-20 | 17.48 | 199.38 | 218.45 | |||
SO50720_17 | 38E2-4AA6-B4 | PO9715181953 | 100 | 281 | 362 | 490 | 4 | 2023-09-23 | 1229.46 | 30.74 | 2023-09-11 | 1 | 1105.81 | 1 | 1229.46 | 17 | SO50720 | 2023-09-18 | 98.36 | 1105.81 | 1229.46 | |||
SO45070_5 | B035-4728-8C | PO5626126979 | 100 | 283 | 338 | 166 | 4 | 2022-04-25 | 838.92 | 20.97 | 2022-04-13 | 2 | 413.15 | 1 | 838.92 | 5 | SO45070 | 2022-04-20 | 67.11 | 826.29 | 419.46 | |||
SO49515_2 | 52D0-4584-BC | PO9715144044 | 100 | 281 | 421 | 490 | 4 | 2023-06-23 | 392.66 | 9.82 | 2023-06-11 | 2 | 145.28 | 1 | 392.66 | 2 | SO49515 | 2023-06-18 | 31.41 | 290.57 | 196.33 | |||
SO65157_26 | 51FF-4A62-89 | PO19372154832 | 100 | 282 | 234 | 582 | 4 | 2024-06-23 | 59.99 | 1.50 | 2024-06-11 | 2 | 38.49 | 1 | 59.99 | 26 | SO65157 | 2024-06-18 | 4.80 | 76.98 | 29.99 | |||
SO51122_27 | D915-4225-97 | PO551181465 | 100 | 281 | 255 | 4 | 4 | 2023-10-23 | 1618.66 | 40.47 | 2023-10-11 | 8 | 204.63 | 1 | 1618.66 | 27 | SO51122 | 2023-10-18 | 129.49 | 1637.00 | 202.33 | |||
SO46648_27 | 2073-4051-9E | PO2494191557 | 100 | 283 | 352 | 184 | 4 | 2022-10-23 | 4971.41 | 124.29 | 2022-10-11 | 4 | 1117.86 | 1 | 4971.41 | 27 | SO46648 | 2022-10-18 | 397.71 | 4471.42 | 1242.85 | |||
SO69532_20 | 27FB-4A86-85 | PO3799165791 | 100 | 282 | 595 | 16 | 312 | 4 | 45.20 | 2024-08-23 | 113.00 | 1.70 | 2024-08-11 | 1 | 308.22 | 1 | 67.80 | 20 | SO69532 | 2024-08-18 | 5.42 | 308.22 | 113.00 | 0.40 |
SO43912_10 | 69B6-46F8-A4 | PO7656175368 | 100 | 282 | 270 | 403 | 4 | 2021-11-23 | 183.94 | 4.60 | 2021-11-11 | 1 | 181.49 | 1 | 183.94 | 10 | SO43912 | 2021-11-18 | 14.72 | 181.49 | 183.94 | |||
SO44752_2 | 584D-40E8-AF | PO15950187592 | 100 | 282 | 332 | 114 | 4 | 2022-03-25 | 419.46 | 10.49 | 2022-03-13 | 1 | 413.15 | 1 | 419.46 | 2 | SO44752 | 2022-03-20 | 33.56 | 413.15 | 419.46 | |||
SO47972_3 | 2DF2-4C68-B0 | PO18647114504 | 100 | 282 | 358 | 583 | 4 | 2023-02-23 | 2458.92 | 61.47 | 2023-02-11 | 2 | 1105.81 | 1 | 2458.92 | 3 | SO47972 | 2023-02-18 | 196.71 | 2211.62 | 1229.46 | |||
SO51827_17 | B106-4221-AD | PO4611117026 | 100 | 287 | 500 | 131 | 4 | 2023-11-23 | 602.35 | 15.06 | 2023-11-11 | 1 | 601.74 | 1 | 602.35 | 17 | SO51827 | 2023-11-18 | 48.19 | 601.74 | 602.35 | |||
SO59029_29 | E358-40C0-B2 | PO4640116818 | 100 | 287 | 531 | 648 | 4 | 2024-03-24 | 149.87 | 3.75 | 2024-03-12 | 1 | 136.79 | 1 | 149.87 | 29 | SO59029 | 2024-03-19 | 11.99 | 136.79 | 149.87 | |||
SO69532_19 | 27FB-4A86-85 | PO3799165791 | 100 | 282 | 599 | 312 | 4 | 2024-08-23 | 323.99 | 8.10 | 2024-08-11 | 1 | 294.58 | 1 | 323.99 | 19 | SO69532 | 2024-08-18 | 25.92 | 294.58 | 323.99 | |||
SO49533_18 | 5895-4BD4-A3 | PO5597155395 | 100 | 281 | 447 | 75 | 4 | 2023-06-23 | 60.00 | 1.50 | 2023-06-11 | 4 | 10.31 | 1 | 60.00 | 18 | SO49533 | 2023-06-18 | 4.80 | 41.25 | 15.00 | |||
SO43872_1 | 52FF-45CD-9B | PO12557127067 | 100 | 282 | 328 | 240 | 4 | 2021-11-23 | 419.46 | 10.49 | 2021-11-11 | 1 | 413.15 | 1 | 419.46 | 1 | SO43872 | 2021-11-18 | 33.56 | 413.15 | 419.46 | |||
SO48066_21 | F00E-4B06-9D | PO5684167807 | 100 | 282 | 448 | 385 | 4 | 2023-02-23 | 23.99 | 0.60 | 2023-02-11 | 2 | 8.25 | 1 | 23.99 | 21 | SO48066 | 2023-02-18 | 1.92 | 16.49 | 11.99 | |||
SO49074_5 | F3B3-405D-83 | PO2320167746 | 100 | 282 | 417 | 529 | 4 | 2023-05-26 | 324.45 | 8.11 | 2023-05-14 | 1 | 300.12 | 1 | 324.45 | 5 | SO49074 | 2023-05-21 | 25.96 | 300.12 | 324.45 | |||
SO51153_29 | AC8D-4688-81 | PO5626119823 | 100 | 281 | 374 | 166 | 4 | 2023-10-23 | 5864.04 | 146.60 | 2023-10-11 | 4 | 1554.95 | 1 | 5864.04 | 29 | SO51153 | 2023-10-18 | 469.12 | 6219.79 | 1466.01 | |||
SO45565_6 | B963-45A4-B4 | PO5597130894 | 100 | 283 | 349 | 75 | 4 | 2022-06-23 | 4049.99 | 101.25 | 2022-06-11 | 2 | 1898.09 | 1 | 4049.99 | 6 | SO45565 | 2022-06-18 | 324.00 | 3796.19 | 2024.99 | |||
SO45299_18 | 0D55-4B85-AD | PO12557162961 | 100 | 282 | 322 | 240 | 4 | 2022-05-26 | 838.92 | 20.97 | 2022-05-14 | 2 | 413.15 | 1 | 838.92 | 18 | SO45299 | 2022-05-21 | 67.11 | 826.29 | 419.46 | |||
SO67287_23 | 3F1F-44DB-96 | PO10730119334 | 100 | 287 | 390 | 491 | 4 | 2024-07-24 | 3361.47 | 84.04 | 2024-07-12 | 5 | 713.08 | 1 | 3361.47 | 23 | SO67287 | 2024-07-19 | 268.92 | 3565.40 | 672.29 | |||
SO45332_4 | AD0B-49A0-A5 | PO6351110306 | 100 | 283 | 332 | 255 | 4 | 2022-05-26 | 838.92 | 20.97 | 2022-05-14 | 2 | 413.15 | 1 | 838.92 | 4 | SO45332 | 2022-05-21 | 67.11 | 826.29 | 419.46 | |||
SO63201_3 | 8299-4DE4-AD | PO15689136917 | 100 | 281 | 374 | 328 | 4 | 2024-05-25 | 2932.02 | 73.30 | 2024-05-13 | 2 | 1554.95 | 1 | 2932.02 | 3 | SO63201 | 2024-05-20 | 234.56 | 3109.90 | 1466.01 | |||
SO69453_2 | EE3C-40A0-9C | PO609154424 | 100 | 282 | 474 | 492 | 4 | 2024-08-23 | 251.96 | 6.30 | 2024-08-11 | 6 | 26.18 | 1 | 251.96 | 2 | SO69453 | 2024-08-18 | 20.16 | 157.06 | 41.99 | |||
SO51099_7 | FF5E-417D-8D | PO13833111492 | 100 | 287 | 568 | 13 | 95 | 4 | 50.11 | 2023-10-23 | 334.06 | 7.10 | 2023-10-11 | 1 | 461.44 | 1 | 283.95 | 7 | SO51099 | 2023-10-18 | 22.72 | 461.44 | 334.06 | 0.15 |
Generated 2024-11-10 06:55:24.501 UTC