[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 2260 > < TAKE 48 >
48 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO63132_1 | C9E0-492C-AA | PO18705140198 | 19 | 291 | 386 | 479 | 6 | 2024-05-26 | 2016.88 | 50.42 | 2024-05-14 | 3 | 713.08 | 1 | 2016.88 | 1 | SO63132 | 2024-05-21 | 161.35 | 2139.24 | 672.29 | |||
SO69401_9 | 5377-4B5B-80 | PO17603155358 | 19 | 284 | 231 | 12 | 6 | 2024-08-24 | 179.96 | 4.50 | 2024-08-12 | 6 | 38.49 | 1 | 179.96 | 9 | SO69401 | 2024-08-19 | 14.40 | 230.95 | 29.99 | |||
SO53527_12 | 0EBE-4ACB-B5 | PO1798140946 | 19 | 291 | 542 | 10 | 6 | 2023-12-25 | 97.18 | 2.43 | 2023-12-13 | 4 | 17.98 | 1 | 97.18 | 12 | SO53527 | 2023-12-20 | 7.77 | 71.91 | 24.29 | |||
SO51704_42 | 13FA-4729-A9 | PO17661178081 | 19 | 284 | 490 | 264 | 6 | 2023-11-24 | 291.55 | 7.29 | 2023-11-12 | 9 | 41.57 | 1 | 291.55 | 42 | SO51704 | 2023-11-19 | 23.32 | 374.15 | 32.39 | |||
SO49485_1 | 9EA5-4DEF-B8 | PO17545171443 | 19 | 291 | 373 | 155 | 6 | 2023-06-24 | 2617.88 | 65.45 | 2023-06-12 | 2 | 1320.68 | 1 | 2617.88 | 1 | SO49485 | 2023-06-19 | 209.43 | 2641.37 | 1308.94 | |||
SO48023_15 | 18BD-4FA3-9F | PO11020197101 | 19 | 284 | 335 | 336 | 6 | 2023-02-24 | 469.79 | 11.74 | 2023-02-12 | 1 | 486.71 | 1 | 469.79 | 15 | SO48023 | 2023-02-19 | 37.58 | 486.71 | 469.79 | |||
SO55283_12 | 8D6B-460A-83 | PO18473174493 | 19 | 291 | 533 | 442 | 6 | 2024-01-24 | 299.75 | 7.49 | 2024-01-12 | 2 | 136.79 | 1 | 299.75 | 12 | SO55283 | 2024-01-19 | 23.98 | 273.57 | 149.87 | |||
SO49879_12 | 7A79-4FB0-85 | PO4495112714 | 19 | 291 | 358 | 496 | 6 | 2023-07-25 | 8606.21 | 215.16 | 2023-07-13 | 7 | 1105.81 | 1 | 8606.21 | 12 | SO49879 | 2023-07-20 | 688.50 | 7740.67 | 1229.46 | |||
SO49496_29 | 1BAD-4D34-B0 | PO10614179686 | 19 | 291 | 379 | 461 | 6 | 2023-06-24 | 1308.94 | 32.72 | 2023-06-12 | 1 | 1320.68 | 1 | 1308.94 | 29 | SO49496 | 2023-06-19 | 104.72 | 1320.68 | 1308.94 | |||
SO57097_2 | 9A9E-444B-B1 | PO18328123706 | 19 | 284 | 481 | 552 | 6 | 2024-02-24 | 32.36 | 0.81 | 2024-02-12 | 6 | 3.36 | 1 | 32.36 | 2 | SO57097 | 2024-02-19 | 2.59 | 20.17 | 5.39 | |||
SO48779_2 | 1E4A-4963-9E | PO4930175427 | 19 | 291 | 470 | 425 | 6 | 2023-04-26 | 136.76 | 3.42 | 2023-04-14 | 6 | 15.67 | 1 | 136.76 | 2 | SO48779 | 2023-04-21 | 10.94 | 94.03 | 22.79 | |||
SO46062_20 | 114A-41C0-B5 | PO11600112515 | 19 | 288 | 229 | 569 | 6 | 2022-08-24 | 86.52 | 2.16 | 2022-08-12 | 3 | 31.72 | 1 | 86.52 | 20 | SO46062 | 2022-08-19 | 6.92 | 95.17 | 28.84 | |||
SO57023_16 | EE6C-4089-A0 | PO17603140236 | 19 | 284 | 217 | 12 | 6 | 2024-02-24 | 188.95 | 4.72 | 2024-02-12 | 9 | 13.09 | 1 | 188.95 | 16 | SO57023 | 2024-02-19 | 15.12 | 117.78 | 20.99 | |||
SO57023_32 | EE6C-4089-A0 | PO17603140236 | 19 | 284 | 546 | 12 | 6 | 2024-02-24 | 111.76 | 2.79 | 2024-02-12 | 3 | 27.57 | 1 | 111.76 | 32 | SO57023 | 2024-02-19 | 8.94 | 82.70 | 37.25 | |||
SO45781_1 | EB85-4E0C-A3 | PO18444138991 | 19 | 288 | 232 | 227 | 6 | 2022-07-25 | 57.68 | 1.44 | 2022-07-13 | 2 | 31.72 | 1 | 57.68 | 1 | SO45781 | 2022-07-20 | 4.61 | 63.45 | 28.84 | |||
SO49485_19 | 9EA5-4DEF-B8 | PO17545171443 | 19 | 291 | 343 | 155 | 6 | 2023-06-24 | 2348.97 | 58.72 | 2023-06-12 | 5 | 486.71 | 1 | 2348.97 | 19 | SO49485 | 2023-06-19 | 187.92 | 2433.53 | 469.79 | |||
SO44765_6 | 54D5-4FF7-BB | PO11107155025 | 19 | 284 | 262 | 156 | 6 | 2022-03-26 | 183.94 | 4.60 | 2022-03-14 | 1 | 181.49 | 1 | 183.94 | 6 | SO44765 | 2022-03-21 | 14.72 | 181.49 | 183.94 | |||
SO51850_38 | 57A9-4C32-8B | PO1856170170 | 19 | 291 | 574 | 263 | 6 | 2023-11-24 | 2860.88 | 71.52 | 2023-11-12 | 2 | 1481.94 | 1 | 2860.88 | 38 | SO51850 | 2023-11-19 | 228.87 | 2963.88 | 1430.44 | |||
SO53483_32 | A0BE-40E0-81 | PO14761137153 | 19 | 284 | 492 | 408 | 6 | 2023-12-25 | 1204.69 | 30.12 | 2023-12-13 | 2 | 601.74 | 1 | 1204.69 | 32 | SO53483 | 2023-12-20 | 96.38 | 1203.49 | 602.35 | |||
SO63132_28 | C9E0-492C-AA | PO18705140198 | 19 | 291 | 491 | 479 | 6 | 2024-05-26 | 97.18 | 2.43 | 2024-05-14 | 3 | 41.57 | 1 | 97.18 | 28 | SO63132 | 2024-05-21 | 7.77 | 124.72 | 32.39 | |||
SO47365_34 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 419 | 678 | 6 | 2022-12-25 | 315.88 | 7.90 | 2022-12-13 | 6 | 38.96 | 1 | 315.88 | 34 | SO47365 | 2022-12-20 | 25.27 | 233.75 | 52.65 | |||
SO45054_6 | 308A-4BE0-A7 | PO12760127685 | 19 | 288 | 328 | 83 | 6 | 2022-04-26 | 838.92 | 20.97 | 2022-04-14 | 2 | 413.15 | 1 | 838.92 | 6 | SO45054 | 2022-04-21 | 67.11 | 826.29 | 419.46 | |||
SO55280_8 | B925-404B-8B | PO18444178908 | 19 | 291 | 581 | 227 | 6 | 2024-01-24 | 10205.94 | 255.15 | 2024-01-12 | 10 | 1082.51 | 1 | 10205.94 | 8 | SO55280 | 2024-01-19 | 816.48 | 10825.10 | 1020.59 | |||
SO46607_31 | C1B5-40D6-8D | PO18444137892 | 19 | 291 | 339 | 227 | 6 | 2022-10-24 | 2818.76 | 70.47 | 2022-10-12 | 6 | 486.71 | 1 | 2818.76 | 31 | SO46607 | 2022-10-19 | 225.50 | 2920.24 | 469.79 | |||
SO49828_50 | 8223-49DF-83 | PO14732189078 | 19 | 291 | 329 | 514 | 6 | 2023-07-25 | 4228.15 | 105.70 | 2023-07-13 | 9 | 486.71 | 1 | 4228.15 | 50 | SO49828 | 2023-07-20 | 338.25 | 4380.36 | 469.79 | |||
SO49468_2 | DB7C-4159-88 | PO1885116335 | 19 | 284 | 356 | 588 | 6 | 2023-06-24 | 3728.56 | 93.21 | 2023-06-12 | 3 | 1117.86 | 1 | 3728.56 | 2 | SO49468 | 2023-06-19 | 298.28 | 3353.57 | 1242.85 | |||
SO71827_15 | C6C1-47DB-95 | PO11107195325 | 19 | 284 | 605 | 156 | 6 | 2024-09-24 | 971.98 | 24.30 | 2024-09-12 | 3 | 343.65 | 1 | 971.98 | 15 | SO71827 | 2024-09-19 | 77.76 | 1030.95 | 323.99 | |||
SO51132_11 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 520 | 227 | 6 | 2023-10-24 | 126.34 | 3.16 | 2023-10-12 | 4 | 23.37 | 1 | 126.34 | 11 | SO51132 | 2023-10-19 | 10.11 | 93.49 | 31.58 | |||
SO47365_2 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 294 | 678 | 6 | 2022-12-25 | 2232.82 | 55.82 | 2022-12-13 | 3 | 660.91 | 1 | 2232.82 | 2 | SO47365 | 2022-12-20 | 178.63 | 1982.74 | 744.27 | |||
SO53513_20 | 5E21-438C-B3 | PO10875194431 | 19 | 291 | 487 | 281 | 6 | 2023-12-25 | 230.96 | 5.77 | 2023-12-13 | 7 | 20.57 | 1 | 230.96 | 20 | SO53513 | 2023-12-20 | 18.48 | 143.96 | 32.99 | |||
SO48053_12 | 69FC-4D14-B1 | PO4466199959 | 19 | 291 | 213 | 352 | 6 | 2023-02-24 | 80.75 | 2.02 | 2023-02-12 | 4 | 13.88 | 1 | 80.75 | 12 | SO48053 | 2023-02-19 | 6.46 | 55.51 | 20.19 | |||
SO51847_6 | 7E3E-4DB0-80 | PO2030165560 | 19 | 284 | 594 | 661 | 6 | 2023-11-24 | 338.99 | 8.47 | 2023-11-12 | 1 | 308.22 | 1 | 338.99 | 6 | SO51847 | 2023-11-19 | 27.12 | 308.22 | 338.99 | |||
SO67268_21 | 9708-4E22-A4 | PO15312122688 | 19 | 291 | 234 | 3 | 299 | 6 | 22.00 | 2024-07-25 | 439.91 | 10.45 | 2024-07-13 | 16 | 38.49 | 1 | 417.92 | 21 | SO67268 | 2024-07-20 | 33.43 | 615.88 | 27.49 | 0.05 |
SO49511_4 | 30C7-4926-8C | PO11107118911 | 19 | 284 | 323 | 156 | 6 | 2023-06-24 | 469.79 | 11.74 | 2023-06-12 | 1 | 486.71 | 1 | 469.79 | 4 | SO49511 | 2023-06-19 | 37.58 | 486.71 | 469.79 | |||
SO47354_20 | 6E1C-48C6-89 | PO19401144959 | 19 | 291 | 464 | 173 | 6 | 2022-12-25 | 56.52 | 1.41 | 2022-12-13 | 4 | 9.71 | 1 | 56.52 | 20 | SO47354 | 2022-12-20 | 4.52 | 38.85 | 14.13 | |||
SO45323_1 | 8E16-4834-8A | PO4901118407 | 19 | 284 | 315 | 84 | 6 | 2022-05-27 | 3499.18 | 87.48 | 2022-05-15 | 4 | 884.71 | 1 | 3499.18 | 1 | SO45323 | 2022-05-22 | 279.93 | 3538.83 | 874.79 | |||
SO47973_34 | B9F1-47DA-87 | PO18705118148 | 19 | 291 | 407 | 479 | 6 | 2023-02-24 | 65.60 | 1.64 | 2023-02-12 | 1 | 48.55 | 1 | 65.60 | 34 | SO47973 | 2023-02-19 | 5.25 | 48.55 | 65.60 | |||
SO46616_36 | 1264-43E6-B7 | PO14732122562 | 19 | 291 | 267 | 514 | 6 | 2022-10-24 | 404.66 | 10.12 | 2022-10-12 | 2 | 187.16 | 1 | 404.66 | 36 | SO46616 | 2022-10-19 | 32.37 | 374.31 | 202.33 | |||
SO46607_8 | C1B5-40D6-8D | PO18444137892 | 19 | 291 | 423 | 227 | 6 | 2022-10-24 | 330.46 | 8.26 | 2022-10-12 | 2 | 122.27 | 1 | 330.46 | 8 | SO46607 | 2022-10-19 | 26.44 | 244.54 | 165.23 | |||
SO48340_10 | EC75-4D61-8C | PO10962142990 | 19 | 284 | 356 | 685 | 6 | 2023-03-26 | 4971.41 | 124.29 | 2023-03-14 | 4 | 1117.86 | 1 | 4971.41 | 10 | SO48340 | 2023-03-21 | 397.71 | 4471.42 | 1242.85 | |||
SO48296_26 | FC37-4F3E-BB | PO19401157526 | 19 | 291 | 371 | 173 | 6 | 2023-03-26 | 1308.94 | 32.72 | 2023-03-14 | 1 | 1320.68 | 1 | 1308.94 | 26 | SO48296 | 2023-03-21 | 104.72 | 1320.68 | 1308.94 | |||
SO53483_29 | A0BE-40E0-81 | PO14761137153 | 19 | 284 | 496 | 408 | 6 | 2023-12-25 | 2409.38 | 60.23 | 2023-12-13 | 4 | 601.74 | 1 | 2409.38 | 29 | SO53483 | 2023-12-20 | 192.75 | 2406.97 | 602.35 | |||
SO46039_3 | D5C9-4969-86 | PO17313170717 | 19 | 288 | 346 | 389 | 6 | 2022-08-24 | 4079.99 | 102.00 | 2022-08-12 | 2 | 1912.15 | 1 | 4079.99 | 3 | SO46039 | 2022-08-19 | 326.40 | 3824.31 | 2039.99 | |||
SO53509_4 | 4718-4C12-86 | PO11107182902 | 19 | 284 | 491 | 156 | 6 | 2023-12-25 | 194.36 | 4.86 | 2023-12-13 | 6 | 41.57 | 1 | 194.36 | 4 | SO53509 | 2023-12-20 | 15.55 | 249.43 | 32.39 | |||
SO47980_9 | 4C76-4276-8E | PO17603160708 | 19 | 284 | 453 | 12 | 6 | 2023-02-24 | 107.98 | 2.70 | 2023-02-12 | 3 | 24.75 | 1 | 107.98 | 9 | SO47980 | 2023-02-19 | 8.64 | 74.24 | 35.99 | |||
SO71800_14 | 6DBE-44CC-BD | PO15544127760 | 19 | 284 | 559 | 282 | 6 | 2024-09-24 | 12.14 | 0.30 | 2024-09-12 | 1 | 8.99 | 1 | 12.14 | 14 | SO71800 | 2024-09-19 | 0.97 | 8.99 | 12.14 | |||
SO47359_43 | 8BC9-458A-82 | PO18299145297 | 19 | 291 | 462 | 118 | 6 | 2022-12-25 | 56.52 | 1.41 | 2022-12-13 | 4 | 9.71 | 1 | 56.52 | 43 | SO47359 | 2022-12-20 | 4.52 | 38.85 | 14.13 | |||
SO58911_7 | C991-4920-91 | PO19401135315 | 19 | 291 | 606 | 173 | 6 | 2024-03-25 | 323.99 | 8.10 | 2024-03-13 | 1 | 343.65 | 1 | 323.99 | 7 | SO58911 | 2024-03-20 | 25.92 | 343.65 | 323.99 |
Generated 2024-11-11 05:09:42.720 UTC