[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 95 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO61227_12 | 9006-4208-8F | PO10730172247 | 100 | 287 | 234 | 491 | 4 | 2024-04-24 | 149.97 | 3.75 | 2024-04-12 | 5 | 38.49 | 1 | 149.97 | 12 | SO61227 | 2024-04-19 | 12.00 | 192.46 | 29.99 | |||
SO51151_46 | D7A9-4DF6-B9 | PO8787179219 | 100 | 282 | 231 | 2 | 523 | 3 | 7.54 | 2023-10-23 | 376.92 | 9.23 | 2023-10-11 | 13 | 38.49 | 1 | 369.39 | 46 | SO51151 | 2023-10-18 | 29.55 | 500.40 | 28.99 | 0.02 |
SO67327_17 | 2D2C-4C57-A2 | PO6467126287 | 100 | 283 | 490 | 660 | 3 | 2024-07-24 | 161.97 | 4.05 | 2024-07-12 | 5 | 41.57 | 1 | 161.97 | 17 | SO67327 | 2024-07-19 | 12.96 | 207.86 | 32.39 | |||
SO49510_8 | 34F7-4B7D-88 | PO8468119179 | 98 | 288 | 375 | 16 | 10 | 2023-06-23 | 2617.88 | 65.45 | 2023-06-11 | 2 | 1320.68 | 1 | 2617.88 | 8 | SO49510 | 2023-06-18 | 209.43 | 2641.37 | 1308.94 | |||
SO58948_22 | 1534-4AB5-81 | PO11774195497 | 6 | 296 | 487 | 682 | 9 | 2024-03-24 | 65.99 | 1.65 | 2024-03-12 | 2 | 20.57 | 1 | 65.99 | 22 | SO58948 | 2024-03-19 | 5.28 | 41.13 | 32.99 | |||
SO53476_7 | BF5A-472F-98 | PO16153121709 | 100 | 282 | 586 | 13 | 186 | 4 | 100.22 | 2023-12-24 | 668.12 | 14.20 | 2023-12-12 | 2 | 461.44 | 1 | 567.90 | 7 | SO53476 | 2023-12-19 | 45.43 | 922.89 | 334.06 | 0.15 |
SO50753_6 | 8073-4F97-BA | PO7569170218 | 100 | 287 | 420 | 608 | 4 | 2023-09-23 | 849.69 | 21.24 | 2023-09-11 | 6 | 104.80 | 1 | 849.69 | 6 | SO50753 | 2023-09-18 | 67.98 | 628.77 | 141.62 | |||
SO69501_26 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 476 | 345 | 4 | 2024-08-23 | 125.98 | 3.15 | 2024-08-11 | 3 | 26.18 | 1 | 125.98 | 26 | SO69501 | 2024-08-18 | 10.08 | 78.53 | 41.99 | |||
SO57062_18 | D146-4B3C-BB | PO11745129321 | 100 | 282 | 372 | 97 | 4 | 2024-02-23 | 4398.03 | 109.95 | 2024-02-11 | 3 | 1554.95 | 1 | 4398.03 | 18 | SO57062 | 2024-02-18 | 351.84 | 4664.84 | 1466.01 | |||
SO51109_48 | 0EFE-4639-BE | PO12441177944 | 36 | 295 | 569 | 13 | 302 | 8 | 100.22 | 2023-10-23 | 668.12 | 14.20 | 2023-10-11 | 2 | 461.44 | 1 | 567.90 | 48 | SO51109 | 2023-10-18 | 45.43 | 922.89 | 334.06 | 0.15 |
SO53524_12 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 222 | 2 | 611 | 5 | 5.68 | 2023-12-24 | 284.12 | 6.96 | 2023-12-12 | 14 | 13.09 | 1 | 278.44 | 12 | SO53524 | 2023-12-19 | 22.27 | 183.21 | 20.29 | 0.02 |
SO57136_27 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 234 | 433 | 1 | 2024-02-23 | 59.99 | 1.50 | 2024-02-11 | 2 | 38.49 | 1 | 59.99 | 27 | SO57136 | 2024-02-18 | 4.80 | 76.98 | 29.99 | |||
SO44780_8 | EE26-4C8F-95 | PO4147150441 | 100 | 282 | 320 | 222 | 3 | 2022-03-25 | 838.92 | 20.97 | 2022-03-13 | 2 | 413.15 | 1 | 838.92 | 8 | SO44780 | 2022-03-20 | 67.11 | 826.29 | 419.46 | |||
SO51158_4 | 0C39-4657-B5 | PO3741166917 | 100 | 285 | 287 | 404 | 5 | 2023-10-23 | 202.33 | 5.06 | 2023-10-11 | 1 | 204.63 | 1 | 202.33 | 4 | SO51158 | 2023-10-18 | 16.19 | 204.63 | 202.33 | |||
SO50321_8 | 6B3D-47E0-99 | PO8816191637 | 100 | 289 | 273 | 218 | 1 | 2023-08-23 | 607.00 | 15.17 | 2023-08-11 | 3 | 187.16 | 1 | 607.00 | 8 | SO50321 | 2023-08-18 | 48.56 | 561.47 | 202.33 | |||
SO47012_5 | 5043-4C8B-B3 | PO1914167487 | 19 | 284 | 460 | 2 | 66 | 6 | 14.61 | 2022-11-23 | 730.72 | 17.90 | 2022-11-11 | 14 | 37.12 | 1 | 716.10 | 5 | SO47012 | 2022-11-18 | 57.29 | 519.69 | 52.19 | 0.02 |
SO45336_3 | B5D2-4350-B0 | PO7221197705 | 100 | 289 | 307 | 326 | 1 | 2022-05-26 | 722.59 | 18.06 | 2022-05-14 | 1 | 623.84 | 1 | 722.59 | 3 | SO45336 | 2022-05-21 | 57.81 | 623.84 | 722.59 | |||
SO46675_3 | 1ED0-48BC-93 | PO10237173444 | 100 | 287 | 216 | 8 | 41 | 4 | 1.68 | 2022-10-23 | 16.82 | 0.38 | 2022-10-11 | 1 | 13.88 | 1 | 15.14 | 3 | SO46675 | 2022-10-18 | 1.21 | 13.88 | 16.82 | 0.10 |
SO50213_20 | E565-4331-83 | PO15370194449 | 100 | 281 | 364 | 381 | 3 | 2023-08-23 | 1943.98 | 48.60 | 2023-08-11 | 3 | 598.44 | 1 | 1943.98 | 20 | SO50213 | 2023-08-18 | 155.52 | 1795.31 | 647.99 | |||
SO53465_70 | D859-4DF3-84 | PO17574192592 | 19 | 272 | 533 | 678 | 6 | 2023-12-24 | 449.62 | 11.24 | 2023-12-12 | 3 | 136.79 | 1 | 449.62 | 70 | SO53465 | 2023-12-19 | 35.97 | 410.36 | 149.87 | |||
SO46614_16 | 0B65-4374-89 | PO15312137226 | 19 | 291 | 335 | 299 | 6 | 2022-10-23 | 2348.97 | 58.72 | 2022-10-11 | 5 | 486.71 | 1 | 2348.97 | 16 | SO46614 | 2022-10-18 | 187.92 | 2433.53 | 469.79 | |||
SO57118_33 | 69CB-481B-8D | PO5800191707 | 100 | 285 | 400 | 63 | 5 | 2024-02-23 | 111.46 | 2.79 | 2024-02-11 | 3 | 27.49 | 1 | 111.46 | 33 | SO57118 | 2024-02-18 | 8.92 | 82.48 | 37.15 | |||
SO67280_18 | D663-42E1-A2 | PO12412130838 | 100 | 281 | 482 | 3 | 670 | 3 | 3.71 | 2024-07-24 | 74.17 | 1.76 | 2024-07-12 | 15 | 3.36 | 1 | 70.46 | 18 | SO67280 | 2024-07-19 | 5.64 | 50.43 | 4.94 | 0.05 |
SO69467_5 | A38D-4E1B-93 | PO2871181396 | 100 | 283 | 471 | 522 | 2 | 2024-08-23 | 152.40 | 3.81 | 2024-08-11 | 4 | 23.75 | 1 | 152.40 | 5 | SO69467 | 2024-08-18 | 12.19 | 95.00 | 38.10 | |||
SO71818_16 | 2FCA-4131-BD | PO12470139718 | 100 | 287 | 523 | 672 | 1 | 2024-09-23 | 31.58 | 0.79 | 2024-09-11 | 1 | 23.37 | 1 | 31.58 | 16 | SO71818 | 2024-09-18 | 2.53 | 23.37 | 31.58 | |||
SO53468_39 | C577-4CE9-93 | PO17371113808 | 6 | 296 | 488 | 688 | 9 | 2023-12-24 | 291.55 | 7.29 | 2023-12-12 | 9 | 41.57 | 1 | 291.55 | 39 | SO53468 | 2023-12-19 | 23.32 | 374.15 | 32.39 | |||
SO48036_25 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 335 | 66 | 6 | 2023-02-23 | 939.59 | 23.49 | 2023-02-11 | 2 | 486.71 | 1 | 939.59 | 25 | SO48036 | 2023-02-18 | 75.17 | 973.41 | 469.79 | |||
SO46652_20 | D7E0-44F6-86 | PO3509195138 | 36 | 292 | 460 | 139 | 7 | 2022-10-23 | 269.97 | 6.75 | 2022-10-11 | 5 | 37.12 | 1 | 269.97 | 20 | SO46652 | 2022-10-18 | 21.60 | 185.60 | 53.99 | |||
SO48071_23 | E6F7-41F8-92 | PO6525193011 | 100 | 283 | 410 | 345 | 4 | 2023-02-23 | 72.89 | 1.82 | 2023-02-11 | 2 | 26.97 | 1 | 72.89 | 23 | SO48071 | 2023-02-18 | 5.83 | 53.94 | 36.45 | |||
SO55269_34 | C087-4A55-8D | PO899192335 | 100 | 289 | 547 | 290 | 1 | 2024-01-23 | 242.97 | 6.07 | 2024-01-11 | 5 | 35.96 | 1 | 242.97 | 34 | SO55269 | 2024-01-18 | 19.44 | 179.80 | 48.59 | |||
SO47352_18 | 9DF5-4A88-9C | PO19633111392 | 100 | 287 | 447 | 149 | 3 | 2022-12-24 | 75.00 | 1.88 | 2022-12-12 | 5 | 10.31 | 1 | 75.00 | 18 | SO47352 | 2022-12-19 | 6.00 | 51.56 | 15.00 |
Generated 2024-11-10 05:00:15.622 UTC