[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 833 > < TAKE 24 >
24 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48754_36 | FC6A-4A9E-83 | PO18473150383 | 19 | 291 | 460 | 442 | 6 | 2023-03-06 | 161.98 | 4.05 | 2023-02-22 | 3 | 37.12 | 1 | 161.98 | 36 | SO48754 | 2023-03-01 | 12.96 | 111.36 | 53.99 | |||
SO51832_46 | 475C-432F-B2 | PO4466177904 | 19 | 291 | 488 | 352 | 6 | 2023-10-04 | 129.58 | 3.24 | 2023-09-22 | 4 | 41.57 | 1 | 129.58 | 46 | SO51832 | 2023-09-29 | 10.37 | 166.29 | 32.39 | |||
SO46038_10 | D7B6-499A-87 | PO17748117802 | 19 | 284 | 275 | 102 | 6 | 2022-07-04 | 1070.69 | 26.77 | 2022-06-22 | 3 | 352.14 | 1 | 1070.69 | 10 | SO46038 | 2022-06-29 | 85.66 | 1056.42 | 356.90 | |||
SO71891_3 | A2BC-4140-A6 | PO7366158003 | 19 | 284 | 554 | 372 | 6 | 2024-08-04 | 54.94 | 1.37 | 2024-07-23 | 1 | 40.66 | 1 | 54.94 | 3 | SO71891 | 2024-07-30 | 4.40 | 40.66 | 54.94 | |||
SO67270_28 | 685A-440D-8C | PO14732111382 | 19 | 291 | 408 | 514 | 6 | 2024-06-04 | 144.32 | 3.61 | 2024-05-23 | 2 | 53.40 | 1 | 144.32 | 28 | SO67270 | 2024-05-30 | 11.55 | 106.80 | 72.16 | |||
SO46614_11 | 0B65-4374-89 | PO15312137226 | 19 | 291 | 447 | 2 | 299 | 6 | 3.19 | 2022-09-03 | 159.50 | 3.91 | 2022-08-22 | 11 | 10.31 | 1 | 156.31 | 11 | SO46614 | 2022-08-29 | 12.50 | 113.44 | 14.50 | 0.02 |
SO44765_6 | 54D5-4FF7-BB | PO11107155025 | 19 | 284 | 262 | 156 | 6 | 2022-02-03 | 183.94 | 4.60 | 2022-01-22 | 1 | 181.49 | 1 | 183.94 | 6 | SO44765 | 2022-01-29 | 14.72 | 181.49 | 183.94 | |||
SO58925_9 | ACBD-43C3-A2 | PO15544139465 | 19 | 284 | 565 | 282 | 6 | 2024-02-03 | 1781.64 | 44.54 | 2024-01-22 | 4 | 461.44 | 1 | 1781.64 | 9 | SO58925 | 2024-01-29 | 142.53 | 1845.78 | 445.41 | |||
SO47662_8 | 9790-4A85-BE | PO18473142607 | 19 | 291 | 367 | 442 | 6 | 2022-12-04 | 1943.98 | 48.60 | 2022-11-22 | 3 | 598.44 | 1 | 1943.98 | 8 | SO47662 | 2022-11-29 | 155.52 | 1795.31 | 647.99 | |||
SO43898_24 | 420C-4ECE-85 | PO4901196283 | 19 | 284 | 324 | 84 | 6 | 2021-10-04 | 2097.29 | 52.43 | 2021-09-22 | 5 | 413.15 | 1 | 2097.29 | 24 | SO43898 | 2021-09-29 | 167.78 | 2065.73 | 419.46 | |||
SO49828_30 | 8223-49DF-83 | PO14732189078 | 19 | 291 | 233 | 514 | 6 | 2023-06-04 | 288.40 | 7.21 | 2023-05-23 | 10 | 29.08 | 1 | 288.40 | 30 | SO49828 | 2023-05-30 | 23.07 | 290.81 | 28.84 | |||
SO57024_36 | DED7-4CEF-90 | PO17661138970 | 19 | 284 | 558 | 264 | 6 | 2024-01-04 | 242.99 | 6.07 | 2023-12-23 | 1 | 179.82 | 1 | 242.99 | 36 | SO57024 | 2023-12-30 | 19.44 | 179.82 | 242.99 | |||
SO50716_30 | 0B80-45BD-98 | PO18299117393 | 19 | 291 | 410 | 118 | 6 | 2023-08-04 | 36.45 | 0.91 | 2023-07-23 | 1 | 26.97 | 1 | 36.45 | 30 | SO50716 | 2023-07-30 | 2.92 | 26.97 | 36.45 | |||
SO49066_10 | 4065-4B0A-A2 | PO1595117888 | 19 | 284 | 464 | 426 | 6 | 2023-04-06 | 56.52 | 1.41 | 2023-03-25 | 4 | 9.71 | 1 | 56.52 | 10 | SO49066 | 2023-04-01 | 4.52 | 38.85 | 14.13 | |||
SO57013_4 | E12C-431B-BD | PO19691121735 | 19 | 291 | 474 | 353 | 6 | 2024-01-04 | 125.98 | 3.15 | 2023-12-23 | 3 | 26.18 | 1 | 125.98 | 4 | SO57013 | 2023-12-30 | 10.08 | 78.53 | 41.99 | |||
SO53456_4 | 9F7E-451F-8E | PO19401178762 | 19 | 291 | 482 | 2 | 173 | 6 | 1.15 | 2023-11-04 | 57.36 | 1.41 | 2023-10-23 | 11 | 3.36 | 1 | 56.21 | 4 | SO53456 | 2023-10-30 | 4.50 | 36.99 | 5.21 | 0.02 |
SO47380_12 | EF71-4036-91 | PO14790123967 | 19 | 291 | 448 | 497 | 6 | 2022-11-04 | 35.98 | 0.90 | 2022-10-23 | 3 | 8.25 | 1 | 35.98 | 12 | SO47380 | 2022-10-30 | 2.88 | 24.74 | 11.99 | |||
SO45527_14 | 610E-44BC-87 | PO17545114353 | 19 | 288 | 318 | 155 | 6 | 2022-05-04 | 874.79 | 21.87 | 2022-04-22 | 1 | 884.71 | 1 | 874.79 | 14 | SO45527 | 2022-04-29 | 69.98 | 884.71 | 874.79 | |||
SO51847_3 | 7E3E-4DB0-80 | PO2030165560 | 19 | 284 | 597 | 661 | 6 | 2023-10-04 | 971.98 | 24.30 | 2023-09-22 | 3 | 294.58 | 1 | 971.98 | 3 | SO51847 | 2023-09-29 | 77.76 | 883.74 | 323.99 | |||
SO47359_43 | 8BC9-458A-82 | PO18299145297 | 19 | 291 | 462 | 118 | 6 | 2022-11-04 | 56.52 | 1.41 | 2022-10-23 | 4 | 9.71 | 1 | 56.52 | 43 | SO47359 | 2022-10-30 | 4.52 | 38.85 | 14.13 | |||
SO65238_33 | 896A-4ED1-B1 | PO10875188169 | 19 | 291 | 561 | 281 | 6 | 2024-05-04 | 2860.88 | 71.52 | 2024-04-22 | 2 | 1481.94 | 1 | 2860.88 | 33 | SO65238 | 2024-04-29 | 228.87 | 2963.88 | 1430.44 | |||
SO45529_4 | 86CC-47BA-B3 | PO17574182721 | 19 | 288 | 351 | 678 | 6 | 2022-05-04 | 18224.95 | 455.62 | 2022-04-22 | 9 | 1898.09 | 1 | 18224.95 | 4 | SO45529 | 2022-04-29 | 1458.00 | 17082.85 | 2024.99 | |||
SO49855_27 | 0C94-4D84-A4 | PO18473166459 | 19 | 291 | 428 | 442 | 6 | 2023-06-04 | 837.02 | 20.93 | 2023-05-23 | 4 | 185.82 | 1 | 837.02 | 27 | SO49855 | 2023-05-30 | 66.96 | 743.28 | 209.26 | |||
SO55275_7 | 72C3-4048-BC | PO1711122362 | 19 | 291 | 309 | 245 | 6 | 2023-12-04 | 2456.10 | 61.40 | 2023-11-22 | 3 | 747.20 | 1 | 2456.10 | 7 | SO55275 | 2023-11-29 | 196.49 | 2241.60 | 818.70 |
Generated 2024-09-21 07:32:14.616 UTC