[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SKIP 0 SHUFFLE < SKIP 317 > < TAKE 31 >
31 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51096_16 | 2D8A-4DAD-96 | PO14732111307 | 19 | 291 | 546 | 514 | 6 | 2023-09-02 | 186.27 | 4.66 | 2023-08-21 | 5 | 27.57 | 1 | 186.27 | 16 | SO51096 | 2023-08-28 | 14.90 | 137.84 | 37.25 | |||
SO67294_23 | 85E2-46A1-BE | PO899165491 | 100 | 289 | 547 | 290 | 1 | 2024-06-03 | 145.78 | 3.64 | 2024-05-22 | 3 | 35.96 | 1 | 145.78 | 23 | SO67294 | 2024-05-29 | 11.66 | 107.88 | 48.59 | |||
SO71948_28 | DCEE-428D-87 | PO9599179297 | 100 | 285 | 390 | 170 | 5 | 2024-08-03 | 2689.18 | 67.23 | 2024-07-22 | 4 | 713.08 | 1 | 2689.18 | 28 | SO71948 | 2024-07-29 | 215.13 | 2852.32 | 672.29 | |||
SO63198_2 | 20FD-4BBB-BF | PO14558113391 | 100 | 289 | 476 | 2 | 1 | 2024-04-04 | 41.99 | 1.05 | 2024-03-23 | 1 | 26.18 | 1 | 41.99 | 2 | SO63198 | 2024-03-30 | 3.36 | 26.18 | 41.99 | |||
SO51786_22 | CB32-4179-97 | PO18357130739 | 19 | 272 | 214 | 138 | 6 | 2023-10-03 | 104.97 | 2.62 | 2023-09-21 | 5 | 13.09 | 1 | 104.97 | 22 | SO51786 | 2023-09-28 | 8.40 | 65.43 | 20.99 | |||
SO51734_51 | 9D8E-4873-8B | PO13427111801 | 100 | 292 | 582 | 638 | 7 | 2023-10-03 | 1020.59 | 25.51 | 2023-09-21 | 1 | 1082.51 | 1 | 1020.59 | 51 | SO51734 | 2023-09-28 | 81.65 | 1082.51 | 1020.59 | |||
SO46333_5 | B042-408B-A8 | PO17545158984 | 19 | 288 | 232 | 155 | 6 | 2022-08-03 | 173.04 | 4.33 | 2022-07-22 | 6 | 31.72 | 1 | 173.04 | 5 | SO46333 | 2022-07-29 | 13.84 | 190.35 | 28.84 | |||
SO65226_4 | 55DE-4772-82 | PO15515186601 | 100 | 292 | 491 | 3 | 481 | 7 | 26.73 | 2024-05-03 | 534.50 | 12.69 | 2024-04-21 | 18 | 41.57 | 1 | 507.78 | 4 | SO65226 | 2024-04-28 | 40.62 | 748.30 | 29.69 | 0.05 |
SO57024_18 | DED7-4CEF-90 | PO17661138970 | 19 | 284 | 222 | 264 | 6 | 2024-01-03 | 62.98 | 1.57 | 2023-12-22 | 3 | 13.09 | 1 | 62.98 | 18 | SO57024 | 2023-12-29 | 5.04 | 39.26 | 20.99 | |||
SO71832_14 | 269D-4F59-82 | PO10353140756 | 98 | 288 | 298 | 88 | 10 | 2024-08-03 | 3239.04 | 80.98 | 2024-07-22 | 4 | 739.04 | 1 | 3239.04 | 14 | SO71832 | 2024-07-29 | 259.12 | 2956.16 | 809.76 | |||
SO46626_4 | CFB3-4671-A6 | PO13340194893 | 100 | 292 | 419 | 355 | 7 | 2022-09-02 | 52.65 | 1.32 | 2022-08-21 | 1 | 38.96 | 1 | 52.65 | 4 | SO46626 | 2022-08-28 | 4.21 | 38.96 | 52.65 | |||
SO44533_16 | 6A24-4735-B2 | PO1827111566 | 19 | 288 | 215 | 317 | 6 | 2022-01-03 | 121.12 | 3.03 | 2021-12-22 | 6 | 12.03 | 1 | 121.12 | 16 | SO44533 | 2021-12-29 | 9.69 | 72.17 | 20.19 | |||
SO51092_17 | FB68-47B7-9D | PO15312133079 | 19 | 291 | 547 | 299 | 6 | 2023-09-02 | 145.78 | 3.64 | 2023-08-21 | 3 | 35.96 | 1 | 145.78 | 17 | SO51092 | 2023-08-28 | 11.66 | 107.88 | 48.59 | |||
SO46964_9 | B3E6-43CC-A2 | PO15689139014 | 100 | 283 | 236 | 328 | 4 | 2022-10-03 | 144.20 | 3.61 | 2022-09-21 | 5 | 29.08 | 1 | 144.20 | 9 | SO46964 | 2022-09-28 | 11.54 | 145.40 | 28.84 | |||
SO46611_32 | 93A4-4A4D-99 | PO16588117269 | 100 | 289 | 464 | 146 | 1 | 2022-09-02 | 113.03 | 2.83 | 2022-08-21 | 8 | 9.71 | 1 | 113.03 | 32 | SO46611 | 2022-08-28 | 9.04 | 77.71 | 14.13 | |||
SO47658_15 | C574-484B-83 | PO551177057 | 100 | 283 | 385 | 4 | 4 | 2022-12-03 | 1800.79 | 45.02 | 2022-11-21 | 3 | 605.65 | 1 | 1800.79 | 15 | SO47658 | 2022-11-28 | 144.06 | 1816.95 | 600.26 | |||
SO69520_42 | 654B-484B-8F | PO4466144794 | 19 | 291 | 483 | 352 | 6 | 2024-07-03 | 144.00 | 3.60 | 2024-06-21 | 2 | 44.88 | 1 | 144.00 | 42 | SO69520 | 2024-06-28 | 11.52 | 89.76 | 72.00 | |||
SO69531_1 | 1871-4E54-BE | PO3683141039 | 100 | 292 | 523 | 85 | 7 | 2024-07-03 | 157.92 | 3.95 | 2024-06-21 | 5 | 23.37 | 1 | 157.92 | 1 | SO69531 | 2024-06-28 | 12.63 | 116.86 | 31.58 | |||
SO49105_15 | B762-4BA5-A0 | PO14500175804 | 100 | 282 | 399 | 650 | 1 | 2023-04-05 | 33.77 | 0.84 | 2023-03-24 | 1 | 24.99 | 1 | 33.77 | 15 | SO49105 | 2023-03-31 | 2.70 | 24.99 | 33.77 | |||
SO71835_22 | EBBF-4B16-99 | PO870120974 | 100 | 286 | 500 | 621 | 1 | 2024-08-03 | 602.35 | 15.06 | 2024-07-22 | 1 | 601.74 | 1 | 602.35 | 22 | SO71835 | 2024-07-29 | 48.19 | 601.74 | 602.35 | |||
SO51092_11 | FB68-47B7-9D | PO15312133079 | 19 | 291 | 234 | 3 | 299 | 6 | 24.75 | 2023-09-02 | 494.90 | 11.75 | 2023-08-21 | 18 | 38.49 | 1 | 470.16 | 11 | SO51092 | 2023-08-28 | 37.61 | 692.86 | 27.49 | 0.05 |
SO46325_20 | D29B-490E-A9 | PO19488134185 | 100 | 283 | 332 | 57 | 3 | 2022-08-03 | 3355.67 | 83.89 | 2022-07-22 | 8 | 413.15 | 1 | 3355.67 | 20 | SO46325 | 2022-07-29 | 268.45 | 3305.17 | 419.46 | |||
SO46385_29 | F727-48F0-AF | PO9483110086 | 100 | 281 | 235 | 54 | 2 | 2022-08-03 | 57.68 | 1.44 | 2022-07-22 | 2 | 31.72 | 1 | 57.68 | 29 | SO46385 | 2022-07-29 | 4.61 | 63.45 | 28.84 | |||
SO57180_5 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 498 | 520 | 10 | 2024-01-03 | 1204.69 | 30.12 | 2023-12-22 | 2 | 601.74 | 1 | 1204.69 | 5 | SO57180 | 2023-12-29 | 96.38 | 1203.49 | 602.35 | |||
SO48028_37 | B23F-4743-B9 | PO928137953 | 98 | 288 | 233 | 484 | 10 | 2023-01-03 | 144.20 | 3.61 | 2022-12-22 | 5 | 29.08 | 1 | 144.20 | 37 | SO48028 | 2022-12-29 | 11.54 | 145.40 | 28.84 | |||
SO46673_22 | 578D-4F7B-A6 | PO9657163155 | 100 | 285 | 427 | 315 | 5 | 2022-09-02 | 837.02 | 20.93 | 2022-08-21 | 4 | 185.82 | 1 | 837.02 | 22 | SO46673 | 2022-08-28 | 66.96 | 743.28 | 209.26 | |||
SO47033_45 | 2797-46ED-BB | PO4727113716 | 100 | 286 | 423 | 343 | 1 | 2022-10-03 | 165.23 | 4.13 | 2022-09-21 | 1 | 122.27 | 1 | 165.23 | 45 | SO47033 | 2022-09-28 | 13.22 | 122.27 | 165.23 | |||
SO45042_2 | 081C-4281-8E | PO16617111461 | 100 | 286 | 344 | 397 | 1 | 2022-03-05 | 8159.98 | 204.00 | 2022-02-21 | 4 | 1912.15 | 1 | 8159.98 | 2 | SO45042 | 2022-02-28 | 652.80 | 7648.62 | 2039.99 | |||
SO65253_12 | D4A8-44F8-80 | PO12673115345 | 100 | 292 | 374 | 499 | 7 | 2024-05-03 | 7330.05 | 183.25 | 2024-04-21 | 5 | 1554.95 | 1 | 7330.05 | 12 | SO65253 | 2024-04-28 | 586.40 | 7774.74 | 1466.01 | |||
SO46984_16 | 0C1F-467E-93 | PO12789152571 | 19 | 291 | 216 | 677 | 6 | 2022-10-03 | 80.75 | 2.02 | 2022-09-21 | 4 | 13.88 | 1 | 80.75 | 16 | SO46984 | 2022-09-28 | 6.46 | 55.51 | 20.19 | |||
SO63201_1 | 8299-4DE4-AD | PO15689136917 | 100 | 281 | 584 | 328 | 4 | 2024-04-04 | 1295.98 | 32.40 | 2024-03-23 | 4 | 343.65 | 1 | 1295.98 | 1 | SO63201 | 2024-03-30 | 103.68 | 1374.60 | 323.99 |
Generated 2024-09-20 13:39:41.926 UTC