[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 2498 > < TAKE 30 >
30 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47436_4 | 4AA1-4884-91 | PO5510133089 | 100 | 287 | 333 | 5 | 4 | 2022-11-03 | 939.59 | 23.49 | 2022-10-22 | 2 | 486.71 | 1 | 939.59 | 4 | SO47436 | 2022-10-29 | 75.17 | 973.41 | 469.79 | |||
SO48049_31 | C09A-49F5-80 | PO3799136256 | 100 | 282 | 221 | 312 | 4 | 2023-01-03 | 40.37 | 1.01 | 2022-12-22 | 2 | 13.88 | 1 | 40.37 | 31 | SO48049 | 2022-12-29 | 3.23 | 27.76 | 20.19 | |||
SO51764_10 | D5EC-49D5-9F | PO609164065 | 100 | 282 | 471 | 492 | 4 | 2023-10-03 | 114.30 | 2.86 | 2023-09-21 | 3 | 23.75 | 1 | 114.30 | 10 | SO51764 | 2023-09-28 | 9.14 | 71.25 | 38.10 | |||
SO47439_27 | D4B6-4746-BE | PO6786128920 | 100 | 283 | 417 | 3 | 4 | 2022-11-03 | 648.91 | 16.22 | 2022-10-22 | 2 | 300.12 | 1 | 648.91 | 27 | SO47439 | 2022-10-29 | 51.91 | 600.24 | 324.45 | |||
SO57128_3 | 52E0-4277-80 | PO6525176590 | 100 | 281 | 595 | 345 | 4 | 2024-01-03 | 338.99 | 8.47 | 2023-12-22 | 1 | 308.22 | 1 | 338.99 | 3 | SO57128 | 2023-12-29 | 27.12 | 308.22 | 338.99 | |||
SO51825_26 | E395-4F72-84 | PO6525184188 | 100 | 281 | 588 | 345 | 4 | 2023-10-03 | 1846.78 | 46.17 | 2023-09-21 | 4 | 419.78 | 1 | 1846.78 | 26 | SO51825 | 2023-09-28 | 147.74 | 1679.11 | 461.69 | |||
SO65266_1 | 4B49-46DB-97 | PO3944164136 | 100 | 281 | 523 | 112 | 4 | 2024-05-03 | 31.58 | 0.79 | 2024-04-21 | 1 | 23.37 | 1 | 31.58 | 1 | SO65266 | 2024-04-28 | 2.53 | 23.37 | 31.58 | |||
SO59027_34 | C142-4AAA-AB | PO6757122081 | 100 | 281 | 603 | 21 | 4 | 2024-02-02 | 145.79 | 3.64 | 2024-01-21 | 2 | 53.94 | 1 | 145.79 | 34 | SO59027 | 2024-01-28 | 11.66 | 107.88 | 72.89 | |||
SO47687_5 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 286 | 203 | 4 | 2022-12-03 | 183.94 | 4.60 | 2022-11-21 | 1 | 170.14 | 1 | 183.94 | 5 | SO47687 | 2022-11-28 | 14.72 | 170.14 | 183.94 | |||
SO57034_35 | 57D0-46D3-B7 | PO15689142548 | 100 | 281 | 471 | 328 | 4 | 2024-01-03 | 266.70 | 6.67 | 2023-12-22 | 7 | 23.75 | 1 | 266.70 | 35 | SO57034 | 2023-12-29 | 21.34 | 166.24 | 38.10 | |||
SO67325_27 | 981F-41CE-8A | PO7859144943 | 100 | 287 | 418 | 221 | 4 | 2024-06-03 | 356.90 | 8.92 | 2024-05-22 | 1 | 360.94 | 1 | 356.90 | 27 | SO67325 | 2024-05-29 | 28.55 | 360.94 | 356.90 | |||
SO47434_27 | 6848-4C33-98 | PO5539145068 | 100 | 282 | 468 | 61 | 4 | 2022-11-03 | 45.59 | 1.14 | 2022-10-22 | 2 | 15.67 | 1 | 45.59 | 27 | SO47434 | 2022-10-29 | 3.65 | 31.34 | 22.79 | |||
SO50663_48 | 286E-4915-89 | PO19343130555 | 100 | 282 | 462 | 2 | 24 | 4 | 3.28 | 2023-08-03 | 163.89 | 4.02 | 2023-07-22 | 12 | 9.71 | 1 | 160.62 | 48 | SO50663 | 2023-07-29 | 12.85 | 116.56 | 13.66 | 0.02 |
SO51102_29 | F2B1-4561-84 | PO13659193365 | 100 | 287 | 512 | 437 | 4 | 2023-09-02 | 1310.72 | 32.77 | 2023-08-21 | 6 | 199.38 | 1 | 1310.72 | 29 | SO51102 | 2023-08-28 | 104.86 | 1196.25 | 218.45 | |||
SO48740_21 | 158B-4BBF-9F | PO551143768 | 100 | 281 | 368 | 4 | 4 | 2023-03-05 | 7330.05 | 183.25 | 2023-02-21 | 5 | 1518.79 | 1 | 7330.05 | 21 | SO48740 | 2023-02-28 | 586.40 | 7593.93 | 1466.01 | |||
SO59068_18 | B7CC-4A9D-86 | PO9715112509 | 100 | 281 | 595 | 490 | 4 | 2024-02-02 | 1016.98 | 25.42 | 2024-01-21 | 3 | 308.22 | 1 | 1016.98 | 18 | SO59068 | 2024-01-28 | 81.36 | 924.65 | 338.99 | |||
SO44095_8 | 97A5-4FCA-88 | PO14964184959 | 100 | 287 | 307 | 581 | 4 | 2021-11-03 | 722.59 | 18.06 | 2021-10-22 | 1 | 623.84 | 1 | 722.59 | 8 | SO44095 | 2021-10-29 | 57.81 | 623.84 | 722.59 | |||
SO71857_19 | CD4E-4DE8-81 | PO16269151631 | 100 | 287 | 287 | 624 | 4 | 2024-08-03 | 202.33 | 5.06 | 2024-07-22 | 1 | 204.63 | 1 | 202.33 | 19 | SO71857 | 2024-07-29 | 16.19 | 204.63 | 202.33 | |||
SO69509_24 | 3683-45BF-B7 | PO4611111760 | 100 | 287 | 603 | 131 | 4 | 2024-07-03 | 72.89 | 1.82 | 2024-06-21 | 1 | 53.94 | 1 | 72.89 | 24 | SO69509 | 2024-06-28 | 5.83 | 53.94 | 72.89 | |||
SO67318_5 | 5460-4BEE-A6 | PO6409141464 | 100 | 281 | 481 | 292 | 4 | 2024-06-03 | 32.36 | 0.81 | 2024-05-22 | 6 | 3.36 | 1 | 32.36 | 5 | SO67318 | 2024-05-29 | 2.59 | 20.17 | 5.39 | |||
SO48363_27 | A9C9-4B7B-9B | PO3915186343 | 100 | 283 | 435 | 130 | 4 | 2023-02-02 | 1297.81 | 32.45 | 2023-01-21 | 4 | 300.12 | 1 | 1297.81 | 27 | SO48363 | 2023-01-28 | 103.82 | 1200.48 | 324.45 | |||
SO48052_18 | FBD0-4407-84 | PO3654150499 | 100 | 283 | 362 | 435 | 4 | 2023-01-03 | 3688.38 | 92.21 | 2022-12-22 | 3 | 1105.81 | 1 | 3688.38 | 18 | SO48052 | 2022-12-29 | 295.07 | 3317.43 | 1229.46 | |||
SO44087_2 | F58F-45C1-8E | PO16095130285 | 100 | 282 | 276 | 96 | 4 | 2021-11-03 | 713.80 | 17.84 | 2021-10-22 | 2 | 352.14 | 1 | 713.80 | 2 | SO44087 | 2021-10-29 | 57.10 | 704.28 | 356.90 | |||
SO51714_20 | D33A-4EAE-B1 | PO15689195197 | 100 | 281 | 378 | 328 | 4 | 2023-10-03 | 8796.06 | 219.90 | 2023-09-21 | 6 | 1554.95 | 1 | 8796.06 | 20 | SO51714 | 2023-09-28 | 703.68 | 9329.69 | 1466.01 | |||
SO46668_4 | 6711-47BE-BF | PO7859142972 | 100 | 287 | 286 | 221 | 4 | 2022-09-02 | 183.94 | 4.60 | 2022-08-21 | 1 | 170.14 | 1 | 183.94 | 4 | SO46668 | 2022-08-28 | 14.72 | 170.14 | 183.94 | |||
SO58919_7 | AF42-4FCB-BB | PO17052190887 | 100 | 282 | 498 | 420 | 4 | 2024-02-02 | 602.35 | 15.06 | 2024-01-21 | 1 | 601.74 | 1 | 602.35 | 7 | SO58919 | 2024-01-28 | 48.19 | 601.74 | 602.35 | |||
SO46058_6 | FA37-4F46-97 | PO12557123934 | 100 | 282 | 342 | 240 | 4 | 2022-07-03 | 1258.38 | 31.46 | 2022-06-21 | 3 | 413.15 | 1 | 1258.38 | 6 | SO46058 | 2022-06-28 | 100.67 | 1239.44 | 419.46 | |||
SO71857_3 | CD4E-4DE8-81 | PO16269151631 | 100 | 287 | 386 | 624 | 4 | 2024-08-03 | 1344.59 | 33.61 | 2024-07-22 | 2 | 713.08 | 1 | 1344.59 | 3 | SO71857 | 2024-07-29 | 107.57 | 1426.16 | 672.29 | |||
SO47049_5 | 3D73-4468-AE | PO6525111066 | 100 | 283 | 358 | 345 | 4 | 2022-10-03 | 7376.75 | 184.42 | 2022-09-21 | 6 | 1105.81 | 1 | 7376.75 | 5 | SO47049 | 2022-09-28 | 590.14 | 6634.86 | 1229.46 | |||
SO51745_27 | C261-441D-A5 | PO11745132954 | 100 | 282 | 372 | 97 | 4 | 2023-10-03 | 4398.03 | 109.95 | 2023-09-21 | 3 | 1554.95 | 1 | 4398.03 | 27 | SO51745 | 2023-09-28 | 351.84 | 4664.84 | 1466.01 |
Generated 2024-09-20 13:32:14.506 UTC