[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 250 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO53484_13 | CEC0-499D-80 | PO14790120337 | 19 | 291 | 525 | 497 | 6 | 2023-10-30 | 316.86 | 7.92 | 2023-10-18 | 2 | 144.59 | 1 | 316.86 | 13 | SO53484 | 2023-10-25 | 25.35 | 289.19 | 158.43 | |||
SO53536_25 | 5C09-4051-92 | PO18299189909 | 19 | 291 | 475 | 118 | 6 | 2023-10-30 | 83.99 | 2.10 | 2023-10-18 | 2 | 26.18 | 1 | 83.99 | 25 | SO53536 | 2023-10-25 | 6.72 | 52.35 | 41.99 | |||
SO71808_9 | 2E63-4616-B1 | PO14761198562 | 19 | 284 | 234 | 2 | 408 | 6 | 6.96 | 2024-07-30 | 347.93 | 8.52 | 2024-07-18 | 12 | 38.49 | 1 | 340.97 | 9 | SO71808 | 2024-07-25 | 27.28 | 461.91 | 28.99 | 0.02 |
SO44744_16 | 6D80-4E9D-83 | PO19401124443 | 19 | 288 | 342 | 173 | 6 | 2022-01-29 | 419.46 | 10.49 | 2022-01-17 | 1 | 413.15 | 1 | 419.46 | 16 | SO44744 | 2022-01-24 | 33.56 | 413.15 | 419.46 | |||
SO53535_30 | 8195-45C7-93 | PO18502176746 | 19 | 291 | 570 | 13 | 154 | 6 | 150.33 | 2023-10-30 | 1002.17 | 21.30 | 2023-10-18 | 3 | 461.44 | 1 | 851.85 | 30 | SO53535 | 2023-10-25 | 68.15 | 1384.33 | 334.06 | 0.15 |
SO69520_10 | 654B-484B-8F | PO4466144794 | 19 | 291 | 533 | 352 | 6 | 2024-06-29 | 299.75 | 7.49 | 2024-06-17 | 2 | 136.79 | 1 | 299.75 | 10 | SO69520 | 2024-06-24 | 23.98 | 273.57 | 149.87 | |||
SO50195_1 | F28B-4548-99 | PO19198175870 | 19 | 291 | 395 | 653 | 6 | 2023-06-29 | 122.75 | 3.07 | 2023-06-17 | 2 | 45.42 | 1 | 122.75 | 1 | SO50195 | 2023-06-24 | 9.82 | 90.83 | 61.37 | |||
SO51818_30 | B8CE-4C91-A9 | PO9077115532 | 19 | 291 | 527 | 100 | 6 | 2023-09-29 | 475.29 | 11.88 | 2023-09-17 | 3 | 144.59 | 1 | 475.29 | 30 | SO51818 | 2023-09-24 | 38.02 | 433.78 | 158.43 | |||
SO46039_5 | D5C9-4969-86 | PO17313170717 | 19 | 288 | 345 | 389 | 6 | 2022-06-29 | 4079.99 | 102.00 | 2022-06-17 | 2 | 1912.15 | 1 | 4079.99 | 5 | SO46039 | 2022-06-24 | 326.40 | 3824.31 | 2039.99 | |||
SO61222_20 | 9C3C-4330-8A | PO13862196260 | 19 | 291 | 359 | 119 | 6 | 2024-02-29 | 5507.98 | 137.70 | 2024-02-17 | 4 | 1251.98 | 1 | 5507.98 | 20 | SO61222 | 2024-02-24 | 440.64 | 5007.93 | 1376.99 | |||
SO44547_18 | 801C-4288-87 | PO4901179982 | 19 | 284 | 270 | 84 | 6 | 2021-12-30 | 367.88 | 9.20 | 2021-12-18 | 2 | 181.49 | 1 | 367.88 | 18 | SO44547 | 2021-12-25 | 29.43 | 362.97 | 183.94 | |||
SO50265_11 | 6C30-435D-9D | PO18705169014 | 19 | 291 | 447 | 479 | 6 | 2023-06-29 | 45.00 | 1.13 | 2023-06-17 | 3 | 10.31 | 1 | 45.00 | 11 | SO50265 | 2023-06-24 | 3.60 | 30.94 | 15.00 | |||
SO55297_2 | 2455-4B60-A5 | PO4495126679 | 19 | 291 | 555 | 496 | 6 | 2023-11-29 | 447.30 | 11.18 | 2023-11-17 | 7 | 47.29 | 1 | 447.30 | 2 | SO55297 | 2023-11-24 | 35.78 | 331.00 | 63.90 | |||
SO45527_1 | 610E-44BC-87 | PO17545114353 | 19 | 288 | 324 | 155 | 6 | 2022-04-29 | 419.46 | 10.49 | 2022-04-17 | 1 | 413.15 | 1 | 419.46 | 1 | SO45527 | 2022-04-24 | 33.56 | 413.15 | 419.46 | |||
SO58925_5 | ACBD-43C3-A2 | PO15544139465 | 19 | 284 | 570 | 282 | 6 | 2024-01-29 | 445.41 | 11.14 | 2024-01-17 | 1 | 461.44 | 1 | 445.41 | 5 | SO58925 | 2024-01-24 | 35.63 | 461.44 | 445.41 | |||
SO48768_1 | 590A-4550-A0 | PO13862146668 | 19 | 291 | 362 | 119 | 6 | 2023-03-01 | 1229.46 | 30.74 | 2023-02-17 | 1 | 1105.81 | 1 | 1229.46 | 1 | SO48768 | 2023-02-24 | 98.36 | 1105.81 | 1229.46 | |||
SO49140_26 | EFF3-483D-BE | PO4901154744 | 19 | 284 | 230 | 84 | 6 | 2023-04-01 | 57.68 | 1.44 | 2023-03-20 | 2 | 29.08 | 1 | 57.68 | 26 | SO49140 | 2023-03-27 | 4.61 | 58.16 | 28.84 | |||
SO47362_11 | 41E3-4BA0-99 | PO17690189228 | 19 | 291 | 358 | 47 | 6 | 2022-10-30 | 1229.46 | 30.74 | 2022-10-18 | 1 | 1105.81 | 1 | 1229.46 | 11 | SO47362 | 2022-10-25 | 98.36 | 1105.81 | 1229.46 | |||
SO51096_12 | 2D8A-4DAD-96 | PO14732111307 | 19 | 291 | 520 | 514 | 6 | 2023-08-29 | 126.34 | 3.16 | 2023-08-17 | 4 | 23.37 | 1 | 126.34 | 12 | SO51096 | 2023-08-24 | 10.11 | 93.49 | 31.58 | |||
SO69448_10 | 26BF-4CA1-97 | PO11020118669 | 19 | 284 | 581 | 336 | 6 | 2024-06-29 | 4082.38 | 102.06 | 2024-06-17 | 4 | 1082.51 | 1 | 4082.38 | 10 | SO69448 | 2024-06-24 | 326.59 | 4330.04 | 1020.59 | |||
SO46950_20 | AAC1-43D9-A3 | PO17806144306 | 19 | 291 | 263 | 101 | 6 | 2022-09-29 | 809.33 | 20.23 | 2022-09-17 | 4 | 187.16 | 1 | 809.33 | 20 | SO46950 | 2022-09-24 | 64.75 | 748.63 | 202.33 | |||
SO50676_15 | 66F1-4A9A-97 | PO14790188963 | 19 | 291 | 453 | 497 | 6 | 2023-07-30 | 71.99 | 1.80 | 2023-07-18 | 2 | 24.75 | 1 | 71.99 | 15 | SO50676 | 2023-07-25 | 5.76 | 49.49 | 35.99 | |||
SO58932_1 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 502 | 408 | 6 | 2024-01-29 | 600.16 | 15.00 | 2024-01-17 | 3 | 199.85 | 1 | 600.16 | 1 | SO58932 | 2024-01-24 | 48.01 | 599.56 | 200.05 | |||
SO47366_52 | DD3E-4DAA-BA | PO17545115575 | 19 | 291 | 445 | 155 | 6 | 2022-10-30 | 35.99 | 0.90 | 2022-10-18 | 1 | 24.75 | 1 | 35.99 | 52 | SO47366 | 2022-10-25 | 2.88 | 24.75 | 35.99 | |||
SO46936_12 | 95A0-4327-AA | PO19227121833 | 19 | 284 | 271 | 210 | 6 | 2022-09-29 | 607.00 | 15.17 | 2022-09-17 | 3 | 187.16 | 1 | 607.00 | 12 | SO46936 | 2022-09-24 | 48.56 | 561.47 | 202.33 | |||
SO50245_42 | 28E4-4CC9-BF | PO1914152990 | 19 | 284 | 422 | 66 | 6 | 2023-06-29 | 67.54 | 1.69 | 2023-06-17 | 1 | 49.98 | 1 | 67.54 | 42 | SO50245 | 2023-06-24 | 5.40 | 49.98 | 67.54 | |||
SO49827_17 | E4F0-4B91-84 | PO15312199090 | 19 | 291 | 273 | 299 | 6 | 2023-05-30 | 404.66 | 10.12 | 2023-05-18 | 2 | 187.16 | 1 | 404.66 | 17 | SO49827 | 2023-05-25 | 32.37 | 374.31 | 202.33 | |||
SO53535_15 | 8195-45C7-93 | PO18502176746 | 19 | 291 | 568 | 13 | 154 | 6 | 250.54 | 2023-10-30 | 1670.29 | 35.49 | 2023-10-18 | 5 | 461.44 | 1 | 1419.74 | 15 | SO53535 | 2023-10-25 | 113.58 | 2307.22 | 334.06 | 0.15 |
SO48306_22 | EA27-471A-9D | PO17574166075 | 19 | 291 | 367 | 678 | 6 | 2023-01-29 | 1943.98 | 48.60 | 2023-01-17 | 3 | 598.44 | 1 | 1943.98 | 22 | SO48306 | 2023-01-24 | 155.52 | 1795.31 | 647.99 | |||
SO44534_10 | 07F6-4A99-A3 | PO2146113582 | 19 | 284 | 350 | 2 | 354 | 6 | 469.80 | 2021-12-30 | 23489.93 | 575.50 | 2021-12-18 | 12 | 1898.09 | 1 | 23020.13 | 10 | SO44534 | 2021-12-25 | 1841.61 | 22777.13 | 1957.49 | 0.02 |
SO44288_27 | 6F5C-4E3C-B5 | PO14732190246 | 19 | 288 | 328 | 514 | 6 | 2021-11-29 | 1677.84 | 41.95 | 2021-11-17 | 4 | 413.15 | 1 | 1677.84 | 27 | SO44288 | 2021-11-24 | 134.23 | 1652.59 | 419.46 |
Generated 2024-09-16 05:49:52.461 UTC