[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SKIP 0 SHUFFLE < SKIP 1250 > < TAKE 30 >
30 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO46331_4 | 729B-498D-BD | PO17719139668 | 19 | 284 | 232 | 631 | 6 | 2022-08-02 | 57.68 | 1.44 | 2022-07-21 | 2 | 31.72 | 1 | 57.68 | 4 | SO46331 | 2022-07-28 | 4.61 | 63.45 | 28.84 | |||
| SO63239_14 | AF5E-48ED-A4 | PO4901178462 | 19 | 284 | 471 | 84 | 6 | 2024-04-03 | 304.80 | 7.62 | 2024-03-22 | 8 | 23.75 | 1 | 304.80 | 14 | SO63239 | 2024-03-29 | 24.38 | 189.99 | 38.10 | |||
| SO47670_9 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 265 | 514 | 6 | 2022-12-02 | 1416.32 | 35.41 | 2022-11-20 | 7 | 187.16 | 1 | 1416.32 | 9 | SO47670 | 2022-11-27 | 113.31 | 1310.10 | 202.33 | |||
| SO48297_7 | FF31-49F8-B2 | PO18531121802 | 19 | 284 | 233 | 613 | 6 | 2023-02-01 | 144.20 | 3.61 | 2023-01-20 | 5 | 29.08 | 1 | 144.20 | 7 | SO48297 | 2023-01-27 | 11.54 | 145.40 | 28.84 | |||
| SO51839_49 | 411D-4ACA-8E | PO4901195797 | 19 | 284 | 231 | 2 | 84 | 6 | 6.96 | 2023-10-02 | 347.93 | 8.52 | 2023-09-20 | 12 | 38.49 | 1 | 340.97 | 49 | SO51839 | 2023-09-27 | 27.28 | 461.91 | 28.99 | 0.02 |
| SO58932_36 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 483 | 2 | 408 | 6 | 16.70 | 2024-02-01 | 835.20 | 20.46 | 2024-01-20 | 12 | 44.88 | 1 | 818.50 | 36 | SO58932 | 2024-01-27 | 65.48 | 538.56 | 69.60 | 0.02 |
| SO65174_8 | E2AA-4EEC-93 | PO17574133893 | 19 | 291 | 516 | 678 | 6 | 2024-05-02 | 93.94 | 2.35 | 2024-04-20 | 4 | 17.38 | 1 | 93.94 | 8 | SO65174 | 2024-04-27 | 7.51 | 69.51 | 23.48 | |||
| SO50265_42 | 6C30-435D-9D | PO18705169014 | 19 | 291 | 221 | 479 | 6 | 2023-07-02 | 40.37 | 1.01 | 2023-06-20 | 2 | 13.88 | 1 | 40.37 | 42 | SO50265 | 2023-06-27 | 3.23 | 27.76 | 20.19 | |||
| SO69520_41 | 654B-484B-8F | PO4466144794 | 19 | 291 | 225 | 352 | 6 | 2024-07-02 | 37.76 | 0.94 | 2024-06-20 | 7 | 6.92 | 1 | 37.76 | 41 | SO69520 | 2024-06-27 | 3.02 | 48.46 | 5.39 | |||
| SO48291_1 | 15AC-43EA-80 | PO19778159565 | 19 | 291 | 297 | 388 | 6 | 2023-02-01 | 736.15 | 18.40 | 2023-01-20 | 1 | 653.70 | 1 | 736.15 | 1 | SO48291 | 2023-01-27 | 58.89 | 653.70 | 736.15 | |||
| SO46044_10 | 029B-4675-9A | PO16733123313 | 19 | 288 | 275 | 533 | 6 | 2022-07-02 | 356.90 | 8.92 | 2022-06-20 | 1 | 352.14 | 1 | 356.90 | 10 | SO46044 | 2022-06-27 | 28.55 | 352.14 | 356.90 | |||
| SO55245_11 | B5AD-476D-B4 | PO14732112185 | 19 | 291 | 287 | 514 | 6 | 2023-12-02 | 404.66 | 10.12 | 2023-11-20 | 2 | 204.63 | 1 | 404.66 | 11 | SO55245 | 2023-11-27 | 32.37 | 409.25 | 202.33 | |||
| SO71830_9 | DA2D-4B00-A4 | PO10875112195 | 19 | 291 | 234 | 2 | 281 | 6 | 6.96 | 2024-08-02 | 347.93 | 8.52 | 2024-07-21 | 12 | 38.49 | 1 | 340.97 | 9 | SO71830 | 2024-07-28 | 27.28 | 461.91 | 28.99 | 0.02 |
| SO67268_24 | 9708-4E22-A4 | PO15312122688 | 19 | 291 | 581 | 299 | 6 | 2024-06-02 | 6123.56 | 153.09 | 2024-05-21 | 6 | 1082.51 | 1 | 6123.56 | 24 | SO67268 | 2024-05-28 | 489.89 | 6495.06 | 1020.59 | |||
| SO46645_20 | F857-4A6D-9C | PO1711132491 | 19 | 291 | 397 | 245 | 6 | 2022-09-01 | 97.18 | 2.43 | 2022-08-20 | 4 | 17.98 | 1 | 97.18 | 20 | SO46645 | 2022-08-27 | 7.77 | 71.91 | 24.29 | |||
| SO46038_15 | D7B6-499A-87 | PO17748117802 | 19 | 284 | 328 | 102 | 6 | 2022-07-02 | 1677.84 | 41.95 | 2022-06-20 | 4 | 413.15 | 1 | 1677.84 | 15 | SO46038 | 2022-06-27 | 134.23 | 1652.59 | 419.46 | |||
| SO44504_5 | CFE2-4C08-B0 | PO16733198490 | 19 | 288 | 310 | 533 | 6 | 2022-01-02 | 2146.96 | 53.67 | 2021-12-21 | 1 | 2171.29 | 1 | 2146.96 | 5 | SO44504 | 2021-12-28 | 171.76 | 2171.29 | 2146.96 | |||
| SO47413_25 | E274-4280-9B | PO1885161774 | 19 | 284 | 420 | 588 | 6 | 2022-11-02 | 141.62 | 3.54 | 2022-10-21 | 1 | 104.80 | 1 | 141.62 | 25 | SO47413 | 2022-10-28 | 11.33 | 104.80 | 141.62 | |||
| SO58930_8 | 3C7F-464E-B2 | PO14790187151 | 19 | 291 | 476 | 497 | 6 | 2024-02-01 | 293.96 | 7.35 | 2024-01-20 | 7 | 26.18 | 1 | 293.96 | 8 | SO58930 | 2024-01-27 | 23.52 | 183.23 | 41.99 | |||
| SO44535_6 | 26EF-4A69-B0 | PO2088169831 | 19 | 288 | 272 | 136 | 6 | 2022-01-02 | 183.94 | 4.60 | 2021-12-21 | 1 | 181.49 | 1 | 183.94 | 6 | SO44535 | 2021-12-28 | 14.72 | 181.49 | 183.94 | |||
| SO69399_25 | BEA9-4703-91 | PO17661173810 | 19 | 284 | 577 | 264 | 6 | 2024-07-02 | 728.91 | 18.22 | 2024-06-20 | 1 | 755.15 | 1 | 728.91 | 25 | SO69399 | 2024-06-27 | 58.31 | 755.15 | 728.91 | |||
| SO65189_23 | 985E-4937-94 | PO14761195376 | 19 | 284 | 487 | 408 | 6 | 2024-05-02 | 131.98 | 3.30 | 2024-04-20 | 4 | 20.57 | 1 | 131.98 | 23 | SO65189 | 2024-04-27 | 10.56 | 82.27 | 32.99 | |||
| SO48750_16 | 9A71-449E-B6 | PO14732147398 | 19 | 291 | 331 | 514 | 6 | 2023-03-04 | 1409.38 | 35.23 | 2023-02-20 | 3 | 486.71 | 1 | 1409.38 | 16 | SO48750 | 2023-02-27 | 112.75 | 1460.12 | 469.79 | |||
| SO43891_1 | 1094-43CB-B1 | PO2726163521 | 19 | 288 | 348 | 29 | 6 | 2021-10-02 | 4049.99 | 101.25 | 2021-09-20 | 2 | 1898.09 | 1 | 4049.99 | 1 | SO43891 | 2021-09-27 | 324.00 | 3796.19 | 2024.99 | |||
| SO48750_8 | 9A71-449E-B6 | PO14732147398 | 19 | 291 | 448 | 514 | 6 | 2023-03-04 | 47.98 | 1.20 | 2023-02-20 | 4 | 8.25 | 1 | 47.98 | 8 | SO48750 | 2023-02-27 | 3.84 | 32.98 | 11.99 | |||
| SO48339_24 | EAB2-42EA-9C | PO10614150674 | 19 | 291 | 221 | 461 | 6 | 2023-02-01 | 40.37 | 1.01 | 2023-01-20 | 2 | 13.88 | 1 | 40.37 | 24 | SO48339 | 2023-01-27 | 3.23 | 27.76 | 20.19 | |||
| SO51113_1 | C890-4CA6-90 | PO11136135505 | 19 | 284 | 499 | 120 | 6 | 2023-09-01 | 1204.69 | 30.12 | 2023-08-20 | 2 | 601.74 | 1 | 1204.69 | 1 | SO51113 | 2023-08-27 | 96.38 | 1203.49 | 602.35 | |||
| SO47397_15 | B964-4D2F-B3 | PO11107130091 | 19 | 284 | 221 | 156 | 6 | 2022-11-02 | 60.56 | 1.51 | 2022-10-21 | 3 | 13.88 | 1 | 60.56 | 15 | SO47397 | 2022-10-28 | 4.84 | 41.63 | 20.19 | |||
| SO45323_7 | 8E16-4834-8A | PO4901118407 | 19 | 284 | 229 | 84 | 6 | 2022-04-04 | 259.56 | 6.49 | 2022-03-23 | 9 | 31.72 | 1 | 259.56 | 7 | SO45323 | 2022-03-30 | 20.77 | 285.52 | 28.84 | |||
| SO51786_25 | CB32-4179-97 | PO18357130739 | 19 | 272 | 472 | 138 | 6 | 2023-10-02 | 76.20 | 1.91 | 2023-09-20 | 2 | 23.75 | 1 | 76.20 | 25 | SO51786 | 2023-09-27 | 6.10 | 47.50 | 38.10 |
Generated 2024-09-19 23:42:56.903 UTC