[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SKIP 0 SHUFFLE < SKIP 999 > < TAKE 30 >
30 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44754_14 | 2F58-4025-92 | PO15834116970 | 100 | 283 | 220 | 417 | 4 | 2022-02-01 | 40.37 | 1.01 | 2022-01-20 | 2 | 12.03 | 1 | 40.37 | 14 | SO44754 | 2022-01-27 | 3.23 | 24.06 | 20.19 | |||
SO47352_30 | 9DF5-4A88-9C | PO19633111392 | 100 | 287 | 428 | 149 | 3 | 2022-11-02 | 1674.05 | 41.85 | 2022-10-21 | 8 | 185.82 | 1 | 1674.05 | 30 | SO47352 | 2022-10-28 | 133.92 | 1486.55 | 209.26 | |||
SO47720_27 | 30D0-4EF0-B1 | PO7859164121 | 100 | 287 | 335 | 221 | 4 | 2022-12-02 | 469.79 | 11.74 | 2022-11-20 | 1 | 486.71 | 1 | 469.79 | 27 | SO47720 | 2022-11-27 | 37.58 | 486.71 | 469.79 | |||
SO53452_43 | B555-4FD7-8B | PO870113712 | 100 | 286 | 566 | 13 | 621 | 1 | 100.22 | 2023-11-02 | 668.12 | 14.20 | 2023-10-21 | 2 | 461.44 | 1 | 567.90 | 43 | SO53452 | 2023-10-28 | 45.43 | 922.89 | 334.06 | 0.15 |
SO63216_9 | A61E-4461-B6 | PO12702151034 | 100 | 292 | 511 | 175 | 7 | 2024-04-03 | 436.91 | 10.92 | 2024-03-22 | 2 | 199.38 | 1 | 436.91 | 9 | SO63216 | 2024-03-29 | 34.95 | 398.75 | 218.45 | |||
SO55241_11 | F7DC-49D7-89 | PO16588188882 | 100 | 289 | 355 | 146 | 1 | 2023-12-02 | 2783.99 | 69.60 | 2023-11-20 | 2 | 1265.62 | 1 | 2783.99 | 11 | SO55241 | 2023-11-27 | 222.72 | 2531.24 | 1391.99 | |||
SO53459_18 | 9828-4F27-B0 | PO19372154638 | 100 | 282 | 552 | 582 | 4 | 2023-11-02 | 219.58 | 5.49 | 2023-10-21 | 4 | 40.62 | 1 | 219.58 | 18 | SO53459 | 2023-10-28 | 17.57 | 162.49 | 54.89 | |||
SO44083_4 | A5F2-4B59-BA | PO17719115878 | 19 | 284 | 342 | 631 | 6 | 2021-11-02 | 419.46 | 10.49 | 2021-10-21 | 1 | 413.15 | 1 | 419.46 | 4 | SO44083 | 2021-10-28 | 33.56 | 413.15 | 419.46 | |||
SO55275_16 | 72C3-4048-BC | PO1711122362 | 19 | 291 | 361 | 245 | 6 | 2023-12-02 | 6884.97 | 172.12 | 2023-11-20 | 5 | 1251.98 | 1 | 6884.97 | 16 | SO55275 | 2023-11-27 | 550.80 | 6259.91 | 1376.99 | |||
SO57138_7 | CD80-4144-8A | PO5684168325 | 100 | 282 | 517 | 385 | 4 | 2024-01-02 | 31.58 | 0.79 | 2023-12-21 | 1 | 23.37 | 1 | 31.58 | 7 | SO57138 | 2023-12-28 | 2.53 | 23.37 | 31.58 | |||
SO71894_17 | 8013-4FC0-B4 | PO7685115663 | 100 | 283 | 488 | 539 | 2 | 2024-08-02 | 194.36 | 4.86 | 2024-07-21 | 6 | 41.57 | 1 | 194.36 | 17 | SO71894 | 2024-07-28 | 15.55 | 249.43 | 32.39 | |||
SO51825_7 | E395-4F72-84 | PO6525184188 | 100 | 281 | 557 | 345 | 4 | 2023-10-02 | 307.79 | 7.69 | 2023-09-20 | 2 | 113.88 | 1 | 307.79 | 7 | SO51825 | 2023-09-27 | 24.62 | 227.76 | 153.89 | |||
SO65310_14 | 65CB-474A-9D | PO6786169596 | 100 | 281 | 583 | 3 | 4 | 2024-05-02 | 2041.19 | 51.03 | 2024-04-20 | 2 | 1082.51 | 1 | 2041.19 | 14 | SO65310 | 2024-04-27 | 163.30 | 2165.02 | 1020.59 | |||
SO44541_3 | 64BA-409F-A1 | PO2958192556 | 100 | 286 | 349 | 559 | 1 | 2022-01-02 | 4049.99 | 101.25 | 2021-12-21 | 2 | 1898.09 | 1 | 4049.99 | 3 | SO44541 | 2021-12-28 | 324.00 | 3796.19 | 2024.99 | |||
SO45517_6 | 1980-4886-B0 | PO20213190120 | 100 | 281 | 328 | 216 | 2 | 2022-05-02 | 1677.84 | 41.95 | 2022-04-20 | 4 | 413.15 | 1 | 1677.84 | 6 | SO45517 | 2022-04-27 | 134.23 | 1652.59 | 419.46 | |||
SO63249_13 | ABDD-4795-8F | PO4727178983 | 100 | 293 | 380 | 343 | 1 | 2024-04-03 | 2932.02 | 73.30 | 2024-03-22 | 2 | 1554.95 | 1 | 2932.02 | 13 | SO63249 | 2024-03-29 | 234.56 | 3109.90 | 1466.01 | |||
SO51755_3 | 46F4-477C-A7 | PO11020169365 | 19 | 284 | 436 | 336 | 6 | 2023-10-02 | 356.90 | 8.92 | 2023-09-20 | 1 | 360.94 | 1 | 356.90 | 3 | SO51755 | 2023-09-27 | 28.55 | 360.94 | 356.90 | |||
SO57159_1 | DDBB-4887-AA | PO2262133775 | 19 | 291 | 573 | 629 | 6 | 2024-01-02 | 2860.88 | 71.52 | 2023-12-21 | 2 | 1481.94 | 1 | 2860.88 | 1 | SO57159 | 2023-12-28 | 228.87 | 2963.88 | 1430.44 | |||
SO44128_2 | 2EFE-4DBD-95 | PO9541192839 | 100 | 285 | 347 | 279 | 5 | 2021-11-02 | 2039.99 | 51.00 | 2021-10-21 | 1 | 1912.15 | 1 | 2039.99 | 2 | SO44128 | 2021-10-28 | 163.20 | 1912.15 | 2039.99 | |||
SO45298_1 | 7EEC-41A1-9E | PO13572147445 | 100 | 287 | 320 | 527 | 3 | 2022-04-04 | 419.46 | 10.49 | 2022-03-23 | 1 | 413.15 | 1 | 419.46 | 1 | SO45298 | 2022-03-30 | 33.56 | 413.15 | 419.46 | |||
SO46940_29 | 6ADC-4363-B3 | PO18705126181 | 19 | 291 | 447 | 479 | 6 | 2022-10-02 | 60.00 | 1.50 | 2022-09-20 | 4 | 10.31 | 1 | 60.00 | 29 | SO46940 | 2022-09-27 | 4.80 | 41.25 | 15.00 | |||
SO55251_18 | 2481-4FF1-80 | PO13659159365 | 100 | 287 | 597 | 437 | 4 | 2023-12-02 | 1295.98 | 32.40 | 2023-11-20 | 4 | 294.58 | 1 | 1295.98 | 18 | SO55251 | 2023-11-27 | 103.68 | 1178.32 | 323.99 | |||
SO47355_57 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 263 | 24 | 4 | 2022-11-02 | 2023.32 | 50.58 | 2022-10-21 | 10 | 187.16 | 1 | 2023.32 | 57 | SO47355 | 2022-10-28 | 161.87 | 1871.57 | 202.33 | |||
SO65173_7 | 5315-45D4-AA | PO17545119578 | 19 | 291 | 482 | 2 | 155 | 6 | 1.25 | 2024-05-02 | 62.57 | 1.53 | 2024-04-20 | 12 | 3.36 | 1 | 61.32 | 7 | SO65173 | 2024-04-27 | 4.91 | 40.35 | 5.21 | 0.02 |
SO46068_13 | E058-4217-9B | PO10121135632 | 100 | 281 | 342 | 684 | 2 | 2022-07-02 | 1258.38 | 31.46 | 2022-06-20 | 3 | 413.15 | 1 | 1258.38 | 13 | SO46068 | 2022-06-27 | 100.67 | 1239.44 | 419.46 | |||
SO51734_35 | 9D8E-4873-8B | PO13427111801 | 100 | 292 | 480 | 638 | 7 | 2023-10-02 | 4.12 | 0.10 | 2023-09-20 | 3 | 0.86 | 1 | 4.12 | 35 | SO51734 | 2023-09-27 | 0.33 | 2.57 | 1.37 | |||
SO46980_31 | FAA2-449B-99 | PO13572170679 | 100 | 287 | 383 | 527 | 3 | 2022-10-02 | 600.26 | 15.01 | 2022-09-20 | 1 | 605.65 | 1 | 600.26 | 31 | SO46980 | 2022-09-27 | 48.02 | 605.65 | 600.26 | |||
SO51751_28 | 257C-4EC8-98 | PO11368156185 | 36 | 295 | 355 | 687 | 8 | 2023-10-02 | 2783.99 | 69.60 | 2023-09-20 | 2 | 1265.62 | 1 | 2783.99 | 28 | SO51751 | 2023-09-27 | 222.72 | 2531.24 | 1391.99 | |||
SO46068_2 | E058-4217-9B | PO10121135632 | 100 | 281 | 316 | 684 | 2 | 2022-07-02 | 1749.59 | 43.74 | 2022-06-20 | 2 | 884.71 | 1 | 1749.59 | 2 | SO46068 | 2022-06-27 | 139.97 | 1769.42 | 874.79 | |||
SO53511_3 | A091-46E6-B8 | PO10295138349 | 98 | 288 | 544 | 322 | 10 | 2023-11-02 | 48.59 | 1.21 | 2023-10-21 | 1 | 35.96 | 1 | 48.59 | 3 | SO53511 | 2023-10-28 | 3.89 | 35.96 | 48.59 |
Generated 2024-09-19 23:05:32.015 UTC