[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 799 > < TAKE 28 >
28 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46374_4 | 67B2-494E-90 | PO5597118034 | 100 | 283 | 344 | 7 | 75 | 4 | 1487.50 | 2022-08-03 | 4249.99 | 69.06 | 2022-07-22 | 5 | 1912.15 | 1 | 2762.49 | 4 | SO46374 | 2022-07-29 | 221.00 | 9560.77 | 850.00 | 0.35 |
SO65315_26 | 0FFB-4EB5-A3 | PO6757194680 | 100 | 281 | 237 | 21 | 4 | 2024-05-03 | 269.95 | 6.75 | 2024-04-21 | 9 | 38.49 | 1 | 269.95 | 26 | SO65315 | 2024-04-28 | 21.60 | 346.43 | 29.99 | |||
SO51764_15 | D5EC-49D5-9F | PO609164065 | 100 | 282 | 217 | 492 | 4 | 2023-10-03 | 83.98 | 2.10 | 2023-09-21 | 4 | 13.09 | 1 | 83.98 | 15 | SO51764 | 2023-09-28 | 6.72 | 52.35 | 20.99 | |||
SO55256_10 | 686E-4D36-8B | PO12528136439 | 100 | 282 | 575 | 331 | 4 | 2023-12-03 | 1430.44 | 35.76 | 2023-11-21 | 1 | 1481.94 | 1 | 1430.44 | 10 | SO55256 | 2023-11-28 | 114.44 | 1481.94 | 1430.44 | |||
SO45322_4 | 83B9-4E36-B7 | PO3857182032 | 100 | 283 | 315 | 256 | 4 | 2022-04-05 | 2624.38 | 65.61 | 2022-03-24 | 3 | 884.71 | 1 | 2624.38 | 4 | SO45322 | 2022-03-31 | 209.95 | 2654.12 | 874.79 | |||
SO57168_39 | B6D5-41ED-B9 | PO3480129742 | 100 | 281 | 481 | 436 | 4 | 2024-01-03 | 53.94 | 1.35 | 2023-12-22 | 10 | 3.36 | 1 | 53.94 | 39 | SO57168 | 2023-12-29 | 4.32 | 33.62 | 5.39 | |||
SO71889_1 | 79BB-4639-B8 | PO6786144643 | 100 | 281 | 231 | 3 | 4 | 2024-08-03 | 89.98 | 2.25 | 2024-07-22 | 3 | 38.49 | 1 | 89.98 | 1 | SO71889 | 2024-07-29 | 7.20 | 115.48 | 29.99 | |||
SO55249_49 | 0527-4C9D-BA | PO13688172507 | 100 | 282 | 542 | 475 | 4 | 2023-12-03 | 48.59 | 1.21 | 2023-11-21 | 2 | 17.98 | 1 | 48.59 | 49 | SO55249 | 2023-11-28 | 3.89 | 35.96 | 24.29 | |||
SO53539_12 | 2B21-4FAC-8C | PO18763121730 | 100 | 287 | 568 | 13 | 59 | 4 | 50.11 | 2023-11-03 | 334.06 | 7.10 | 2023-10-22 | 1 | 461.44 | 1 | 283.95 | 12 | SO53539 | 2023-10-29 | 22.72 | 461.44 | 334.06 | 0.15 |
SO45301_19 | 0BA8-4928-A7 | PO12499190711 | 100 | 282 | 235 | 78 | 4 | 2022-04-05 | 86.52 | 2.16 | 2022-03-24 | 3 | 31.72 | 1 | 86.52 | 19 | SO45301 | 2022-03-31 | 6.92 | 95.17 | 28.84 | |||
SO50214_8 | 97D5-41D3-8F | PO15196120916 | 100 | 282 | 383 | 258 | 4 | 2023-07-03 | 1800.79 | 45.02 | 2023-06-21 | 3 | 605.65 | 1 | 1800.79 | 8 | SO50214 | 2023-06-28 | 144.06 | 1816.95 | 600.26 | |||
SO50208_40 | 6993-49B4-8B | PO15689114248 | 100 | 281 | 337 | 328 | 4 | 2023-07-03 | 3758.35 | 93.96 | 2023-06-21 | 8 | 486.71 | 1 | 3758.35 | 40 | SO50208 | 2023-06-28 | 300.67 | 3893.65 | 469.79 | |||
SO49498_9 | D9E7-4090-86 | PO16472151816 | 100 | 287 | 417 | 239 | 4 | 2023-05-03 | 973.36 | 24.33 | 2023-04-21 | 3 | 300.12 | 1 | 973.36 | 9 | SO49498 | 2023-04-28 | 77.87 | 900.36 | 324.45 | |||
SO49490_6 | 0396-4322-83 | PO19343175441 | 100 | 282 | 331 | 24 | 4 | 2023-05-03 | 1879.18 | 46.98 | 2023-04-21 | 4 | 486.71 | 1 | 1879.18 | 6 | SO49490 | 2023-04-28 | 150.33 | 1946.83 | 469.79 | |||
SO45568_13 | 32F9-4A87-9D | PO6786144925 | 100 | 283 | 235 | 3 | 4 | 2022-05-03 | 28.84 | 0.72 | 2022-04-21 | 1 | 31.72 | 1 | 28.84 | 13 | SO45568 | 2022-04-28 | 2.31 | 31.72 | 28.84 | |||
SO47355_7 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 325 | 24 | 4 | 2022-11-03 | 2348.97 | 58.72 | 2022-10-22 | 5 | 486.71 | 1 | 2348.97 | 7 | SO47355 | 2022-10-29 | 187.92 | 2433.53 | 469.79 | |||
SO57035_1 | CD56-4460-9B | PO15921199440 | 100 | 287 | 546 | 77 | 4 | 2024-01-03 | 74.51 | 1.86 | 2023-12-22 | 2 | 27.57 | 1 | 74.51 | 1 | SO57035 | 2023-12-29 | 5.96 | 55.14 | 37.25 | |||
SO46374_2 | 67B2-494E-90 | PO5597118034 | 100 | 283 | 346 | 7 | 75 | 4 | 892.50 | 2022-08-03 | 2549.99 | 41.44 | 2022-07-22 | 3 | 1912.15 | 1 | 1657.50 | 2 | SO46374 | 2022-07-29 | 132.60 | 5736.46 | 850.00 | 0.35 |
SO50310_16 | FCBD-48EE-A9 | PO6438126969 | 100 | 281 | 427 | 309 | 4 | 2023-07-03 | 418.51 | 10.46 | 2023-06-21 | 2 | 185.82 | 1 | 418.51 | 16 | SO50310 | 2023-06-28 | 33.48 | 371.64 | 209.26 | |||
SO44564_20 | 142F-443C-90 | PO7656157194 | 100 | 282 | 262 | 403 | 4 | 2022-01-03 | 183.94 | 4.60 | 2021-12-22 | 1 | 181.49 | 1 | 183.94 | 20 | SO44564 | 2021-12-29 | 14.72 | 181.49 | 183.94 | |||
SO43873_12 | 494C-48D2-BD | PO12499138177 | 100 | 282 | 276 | 78 | 4 | 2021-10-03 | 1070.69 | 26.77 | 2021-09-21 | 3 | 352.14 | 1 | 1070.69 | 12 | SO43873 | 2021-09-28 | 85.66 | 1056.42 | 356.90 | |||
SO51809_27 | F690-4F1D-B1 | PO6438145374 | 100 | 281 | 490 | 309 | 4 | 2023-10-03 | 97.18 | 2.43 | 2023-09-21 | 3 | 41.57 | 1 | 97.18 | 27 | SO51809 | 2023-09-28 | 7.77 | 124.72 | 32.39 | |||
SO44119_1 | 6300-4202-8C | PO4640166555 | 100 | 287 | 218 | 648 | 4 | 2021-11-03 | 34.20 | 0.86 | 2021-10-22 | 6 | 3.40 | 1 | 34.20 | 1 | SO44119 | 2021-10-29 | 2.74 | 20.38 | 5.70 | |||
SO58909_40 | EBC4-496C-90 | PO19343180161 | 100 | 282 | 243 | 24 | 4 | 2024-02-02 | 858.90 | 21.47 | 2024-01-21 | 1 | 868.63 | 1 | 858.90 | 40 | SO58909 | 2024-01-28 | 68.71 | 868.63 | 858.90 | |||
SO63180_19 | B8CD-47BA-8C | PO2523117609 | 100 | 287 | 388 | 167 | 4 | 2024-04-04 | 2689.18 | 67.23 | 2024-03-23 | 4 | 713.08 | 1 | 2689.18 | 19 | SO63180 | 2024-03-30 | 215.13 | 2852.32 | 672.29 | |||
SO46964_35 | B3E6-43CC-A2 | PO15689139014 | 100 | 283 | 389 | 328 | 4 | 2022-10-03 | 3601.58 | 90.04 | 2022-09-21 | 6 | 605.65 | 1 | 3601.58 | 35 | SO46964 | 2022-09-28 | 288.13 | 3633.90 | 600.26 | |||
SO49490_26 | 0396-4322-83 | PO19343175441 | 100 | 282 | 462 | 24 | 4 | 2023-05-03 | 42.39 | 1.06 | 2023-04-21 | 3 | 9.71 | 1 | 42.39 | 26 | SO49490 | 2023-04-28 | 3.39 | 29.14 | 14.13 | |||
SO67320_6 | 771C-4E57-91 | PO5626199373 | 100 | 281 | 580 | 166 | 4 | 2024-06-03 | 4082.38 | 102.06 | 2024-05-22 | 4 | 1082.51 | 1 | 4082.38 | 6 | SO67320 | 2024-05-29 | 326.59 | 4330.04 | 1020.59 |
Generated 2024-09-20 16:27:47.973 UTC