[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SKIP 5000 SHUFFLE SKIP 0 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO69441_7 | F156-4EE0-B0 | PO11745165450 | 100 | 282 | 605 | 97 | 4 | 2024-08-23 | 323.99 | 8.10 | 2024-08-11 | 1 | 343.65 | 1 | 323.99 | 7 | SO69441 | 2024-08-18 | 25.92 | 343.65 | 323.99 |
SO57168_24 | B6D5-41ED-B9 | PO3480129742 | 100 | 281 | 471 | 436 | 4 | 2024-02-23 | 342.90 | 8.57 | 2024-02-11 | 9 | 23.75 | 1 | 342.90 | 24 | SO57168 | 2024-02-18 | 27.43 | 213.74 | 38.10 |
SO49498_19 | D9E7-4090-86 | PO16472151816 | 100 | 287 | 286 | 239 | 4 | 2023-06-23 | 183.94 | 4.60 | 2023-06-11 | 1 | 170.14 | 1 | 183.94 | 19 | SO49498 | 2023-06-18 | 14.72 | 170.14 | 183.94 |
SO67307_1 | ED03-4D31-93 | PO14413128868 | 100 | 287 | 481 | 383 | 4 | 2024-07-24 | 26.97 | 0.67 | 2024-07-12 | 5 | 3.36 | 1 | 26.97 | 1 | SO67307 | 2024-07-19 | 2.16 | 16.81 | 5.39 |
SO57153_6 | 6322-496F-9C | PO3219142707 | 100 | 282 | 384 | 493 | 4 | 2024-02-23 | 1344.59 | 33.61 | 2024-02-11 | 2 | 713.08 | 1 | 1344.59 | 6 | SO57153 | 2024-02-18 | 107.57 | 1426.16 | 672.29 |
SO50738_28 | 531C-4E52-80 | PO3915159731 | 100 | 281 | 230 | 130 | 4 | 2023-09-23 | 144.20 | 3.61 | 2023-09-11 | 5 | 29.08 | 1 | 144.20 | 28 | SO50738 | 2023-09-18 | 11.54 | 145.40 | 28.84 |
SO63251_14 | CA03-47EE-90 | PO6525146360 | 100 | 281 | 524 | 345 | 4 | 2024-05-25 | 316.86 | 7.92 | 2024-05-13 | 2 | 144.59 | 1 | 316.86 | 14 | SO63251 | 2024-05-20 | 25.35 | 289.19 | 158.43 |
SO55264_28 | 80F3-4A7B-A2 | PO10730163005 | 100 | 287 | 434 | 491 | 4 | 2024-01-23 | 1784.49 | 44.61 | 2024-01-11 | 5 | 360.94 | 1 | 1784.49 | 28 | SO55264 | 2024-01-18 | 142.76 | 1804.71 | 356.90 |
SO55276_14 | 81AA-41E5-B0 | PO2755182998 | 100 | 282 | 499 | 205 | 4 | 2024-01-23 | 4818.77 | 120.47 | 2024-01-11 | 8 | 601.74 | 1 | 4818.77 | 14 | SO55276 | 2024-01-18 | 385.50 | 4813.95 | 602.35 |
SO63262_8 | 3368-4317-8F | PO6351144702 | 100 | 281 | 388 | 255 | 4 | 2024-05-25 | 1344.59 | 33.61 | 2024-05-13 | 2 | 713.08 | 1 | 1344.59 | 8 | SO63262 | 2024-05-20 | 107.57 | 1426.16 | 672.29 |
SO57128_17 | 52E0-4277-80 | PO6525176590 | 100 | 281 | 544 | 345 | 4 | 2024-02-23 | 97.19 | 2.43 | 2024-02-11 | 2 | 35.96 | 1 | 97.19 | 17 | SO57128 | 2024-02-18 | 7.78 | 71.92 | 48.59 |
SO63285_11 | 6316-44BB-8E | PO3480176259 | 100 | 281 | 547 | 436 | 4 | 2024-05-25 | 97.19 | 2.43 | 2024-05-13 | 2 | 35.96 | 1 | 97.19 | 11 | SO63285 | 2024-05-20 | 7.78 | 71.92 | 48.59 |
SO67290_14 | 763C-4FCC-8E | PO10237115936 | 100 | 287 | 606 | 41 | 4 | 2024-07-24 | 1295.98 | 32.40 | 2024-07-12 | 4 | 343.65 | 1 | 1295.98 | 14 | SO67290 | 2024-07-19 | 103.68 | 1374.60 | 323.99 |
SO49821_23 | 0B9B-460C-BC | PO551117366 | 100 | 281 | 377 | 4 | 4 | 2023-07-24 | 3926.81 | 98.17 | 2023-07-12 | 3 | 1320.68 | 1 | 3926.81 | 23 | SO49821 | 2023-07-19 | 314.15 | 3962.05 | 1308.94 |
SO47434_19 | 6848-4C33-98 | PO5539145068 | 100 | 282 | 459 | 61 | 4 | 2022-12-24 | 161.98 | 4.05 | 2022-12-12 | 3 | 37.12 | 1 | 161.98 | 19 | SO47434 | 2022-12-19 | 12.96 | 111.36 | 53.99 |
SO58984_1 | 5D72-43BF-AB | PO16153135798 | 100 | 282 | 560 | 186 | 4 | 2024-03-24 | 1457.82 | 36.45 | 2024-03-12 | 2 | 755.15 | 1 | 1457.82 | 1 | SO58984 | 2024-03-19 | 116.63 | 1510.30 | 728.91 |
SO53621_54 | 9324-4A3D-83 | PO9715186811 | 100 | 281 | 525 | 490 | 4 | 2023-12-24 | 792.15 | 19.80 | 2023-12-12 | 5 | 144.59 | 1 | 792.15 | 54 | SO53621 | 2023-12-19 | 63.37 | 722.97 | 158.43 |
SO49058_7 | BD1B-4C7F-A9 | PO12499147561 | 100 | 282 | 224 | 78 | 4 | 2023-05-26 | 31.12 | 0.78 | 2023-05-14 | 6 | 5.23 | 1 | 31.12 | 7 | SO49058 | 2023-05-21 | 2.49 | 31.38 | 5.19 |
SO49506_3 | A1B2-45C6-A2 | PO13717198252 | 100 | 287 | 216 | 473 | 4 | 2023-06-23 | 20.19 | 0.50 | 2023-06-11 | 1 | 13.88 | 1 | 20.19 | 3 | SO49506 | 2023-06-18 | 1.61 | 13.88 | 20.19 |
SO47355_45 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 407 | 24 | 4 | 2022-12-24 | 393.61 | 9.84 | 2022-12-12 | 6 | 48.55 | 1 | 393.61 | 45 | SO47355 | 2022-12-19 | 31.49 | 291.27 | 65.60 |
SO53460_41 | 3BD9-47C3-94 | PO19343112747 | 100 | 282 | 442 | 24 | 4 | 2023-12-24 | 2576.70 | 64.42 | 2023-12-12 | 3 | 868.63 | 1 | 2576.70 | 41 | SO53460 | 2023-12-19 | 206.14 | 2605.90 | 858.90 |
SO49099_19 | D567-4CCE-A4 | PO15689170019 | 100 | 281 | 368 | 328 | 4 | 2023-05-26 | 8796.06 | 219.90 | 2023-05-14 | 6 | 1518.79 | 1 | 8796.06 | 19 | SO49099 | 2023-05-21 | 703.68 | 9112.72 | 1466.01 |
SO61236_6 | 1CCD-453C-A4 | PO10237145027 | 100 | 287 | 606 | 41 | 4 | 2024-04-24 | 323.99 | 8.10 | 2024-04-12 | 1 | 343.65 | 1 | 323.99 | 6 | SO61236 | 2024-04-19 | 25.92 | 343.65 | 323.99 |
SO57085_26 | D1E5-454C-85 | PO2523188219 | 100 | 287 | 222 | 167 | 4 | 2024-02-23 | 83.98 | 2.10 | 2024-02-11 | 4 | 13.09 | 1 | 83.98 | 26 | SO57085 | 2024-02-18 | 6.72 | 52.35 | 20.99 |
SO50672_44 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 458 | 239 | 4 | 2023-09-23 | 404.95 | 10.12 | 2023-09-11 | 9 | 30.93 | 1 | 404.95 | 44 | SO50672 | 2023-09-18 | 32.40 | 278.40 | 44.99 |
SO59026_1 | 6264-4C83-B2 | PO4002182599 | 100 | 282 | 483 | 674 | 4 | 2024-03-24 | 288.00 | 7.20 | 2024-03-12 | 4 | 44.88 | 1 | 288.00 | 1 | SO59026 | 2024-03-19 | 23.04 | 179.52 | 72.00 |
SO48740_6 | 158B-4BBF-9F | PO551143768 | 100 | 281 | 337 | 4 | 4 | 2023-04-25 | 3758.35 | 93.96 | 2023-04-13 | 8 | 486.71 | 1 | 3758.35 | 6 | SO48740 | 2023-04-20 | 300.67 | 3893.65 | 469.79 |
SO48396_4 | F55B-45AE-8B | PO9715142000 | 100 | 283 | 305 | 490 | 4 | 2023-03-25 | 736.15 | 18.40 | 2023-03-13 | 1 | 653.70 | 1 | 736.15 | 4 | SO48396 | 2023-03-20 | 58.89 | 653.70 | 736.15 |
SO49152_21 | 52FC-4E8F-B0 | PO6525119586 | 100 | 272 | 364 | 345 | 4 | 2023-05-26 | 647.99 | 16.20 | 2023-05-14 | 1 | 598.44 | 1 | 647.99 | 21 | SO49152 | 2023-05-21 | 51.84 | 598.44 | 647.99 |
SO47405_1 | F397-4649-8A | PO348128434 | 100 | 282 | 239 | 609 | 4 | 2022-12-24 | 780.82 | 19.52 | 2022-12-12 | 1 | 722.26 | 1 | 780.82 | 1 | SO47405 | 2022-12-19 | 62.47 | 722.26 | 780.82 |
SO57145_13 | 4C59-4193-B1 | PO3654153385 | 100 | 281 | 501 | 435 | 4 | 2024-02-23 | 72.88 | 1.82 | 2024-02-11 | 1 | 53.93 | 1 | 72.88 | 13 | SO57145 | 2024-02-18 | 5.83 | 53.93 | 72.88 |
Generated 2024-11-10 19:19:39.782 UTC