[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > SHUFFLE < SKIP 344 > < TAKE 24 >
24 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO53560_22 | 3D25-4203-A4 | PO7685199983 | 100 | 283 | 572 | 13 | 539 | 2 | 200.43 | 2023-11-04 | 1336.23 | 28.39 | 2023-10-23 | 4 | 461.44 | 1 | 1135.80 | 22 | SO53560 | 2023-10-30 | 90.86 | 1845.78 | 334.06 | 0.15 |
SO45575_5 | 358D-446A-9A | PO9483193232 | 100 | 281 | 328 | 54 | 2 | 2022-05-04 | 419.46 | 10.49 | 2022-04-22 | 1 | 413.15 | 1 | 419.46 | 5 | SO45575 | 2022-04-29 | 33.56 | 413.15 | 419.46 | |||
SO47011_5 | 808A-4138-A9 | PO1769173090 | 100 | 281 | 422 | 540 | 2 | 2022-10-04 | 135.08 | 3.38 | 2022-09-22 | 2 | 49.98 | 1 | 135.08 | 5 | SO47011 | 2022-09-29 | 10.81 | 99.96 | 67.54 | |||
SO55301_56 | C4D6-4789-A9 | PO3828165579 | 100 | 283 | 477 | 414 | 2 | 2023-12-04 | 26.95 | 0.67 | 2023-11-22 | 9 | 1.87 | 1 | 26.95 | 56 | SO55301 | 2023-11-29 | 2.16 | 16.80 | 2.99 | |||
SO46633_2 | D8C9-4AB8-A4 | PO11484122930 | 100 | 281 | 308 | 594 | 2 | 2022-09-03 | 2977.09 | 74.43 | 2022-08-22 | 4 | 660.91 | 1 | 2977.09 | 2 | SO46633 | 2022-08-29 | 238.17 | 2643.66 | 744.27 | |||
SO49123_25 | FDE5-41D0-A8 | PO18386193475 | 100 | 283 | 339 | 558 | 2 | 2023-04-06 | 2348.97 | 58.72 | 2023-03-25 | 5 | 486.71 | 1 | 2348.97 | 25 | SO49123 | 2023-04-01 | 187.92 | 2433.53 | 469.79 | |||
SO53506_28 | B5B1-4DF9-82 | PO11455145357 | 100 | 283 | 390 | 72 | 2 | 2023-11-04 | 6722.94 | 168.07 | 2023-10-23 | 10 | 713.08 | 1 | 6722.94 | 28 | SO53506 | 2023-10-30 | 537.84 | 7130.80 | 672.29 | |||
SO57101_3 | E5FB-42E2-A9 | PO18386193019 | 100 | 283 | 434 | 558 | 2 | 2024-01-04 | 1070.69 | 26.77 | 2023-12-23 | 3 | 360.94 | 1 | 1070.69 | 3 | SO57101 | 2023-12-30 | 85.66 | 1082.83 | 356.90 | |||
SO49113_3 | 4C8B-47E0-A7 | PO11658167469 | 100 | 283 | 364 | 233 | 2 | 2023-04-06 | 647.99 | 16.20 | 2023-03-25 | 1 | 598.44 | 1 | 647.99 | 3 | SO49113 | 2023-04-01 | 51.84 | 598.44 | 647.99 | |||
SO47450_55 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 453 | 54 | 2 | 2022-11-04 | 143.98 | 3.60 | 2022-10-23 | 4 | 24.75 | 1 | 143.98 | 55 | SO47450 | 2022-10-30 | 11.52 | 98.98 | 35.99 | |||
SO49864_31 | D282-4C24-9B | PO13775121562 | 100 | 283 | 458 | 618 | 2 | 2023-06-04 | 89.99 | 2.25 | 2023-05-23 | 2 | 30.93 | 1 | 89.99 | 31 | SO49864 | 2023-05-30 | 7.20 | 61.87 | 44.99 | |||
SO44531_6 | E4D9-426B-8B | PO10121174343 | 100 | 281 | 279 | 684 | 2 | 2022-01-04 | 178.58 | 4.46 | 2021-12-23 | 1 | 176.20 | 1 | 178.58 | 6 | SO44531 | 2021-12-30 | 14.29 | 176.20 | 178.58 | |||
SO59012_33 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 577 | 539 | 2 | 2024-02-03 | 2915.64 | 72.89 | 2024-01-22 | 4 | 755.15 | 1 | 2915.64 | 33 | SO59012 | 2024-01-29 | 233.25 | 3020.60 | 728.91 | |||
SO65153_4 | 0F10-4B75-A4 | PO19894114601 | 100 | 283 | 570 | 557 | 2 | 2024-05-04 | 1336.23 | 33.41 | 2024-04-22 | 3 | 461.44 | 1 | 1336.23 | 4 | SO65153 | 2024-04-29 | 106.90 | 1384.33 | 445.41 | |||
SO48753_4 | 1DDA-42B2-AF | PO17197151135 | 100 | 283 | 358 | 125 | 2 | 2023-03-06 | 4917.84 | 122.95 | 2023-02-22 | 4 | 1105.81 | 1 | 4917.84 | 4 | SO48753 | 2023-03-01 | 393.43 | 4423.24 | 1229.46 | |||
SO55248_29 | 8E6C-4F5E-92 | PO13775186264 | 100 | 283 | 471 | 2 | 618 | 2 | 9.58 | 2023-12-04 | 478.79 | 11.73 | 2023-11-22 | 13 | 23.75 | 1 | 469.21 | 29 | SO55248 | 2023-11-29 | 37.54 | 308.74 | 36.83 | 0.02 |
SO44307_5 | BDB1-4B91-A6 | PO1566191208 | 100 | 281 | 326 | 486 | 2 | 2021-12-04 | 838.92 | 20.97 | 2021-11-22 | 2 | 413.15 | 1 | 838.92 | 5 | SO44307 | 2021-11-29 | 67.11 | 826.29 | 419.46 | |||
SO65236_31 | 46EF-4D44-A9 | PO9483140017 | 100 | 283 | 434 | 54 | 2 | 2024-05-04 | 356.90 | 8.92 | 2024-04-22 | 1 | 360.94 | 1 | 356.90 | 31 | SO65236 | 2024-04-29 | 28.55 | 360.94 | 356.90 | |||
SO55301_48 | C4D6-4789-A9 | PO3828165579 | 100 | 283 | 357 | 414 | 2 | 2023-12-04 | 1391.99 | 34.80 | 2023-11-22 | 1 | 1265.62 | 1 | 1391.99 | 48 | SO55301 | 2023-11-29 | 111.36 | 1265.62 | 1391.99 | |||
SO65257_23 | 4659-4DD9-90 | PO7685190459 | 100 | 283 | 578 | 539 | 2 | 2024-05-04 | 1457.82 | 36.45 | 2024-04-22 | 2 | 755.15 | 1 | 1457.82 | 23 | SO65257 | 2024-04-29 | 116.63 | 1510.30 | 728.91 | |||
SO58950_16 | E67E-435E-9F | PO11455199372 | 100 | 283 | 583 | 72 | 2 | 2024-02-03 | 4082.38 | 102.06 | 2024-01-22 | 4 | 1082.51 | 1 | 4082.38 | 16 | SO58950 | 2024-01-29 | 326.59 | 4330.04 | 1020.59 | |||
SO49157_7 | 9DDB-4852-A8 | PO7424122254 | 100 | 283 | 356 | 642 | 2 | 2023-04-06 | 8699.96 | 217.50 | 2023-03-25 | 7 | 1117.86 | 1 | 8699.96 | 7 | SO49157 | 2023-04-01 | 696.00 | 7824.99 | 1242.85 | |||
SO49894_18 | C75C-4AA6-B6 | PO10092140429 | 100 | 283 | 399 | 252 | 2 | 2023-06-04 | 33.77 | 0.84 | 2023-05-23 | 1 | 24.99 | 1 | 33.77 | 18 | SO49894 | 2023-05-30 | 2.70 | 24.99 | 33.77 | |||
SO65257_22 | 4659-4DD9-90 | PO7685190459 | 100 | 283 | 472 | 539 | 2 | 2024-05-04 | 38.10 | 0.95 | 2024-04-22 | 1 | 23.75 | 1 | 38.10 | 22 | SO65257 | 2024-04-29 | 3.05 | 23.75 | 38.10 |
Generated 2024-09-21 08:49:44.788 UTC