[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '10' > SHUFFLE SKIP 2000 < SKIP 625 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46615_9 | 826F-457B-84 | PO14355186739 | 98 | 288 | 415 | 286 | 10 | 2022-09-01 | 396.07 | 9.90 | 2022-08-20 | 2 | 146.55 | 1 | 396.07 | 9 | SO46615 | 2022-08-27 | 31.69 | 293.09 | 198.04 | |||
SO67289_34 | 5B09-42E8-A1 | PO10324110444 | 98 | 288 | 595 | 196 | 10 | 2024-06-02 | 677.99 | 16.95 | 2024-05-21 | 2 | 308.22 | 1 | 677.99 | 34 | SO67289 | 2024-05-28 | 54.24 | 616.44 | 338.99 | |||
SO55270_2 | F26D-4C3A-88 | PO696117622 | 98 | 288 | 225 | 232 | 10 | 2023-12-02 | 37.76 | 0.94 | 2023-11-20 | 7 | 6.92 | 1 | 37.76 | 2 | SO55270 | 2023-11-27 | 3.02 | 48.46 | 5.39 | |||
SO65177_27 | 1619-495E-81 | PO16501143019 | 98 | 288 | 390 | 142 | 10 | 2024-05-02 | 1344.59 | 33.61 | 2024-04-20 | 2 | 713.08 | 1 | 1344.59 | 27 | SO65177 | 2024-04-27 | 107.57 | 1426.16 | 672.29 | |||
SO59064_42 | AE68-4CAD-B8 | PO8671111477 | 98 | 290 | 363 | 502 | 10 | 2024-02-01 | 4130.98 | 103.27 | 2024-01-20 | 3 | 1251.98 | 1 | 4130.98 | 42 | SO59064 | 2024-01-27 | 330.48 | 3755.94 | 1376.99 | |||
SO51771_1 | F78B-4D68-8E | PO1508157846 | 98 | 288 | 604 | 430 | 10 | 2023-10-02 | 647.99 | 16.20 | 2023-09-20 | 2 | 343.65 | 1 | 647.99 | 1 | SO51771 | 2023-09-27 | 51.84 | 687.30 | 323.99 | |||
SO50722_5 | 126E-410B-A5 | PO8468186428 | 98 | 290 | 337 | 16 | 10 | 2023-08-02 | 1409.38 | 35.23 | 2023-07-21 | 3 | 486.71 | 1 | 1409.38 | 5 | SO50722 | 2023-07-28 | 112.75 | 1460.12 | 469.79 | |||
SO46615_4 | 826F-457B-84 | PO14355186739 | 98 | 288 | 230 | 286 | 10 | 2022-09-01 | 86.52 | 2.16 | 2022-08-20 | 3 | 29.08 | 1 | 86.52 | 4 | SO46615 | 2022-08-27 | 6.92 | 87.24 | 28.84 | |||
SO65271_6 | 11E0-45B2-93 | PO8468172113 | 98 | 288 | 234 | 16 | 10 | 2024-05-02 | 149.97 | 3.75 | 2024-04-20 | 5 | 38.49 | 1 | 149.97 | 6 | SO65271 | 2024-04-27 | 12.00 | 192.46 | 29.99 | |||
SO53512_28 | 6AC2-4C2F-81 | PO10353157108 | 98 | 290 | 532 | 88 | 10 | 2023-11-02 | 599.50 | 14.99 | 2023-10-21 | 4 | 136.79 | 1 | 599.50 | 28 | SO53512 | 2023-10-28 | 47.96 | 547.14 | 149.87 | |||
SO71832_30 | 269D-4F59-82 | PO10353140756 | 98 | 288 | 527 | 88 | 10 | 2024-08-02 | 158.43 | 3.96 | 2024-07-21 | 1 | 144.59 | 1 | 158.43 | 30 | SO71832 | 2024-07-28 | 12.67 | 144.59 | 158.43 | |||
SO63170_33 | 9588-481B-B3 | PO957184615 | 98 | 288 | 594 | 376 | 10 | 2024-04-03 | 338.99 | 8.47 | 2024-03-22 | 1 | 308.22 | 1 | 338.99 | 33 | SO63170 | 2024-03-29 | 27.12 | 308.22 | 338.99 | |||
SO71832_14 | 269D-4F59-82 | PO10353140756 | 98 | 288 | 298 | 88 | 10 | 2024-08-02 | 3239.04 | 80.98 | 2024-07-21 | 4 | 739.04 | 1 | 3239.04 | 14 | SO71832 | 2024-07-28 | 259.12 | 2956.16 | 809.76 | |||
SO69456_43 | CCD9-4C53-AB | PO957172965 | 98 | 288 | 593 | 16 | 376 | 10 | 45.20 | 2024-07-02 | 113.00 | 1.70 | 2024-06-20 | 1 | 308.22 | 1 | 67.80 | 43 | SO69456 | 2024-06-27 | 5.42 | 308.22 | 113.00 | 0.40 |
SO47451_2 | 6525-4619-9A | PO8671131661 | 98 | 288 | 294 | 502 | 10 | 2022-11-02 | 744.27 | 18.61 | 2022-10-21 | 1 | 660.91 | 1 | 744.27 | 2 | SO47451 | 2022-10-28 | 59.54 | 660.91 | 744.27 | |||
SO53577_13 | A44D-449C-80 | PO5713160840 | 98 | 288 | 575 | 52 | 10 | 2023-11-02 | 2860.88 | 71.52 | 2023-10-21 | 2 | 1481.94 | 1 | 2860.88 | 13 | SO53577 | 2023-10-28 | 228.87 | 2963.88 | 1430.44 | |||
SO51815_14 | 9899-4418-B8 | PO8729139087 | 98 | 290 | 569 | 13 | 556 | 10 | 50.11 | 2023-10-02 | 334.06 | 7.10 | 2023-09-20 | 1 | 461.44 | 1 | 283.95 | 14 | SO51815 | 2023-09-27 | 22.72 | 461.44 | 334.06 | 0.15 |
SO53573_37 | F674-4899-B9 | PO8671117198 | 98 | 288 | 306 | 502 | 10 | 2023-11-02 | 1619.52 | 40.49 | 2023-10-21 | 2 | 739.04 | 1 | 1619.52 | 37 | SO53573 | 2023-10-28 | 129.56 | 1478.08 | 809.76 | |||
SO48386_32 | 7AB1-4817-8F | PO8468170337 | 98 | 288 | 339 | 16 | 10 | 2023-02-01 | 469.79 | 11.74 | 2023-01-20 | 1 | 486.71 | 1 | 469.79 | 32 | SO48386 | 2023-01-27 | 37.58 | 486.71 | 469.79 | |||
SO71898_14 | 50A6-4178-9B | PO5713190501 | 98 | 288 | 565 | 52 | 10 | 2024-08-02 | 445.41 | 11.14 | 2024-07-21 | 1 | 461.44 | 1 | 445.41 | 14 | SO71898 | 2024-07-28 | 35.63 | 461.44 | 445.41 | |||
SO51143_43 | 5AF9-4974-90 | PO8410118711 | 98 | 288 | 287 | 538 | 10 | 2023-09-01 | 809.33 | 20.23 | 2023-08-20 | 4 | 204.63 | 1 | 809.33 | 43 | SO51143 | 2023-08-27 | 64.75 | 818.50 | 202.33 | |||
SO50237_23 | 6856-44BE-87 | PO928122277 | 98 | 288 | 230 | 484 | 10 | 2023-07-02 | 144.20 | 3.61 | 2023-06-20 | 5 | 29.08 | 1 | 144.20 | 23 | SO50237 | 2023-06-27 | 11.54 | 145.40 | 28.84 | |||
SO61238_1 | 0A37-46F4-8E | PO8410140860 | 98 | 288 | 584 | 538 | 10 | 2024-03-03 | 971.98 | 24.30 | 2024-02-20 | 3 | 343.65 | 1 | 971.98 | 1 | SO61238 | 2024-02-27 | 77.76 | 1030.95 | 323.99 | |||
SO49061_10 | 6C3C-4A57-8D | PO957194532 | 98 | 288 | 358 | 376 | 10 | 2023-04-04 | 7376.75 | 184.42 | 2023-03-23 | 6 | 1105.81 | 1 | 7376.75 | 10 | SO49061 | 2023-03-30 | 590.14 | 6634.86 | 1229.46 | |||
SO65282_12 | 2628-4FDF-B1 | PO5713156786 | 98 | 288 | 561 | 52 | 10 | 2024-05-02 | 1430.44 | 35.76 | 2024-04-20 | 1 | 1481.94 | 1 | 1430.44 | 12 | SO65282 | 2024-04-27 | 114.44 | 1481.94 | 1430.44 | |||
SO58905_19 | 79BE-4713-94 | PO19604111681 | 98 | 288 | 595 | 340 | 10 | 2024-02-01 | 677.99 | 16.95 | 2024-01-20 | 2 | 308.22 | 1 | 677.99 | 19 | SO58905 | 2024-01-27 | 54.24 | 616.44 | 338.99 | |||
SO49061_11 | 6C3C-4A57-8D | PO957194532 | 98 | 288 | 458 | 376 | 10 | 2023-04-04 | 269.96 | 6.75 | 2023-03-23 | 6 | 30.93 | 1 | 269.96 | 11 | SO49061 | 2023-03-30 | 21.60 | 185.60 | 44.99 | |||
SO50244_10 | 8887-4F96-A3 | PO1508168261 | 98 | 290 | 224 | 430 | 10 | 2023-07-02 | 25.93 | 0.65 | 2023-06-20 | 5 | 5.23 | 1 | 25.93 | 10 | SO50244 | 2023-06-27 | 2.07 | 26.15 | 5.19 | |||
SO48389_5 | 304D-46A7-8E | PO8671159284 | 98 | 288 | 428 | 502 | 10 | 2023-02-01 | 1674.05 | 41.85 | 2023-01-20 | 8 | 185.82 | 1 | 1674.05 | 5 | SO48389 | 2023-01-27 | 133.92 | 1486.55 | 209.26 | |||
SO47447_14 | 5913-43AF-8D | PO8468183786 | 98 | 288 | 414 | 16 | 10 | 2022-11-02 | 149.03 | 3.73 | 2022-10-21 | 1 | 110.28 | 1 | 149.03 | 14 | SO47447 | 2022-10-28 | 11.92 | 110.28 | 149.03 | |||
SO59008_18 | 4EE7-43A3-A6 | PO5713164207 | 98 | 288 | 561 | 52 | 10 | 2024-02-01 | 4291.33 | 107.28 | 2024-01-20 | 3 | 1481.94 | 1 | 4291.33 | 18 | SO59008 | 2024-01-27 | 343.31 | 4445.81 | 1430.44 |
Generated 2024-09-19 15:13:05.085 UTC