[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SKIP 0 < SKIP 2688 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO53530_11 | A31D-483D-A1 | PO2813121313 | 100 | 283 | 482 | 90 | 5 | 2023-11-03 | 10.79 | 0.27 | 2023-10-22 | 2 | 3.36 | 1 | 10.79 | 11 | SO53530 | 2023-10-29 | 0.86 | 6.72 | 5.39 | |||
SO65210_5 | 08E4-4CC9-A7 | PO2813181442 | 100 | 283 | 234 | 90 | 5 | 2024-05-03 | 269.95 | 6.75 | 2024-04-21 | 9 | 38.49 | 1 | 269.95 | 5 | SO65210 | 2024-04-28 | 21.60 | 346.43 | 29.99 | |||
SO45805_12 | 4E35-406B-B7 | PO3393138494 | 100 | 285 | 330 | 549 | 5 | 2022-06-03 | 419.46 | 10.49 | 2022-05-22 | 1 | 413.15 | 1 | 419.46 | 12 | SO45805 | 2022-05-29 | 33.56 | 413.15 | 419.46 | |||
SO48730_6 | C918-466B-B1 | PO522152463 | 100 | 285 | 360 | 676 | 5 | 2023-03-05 | 3688.38 | 92.21 | 2023-02-21 | 3 | 1105.81 | 1 | 3688.38 | 6 | SO48730 | 2023-02-28 | 295.07 | 3317.43 | 1229.46 | |||
SO53530_12 | A31D-483D-A1 | PO2813121313 | 100 | 283 | 472 | 2 | 90 | 5 | 10.31 | 2023-11-03 | 515.62 | 12.63 | 2023-10-22 | 14 | 23.75 | 1 | 505.31 | 12 | SO53530 | 2023-10-29 | 40.42 | 332.49 | 36.83 | 0.02 |
SO65210_6 | 08E4-4CC9-A7 | PO2813181442 | 100 | 283 | 484 | 90 | 5 | 2024-05-03 | 19.08 | 0.48 | 2024-04-21 | 4 | 2.97 | 1 | 19.08 | 6 | SO65210 | 2024-04-28 | 1.53 | 11.89 | 4.77 | |||
SO45805_13 | 4E35-406B-B7 | PO3393138494 | 100 | 285 | 328 | 549 | 5 | 2022-06-03 | 419.46 | 10.49 | 2022-05-22 | 1 | 413.15 | 1 | 419.46 | 13 | SO45805 | 2022-05-29 | 33.56 | 413.15 | 419.46 | |||
SO48730_7 | C918-466B-B1 | PO522152463 | 100 | 285 | 362 | 676 | 5 | 2023-03-05 | 3688.38 | 92.21 | 2023-02-21 | 3 | 1105.81 | 1 | 3688.38 | 7 | SO48730 | 2023-02-28 | 295.07 | 3317.43 | 1229.46 | |||
SO53530_13 | A31D-483D-A1 | PO2813121313 | 100 | 283 | 605 | 90 | 5 | 2023-11-03 | 3239.94 | 81.00 | 2023-10-22 | 10 | 343.65 | 1 | 3239.94 | 13 | SO53530 | 2023-10-29 | 259.20 | 3436.50 | 323.99 | |||
SO65210_7 | 08E4-4CC9-A7 | PO2813181442 | 100 | 283 | 225 | 90 | 5 | 2024-05-03 | 21.58 | 0.54 | 2024-04-21 | 4 | 6.92 | 1 | 21.58 | 7 | SO65210 | 2024-04-28 | 1.73 | 27.69 | 5.39 | |||
SO45805_14 | 4E35-406B-B7 | PO3393138494 | 100 | 285 | 322 | 549 | 5 | 2022-06-03 | 419.46 | 10.49 | 2022-05-22 | 1 | 413.15 | 1 | 419.46 | 14 | SO45805 | 2022-05-29 | 33.56 | 413.15 | 419.46 | |||
SO48730_8 | C918-466B-B1 | PO522152463 | 100 | 285 | 352 | 676 | 5 | 2023-03-05 | 7457.11 | 186.43 | 2023-02-21 | 6 | 1117.86 | 1 | 7457.11 | 8 | SO48730 | 2023-02-28 | 596.57 | 6707.14 | 1242.85 | |||
SO53530_14 | A31D-483D-A1 | PO2813121313 | 100 | 283 | 231 | 90 | 5 | 2023-11-03 | 269.95 | 6.75 | 2023-10-22 | 9 | 38.49 | 1 | 269.95 | 14 | SO53530 | 2023-10-29 | 21.60 | 346.43 | 29.99 | |||
SO65210_8 | 08E4-4CC9-A7 | PO2813181442 | 100 | 283 | 231 | 90 | 5 | 2024-05-03 | 179.96 | 4.50 | 2024-04-21 | 6 | 38.49 | 1 | 179.96 | 8 | SO65210 | 2024-04-28 | 14.40 | 230.95 | 29.99 | |||
SO45805_15 | 4E35-406B-B7 | PO3393138494 | 100 | 285 | 334 | 549 | 5 | 2022-06-03 | 1258.38 | 31.46 | 2022-05-22 | 3 | 413.15 | 1 | 1258.38 | 15 | SO45805 | 2022-05-29 | 100.67 | 1239.44 | 419.46 | |||
SO48730_9 | C918-466B-B1 | PO522152463 | 100 | 285 | 354 | 676 | 5 | 2023-03-05 | 2485.70 | 62.14 | 2023-02-21 | 2 | 1117.86 | 1 | 2485.70 | 9 | SO48730 | 2023-02-28 | 198.86 | 2235.71 | 1242.85 | |||
SO53530_15 | A31D-483D-A1 | PO2813121313 | 100 | 283 | 225 | 90 | 5 | 2023-11-03 | 10.79 | 0.27 | 2023-10-22 | 2 | 6.92 | 1 | 10.79 | 15 | SO53530 | 2023-10-29 | 0.86 | 13.84 | 5.39 | |||
SO65210_9 | 08E4-4CC9-A7 | PO2813181442 | 100 | 283 | 463 | 90 | 5 | 2024-05-03 | 29.39 | 0.73 | 2024-04-21 | 2 | 9.16 | 1 | 29.39 | 9 | SO65210 | 2024-04-28 | 2.35 | 18.32 | 14.69 | |||
SO45805_16 | 4E35-406B-B7 | PO3393138494 | 100 | 285 | 326 | 549 | 5 | 2022-06-03 | 419.46 | 10.49 | 2022-05-22 | 1 | 413.15 | 1 | 419.46 | 16 | SO45805 | 2022-05-29 | 33.56 | 413.15 | 419.46 | |||
SO48730_10 | C918-466B-B1 | PO522152463 | 100 | 285 | 356 | 676 | 5 | 2023-03-05 | 4971.41 | 124.29 | 2023-02-21 | 4 | 1117.86 | 1 | 4971.41 | 10 | SO48730 | 2023-02-28 | 397.71 | 4471.42 | 1242.85 | |||
SO53530_16 | A31D-483D-A1 | PO2813121313 | 100 | 283 | 214 | 2 | 90 | 5 | 5.68 | 2023-11-03 | 284.12 | 6.96 | 2023-10-22 | 14 | 13.09 | 1 | 278.44 | 16 | SO53530 | 2023-10-29 | 22.27 | 183.21 | 20.29 | 0.02 |
SO65210_10 | 08E4-4CC9-A7 | PO2813181442 | 100 | 283 | 465 | 90 | 5 | 2024-05-03 | 44.08 | 1.10 | 2024-04-21 | 3 | 9.16 | 1 | 44.08 | 10 | SO65210 | 2024-04-28 | 3.53 | 27.48 | 14.69 | |||
SO45805_17 | 4E35-406B-B7 | PO3393138494 | 100 | 285 | 338 | 549 | 5 | 2022-06-03 | 1258.38 | 31.46 | 2022-05-22 | 3 | 413.15 | 1 | 1258.38 | 17 | SO45805 | 2022-05-29 | 100.67 | 1239.44 | 419.46 | |||
SO48730_11 | C918-466B-B1 | PO522152463 | 100 | 285 | 399 | 676 | 5 | 2023-03-05 | 33.77 | 0.84 | 2023-02-21 | 1 | 24.99 | 1 | 33.77 | 11 | SO48730 | 2023-02-28 | 2.70 | 24.99 | 33.77 | |||
SO53530_17 | A31D-483D-A1 | PO2813121313 | 100 | 283 | 382 | 90 | 5 | 2023-11-03 | 5378.35 | 134.46 | 2023-10-22 | 8 | 713.08 | 1 | 5378.35 | 17 | SO53530 | 2023-10-29 | 430.27 | 5704.64 | 672.29 | |||
SO65210_11 | 08E4-4CC9-A7 | PO2813181442 | 100 | 283 | 472 | 90 | 5 | 2024-05-03 | 190.50 | 4.76 | 2024-04-21 | 5 | 23.75 | 1 | 190.50 | 11 | SO65210 | 2024-04-28 | 15.24 | 118.75 | 38.10 | |||
SO45805_18 | 4E35-406B-B7 | PO3393138494 | 100 | 285 | 319 | 549 | 5 | 2022-06-03 | 874.79 | 21.87 | 2022-05-22 | 1 | 884.71 | 1 | 874.79 | 18 | SO45805 | 2022-05-29 | 69.98 | 884.71 | 874.79 | |||
SO48730_12 | C918-466B-B1 | PO522152463 | 100 | 285 | 420 | 676 | 5 | 2023-03-05 | 141.62 | 3.54 | 2023-02-21 | 1 | 104.80 | 1 | 141.62 | 12 | SO48730 | 2023-02-28 | 11.33 | 104.80 | 141.62 | |||
SO53530_18 | A31D-483D-A1 | PO2813121313 | 100 | 283 | 606 | 2 | 90 | 5 | 68.90 | 2023-11-03 | 3445.14 | 84.41 | 2023-10-22 | 11 | 343.65 | 1 | 3376.23 | 18 | SO53530 | 2023-10-29 | 270.10 | 3780.15 | 313.19 | 0.02 |
SO65210_12 | 08E4-4CC9-A7 | PO2813181442 | 100 | 283 | 606 | 90 | 5 | 2024-05-03 | 971.98 | 24.30 | 2024-04-21 | 3 | 343.65 | 1 | 971.98 | 12 | SO65210 | 2024-04-28 | 77.76 | 1030.95 | 323.99 | |||
SO45805_19 | 4E35-406B-B7 | PO3393138494 | 100 | 285 | 314 | 549 | 5 | 2022-06-03 | 4293.92 | 107.35 | 2022-05-22 | 2 | 2171.29 | 1 | 4293.92 | 19 | SO45805 | 2022-05-29 | 343.51 | 4342.59 | 2146.96 |
Generated 2024-09-20 06:38:48.091 UTC