[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 3678 > < TAKE 62 >
62 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO53476_1 | BF5A-472F-98 | PO16153121709 | 100 | 282 | 576 | 186 | 4 | 2023-12-27 | 4291.33 | 107.28 | 2023-12-15 | 3 | 1481.94 | 1 | 4291.33 | 1 | SO53476 | 2023-12-22 | 343.31 | 4445.81 | 1430.44 | |||
SO53476_2 | BF5A-472F-98 | PO16153121709 | 100 | 282 | 488 | 186 | 4 | 2023-12-27 | 32.39 | 0.81 | 2023-12-15 | 1 | 41.57 | 1 | 32.39 | 2 | SO53476 | 2023-12-22 | 2.59 | 41.57 | 32.39 | |||
SO53476_3 | BF5A-472F-98 | PO16153121709 | 100 | 282 | 552 | 186 | 4 | 2023-12-27 | 164.68 | 4.12 | 2023-12-15 | 3 | 40.62 | 1 | 164.68 | 3 | SO53476 | 2023-12-22 | 13.17 | 121.86 | 54.89 | |||
SO53476_4 | BF5A-472F-98 | PO16153121709 | 100 | 282 | 555 | 186 | 4 | 2023-12-27 | 127.80 | 3.20 | 2023-12-15 | 2 | 47.29 | 1 | 127.80 | 4 | SO53476 | 2023-12-22 | 10.22 | 94.57 | 63.90 | |||
SO53476_5 | BF5A-472F-98 | PO16153121709 | 100 | 282 | 561 | 14 | 186 | 4 | 190.73 | 2023-12-27 | 953.63 | 19.07 | 2023-12-15 | 1 | 1481.94 | 1 | 762.90 | 5 | SO53476 | 2023-12-22 | 61.03 | 1481.94 | 953.63 | 0.20 |
SO53476_6 | BF5A-472F-98 | PO16153121709 | 100 | 282 | 214 | 186 | 4 | 2023-12-27 | 20.99 | 0.52 | 2023-12-15 | 1 | 13.09 | 1 | 20.99 | 6 | SO53476 | 2023-12-22 | 1.68 | 13.09 | 20.99 | |||
SO53476_7 | BF5A-472F-98 | PO16153121709 | 100 | 282 | 586 | 13 | 186 | 4 | 100.22 | 2023-12-27 | 668.12 | 14.20 | 2023-12-15 | 2 | 461.44 | 1 | 567.90 | 7 | SO53476 | 2023-12-22 | 45.43 | 922.89 | 334.06 | 0.15 |
SO53476_8 | BF5A-472F-98 | PO16153121709 | 100 | 282 | 572 | 13 | 186 | 4 | 50.11 | 2023-12-27 | 334.06 | 7.10 | 2023-12-15 | 1 | 461.44 | 1 | 283.95 | 8 | SO53476 | 2023-12-22 | 22.72 | 461.44 | 334.06 | 0.15 |
SO53476_9 | BF5A-472F-98 | PO16153121709 | 100 | 282 | 569 | 13 | 186 | 4 | 50.11 | 2023-12-27 | 334.06 | 7.10 | 2023-12-15 | 1 | 461.44 | 1 | 283.95 | 9 | SO53476 | 2023-12-22 | 22.72 | 461.44 | 334.06 | 0.15 |
SO53476_10 | BF5A-472F-98 | PO16153121709 | 100 | 282 | 573 | 186 | 4 | 2023-12-27 | 1430.44 | 35.76 | 2023-12-15 | 1 | 1481.94 | 1 | 1430.44 | 10 | SO53476 | 2023-12-22 | 114.44 | 1481.94 | 1430.44 | |||
SO53476_11 | BF5A-472F-98 | PO16153121709 | 100 | 282 | 558 | 186 | 4 | 2023-12-27 | 242.99 | 6.07 | 2023-12-15 | 1 | 179.82 | 1 | 242.99 | 11 | SO53476 | 2023-12-22 | 19.44 | 179.82 | 242.99 | |||
SO53476_12 | BF5A-472F-98 | PO16153121709 | 100 | 282 | 579 | 186 | 4 | 2023-12-27 | 2915.64 | 72.89 | 2023-12-15 | 4 | 755.15 | 1 | 2915.64 | 12 | SO53476 | 2023-12-22 | 233.25 | 3020.60 | 728.91 | |||
SO53476_13 | BF5A-472F-98 | PO16153121709 | 100 | 282 | 564 | 14 | 186 | 4 | 190.73 | 2023-12-27 | 953.63 | 19.07 | 2023-12-15 | 1 | 1481.94 | 1 | 762.90 | 13 | SO53476 | 2023-12-22 | 61.03 | 1481.94 | 953.63 | 0.20 |
SO53476_14 | BF5A-472F-98 | PO16153121709 | 100 | 282 | 560 | 186 | 4 | 2023-12-27 | 728.91 | 18.22 | 2023-12-15 | 1 | 755.15 | 1 | 728.91 | 14 | SO53476 | 2023-12-22 | 58.31 | 755.15 | 728.91 | |||
SO53476_15 | BF5A-472F-98 | PO16153121709 | 100 | 282 | 568 | 13 | 186 | 4 | 50.11 | 2023-12-27 | 334.06 | 7.10 | 2023-12-15 | 1 | 461.44 | 1 | 283.95 | 15 | SO53476 | 2023-12-22 | 22.72 | 461.44 | 334.06 | 0.15 |
SO53476_16 | BF5A-472F-98 | PO16153121709 | 100 | 282 | 603 | 186 | 4 | 2023-12-27 | 218.68 | 5.47 | 2023-12-15 | 3 | 53.94 | 1 | 218.68 | 16 | SO53476 | 2023-12-22 | 17.49 | 161.82 | 72.89 | |||
SO53489_1 | 3391-4B55-9E | PO13804161202 | 100 | 281 | 562 | 14 | 202 | 4 | 381.45 | 2023-12-27 | 1907.26 | 38.15 | 2023-12-15 | 2 | 1481.94 | 1 | 1525.80 | 1 | SO53489 | 2023-12-22 | 122.06 | 2963.88 | 953.63 | 0.20 |
SO53490_1 | 48D0-4BD6-8A | PO13717132596 | 100 | 287 | 243 | 473 | 4 | 2023-12-27 | 858.90 | 21.47 | 2023-12-15 | 1 | 868.63 | 1 | 858.90 | 1 | SO53490 | 2023-12-22 | 68.71 | 868.63 | 858.90 | |||
SO53490_2 | 48D0-4BD6-8A | PO13717132596 | 100 | 287 | 520 | 473 | 4 | 2023-12-27 | 31.58 | 0.79 | 2023-12-15 | 1 | 23.37 | 1 | 31.58 | 2 | SO53490 | 2023-12-22 | 2.53 | 23.37 | 31.58 | |||
SO53490_3 | 48D0-4BD6-8A | PO13717132596 | 100 | 287 | 482 | 473 | 4 | 2023-12-27 | 16.18 | 0.40 | 2023-12-15 | 3 | 3.36 | 1 | 16.18 | 3 | SO53490 | 2023-12-22 | 1.29 | 10.09 | 5.39 | |||
SO53490_4 | 48D0-4BD6-8A | PO13717132596 | 100 | 287 | 240 | 473 | 4 | 2023-12-27 | 1717.80 | 42.95 | 2023-12-15 | 2 | 868.63 | 1 | 1717.80 | 4 | SO53490 | 2023-12-22 | 137.42 | 1737.27 | 858.90 | |||
SO53490_5 | 48D0-4BD6-8A | PO13717132596 | 100 | 287 | 440 | 473 | 4 | 2023-12-27 | 858.90 | 21.47 | 2023-12-15 | 1 | 868.63 | 1 | 858.90 | 5 | SO53490 | 2023-12-22 | 68.71 | 868.63 | 858.90 | |||
SO53491_1 | 7B63-436A-AF | PO13021164883 | 100 | 282 | 287 | 276 | 4 | 2023-12-27 | 202.33 | 5.06 | 2023-12-15 | 1 | 204.63 | 1 | 202.33 | 1 | SO53491 | 2023-12-22 | 16.19 | 204.63 | 202.33 | |||
SO53496_1 | 5404-4BB1-95 | PO12992153220 | 100 | 282 | 558 | 295 | 4 | 2023-12-27 | 242.99 | 6.07 | 2023-12-15 | 1 | 179.82 | 1 | 242.99 | 1 | SO53496 | 2023-12-22 | 19.44 | 179.82 | 242.99 | |||
SO53496_2 | 5404-4BB1-95 | PO12992153220 | 100 | 282 | 565 | 13 | 295 | 4 | 100.22 | 2023-12-27 | 668.12 | 14.20 | 2023-12-15 | 2 | 461.44 | 1 | 567.90 | 2 | SO53496 | 2023-12-22 | 45.43 | 922.89 | 334.06 | 0.15 |
SO53496_3 | 5404-4BB1-95 | PO12992153220 | 100 | 282 | 564 | 14 | 295 | 4 | 190.73 | 2023-12-27 | 953.63 | 19.07 | 2023-12-15 | 1 | 1481.94 | 1 | 762.90 | 3 | SO53496 | 2023-12-22 | 61.03 | 1481.94 | 953.63 | 0.20 |
SO53496_4 | 5404-4BB1-95 | PO12992153220 | 100 | 282 | 572 | 13 | 295 | 4 | 50.11 | 2023-12-27 | 334.06 | 7.10 | 2023-12-15 | 1 | 461.44 | 1 | 283.95 | 4 | SO53496 | 2023-12-22 | 22.72 | 461.44 | 334.06 | 0.15 |
SO53496_5 | 5404-4BB1-95 | PO12992153220 | 100 | 282 | 552 | 295 | 4 | 2023-12-27 | 109.79 | 2.74 | 2023-12-15 | 2 | 40.62 | 1 | 109.79 | 5 | SO53496 | 2023-12-22 | 8.78 | 81.24 | 54.89 | |||
SO53496_6 | 5404-4BB1-95 | PO12992153220 | 100 | 282 | 579 | 295 | 4 | 2023-12-27 | 728.91 | 18.22 | 2023-12-15 | 1 | 755.15 | 1 | 728.91 | 6 | SO53496 | 2023-12-22 | 58.31 | 755.15 | 728.91 | |||
SO53496_7 | 5404-4BB1-95 | PO12992153220 | 100 | 282 | 560 | 295 | 4 | 2023-12-27 | 728.91 | 18.22 | 2023-12-15 | 1 | 755.15 | 1 | 728.91 | 7 | SO53496 | 2023-12-22 | 58.31 | 755.15 | 728.91 | |||
SO53496_8 | 5404-4BB1-95 | PO12992153220 | 100 | 282 | 586 | 13 | 295 | 4 | 50.11 | 2023-12-27 | 334.06 | 7.10 | 2023-12-15 | 1 | 461.44 | 1 | 283.95 | 8 | SO53496 | 2023-12-22 | 22.72 | 461.44 | 334.06 | 0.15 |
SO53496_9 | 5404-4BB1-95 | PO12992153220 | 100 | 282 | 488 | 295 | 4 | 2023-12-27 | 32.39 | 0.81 | 2023-12-15 | 1 | 41.57 | 1 | 32.39 | 9 | SO53496 | 2023-12-22 | 2.59 | 41.57 | 32.39 | |||
SO53515_1 | 5B08-47B5-98 | PO348172261 | 100 | 282 | 404 | 609 | 4 | 2023-12-27 | 26.72 | 0.67 | 2023-12-15 | 1 | 19.78 | 1 | 26.72 | 1 | SO53515 | 2023-12-22 | 2.14 | 19.78 | 26.72 | |||
SO53517_1 | B483-4886-80 | PO725184057 | 100 | 281 | 551 | 291 | 4 | 2023-12-27 | 158.43 | 3.96 | 2023-12-15 | 1 | 144.59 | 1 | 158.43 | 1 | SO53517 | 2023-12-22 | 12.67 | 144.59 | 158.43 | |||
SO65232_16 | 3D4B-4E94-8F | PO9715132845 | 100 | 281 | 237 | 490 | 4 | 2024-06-26 | 29.99 | 0.75 | 2024-06-14 | 1 | 38.49 | 1 | 29.99 | 16 | SO65232 | 2024-06-21 | 2.40 | 38.49 | 29.99 | |||
SO65232_17 | 3D4B-4E94-8F | PO9715132845 | 100 | 281 | 552 | 490 | 4 | 2024-06-26 | 439.15 | 10.98 | 2024-06-14 | 8 | 40.62 | 1 | 439.15 | 17 | SO65232 | 2024-06-21 | 35.13 | 324.97 | 54.89 | |||
SO65232_18 | 3D4B-4E94-8F | PO9715132845 | 100 | 281 | 517 | 490 | 4 | 2024-06-26 | 63.17 | 1.58 | 2024-06-14 | 2 | 23.37 | 1 | 63.17 | 18 | SO65232 | 2024-06-21 | 5.05 | 46.74 | 31.58 | |||
SO65232_19 | 3D4B-4E94-8F | PO9715132845 | 100 | 281 | 516 | 490 | 4 | 2024-06-26 | 23.48 | 0.59 | 2024-06-14 | 1 | 17.38 | 1 | 23.48 | 19 | SO65232 | 2024-06-21 | 1.88 | 17.38 | 23.48 | |||
SO65232_20 | 3D4B-4E94-8F | PO9715132845 | 100 | 281 | 363 | 490 | 4 | 2024-06-26 | 4130.98 | 103.27 | 2024-06-14 | 3 | 1251.98 | 1 | 4130.98 | 20 | SO65232 | 2024-06-21 | 330.48 | 3755.94 | 1376.99 | |||
SO65232_21 | 3D4B-4E94-8F | PO9715132845 | 100 | 281 | 309 | 490 | 4 | 2024-06-26 | 1637.40 | 40.94 | 2024-06-14 | 2 | 747.20 | 1 | 1637.40 | 21 | SO65232 | 2024-06-21 | 130.99 | 1494.40 | 818.70 | |||
SO65232_22 | 3D4B-4E94-8F | PO9715132845 | 100 | 281 | 298 | 490 | 4 | 2024-06-26 | 1619.52 | 40.49 | 2024-06-14 | 2 | 739.04 | 1 | 1619.52 | 22 | SO65232 | 2024-06-21 | 129.56 | 1478.08 | 809.76 | |||
SO65232_23 | 3D4B-4E94-8F | PO9715132845 | 100 | 281 | 512 | 490 | 4 | 2024-06-26 | 655.36 | 16.38 | 2024-06-14 | 3 | 199.38 | 1 | 655.36 | 23 | SO65232 | 2024-06-21 | 52.43 | 598.13 | 218.45 | |||
SO65232_24 | 3D4B-4E94-8F | PO9715132845 | 100 | 281 | 357 | 490 | 4 | 2024-06-26 | 1391.99 | 34.80 | 2024-06-14 | 1 | 1265.62 | 1 | 1391.99 | 24 | SO65232 | 2024-06-21 | 111.36 | 1265.62 | 1391.99 | |||
SO65232_25 | 3D4B-4E94-8F | PO9715132845 | 100 | 281 | 476 | 2 | 490 | 4 | 9.74 | 2024-06-26 | 487.13 | 11.93 | 2024-06-14 | 12 | 26.18 | 1 | 477.39 | 25 | SO65232 | 2024-06-21 | 38.19 | 314.12 | 40.59 | 0.02 |
SO65232_26 | 3D4B-4E94-8F | PO9715132845 | 100 | 281 | 544 | 490 | 4 | 2024-06-26 | 194.38 | 4.86 | 2024-06-14 | 4 | 35.96 | 1 | 194.38 | 26 | SO65232 | 2024-06-21 | 15.55 | 143.84 | 48.59 | |||
SO65232_27 | 3D4B-4E94-8F | PO9715132845 | 100 | 281 | 527 | 490 | 4 | 2024-06-26 | 633.72 | 15.84 | 2024-06-14 | 4 | 144.59 | 1 | 633.72 | 27 | SO65232 | 2024-06-21 | 50.70 | 578.38 | 158.43 | |||
SO65232_28 | 3D4B-4E94-8F | PO9715132845 | 100 | 281 | 400 | 490 | 4 | 2024-06-26 | 148.61 | 3.72 | 2024-06-14 | 4 | 27.49 | 1 | 148.61 | 28 | SO65232 | 2024-06-21 | 11.89 | 109.97 | 37.15 | |||
SO65232_29 | 3D4B-4E94-8F | PO9715132845 | 100 | 281 | 474 | 490 | 4 | 2024-06-26 | 293.96 | 7.35 | 2024-06-14 | 7 | 26.18 | 1 | 293.96 | 29 | SO65232 | 2024-06-21 | 23.52 | 183.23 | 41.99 | |||
SO65232_30 | 3D4B-4E94-8F | PO9715132845 | 100 | 281 | 603 | 490 | 4 | 2024-06-26 | 218.68 | 5.47 | 2024-06-14 | 3 | 53.94 | 1 | 218.68 | 30 | SO65232 | 2024-06-21 | 17.49 | 161.82 | 72.89 | |||
SO65232_31 | 3D4B-4E94-8F | PO9715132845 | 100 | 281 | 359 | 490 | 4 | 2024-06-26 | 6884.97 | 172.12 | 2024-06-14 | 5 | 1251.98 | 1 | 6884.97 | 31 | SO65232 | 2024-06-21 | 550.80 | 6259.91 | 1376.99 | |||
SO65239_1 | 05CB-4E4A-AC | PO13717153710 | 100 | 287 | 483 | 473 | 4 | 2024-06-26 | 72.00 | 1.80 | 2024-06-14 | 1 | 44.88 | 1 | 72.00 | 1 | SO65239 | 2024-06-21 | 5.76 | 44.88 | 72.00 | |||
SO65239_2 | 05CB-4E4A-AC | PO13717153710 | 100 | 287 | 546 | 473 | 4 | 2024-06-26 | 37.25 | 0.93 | 2024-06-14 | 1 | 27.57 | 1 | 37.25 | 2 | SO65239 | 2024-06-21 | 2.98 | 27.57 | 37.25 | |||
SO65244_1 | 9913-4EA4-9F | PO12992138491 | 100 | 282 | 572 | 295 | 4 | 2024-06-26 | 445.41 | 11.14 | 2024-06-14 | 1 | 461.44 | 1 | 445.41 | 1 | SO65244 | 2024-06-21 | 35.63 | 461.44 | 445.41 | |||
SO65244_2 | 9913-4EA4-9F | PO12992138491 | 100 | 282 | 568 | 295 | 4 | 2024-06-26 | 890.82 | 22.27 | 2024-06-14 | 2 | 461.44 | 1 | 890.82 | 2 | SO65244 | 2024-06-21 | 71.27 | 922.89 | 445.41 | |||
SO65244_3 | 9913-4EA4-9F | PO12992138491 | 100 | 282 | 564 | 295 | 4 | 2024-06-26 | 1430.44 | 35.76 | 2024-06-14 | 1 | 1481.94 | 1 | 1430.44 | 3 | SO65244 | 2024-06-21 | 114.44 | 1481.94 | 1430.44 | |||
SO65244_4 | 9913-4EA4-9F | PO12992138491 | 100 | 282 | 560 | 295 | 4 | 2024-06-26 | 728.91 | 18.22 | 2024-06-14 | 1 | 755.15 | 1 | 728.91 | 4 | SO65244 | 2024-06-21 | 58.31 | 755.15 | 728.91 | |||
SO65244_5 | 9913-4EA4-9F | PO12992138491 | 100 | 282 | 576 | 295 | 4 | 2024-06-26 | 5721.77 | 143.04 | 2024-06-14 | 4 | 1481.94 | 1 | 5721.77 | 5 | SO65244 | 2024-06-21 | 457.74 | 5927.75 | 1430.44 | |||
SO65244_6 | 9913-4EA4-9F | PO12992138491 | 100 | 282 | 579 | 295 | 4 | 2024-06-26 | 728.91 | 18.22 | 2024-06-14 | 1 | 755.15 | 1 | 728.91 | 6 | SO65244 | 2024-06-21 | 58.31 | 755.15 | 728.91 | |||
SO65244_7 | 9913-4EA4-9F | PO12992138491 | 100 | 282 | 561 | 295 | 4 | 2024-06-26 | 1430.44 | 35.76 | 2024-06-14 | 1 | 1481.94 | 1 | 1430.44 | 7 | SO65244 | 2024-06-21 | 114.44 | 1481.94 | 1430.44 | |||
SO65266_1 | 4B49-46DB-97 | PO3944164136 | 100 | 281 | 523 | 112 | 4 | 2024-06-26 | 31.58 | 0.79 | 2024-06-14 | 1 | 23.37 | 1 | 31.58 | 1 | SO65266 | 2024-06-21 | 2.53 | 23.37 | 31.58 | |||
SO65269_1 | 999D-45C9-AA | PO4640162431 | 100 | 287 | 591 | 648 | 4 | 2024-06-26 | 338.99 | 8.47 | 2024-06-14 | 1 | 308.22 | 1 | 338.99 | 1 | SO65269 | 2024-06-21 | 27.12 | 308.22 | 338.99 | |||
SO65269_2 | 999D-45C9-AA | PO4640162431 | 100 | 287 | 596 | 648 | 4 | 2024-06-26 | 323.99 | 8.10 | 2024-06-14 | 1 | 294.58 | 1 | 323.99 | 2 | SO65269 | 2024-06-21 | 25.92 | 294.58 | 323.99 |
Generated 2024-11-13 05:11:11.768 UTC