[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '9' > < SKIP 623 > < TAKE 48 >
48 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO61235_2 | CFAF-4A60-86 | PO8004115760 | 6 | 296 | 568 | 231 | 9 | 2024-03-05 | 445.41 | 11.14 | 2024-02-22 | 1 | 461.44 | 1 | 445.41 | 2 | SO61235 | 2024-02-29 | 35.63 | 461.44 | 445.41 |
SO61235_3 | CFAF-4A60-86 | PO8004115760 | 6 | 296 | 571 | 231 | 9 | 2024-03-05 | 890.82 | 22.27 | 2024-02-22 | 2 | 461.44 | 1 | 890.82 | 3 | SO61235 | 2024-02-29 | 71.27 | 922.89 | 445.41 |
SO61235_4 | CFAF-4A60-86 | PO8004115760 | 6 | 296 | 566 | 231 | 9 | 2024-03-05 | 445.41 | 11.14 | 2024-02-22 | 1 | 461.44 | 1 | 445.41 | 4 | SO61235 | 2024-02-29 | 35.63 | 461.44 | 445.41 |
SO61235_5 | CFAF-4A60-86 | PO8004115760 | 6 | 296 | 561 | 231 | 9 | 2024-03-05 | 1430.44 | 35.76 | 2024-02-22 | 1 | 1481.94 | 1 | 1430.44 | 5 | SO61235 | 2024-02-29 | 114.44 | 1481.94 | 1430.44 |
SO61235_6 | CFAF-4A60-86 | PO8004115760 | 6 | 296 | 576 | 231 | 9 | 2024-03-05 | 5721.77 | 143.04 | 2024-02-22 | 4 | 1481.94 | 1 | 5721.77 | 6 | SO61235 | 2024-02-29 | 457.74 | 5927.75 | 1430.44 |
SO61235_7 | CFAF-4A60-86 | PO8004115760 | 6 | 296 | 572 | 231 | 9 | 2024-03-05 | 445.41 | 11.14 | 2024-02-22 | 1 | 461.44 | 1 | 445.41 | 7 | SO61235 | 2024-02-29 | 35.63 | 461.44 | 445.41 |
SO61235_8 | CFAF-4A60-86 | PO8004115760 | 6 | 296 | 586 | 231 | 9 | 2024-03-05 | 445.41 | 11.14 | 2024-02-22 | 1 | 461.44 | 1 | 445.41 | 8 | SO61235 | 2024-02-29 | 35.63 | 461.44 | 445.41 |
SO61235_9 | CFAF-4A60-86 | PO8004115760 | 6 | 296 | 562 | 231 | 9 | 2024-03-05 | 4291.33 | 107.28 | 2024-02-22 | 3 | 1481.94 | 1 | 4291.33 | 9 | SO61235 | 2024-02-29 | 343.31 | 4445.81 | 1430.44 |
SO61235_10 | CFAF-4A60-86 | PO8004115760 | 6 | 296 | 570 | 231 | 9 | 2024-03-05 | 1336.23 | 33.41 | 2024-02-22 | 3 | 461.44 | 1 | 1336.23 | 10 | SO61235 | 2024-02-29 | 106.90 | 1384.33 | 445.41 |
SO61235_11 | CFAF-4A60-86 | PO8004115760 | 6 | 296 | 575 | 231 | 9 | 2024-03-05 | 1430.44 | 35.76 | 2024-02-22 | 1 | 1481.94 | 1 | 1430.44 | 11 | SO61235 | 2024-02-29 | 114.44 | 1481.94 | 1430.44 |
SO61235_12 | CFAF-4A60-86 | PO8004115760 | 6 | 296 | 558 | 231 | 9 | 2024-03-05 | 485.99 | 12.15 | 2024-02-22 | 2 | 179.82 | 1 | 485.99 | 12 | SO61235 | 2024-02-29 | 38.88 | 359.63 | 242.99 |
SO61235_13 | CFAF-4A60-86 | PO8004115760 | 6 | 296 | 577 | 231 | 9 | 2024-03-05 | 728.91 | 18.22 | 2024-02-22 | 1 | 755.15 | 1 | 728.91 | 13 | SO61235 | 2024-02-29 | 58.31 | 755.15 | 728.91 |
SO61235_14 | CFAF-4A60-86 | PO8004115760 | 6 | 296 | 569 | 231 | 9 | 2024-03-05 | 890.82 | 22.27 | 2024-02-22 | 2 | 461.44 | 1 | 890.82 | 14 | SO61235 | 2024-02-29 | 71.27 | 922.89 | 445.41 |
SO61235_15 | CFAF-4A60-86 | PO8004115760 | 6 | 296 | 567 | 231 | 9 | 2024-03-05 | 1336.23 | 33.41 | 2024-02-22 | 3 | 461.44 | 1 | 1336.23 | 15 | SO61235 | 2024-02-29 | 106.90 | 1384.33 | 445.41 |
SO61235_16 | CFAF-4A60-86 | PO8004115760 | 6 | 296 | 564 | 231 | 9 | 2024-03-05 | 2860.88 | 71.52 | 2024-02-22 | 2 | 1481.94 | 1 | 2860.88 | 16 | SO61235 | 2024-02-29 | 228.87 | 2963.88 | 1430.44 |
SO61235_17 | CFAF-4A60-86 | PO8004115760 | 6 | 296 | 574 | 231 | 9 | 2024-03-05 | 1430.44 | 35.76 | 2024-02-22 | 1 | 1481.94 | 1 | 1430.44 | 17 | SO61235 | 2024-02-29 | 114.44 | 1481.94 | 1430.44 |
SO61235_18 | CFAF-4A60-86 | PO8004115760 | 6 | 296 | 578 | 231 | 9 | 2024-03-05 | 1457.82 | 36.45 | 2024-02-22 | 2 | 755.15 | 1 | 1457.82 | 18 | SO61235 | 2024-02-29 | 116.63 | 1510.30 | 728.91 |
SO61235_19 | CFAF-4A60-86 | PO8004115760 | 6 | 296 | 563 | 231 | 9 | 2024-03-05 | 2860.88 | 71.52 | 2024-02-22 | 2 | 1481.94 | 1 | 2860.88 | 19 | SO61235 | 2024-02-29 | 228.87 | 2963.88 | 1430.44 |
SO61235_20 | CFAF-4A60-86 | PO8004115760 | 6 | 296 | 552 | 231 | 9 | 2024-03-05 | 54.89 | 1.37 | 2024-02-22 | 1 | 40.62 | 1 | 54.89 | 20 | SO61235 | 2024-02-29 | 4.39 | 40.62 | 54.89 |
SO61237_1 | EC07-40EA-97 | PO6032191923 | 6 | 296 | 569 | 177 | 9 | 2024-03-05 | 1336.23 | 33.41 | 2024-02-22 | 3 | 461.44 | 1 | 1336.23 | 1 | SO61237 | 2024-02-29 | 106.90 | 1384.33 | 445.41 |
SO61237_2 | EC07-40EA-97 | PO6032191923 | 6 | 296 | 576 | 177 | 9 | 2024-03-05 | 1430.44 | 35.76 | 2024-02-22 | 1 | 1481.94 | 1 | 1430.44 | 2 | SO61237 | 2024-02-29 | 114.44 | 1481.94 | 1430.44 |
SO61237_3 | EC07-40EA-97 | PO6032191923 | 6 | 296 | 560 | 177 | 9 | 2024-03-05 | 1457.82 | 36.45 | 2024-02-22 | 2 | 755.15 | 1 | 1457.82 | 3 | SO61237 | 2024-02-29 | 116.63 | 1510.30 | 728.91 |
SO61237_4 | EC07-40EA-97 | PO6032191923 | 6 | 296 | 565 | 177 | 9 | 2024-03-05 | 890.82 | 22.27 | 2024-02-22 | 2 | 461.44 | 1 | 890.82 | 4 | SO61237 | 2024-02-29 | 71.27 | 922.89 | 445.41 |
SO61245_1 | 1F74-445F-93 | PO9367166470 | 6 | 294 | 571 | 664 | 9 | 2024-03-05 | 445.41 | 11.14 | 2024-02-22 | 1 | 461.44 | 1 | 445.41 | 1 | SO61245 | 2024-02-29 | 35.63 | 461.44 | 445.41 |
SO63145_1 | 77C8-41B8-A1 | PO16820152305 | 6 | 296 | 579 | 213 | 9 | 2024-04-05 | 1457.82 | 36.45 | 2024-03-24 | 2 | 755.15 | 1 | 1457.82 | 1 | SO63145 | 2024-03-31 | 116.63 | 1510.30 | 728.91 |
SO63145_2 | 77C8-41B8-A1 | PO16820152305 | 6 | 296 | 572 | 213 | 9 | 2024-04-05 | 445.41 | 11.14 | 2024-03-24 | 1 | 461.44 | 1 | 445.41 | 2 | SO63145 | 2024-03-31 | 35.63 | 461.44 | 445.41 |
SO63145_3 | 77C8-41B8-A1 | PO16820152305 | 6 | 296 | 560 | 213 | 9 | 2024-04-05 | 1457.82 | 36.45 | 2024-03-24 | 2 | 755.15 | 1 | 1457.82 | 3 | SO63145 | 2024-03-31 | 116.63 | 1510.30 | 728.91 |
SO63145_4 | 77C8-41B8-A1 | PO16820152305 | 6 | 296 | 573 | 213 | 9 | 2024-04-05 | 2860.88 | 71.52 | 2024-03-24 | 2 | 1481.94 | 1 | 2860.88 | 4 | SO63145 | 2024-03-31 | 228.87 | 2963.88 | 1430.44 |
SO63145_5 | 77C8-41B8-A1 | PO16820152305 | 6 | 296 | 471 | 213 | 9 | 2024-04-05 | 114.30 | 2.86 | 2024-03-24 | 3 | 23.75 | 1 | 114.30 | 5 | SO63145 | 2024-03-31 | 9.14 | 71.25 | 38.10 |
SO63145_6 | 77C8-41B8-A1 | PO16820152305 | 6 | 296 | 564 | 213 | 9 | 2024-04-05 | 2860.88 | 71.52 | 2024-03-24 | 2 | 1481.94 | 1 | 2860.88 | 6 | SO63145 | 2024-03-31 | 228.87 | 2963.88 | 1430.44 |
SO63145_7 | 77C8-41B8-A1 | PO16820152305 | 6 | 296 | 561 | 213 | 9 | 2024-04-05 | 2860.88 | 71.52 | 2024-03-24 | 2 | 1481.94 | 1 | 2860.88 | 7 | SO63145 | 2024-03-31 | 228.87 | 2963.88 | 1430.44 |
SO63164_1 | 0AAA-4E44-B2 | PO12064198233 | 6 | 296 | 579 | 159 | 9 | 2024-04-05 | 1457.82 | 36.45 | 2024-03-24 | 2 | 755.15 | 1 | 1457.82 | 1 | SO63164 | 2024-03-31 | 116.63 | 1510.30 | 728.91 |
SO63164_2 | 0AAA-4E44-B2 | PO12064198233 | 6 | 296 | 576 | 159 | 9 | 2024-04-05 | 1430.44 | 35.76 | 2024-03-24 | 1 | 1481.94 | 1 | 1430.44 | 2 | SO63164 | 2024-03-31 | 114.44 | 1481.94 | 1430.44 |
SO63203_1 | A519-4FDF-86 | PO12209121100 | 6 | 294 | 363 | 411 | 9 | 2024-04-05 | 1376.99 | 34.42 | 2024-03-24 | 1 | 1251.98 | 1 | 1376.99 | 1 | SO63203 | 2024-03-31 | 110.16 | 1251.98 | 1376.99 |
SO63222_1 | BC72-4C6D-81 | PO7801190094 | 6 | 296 | 225 | 87 | 9 | 2024-04-05 | 5.39 | 0.13 | 2024-03-24 | 1 | 6.92 | 1 | 5.39 | 1 | SO63222 | 2024-03-31 | 0.43 | 6.92 | 5.39 |
SO63222_2 | BC72-4C6D-81 | PO7801190094 | 6 | 296 | 492 | 87 | 9 | 2024-04-05 | 1204.69 | 30.12 | 2024-03-24 | 2 | 601.74 | 1 | 1204.69 | 2 | SO63222 | 2024-03-31 | 96.38 | 1203.49 | 602.35 |
SO63222_3 | BC72-4C6D-81 | PO7801190094 | 6 | 296 | 576 | 87 | 9 | 2024-04-05 | 2860.88 | 71.52 | 2024-03-24 | 2 | 1481.94 | 1 | 2860.88 | 3 | SO63222 | 2024-03-31 | 228.87 | 2963.88 | 1430.44 |
SO63222_4 | BC72-4C6D-81 | PO7801190094 | 6 | 296 | 574 | 87 | 9 | 2024-04-05 | 1430.44 | 35.76 | 2024-03-24 | 1 | 1481.94 | 1 | 1430.44 | 4 | SO63222 | 2024-03-31 | 114.44 | 1481.94 | 1430.44 |
SO63222_5 | BC72-4C6D-81 | PO7801190094 | 6 | 296 | 562 | 87 | 9 | 2024-04-05 | 1430.44 | 35.76 | 2024-03-24 | 1 | 1481.94 | 1 | 1430.44 | 5 | SO63222 | 2024-03-31 | 114.44 | 1481.94 | 1430.44 |
SO63222_6 | BC72-4C6D-81 | PO7801190094 | 6 | 296 | 496 | 87 | 9 | 2024-04-05 | 602.35 | 15.06 | 2024-03-24 | 1 | 601.74 | 1 | 602.35 | 6 | SO63222 | 2024-03-31 | 48.19 | 601.74 | 602.35 |
SO63222_7 | BC72-4C6D-81 | PO7801190094 | 6 | 296 | 561 | 87 | 9 | 2024-04-05 | 2860.88 | 71.52 | 2024-03-24 | 2 | 1481.94 | 1 | 2860.88 | 7 | SO63222 | 2024-03-31 | 228.87 | 2963.88 | 1430.44 |
SO63222_8 | BC72-4C6D-81 | PO7801190094 | 6 | 296 | 506 | 87 | 9 | 2024-04-05 | 600.16 | 15.00 | 2024-03-24 | 3 | 199.85 | 1 | 600.16 | 8 | SO63222 | 2024-03-31 | 48.01 | 599.56 | 200.05 |
SO63222_9 | BC72-4C6D-81 | PO7801190094 | 6 | 296 | 566 | 87 | 9 | 2024-04-05 | 445.41 | 11.14 | 2024-03-24 | 1 | 461.44 | 1 | 445.41 | 9 | SO63222 | 2024-03-31 | 35.63 | 461.44 | 445.41 |
SO63222_10 | BC72-4C6D-81 | PO7801190094 | 6 | 296 | 568 | 87 | 9 | 2024-04-05 | 445.41 | 11.14 | 2024-03-24 | 1 | 461.44 | 1 | 445.41 | 10 | SO63222 | 2024-03-31 | 35.63 | 461.44 | 445.41 |
SO63222_11 | BC72-4C6D-81 | PO7801190094 | 6 | 296 | 573 | 87 | 9 | 2024-04-05 | 1430.44 | 35.76 | 2024-03-24 | 1 | 1481.94 | 1 | 1430.44 | 11 | SO63222 | 2024-03-31 | 114.44 | 1481.94 | 1430.44 |
SO63222_12 | BC72-4C6D-81 | PO7801190094 | 6 | 296 | 500 | 87 | 9 | 2024-04-05 | 602.35 | 15.06 | 2024-03-24 | 1 | 601.74 | 1 | 602.35 | 12 | SO63222 | 2024-03-31 | 48.19 | 601.74 | 602.35 |
SO63222_13 | BC72-4C6D-81 | PO7801190094 | 6 | 296 | 523 | 87 | 9 | 2024-04-05 | 63.17 | 1.58 | 2024-03-24 | 2 | 23.37 | 1 | 63.17 | 13 | SO63222 | 2024-03-31 | 5.05 | 46.74 | 31.58 |
SO63222_14 | BC72-4C6D-81 | PO7801190094 | 6 | 296 | 499 | 87 | 9 | 2024-04-05 | 3011.73 | 75.29 | 2024-03-24 | 5 | 601.74 | 1 | 3011.73 | 14 | SO63222 | 2024-03-31 | 240.94 | 3008.72 | 602.35 |
Generated 2024-09-21 07:36:09.367 UTC