[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE SKIP 2000 < SKIP 127 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO44762_20 | 553E-437E-92 | PO13543176259 | 100 | 287 | 220 | 2 | 293 | 1 | 4.29 | 2022-03-25 | 214.65 | 5.26 | 2022-03-13 | 11 | 12.03 | 1 | 210.36 | 20 | SO44762 | 2022-03-20 | 16.83 | 132.31 | 19.51 | 0.02 |
| SO49503_4 | 1FD6-48BE-A1 | PO13543189827 | 100 | 287 | 469 | 293 | 1 | 2023-06-23 | 68.38 | 1.71 | 2023-06-11 | 3 | 15.67 | 1 | 68.38 | 4 | SO49503 | 2023-06-18 | 5.47 | 47.01 | 22.79 | |||
| SO58940_5 | 72B7-4C82-8A | PO13543115032 | 100 | 287 | 474 | 293 | 1 | 2024-03-24 | 293.96 | 7.35 | 2024-03-12 | 7 | 26.18 | 1 | 293.96 | 5 | SO58940 | 2024-03-19 | 23.52 | 183.23 | 41.99 | |||
| SO53576_12 | 7638-4151-96 | PO7395119515 | 100 | 286 | 596 | 542 | 1 | 2023-12-24 | 647.99 | 16.20 | 2023-12-12 | 2 | 294.58 | 1 | 647.99 | 12 | SO53576 | 2023-12-19 | 51.84 | 589.16 | 323.99 | |||
| SO46972_4 | 1A21-419F-8D | PO14500164221 | 100 | 282 | 397 | 650 | 1 | 2022-11-23 | 145.77 | 3.64 | 2022-11-11 | 6 | 17.98 | 1 | 145.77 | 4 | SO46972 | 2022-11-18 | 11.66 | 107.87 | 24.29 | |||
| SO71893_17 | 9AE1-416A-8F | PO7482196160 | 100 | 293 | 493 | 163 | 1 | 2024-09-23 | 200.05 | 5.00 | 2024-09-11 | 1 | 199.85 | 1 | 200.05 | 17 | SO71893 | 2024-09-18 | 16.00 | 199.85 | 200.05 | |||
| SO46372_13 | 236A-4108-B4 | PO5220136009 | 100 | 282 | 300 | 169 | 1 | 2022-09-23 | 809.76 | 20.24 | 2022-09-11 | 1 | 699.09 | 1 | 809.76 | 13 | SO46372 | 2022-09-18 | 64.78 | 699.09 | 809.76 | |||
| SO67309_6 | 9B68-41C2-90 | PO14094179707 | 100 | 293 | 222 | 253 | 1 | 2024-07-24 | 20.99 | 0.52 | 2024-07-12 | 1 | 13.09 | 1 | 20.99 | 6 | SO67309 | 2024-07-19 | 1.68 | 13.09 | 20.99 | |||
| SO65175_1 | E1A8-440E-94 | PO17139119772 | 100 | 293 | 382 | 644 | 1 | 2024-06-23 | 2689.18 | 67.23 | 2024-06-11 | 4 | 713.08 | 1 | 2689.18 | 1 | SO65175 | 2024-06-18 | 215.13 | 2852.32 | 672.29 | |||
| SO58910_24 | A209-4ADD-98 | PO19169152738 | 100 | 289 | 532 | 272 | 1 | 2024-03-24 | 149.87 | 3.75 | 2024-03-12 | 1 | 136.79 | 1 | 149.87 | 24 | SO58910 | 2024-03-19 | 11.99 | 136.79 | 149.87 | |||
| SO58961_1 | 0848-4E9B-81 | PO10411162031 | 100 | 289 | 465 | 182 | 1 | 2024-03-24 | 73.47 | 1.84 | 2024-03-12 | 5 | 9.16 | 1 | 73.47 | 1 | SO58961 | 2024-03-19 | 5.88 | 45.80 | 14.69 | |||
| SO65278_8 | 5822-4DF1-92 | PO5017152408 | 100 | 289 | 561 | 308 | 1 | 2024-06-23 | 7152.21 | 178.81 | 2024-06-11 | 5 | 1481.94 | 1 | 7152.21 | 8 | SO65278 | 2024-06-18 | 572.18 | 7409.69 | 1430.44 | |||
| SO44513_5 | A881-41E7-AD | PO14471116260 | 100 | 286 | 349 | 145 | 1 | 2022-02-23 | 6074.98 | 151.87 | 2022-02-11 | 3 | 1898.09 | 1 | 6074.98 | 5 | SO44513 | 2022-02-18 | 486.00 | 5694.28 | 2024.99 | |||
| SO50678_2 | CAED-407A-BA | PO13543174640 | 100 | 287 | 297 | 293 | 1 | 2023-09-23 | 1472.29 | 36.81 | 2023-09-11 | 2 | 653.70 | 1 | 1472.29 | 2 | SO50678 | 2023-09-18 | 117.78 | 1307.39 | 736.15 | |||
| SO50297_48 | 5199-40AD-90 | PO4727113542 | 100 | 293 | 453 | 343 | 1 | 2023-08-23 | 35.99 | 0.90 | 2023-08-11 | 1 | 24.75 | 1 | 35.99 | 48 | SO50297 | 2023-08-18 | 2.88 | 24.75 | 35.99 | |||
| SO69525_5 | 9DCD-4F42-9E | PO4727119266 | 100 | 293 | 382 | 343 | 1 | 2024-08-23 | 2689.18 | 67.23 | 2024-08-11 | 4 | 713.08 | 1 | 2689.18 | 5 | SO69525 | 2024-08-18 | 215.13 | 2852.32 | 672.29 | |||
| SO47992_11 | 3F55-4354-BD | PO15573158216 | 100 | 293 | 399 | 487 | 1 | 2023-02-23 | 101.32 | 2.53 | 2023-02-11 | 3 | 24.99 | 1 | 101.32 | 11 | SO47992 | 2023-02-18 | 8.11 | 74.98 | 33.77 | |||
| SO57030_36 | 373C-4C0F-88 | PO16414180321 | 100 | 289 | 290 | 236 | 1 | 2024-02-23 | 818.70 | 20.47 | 2024-02-11 | 1 | 747.20 | 1 | 818.70 | 36 | SO57030 | 2024-02-18 | 65.50 | 747.20 | 818.70 | |||
| SO67294_2 | 85E2-46A1-BE | PO899165491 | 100 | 289 | 225 | 2 | 290 | 1 | 1.25 | 2024-07-24 | 62.57 | 1.53 | 2024-07-12 | 12 | 6.92 | 1 | 61.32 | 2 | SO67294 | 2024-07-19 | 4.91 | 83.07 | 5.21 | 0.02 |
| SO71935_6 | 053A-47E3-AC | PO7946145876 | 100 | 282 | 482 | 2 | 438 | 1 | 1.36 | 2024-09-23 | 67.78 | 1.66 | 2024-09-11 | 13 | 3.36 | 1 | 66.43 | 6 | SO71935 | 2024-09-18 | 5.31 | 43.71 | 5.21 | 0.02 |
| SO57030_34 | 373C-4C0F-88 | PO16414180321 | 100 | 289 | 514 | 236 | 1 | 2024-02-23 | 191.70 | 4.79 | 2024-02-11 | 3 | 47.29 | 1 | 191.70 | 34 | SO57030 | 2024-02-18 | 15.34 | 141.86 | 63.90 | |||
| SO53518_34 | 5712-444B-BC | PO841197199 | 100 | 286 | 551 | 2 | 254 | 1 | 33.69 | 2023-12-24 | 1684.64 | 41.27 | 2023-12-12 | 11 | 144.59 | 1 | 1650.95 | 34 | SO53518 | 2023-12-19 | 132.08 | 1590.53 | 153.15 | 0.02 |
| SO67266_19 | 3CFE-46C9-88 | PO16588161069 | 100 | 289 | 532 | 146 | 1 | 2024-07-24 | 749.37 | 18.73 | 2024-07-12 | 5 | 136.79 | 1 | 749.37 | 19 | SO67266 | 2024-07-19 | 59.95 | 683.93 | 149.87 | |||
| SO44285_10 | 33BA-457C-B7 | PO16617120120 | 100 | 286 | 349 | 397 | 1 | 2022-01-23 | 4049.99 | 101.25 | 2022-01-11 | 2 | 1898.09 | 1 | 4049.99 | 10 | SO44285 | 2022-01-18 | 324.00 | 3796.19 | 2024.99 | |||
| SO44541_7 | 64BA-409F-A1 | PO2958192556 | 100 | 286 | 223 | 559 | 1 | 2022-02-23 | 5.19 | 0.13 | 2022-02-11 | 1 | 5.71 | 1 | 5.19 | 7 | SO44541 | 2022-02-18 | 0.41 | 5.71 | 5.19 | |||
| SO46098_11 | CB38-416D-A7 | PO7221115229 | 100 | 289 | 218 | 326 | 1 | 2022-08-23 | 17.10 | 0.43 | 2022-08-11 | 3 | 3.40 | 1 | 17.10 | 11 | SO46098 | 2022-08-18 | 1.37 | 10.19 | 5.70 | |||
| SO49136_19 | 3492-4F41-97 | PO4727180151 | 100 | 293 | 341 | 343 | 1 | 2023-05-26 | 469.79 | 11.74 | 2023-05-14 | 1 | 486.71 | 1 | 469.79 | 19 | SO49136 | 2023-05-21 | 37.58 | 486.71 | 469.79 | |||
| SO48083_10 | E4B1-4D02-90 | PO7917164304 | 100 | 287 | 456 | 401 | 1 | 2023-02-23 | 89.99 | 2.25 | 2023-02-11 | 2 | 30.93 | 1 | 89.99 | 10 | SO48083 | 2023-02-18 | 7.20 | 61.87 | 44.99 | |||
| SO65175_12 | E1A8-440E-94 | PO17139119772 | 100 | 293 | 418 | 644 | 1 | 2024-06-23 | 713.80 | 17.84 | 2024-06-11 | 2 | 360.94 | 1 | 713.80 | 12 | SO65175 | 2024-06-18 | 57.10 | 721.89 | 356.90 | |||
| SO44563_6 | 9AFF-40A9-96 | PO7627161014 | 100 | 286 | 336 | 433 | 1 | 2022-02-23 | 1677.84 | 41.95 | 2022-02-11 | 4 | 413.15 | 1 | 1677.84 | 6 | SO44563 | 2022-02-18 | 134.23 | 1652.59 | 419.46 | |||
| SO44570_10 | 4132-4AE3-99 | PO8816195785 | 100 | 289 | 338 | 218 | 1 | 2022-02-23 | 1258.38 | 31.46 | 2022-02-11 | 3 | 413.15 | 1 | 1258.38 | 10 | SO44570 | 2022-02-18 | 100.67 | 1239.44 | 419.46 |
Generated 2024-11-10 08:24:52.199 UTC