[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SKIP 0 < SKIP 3281 > < TAKE 31 >
31 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45330_2 | 19B9-4EA4-8F | PO5800111159 | 100 | 285 | 218 | 63 | 5 | 2022-05-25 | 11.40 | 0.29 | 2022-05-13 | 2 | 3.40 | 1 | 11.40 | 2 | SO45330 | 2022-05-20 | 0.91 | 6.79 | 5.70 |
SO50757_2 | 5C6E-4693-95 | PO9048116268 | 100 | 285 | 469 | 652 | 5 | 2023-09-22 | 45.59 | 1.14 | 2023-09-10 | 2 | 15.67 | 1 | 45.59 | 2 | SO50757 | 2023-09-17 | 3.65 | 31.34 | 22.79 |
SO45331_1 | 4702-48B5-B8 | PO6293165974 | 100 | 285 | 313 | 612 | 5 | 2022-05-25 | 2146.96 | 53.67 | 2022-05-13 | 1 | 2171.29 | 1 | 2146.96 | 1 | SO45331 | 2022-05-20 | 171.76 | 2171.29 | 2146.96 |
SO50757_3 | 5C6E-4693-95 | PO9048116268 | 100 | 285 | 468 | 652 | 5 | 2023-09-22 | 45.59 | 1.14 | 2023-09-10 | 2 | 15.67 | 1 | 45.59 | 3 | SO50757 | 2023-09-17 | 3.65 | 31.34 | 22.79 |
SO45331_2 | 4702-48B5-B8 | PO6293165974 | 100 | 285 | 322 | 612 | 5 | 2022-05-25 | 419.46 | 10.49 | 2022-05-13 | 1 | 413.15 | 1 | 419.46 | 2 | SO45331 | 2022-05-20 | 33.56 | 413.15 | 419.46 |
SO50759_1 | E56C-42C1-A9 | PO9744159893 | 100 | 285 | 358 | 98 | 5 | 2023-09-22 | 1229.46 | 30.74 | 2023-09-10 | 1 | 1105.81 | 1 | 1229.46 | 1 | SO50759 | 2023-09-17 | 98.36 | 1105.81 | 1229.46 |
SO45331_3 | 4702-48B5-B8 | PO6293165974 | 100 | 285 | 324 | 612 | 5 | 2022-05-25 | 2097.29 | 52.43 | 2022-05-13 | 5 | 413.15 | 1 | 2097.29 | 3 | SO45331 | 2022-05-20 | 167.78 | 2065.73 | 419.46 |
SO50759_2 | E56C-42C1-A9 | PO9744159893 | 100 | 285 | 468 | 98 | 5 | 2023-09-22 | 22.79 | 0.57 | 2023-09-10 | 1 | 15.67 | 1 | 22.79 | 2 | SO50759 | 2023-09-17 | 1.82 | 15.67 | 22.79 |
SO45331_4 | 4702-48B5-B8 | PO6293165974 | 100 | 285 | 326 | 612 | 5 | 2022-05-25 | 838.92 | 20.97 | 2022-05-13 | 2 | 413.15 | 1 | 838.92 | 4 | SO45331 | 2022-05-20 | 67.11 | 826.29 | 419.46 |
SO51081_1 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 237 | 676 | 5 | 2023-10-22 | 119.98 | 3.00 | 2023-10-10 | 4 | 38.49 | 1 | 119.98 | 1 | SO51081 | 2023-10-17 | 9.60 | 153.97 | 29.99 |
SO45331_5 | 4702-48B5-B8 | PO6293165974 | 100 | 285 | 332 | 612 | 5 | 2022-05-25 | 419.46 | 10.49 | 2022-05-13 | 1 | 413.15 | 1 | 419.46 | 5 | SO45331 | 2022-05-20 | 33.56 | 413.15 | 419.46 |
SO51081_2 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 596 | 676 | 5 | 2023-10-22 | 323.99 | 8.10 | 2023-10-10 | 1 | 294.58 | 1 | 323.99 | 2 | SO51081 | 2023-10-17 | 25.92 | 294.58 | 323.99 |
SO45331_6 | 4702-48B5-B8 | PO6293165974 | 100 | 285 | 330 | 612 | 5 | 2022-05-25 | 838.92 | 20.97 | 2022-05-13 | 2 | 413.15 | 1 | 838.92 | 6 | SO45331 | 2022-05-20 | 67.11 | 826.29 | 419.46 |
SO51081_3 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 597 | 676 | 5 | 2023-10-22 | 971.98 | 24.30 | 2023-10-10 | 3 | 294.58 | 1 | 971.98 | 3 | SO51081 | 2023-10-17 | 77.76 | 883.74 | 323.99 |
SO45331_7 | 4702-48B5-B8 | PO6293165974 | 100 | 285 | 316 | 612 | 5 | 2022-05-25 | 874.79 | 21.87 | 2022-05-13 | 1 | 884.71 | 1 | 874.79 | 7 | SO45331 | 2022-05-20 | 69.98 | 884.71 | 874.79 |
SO51081_4 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 599 | 676 | 5 | 2023-10-22 | 323.99 | 8.10 | 2023-10-10 | 1 | 294.58 | 1 | 323.99 | 4 | SO51081 | 2023-10-17 | 25.92 | 294.58 | 323.99 |
SO45331_8 | 4702-48B5-B8 | PO6293165974 | 100 | 285 | 311 | 612 | 5 | 2022-05-25 | 4293.92 | 107.35 | 2022-05-13 | 2 | 2171.29 | 1 | 4293.92 | 8 | SO45331 | 2022-05-20 | 343.51 | 4342.59 | 2146.96 |
SO51081_5 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 591 | 676 | 5 | 2023-10-22 | 338.99 | 8.47 | 2023-10-10 | 1 | 308.22 | 1 | 338.99 | 5 | SO51081 | 2023-10-17 | 27.12 | 308.22 | 338.99 |
SO45331_9 | 4702-48B5-B8 | PO6293165974 | 100 | 285 | 338 | 612 | 5 | 2022-05-25 | 838.92 | 20.97 | 2022-05-13 | 2 | 413.15 | 1 | 838.92 | 9 | SO45331 | 2022-05-20 | 67.11 | 826.29 | 419.46 |
SO51081_6 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 593 | 676 | 5 | 2023-10-22 | 677.99 | 16.95 | 2023-10-10 | 2 | 308.22 | 1 | 677.99 | 6 | SO51081 | 2023-10-17 | 54.24 | 616.44 | 338.99 |
SO45331_10 | 4702-48B5-B8 | PO6293165974 | 100 | 285 | 317 | 612 | 5 | 2022-05-25 | 874.79 | 21.87 | 2022-05-13 | 1 | 884.71 | 1 | 874.79 | 10 | SO45331 | 2022-05-20 | 69.98 | 884.71 | 874.79 |
SO51081_7 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 588 | 676 | 5 | 2023-10-22 | 1846.78 | 46.17 | 2023-10-10 | 4 | 419.78 | 1 | 1846.78 | 7 | SO51081 | 2023-10-17 | 147.74 | 1679.11 | 461.69 |
SO45331_11 | 4702-48B5-B8 | PO6293165974 | 100 | 285 | 315 | 612 | 5 | 2022-05-25 | 2624.38 | 65.61 | 2022-05-13 | 3 | 884.71 | 1 | 2624.38 | 11 | SO45331 | 2022-05-20 | 209.95 | 2654.12 | 874.79 |
SO51081_8 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 465 | 676 | 5 | 2023-10-22 | 88.16 | 2.20 | 2023-10-10 | 6 | 9.16 | 1 | 88.16 | 8 | SO51081 | 2023-10-17 | 7.05 | 54.96 | 14.69 |
SO45331_12 | 4702-48B5-B8 | PO6293165974 | 100 | 285 | 319 | 612 | 5 | 2022-05-25 | 874.79 | 21.87 | 2022-05-13 | 1 | 884.71 | 1 | 874.79 | 12 | SO45331 | 2022-05-20 | 69.98 | 884.71 | 874.79 |
SO51081_9 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 359 | 676 | 5 | 2023-10-22 | 8261.96 | 206.55 | 2023-10-10 | 6 | 1251.98 | 1 | 8261.96 | 9 | SO51081 | 2023-10-17 | 660.96 | 7511.89 | 1376.99 |
SO45331_13 | 4702-48B5-B8 | PO6293165974 | 100 | 285 | 328 | 612 | 5 | 2022-05-25 | 838.92 | 20.97 | 2022-05-13 | 2 | 413.15 | 1 | 838.92 | 13 | SO45331 | 2022-05-20 | 67.11 | 826.29 | 419.46 |
SO51081_10 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 355 | 676 | 5 | 2023-10-22 | 4175.98 | 104.40 | 2023-10-10 | 3 | 1265.62 | 1 | 4175.98 | 10 | SO51081 | 2023-10-17 | 334.08 | 3796.86 | 1391.99 |
SO45331_14 | 4702-48B5-B8 | PO6293165974 | 100 | 285 | 312 | 612 | 5 | 2022-05-25 | 2146.96 | 53.67 | 2022-05-13 | 1 | 2171.29 | 1 | 2146.96 | 14 | SO45331 | 2022-05-20 | 171.76 | 2171.29 | 2146.96 |
SO51081_11 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 398 | 676 | 5 | 2023-10-22 | 80.17 | 2.00 | 2023-10-10 | 3 | 19.78 | 1 | 80.17 | 11 | SO51081 | 2023-10-17 | 6.41 | 59.33 | 26.72 |
SO45331_15 | 4702-48B5-B8 | PO6293165974 | 100 | 285 | 220 | 612 | 5 | 2022-05-25 | 20.19 | 0.50 | 2022-05-13 | 1 | 12.03 | 1 | 20.19 | 15 | SO45331 | 2022-05-20 | 1.61 | 12.03 | 20.19 |
Generated 2024-11-10 02:05:45.643 UTC