[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 25 > < TAKE 24 >
24 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48048_47 | B414-46CB-BA | PO3480117933 | 100 | 283 | 213 | 436 | 4 | 2023-02-26 | 60.56 | 1.51 | 2023-02-14 | 3 | 13.88 | 1 | 60.56 | 47 | SO48048 | 2023-02-21 | 4.84 | 41.63 | 20.19 | |||
SO44509_30 | FAD7-4A4C-B0 | PO15689158248 | 100 | 283 | 313 | 328 | 4 | 2022-02-26 | 4293.92 | 107.35 | 2022-02-14 | 2 | 2171.29 | 1 | 4293.92 | 30 | SO44509 | 2022-02-21 | 343.51 | 4342.59 | 2146.96 | |||
SO49541_22 | B736-4142-A1 | PO7569133326 | 100 | 287 | 360 | 608 | 4 | 2023-06-26 | 4917.84 | 122.95 | 2023-06-14 | 4 | 1105.81 | 1 | 4917.84 | 22 | SO49541 | 2023-06-21 | 393.43 | 4423.24 | 1229.46 | |||
SO47422_50 | 9D8D-4481-B6 | PO3915123127 | 100 | 283 | 323 | 2 | 130 | 4 | 118.07 | 2022-12-27 | 5903.74 | 144.64 | 2022-12-15 | 13 | 486.71 | 1 | 5785.67 | 50 | SO47422 | 2022-12-22 | 462.85 | 6327.19 | 454.13 | 0.02 |
SO67290_9 | 763C-4FCC-8E | PO10237115936 | 100 | 287 | 481 | 41 | 4 | 2024-07-27 | 32.36 | 0.81 | 2024-07-15 | 6 | 3.36 | 1 | 32.36 | 9 | SO67290 | 2024-07-22 | 2.59 | 20.17 | 5.39 | |||
SO55303_9 | 5C9C-4B35-B8 | PO5626137276 | 100 | 281 | 482 | 166 | 4 | 2024-01-26 | 16.18 | 0.40 | 2024-01-14 | 3 | 3.36 | 1 | 16.18 | 9 | SO55303 | 2024-01-21 | 1.29 | 10.09 | 5.39 | |||
SO48769_9 | A39E-4380-A6 | PO7859190388 | 100 | 287 | 448 | 221 | 4 | 2023-04-28 | 35.98 | 0.90 | 2023-04-16 | 3 | 8.25 | 1 | 35.98 | 9 | SO48769 | 2023-04-23 | 2.88 | 24.74 | 11.99 | |||
SO48378_37 | 2FD7-4721-9D | PO6786131738 | 100 | 283 | 389 | 3 | 4 | 2023-03-28 | 2401.05 | 60.03 | 2023-03-16 | 4 | 605.65 | 1 | 2401.05 | 37 | SO48378 | 2023-03-23 | 192.08 | 2422.60 | 600.26 | |||
SO46364_6 | BC3C-4FE8-AC | PO3248115921 | 100 | 282 | 215 | 366 | 4 | 2022-09-26 | 80.75 | 2.02 | 2022-09-14 | 4 | 12.03 | 1 | 80.75 | 6 | SO46364 | 2022-09-21 | 6.46 | 48.11 | 20.19 | |||
SO47439_51 | D4B6-4746-BE | PO6786128920 | 100 | 283 | 454 | 3 | 4 | 2022-12-27 | 143.98 | 3.60 | 2022-12-15 | 4 | 24.75 | 1 | 143.98 | 51 | SO47439 | 2022-12-22 | 11.52 | 98.98 | 35.99 | |||
SO47677_16 | 2C43-407F-B3 | PO13688179339 | 100 | 282 | 294 | 475 | 4 | 2023-01-26 | 1488.55 | 37.21 | 2023-01-14 | 2 | 660.91 | 1 | 1488.55 | 16 | SO47677 | 2023-01-21 | 119.08 | 1321.83 | 744.27 | |||
SO44787_4 | CFC8-46AC-A7 | PO5597180446 | 100 | 283 | 296 | 75 | 4 | 2022-03-28 | 1429.41 | 35.74 | 2022-03-16 | 2 | 617.03 | 1 | 1429.41 | 4 | SO44787 | 2022-03-23 | 114.35 | 1234.06 | 714.70 | |||
SO46101_8 | FAFC-4F06-B2 | PO7656119075 | 100 | 282 | 319 | 403 | 4 | 2022-08-26 | 874.79 | 21.87 | 2022-08-14 | 1 | 884.71 | 1 | 874.79 | 8 | SO46101 | 2022-08-21 | 69.98 | 884.71 | 874.79 | |||
SO51825_25 | E395-4F72-84 | PO6525184188 | 100 | 281 | 527 | 345 | 4 | 2023-11-26 | 950.58 | 23.76 | 2023-11-14 | 6 | 144.59 | 1 | 950.58 | 25 | SO51825 | 2023-11-21 | 76.05 | 867.56 | 158.43 | |||
SO47027_23 | 1A9C-4166-A7 | PO3480112515 | 100 | 283 | 236 | 436 | 4 | 2022-11-26 | 86.52 | 2.16 | 2022-11-14 | 3 | 29.08 | 1 | 86.52 | 23 | SO47027 | 2022-11-21 | 6.92 | 87.24 | 28.84 | |||
SO61264_4 | 5396-4F0C-B0 | PO5626112601 | 100 | 281 | 581 | 166 | 4 | 2024-04-27 | 2041.19 | 51.03 | 2024-04-15 | 2 | 1082.51 | 1 | 2041.19 | 4 | SO61264 | 2024-04-22 | 163.30 | 2165.02 | 1020.59 | |||
SO47994_14 | 284B-45A1-94 | PO15196121630 | 100 | 282 | 387 | 258 | 4 | 2023-02-26 | 600.26 | 15.01 | 2023-02-14 | 1 | 605.65 | 1 | 600.26 | 14 | SO47994 | 2023-02-21 | 48.02 | 605.65 | 600.26 | |||
SO47458_15 | 5D5A-47FC-AE | PO9686113121 | 100 | 282 | 409 | 457 | 4 | 2022-12-27 | 209.26 | 5.23 | 2022-12-15 | 1 | 185.82 | 1 | 209.26 | 15 | SO47458 | 2022-12-22 | 16.74 | 185.82 | 209.26 | |||
SO48069_9 | 60CF-43B6-82 | PO6438117188 | 100 | 283 | 221 | 309 | 4 | 2023-02-26 | 20.19 | 0.50 | 2023-02-14 | 1 | 13.88 | 1 | 20.19 | 9 | SO48069 | 2023-02-21 | 1.61 | 13.88 | 20.19 | |||
SO50289_32 | 0809-4DE4-93 | PO3480117331 | 100 | 281 | 216 | 436 | 4 | 2023-08-26 | 100.93 | 2.52 | 2023-08-14 | 5 | 13.88 | 1 | 100.93 | 32 | SO50289 | 2023-08-21 | 8.07 | 69.39 | 20.19 | |||
SO67273_37 | 9BAE-4E69-B9 | PO13688176638 | 100 | 282 | 552 | 475 | 4 | 2024-07-27 | 164.68 | 4.12 | 2024-07-15 | 3 | 40.62 | 1 | 164.68 | 37 | SO67273 | 2024-07-22 | 13.17 | 121.86 | 54.89 | |||
SO45548_6 | DC0C-4102-83 | PO667144480 | 100 | 287 | 326 | 365 | 4 | 2022-06-26 | 838.92 | 20.97 | 2022-06-14 | 2 | 413.15 | 1 | 838.92 | 6 | SO45548 | 2022-06-21 | 67.11 | 826.29 | 419.46 | |||
SO58977_10 | 1BFB-45A0-B9 | PO18763128008 | 100 | 287 | 555 | 59 | 4 | 2024-03-27 | 127.80 | 3.20 | 2024-03-15 | 2 | 47.29 | 1 | 127.80 | 10 | SO58977 | 2024-03-22 | 10.22 | 94.57 | 63.90 | |||
SO49152_3 | 52FC-4E8F-B0 | PO6525119586 | 100 | 272 | 367 | 345 | 4 | 2023-05-29 | 647.99 | 16.20 | 2023-05-17 | 1 | 598.44 | 1 | 647.99 | 3 | SO49152 | 2023-05-24 | 51.84 | 598.44 | 647.99 |
Generated 2024-11-13 09:54:25.894 UTC