[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '7' > SKIP 2503 SKIP 0 SHUFFLE SKIP 1000
27 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47377_35 | FA63-499A-AB | PO15515156459 | 100 | 292 | 335 | 481 | 7 | 2022-12-27 | 939.59 | 23.49 | 2022-12-15 | 2 | 486.71 | 1 | 939.59 | 35 | SO47377 | 2022-12-22 | 75.17 | 973.41 | 469.79 | |||
SO57061_35 | C48C-4776-A7 | PO12702183787 | 100 | 292 | 487 | 2 | 175 | 7 | 7.65 | 2024-02-26 | 382.73 | 9.38 | 2024-02-14 | 12 | 20.57 | 1 | 375.08 | 35 | SO57061 | 2024-02-21 | 30.01 | 246.80 | 31.89 | 0.02 |
SO46627_11 | A7A2-45B6-97 | PO13485114699 | 100 | 292 | 356 | 265 | 7 | 2022-10-26 | 1242.85 | 31.07 | 2022-10-14 | 1 | 1117.86 | 1 | 1242.85 | 11 | SO46627 | 2022-10-21 | 99.43 | 1117.86 | 1242.85 | |||
SO57181_1 | 9ADA-417F-90 | PO8323175925 | 100 | 292 | 430 | 211 | 7 | 2024-02-26 | 356.90 | 8.92 | 2024-02-14 | 1 | 360.94 | 1 | 356.90 | 1 | SO57181 | 2024-02-21 | 28.55 | 360.94 | 356.90 | |||
SO53523_16 | F9D7-4438-8C | PO1450197859 | 100 | 292 | 484 | 571 | 7 | 2023-12-27 | 28.62 | 0.72 | 2023-12-15 | 6 | 2.97 | 1 | 28.62 | 16 | SO53523 | 2023-12-22 | 2.29 | 17.84 | 4.77 | |||
SO57068_9 | 0E44-4044-B3 | PO11223190191 | 100 | 292 | 559 | 632 | 7 | 2024-02-26 | 48.58 | 1.21 | 2024-02-14 | 4 | 8.99 | 1 | 48.58 | 9 | SO57068 | 2024-02-21 | 3.89 | 35.95 | 12.14 | |||
SO58926_3 | B82A-4380-9C | PO15486118845 | 100 | 292 | 398 | 121 | 7 | 2024-03-27 | 53.45 | 1.34 | 2024-03-15 | 2 | 19.78 | 1 | 53.45 | 3 | SO58926 | 2024-03-22 | 4.28 | 39.55 | 26.72 | |||
SO57119_9 | 588B-4457-8A | PO3712174757 | 100 | 292 | 560 | 662 | 7 | 2024-02-26 | 728.91 | 18.22 | 2024-02-14 | 1 | 755.15 | 1 | 728.91 | 9 | SO57119 | 2024-02-21 | 58.31 | 755.15 | 728.91 | |||
SO57086_6 | 9159-4FEC-A8 | PO2668146833 | 100 | 292 | 306 | 535 | 7 | 2024-02-26 | 809.76 | 20.24 | 2024-02-14 | 1 | 739.04 | 1 | 809.76 | 6 | SO57086 | 2024-02-21 | 64.78 | 739.04 | 809.76 | |||
SO57051_6 | 0E3B-4DB5-83 | PO13427178709 | 100 | 292 | 471 | 3 | 638 | 7 | 26.19 | 2024-02-26 | 523.88 | 12.44 | 2024-02-14 | 15 | 23.75 | 1 | 497.68 | 6 | SO57051 | 2024-02-21 | 39.81 | 356.24 | 34.93 | 0.05 |
SO57143_26 | 69ED-4172-83 | PO3567189986 | 100 | 292 | 507 | 193 | 7 | 2024-02-26 | 200.05 | 5.00 | 2024-02-14 | 1 | 199.85 | 1 | 200.05 | 26 | SO57143 | 2024-02-21 | 16.00 | 199.85 | 200.05 | |||
SO57061_26 | C48C-4776-A7 | PO12702183787 | 100 | 292 | 543 | 175 | 7 | 2024-02-26 | 111.76 | 2.79 | 2024-02-14 | 3 | 27.57 | 1 | 111.76 | 26 | SO57061 | 2024-02-21 | 8.94 | 82.70 | 37.25 | |||
SO47410_7 | E1AD-4918-86 | PO1450182394 | 100 | 292 | 456 | 571 | 7 | 2022-12-27 | 89.99 | 2.25 | 2022-12-15 | 2 | 30.93 | 1 | 89.99 | 7 | SO47410 | 2022-12-22 | 7.20 | 61.87 | 44.99 | |||
SO57143_6 | 69ED-4172-83 | PO3567189986 | 100 | 292 | 500 | 193 | 7 | 2024-02-26 | 1204.69 | 30.12 | 2024-02-14 | 2 | 601.74 | 1 | 1204.69 | 6 | SO57143 | 2024-02-21 | 96.38 | 1203.49 | 602.35 | |||
SO47377_9 | FA63-499A-AB | PO15515156459 | 100 | 292 | 245 | 481 | 7 | 2022-12-27 | 1561.64 | 39.04 | 2022-12-15 | 2 | 722.26 | 1 | 1561.64 | 9 | SO47377 | 2022-12-22 | 124.93 | 1444.51 | 780.82 | |||
SO55252_32 | 1F1C-4667-AE | PO13340115824 | 100 | 292 | 475 | 355 | 7 | 2024-01-26 | 125.98 | 3.15 | 2024-01-14 | 3 | 26.18 | 1 | 125.98 | 32 | SO55252 | 2024-01-21 | 10.08 | 78.53 | 41.99 | |||
SO47391_10 | 8A04-4F3F-97 | PO12673197440 | 100 | 292 | 242 | 499 | 7 | 2022-12-27 | 2342.45 | 58.56 | 2022-12-15 | 3 | 722.26 | 1 | 2342.45 | 10 | SO47391 | 2022-12-22 | 187.40 | 2166.77 | 780.82 | |||
SO58943_8 | 8472-486E-87 | PO12673119602 | 100 | 292 | 376 | 499 | 7 | 2024-03-27 | 1466.01 | 36.65 | 2024-03-15 | 1 | 1554.95 | 1 | 1466.01 | 8 | SO58943 | 2024-03-22 | 117.28 | 1554.95 | 1466.01 | |||
SO46627_8 | A7A2-45B6-97 | PO13485114699 | 100 | 292 | 216 | 8 | 265 | 7 | 8.41 | 2022-10-26 | 84.11 | 1.89 | 2022-10-14 | 5 | 13.88 | 1 | 75.70 | 8 | SO46627 | 2022-10-21 | 6.06 | 69.39 | 16.82 | 0.10 |
SO57061_18 | C48C-4776-A7 | PO12702183787 | 100 | 292 | 295 | 175 | 7 | 2024-02-26 | 4093.50 | 102.34 | 2024-02-14 | 5 | 747.20 | 1 | 4093.50 | 18 | SO57061 | 2024-02-21 | 327.48 | 3736.00 | 818.70 | |||
SO57054_1 | 8D1A-4AF0-91 | PO13456189029 | 36 | 292 | 568 | 614 | 7 | 2024-02-26 | 1336.23 | 33.41 | 2024-02-14 | 3 | 461.44 | 1 | 1336.23 | 1 | SO57054 | 2024-02-21 | 106.90 | 1384.33 | 445.41 | |||
SO57086_13 | 9159-4FEC-A8 | PO2668146833 | 100 | 292 | 515 | 535 | 7 | 2024-02-26 | 16.27 | 0.41 | 2024-02-14 | 1 | 12.04 | 1 | 16.27 | 13 | SO57086 | 2024-02-21 | 1.30 | 12.04 | 16.27 | |||
SO46981_57 | 22E4-4440-81 | PO13427119728 | 100 | 292 | 459 | 2 | 638 | 7 | 11.48 | 2022-11-26 | 574.14 | 14.07 | 2022-11-14 | 11 | 37.12 | 1 | 562.65 | 57 | SO46981 | 2022-11-21 | 45.01 | 408.33 | 52.19 | 0.02 |
SO57056_4 | EE54-4BF3-BD | PO12731191306 | 36 | 290 | 225 | 247 | 7 | 2024-02-26 | 16.18 | 0.40 | 2024-02-14 | 3 | 6.92 | 1 | 16.18 | 4 | SO57056 | 2024-02-21 | 1.29 | 20.77 | 5.39 | |||
SO55311_15 | 2309-401E-BD | PO3509171799 | 36 | 292 | 545 | 139 | 7 | 2024-01-26 | 97.18 | 2.43 | 2024-01-14 | 4 | 17.98 | 1 | 97.18 | 15 | SO55311 | 2024-01-21 | 7.77 | 71.91 | 24.29 | |||
SO57054_7 | 8D1A-4AF0-91 | PO13456189029 | 36 | 292 | 554 | 614 | 7 | 2024-02-26 | 164.83 | 4.12 | 2024-02-14 | 3 | 40.66 | 1 | 164.83 | 7 | SO57054 | 2024-02-21 | 13.19 | 121.97 | 54.94 | |||
SO55252_38 | 1F1C-4667-AE | PO13340115824 | 100 | 292 | 595 | 355 | 7 | 2024-01-26 | 1355.98 | 33.90 | 2024-01-14 | 4 | 308.22 | 1 | 1355.98 | 38 | SO55252 | 2024-01-21 | 108.48 | 1232.87 | 338.99 |
Generated 2024-11-13 06:20:01.890 UTC