[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > < SKIP 2419 > < TAKE 30 >
30 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49169_8 | 73B1-4F93-B6 | PO10121138908 | 100 | 283 | 323 | 684 | 2 | 2023-05-26 | 2818.76 | 70.47 | 2023-05-14 | 6 | 486.71 | 1 | 2818.76 | 8 | SO49169 | 2023-05-21 | 225.50 | 2920.24 | 469.79 |
SO49169_9 | 73B1-4F93-B6 | PO10121138908 | 100 | 283 | 286 | 684 | 2 | 2023-05-26 | 183.94 | 4.60 | 2023-05-14 | 1 | 170.14 | 1 | 183.94 | 9 | SO49169 | 2023-05-21 | 14.72 | 170.14 | 183.94 |
SO49169_10 | 73B1-4F93-B6 | PO10121138908 | 100 | 283 | 389 | 684 | 2 | 2023-05-26 | 600.26 | 15.01 | 2023-05-14 | 1 | 605.65 | 1 | 600.26 | 10 | SO49169 | 2023-05-21 | 48.02 | 605.65 | 600.26 |
SO49169_11 | 73B1-4F93-B6 | PO10121138908 | 100 | 283 | 333 | 684 | 2 | 2023-05-26 | 3758.35 | 93.96 | 2023-05-14 | 8 | 486.71 | 1 | 3758.35 | 11 | SO49169 | 2023-05-21 | 300.67 | 3893.65 | 469.79 |
SO49169_12 | 73B1-4F93-B6 | PO10121138908 | 100 | 283 | 422 | 684 | 2 | 2023-05-26 | 135.08 | 3.38 | 2023-05-14 | 2 | 49.98 | 1 | 135.08 | 12 | SO49169 | 2023-05-21 | 10.81 | 99.96 | 67.54 |
SO49169_13 | 73B1-4F93-B6 | PO10121138908 | 100 | 283 | 331 | 684 | 2 | 2023-05-26 | 939.59 | 23.49 | 2023-05-14 | 2 | 486.71 | 1 | 939.59 | 13 | SO49169 | 2023-05-21 | 75.17 | 973.41 | 469.79 |
SO49169_14 | 73B1-4F93-B6 | PO10121138908 | 100 | 283 | 417 | 684 | 2 | 2023-05-26 | 324.45 | 8.11 | 2023-05-14 | 1 | 300.12 | 1 | 324.45 | 14 | SO49169 | 2023-05-21 | 25.96 | 300.12 | 324.45 |
SO49169_15 | 73B1-4F93-B6 | PO10121138908 | 100 | 283 | 254 | 684 | 2 | 2023-05-26 | 183.94 | 4.60 | 2023-05-14 | 1 | 170.14 | 1 | 183.94 | 15 | SO49169 | 2023-05-21 | 14.72 | 170.14 | 183.94 |
SO49169_16 | 73B1-4F93-B6 | PO10121138908 | 100 | 283 | 433 | 684 | 2 | 2023-05-26 | 648.91 | 16.22 | 2023-05-14 | 2 | 300.12 | 1 | 648.91 | 16 | SO49169 | 2023-05-21 | 51.91 | 600.24 | 324.45 |
SO49169_17 | 73B1-4F93-B6 | PO10121138908 | 100 | 283 | 415 | 684 | 2 | 2023-05-26 | 198.04 | 4.95 | 2023-05-14 | 1 | 146.55 | 1 | 198.04 | 17 | SO49169 | 2023-05-21 | 15.84 | 146.55 | 198.04 |
SO49169_18 | 73B1-4F93-B6 | PO10121138908 | 100 | 283 | 325 | 684 | 2 | 2023-05-26 | 3288.56 | 82.21 | 2023-05-14 | 7 | 486.71 | 1 | 3288.56 | 18 | SO49169 | 2023-05-21 | 263.08 | 3406.95 | 469.79 |
SO49169_19 | 73B1-4F93-B6 | PO10121138908 | 100 | 283 | 373 | 684 | 2 | 2023-05-26 | 5235.75 | 130.89 | 2023-05-14 | 4 | 1320.68 | 1 | 5235.75 | 19 | SO49169 | 2023-05-21 | 418.86 | 5282.74 | 1308.94 |
SO49169_20 | 73B1-4F93-B6 | PO10121138908 | 100 | 283 | 335 | 684 | 2 | 2023-05-26 | 469.79 | 11.74 | 2023-05-14 | 1 | 486.71 | 1 | 469.79 | 20 | SO49169 | 2023-05-21 | 37.58 | 486.71 | 469.79 |
SO63125_4 | F7DD-4FA0-B5 | PO18792150789 | 100 | 283 | 556 | 378 | 2 | 2024-05-25 | 315.88 | 7.90 | 2024-05-13 | 3 | 77.92 | 1 | 315.88 | 4 | SO63125 | 2024-05-20 | 25.27 | 233.75 | 105.29 |
SO63125_5 | F7DD-4FA0-B5 | PO18792150789 | 100 | 283 | 551 | 378 | 2 | 2024-05-25 | 158.43 | 3.96 | 2024-05-13 | 1 | 144.59 | 1 | 158.43 | 5 | SO63125 | 2024-05-20 | 12.67 | 144.59 | 158.43 |
SO63125_6 | F7DD-4FA0-B5 | PO18792150789 | 100 | 283 | 531 | 378 | 2 | 2024-05-25 | 299.75 | 7.49 | 2024-05-13 | 2 | 136.79 | 1 | 299.75 | 6 | SO63125 | 2024-05-20 | 23.98 | 273.57 | 149.87 |
SO63125_7 | F7DD-4FA0-B5 | PO18792150789 | 100 | 283 | 603 | 378 | 2 | 2024-05-25 | 72.89 | 1.82 | 2024-05-13 | 1 | 53.94 | 1 | 72.89 | 7 | SO63125 | 2024-05-20 | 5.83 | 53.94 | 72.89 |
SO63125_8 | F7DD-4FA0-B5 | PO18792150789 | 100 | 283 | 527 | 378 | 2 | 2024-05-25 | 475.29 | 11.88 | 2024-05-13 | 3 | 144.59 | 1 | 475.29 | 8 | SO63125 | 2024-05-20 | 38.02 | 433.78 | 158.43 |
SO63125_9 | F7DD-4FA0-B5 | PO18792150789 | 100 | 283 | 595 | 378 | 2 | 2024-05-25 | 338.99 | 8.47 | 2024-05-13 | 1 | 308.22 | 1 | 338.99 | 9 | SO63125 | 2024-05-20 | 27.12 | 308.22 | 338.99 |
SO63125_10 | F7DD-4FA0-B5 | PO18792150789 | 100 | 283 | 306 | 378 | 2 | 2024-05-25 | 2429.28 | 60.73 | 2024-05-13 | 3 | 739.04 | 1 | 2429.28 | 10 | SO63125 | 2024-05-20 | 194.34 | 2217.12 | 809.76 |
SO63135_1 | 858A-401E-AA | PO18386124171 | 100 | 283 | 222 | 558 | 2 | 2024-05-25 | 62.98 | 1.57 | 2024-05-13 | 3 | 13.09 | 1 | 62.98 | 1 | SO63135 | 2024-05-20 | 5.04 | 39.26 | 20.99 |
SO63135_2 | 858A-401E-AA | PO18386124171 | 100 | 283 | 546 | 558 | 2 | 2024-05-25 | 37.25 | 0.93 | 2024-05-13 | 1 | 27.57 | 1 | 37.25 | 2 | SO63135 | 2024-05-20 | 2.98 | 27.57 | 37.25 |
SO63135_3 | 858A-401E-AA | PO18386124171 | 100 | 283 | 547 | 558 | 2 | 2024-05-25 | 97.19 | 2.43 | 2024-05-13 | 2 | 35.96 | 1 | 97.19 | 3 | SO63135 | 2024-05-20 | 7.78 | 71.92 | 48.59 |
SO63135_4 | 858A-401E-AA | PO18386124171 | 100 | 283 | 374 | 558 | 2 | 2024-05-25 | 1466.01 | 36.65 | 2024-05-13 | 1 | 1554.95 | 1 | 1466.01 | 4 | SO63135 | 2024-05-20 | 117.28 | 1554.95 | 1466.01 |
SO63137_1 | 269D-49DF-89 | PO18183116686 | 100 | 283 | 511 | 667 | 2 | 2024-05-25 | 218.45 | 5.46 | 2024-05-13 | 1 | 199.38 | 1 | 218.45 | 1 | SO63137 | 2024-05-20 | 17.48 | 199.38 | 218.45 |
SO63137_2 | 269D-49DF-89 | PO18183116686 | 100 | 283 | 474 | 667 | 2 | 2024-05-25 | 419.94 | 10.50 | 2024-05-13 | 10 | 26.18 | 1 | 419.94 | 2 | SO63137 | 2024-05-20 | 33.60 | 261.76 | 41.99 |
SO63137_3 | 269D-49DF-89 | PO18183116686 | 100 | 283 | 475 | 667 | 2 | 2024-05-25 | 83.99 | 2.10 | 2024-05-13 | 2 | 26.18 | 1 | 83.99 | 3 | SO63137 | 2024-05-20 | 6.72 | 52.35 | 41.99 |
SO63137_4 | 269D-49DF-89 | PO18183116686 | 100 | 283 | 524 | 667 | 2 | 2024-05-25 | 158.43 | 3.96 | 2024-05-13 | 1 | 144.59 | 1 | 158.43 | 4 | SO63137 | 2024-05-20 | 12.67 | 144.59 | 158.43 |
SO63147_1 | B44E-4B02-B5 | PO16791114018 | 100 | 283 | 545 | 36 | 2 | 2024-05-25 | 48.59 | 1.21 | 2024-05-13 | 2 | 17.98 | 1 | 48.59 | 1 | SO63147 | 2024-05-20 | 3.89 | 35.96 | 24.29 |
SO63163_1 | F62A-48E2-BB | PO12383112537 | 100 | 283 | 481 | 89 | 2 | 2024-05-25 | 10.79 | 0.27 | 2024-05-13 | 2 | 3.36 | 1 | 10.79 | 1 | SO63163 | 2024-05-20 | 0.86 | 6.72 | 5.39 |
Generated 2024-11-11 02:25:48.285 UTC