[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 372 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48778_10 | 4F83-4D59-87 | PO4495173571 | 19 | 291 | 459 | 496 | 6 | 2023-04-25 | 215.98 | 5.40 | 2023-04-13 | 4 | 37.12 | 1 | 215.98 | 10 | SO48778 | 2023-04-20 | 17.28 | 148.48 | 53.99 | |||
SO53509_7 | 4718-4C12-86 | PO11107182902 | 19 | 284 | 217 | 156 | 6 | 2023-12-24 | 146.96 | 3.67 | 2023-12-12 | 7 | 13.09 | 1 | 146.96 | 7 | SO53509 | 2023-12-19 | 11.76 | 91.60 | 20.99 | |||
SO51092_17 | FB68-47B7-9D | PO15312133079 | 19 | 291 | 547 | 299 | 6 | 2023-10-23 | 145.78 | 3.64 | 2023-10-11 | 3 | 35.96 | 1 | 145.78 | 17 | SO51092 | 2023-10-18 | 11.66 | 107.88 | 48.59 | |||
SO65238_22 | 896A-4ED1-B1 | PO10875188169 | 19 | 291 | 463 | 2 | 281 | 6 | 3.12 | 2024-06-23 | 156.25 | 3.83 | 2024-06-11 | 11 | 9.16 | 1 | 153.12 | 22 | SO65238 | 2024-06-18 | 12.25 | 100.75 | 14.20 | 0.02 |
SO53483_36 | A0BE-40E0-81 | PO14761137153 | 19 | 284 | 467 | 408 | 6 | 2023-12-24 | 58.78 | 1.47 | 2023-12-12 | 4 | 9.16 | 1 | 58.78 | 36 | SO53483 | 2023-12-19 | 4.70 | 36.64 | 14.69 | |||
SO50684_2 | 74E9-4949-91 | PO11165153787 | 19 | 291 | 468 | 586 | 6 | 2023-09-23 | 68.38 | 1.71 | 2023-09-11 | 3 | 15.67 | 1 | 68.38 | 2 | SO50684 | 2023-09-18 | 5.47 | 47.01 | 22.79 | |||
SO67268_37 | 9708-4E22-A4 | PO15312122688 | 19 | 291 | 487 | 299 | 6 | 2024-07-24 | 131.98 | 3.30 | 2024-07-12 | 4 | 20.57 | 1 | 131.98 | 37 | SO67268 | 2024-07-19 | 10.56 | 82.27 | 32.99 | |||
SO49482_3 | B4B5-4693-83 | PO11165189258 | 19 | 291 | 358 | 586 | 6 | 2023-06-23 | 2458.92 | 61.47 | 2023-06-11 | 2 | 1105.81 | 1 | 2458.92 | 3 | SO49482 | 2023-06-18 | 196.71 | 2211.62 | 1229.46 | |||
SO49480_23 | BA71-43B7-82 | PO19401115391 | 19 | 291 | 375 | 173 | 6 | 2023-06-23 | 2617.88 | 65.45 | 2023-06-11 | 2 | 1320.68 | 1 | 2617.88 | 23 | SO49480 | 2023-06-18 | 209.43 | 2641.37 | 1308.94 | |||
SO58932_7 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 222 | 2 | 408 | 6 | 4.87 | 2024-03-24 | 243.53 | 5.97 | 2024-03-12 | 12 | 13.09 | 1 | 238.66 | 7 | SO58932 | 2024-03-19 | 19.09 | 157.04 | 20.29 | 0.02 |
SO49106_2 | 5480-4CE8-A3 | PO11020118737 | 19 | 284 | 445 | 336 | 6 | 2023-05-26 | 71.99 | 1.80 | 2023-05-14 | 2 | 24.75 | 1 | 71.99 | 2 | SO49106 | 2023-05-21 | 5.76 | 49.49 | 35.99 | |||
SO53527_55 | 0EBE-4ACB-B5 | PO1798140946 | 19 | 291 | 234 | 10 | 6 | 2023-12-24 | 239.95 | 6.00 | 2023-12-12 | 8 | 38.49 | 1 | 239.95 | 55 | SO53527 | 2023-12-19 | 19.20 | 307.94 | 29.99 | |||
SO49839_10 | 3123-41F3-9B | PO10527179463 | 19 | 284 | 329 | 480 | 6 | 2023-07-24 | 939.59 | 23.49 | 2023-07-12 | 2 | 486.71 | 1 | 939.59 | 10 | SO49839 | 2023-07-19 | 75.17 | 973.41 | 469.79 | |||
SO51839_48 | 411D-4ACA-8E | PO4901195797 | 19 | 284 | 467 | 84 | 6 | 2023-11-23 | 117.55 | 2.94 | 2023-11-11 | 8 | 9.16 | 1 | 117.55 | 48 | SO51839 | 2023-11-18 | 9.40 | 73.27 | 14.69 | |||
SO49140_33 | EFF3-483D-BE | PO4901154744 | 19 | 284 | 381 | 84 | 6 | 2023-05-26 | 600.26 | 15.01 | 2023-05-14 | 1 | 605.65 | 1 | 600.26 | 33 | SO49140 | 2023-05-21 | 48.02 | 605.65 | 600.26 | |||
SO55275_1 | 72C3-4048-BC | PO1711122362 | 19 | 291 | 551 | 245 | 6 | 2024-01-23 | 316.86 | 7.92 | 2024-01-11 | 2 | 144.59 | 1 | 316.86 | 1 | SO55275 | 2024-01-18 | 25.35 | 289.19 | 158.43 | |||
SO69396_6 | 210F-43F3-97 | PO19227139814 | 19 | 284 | 225 | 210 | 6 | 2024-08-23 | 10.79 | 0.27 | 2024-08-11 | 2 | 6.92 | 1 | 10.79 | 6 | SO69396 | 2024-08-18 | 0.86 | 13.84 | 5.39 | |||
SO69479_16 | 3D8D-4908-A6 | PO18328116976 | 19 | 284 | 471 | 2 | 552 | 6 | 10.31 | 2024-08-23 | 515.62 | 12.63 | 2024-08-11 | 14 | 23.75 | 1 | 505.31 | 16 | SO69479 | 2024-08-18 | 40.42 | 332.49 | 36.83 | 0.02 |
SO51791_17 | DAF1-41B6-96 | PO18328158624 | 19 | 284 | 484 | 552 | 6 | 2023-11-23 | 28.62 | 0.72 | 2023-11-11 | 6 | 2.97 | 1 | 28.62 | 17 | SO51791 | 2023-11-18 | 2.29 | 17.84 | 4.77 | |||
SO47964_2 | 5CE9-4D75-8F | PO19459187071 | 19 | 291 | 448 | 334 | 6 | 2023-02-23 | 71.96 | 1.80 | 2023-02-11 | 6 | 8.25 | 1 | 71.96 | 2 | SO47964 | 2023-02-18 | 5.76 | 49.48 | 11.99 | |||
SO69479_1 | 3D8D-4908-A6 | PO18328116976 | 19 | 284 | 604 | 552 | 6 | 2024-08-23 | 323.99 | 8.10 | 2024-08-11 | 1 | 343.65 | 1 | 323.99 | 1 | SO69479 | 2024-08-18 | 25.92 | 343.65 | 323.99 | |||
SO58953_15 | 99EE-491E-BD | PO11107122647 | 19 | 284 | 225 | 156 | 6 | 2024-03-24 | 26.97 | 0.67 | 2024-03-12 | 5 | 6.92 | 1 | 26.97 | 15 | SO58953 | 2024-03-19 | 2.16 | 34.61 | 5.39 | |||
SO46616_27 | 1264-43E6-B7 | PO14732122562 | 19 | 291 | 462 | 514 | 6 | 2022-10-23 | 84.77 | 2.12 | 2022-10-11 | 6 | 9.71 | 1 | 84.77 | 27 | SO46616 | 2022-10-18 | 6.78 | 58.28 | 14.13 | |||
SO46334_1 | F652-4575-B7 | PO17574196050 | 19 | 272 | 300 | 678 | 6 | 2022-09-23 | 1619.52 | 40.49 | 2022-09-11 | 2 | 699.09 | 1 | 1619.52 | 1 | SO46334 | 2022-09-18 | 129.56 | 1398.19 | 809.76 | |||
SO50239_5 | E1A7-444D-BB | PO638156203 | 19 | 291 | 469 | 280 | 6 | 2023-08-23 | 182.35 | 4.56 | 2023-08-11 | 8 | 15.67 | 1 | 182.35 | 5 | SO50239 | 2023-08-18 | 14.59 | 125.37 | 22.79 | |||
SO47696_13 | B251-4D0B-9C | PO1711162591 | 19 | 291 | 427 | 245 | 6 | 2023-01-23 | 1046.28 | 26.16 | 2023-01-11 | 5 | 185.82 | 1 | 1046.28 | 13 | SO47696 | 2023-01-18 | 83.70 | 929.10 | 209.26 | |||
SO47708_41 | 86B1-46A5-95 | PO4495147689 | 19 | 291 | 224 | 496 | 6 | 2023-01-23 | 41.49 | 1.04 | 2023-01-11 | 8 | 5.23 | 1 | 41.49 | 41 | SO47708 | 2023-01-18 | 3.32 | 41.84 | 5.19 | |||
SO61204_20 | E810-4164-82 | PO15312134209 | 19 | 291 | 547 | 299 | 6 | 2024-04-24 | 97.19 | 2.43 | 2024-04-12 | 2 | 35.96 | 1 | 97.19 | 20 | SO61204 | 2024-04-19 | 7.78 | 71.92 | 48.59 | |||
SO53536_30 | 5C09-4051-92 | PO18299189909 | 19 | 291 | 543 | 118 | 6 | 2023-12-24 | 149.02 | 3.73 | 2023-12-12 | 4 | 27.57 | 1 | 149.02 | 30 | SO53536 | 2023-12-19 | 11.92 | 110.27 | 37.25 | |||
SO48744_12 | 15DB-48CD-9B | PO1711156590 | 19 | 291 | 297 | 245 | 6 | 2023-04-25 | 736.15 | 18.40 | 2023-04-13 | 1 | 653.70 | 1 | 736.15 | 12 | SO48744 | 2023-04-20 | 58.89 | 653.70 | 736.15 |
Generated 2024-11-10 08:37:02.335 UTC