[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > < SKIP 2318 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49088_1 | ED04-4B44-9B | PO11542199639 | 100 | 285 | 323 | 62 | 5 | 2023-04-06 | 1409.38 | 35.23 | 2023-03-25 | 3 | 486.71 | 1 | 1409.38 | 1 | SO49088 | 2023-04-01 | 112.75 | 1460.12 | 469.79 | |||
SO51693_31 | 6FEB-4D5B-92 | PO19546179477 | 100 | 285 | 482 | 206 | 5 | 2023-10-04 | 16.18 | 0.40 | 2023-09-22 | 3 | 3.36 | 1 | 16.18 | 31 | SO51693 | 2023-09-29 | 1.29 | 10.09 | 5.39 | |||
SO63124_11 | 5CAE-4C1D-85 | PO19546167735 | 100 | 285 | 386 | 206 | 5 | 2024-04-05 | 1344.59 | 33.61 | 2024-03-24 | 2 | 713.08 | 1 | 1344.59 | 11 | SO63124 | 2024-03-31 | 107.57 | 1426.16 | 672.29 | |||
SO46056_3 | 4B9A-4022-AA | PO12586180466 | 100 | 285 | 307 | 278 | 5 | 2022-07-04 | 2890.38 | 72.26 | 2022-06-22 | 4 | 623.84 | 1 | 2890.38 | 3 | SO46056 | 2022-06-29 | 231.23 | 2495.36 | 722.59 | |||
SO49088_2 | ED04-4B44-9B | PO11542199639 | 100 | 285 | 343 | 62 | 5 | 2023-04-06 | 469.79 | 11.74 | 2023-03-25 | 1 | 486.71 | 1 | 469.79 | 2 | SO49088 | 2023-04-01 | 37.58 | 486.71 | 469.79 | |||
SO51701_1 | 9BDF-42CB-8A | PO17255146915 | 100 | 285 | 579 | 80 | 5 | 2023-10-04 | 728.91 | 18.22 | 2023-09-22 | 1 | 755.15 | 1 | 728.91 | 1 | SO51701 | 2023-09-29 | 58.31 | 755.15 | 728.91 | |||
SO63124_12 | 5CAE-4C1D-85 | PO19546167735 | 100 | 285 | 583 | 206 | 5 | 2024-04-05 | 2041.19 | 51.03 | 2024-03-24 | 2 | 1082.51 | 1 | 2041.19 | 12 | SO63124 | 2024-03-31 | 163.30 | 2165.02 | 1020.59 | |||
SO46056_4 | 4B9A-4022-AA | PO12586180466 | 100 | 285 | 293 | 278 | 5 | 2022-07-04 | 2890.38 | 72.26 | 2022-06-22 | 4 | 623.84 | 1 | 2890.38 | 4 | SO46056 | 2022-06-29 | 231.23 | 2495.36 | 722.59 | |||
SO49088_3 | ED04-4B44-9B | PO11542199639 | 100 | 285 | 325 | 62 | 5 | 2023-04-06 | 469.79 | 11.74 | 2023-03-25 | 1 | 486.71 | 1 | 469.79 | 3 | SO49088 | 2023-04-01 | 37.58 | 486.71 | 469.79 | |||
SO51701_2 | 9BDF-42CB-8A | PO17255146915 | 100 | 285 | 564 | 14 | 80 | 5 | 381.45 | 2023-10-04 | 1907.26 | 38.15 | 2023-09-22 | 2 | 1481.94 | 1 | 1525.80 | 2 | SO51701 | 2023-09-29 | 122.06 | 2963.88 | 953.63 | 0.20 |
SO63124_13 | 5CAE-4C1D-85 | PO19546167735 | 100 | 285 | 374 | 206 | 5 | 2024-04-05 | 2932.02 | 73.30 | 2024-03-24 | 2 | 1554.95 | 1 | 2932.02 | 13 | SO63124 | 2024-03-31 | 234.56 | 3109.90 | 1466.01 | |||
SO46056_5 | 4B9A-4022-AA | PO12586180466 | 100 | 285 | 351 | 278 | 5 | 2022-07-04 | 4049.99 | 101.25 | 2022-06-22 | 2 | 1898.09 | 1 | 4049.99 | 5 | SO46056 | 2022-06-29 | 324.00 | 3796.19 | 2024.99 | |||
SO49088_4 | ED04-4B44-9B | PO11542199639 | 100 | 285 | 329 | 62 | 5 | 2023-04-06 | 1409.38 | 35.23 | 2023-03-25 | 3 | 486.71 | 1 | 1409.38 | 4 | SO49088 | 2023-04-01 | 112.75 | 1460.12 | 469.79 | |||
SO51705_1 | DFFB-4C23-BD | PO16965171069 | 100 | 285 | 490 | 441 | 5 | 2023-10-04 | 226.76 | 5.67 | 2023-09-22 | 7 | 41.57 | 1 | 226.76 | 1 | SO51705 | 2023-09-29 | 18.14 | 291.01 | 32.39 | |||
SO63124_14 | 5CAE-4C1D-85 | PO19546167735 | 100 | 285 | 384 | 206 | 5 | 2024-04-05 | 672.29 | 16.81 | 2024-03-24 | 1 | 713.08 | 1 | 672.29 | 14 | SO63124 | 2024-03-31 | 53.78 | 713.08 | 672.29 | |||
SO46056_6 | 4B9A-4022-AA | PO12586180466 | 100 | 285 | 304 | 278 | 5 | 2022-07-04 | 2858.82 | 71.47 | 2022-06-22 | 4 | 617.03 | 1 | 2858.82 | 6 | SO46056 | 2022-06-29 | 228.71 | 2468.11 | 714.70 | |||
SO49088_5 | ED04-4B44-9B | PO11542199639 | 100 | 285 | 327 | 62 | 5 | 2023-04-06 | 469.79 | 11.74 | 2023-03-25 | 1 | 486.71 | 1 | 469.79 | 5 | SO49088 | 2023-04-01 | 37.58 | 486.71 | 469.79 | |||
SO51705_2 | DFFB-4C23-BD | PO16965171069 | 100 | 285 | 580 | 441 | 5 | 2023-10-04 | 2041.19 | 51.03 | 2023-09-22 | 2 | 1082.51 | 1 | 2041.19 | 2 | SO51705 | 2023-09-29 | 163.30 | 2165.02 | 1020.59 | |||
SO63124_15 | 5CAE-4C1D-85 | PO19546167735 | 100 | 285 | 482 | 206 | 5 | 2024-04-05 | 10.79 | 0.27 | 2024-03-24 | 2 | 3.36 | 1 | 10.79 | 15 | SO63124 | 2024-03-31 | 0.86 | 6.72 | 5.39 | |||
SO46056_7 | 4B9A-4022-AA | PO12586180466 | 100 | 285 | 346 | 278 | 5 | 2022-07-04 | 10199.97 | 255.00 | 2022-06-22 | 5 | 1912.15 | 1 | 10199.97 | 7 | SO46056 | 2022-06-29 | 816.00 | 9560.77 | 2039.99 | |||
SO49088_6 | ED04-4B44-9B | PO11542199639 | 100 | 285 | 333 | 62 | 5 | 2023-04-06 | 1409.38 | 35.23 | 2023-03-25 | 3 | 486.71 | 1 | 1409.38 | 6 | SO49088 | 2023-04-01 | 112.75 | 1460.12 | 469.79 | |||
SO51705_3 | DFFB-4C23-BD | PO16965171069 | 100 | 285 | 477 | 441 | 5 | 2023-10-04 | 5.99 | 0.15 | 2023-09-22 | 2 | 1.87 | 1 | 5.99 | 3 | SO51705 | 2023-09-29 | 0.48 | 3.73 | 2.99 | |||
SO63124_16 | 5CAE-4C1D-85 | PO19546167735 | 100 | 285 | 378 | 206 | 5 | 2024-04-05 | 2932.02 | 73.30 | 2024-03-24 | 2 | 1554.95 | 1 | 2932.02 | 16 | SO63124 | 2024-03-31 | 234.56 | 3109.90 | 1466.01 | |||
SO46056_8 | 4B9A-4022-AA | PO12586180466 | 100 | 285 | 348 | 278 | 5 | 2022-07-04 | 6074.98 | 151.87 | 2022-06-22 | 3 | 1898.09 | 1 | 6074.98 | 8 | SO46056 | 2022-06-29 | 486.00 | 5694.28 | 2024.99 |
Generated 2024-09-21 06:46:30.068 UTC