[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE SKIP 2000 < SKIP 531 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44564_5 | 142F-443C-90 | PO7656157194 | 100 | 282 | 229 | 403 | 4 | 2022-02-24 | 28.84 | 0.72 | 2022-02-12 | 1 | 31.72 | 1 | 28.84 | 5 | SO44564 | 2022-02-19 | 2.31 | 31.72 | 28.84 | |||
SO48397_24 | A1DC-424B-A8 | PO9686169278 | 100 | 282 | 421 | 457 | 4 | 2023-03-26 | 1177.97 | 29.45 | 2023-03-14 | 6 | 145.28 | 1 | 1177.97 | 24 | SO48397 | 2023-03-21 | 94.24 | 871.70 | 196.33 | |||
SO45291_11 | 3865-4B93-A6 | PO15689110696 | 100 | 283 | 332 | 328 | 4 | 2022-05-27 | 1677.84 | 41.95 | 2022-05-15 | 4 | 413.15 | 1 | 1677.84 | 11 | SO45291 | 2022-05-22 | 134.23 | 1652.59 | 419.46 | |||
SO65157_22 | 51FF-4A62-89 | PO19372154832 | 100 | 282 | 555 | 582 | 4 | 2024-06-24 | 63.90 | 1.60 | 2024-06-12 | 1 | 47.29 | 1 | 63.90 | 22 | SO65157 | 2024-06-19 | 5.11 | 47.29 | 63.90 | |||
SO47056_46 | 53BF-4950-9E | PO7656118289 | 100 | 282 | 221 | 403 | 4 | 2022-11-24 | 80.75 | 2.02 | 2022-11-12 | 4 | 13.88 | 1 | 80.75 | 46 | SO47056 | 2022-11-19 | 6.46 | 55.51 | 20.19 | |||
SO46374_3 | 67B2-494E-90 | PO5597118034 | 100 | 283 | 345 | 7 | 75 | 4 | 595.00 | 2022-09-24 | 1700.00 | 27.62 | 2022-09-12 | 2 | 1912.15 | 1 | 1105.00 | 3 | SO46374 | 2022-09-19 | 88.40 | 3824.31 | 850.00 | 0.35 |
SO51809_47 | F690-4F1D-B1 | PO6438145374 | 100 | 281 | 588 | 309 | 4 | 2023-11-24 | 2308.47 | 57.71 | 2023-11-12 | 5 | 419.78 | 1 | 2308.47 | 47 | SO51809 | 2023-11-19 | 184.68 | 2098.89 | 461.69 | |||
SO47441_11 | 2582-4E47-98 | PO7569166535 | 100 | 287 | 367 | 608 | 4 | 2022-12-25 | 3239.97 | 81.00 | 2022-12-13 | 5 | 598.44 | 1 | 3239.97 | 11 | SO47441 | 2022-12-20 | 259.20 | 2992.18 | 647.99 | |||
SO50753_16 | 8073-4F97-BA | PO7569170218 | 100 | 287 | 358 | 608 | 4 | 2023-09-24 | 6147.29 | 153.68 | 2023-09-12 | 5 | 1105.81 | 1 | 6147.29 | 16 | SO50753 | 2023-09-19 | 491.78 | 5529.05 | 1229.46 | |||
SO50310_13 | FCBD-48EE-A9 | PO6438126969 | 100 | 281 | 410 | 309 | 4 | 2023-08-24 | 36.45 | 0.91 | 2023-08-12 | 1 | 26.97 | 1 | 36.45 | 13 | SO50310 | 2023-08-19 | 2.92 | 26.97 | 36.45 | |||
SO51153_8 | AC8D-4688-81 | PO5626119823 | 100 | 281 | 482 | 166 | 4 | 2023-10-24 | 32.36 | 0.81 | 2023-10-12 | 6 | 3.36 | 1 | 32.36 | 8 | SO51153 | 2023-10-19 | 2.59 | 20.17 | 5.39 | |||
SO46625_17 | 361B-4CAF-A2 | PO13688113829 | 100 | 282 | 365 | 475 | 4 | 2022-10-24 | 2591.98 | 64.80 | 2022-10-12 | 4 | 598.44 | 1 | 2591.98 | 17 | SO46625 | 2022-10-19 | 207.36 | 2393.74 | 647.99 | |||
SO45074_18 | 7225-40DF-B0 | PO7859191751 | 100 | 287 | 319 | 221 | 4 | 2022-04-26 | 2624.38 | 65.61 | 2022-04-14 | 3 | 884.71 | 1 | 2624.38 | 18 | SO45074 | 2022-04-21 | 209.95 | 2654.12 | 874.79 | |||
SO48780_27 | F139-41F4-83 | PO5626121558 | 100 | 281 | 325 | 166 | 4 | 2023-04-26 | 2348.97 | 58.72 | 2023-04-14 | 5 | 486.71 | 1 | 2348.97 | 27 | SO48780 | 2023-04-21 | 187.92 | 2433.53 | 469.79 | |||
SO47439_48 | D4B6-4746-BE | PO6786128920 | 100 | 283 | 327 | 3 | 4 | 2022-12-25 | 4697.94 | 117.45 | 2022-12-13 | 10 | 486.71 | 1 | 4697.94 | 48 | SO47439 | 2022-12-20 | 375.84 | 4867.07 | 469.79 | |||
SO50298_12 | 2A9C-4236-85 | PO4843196377 | 100 | 287 | 263 | 257 | 4 | 2023-08-24 | 404.66 | 10.12 | 2023-08-12 | 2 | 187.16 | 1 | 404.66 | 12 | SO50298 | 2023-08-19 | 32.37 | 374.31 | 202.33 | |||
SO49884_6 | 822A-428D-94 | PO5626129805 | 100 | 281 | 239 | 166 | 4 | 2023-07-25 | 1561.64 | 39.04 | 2023-07-13 | 2 | 722.26 | 1 | 1561.64 | 6 | SO49884 | 2023-07-20 | 124.93 | 1444.51 | 780.82 | |||
SO53599_4 | 6D38-4AD7-96 | PO3973121763 | 100 | 281 | 559 | 201 | 4 | 2023-12-25 | 36.43 | 0.91 | 2023-12-13 | 3 | 8.99 | 1 | 36.43 | 4 | SO53599 | 2023-12-20 | 2.91 | 26.96 | 12.14 | |||
SO47972_5 | 2DF2-4C68-B0 | PO18647114504 | 100 | 282 | 470 | 583 | 4 | 2023-02-24 | 205.15 | 5.13 | 2023-02-12 | 9 | 15.67 | 1 | 205.15 | 5 | SO47972 | 2023-02-19 | 16.41 | 141.04 | 22.79 | |||
SO50688_13 | C55C-41B0-92 | PO10701178438 | 100 | 282 | 213 | 2 | 133 | 4 | 4.68 | 2023-09-24 | 234.16 | 5.74 | 2023-09-12 | 12 | 13.88 | 1 | 229.48 | 13 | SO50688 | 2023-09-19 | 18.36 | 166.54 | 19.51 | 0.02 |
SO50282_7 | 9C0C-42E0-B6 | PO6525160235 | 100 | 281 | 358 | 345 | 4 | 2023-08-24 | 4917.84 | 122.95 | 2023-08-12 | 4 | 1105.81 | 1 | 4917.84 | 7 | SO50282 | 2023-08-19 | 393.43 | 4423.24 | 1229.46 | |||
SO57137_7 | 9401-4518-A4 | PO6438194874 | 100 | 281 | 524 | 309 | 4 | 2024-02-24 | 633.72 | 15.84 | 2024-02-12 | 4 | 144.59 | 1 | 633.72 | 7 | SO57137 | 2024-02-19 | 50.70 | 578.38 | 158.43 | |||
SO63280_13 | C73E-4203-80 | PO3654118854 | 100 | 281 | 516 | 435 | 4 | 2024-05-26 | 46.97 | 1.17 | 2024-05-14 | 2 | 17.38 | 1 | 46.97 | 13 | SO63280 | 2024-05-21 | 3.76 | 34.76 | 23.48 | |||
SO71890_9 | D31D-413E-BB | PO5510169156 | 100 | 287 | 583 | 5 | 4 | 2024-09-24 | 1020.59 | 25.51 | 2024-09-12 | 1 | 1082.51 | 1 | 1020.59 | 9 | SO71890 | 2024-09-19 | 81.65 | 1082.51 | 1020.59 | |||
SO71924_2 | 1C32-4971-8C | PO725177386 | 100 | 281 | 353 | 291 | 4 | 2024-09-24 | 2783.99 | 69.60 | 2024-09-12 | 2 | 1265.62 | 1 | 2783.99 | 2 | SO71924 | 2024-09-19 | 222.72 | 2531.24 | 1391.99 | |||
SO46642_29 | 0A4E-465C-BB | PO551133122 | 100 | 283 | 407 | 4 | 4 | 2022-10-24 | 131.20 | 3.28 | 2022-10-12 | 2 | 48.55 | 1 | 131.20 | 29 | SO46642 | 2022-10-19 | 10.50 | 97.09 | 65.60 | |||
SO48378_14 | 2FD7-4721-9D | PO6786131738 | 100 | 283 | 343 | 3 | 4 | 2023-03-26 | 469.79 | 11.74 | 2023-03-14 | 1 | 486.71 | 1 | 469.79 | 14 | SO48378 | 2023-03-21 | 37.58 | 486.71 | 469.79 | |||
SO51131_12 | D489-4DF3-A2 | PO16298169856 | 100 | 287 | 576 | 3 | 599 | 4 | 1376.80 | 2023-10-24 | 27536.01 | 653.98 | 2023-10-12 | 21 | 1481.94 | 1 | 26159.21 | 12 | SO51131 | 2023-10-19 | 2092.74 | 31120.70 | 1311.24 | 0.05 |
Generated 2024-11-11 06:53:09.750 UTC