[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 2811 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45317_21 | 92DD-46A2-8D | PO2523164373 | 100 | 272 | 313 | 167 | 4 | 2022-05-30 | 12881.77 | 322.04 | 2022-05-18 | 6 | 2171.29 | 1 | 12881.77 | 21 | SO45317 | 2022-05-25 | 1030.54 | 13027.77 | 2146.96 |
SO48048_26 | B414-46CB-BA | PO3480117933 | 100 | 283 | 435 | 436 | 4 | 2023-02-27 | 973.36 | 24.33 | 2023-02-15 | 3 | 300.12 | 1 | 973.36 | 26 | SO48048 | 2023-02-22 | 77.87 | 900.36 | 324.45 |
SO51845_17 | 6AB8-4CEA-A9 | PO3799111961 | 100 | 282 | 298 | 312 | 4 | 2023-11-27 | 809.76 | 20.24 | 2023-11-15 | 1 | 739.04 | 1 | 809.76 | 17 | SO51845 | 2023-11-22 | 64.78 | 739.04 | 809.76 |
SO45317_22 | 92DD-46A2-8D | PO2523164373 | 100 | 272 | 314 | 167 | 4 | 2022-05-30 | 10734.81 | 268.37 | 2022-05-18 | 5 | 2171.29 | 1 | 10734.81 | 22 | SO45317 | 2022-05-25 | 858.78 | 10856.47 | 2146.96 |
SO48048_27 | B414-46CB-BA | PO3480117933 | 100 | 283 | 447 | 436 | 4 | 2023-02-27 | 45.00 | 1.13 | 2023-02-15 | 3 | 10.31 | 1 | 45.00 | 27 | SO48048 | 2023-02-22 | 3.60 | 30.94 | 15.00 |
SO51845_18 | 6AB8-4CEA-A9 | PO3799111961 | 100 | 282 | 231 | 312 | 4 | 2023-11-27 | 119.98 | 3.00 | 2023-11-15 | 4 | 38.49 | 1 | 119.98 | 18 | SO51845 | 2023-11-22 | 9.60 | 153.97 | 29.99 |
SO45321_1 | C4E4-4F04-B1 | PO3799119166 | 100 | 282 | 232 | 312 | 4 | 2022-05-30 | 144.20 | 3.61 | 2022-05-18 | 5 | 31.72 | 1 | 144.20 | 1 | SO45321 | 2022-05-25 | 11.54 | 158.62 | 28.84 |
SO48048_28 | B414-46CB-BA | PO3480117933 | 100 | 283 | 216 | 436 | 4 | 2023-02-27 | 60.56 | 1.51 | 2023-02-15 | 3 | 13.88 | 1 | 60.56 | 28 | SO48048 | 2023-02-22 | 4.84 | 41.63 | 20.19 |
SO51845_19 | 6AB8-4CEA-A9 | PO3799111961 | 100 | 282 | 592 | 312 | 4 | 2023-11-27 | 1016.98 | 25.42 | 2023-11-15 | 3 | 308.22 | 1 | 1016.98 | 19 | SO51845 | 2023-11-22 | 81.36 | 924.65 | 338.99 |
SO45321_2 | C4E4-4F04-B1 | PO3799119166 | 100 | 282 | 351 | 312 | 4 | 2022-05-30 | 2024.99 | 50.62 | 2022-05-18 | 1 | 1898.09 | 1 | 2024.99 | 2 | SO45321 | 2022-05-25 | 162.00 | 1898.09 | 2024.99 |
SO48048_29 | B414-46CB-BA | PO3480117933 | 100 | 283 | 371 | 436 | 4 | 2023-02-27 | 6544.69 | 163.62 | 2023-02-15 | 5 | 1320.68 | 1 | 6544.69 | 29 | SO48048 | 2023-02-22 | 523.58 | 6603.42 | 1308.94 |
SO51845_20 | 6AB8-4CEA-A9 | PO3799111961 | 100 | 282 | 595 | 312 | 4 | 2023-11-27 | 338.99 | 8.47 | 2023-11-15 | 1 | 308.22 | 1 | 338.99 | 20 | SO51845 | 2023-11-22 | 27.12 | 308.22 | 338.99 |
SO45321_3 | C4E4-4F04-B1 | PO3799119166 | 100 | 282 | 350 | 312 | 4 | 2022-05-30 | 10124.97 | 253.12 | 2022-05-18 | 5 | 1898.09 | 1 | 10124.97 | 3 | SO45321 | 2022-05-25 | 810.00 | 9490.47 | 2024.99 |
SO48048_30 | B414-46CB-BA | PO3480117933 | 100 | 283 | 458 | 436 | 4 | 2023-02-27 | 224.97 | 5.62 | 2023-02-15 | 5 | 30.93 | 1 | 224.97 | 30 | SO48048 | 2023-02-22 | 18.00 | 154.67 | 44.99 |
SO51845_21 | 6AB8-4CEA-A9 | PO3799111961 | 100 | 282 | 593 | 312 | 4 | 2023-11-27 | 338.99 | 8.47 | 2023-11-15 | 1 | 308.22 | 1 | 338.99 | 21 | SO51845 | 2023-11-22 | 27.12 | 308.22 | 338.99 |
SO45321_4 | C4E4-4F04-B1 | PO3799119166 | 100 | 282 | 344 | 312 | 4 | 2022-05-30 | 8159.98 | 204.00 | 2022-05-18 | 4 | 1912.15 | 1 | 8159.98 | 4 | SO45321 | 2022-05-25 | 652.80 | 7648.62 | 2039.99 |
SO48048_31 | B414-46CB-BA | PO3480117933 | 100 | 283 | 415 | 436 | 4 | 2023-02-27 | 1188.22 | 29.71 | 2023-02-15 | 6 | 146.55 | 1 | 1188.22 | 31 | SO48048 | 2023-02-22 | 95.06 | 879.28 | 198.04 |
SO51845_22 | 6AB8-4CEA-A9 | PO3799111961 | 100 | 282 | 234 | 312 | 4 | 2023-11-27 | 269.95 | 6.75 | 2023-11-15 | 9 | 38.49 | 1 | 269.95 | 22 | SO51845 | 2023-11-22 | 21.60 | 346.43 | 29.99 |
SO45321_5 | C4E4-4F04-B1 | PO3799119166 | 100 | 282 | 349 | 312 | 4 | 2022-05-30 | 12149.96 | 303.75 | 2022-05-18 | 6 | 1898.09 | 1 | 12149.96 | 5 | SO45321 | 2022-05-25 | 972.00 | 11388.57 | 2024.99 |
SO48048_32 | B414-46CB-BA | PO3480117933 | 100 | 283 | 331 | 436 | 4 | 2023-02-27 | 2348.97 | 58.72 | 2023-02-15 | 5 | 486.71 | 1 | 2348.97 | 32 | SO48048 | 2023-02-22 | 187.92 | 2433.53 | 469.79 |
SO51845_23 | 6AB8-4CEA-A9 | PO3799111961 | 100 | 282 | 551 | 312 | 4 | 2023-11-27 | 158.43 | 3.96 | 2023-11-15 | 1 | 144.59 | 1 | 158.43 | 23 | SO51845 | 2023-11-22 | 12.67 | 144.59 | 158.43 |
SO45321_6 | C4E4-4F04-B1 | PO3799119166 | 100 | 282 | 223 | 312 | 4 | 2022-05-30 | 20.75 | 0.52 | 2022-05-18 | 4 | 5.71 | 1 | 20.75 | 6 | SO45321 | 2022-05-25 | 1.66 | 22.82 | 5.19 |
SO48048_33 | B414-46CB-BA | PO3480117933 | 100 | 283 | 407 | 436 | 4 | 2023-02-27 | 328.01 | 8.20 | 2023-02-15 | 5 | 48.55 | 1 | 328.01 | 33 | SO48048 | 2023-02-22 | 26.24 | 242.73 | 65.60 |
SO51845_24 | 6AB8-4CEA-A9 | PO3799111961 | 100 | 282 | 475 | 312 | 4 | 2023-11-27 | 125.98 | 3.15 | 2023-11-15 | 3 | 26.18 | 1 | 125.98 | 24 | SO51845 | 2023-11-22 | 10.08 | 78.53 | 41.99 |
SO45321_7 | C4E4-4F04-B1 | PO3799119166 | 100 | 282 | 348 | 312 | 4 | 2022-05-30 | 12149.96 | 303.75 | 2022-05-18 | 6 | 1898.09 | 1 | 12149.96 | 7 | SO45321 | 2022-05-25 | 972.00 | 11388.57 | 2024.99 |
SO48048_34 | B414-46CB-BA | PO3480117933 | 100 | 283 | 286 | 436 | 4 | 2023-02-27 | 367.88 | 9.20 | 2023-02-15 | 2 | 170.14 | 1 | 367.88 | 34 | SO48048 | 2023-02-22 | 29.43 | 340.29 | 183.94 |
SO51845_25 | 6AB8-4CEA-A9 | PO3799111961 | 100 | 282 | 532 | 312 | 4 | 2023-11-27 | 599.50 | 14.99 | 2023-11-15 | 4 | 136.79 | 1 | 599.50 | 25 | SO51845 | 2023-11-22 | 47.96 | 547.14 | 149.87 |
SO45321_8 | C4E4-4F04-B1 | PO3799119166 | 100 | 282 | 345 | 312 | 4 | 2022-05-30 | 8159.98 | 204.00 | 2022-05-18 | 4 | 1912.15 | 1 | 8159.98 | 8 | SO45321 | 2022-05-25 | 652.80 | 7648.62 | 2039.99 |
SO48048_35 | B414-46CB-BA | PO3480117933 | 100 | 283 | 321 | 436 | 4 | 2023-02-27 | 1879.18 | 46.98 | 2023-02-15 | 4 | 486.71 | 1 | 1879.18 | 35 | SO48048 | 2023-02-22 | 150.33 | 1946.83 | 469.79 |
SO51845_26 | 6AB8-4CEA-A9 | PO3799111961 | 100 | 282 | 361 | 312 | 4 | 2023-11-27 | 5507.98 | 137.70 | 2023-11-15 | 4 | 1251.98 | 1 | 5507.98 | 26 | SO51845 | 2023-11-22 | 440.64 | 5007.93 | 1376.99 |
Generated 2024-11-14 17:55:36.004 UTC