[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '10' > SHUFFLE < SKIP 1250 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO59055_3 | 329B-4147-AB | PO6119158372 | 98 | 288 | 471 | 268 | 10 | 2024-02-18 | 152.40 | 3.81 | 2024-02-06 | 4 | 23.75 | 1 | 152.40 | 3 | SO59055 | 2024-02-13 | 12.19 | 95.00 | 38.10 | |||
SO51143_41 | 5AF9-4974-90 | PO8410118711 | 98 | 288 | 582 | 538 | 10 | 2023-09-18 | 2041.19 | 51.03 | 2023-09-06 | 2 | 1082.51 | 1 | 2041.19 | 41 | SO51143 | 2023-09-13 | 163.30 | 2165.02 | 1020.59 | |||
SO50244_38 | 8887-4F96-A3 | PO1508168261 | 98 | 290 | 370 | 430 | 10 | 2023-07-19 | 1466.01 | 36.65 | 2023-07-07 | 1 | 1518.79 | 1 | 1466.01 | 38 | SO50244 | 2023-07-14 | 117.28 | 1518.79 | 1466.01 | |||
SO49510_14 | 34F7-4B7D-88 | PO8468119179 | 98 | 288 | 458 | 16 | 10 | 2023-05-19 | 179.98 | 4.50 | 2023-05-07 | 4 | 30.93 | 1 | 179.98 | 14 | SO49510 | 2023-05-14 | 14.40 | 123.73 | 44.99 | |||
SO46669_24 | 7080-4FDD-BD | PO8410183627 | 98 | 288 | 407 | 538 | 10 | 2022-09-18 | 131.20 | 3.28 | 2022-09-06 | 2 | 48.55 | 1 | 131.20 | 24 | SO46669 | 2022-09-13 | 10.50 | 97.09 | 65.60 | |||
SO55323_39 | 7398-4A3C-BE | PO8410135313 | 98 | 288 | 482 | 538 | 10 | 2023-12-19 | 26.97 | 0.67 | 2023-12-07 | 5 | 3.36 | 1 | 26.97 | 39 | SO55323 | 2023-12-14 | 2.16 | 16.81 | 5.39 | |||
SO53512_13 | 6AC2-4C2F-81 | PO10353157108 | 98 | 290 | 400 | 88 | 10 | 2023-11-19 | 37.15 | 0.93 | 2023-11-07 | 1 | 27.49 | 1 | 37.15 | 13 | SO53512 | 2023-11-14 | 2.97 | 27.49 | 37.15 | |||
SO47004_14 | BB9D-49AE-A9 | PO928175019 | 98 | 290 | 364 | 484 | 10 | 2022-10-19 | 1295.99 | 32.40 | 2022-10-07 | 2 | 598.44 | 1 | 1295.99 | 14 | SO47004 | 2022-10-14 | 103.68 | 1196.87 | 647.99 | |||
SO47006_4 | 142D-4F23-BF | PO957186440 | 98 | 288 | 367 | 376 | 10 | 2022-10-19 | 3239.97 | 81.00 | 2022-10-07 | 5 | 598.44 | 1 | 3239.97 | 4 | SO47006 | 2022-10-14 | 259.20 | 2992.18 | 647.99 | |||
SO63170_7 | 9588-481B-B3 | PO957184615 | 98 | 288 | 357 | 376 | 10 | 2024-04-20 | 1391.99 | 34.80 | 2024-04-08 | 1 | 1265.62 | 1 | 1391.99 | 7 | SO63170 | 2024-04-15 | 111.36 | 1265.62 | 1391.99 | |||
SO61238_18 | 0A37-46F4-8E | PO8410140860 | 98 | 288 | 605 | 538 | 10 | 2024-03-20 | 1295.98 | 32.40 | 2024-03-08 | 4 | 343.65 | 1 | 1295.98 | 18 | SO61238 | 2024-03-15 | 103.68 | 1374.60 | 323.99 | |||
SO51143_13 | 5AF9-4974-90 | PO8410118711 | 98 | 288 | 382 | 538 | 10 | 2023-09-18 | 2689.18 | 67.23 | 2023-09-06 | 4 | 713.08 | 1 | 2689.18 | 13 | SO51143 | 2023-09-13 | 215.13 | 2852.32 | 672.29 | |||
SO49891_27 | 78CA-4790-95 | PO8410166354 | 98 | 288 | 414 | 538 | 10 | 2023-06-19 | 447.09 | 11.18 | 2023-06-07 | 3 | 110.28 | 1 | 447.09 | 27 | SO49891 | 2023-06-14 | 35.77 | 330.85 | 149.03 | |||
SO51815_11 | 9899-4418-B8 | PO8729139087 | 98 | 290 | 603 | 556 | 10 | 2023-10-19 | 72.89 | 1.82 | 2023-10-07 | 1 | 53.94 | 1 | 72.89 | 11 | SO51815 | 2023-10-14 | 5.83 | 53.94 | 72.89 | |||
SO48771_11 | E98F-4302-92 | PO8410125811 | 98 | 288 | 224 | 538 | 10 | 2023-03-21 | 20.75 | 0.52 | 2023-03-09 | 4 | 5.23 | 1 | 20.75 | 11 | SO48771 | 2023-03-16 | 1.66 | 20.92 | 5.19 | |||
SO53577_24 | A44D-449C-80 | PO5713160840 | 98 | 288 | 523 | 52 | 10 | 2023-11-19 | 63.17 | 1.58 | 2023-11-07 | 2 | 23.37 | 1 | 63.17 | 24 | SO53577 | 2023-11-14 | 5.05 | 46.74 | 31.58 | |||
SO71832_26 | 269D-4F59-82 | PO10353140756 | 98 | 288 | 400 | 88 | 10 | 2024-08-19 | 37.15 | 0.93 | 2024-08-07 | 1 | 27.49 | 1 | 37.15 | 26 | SO71832 | 2024-08-14 | 2.97 | 27.49 | 37.15 | |||
SO47009_10 | 8F7C-4372-A2 | PO1508115971 | 98 | 288 | 335 | 430 | 10 | 2022-10-19 | 1409.38 | 35.23 | 2022-10-07 | 3 | 486.71 | 1 | 1409.38 | 10 | SO47009 | 2022-10-14 | 112.75 | 1460.12 | 469.79 | |||
SO63255_3 | AA89-4F8F-A0 | PO8555130097 | 98 | 288 | 474 | 250 | 10 | 2024-04-20 | 83.99 | 2.10 | 2024-04-08 | 2 | 26.18 | 1 | 83.99 | 3 | SO63255 | 2024-04-15 | 6.72 | 52.35 | 41.99 | |||
SO51143_16 | 5AF9-4974-90 | PO8410118711 | 98 | 288 | 408 | 538 | 10 | 2023-09-18 | 144.32 | 3.61 | 2023-09-06 | 2 | 53.40 | 1 | 144.32 | 16 | SO51143 | 2023-09-13 | 11.55 | 106.80 | 72.16 | |||
SO48386_17 | 7AB1-4817-8F | PO8468170337 | 98 | 288 | 233 | 16 | 10 | 2023-02-18 | 57.68 | 1.44 | 2023-02-06 | 2 | 29.08 | 1 | 57.68 | 17 | SO48386 | 2023-02-13 | 4.61 | 58.16 | 28.84 | |||
SO51771_30 | F78B-4D68-8E | PO1508157846 | 98 | 288 | 382 | 430 | 10 | 2023-10-19 | 1344.59 | 33.61 | 2023-10-07 | 2 | 713.08 | 1 | 1344.59 | 30 | SO51771 | 2023-10-14 | 107.57 | 1426.16 | 672.29 | |||
SO47451_23 | 6525-4619-9A | PO8671131661 | 98 | 288 | 297 | 502 | 10 | 2022-11-19 | 4416.87 | 110.42 | 2022-11-07 | 6 | 653.70 | 1 | 4416.87 | 23 | SO47451 | 2022-11-14 | 353.35 | 3922.18 | 736.15 | |||
SO58920_17 | 944F-4219-85 | PO16501139645 | 98 | 288 | 237 | 142 | 10 | 2024-02-18 | 119.98 | 3.00 | 2024-02-06 | 4 | 38.49 | 1 | 119.98 | 17 | SO58920 | 2024-02-13 | 9.60 | 153.97 | 29.99 | |||
SO58920_3 | 944F-4219-85 | PO16501139645 | 98 | 288 | 477 | 142 | 10 | 2024-02-18 | 23.95 | 0.60 | 2024-02-06 | 8 | 1.87 | 1 | 23.95 | 3 | SO58920 | 2024-02-13 | 1.92 | 14.93 | 2.99 | |||
SO69456_33 | CCD9-4C53-AB | PO957172965 | 98 | 288 | 361 | 376 | 10 | 2024-07-19 | 8261.96 | 206.55 | 2024-07-07 | 6 | 1251.98 | 1 | 8261.96 | 33 | SO69456 | 2024-07-14 | 660.96 | 7511.89 | 1376.99 | |||
SO65154_11 | D373-4F8D-B5 | PO19604162014 | 98 | 288 | 359 | 340 | 10 | 2024-05-19 | 5507.98 | 137.70 | 2024-05-07 | 4 | 1251.98 | 1 | 5507.98 | 11 | SO65154 | 2024-05-14 | 440.64 | 5007.93 | 1376.99 | |||
SO51120_28 | 6C2D-4670-B0 | PO10324111289 | 98 | 288 | 550 | 196 | 10 | 2023-09-18 | 149.87 | 3.75 | 2023-09-06 | 1 | 136.79 | 1 | 149.87 | 28 | SO51120 | 2023-09-13 | 11.99 | 136.79 | 149.87 | |||
SO69456_9 | CCD9-4C53-AB | PO957172965 | 98 | 288 | 363 | 376 | 10 | 2024-07-19 | 2753.99 | 68.85 | 2024-07-07 | 2 | 1251.98 | 1 | 2753.99 | 9 | SO69456 | 2024-07-14 | 220.32 | 2503.96 | 1376.99 | |||
SO46669_36 | 7080-4FDD-BD | PO8410183627 | 98 | 288 | 216 | 8 | 538 | 10 | 13.46 | 2022-09-18 | 134.58 | 3.03 | 2022-09-06 | 8 | 13.88 | 1 | 121.12 | 36 | SO46669 | 2022-09-13 | 9.69 | 111.03 | 16.82 | 0.10 |
SO59063_11 | 81BA-420E-80 | PO8468196044 | 98 | 288 | 581 | 16 | 10 | 2024-02-18 | 2041.19 | 51.03 | 2024-02-06 | 2 | 1082.51 | 1 | 2041.19 | 11 | SO59063 | 2024-02-13 | 163.30 | 2165.02 | 1020.59 |
Generated 2024-10-06 11:43:30.975 UTC