[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '3' > < SKIP 3124 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46621_6 | DCA1-4F74-BD | PO13949117076 | 100 | 281 | 323 | 643 | 3 | 2022-10-26 | 939.59 | 23.49 | 2022-10-14 | 2 | 486.71 | 1 | 939.59 | 6 | SO46621 | 2022-10-21 | 75.17 | 973.41 | 469.79 | |||
SO46621_7 | DCA1-4F74-BD | PO13949117076 | 100 | 281 | 329 | 643 | 3 | 2022-10-26 | 939.59 | 23.49 | 2022-10-14 | 2 | 486.71 | 1 | 939.59 | 7 | SO46621 | 2022-10-21 | 75.17 | 973.41 | 469.79 | |||
SO46621_8 | DCA1-4F74-BD | PO13949117076 | 100 | 281 | 327 | 9 | 643 | 3 | 211.41 | 2022-10-26 | 704.69 | 12.33 | 2022-10-14 | 3 | 486.71 | 1 | 493.28 | 8 | SO46621 | 2022-10-21 | 39.46 | 1460.12 | 234.90 | 0.30 |
SO46629_1 | E8D3-4649-8A | PO12412165004 | 100 | 283 | 271 | 670 | 3 | 2022-10-26 | 809.33 | 20.23 | 2022-10-14 | 4 | 187.16 | 1 | 809.33 | 1 | SO46629 | 2022-10-21 | 64.75 | 748.63 | 202.33 | |||
SO46629_2 | E8D3-4649-8A | PO12412165004 | 100 | 283 | 263 | 670 | 3 | 2022-10-26 | 809.33 | 20.23 | 2022-10-14 | 4 | 187.16 | 1 | 809.33 | 2 | SO46629 | 2022-10-21 | 64.75 | 748.63 | 202.33 | |||
SO46629_3 | E8D3-4649-8A | PO12412165004 | 100 | 283 | 329 | 670 | 3 | 2022-10-26 | 1409.38 | 35.23 | 2022-10-14 | 3 | 486.71 | 1 | 1409.38 | 3 | SO46629 | 2022-10-21 | 112.75 | 1460.12 | 469.79 | |||
SO46629_4 | E8D3-4649-8A | PO12412165004 | 100 | 283 | 389 | 670 | 3 | 2022-10-26 | 1800.79 | 45.02 | 2022-10-14 | 3 | 605.65 | 1 | 1800.79 | 4 | SO46629 | 2022-10-21 | 144.06 | 1816.95 | 600.26 | |||
SO46629_5 | E8D3-4649-8A | PO12412165004 | 100 | 283 | 371 | 670 | 3 | 2022-10-26 | 9162.56 | 229.06 | 2022-10-14 | 7 | 1320.68 | 1 | 9162.56 | 5 | SO46629 | 2022-10-21 | 733.01 | 9244.79 | 1308.94 | |||
SO46629_6 | E8D3-4649-8A | PO12412165004 | 100 | 283 | 339 | 670 | 3 | 2022-10-26 | 2348.97 | 58.72 | 2022-10-14 | 5 | 486.71 | 1 | 2348.97 | 6 | SO46629 | 2022-10-21 | 187.92 | 2433.53 | 469.79 | |||
SO46629_7 | E8D3-4649-8A | PO12412165004 | 100 | 283 | 375 | 670 | 3 | 2022-10-26 | 3926.81 | 98.17 | 2022-10-14 | 3 | 1320.68 | 1 | 3926.81 | 7 | SO46629 | 2022-10-21 | 314.15 | 3962.05 | 1308.94 | |||
SO46629_8 | E8D3-4649-8A | PO12412165004 | 100 | 283 | 341 | 670 | 3 | 2022-10-26 | 2818.76 | 70.47 | 2022-10-14 | 6 | 486.71 | 1 | 2818.76 | 8 | SO46629 | 2022-10-21 | 225.50 | 2920.24 | 469.79 | |||
SO46629_9 | E8D3-4649-8A | PO12412165004 | 100 | 283 | 335 | 670 | 3 | 2022-10-26 | 1879.18 | 46.98 | 2022-10-14 | 4 | 486.71 | 1 | 1879.18 | 9 | SO46629 | 2022-10-21 | 150.33 | 1946.83 | 469.79 | |||
SO58906_33 | 6BB0-48C1-BE | PO19633186598 | 100 | 287 | 491 | 149 | 3 | 2024-03-27 | 161.97 | 4.05 | 2024-03-15 | 5 | 41.57 | 1 | 161.97 | 33 | SO58906 | 2024-03-22 | 12.96 | 207.86 | 32.39 | |||
SO58906_34 | 6BB0-48C1-BE | PO19633186598 | 100 | 287 | 465 | 149 | 3 | 2024-03-27 | 102.86 | 2.57 | 2024-03-15 | 7 | 9.16 | 1 | 102.86 | 34 | SO58906 | 2024-03-22 | 8.23 | 64.12 | 14.69 | |||
SO58906_35 | 6BB0-48C1-BE | PO19633186598 | 100 | 287 | 214 | 149 | 3 | 2024-03-27 | 83.98 | 2.10 | 2024-03-15 | 4 | 13.09 | 1 | 83.98 | 35 | SO58906 | 2024-03-22 | 6.72 | 52.35 | 20.99 | |||
SO58906_36 | 6BB0-48C1-BE | PO19633186598 | 100 | 287 | 217 | 149 | 3 | 2024-03-27 | 62.98 | 1.57 | 2024-03-15 | 3 | 13.09 | 1 | 62.98 | 36 | SO58906 | 2024-03-22 | 5.04 | 39.26 | 20.99 | |||
SO58906_37 | 6BB0-48C1-BE | PO19633186598 | 100 | 287 | 483 | 149 | 3 | 2024-03-27 | 72.00 | 1.80 | 2024-03-15 | 1 | 44.88 | 1 | 72.00 | 37 | SO58906 | 2024-03-22 | 5.76 | 44.88 | 72.00 | |||
SO58906_38 | 6BB0-48C1-BE | PO19633186598 | 100 | 287 | 524 | 149 | 3 | 2024-03-27 | 316.86 | 7.92 | 2024-03-15 | 2 | 144.59 | 1 | 316.86 | 38 | SO58906 | 2024-03-22 | 25.35 | 289.19 | 158.43 | |||
SO58906_39 | 6BB0-48C1-BE | PO19633186598 | 100 | 287 | 590 | 149 | 3 | 2024-03-27 | 1846.78 | 46.17 | 2024-03-15 | 4 | 419.78 | 1 | 1846.78 | 39 | SO58906 | 2024-03-22 | 147.74 | 1679.11 | 461.69 | |||
SO58906_40 | 6BB0-48C1-BE | PO19633186598 | 100 | 287 | 543 | 149 | 3 | 2024-03-27 | 37.25 | 0.93 | 2024-03-15 | 1 | 27.57 | 1 | 37.25 | 40 | SO58906 | 2024-03-22 | 2.98 | 27.57 | 37.25 | |||
SO58921_1 | DB78-489E-8E | PO16994165104 | 100 | 283 | 382 | 306 | 3 | 2024-03-27 | 1344.59 | 33.61 | 2024-03-15 | 2 | 713.08 | 1 | 1344.59 | 1 | SO58921 | 2024-03-22 | 107.57 | 1426.16 | 672.29 | |||
SO58921_2 | DB78-489E-8E | PO16994165104 | 100 | 283 | 481 | 306 | 3 | 2024-03-27 | 32.36 | 0.81 | 2024-03-15 | 6 | 3.36 | 1 | 32.36 | 2 | SO58921 | 2024-03-22 | 2.59 | 20.17 | 5.39 | |||
SO58921_3 | DB78-489E-8E | PO16994165104 | 100 | 283 | 482 | 306 | 3 | 2024-03-27 | 32.36 | 0.81 | 2024-03-15 | 6 | 3.36 | 1 | 32.36 | 3 | SO58921 | 2024-03-22 | 2.59 | 20.17 | 5.39 | |||
SO58921_4 | DB78-489E-8E | PO16994165104 | 100 | 283 | 418 | 306 | 3 | 2024-03-27 | 713.80 | 17.84 | 2024-03-15 | 2 | 360.94 | 1 | 713.80 | 4 | SO58921 | 2024-03-22 | 57.10 | 721.89 | 356.90 | |||
SO58921_5 | DB78-489E-8E | PO16994165104 | 100 | 283 | 386 | 306 | 3 | 2024-03-27 | 1344.59 | 33.61 | 2024-03-15 | 2 | 713.08 | 1 | 1344.59 | 5 | SO58921 | 2024-03-22 | 107.57 | 1426.16 | 672.29 | |||
SO58921_6 | DB78-489E-8E | PO16994165104 | 100 | 283 | 374 | 306 | 3 | 2024-03-27 | 2932.02 | 73.30 | 2024-03-15 | 2 | 1554.95 | 1 | 2932.02 | 6 | SO58921 | 2024-03-22 | 234.56 | 3109.90 | 1466.01 | |||
SO58921_7 | DB78-489E-8E | PO16994165104 | 100 | 283 | 390 | 306 | 3 | 2024-03-27 | 2016.88 | 50.42 | 2024-03-15 | 3 | 713.08 | 1 | 2016.88 | 7 | SO58921 | 2024-03-22 | 161.35 | 2139.24 | 672.29 | |||
SO58921_8 | DB78-489E-8E | PO16994165104 | 100 | 283 | 463 | 306 | 3 | 2024-03-27 | 14.69 | 0.37 | 2024-03-15 | 1 | 9.16 | 1 | 14.69 | 8 | SO58921 | 2024-03-22 | 1.18 | 9.16 | 14.69 |
Generated 2024-11-13 10:13:13.610 UTC