[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '3' > SKIP 0 < SKIP 3342 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO55324_4 | 35BE-456A-B8 | PO8787146999 | 100 | 282 | 547 | 523 | 3 | 2023-12-03 | 97.19 | 2.43 | 2023-11-21 | 2 | 35.96 | 1 | 97.19 | 4 | SO55324 | 2023-11-28 | 7.78 | 71.92 | 48.59 | |||
SO69468_6 | 25FB-4E10-88 | PO3074129578 | 100 | 281 | 592 | 16 | 237 | 3 | 90.40 | 2024-07-03 | 226.00 | 3.39 | 2024-06-21 | 2 | 308.22 | 1 | 135.60 | 6 | SO69468 | 2024-06-28 | 10.85 | 616.44 | 113.00 | 0.40 |
SO46066_4 | ADF8-444D-9C | PO10759115463 | 100 | 283 | 351 | 346 | 3 | 2022-07-03 | 8099.98 | 202.50 | 2022-06-21 | 4 | 1898.09 | 1 | 8099.98 | 4 | SO46066 | 2022-06-28 | 648.00 | 7592.38 | 2024.99 | |||
SO49147_22 | B753-40C9-A6 | PO5771172608 | 100 | 282 | 371 | 79 | 3 | 2023-04-05 | 3926.81 | 98.17 | 2023-03-24 | 3 | 1320.68 | 1 | 3926.81 | 22 | SO49147 | 2023-03-31 | 314.15 | 3962.05 | 1308.94 | |||
SO55324_5 | 35BE-456A-B8 | PO8787146999 | 100 | 282 | 606 | 523 | 3 | 2023-12-03 | 647.99 | 16.20 | 2023-11-21 | 2 | 343.65 | 1 | 647.99 | 5 | SO55324 | 2023-11-28 | 51.84 | 687.30 | 323.99 | |||
SO69468_7 | 25FB-4E10-88 | PO3074129578 | 100 | 281 | 594 | 16 | 237 | 3 | 135.60 | 2024-07-03 | 338.99 | 5.08 | 2024-06-21 | 3 | 308.22 | 1 | 203.40 | 7 | SO69468 | 2024-06-28 | 16.27 | 924.65 | 113.00 | 0.40 |
SO46066_5 | ADF8-444D-9C | PO10759115463 | 100 | 283 | 347 | 346 | 3 | 2022-07-03 | 20399.94 | 510.00 | 2022-06-21 | 10 | 1912.15 | 1 | 20399.94 | 5 | SO46066 | 2022-06-28 | 1632.00 | 19121.54 | 2039.99 | |||
SO49147_23 | B753-40C9-A6 | PO5771172608 | 100 | 282 | 385 | 79 | 3 | 2023-04-05 | 4201.84 | 105.05 | 2023-03-24 | 7 | 605.65 | 1 | 4201.84 | 23 | SO49147 | 2023-03-31 | 336.15 | 4239.54 | 600.26 | |||
SO55324_6 | 35BE-456A-B8 | PO8787146999 | 100 | 282 | 477 | 3 | 523 | 3 | 2.74 | 2023-12-03 | 54.89 | 1.30 | 2023-11-21 | 20 | 1.87 | 1 | 52.15 | 6 | SO55324 | 2023-11-28 | 4.17 | 37.33 | 2.74 | 0.05 |
SO69468_8 | 25FB-4E10-88 | PO3074129578 | 100 | 281 | 398 | 237 | 3 | 2024-07-03 | 26.72 | 0.67 | 2024-06-21 | 1 | 19.78 | 1 | 26.72 | 8 | SO69468 | 2024-06-28 | 2.14 | 19.78 | 26.72 | |||
SO46066_6 | ADF8-444D-9C | PO10759115463 | 100 | 283 | 344 | 346 | 3 | 2022-07-03 | 20399.94 | 510.00 | 2022-06-21 | 10 | 1912.15 | 1 | 20399.94 | 6 | SO46066 | 2022-06-28 | 1632.00 | 19121.54 | 2039.99 | |||
SO49147_24 | B753-40C9-A6 | PO5771172608 | 100 | 282 | 369 | 79 | 3 | 2023-04-05 | 1466.01 | 36.65 | 2023-03-24 | 1 | 1518.79 | 1 | 1466.01 | 24 | SO49147 | 2023-03-31 | 117.28 | 1518.79 | 1466.01 | |||
SO55324_7 | 35BE-456A-B8 | PO8787146999 | 100 | 282 | 471 | 523 | 3 | 2023-12-03 | 228.60 | 5.72 | 2023-11-21 | 6 | 23.75 | 1 | 228.60 | 7 | SO55324 | 2023-11-28 | 18.29 | 142.49 | 38.10 | |||
SO69480_1 | C121-45B1-B6 | PO15225149137 | 100 | 283 | 497 | 360 | 3 | 2024-07-03 | 2409.38 | 60.23 | 2024-06-21 | 4 | 601.74 | 1 | 2409.38 | 1 | SO69480 | 2024-06-28 | 192.75 | 2406.97 | 602.35 | |||
SO46066_7 | ADF8-444D-9C | PO10759115463 | 100 | 283 | 348 | 346 | 3 | 2022-07-03 | 6074.98 | 151.87 | 2022-06-21 | 3 | 1898.09 | 1 | 6074.98 | 7 | SO46066 | 2022-06-28 | 486.00 | 5694.28 | 2024.99 | |||
SO49147_25 | B753-40C9-A6 | PO5771172608 | 100 | 282 | 339 | 79 | 3 | 2023-04-05 | 2348.97 | 58.72 | 2023-03-24 | 5 | 486.71 | 1 | 2348.97 | 25 | SO49147 | 2023-03-31 | 187.92 | 2433.53 | 469.79 | |||
SO55324_8 | 35BE-456A-B8 | PO8787146999 | 100 | 282 | 480 | 523 | 3 | 2023-12-03 | 6.87 | 0.17 | 2023-11-21 | 5 | 0.86 | 1 | 6.87 | 8 | SO55324 | 2023-11-28 | 0.55 | 4.28 | 1.37 | |||
SO69480_2 | C121-45B1-B6 | PO15225149137 | 100 | 283 | 494 | 360 | 3 | 2024-07-03 | 1807.04 | 45.18 | 2024-06-21 | 3 | 601.74 | 1 | 1807.04 | 2 | SO69480 | 2024-06-28 | 144.56 | 1805.23 | 602.35 | |||
SO46066_8 | ADF8-444D-9C | PO10759115463 | 100 | 283 | 218 | 346 | 3 | 2022-07-03 | 34.20 | 0.86 | 2022-06-21 | 6 | 3.40 | 1 | 34.20 | 8 | SO46066 | 2022-06-28 | 2.74 | 20.38 | 5.70 | |||
SO49147_26 | B753-40C9-A6 | PO5771172608 | 100 | 282 | 343 | 79 | 3 | 2023-04-05 | 1409.38 | 35.23 | 2023-03-24 | 3 | 486.71 | 1 | 1409.38 | 26 | SO49147 | 2023-03-31 | 112.75 | 1460.12 | 469.79 | |||
SO55324_9 | 35BE-456A-B8 | PO8787146999 | 100 | 282 | 481 | 523 | 3 | 2023-12-03 | 5.39 | 0.13 | 2023-11-21 | 1 | 3.36 | 1 | 5.39 | 9 | SO55324 | 2023-11-28 | 0.43 | 3.36 | 5.39 | |||
SO69480_3 | C121-45B1-B6 | PO15225149137 | 100 | 283 | 495 | 360 | 3 | 2024-07-03 | 1807.04 | 45.18 | 2024-06-21 | 3 | 601.74 | 1 | 1807.04 | 3 | SO69480 | 2024-06-28 | 144.56 | 1805.23 | 602.35 | |||
SO46066_9 | ADF8-444D-9C | PO10759115463 | 100 | 283 | 307 | 346 | 3 | 2022-07-03 | 1445.19 | 36.13 | 2022-06-21 | 2 | 623.84 | 1 | 1445.19 | 9 | SO46066 | 2022-06-28 | 115.62 | 1247.68 | 722.59 | |||
SO49147_27 | B753-40C9-A6 | PO5771172608 | 100 | 282 | 381 | 79 | 3 | 2023-04-05 | 2401.05 | 60.03 | 2023-03-24 | 4 | 605.65 | 1 | 2401.05 | 27 | SO49147 | 2023-03-31 | 192.08 | 2422.60 | 600.26 | |||
SO55324_10 | 35BE-456A-B8 | PO8787146999 | 100 | 282 | 384 | 523 | 3 | 2023-12-03 | 672.29 | 16.81 | 2023-11-21 | 1 | 713.08 | 1 | 672.29 | 10 | SO55324 | 2023-11-28 | 53.78 | 713.08 | 672.29 | |||
SO69480_4 | C121-45B1-B6 | PO15225149137 | 100 | 283 | 554 | 360 | 3 | 2024-07-03 | 54.94 | 1.37 | 2024-06-21 | 1 | 40.66 | 1 | 54.94 | 4 | SO69480 | 2024-06-28 | 4.40 | 40.66 | 54.94 | |||
SO46066_10 | ADF8-444D-9C | PO10759115463 | 100 | 283 | 349 | 346 | 3 | 2022-07-03 | 8099.98 | 202.50 | 2022-06-21 | 4 | 1898.09 | 1 | 8099.98 | 10 | SO46066 | 2022-06-28 | 648.00 | 7592.38 | 2024.99 | |||
SO49147_28 | B753-40C9-A6 | PO5771172608 | 100 | 282 | 335 | 79 | 3 | 2023-04-05 | 2348.97 | 58.72 | 2023-03-24 | 5 | 486.71 | 1 | 2348.97 | 28 | SO49147 | 2023-03-31 | 187.92 | 2433.53 | 469.79 | |||
SO55324_11 | 35BE-456A-B8 | PO8787146999 | 100 | 282 | 483 | 523 | 3 | 2023-12-03 | 576.00 | 14.40 | 2023-11-21 | 8 | 44.88 | 1 | 576.00 | 11 | SO55324 | 2023-11-28 | 46.08 | 359.04 | 72.00 | |||
SO69492_1 | FD40-425E-B6 | PO11252160870 | 100 | 281 | 287 | 606 | 3 | 2024-07-03 | 607.00 | 15.17 | 2024-06-21 | 3 | 204.63 | 1 | 607.00 | 1 | SO69492 | 2024-06-28 | 48.56 | 613.88 | 202.33 |
Generated 2024-09-20 11:50:03.737 UTC