[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > < SKIP 3616 > < TAKE 31 >
31 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO65173_7 | 5315-45D4-AA | PO17545119578 | 19 | 291 | 482 | 2 | 155 | 6 | 1.25 | 2024-05-04 | 62.57 | 1.53 | 2024-04-22 | 12 | 3.36 | 1 | 61.32 | 7 | SO65173 | 2024-04-29 | 4.91 | 40.35 | 5.21 | 0.02 |
SO45313_11 | 181D-4E05-8D | PO1827151513 | 19 | 288 | 223 | 317 | 6 | 2022-04-06 | 20.75 | 0.52 | 2022-03-25 | 4 | 5.71 | 1 | 20.75 | 11 | SO45313 | 2022-04-01 | 1.66 | 22.82 | 5.19 | |||
SO48321_14 | FA9B-4026-BF | PO14790154902 | 19 | 291 | 421 | 497 | 6 | 2023-02-03 | 588.99 | 14.72 | 2023-01-22 | 3 | 145.28 | 1 | 588.99 | 14 | SO48321 | 2023-01-29 | 47.12 | 435.85 | 196.33 | |||
SO65173_8 | 5315-45D4-AA | PO17545119578 | 19 | 291 | 378 | 155 | 6 | 2024-05-04 | 11728.08 | 293.20 | 2024-04-22 | 8 | 1554.95 | 1 | 11728.08 | 8 | SO65173 | 2024-04-29 | 938.25 | 12439.58 | 1466.01 | |||
SO45313_12 | 181D-4E05-8D | PO1827151513 | 19 | 288 | 326 | 317 | 6 | 2022-04-06 | 419.46 | 10.49 | 2022-03-25 | 1 | 413.15 | 1 | 419.46 | 12 | SO45313 | 2022-04-01 | 33.56 | 413.15 | 419.46 | |||
SO48321_15 | FA9B-4026-BF | PO14790154902 | 19 | 291 | 410 | 497 | 6 | 2023-02-03 | 72.89 | 1.82 | 2023-01-22 | 2 | 26.97 | 1 | 72.89 | 15 | SO48321 | 2023-01-29 | 5.83 | 53.94 | 36.45 | |||
SO65173_9 | 5315-45D4-AA | PO17545119578 | 19 | 291 | 580 | 155 | 6 | 2024-05-04 | 6123.56 | 153.09 | 2024-04-22 | 6 | 1082.51 | 1 | 6123.56 | 9 | SO65173 | 2024-04-29 | 489.89 | 6495.06 | 1020.59 | |||
SO45313_13 | 181D-4E05-8D | PO1827151513 | 19 | 288 | 338 | 317 | 6 | 2022-04-06 | 419.46 | 10.49 | 2022-03-25 | 1 | 413.15 | 1 | 419.46 | 13 | SO45313 | 2022-04-01 | 33.56 | 413.15 | 419.46 | |||
SO48321_16 | FA9B-4026-BF | PO14790154902 | 19 | 291 | 236 | 497 | 6 | 2023-02-03 | 86.52 | 2.16 | 2023-01-22 | 3 | 29.08 | 1 | 86.52 | 16 | SO48321 | 2023-01-29 | 6.92 | 87.24 | 28.84 | |||
SO65173_10 | 5315-45D4-AA | PO17545119578 | 19 | 291 | 584 | 155 | 6 | 2024-05-04 | 971.98 | 24.30 | 2024-04-22 | 3 | 343.65 | 1 | 971.98 | 10 | SO65173 | 2024-04-29 | 77.76 | 1030.95 | 323.99 | |||
SO45313_14 | 181D-4E05-8D | PO1827151513 | 19 | 288 | 215 | 317 | 6 | 2022-04-06 | 20.19 | 0.50 | 2022-03-25 | 1 | 12.03 | 1 | 20.19 | 14 | SO45313 | 2022-04-01 | 1.61 | 12.03 | 20.19 | |||
SO48321_17 | FA9B-4026-BF | PO14790154902 | 19 | 291 | 469 | 2 | 497 | 6 | 5.73 | 2023-02-03 | 286.44 | 7.02 | 2023-01-22 | 13 | 15.67 | 1 | 280.72 | 17 | SO48321 | 2023-01-29 | 22.46 | 203.72 | 22.03 | 0.02 |
SO65173_11 | 5315-45D4-AA | PO17545119578 | 19 | 291 | 605 | 155 | 6 | 2024-05-04 | 971.98 | 24.30 | 2024-04-22 | 3 | 343.65 | 1 | 971.98 | 11 | SO65173 | 2024-04-29 | 77.76 | 1030.95 | 323.99 | |||
SO45313_15 | 181D-4E05-8D | PO1827151513 | 19 | 288 | 310 | 317 | 6 | 2022-04-06 | 4293.92 | 107.35 | 2022-03-25 | 2 | 2171.29 | 1 | 4293.92 | 15 | SO45313 | 2022-04-01 | 343.51 | 4342.59 | 2146.96 | |||
SO48321_18 | FA9B-4026-BF | PO14790154902 | 19 | 291 | 453 | 497 | 6 | 2023-02-03 | 179.97 | 4.50 | 2023-01-22 | 5 | 24.75 | 1 | 179.97 | 18 | SO48321 | 2023-01-29 | 14.40 | 123.73 | 35.99 | |||
SO65173_12 | 5315-45D4-AA | PO17545119578 | 19 | 291 | 581 | 155 | 6 | 2024-05-04 | 6123.56 | 153.09 | 2024-04-22 | 6 | 1082.51 | 1 | 6123.56 | 12 | SO65173 | 2024-04-29 | 489.89 | 6495.06 | 1020.59 | |||
SO45313_16 | 181D-4E05-8D | PO1827151513 | 19 | 288 | 253 | 317 | 6 | 2022-04-06 | 357.16 | 8.93 | 2022-03-25 | 2 | 176.20 | 1 | 357.16 | 16 | SO45313 | 2022-04-01 | 28.57 | 352.40 | 178.58 | |||
SO48321_19 | FA9B-4026-BF | PO14790154902 | 19 | 291 | 367 | 497 | 6 | 2023-02-03 | 647.99 | 16.20 | 2023-01-22 | 1 | 598.44 | 1 | 647.99 | 19 | SO48321 | 2023-01-29 | 51.84 | 598.44 | 647.99 | |||
SO65173_13 | 5315-45D4-AA | PO17545119578 | 19 | 291 | 487 | 155 | 6 | 2024-05-04 | 131.98 | 3.30 | 2024-04-22 | 4 | 20.57 | 1 | 131.98 | 13 | SO65173 | 2024-04-29 | 10.56 | 82.27 | 32.99 | |||
SO45313_17 | 181D-4E05-8D | PO1827151513 | 19 | 288 | 314 | 317 | 6 | 2022-04-06 | 2146.96 | 53.67 | 2022-03-25 | 1 | 2171.29 | 1 | 2146.96 | 17 | SO45313 | 2022-04-01 | 171.76 | 2171.29 | 2146.96 | |||
SO48321_20 | FA9B-4026-BF | PO14790154902 | 19 | 291 | 354 | 497 | 6 | 2023-02-03 | 4971.41 | 124.29 | 2023-01-22 | 4 | 1117.86 | 1 | 4971.41 | 20 | SO48321 | 2023-01-29 | 397.71 | 4471.42 | 1242.85 | |||
SO65173_14 | 5315-45D4-AA | PO17545119578 | 19 | 291 | 472 | 155 | 6 | 2024-05-04 | 76.20 | 1.91 | 2024-04-22 | 2 | 23.75 | 1 | 76.20 | 14 | SO65173 | 2024-04-29 | 6.10 | 47.50 | 38.10 | |||
SO45313_18 | 181D-4E05-8D | PO1827151513 | 19 | 288 | 212 | 317 | 6 | 2022-04-06 | 20.19 | 0.50 | 2022-03-25 | 1 | 12.03 | 1 | 20.19 | 18 | SO45313 | 2022-04-01 | 1.61 | 12.03 | 20.19 | |||
SO48321_21 | FA9B-4026-BF | PO14790154902 | 19 | 291 | 458 | 497 | 6 | 2023-02-03 | 134.98 | 3.37 | 2023-01-22 | 3 | 30.93 | 1 | 134.98 | 21 | SO48321 | 2023-01-29 | 10.80 | 92.80 | 44.99 | |||
SO65173_15 | 5315-45D4-AA | PO17545119578 | 19 | 291 | 606 | 155 | 6 | 2024-05-04 | 647.99 | 16.20 | 2024-04-22 | 2 | 343.65 | 1 | 647.99 | 15 | SO65173 | 2024-04-29 | 51.84 | 687.30 | 323.99 | |||
SO45313_19 | 181D-4E05-8D | PO1827151513 | 19 | 288 | 315 | 317 | 6 | 2022-04-06 | 874.79 | 21.87 | 2022-03-25 | 1 | 884.71 | 1 | 874.79 | 19 | SO45313 | 2022-04-01 | 69.98 | 884.71 | 874.79 | |||
SO48321_22 | FA9B-4026-BF | PO14790154902 | 19 | 291 | 221 | 497 | 6 | 2023-02-03 | 121.12 | 3.03 | 2023-01-22 | 6 | 13.88 | 1 | 121.12 | 22 | SO48321 | 2023-01-29 | 9.69 | 83.27 | 20.19 | |||
SO65173_16 | 5315-45D4-AA | PO17545119578 | 19 | 291 | 380 | 155 | 6 | 2024-05-04 | 7330.05 | 183.25 | 2024-04-22 | 5 | 1554.95 | 1 | 7330.05 | 16 | SO65173 | 2024-04-29 | 586.40 | 7774.74 | 1466.01 | |||
SO45313_20 | 181D-4E05-8D | PO1827151513 | 19 | 288 | 275 | 317 | 6 | 2022-04-06 | 356.90 | 8.92 | 2022-03-25 | 1 | 352.14 | 1 | 356.90 | 20 | SO45313 | 2022-04-01 | 28.55 | 352.14 | 356.90 | |||
SO48321_23 | FA9B-4026-BF | PO14790154902 | 19 | 291 | 409 | 497 | 6 | 2023-02-03 | 418.51 | 10.46 | 2023-01-22 | 2 | 185.82 | 1 | 418.51 | 23 | SO48321 | 2023-01-29 | 33.48 | 371.64 | 209.26 | |||
SO65173_17 | 5315-45D4-AA | PO17545119578 | 19 | 291 | 546 | 155 | 6 | 2024-05-04 | 149.02 | 3.73 | 2024-04-22 | 4 | 27.57 | 1 | 149.02 | 17 | SO65173 | 2024-04-29 | 11.92 | 110.27 | 37.25 |
Generated 2024-09-21 09:27:12.444 UTC