[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 781 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO67268_38 | 9708-4E22-A4 | PO15312122688 | 19 | 291 | 477 | 2 | 299 | 6 | 0.64 | 2024-07-26 | 31.84 | 0.78 | 2024-07-14 | 11 | 1.87 | 1 | 31.20 | 38 | SO67268 | 2024-07-21 | 2.50 | 20.53 | 2.89 | 0.02 |
SO44750_14 | B71E-4BBF-B5 | PO17574147002 | 19 | 288 | 215 | 678 | 6 | 2022-03-27 | 121.12 | 3.03 | 2022-03-15 | 6 | 12.03 | 1 | 121.12 | 14 | SO44750 | 2022-03-22 | 9.69 | 72.17 | 20.19 | |||
SO49879_28 | 7A79-4FB0-85 | PO4495112714 | 19 | 291 | 360 | 496 | 6 | 2023-07-26 | 9835.67 | 245.89 | 2023-07-14 | 8 | 1105.81 | 1 | 9835.67 | 28 | SO49879 | 2023-07-21 | 786.85 | 8846.48 | 1229.46 | |||
SO51700_19 | 6837-439E-BC | PO17806126316 | 19 | 291 | 477 | 101 | 6 | 2023-11-25 | 11.98 | 0.30 | 2023-11-13 | 4 | 1.87 | 1 | 11.98 | 19 | SO51700 | 2023-11-20 | 0.96 | 7.47 | 2.99 | |||
SO47354_46 | 6E1C-48C6-89 | PO19401144959 | 19 | 291 | 383 | 173 | 6 | 2022-12-26 | 1800.79 | 45.02 | 2022-12-14 | 3 | 605.65 | 1 | 1800.79 | 46 | SO47354 | 2022-12-21 | 144.06 | 1816.95 | 600.26 | |||
SO53513_6 | 5E21-438C-B3 | PO10875194431 | 19 | 291 | 467 | 281 | 6 | 2023-12-26 | 44.08 | 1.10 | 2023-12-14 | 3 | 9.16 | 1 | 44.08 | 6 | SO53513 | 2023-12-21 | 3.53 | 27.48 | 14.69 | |||
SO43661_4 | 4E0A-4F89-AE | PO18473189620 | 19 | 288 | 223 | 442 | 6 | 2021-10-25 | 20.75 | 0.52 | 2021-10-13 | 4 | 5.71 | 1 | 20.75 | 4 | SO43661 | 2021-10-20 | 1.66 | 22.82 | 5.19 | |||
SO47397_12 | B964-4D2F-B3 | PO11107130091 | 19 | 284 | 448 | 156 | 6 | 2022-12-26 | 11.99 | 0.30 | 2022-12-14 | 1 | 8.25 | 1 | 11.99 | 12 | SO47397 | 2022-12-21 | 0.96 | 8.25 | 11.99 | |||
SO57022_7 | 9202-4FEB-88 | PO17806175482 | 19 | 291 | 605 | 101 | 6 | 2024-02-25 | 647.99 | 16.20 | 2024-02-13 | 2 | 343.65 | 1 | 647.99 | 7 | SO57022 | 2024-02-20 | 51.84 | 687.30 | 323.99 | |||
SO50699_14 | FEA0-4613-AE | PO1885169186 | 19 | 284 | 366 | 588 | 6 | 2023-09-25 | 647.99 | 16.20 | 2023-09-13 | 1 | 598.44 | 1 | 647.99 | 14 | SO50699 | 2023-09-20 | 51.84 | 598.44 | 647.99 | |||
SO44504_16 | CFE2-4C08-B0 | PO16733198490 | 19 | 288 | 319 | 533 | 6 | 2022-02-25 | 874.79 | 21.87 | 2022-02-13 | 1 | 884.71 | 1 | 874.79 | 16 | SO44504 | 2022-02-20 | 69.98 | 884.71 | 874.79 | |||
SO57093_38 | 2F7C-4AF6-8B | PO18705165751 | 19 | 291 | 484 | 479 | 6 | 2024-02-25 | 14.31 | 0.36 | 2024-02-13 | 3 | 2.97 | 1 | 14.31 | 38 | SO57093 | 2024-02-20 | 1.14 | 8.92 | 4.77 | |||
SO48059_29 | E21D-4968-B0 | PO4901134783 | 19 | 284 | 254 | 84 | 6 | 2023-02-25 | 183.94 | 4.60 | 2023-02-13 | 1 | 170.14 | 1 | 183.94 | 29 | SO48059 | 2023-02-20 | 14.72 | 170.14 | 183.94 | |||
SO47413_24 | E274-4280-9B | PO1885161774 | 19 | 284 | 358 | 588 | 6 | 2022-12-26 | 3688.38 | 92.21 | 2022-12-14 | 3 | 1105.81 | 1 | 3688.38 | 24 | SO47413 | 2022-12-21 | 295.07 | 3317.43 | 1229.46 | |||
SO45284_1 | 57F0-404F-97 | PO16733112744 | 19 | 288 | 328 | 533 | 6 | 2022-05-28 | 838.92 | 20.97 | 2022-05-16 | 2 | 413.15 | 1 | 838.92 | 1 | SO45284 | 2022-05-23 | 67.11 | 826.29 | 419.46 | |||
SO46086_16 | 56A8-4607-A0 | PO4901123378 | 19 | 284 | 338 | 84 | 6 | 2022-08-25 | 838.92 | 20.97 | 2022-08-13 | 2 | 413.15 | 1 | 838.92 | 16 | SO46086 | 2022-08-20 | 67.11 | 826.29 | 419.46 | |||
SO47673_12 | AFCF-4DA6-99 | PO13862175462 | 19 | 291 | 358 | 119 | 6 | 2023-01-25 | 2458.92 | 61.47 | 2023-01-13 | 2 | 1105.81 | 1 | 2458.92 | 12 | SO47673 | 2023-01-20 | 196.71 | 2211.62 | 1229.46 | |||
SO49484_9 | B25F-4DF4-8E | PO18299142683 | 19 | 291 | 448 | 118 | 6 | 2023-06-25 | 71.96 | 1.80 | 2023-06-13 | 6 | 8.25 | 1 | 71.96 | 9 | SO49484 | 2023-06-20 | 5.76 | 49.48 | 11.99 | |||
SO48306_37 | EA27-471A-9D | PO17574166075 | 19 | 291 | 216 | 678 | 6 | 2023-03-27 | 181.68 | 4.54 | 2023-03-15 | 9 | 13.88 | 1 | 181.68 | 37 | SO48306 | 2023-03-22 | 14.53 | 124.90 | 20.19 | |||
SO69560_1 | B1B6-43F4-BC | PO9077167302 | 19 | 291 | 542 | 100 | 6 | 2024-08-25 | 24.29 | 0.61 | 2024-08-13 | 1 | 17.98 | 1 | 24.29 | 1 | SO69560 | 2024-08-20 | 1.94 | 17.98 | 24.29 | |||
SO44498_11 | 7715-4053-B5 | PO17748167942 | 19 | 284 | 330 | 102 | 6 | 2022-02-25 | 838.92 | 20.97 | 2022-02-13 | 2 | 413.15 | 1 | 838.92 | 11 | SO44498 | 2022-02-20 | 67.11 | 826.29 | 419.46 | |||
SO51092_37 | FB68-47B7-9D | PO15312133079 | 19 | 291 | 545 | 299 | 6 | 2023-10-25 | 97.18 | 2.43 | 2023-10-13 | 4 | 17.98 | 1 | 97.18 | 37 | SO51092 | 2023-10-20 | 7.77 | 71.91 | 24.29 | |||
SO50284_40 | F8D1-49E1-A5 | PO4901178867 | 19 | 284 | 464 | 84 | 6 | 2023-08-25 | 113.03 | 2.83 | 2023-08-13 | 8 | 9.71 | 1 | 113.03 | 40 | SO50284 | 2023-08-20 | 9.04 | 77.71 | 14.13 | |||
SO51124_24 | 5EEF-4271-BB | PO1711177181 | 19 | 291 | 398 | 245 | 6 | 2023-10-25 | 213.79 | 5.34 | 2023-10-13 | 8 | 19.78 | 1 | 213.79 | 24 | SO51124 | 2023-10-20 | 17.10 | 158.21 | 26.72 | |||
SO61177_17 | DA64-4BC0-A0 | PO18473117778 | 19 | 291 | 552 | 442 | 6 | 2024-04-26 | 274.47 | 6.86 | 2024-04-14 | 5 | 40.62 | 1 | 274.47 | 17 | SO61177 | 2024-04-21 | 21.96 | 203.11 | 54.89 | |||
SO48299_21 | ABFA-41A9-A7 | PO18299110324 | 19 | 291 | 294 | 118 | 6 | 2023-03-27 | 744.27 | 18.61 | 2023-03-15 | 1 | 660.91 | 1 | 744.27 | 21 | SO48299 | 2023-03-22 | 59.54 | 660.91 | 744.27 | |||
SO47380_18 | EF71-4036-91 | PO14790123967 | 19 | 291 | 364 | 497 | 6 | 2022-12-26 | 1943.98 | 48.60 | 2022-12-14 | 3 | 598.44 | 1 | 1943.98 | 18 | SO47380 | 2022-12-21 | 155.52 | 1795.31 | 647.99 | |||
SO48750_34 | 9A71-449E-B6 | PO14732147398 | 19 | 291 | 417 | 514 | 6 | 2023-04-27 | 973.36 | 24.33 | 2023-04-15 | 3 | 300.12 | 1 | 973.36 | 34 | SO48750 | 2023-04-22 | 77.87 | 900.36 | 324.45 |
Generated 2024-11-13 03:41:27.145 UTC