[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE < SKIP 384 > < TAKE 28 >
28 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46604_8 | 8062-4A97-B3 | PO522154989 | 100 | 285 | 356 | 676 | 5 | 2022-09-02 | 1242.85 | 31.07 | 2022-08-21 | 1 | 1117.86 | 1 | 1242.85 | 8 | SO46604 | 2022-08-28 | 99.43 | 1117.86 | 1242.85 |
SO47726_18 | 7256-4599-93 | PO9657190563 | 100 | 285 | 456 | 315 | 5 | 2022-12-03 | 89.99 | 2.25 | 2022-11-21 | 2 | 30.93 | 1 | 89.99 | 18 | SO47726 | 2022-11-28 | 7.20 | 61.87 | 44.99 |
SO44763_1 | 42FB-4859-8F | PO11977198048 | 100 | 285 | 275 | 675 | 5 | 2022-02-02 | 356.90 | 8.92 | 2022-01-21 | 1 | 352.14 | 1 | 356.90 | 1 | SO44763 | 2022-01-28 | 28.55 | 352.14 | 356.90 |
SO44506_6 | CD67-4B07-B6 | PO16327113845 | 100 | 285 | 336 | 584 | 5 | 2022-01-03 | 419.46 | 10.49 | 2021-12-22 | 1 | 413.15 | 1 | 419.46 | 6 | SO44506 | 2021-12-29 | 33.56 | 413.15 | 419.46 |
SO55234_46 | C6FC-46EE-88 | PO522140495 | 100 | 285 | 309 | 676 | 5 | 2023-12-03 | 1637.40 | 40.94 | 2023-11-21 | 2 | 747.20 | 1 | 1637.40 | 46 | SO55234 | 2023-11-28 | 130.99 | 1494.40 | 818.70 |
SO44304_6 | D34C-4225-A3 | PO10179168311 | 100 | 285 | 300 | 27 | 5 | 2021-12-03 | 809.76 | 20.24 | 2021-11-21 | 1 | 699.09 | 1 | 809.76 | 6 | SO44304 | 2021-11-28 | 64.78 | 699.09 | 809.76 |
SO47726_29 | 7256-4599-93 | PO9657190563 | 100 | 285 | 221 | 315 | 5 | 2022-12-03 | 80.75 | 2.02 | 2022-11-21 | 4 | 13.88 | 1 | 80.75 | 29 | SO47726 | 2022-11-28 | 6.46 | 55.51 | 20.19 |
SO46099_3 | 7E3B-4362-99 | PO7598165395 | 100 | 285 | 241 | 45 | 5 | 2022-07-03 | 2274.23 | 56.86 | 2022-06-21 | 3 | 747.97 | 1 | 2274.23 | 3 | SO46099 | 2022-06-28 | 181.94 | 2243.90 | 758.08 |
SO44562_4 | 1856-47B2-AD | PO7598190472 | 100 | 285 | 342 | 45 | 5 | 2022-01-03 | 838.92 | 20.97 | 2021-12-22 | 2 | 413.15 | 1 | 838.92 | 4 | SO44562 | 2021-12-29 | 67.11 | 826.29 | 419.46 |
SO58971_40 | 319A-4CAC-B1 | PO1537134870 | 100 | 285 | 237 | 611 | 5 | 2024-02-02 | 89.98 | 2.25 | 2024-01-21 | 3 | 38.49 | 1 | 89.98 | 40 | SO58971 | 2024-01-28 | 7.20 | 115.48 | 29.99 |
SO61230_27 | B9F1-4FF8-B4 | PO12644163346 | 100 | 285 | 596 | 530 | 5 | 2024-03-04 | 971.98 | 24.30 | 2024-02-21 | 3 | 294.58 | 1 | 971.98 | 27 | SO61230 | 2024-02-28 | 77.76 | 883.74 | 323.99 |
SO43693_7 | EC62-4BB3-9B | PO8120182325 | 100 | 281 | 347 | 485 | 5 | 2021-09-02 | 2039.99 | 51.00 | 2021-08-21 | 1 | 1912.15 | 1 | 2039.99 | 7 | SO43693 | 2021-08-28 | 163.20 | 1912.15 | 2039.99 |
SO44309_7 | F0DB-4889-AC | PO3393112350 | 100 | 285 | 334 | 549 | 5 | 2021-12-03 | 2097.29 | 52.43 | 2021-11-21 | 5 | 413.15 | 1 | 2097.29 | 7 | SO44309 | 2021-11-28 | 167.78 | 2065.73 | 419.46 |
SO50726_12 | A80B-408E-B3 | PO9599192861 | 100 | 285 | 337 | 170 | 5 | 2023-08-03 | 2818.76 | 70.47 | 2023-07-22 | 6 | 486.71 | 1 | 2818.76 | 12 | SO50726 | 2023-07-29 | 225.50 | 2920.24 | 469.79 |
SO46090_15 | 987E-4B5B-B6 | PO5858172038 | 100 | 285 | 215 | 566 | 5 | 2022-07-03 | 40.37 | 1.01 | 2022-06-21 | 2 | 12.03 | 1 | 40.37 | 15 | SO46090 | 2022-06-28 | 3.23 | 24.06 | 20.19 |
SO53524_43 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 497 | 611 | 5 | 2023-11-03 | 602.35 | 15.06 | 2023-10-22 | 1 | 601.74 | 1 | 602.35 | 43 | SO53524 | 2023-10-29 | 48.19 | 601.74 | 602.35 |
SO51775_2 | 5DF8-4C96-81 | PO2842127356 | 100 | 285 | 472 | 700 | 5 | 2023-10-03 | 114.30 | 2.86 | 2023-09-21 | 3 | 23.75 | 1 | 114.30 | 2 | SO51775 | 2023-09-28 | 9.14 | 71.25 | 38.10 |
SO71839_13 | 8F89-4B1E-A8 | PO1537119063 | 100 | 285 | 497 | 611 | 5 | 2024-08-03 | 1204.69 | 30.12 | 2024-07-22 | 2 | 601.74 | 1 | 1204.69 | 13 | SO71839 | 2024-07-29 | 96.38 | 1203.49 | 602.35 |
SO47457_4 | 37E5-4B0F-9D | PO9744168861 | 100 | 285 | 419 | 98 | 5 | 2022-11-03 | 52.65 | 1.32 | 2022-10-22 | 1 | 38.96 | 1 | 52.65 | 4 | SO47457 | 2022-10-29 | 4.21 | 38.96 | 52.65 |
SO69485_3 | E19F-443F-BB | PO16211116121 | 100 | 285 | 359 | 99 | 5 | 2024-07-03 | 2753.99 | 68.85 | 2024-06-21 | 2 | 1251.98 | 1 | 2753.99 | 3 | SO69485 | 2024-06-28 | 220.32 | 2503.96 | 1376.99 |
SO63124_7 | 5CAE-4C1D-85 | PO19546167735 | 100 | 285 | 582 | 206 | 5 | 2024-04-04 | 1020.59 | 25.51 | 2024-03-23 | 1 | 1082.51 | 1 | 1020.59 | 7 | SO63124 | 2024-03-30 | 81.65 | 1082.51 | 1020.59 |
SO58987_7 | 9A04-4070-80 | PO18241161045 | 100 | 285 | 564 | 477 | 5 | 2024-02-02 | 2860.88 | 71.52 | 2024-01-21 | 2 | 1481.94 | 1 | 2860.88 | 7 | SO58987 | 2024-01-28 | 228.87 | 2963.88 | 1430.44 |
SO49091_3 | 7A94-486D-8A | PO19546118667 | 100 | 285 | 370 | 206 | 5 | 2023-04-05 | 4398.03 | 109.95 | 2023-03-24 | 3 | 1518.79 | 1 | 4398.03 | 3 | SO49091 | 2023-03-31 | 351.84 | 4556.36 | 1466.01 |
SO51108_29 | 8650-4A20-B1 | PO12644151814 | 100 | 285 | 587 | 530 | 5 | 2023-09-02 | 923.39 | 23.08 | 2023-08-21 | 2 | 419.78 | 1 | 923.39 | 29 | SO51108 | 2023-08-28 | 73.87 | 839.56 | 461.69 |
SO47693_27 | 3962-4A1A-93 | PO522165713 | 100 | 285 | 468 | 676 | 5 | 2022-12-03 | 68.38 | 1.71 | 2022-11-21 | 3 | 15.67 | 1 | 68.38 | 27 | SO47693 | 2022-11-28 | 5.47 | 47.01 | 22.79 |
SO65242_1 | 0175-4222-B3 | PO14297142992 | 100 | 285 | 563 | 627 | 5 | 2024-05-03 | 2860.88 | 71.52 | 2024-04-21 | 2 | 1481.94 | 1 | 2860.88 | 1 | SO65242 | 2024-04-28 | 228.87 | 2963.88 | 1430.44 |
SO45814_5 | 9844-4839-BA | PO8120138004 | 100 | 272 | 347 | 485 | 5 | 2022-06-03 | 8159.98 | 204.00 | 2022-05-22 | 4 | 1912.15 | 1 | 8159.98 | 5 | SO45814 | 2022-05-29 | 652.80 | 7648.62 | 2039.99 |
SO48760_9 | D682-4FD4-94 | PO9657199450 | 100 | 285 | 420 | 315 | 5 | 2023-03-05 | 141.62 | 3.54 | 2023-02-21 | 1 | 104.80 | 1 | 141.62 | 9 | SO48760 | 2023-02-28 | 11.33 | 104.80 | 141.62 |
Generated 2024-09-21 00:32:58.036 UTC