[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 190 > < TAKE 30 >
30 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO43855_11 | FB88-4B92-82 | PO17748116016 | 19 | 284 | 262 | 102 | 6 | 2021-10-02 | 183.94 | 4.60 | 2021-09-20 | 1 | 181.49 | 1 | 183.94 | 11 | SO43855 | 2021-09-27 | 14.72 | 181.49 | 183.94 | |||
SO55308_1 | 9C2E-4321-8F | PO4930120456 | 19 | 291 | 361 | 425 | 6 | 2023-12-02 | 1376.99 | 34.42 | 2023-11-20 | 1 | 1251.98 | 1 | 1376.99 | 1 | SO55308 | 2023-11-27 | 110.16 | 1251.98 | 1376.99 | |||
SO49827_36 | E4F0-4B91-84 | PO15312199090 | 19 | 291 | 461 | 299 | 6 | 2023-06-02 | 161.98 | 4.05 | 2023-05-21 | 3 | 37.12 | 1 | 161.98 | 36 | SO49827 | 2023-05-28 | 12.96 | 111.36 | 53.99 | |||
SO49828_25 | 8223-49DF-83 | PO14732189078 | 19 | 291 | 377 | 514 | 6 | 2023-06-02 | 2617.88 | 65.45 | 2023-05-21 | 2 | 1320.68 | 1 | 2617.88 | 25 | SO49828 | 2023-05-28 | 209.43 | 2641.37 | 1308.94 | |||
SO69560_2 | B1B6-43F4-BC | PO9077167302 | 19 | 291 | 363 | 100 | 6 | 2024-07-02 | 1376.99 | 34.42 | 2024-06-20 | 1 | 1251.98 | 1 | 1376.99 | 2 | SO69560 | 2024-06-27 | 110.16 | 1251.98 | 1376.99 | |||
SO46360_10 | 00EC-47DF-BB | PO1885143134 | 19 | 284 | 344 | 7 | 588 | 6 | 595.00 | 2022-08-02 | 1700.00 | 27.62 | 2022-07-21 | 2 | 1912.15 | 1 | 1105.00 | 10 | SO46360 | 2022-07-28 | 88.40 | 3824.31 | 850.00 | 0.35 |
SO71851_9 | AABE-4443-91 | PO18299133687 | 19 | 291 | 306 | 118 | 6 | 2024-08-02 | 4048.80 | 101.22 | 2024-07-21 | 5 | 739.04 | 1 | 4048.80 | 9 | SO71851 | 2024-07-28 | 323.90 | 3695.21 | 809.76 | |||
SO45529_7 | 86CC-47BA-B3 | PO17574182721 | 19 | 288 | 345 | 678 | 6 | 2022-05-02 | 16319.95 | 408.00 | 2022-04-20 | 8 | 1912.15 | 1 | 16319.95 | 7 | SO45529 | 2022-04-27 | 1305.60 | 15297.24 | 2039.99 | |||
SO47366_7 | DD3E-4DAA-BA | PO17545115575 | 19 | 291 | 417 | 155 | 6 | 2022-11-02 | 648.91 | 16.22 | 2022-10-21 | 2 | 300.12 | 1 | 648.91 | 7 | SO47366 | 2022-10-28 | 51.91 | 600.24 | 324.45 | |||
SO53600_16 | 8E02-463C-A5 | PO2233133950 | 19 | 291 | 484 | 262 | 6 | 2023-11-02 | 14.31 | 0.36 | 2023-10-21 | 3 | 2.97 | 1 | 14.31 | 16 | SO53600 | 2023-10-28 | 1.14 | 8.92 | 4.77 | |||
SO53536_12 | 5C09-4051-92 | PO18299189909 | 19 | 291 | 533 | 118 | 6 | 2023-11-02 | 149.87 | 3.75 | 2023-10-21 | 1 | 136.79 | 1 | 149.87 | 12 | SO53536 | 2023-10-28 | 11.99 | 136.79 | 149.87 | |||
SO55263_14 | 10F0-498D-AE | PO11136189942 | 19 | 284 | 552 | 120 | 6 | 2023-12-02 | 109.79 | 2.74 | 2023-11-20 | 2 | 40.62 | 1 | 109.79 | 14 | SO55263 | 2023-11-27 | 8.78 | 81.24 | 54.89 | |||
SO71841_30 | 1544-4561-AB | PO1798133189 | 19 | 291 | 532 | 10 | 6 | 2024-08-02 | 299.75 | 7.49 | 2024-07-21 | 2 | 136.79 | 1 | 299.75 | 30 | SO71841 | 2024-07-28 | 23.98 | 273.57 | 149.87 | |||
SO48306_12 | EA27-471A-9D | PO17574166075 | 19 | 291 | 445 | 678 | 6 | 2023-02-01 | 71.99 | 1.80 | 2023-01-20 | 2 | 24.75 | 1 | 71.99 | 12 | SO48306 | 2023-01-27 | 5.76 | 49.49 | 35.99 | |||
SO47365_53 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 360 | 678 | 6 | 2022-11-02 | 8606.21 | 215.16 | 2022-10-21 | 7 | 1105.81 | 1 | 8606.21 | 53 | SO47365 | 2022-10-28 | 688.50 | 7740.67 | 1229.46 | |||
SO50246_15 | F243-44EB-B2 | PO1827174701 | 19 | 291 | 414 | 317 | 6 | 2023-07-02 | 298.06 | 7.45 | 2023-06-20 | 2 | 110.28 | 1 | 298.06 | 15 | SO50246 | 2023-06-27 | 23.85 | 220.57 | 149.03 | |||
SO50245_5 | 28E4-4CC9-BF | PO1914152990 | 19 | 284 | 339 | 66 | 6 | 2023-07-02 | 939.59 | 23.49 | 2023-06-20 | 2 | 486.71 | 1 | 939.59 | 5 | SO50245 | 2023-06-27 | 75.17 | 973.41 | 469.79 | |||
SO69482_7 | 0D35-42F6-9E | PO18357170772 | 19 | 284 | 225 | 138 | 6 | 2024-07-02 | 10.79 | 0.27 | 2024-06-20 | 2 | 6.92 | 1 | 10.79 | 7 | SO69482 | 2024-06-27 | 0.86 | 13.84 | 5.39 | |||
SO46959_2 | 9007-4F97-9C | PO16733197949 | 19 | 291 | 464 | 533 | 6 | 2022-10-02 | 42.39 | 1.06 | 2022-09-20 | 3 | 9.71 | 1 | 42.39 | 2 | SO46959 | 2022-09-27 | 3.39 | 29.14 | 14.13 | |||
SO48339_45 | EAB2-42EA-9C | PO10614150674 | 19 | 291 | 265 | 461 | 6 | 2023-02-01 | 404.66 | 10.12 | 2023-01-20 | 2 | 187.16 | 1 | 404.66 | 45 | SO48339 | 2023-01-27 | 32.37 | 374.31 | 202.33 | |||
SO47662_32 | 9790-4A85-BE | PO18473142607 | 19 | 291 | 461 | 442 | 6 | 2022-12-02 | 161.98 | 4.05 | 2022-11-20 | 3 | 37.12 | 1 | 161.98 | 32 | SO47662 | 2022-11-27 | 12.96 | 111.36 | 53.99 | |||
SO65264_5 | 296E-492E-8B | PO12818156002 | 19 | 291 | 418 | 587 | 6 | 2024-05-02 | 356.90 | 8.92 | 2024-04-20 | 1 | 360.94 | 1 | 356.90 | 5 | SO65264 | 2024-04-27 | 28.55 | 360.94 | 356.90 | |||
SO58972_6 | 07C8-43BD-85 | PO1798131785 | 19 | 291 | 543 | 10 | 6 | 2024-02-01 | 149.02 | 3.73 | 2024-01-20 | 4 | 27.57 | 1 | 149.02 | 6 | SO58972 | 2024-01-27 | 11.92 | 110.27 | 37.25 | |||
SO69482_12 | 0D35-42F6-9E | PO18357170772 | 19 | 284 | 552 | 138 | 6 | 2024-07-02 | 54.89 | 1.37 | 2024-06-20 | 1 | 40.62 | 1 | 54.89 | 12 | SO69482 | 2024-06-27 | 4.39 | 40.62 | 54.89 | |||
SO69401_25 | 5377-4B5B-80 | PO17603155358 | 19 | 284 | 471 | 3 | 12 | 6 | 26.19 | 2024-07-02 | 523.88 | 12.44 | 2024-06-20 | 15 | 23.75 | 1 | 497.68 | 25 | SO69401 | 2024-06-27 | 39.81 | 356.24 | 34.93 | 0.05 |
SO50716_22 | 0B80-45BD-98 | PO18299117393 | 19 | 291 | 453 | 118 | 6 | 2023-08-02 | 251.96 | 6.30 | 2023-07-21 | 7 | 24.75 | 1 | 251.96 | 22 | SO50716 | 2023-07-28 | 20.16 | 173.22 | 35.99 | |||
SO69479_35 | 3D8D-4908-A6 | PO18328116976 | 19 | 284 | 583 | 552 | 6 | 2024-07-02 | 1020.59 | 25.51 | 2024-06-20 | 1 | 1082.51 | 1 | 1020.59 | 35 | SO69479 | 2024-06-27 | 81.65 | 1082.51 | 1020.59 | |||
SO71830_35 | DA2D-4B00-A4 | PO10875112195 | 19 | 291 | 237 | 281 | 6 | 2024-08-02 | 119.98 | 3.00 | 2024-07-21 | 4 | 38.49 | 1 | 119.98 | 35 | SO71830 | 2024-07-28 | 9.60 | 153.97 | 29.99 | |||
SO48321_16 | FA9B-4026-BF | PO14790154902 | 19 | 291 | 236 | 497 | 6 | 2023-02-01 | 86.52 | 2.16 | 2023-01-20 | 3 | 29.08 | 1 | 86.52 | 16 | SO48321 | 2023-01-27 | 6.92 | 87.24 | 28.84 | |||
SO51092_34 | FB68-47B7-9D | PO15312133079 | 19 | 291 | 214 | 11 | 299 | 6 | 14.17 | 2023-09-01 | 94.47 | 2.01 | 2023-08-20 | 6 | 13.09 | 1 | 80.30 | 34 | SO51092 | 2023-08-27 | 6.42 | 78.52 | 15.75 | 0.15 |
Generated 2024-09-20 00:13:24.301 UTC