[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE < SKIP 6890 > < TAKE 28 >
28 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO58961_40 | 0848-4E9B-81 | PO10411162031 | 100 | 289 | 564 | 182 | 1 | 2024-02-03 | 1430.44 | 35.76 | 2024-01-22 | 1 | 1481.94 | 1 | 1430.44 | 40 | SO58961 | 2024-01-29 | 114.44 | 1481.94 | 1430.44 | |||
SO69521_14 | EAFC-4D00-94 | PO6148143676 | 100 | 289 | 497 | 693 | 1 | 2024-07-04 | 602.35 | 15.06 | 2024-06-22 | 1 | 601.74 | 1 | 602.35 | 14 | SO69521 | 2024-06-29 | 48.19 | 601.74 | 602.35 | |||
SO63202_12 | 5C83-47EE-AA | PO15631193825 | 100 | 282 | 361 | 43 | 1 | 2024-04-05 | 5507.98 | 137.70 | 2024-03-24 | 4 | 1251.98 | 1 | 5507.98 | 12 | SO63202 | 2024-03-31 | 440.64 | 5007.93 | 1376.99 | |||
SO71818_15 | 2FCA-4131-BD | PO12470139718 | 100 | 287 | 564 | 672 | 1 | 2024-08-04 | 12873.98 | 321.85 | 2024-07-23 | 9 | 1481.94 | 1 | 12873.98 | 15 | SO71818 | 2024-07-30 | 1029.92 | 13337.44 | 1430.44 | |||
SO47701_3 | 5718-4DDD-B7 | PO2929114832 | 100 | 289 | 358 | 380 | 1 | 2022-12-04 | 1229.46 | 30.74 | 2022-11-22 | 1 | 1105.81 | 1 | 1229.46 | 3 | SO47701 | 2022-11-29 | 98.36 | 1105.81 | 1229.46 | |||
SO47057_20 | 0D4D-45B2-91 | PO7917141916 | 100 | 287 | 469 | 401 | 1 | 2022-10-04 | 45.59 | 1.14 | 2022-09-22 | 2 | 15.67 | 1 | 45.59 | 20 | SO47057 | 2022-09-29 | 3.65 | 31.34 | 22.79 | |||
SO55241_30 | F7DC-49D7-89 | PO16588188882 | 100 | 289 | 363 | 146 | 1 | 2023-12-04 | 11015.95 | 275.40 | 2023-11-22 | 8 | 1251.98 | 1 | 11015.95 | 30 | SO55241 | 2023-11-29 | 881.28 | 10015.85 | 1376.99 | |||
SO50206_27 | 7656-4E84-B8 | PO16414158832 | 100 | 289 | 456 | 3 | 236 | 1 | 37.12 | 2023-07-04 | 742.40 | 17.63 | 2023-06-22 | 18 | 30.93 | 1 | 705.28 | 27 | SO50206 | 2023-06-29 | 56.42 | 556.80 | 41.24 | 0.05 |
SO53623_5 | 7BBF-43AA-B5 | PO8903169981 | 100 | 293 | 434 | 235 | 1 | 2023-11-04 | 1427.59 | 35.69 | 2023-10-23 | 4 | 360.94 | 1 | 1427.59 | 5 | SO53623 | 2023-10-30 | 114.21 | 1443.77 | 356.90 | |||
SO45041_1 | 0083-444C-8D | PO17458147053 | 100 | 286 | 332 | 577 | 1 | 2022-03-06 | 419.46 | 10.49 | 2022-02-22 | 1 | 413.15 | 1 | 419.46 | 1 | SO45041 | 2022-03-01 | 33.56 | 413.15 | 419.46 | |||
SO50209_40 | D138-4E7C-86 | PO15573136083 | 100 | 293 | 358 | 487 | 1 | 2023-07-04 | 6147.29 | 153.68 | 2023-06-22 | 5 | 1105.81 | 1 | 6147.29 | 40 | SO50209 | 2023-06-29 | 491.78 | 5529.05 | 1229.46 | |||
SO69475_42 | F74A-4967-BA | PO18618162557 | 100 | 286 | 483 | 605 | 1 | 2024-07-04 | 720.00 | 18.00 | 2024-06-22 | 10 | 44.88 | 1 | 720.00 | 42 | SO69475 | 2024-06-29 | 57.60 | 448.80 | 72.00 | |||
SO44554_1 | FEFE-4C28-A1 | PO5742184541 | 100 | 286 | 293 | 541 | 1 | 2022-01-04 | 722.59 | 18.06 | 2021-12-23 | 1 | 623.84 | 1 | 722.59 | 1 | SO44554 | 2021-12-30 | 57.81 | 623.84 | 722.59 | |||
SO71790_3 | 4C33-40F1-BC | PO17487184338 | 100 | 293 | 583 | 692 | 1 | 2024-08-04 | 2041.19 | 51.03 | 2024-07-23 | 2 | 1082.51 | 1 | 2041.19 | 3 | SO71790 | 2024-07-30 | 163.30 | 2165.02 | 1020.59 | |||
SO55299_21 | 0B56-423B-B7 | PO6612171212 | 100 | 286 | 579 | 110 | 1 | 2023-12-04 | 2915.64 | 72.89 | 2023-11-22 | 4 | 755.15 | 1 | 2915.64 | 21 | SO55299 | 2023-11-29 | 233.25 | 3020.60 | 728.91 | |||
SO58966_1 | 9624-4CF6-91 | PO1160166903 | 100 | 289 | 573 | 38 | 1 | 2024-02-03 | 1430.44 | 35.76 | 2024-01-22 | 1 | 1481.94 | 1 | 1430.44 | 1 | SO58966 | 2024-01-29 | 114.44 | 1481.94 | 1430.44 | |||
SO49826_20 | 2EBD-4312-9C | PO16588178669 | 100 | 289 | 364 | 146 | 1 | 2023-06-04 | 1943.98 | 48.60 | 2023-05-23 | 3 | 598.44 | 1 | 1943.98 | 20 | SO49826 | 2023-05-30 | 155.52 | 1795.31 | 647.99 | |||
SO43877_3 | 4ECF-42F2-A7 | PO11919119101 | 100 | 286 | 218 | 73 | 1 | 2021-10-04 | 28.50 | 0.71 | 2021-09-22 | 5 | 3.40 | 1 | 28.50 | 3 | SO43877 | 2021-09-29 | 2.28 | 16.98 | 5.70 | |||
SO71943_1 | E676-4002-A7 | PO9309168525 | 100 | 293 | 573 | 55 | 1 | 2024-08-04 | 4291.33 | 107.28 | 2024-07-23 | 3 | 1481.94 | 1 | 4291.33 | 1 | SO71943 | 2024-07-30 | 343.31 | 4445.81 | 1430.44 | |||
SO49101_9 | 0549-4175-A0 | PO15573181395 | 100 | 293 | 297 | 487 | 1 | 2023-04-06 | 736.15 | 18.40 | 2023-03-25 | 1 | 653.70 | 1 | 736.15 | 9 | SO49101 | 2023-04-01 | 58.89 | 653.70 | 736.15 | |||
SO45542_15 | A757-4830-AE | PO13543153598 | 100 | 287 | 229 | 293 | 1 | 2022-05-04 | 57.68 | 1.44 | 2022-04-22 | 2 | 31.72 | 1 | 57.68 | 15 | SO45542 | 2022-04-29 | 4.61 | 63.45 | 28.84 | |||
SO67321_2 | 7F43-4E4F-8E | PO7076150186 | 100 | 293 | 503 | 505 | 1 | 2024-06-04 | 400.10 | 10.00 | 2024-05-23 | 2 | 199.85 | 1 | 400.10 | 2 | SO67321 | 2024-05-30 | 32.01 | 399.70 | 200.05 | |||
SO44483_3 | 678B-447B-A1 | PO19981138202 | 100 | 286 | 223 | 271 | 1 | 2022-01-04 | 10.37 | 0.26 | 2021-12-23 | 2 | 5.71 | 1 | 10.37 | 3 | SO44483 | 2021-12-30 | 0.83 | 11.41 | 5.19 | |||
SO53452_8 | B555-4FD7-8B | PO870113712 | 100 | 286 | 556 | 621 | 1 | 2023-11-04 | 421.18 | 10.53 | 2023-10-23 | 4 | 77.92 | 1 | 421.18 | 8 | SO53452 | 2023-10-30 | 33.69 | 311.67 | 105.29 | |||
SO61183_1 | DD50-4E3B-A0 | PO16443112850 | 100 | 289 | 491 | 398 | 1 | 2024-03-05 | 32.39 | 0.81 | 2024-02-22 | 1 | 41.57 | 1 | 32.39 | 1 | SO61183 | 2024-02-29 | 2.59 | 41.57 | 32.39 | |||
SO65268_20 | E14C-42AB-92 | PO9309127032 | 100 | 293 | 574 | 55 | 1 | 2024-05-04 | 1430.44 | 35.76 | 2024-04-22 | 1 | 1481.94 | 1 | 1430.44 | 20 | SO65268 | 2024-04-29 | 114.44 | 1481.94 | 1430.44 | |||
SO53500_11 | BEF0-4525-AF | PO12470126979 | 100 | 287 | 495 | 672 | 1 | 2023-11-04 | 1204.69 | 30.12 | 2023-10-23 | 2 | 601.74 | 1 | 1204.69 | 11 | SO53500 | 2023-10-30 | 96.38 | 1203.49 | 602.35 | |||
SO47444_11 | 4361-4317-91 | PO7946191257 | 100 | 282 | 325 | 438 | 1 | 2022-11-04 | 1409.38 | 35.23 | 2022-10-23 | 3 | 486.71 | 1 | 1409.38 | 11 | SO47444 | 2022-10-30 | 112.75 | 1460.12 | 469.79 |
Generated 2024-09-21 08:31:13.938 UTC