[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SKIP 0 SHUFFLE < SKIP 969 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47677_7 | 2C43-407F-B3 | PO13688179339 | 100 | 282 | 427 | 475 | 4 | 2022-12-03 | 627.77 | 15.69 | 2022-11-21 | 3 | 185.82 | 1 | 627.77 | 7 | SO47677 | 2022-11-28 | 50.22 | 557.46 | 209.26 | |||
SO46668_36 | 6711-47BE-BF | PO7859142972 | 100 | 287 | 462 | 221 | 4 | 2022-09-02 | 70.64 | 1.77 | 2022-08-21 | 5 | 9.71 | 1 | 70.64 | 36 | SO46668 | 2022-08-28 | 5.65 | 48.57 | 14.13 | |||
SO51706_9 | EC0B-4A2D-A1 | PO16762139224 | 100 | 282 | 583 | 259 | 4 | 2023-10-03 | 5102.97 | 127.57 | 2023-09-21 | 5 | 1082.51 | 1 | 5102.97 | 9 | SO51706 | 2023-09-28 | 408.24 | 5412.55 | 1020.59 | |||
SO59023_21 | 9975-4F2A-A7 | PO5539149469 | 100 | 282 | 214 | 61 | 4 | 2024-02-02 | 125.96 | 3.15 | 2024-01-21 | 6 | 13.09 | 1 | 125.96 | 21 | SO59023 | 2024-01-28 | 10.08 | 78.52 | 20.99 | |||
SO55256_22 | 686E-4D36-8B | PO12528136439 | 100 | 282 | 558 | 331 | 4 | 2023-12-03 | 971.98 | 24.30 | 2023-11-21 | 4 | 179.82 | 1 | 971.98 | 22 | SO55256 | 2023-11-28 | 77.76 | 719.26 | 242.99 | |||
SO65285_3 | 83AC-4FF9-8B | PO4002159016 | 100 | 282 | 583 | 674 | 4 | 2024-05-03 | 3061.78 | 76.54 | 2024-04-21 | 3 | 1082.51 | 1 | 3061.78 | 3 | SO65285 | 2024-04-28 | 244.94 | 3247.53 | 1020.59 | |||
SO49515_15 | 52D0-4584-BC | PO9715144044 | 100 | 281 | 367 | 490 | 4 | 2023-05-03 | 1295.99 | 32.40 | 2023-04-21 | 2 | 598.44 | 1 | 1295.99 | 15 | SO49515 | 2023-04-28 | 103.68 | 1196.87 | 647.99 | |||
SO50738_1 | 531C-4E52-80 | PO3915159731 | 100 | 281 | 461 | 130 | 4 | 2023-08-03 | 269.97 | 6.75 | 2023-07-22 | 5 | 37.12 | 1 | 269.97 | 1 | SO50738 | 2023-07-29 | 21.60 | 185.60 | 53.99 | |||
SO53616_18 | A692-4827-93 | PO6786150961 | 100 | 281 | 471 | 3 | 4 | 2023-11-03 | 152.40 | 3.81 | 2023-10-22 | 4 | 23.75 | 1 | 152.40 | 18 | SO53616 | 2023-10-29 | 12.19 | 95.00 | 38.10 | |||
SO48758_20 | 709A-4AE0-B1 | PO13688180139 | 100 | 282 | 453 | 475 | 4 | 2023-03-05 | 359.94 | 9.00 | 2023-02-21 | 10 | 24.75 | 1 | 359.94 | 20 | SO48758 | 2023-02-28 | 28.80 | 247.46 | 35.99 | |||
SO65306_10 | 6B9B-439C-94 | PO5597142402 | 100 | 281 | 398 | 75 | 4 | 2024-05-03 | 53.45 | 1.34 | 2024-04-21 | 2 | 19.78 | 1 | 53.45 | 10 | SO65306 | 2024-04-28 | 4.28 | 39.55 | 26.72 | |||
SO43913_12 | AD88-49ED-90 | PO7830112696 | 100 | 283 | 220 | 40 | 4 | 2021-10-03 | 40.37 | 1.01 | 2021-09-21 | 2 | 12.03 | 1 | 40.37 | 12 | SO43913 | 2021-09-28 | 3.23 | 24.06 | 20.19 | |||
SO67273_48 | 9BAE-4E69-B9 | PO13688176638 | 100 | 282 | 234 | 2 | 475 | 4 | 6.96 | 2024-06-03 | 347.93 | 8.52 | 2024-05-22 | 12 | 38.49 | 1 | 340.97 | 48 | SO67273 | 2024-05-29 | 27.28 | 461.91 | 28.99 | 0.02 |
SO51102_20 | F2B1-4561-84 | PO13659193365 | 100 | 287 | 474 | 437 | 4 | 2023-09-02 | 335.95 | 8.40 | 2023-08-21 | 8 | 26.18 | 1 | 335.95 | 20 | SO51102 | 2023-08-28 | 26.88 | 209.41 | 41.99 | |||
SO53460_47 | 3BD9-47C3-94 | PO19343112747 | 100 | 282 | 545 | 24 | 4 | 2023-11-03 | 97.18 | 2.43 | 2023-10-22 | 4 | 17.98 | 1 | 97.18 | 47 | SO53460 | 2023-10-29 | 7.77 | 71.91 | 24.29 | |||
SO47355_37 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 337 | 24 | 4 | 2022-11-03 | 1409.38 | 35.23 | 2022-10-22 | 3 | 486.71 | 1 | 1409.38 | 37 | SO47355 | 2022-10-29 | 112.75 | 1460.12 | 469.79 | |||
SO45291_14 | 3865-4B93-A6 | PO15689110696 | 100 | 283 | 319 | 328 | 4 | 2022-04-05 | 1749.59 | 43.74 | 2022-03-24 | 2 | 884.71 | 1 | 1749.59 | 14 | SO45291 | 2022-03-31 | 139.97 | 1769.42 | 874.79 | |||
SO49058_38 | BD1B-4C7F-A9 | PO12499147561 | 100 | 282 | 333 | 78 | 4 | 2023-04-05 | 1879.18 | 46.98 | 2023-03-24 | 4 | 486.71 | 1 | 1879.18 | 38 | SO49058 | 2023-03-31 | 150.33 | 1946.83 | 469.79 | |||
SO48080_8 | 4DC7-4772-87 | PO7656157590 | 100 | 282 | 387 | 403 | 4 | 2023-01-03 | 1200.53 | 30.01 | 2022-12-22 | 2 | 605.65 | 1 | 1200.53 | 8 | SO48080 | 2022-12-29 | 96.04 | 1211.30 | 600.26 | |||
SO47687_22 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 327 | 203 | 4 | 2022-12-03 | 1409.38 | 35.23 | 2022-11-21 | 3 | 486.71 | 1 | 1409.38 | 22 | SO47687 | 2022-11-28 | 112.75 | 1460.12 | 469.79 | |||
SO61243_19 | 0370-4B1B-9D | PO7859152962 | 100 | 287 | 463 | 221 | 4 | 2024-03-04 | 58.78 | 1.47 | 2024-02-21 | 4 | 9.16 | 1 | 58.78 | 19 | SO61243 | 2024-02-28 | 4.70 | 36.64 | 14.69 | |||
SO59013_24 | C224-4535-BA | PO5597199820 | 100 | 281 | 532 | 75 | 4 | 2024-02-02 | 299.75 | 7.49 | 2024-01-21 | 2 | 136.79 | 1 | 299.75 | 24 | SO59013 | 2024-01-28 | 23.98 | 273.57 | 149.87 | |||
SO50748_38 | 5FBE-4B52-B2 | PO6786143310 | 100 | 281 | 216 | 3 | 4 | 2023-08-03 | 121.12 | 3.03 | 2023-07-22 | 6 | 13.88 | 1 | 121.12 | 38 | SO50748 | 2023-07-29 | 9.69 | 83.27 | 20.19 | |||
SO47028_16 | 8DA0-456D-8F | PO3799132728 | 100 | 282 | 356 | 312 | 4 | 2022-10-03 | 6214.26 | 155.36 | 2022-09-21 | 5 | 1117.86 | 1 | 6214.26 | 16 | SO47028 | 2022-09-28 | 497.14 | 5589.28 | 1242.85 | |||
SO51102_16 | F2B1-4561-84 | PO13659193365 | 100 | 287 | 524 | 437 | 4 | 2023-09-02 | 475.29 | 11.88 | 2023-08-21 | 3 | 144.59 | 1 | 475.29 | 16 | SO51102 | 2023-08-28 | 38.02 | 433.78 | 158.43 | |||
SO51773_1 | 14B1-48BF-A0 | PO2523163173 | 100 | 287 | 584 | 167 | 4 | 2023-10-03 | 1295.98 | 32.40 | 2023-09-21 | 4 | 343.65 | 1 | 1295.98 | 1 | SO51773 | 2023-09-28 | 103.68 | 1374.60 | 323.99 | |||
SO69532_24 | 27FB-4A86-85 | PO3799165791 | 100 | 282 | 511 | 312 | 4 | 2024-07-03 | 218.45 | 5.46 | 2024-06-21 | 1 | 199.38 | 1 | 218.45 | 24 | SO69532 | 2024-06-28 | 17.48 | 199.38 | 218.45 | |||
SO63261_3 | 47AD-4561-92 | PO2320130718 | 100 | 282 | 390 | 529 | 4 | 2024-04-04 | 1344.59 | 33.61 | 2024-03-23 | 2 | 713.08 | 1 | 1344.59 | 3 | SO63261 | 2024-03-30 | 107.57 | 1426.16 | 672.29 | |||
SO43912_7 | 69B6-46F8-A4 | PO7656175368 | 100 | 282 | 262 | 403 | 4 | 2021-10-03 | 367.88 | 9.20 | 2021-09-21 | 2 | 181.49 | 1 | 367.88 | 7 | SO43912 | 2021-09-28 | 29.43 | 362.97 | 183.94 | |||
SO47439_49 | D4B6-4746-BE | PO6786128920 | 100 | 283 | 422 | 3 | 4 | 2022-11-03 | 270.16 | 6.75 | 2022-10-22 | 4 | 49.98 | 1 | 270.16 | 49 | SO47439 | 2022-10-29 | 21.61 | 199.92 | 67.54 |
Generated 2024-09-20 10:34:58.607 UTC