[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '7' > SHUFFLE < SKIP 266 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO65226_23 | 55DE-4772-82 | PO15515186601 | 100 | 292 | 384 | 481 | 7 | 2024-06-22 | 672.29 | 16.81 | 2024-06-10 | 1 | 713.08 | 1 | 672.29 | 23 | SO65226 | 2024-06-17 | 53.78 | 713.08 | 672.29 | |||
SO69437_8 | AEEE-4ABB-A6 | PO12702116983 | 100 | 292 | 555 | 175 | 7 | 2024-08-22 | 511.20 | 12.78 | 2024-08-10 | 8 | 47.29 | 1 | 511.20 | 8 | SO69437 | 2024-08-17 | 40.90 | 378.29 | 63.90 | |||
SO57150_24 | 0163-41B3-92 | PO3683172338 | 100 | 292 | 558 | 85 | 7 | 2024-02-22 | 1457.96 | 36.45 | 2024-02-10 | 6 | 179.82 | 1 | 1457.96 | 24 | SO57150 | 2024-02-17 | 116.64 | 1078.89 | 242.99 | |||
SO63216_31 | A61E-4461-B6 | PO12702151034 | 100 | 292 | 231 | 175 | 7 | 2024-05-24 | 119.98 | 3.00 | 2024-05-12 | 4 | 38.49 | 1 | 119.98 | 31 | SO63216 | 2024-05-19 | 9.60 | 153.97 | 29.99 | |||
SO63179_4 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 471 | 2 | 535 | 7 | 8.84 | 2024-05-24 | 441.96 | 10.83 | 2024-05-12 | 12 | 23.75 | 1 | 433.12 | 4 | SO63179 | 2024-05-19 | 34.65 | 284.99 | 36.83 | 0.02 |
SO53478_13 | 6005-4C44-A8 | PO15486115045 | 100 | 292 | 527 | 121 | 7 | 2023-12-23 | 633.72 | 15.84 | 2023-12-11 | 4 | 144.59 | 1 | 633.72 | 13 | SO53478 | 2023-12-18 | 50.70 | 578.38 | 158.43 | |||
SO61258_11 | 9DCB-43A8-8D | PO3509137345 | 36 | 292 | 465 | 139 | 7 | 2024-04-23 | 29.39 | 0.73 | 2024-04-11 | 2 | 9.16 | 1 | 29.39 | 11 | SO61258 | 2024-04-18 | 2.35 | 18.32 | 14.69 | |||
SO49488_13 | AB06-4177-BD | PO15515149078 | 100 | 292 | 325 | 481 | 7 | 2023-06-22 | 1409.38 | 35.23 | 2023-06-10 | 3 | 486.71 | 1 | 1409.38 | 13 | SO49488 | 2023-06-17 | 112.75 | 1460.12 | 469.79 | |||
SO49834_3 | 633E-4103-A3 | PO13485138907 | 100 | 292 | 224 | 265 | 7 | 2023-07-23 | 5.19 | 0.13 | 2023-07-11 | 1 | 5.23 | 1 | 5.19 | 3 | SO49834 | 2023-07-18 | 0.41 | 5.23 | 5.19 | |||
SO53497_1 | 1F74-43F0-9F | PO12673113349 | 100 | 292 | 440 | 499 | 7 | 2023-12-23 | 1717.80 | 42.95 | 2023-12-11 | 2 | 868.63 | 1 | 1717.80 | 1 | SO53497 | 2023-12-18 | 137.42 | 1737.27 | 858.90 | |||
SO49078_16 | 827E-4512-AD | PO2668184206 | 100 | 290 | 356 | 535 | 7 | 2023-05-25 | 2485.70 | 62.14 | 2023-05-13 | 2 | 1117.86 | 1 | 2485.70 | 16 | SO49078 | 2023-05-20 | 198.86 | 2235.71 | 1242.85 | |||
SO58943_15 | 8472-486E-87 | PO12673119602 | 100 | 292 | 382 | 499 | 7 | 2024-03-23 | 4033.76 | 100.84 | 2024-03-11 | 6 | 713.08 | 1 | 4033.76 | 15 | SO58943 | 2024-03-18 | 322.70 | 4278.48 | 672.29 | |||
SO51733_6 | 5E45-4EBB-89 | PO13108175772 | 100 | 292 | 560 | 103 | 7 | 2023-11-22 | 728.91 | 18.22 | 2023-11-10 | 1 | 755.15 | 1 | 728.91 | 6 | SO51733 | 2023-11-17 | 58.31 | 755.15 | 728.91 | |||
SO51858_20 | 3089-4603-B3 | PO3567120722 | 100 | 292 | 498 | 193 | 7 | 2023-11-22 | 1204.69 | 30.12 | 2023-11-10 | 2 | 601.74 | 1 | 1204.69 | 20 | SO51858 | 2023-11-17 | 96.38 | 1203.49 | 602.35 | |||
SO46626_26 | CFB3-4671-A6 | PO13340194893 | 100 | 292 | 233 | 355 | 7 | 2022-10-22 | 86.52 | 2.16 | 2022-10-10 | 3 | 29.08 | 1 | 86.52 | 26 | SO46626 | 2022-10-17 | 6.92 | 87.24 | 28.84 | |||
SO69437_45 | AEEE-4ABB-A6 | PO12702116983 | 100 | 292 | 544 | 175 | 7 | 2024-08-22 | 340.16 | 8.50 | 2024-08-10 | 7 | 35.96 | 1 | 340.16 | 45 | SO69437 | 2024-08-17 | 27.21 | 251.72 | 48.59 | |||
SO51737_6 | 5192-43F7-A8 | PO13311130738 | 100 | 290 | 547 | 301 | 7 | 2023-11-22 | 48.59 | 1.21 | 2023-11-10 | 1 | 35.96 | 1 | 48.59 | 6 | SO51737 | 2023-11-17 | 3.89 | 35.96 | 48.59 | |||
SO71799_16 | EBC1-4D4C-8E | PO15486196616 | 100 | 292 | 555 | 121 | 7 | 2024-09-22 | 63.90 | 1.60 | 2024-09-10 | 1 | 47.29 | 1 | 63.90 | 16 | SO71799 | 2024-09-17 | 5.11 | 47.29 | 63.90 | |||
SO69437_49 | AEEE-4ABB-A6 | PO12702116983 | 100 | 292 | 525 | 175 | 7 | 2024-08-22 | 633.72 | 15.84 | 2024-08-10 | 4 | 144.59 | 1 | 633.72 | 49 | SO69437 | 2024-08-17 | 50.70 | 578.38 | 158.43 | |||
SO63179_33 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 477 | 535 | 7 | 2024-05-24 | 14.97 | 0.37 | 2024-05-12 | 5 | 1.87 | 1 | 14.97 | 33 | SO63179 | 2024-05-19 | 1.20 | 9.33 | 2.99 | |||
SO49876_14 | 9450-4B7F-96 | PO3509138751 | 36 | 292 | 461 | 139 | 7 | 2023-07-23 | 53.99 | 1.35 | 2023-07-11 | 1 | 37.12 | 1 | 53.99 | 14 | SO49876 | 2023-07-18 | 4.32 | 37.12 | 53.99 | |||
SO51742_14 | 1720-457C-B3 | PO12731111072 | 36 | 292 | 544 | 247 | 7 | 2023-11-22 | 97.19 | 2.43 | 2023-11-10 | 2 | 35.96 | 1 | 97.19 | 14 | SO51742 | 2023-11-17 | 7.78 | 71.92 | 48.59 | |||
SO57055_13 | 3CBC-4CD2-B1 | PO13369127604 | 100 | 292 | 604 | 391 | 7 | 2024-02-22 | 647.99 | 16.20 | 2024-02-10 | 2 | 343.65 | 1 | 647.99 | 13 | SO57055 | 2024-02-17 | 51.84 | 687.30 | 323.99 | |||
SO47678_1 | 9125-42C2-9B | PO13485115736 | 100 | 292 | 469 | 265 | 7 | 2023-01-22 | 91.18 | 2.28 | 2023-01-10 | 4 | 15.67 | 1 | 91.18 | 1 | SO47678 | 2023-01-17 | 7.29 | 62.68 | 22.79 | |||
SO46626_23 | CFB3-4671-A6 | PO13340194893 | 100 | 292 | 420 | 355 | 7 | 2022-10-22 | 141.62 | 3.54 | 2022-10-10 | 1 | 104.80 | 1 | 141.62 | 23 | SO46626 | 2022-10-17 | 11.33 | 104.80 | 141.62 | |||
SO63284_13 | E5FB-4341-8A | PO3683186679 | 100 | 292 | 571 | 85 | 7 | 2024-05-24 | 3563.28 | 89.08 | 2024-05-12 | 8 | 461.44 | 1 | 3563.28 | 13 | SO63284 | 2024-05-19 | 285.06 | 3691.56 | 445.41 | |||
SO69426_39 | 4194-45D7-B6 | PO13427130433 | 100 | 292 | 488 | 638 | 7 | 2024-08-22 | 161.97 | 4.05 | 2024-08-10 | 5 | 41.57 | 1 | 161.97 | 39 | SO69426 | 2024-08-17 | 12.96 | 207.86 | 32.39 | |||
SO51737_5 | 5192-43F7-A8 | PO13311130738 | 100 | 290 | 434 | 301 | 7 | 2023-11-22 | 1070.69 | 26.77 | 2023-11-10 | 3 | 360.94 | 1 | 1070.69 | 5 | SO51737 | 2023-11-17 | 85.66 | 1082.83 | 356.90 | |||
SO50225_38 | 6F8E-49A2-A5 | PO12702153410 | 100 | 292 | 409 | 175 | 7 | 2023-08-22 | 418.51 | 10.46 | 2023-08-10 | 2 | 185.82 | 1 | 418.51 | 38 | SO50225 | 2023-08-17 | 33.48 | 371.64 | 209.26 | |||
SO69429_11 | 3A09-48B2-AA | PO13369166572 | 100 | 292 | 604 | 391 | 7 | 2024-08-22 | 323.99 | 8.10 | 2024-08-10 | 1 | 343.65 | 1 | 323.99 | 11 | SO69429 | 2024-08-17 | 25.92 | 343.65 | 323.99 |
Generated 2024-11-09 22:45:51.328 UTC