[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > < SKIP 4541 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46352_1 | A467-4700-9C | PO10585133264 | 19 | 284 | 351 | 7 | 498 | 6 | 590.62 | 2022-09-23 | 1687.50 | 27.42 | 2022-09-11 | 2 | 1898.09 | 1 | 1096.87 | 1 | SO46352 | 2022-09-18 | 87.75 | 3796.19 | 843.75 | 0.35 |
SO46352_2 | A467-4700-9C | PO10585133264 | 19 | 284 | 344 | 7 | 498 | 6 | 297.50 | 2022-09-23 | 850.00 | 13.81 | 2022-09-11 | 1 | 1912.15 | 1 | 552.50 | 2 | SO46352 | 2022-09-18 | 44.20 | 1912.15 | 850.00 | 0.35 |
SO46352_3 | A467-4700-9C | PO10585133264 | 19 | 284 | 350 | 7 | 498 | 6 | 885.93 | 2022-09-23 | 2531.24 | 41.13 | 2022-09-11 | 3 | 1898.09 | 1 | 1645.31 | 3 | SO46352 | 2022-09-18 | 131.62 | 5694.28 | 843.75 | 0.35 |
SO63128_1 | 9486-41CD-91 | PO18879146432 | 19 | 291 | 563 | 64 | 6 | 2024-05-25 | 1430.44 | 35.76 | 2024-05-13 | 1 | 1481.94 | 1 | 1430.44 | 1 | SO63128 | 2024-05-20 | 114.44 | 1481.94 | 1430.44 | |||
SO63128_2 | 9486-41CD-91 | PO18879146432 | 19 | 291 | 603 | 64 | 6 | 2024-05-25 | 145.79 | 3.64 | 2024-05-13 | 2 | 53.94 | 1 | 145.79 | 2 | SO63128 | 2024-05-20 | 11.66 | 107.88 | 72.89 | |||
SO63128_3 | 9486-41CD-91 | PO18879146432 | 19 | 291 | 576 | 64 | 6 | 2024-05-25 | 1430.44 | 35.76 | 2024-05-13 | 1 | 1481.94 | 1 | 1430.44 | 3 | SO63128 | 2024-05-20 | 114.44 | 1481.94 | 1430.44 | |||
SO63128_4 | 9486-41CD-91 | PO18879146432 | 19 | 291 | 565 | 64 | 6 | 2024-05-25 | 890.82 | 22.27 | 2024-05-13 | 2 | 461.44 | 1 | 890.82 | 4 | SO63128 | 2024-05-20 | 71.27 | 922.89 | 445.41 | |||
SO63128_5 | 9486-41CD-91 | PO18879146432 | 19 | 291 | 568 | 64 | 6 | 2024-05-25 | 445.41 | 11.14 | 2024-05-13 | 1 | 461.44 | 1 | 445.41 | 5 | SO63128 | 2024-05-20 | 35.63 | 461.44 | 445.41 | |||
SO63128_6 | 9486-41CD-91 | PO18879146432 | 19 | 291 | 577 | 64 | 6 | 2024-05-25 | 1457.82 | 36.45 | 2024-05-13 | 2 | 755.15 | 1 | 1457.82 | 6 | SO63128 | 2024-05-20 | 116.63 | 1510.30 | 728.91 | |||
SO63128_7 | 9486-41CD-91 | PO18879146432 | 19 | 291 | 558 | 64 | 6 | 2024-05-25 | 728.98 | 18.22 | 2024-05-13 | 3 | 179.82 | 1 | 728.98 | 7 | SO63128 | 2024-05-20 | 58.32 | 539.45 | 242.99 | |||
SO63128_8 | 9486-41CD-91 | PO18879146432 | 19 | 291 | 574 | 64 | 6 | 2024-05-25 | 2860.88 | 71.52 | 2024-05-13 | 2 | 1481.94 | 1 | 2860.88 | 8 | SO63128 | 2024-05-20 | 228.87 | 2963.88 | 1430.44 | |||
SO63128_9 | 9486-41CD-91 | PO18879146432 | 19 | 291 | 560 | 64 | 6 | 2024-05-25 | 1457.82 | 36.45 | 2024-05-13 | 2 | 755.15 | 1 | 1457.82 | 9 | SO63128 | 2024-05-20 | 116.63 | 1510.30 | 728.91 | |||
SO63128_10 | 9486-41CD-91 | PO18879146432 | 19 | 291 | 573 | 64 | 6 | 2024-05-25 | 2860.88 | 71.52 | 2024-05-13 | 2 | 1481.94 | 1 | 2860.88 | 10 | SO63128 | 2024-05-20 | 228.87 | 2963.88 | 1430.44 | |||
SO63128_11 | 9486-41CD-91 | PO18879146432 | 19 | 291 | 570 | 64 | 6 | 2024-05-25 | 445.41 | 11.14 | 2024-05-13 | 1 | 461.44 | 1 | 445.41 | 11 | SO63128 | 2024-05-20 | 35.63 | 461.44 | 445.41 | |||
SO63128_12 | 9486-41CD-91 | PO18879146432 | 19 | 291 | 579 | 64 | 6 | 2024-05-25 | 728.91 | 18.22 | 2024-05-13 | 1 | 755.15 | 1 | 728.91 | 12 | SO63128 | 2024-05-20 | 58.31 | 755.15 | 728.91 | |||
SO63128_13 | 9486-41CD-91 | PO18879146432 | 19 | 291 | 555 | 64 | 6 | 2024-05-25 | 63.90 | 1.60 | 2024-05-13 | 1 | 47.29 | 1 | 63.90 | 13 | SO63128 | 2024-05-20 | 5.11 | 47.29 | 63.90 | |||
SO63128_14 | 9486-41CD-91 | PO18879146432 | 19 | 291 | 569 | 64 | 6 | 2024-05-25 | 890.82 | 22.27 | 2024-05-13 | 2 | 461.44 | 1 | 890.82 | 14 | SO63128 | 2024-05-20 | 71.27 | 922.89 | 445.41 | |||
SO63128_15 | 9486-41CD-91 | PO18879146432 | 19 | 291 | 585 | 64 | 6 | 2024-05-25 | 890.82 | 22.27 | 2024-05-13 | 2 | 461.44 | 1 | 890.82 | 15 | SO63128 | 2024-05-20 | 71.27 | 922.89 | 445.41 | |||
SO63128_16 | 9486-41CD-91 | PO18879146432 | 19 | 291 | 571 | 64 | 6 | 2024-05-25 | 1336.23 | 33.41 | 2024-05-13 | 3 | 461.44 | 1 | 1336.23 | 16 | SO63128 | 2024-05-20 | 106.90 | 1384.33 | 445.41 | |||
SO63128_17 | 9486-41CD-91 | PO18879146432 | 19 | 291 | 567 | 64 | 6 | 2024-05-25 | 445.41 | 11.14 | 2024-05-13 | 1 | 461.44 | 1 | 445.41 | 17 | SO63128 | 2024-05-20 | 35.63 | 461.44 | 445.41 | |||
SO63128_18 | 9486-41CD-91 | PO18879146432 | 19 | 291 | 578 | 64 | 6 | 2024-05-25 | 728.91 | 18.22 | 2024-05-13 | 1 | 755.15 | 1 | 728.91 | 18 | SO63128 | 2024-05-20 | 58.31 | 755.15 | 728.91 | |||
SO63128_19 | 9486-41CD-91 | PO18879146432 | 19 | 291 | 552 | 64 | 6 | 2024-05-25 | 109.79 | 2.74 | 2024-05-13 | 2 | 40.62 | 1 | 109.79 | 19 | SO63128 | 2024-05-20 | 8.78 | 81.24 | 54.89 | |||
SO63128_20 | 9486-41CD-91 | PO18879146432 | 19 | 291 | 559 | 64 | 6 | 2024-05-25 | 12.14 | 0.30 | 2024-05-13 | 1 | 8.99 | 1 | 12.14 | 20 | SO63128 | 2024-05-20 | 0.97 | 8.99 | 12.14 | |||
SO63132_1 | C9E0-492C-AA | PO18705140198 | 19 | 291 | 386 | 479 | 6 | 2024-05-25 | 2016.88 | 50.42 | 2024-05-13 | 3 | 713.08 | 1 | 2016.88 | 1 | SO63132 | 2024-05-20 | 161.35 | 2139.24 | 672.29 |
Generated 2024-11-11 00:45:04.836 UTC