[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 6406 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO57138_3 | CD80-4144-8A | PO5684168325 | 100 | 282 | 402 | 385 | 4 | 2024-01-03 | 72.16 | 1.80 | 2023-12-22 | 1 | 53.40 | 1 | 72.16 | 3 | SO57138 | 2023-12-29 | 5.77 | 53.40 | 72.16 | |||
SO49840_3 | 55BC-4E53-B1 | PO10730155465 | 100 | 287 | 407 | 491 | 4 | 2023-06-03 | 65.60 | 1.64 | 2023-05-22 | 1 | 48.55 | 1 | 65.60 | 3 | SO49840 | 2023-05-29 | 5.25 | 48.55 | 65.60 | |||
SO47687_20 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 422 | 203 | 4 | 2022-12-03 | 67.54 | 1.69 | 2022-11-21 | 1 | 49.98 | 1 | 67.54 | 20 | SO47687 | 2022-11-28 | 5.40 | 49.98 | 67.54 | |||
SO63213_11 | 1A10-4A9D-B4 | PO11745122074 | 100 | 282 | 374 | 97 | 4 | 2024-04-04 | 4398.03 | 109.95 | 2024-03-23 | 3 | 1554.95 | 1 | 4398.03 | 11 | SO63213 | 2024-03-30 | 351.84 | 4664.84 | 1466.01 | |||
SO57042_5 | 52C4-4348-BC | PO15196150289 | 100 | 282 | 408 | 258 | 4 | 2024-01-03 | 72.16 | 1.80 | 2023-12-22 | 1 | 53.40 | 1 | 72.16 | 5 | SO57042 | 2023-12-29 | 5.77 | 53.40 | 72.16 | |||
SO50294_5 | F34B-46CA-8D | PO3799186112 | 100 | 282 | 460 | 312 | 4 | 2023-07-03 | 269.97 | 6.75 | 2023-06-21 | 5 | 37.12 | 1 | 269.97 | 5 | SO50294 | 2023-06-28 | 21.60 | 185.60 | 53.99 | |||
SO47369_11 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 233 | 2 | 239 | 4 | 6.69 | 2022-11-03 | 334.55 | 8.20 | 2022-10-22 | 12 | 29.08 | 1 | 327.86 | 11 | SO47369 | 2022-10-29 | 26.23 | 348.97 | 27.88 | 0.02 |
SO49498_2 | D9E7-4090-86 | PO16472151816 | 100 | 287 | 233 | 2 | 239 | 4 | 6.13 | 2023-05-03 | 306.67 | 7.51 | 2023-04-21 | 11 | 29.08 | 1 | 300.54 | 2 | SO49498 | 2023-04-28 | 24.04 | 319.89 | 27.88 | 0.02 |
SO50738_8 | 531C-4E52-80 | PO3915159731 | 100 | 281 | 453 | 130 | 4 | 2023-08-03 | 71.99 | 1.80 | 2023-07-22 | 2 | 24.75 | 1 | 71.99 | 8 | SO50738 | 2023-07-29 | 5.76 | 49.49 | 35.99 | |||
SO51836_25 | 8AA7-498C-8C | PO6351139034 | 100 | 281 | 583 | 255 | 4 | 2023-10-03 | 4082.38 | 102.06 | 2023-09-21 | 4 | 1082.51 | 1 | 4082.38 | 25 | SO51836 | 2023-09-28 | 326.59 | 4330.04 | 1020.59 | |||
SO63251_23 | CA03-47EE-90 | PO6525146360 | 100 | 281 | 400 | 345 | 4 | 2024-04-04 | 37.15 | 0.93 | 2024-03-23 | 1 | 27.49 | 1 | 37.15 | 23 | SO63251 | 2024-03-30 | 2.97 | 27.49 | 37.15 | |||
SO45328_10 | 2212-4E8E-82 | PO5684113284 | 100 | 282 | 232 | 385 | 4 | 2022-04-05 | 144.20 | 3.61 | 2022-03-24 | 5 | 31.72 | 1 | 144.20 | 10 | SO45328 | 2022-03-31 | 11.54 | 158.62 | 28.84 | |||
SO51144_7 | 6330-4EB9-A5 | PO6409122852 | 100 | 281 | 580 | 292 | 4 | 2023-09-02 | 4082.38 | 102.06 | 2023-08-21 | 4 | 1082.51 | 1 | 4082.38 | 7 | SO51144 | 2023-08-28 | 326.59 | 4330.04 | 1020.59 | |||
SO50294_8 | F34B-46CA-8D | PO3799186112 | 100 | 282 | 216 | 312 | 4 | 2023-07-03 | 80.75 | 2.02 | 2023-06-21 | 4 | 13.88 | 1 | 80.75 | 8 | SO50294 | 2023-06-28 | 6.46 | 55.51 | 20.19 | |||
SO46970_24 | 01AF-420A-B9 | PO15196114472 | 100 | 282 | 383 | 258 | 4 | 2022-10-03 | 1800.79 | 45.02 | 2022-09-21 | 3 | 605.65 | 1 | 1800.79 | 24 | SO46970 | 2022-09-28 | 144.06 | 1816.95 | 600.26 | |||
SO49523_7 | 852E-47A8-A9 | PO3915144057 | 100 | 281 | 389 | 130 | 4 | 2023-05-03 | 600.26 | 15.01 | 2023-04-21 | 1 | 605.65 | 1 | 600.26 | 7 | SO49523 | 2023-04-28 | 48.02 | 605.65 | 600.26 | |||
SO48364_2 | 93FF-4A54-BA | PO3886118778 | 100 | 283 | 456 | 165 | 4 | 2023-02-02 | 179.98 | 4.50 | 2023-01-21 | 4 | 30.93 | 1 | 179.98 | 2 | SO48364 | 2023-01-28 | 14.40 | 123.73 | 44.99 | |||
SO65168_9 | 7CDD-4B4A-AE | PO18038110078 | 100 | 287 | 552 | 509 | 4 | 2024-05-03 | 54.89 | 1.37 | 2024-04-21 | 1 | 40.62 | 1 | 54.89 | 9 | SO65168 | 2024-04-28 | 4.39 | 40.62 | 54.89 | |||
SO48775_9 | E56E-4C8C-AA | PO10817145980 | 100 | 287 | 389 | 203 | 4 | 2023-03-05 | 1800.79 | 45.02 | 2023-02-21 | 3 | 605.65 | 1 | 1800.79 | 9 | SO48775 | 2023-02-28 | 144.06 | 1816.95 | 600.26 | |||
SO51809_39 | F690-4F1D-B1 | PO6438145374 | 100 | 281 | 525 | 309 | 4 | 2023-10-03 | 158.43 | 3.96 | 2023-09-21 | 1 | 144.59 | 1 | 158.43 | 39 | SO51809 | 2023-09-28 | 12.67 | 144.59 | 158.43 | |||
SO46103_7 | 1902-406D-BF | PO7830116487 | 100 | 283 | 347 | 40 | 4 | 2022-07-03 | 12239.96 | 306.00 | 2022-06-21 | 6 | 1912.15 | 1 | 12239.96 | 7 | SO46103 | 2022-06-28 | 979.20 | 11472.93 | 2039.99 | |||
SO48048_1 | B414-46CB-BA | PO3480117933 | 100 | 283 | 273 | 436 | 4 | 2023-01-03 | 404.66 | 10.12 | 2022-12-22 | 2 | 187.16 | 1 | 404.66 | 1 | SO48048 | 2022-12-29 | 32.37 | 374.31 | 202.33 | |||
SO51842_5 | 2A39-4E97-9A | PO4843199898 | 100 | 287 | 246 | 257 | 4 | 2023-10-03 | 858.90 | 21.47 | 2023-09-21 | 1 | 868.63 | 1 | 858.90 | 5 | SO51842 | 2023-09-28 | 68.71 | 868.63 | 858.90 | |||
SO46660_28 | CF24-45E2-9D | PO5626129733 | 100 | 283 | 429 | 166 | 4 | 2022-09-02 | 1622.26 | 40.56 | 2022-08-21 | 5 | 300.12 | 1 | 1622.26 | 28 | SO46660 | 2022-08-28 | 129.78 | 1500.59 | 324.45 | |||
SO51773_28 | 14B1-48BF-A0 | PO2523163173 | 100 | 287 | 386 | 167 | 4 | 2023-10-03 | 1344.59 | 33.61 | 2023-09-21 | 2 | 713.08 | 1 | 1344.59 | 28 | SO51773 | 2023-09-28 | 107.57 | 1426.16 | 672.29 | |||
SO59029_4 | E358-40C0-B2 | PO4640116818 | 100 | 287 | 298 | 648 | 4 | 2024-02-02 | 1619.52 | 40.49 | 2024-01-21 | 2 | 739.04 | 1 | 1619.52 | 4 | SO59029 | 2024-01-28 | 129.56 | 1478.08 | 809.76 | |||
SO65232_29 | 3D4B-4E94-8F | PO9715132845 | 100 | 281 | 474 | 490 | 4 | 2024-05-03 | 293.96 | 7.35 | 2024-04-21 | 7 | 26.18 | 1 | 293.96 | 29 | SO65232 | 2024-04-28 | 23.52 | 183.23 | 41.99 | |||
SO49483_12 | 7C7A-4ABF-BA | PO9686173262 | 100 | 282 | 428 | 457 | 4 | 2023-05-03 | 209.26 | 5.23 | 2023-04-21 | 1 | 185.82 | 1 | 209.26 | 12 | SO49483 | 2023-04-28 | 16.74 | 185.82 | 209.26 | |||
SO48374_1 | 6271-4D04-BE | PO5510147369 | 100 | 287 | 422 | 5 | 4 | 2023-02-02 | 135.08 | 3.38 | 2023-01-21 | 2 | 49.98 | 1 | 135.08 | 1 | SO48374 | 2023-01-28 | 10.81 | 99.96 | 67.54 | |||
SO48311_41 | AAD7-4EBC-A1 | PO16472177233 | 100 | 287 | 453 | 239 | 4 | 2023-02-02 | 287.95 | 7.20 | 2023-01-21 | 8 | 24.75 | 1 | 287.95 | 41 | SO48311 | 2023-01-28 | 23.04 | 197.97 | 35.99 | |||
SO49535_1 | 7DAA-4D31-B1 | PO5974140703 | 100 | 282 | 273 | 330 | 4 | 2023-05-03 | 202.33 | 5.06 | 2023-04-21 | 1 | 187.16 | 1 | 202.33 | 1 | SO49535 | 2023-04-28 | 16.19 | 187.16 | 202.33 |
Generated 2024-09-20 10:44:46.427 UTC