[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SKIP 0 SHUFFLE < SKIP 1131 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO71791_6 | AB1B-4CE2-BA | PO17139191080 | 100 | 293 | 390 | 644 | 1 | 2024-09-23 | 2016.88 | 50.42 | 2024-09-11 | 3 | 713.08 | 1 | 2016.88 | 6 | SO71791 | 2024-09-18 | 161.35 | 2139.24 | 672.29 | |||
SO69471_13 | 2CF9-42DE-B1 | PO18676191433 | 100 | 282 | 400 | 697 | 1 | 2024-08-23 | 111.46 | 2.79 | 2024-08-11 | 3 | 27.49 | 1 | 111.46 | 13 | SO69471 | 2024-08-18 | 8.92 | 82.48 | 37.15 | |||
SO63131_7 | E035-4732-84 | PO18676136384 | 100 | 282 | 363 | 697 | 1 | 2024-05-25 | 11015.95 | 275.40 | 2024-05-13 | 8 | 1251.98 | 1 | 11015.95 | 7 | SO63131 | 2024-05-20 | 881.28 | 10015.85 | 1376.99 | |||
SO71880_17 | B0C7-4858-91 | PO7395117544 | 100 | 286 | 476 | 542 | 1 | 2024-09-23 | 293.96 | 7.35 | 2024-09-11 | 7 | 26.18 | 1 | 293.96 | 17 | SO71880 | 2024-09-18 | 23.52 | 183.23 | 41.99 | |||
SO69475_25 | F74A-4967-BA | PO18618162557 | 100 | 286 | 234 | 605 | 1 | 2024-08-23 | 299.94 | 7.50 | 2024-08-11 | 10 | 38.49 | 1 | 299.94 | 25 | SO69475 | 2024-08-18 | 24.00 | 384.92 | 29.99 | |||
SO51127_26 | D321-4FEA-80 | PO2552155165 | 100 | 286 | 531 | 506 | 1 | 2023-10-23 | 599.50 | 14.99 | 2023-10-11 | 4 | 136.79 | 1 | 599.50 | 26 | SO51127 | 2023-10-18 | 47.96 | 547.14 | 149.87 | |||
SO65234_19 | 3BB7-4A9F-AF | PO10411160249 | 100 | 289 | 558 | 182 | 1 | 2024-06-23 | 1214.97 | 30.37 | 2024-06-11 | 5 | 179.82 | 1 | 1214.97 | 19 | SO65234 | 2024-06-18 | 97.20 | 899.08 | 242.99 | |||
SO46649_12 | A093-4C86-B7 | PO2929149182 | 100 | 289 | 428 | 380 | 1 | 2022-10-23 | 418.51 | 10.46 | 2022-10-11 | 2 | 185.82 | 1 | 418.51 | 12 | SO46649 | 2022-10-18 | 33.48 | 371.64 | 209.26 | |||
SO71836_24 | E41E-40C1-84 | PO841118259 | 100 | 286 | 359 | 254 | 1 | 2024-09-23 | 8261.96 | 206.55 | 2024-09-11 | 6 | 1251.98 | 1 | 8261.96 | 24 | SO71836 | 2024-09-18 | 660.96 | 7511.89 | 1376.99 | |||
SO51783_27 | B7A2-49BC-89 | PO18676114917 | 100 | 282 | 361 | 697 | 1 | 2023-11-23 | 4130.98 | 103.27 | 2023-11-11 | 3 | 1251.98 | 1 | 4130.98 | 27 | SO51783 | 2023-11-18 | 330.48 | 3755.94 | 1376.99 | |||
SO49852_6 | 5DD7-447A-8D | PO2581189096 | 100 | 282 | 343 | 698 | 1 | 2023-07-24 | 939.59 | 23.49 | 2023-07-12 | 2 | 486.71 | 1 | 939.59 | 6 | SO49852 | 2023-07-19 | 75.17 | 973.41 | 469.79 | |||
SO53518_47 | 5712-444B-BC | PO841197199 | 100 | 286 | 591 | 254 | 1 | 2023-12-24 | 677.99 | 16.95 | 2023-12-12 | 2 | 308.22 | 1 | 677.99 | 47 | SO53518 | 2023-12-19 | 54.24 | 616.44 | 338.99 | |||
SO44563_27 | 9AFF-40A9-96 | PO7627161014 | 100 | 286 | 326 | 433 | 1 | 2022-02-23 | 838.92 | 20.97 | 2022-02-11 | 2 | 413.15 | 1 | 838.92 | 27 | SO44563 | 2022-02-18 | 67.11 | 826.29 | 419.46 | |||
SO44563_7 | 9AFF-40A9-96 | PO7627161014 | 100 | 286 | 313 | 433 | 1 | 2022-02-23 | 4293.92 | 107.35 | 2022-02-11 | 2 | 2171.29 | 1 | 4293.92 | 7 | SO44563 | 2022-02-18 | 343.51 | 4342.59 | 2146.96 | |||
SO53569_11 | 113E-43AD-94 | PO9309141312 | 100 | 293 | 552 | 55 | 1 | 2023-12-24 | 109.79 | 2.74 | 2023-12-12 | 2 | 40.62 | 1 | 109.79 | 11 | SO53569 | 2023-12-19 | 8.78 | 81.24 | 54.89 | |||
SO50209_37 | D138-4E7C-86 | PO15573136083 | 100 | 293 | 294 | 487 | 1 | 2023-08-23 | 744.27 | 18.61 | 2023-08-11 | 1 | 660.91 | 1 | 744.27 | 37 | SO50209 | 2023-08-18 | 59.54 | 660.91 | 744.27 | |||
SO50299_2 | 0946-4A09-8C | PO5046193357 | 100 | 289 | 289 | 596 | 1 | 2023-08-23 | 744.27 | 18.61 | 2023-08-11 | 1 | 660.91 | 1 | 744.27 | 2 | SO50299 | 2023-08-18 | 59.54 | 660.91 | 744.27 | |||
SO69413_6 | E8F8-4282-9E | PO15631191114 | 100 | 282 | 476 | 2 | 43 | 1 | 9.74 | 2024-08-23 | 487.13 | 11.93 | 2024-08-11 | 12 | 26.18 | 1 | 477.39 | 6 | SO69413 | 2024-08-18 | 38.19 | 314.12 | 40.59 | 0.02 |
SO53571_17 | 89B3-4B87-A8 | PO7482124191 | 100 | 293 | 561 | 14 | 163 | 1 | 2097.98 | 2023-12-24 | 10489.91 | 209.80 | 2023-12-12 | 11 | 1481.94 | 1 | 8391.93 | 17 | SO53571 | 2023-12-19 | 671.35 | 16301.32 | 953.63 | 0.20 |
SO46667_3 | D3CD-4A6E-94 | PO7105131549 | 100 | 286 | 263 | 668 | 1 | 2022-10-23 | 607.00 | 15.17 | 2022-10-11 | 3 | 187.16 | 1 | 607.00 | 3 | SO46667 | 2022-10-18 | 48.56 | 561.47 | 202.33 | |||
SO44492_16 | 8AF8-4DDE-A8 | PO18676158978 | 100 | 282 | 223 | 697 | 1 | 2022-02-23 | 5.19 | 0.13 | 2022-02-11 | 1 | 5.71 | 1 | 5.19 | 16 | SO44492 | 2022-02-18 | 0.41 | 5.71 | 5.19 | |||
SO44771_3 | A78D-40A1-9E | PO783176074 | 100 | 286 | 328 | 91 | 1 | 2022-03-25 | 419.46 | 10.49 | 2022-03-13 | 1 | 413.15 | 1 | 419.46 | 3 | SO44771 | 2022-03-20 | 33.56 | 413.15 | 419.46 | |||
SO58962_11 | 12B1-4451-9A | PO870180310 | 100 | 286 | 573 | 621 | 1 | 2024-03-24 | 4291.33 | 107.28 | 2024-03-12 | 3 | 1481.94 | 1 | 4291.33 | 11 | SO58962 | 2024-03-19 | 343.31 | 4445.81 | 1430.44 | |||
SO65211_3 | EB20-45B3-BC | PO3277163623 | 100 | 293 | 583 | 604 | 1 | 2024-06-23 | 1020.59 | 25.51 | 2024-06-11 | 1 | 1082.51 | 1 | 1020.59 | 3 | SO65211 | 2024-06-18 | 81.65 | 1082.51 | 1020.59 | |||
SO44788_11 | 4CD8-41D6-AE | PO5220181334 | 100 | 282 | 218 | 169 | 1 | 2022-03-25 | 28.50 | 0.71 | 2022-03-13 | 5 | 3.40 | 1 | 28.50 | 11 | SO44788 | 2022-03-20 | 2.28 | 16.98 | 5.70 | |||
SO45296_10 | 1FA6-4616-B7 | PO14471199142 | 100 | 286 | 296 | 145 | 1 | 2022-05-26 | 714.70 | 17.87 | 2022-05-14 | 1 | 617.03 | 1 | 714.70 | 10 | SO45296 | 2022-05-21 | 57.18 | 617.03 | 714.70 | |||
SO51821_1 | 1CCD-45D4-80 | PO7917148134 | 100 | 287 | 465 | 401 | 1 | 2023-11-23 | 29.39 | 0.73 | 2023-11-11 | 2 | 9.16 | 1 | 29.39 | 1 | SO51821 | 2023-11-18 | 2.35 | 18.32 | 14.69 | |||
SO49826_31 | 2EBD-4312-9C | PO16588178669 | 100 | 289 | 358 | 146 | 1 | 2023-07-24 | 12294.59 | 307.36 | 2023-07-12 | 10 | 1105.81 | 1 | 12294.59 | 31 | SO49826 | 2023-07-19 | 983.57 | 11058.10 | 1229.46 |
Generated 2024-11-10 22:21:42.023 UTC