[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '10' > SHUFFLE SKIP 2000 < SKIP 643 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO53455_27 | ACD7-4AF3-84 | PO19604185529 | 98 | 288 | 398 | 340 | 10 | 2023-11-04 | 53.45 | 1.34 | 2023-10-23 | 2 | 19.78 | 1 | 53.45 | 27 | SO53455 | 2023-10-30 | 4.28 | 39.55 | 26.72 | |||
SO48088_3 | AFC3-42C6-85 | PO8758112106 | 98 | 288 | 470 | 683 | 10 | 2023-01-04 | 68.38 | 1.71 | 2022-12-23 | 3 | 15.67 | 1 | 68.38 | 3 | SO48088 | 2022-12-30 | 5.47 | 47.01 | 22.79 | |||
SO50244_24 | 8887-4F96-A3 | PO1508168261 | 98 | 290 | 341 | 430 | 10 | 2023-07-04 | 2348.97 | 58.72 | 2023-06-22 | 5 | 486.71 | 1 | 2348.97 | 24 | SO50244 | 2023-06-29 | 187.92 | 2433.53 | 469.79 | |||
SO53472_29 | 892C-445A-B6 | PO16501111174 | 98 | 288 | 408 | 142 | 10 | 2023-11-04 | 216.49 | 5.41 | 2023-10-23 | 3 | 53.40 | 1 | 216.49 | 29 | SO53472 | 2023-10-30 | 17.32 | 160.20 | 72.16 | |||
SO48031_6 | 9EAA-4023-94 | PO957142471 | 98 | 288 | 233 | 376 | 10 | 2023-01-04 | 28.84 | 0.72 | 2022-12-23 | 1 | 29.08 | 1 | 28.84 | 6 | SO48031 | 2022-12-30 | 2.31 | 29.08 | 28.84 | |||
SO71780_28 | 36CB-4A10-92 | PO19604173239 | 98 | 288 | 476 | 340 | 10 | 2024-08-04 | 293.96 | 7.35 | 2024-07-23 | 7 | 26.18 | 1 | 293.96 | 28 | SO71780 | 2024-07-30 | 23.52 | 183.23 | 41.99 | |||
SO47004_16 | BB9D-49AE-A9 | PO928175019 | 98 | 290 | 352 | 484 | 10 | 2022-10-04 | 7457.11 | 186.43 | 2022-09-22 | 6 | 1117.86 | 1 | 7457.11 | 16 | SO47004 | 2022-09-29 | 596.57 | 6707.14 | 1242.85 | |||
SO55268_6 | 47E6-44B3-A4 | PO10324191521 | 98 | 288 | 463 | 196 | 10 | 2023-12-04 | 58.78 | 1.47 | 2023-11-22 | 4 | 9.16 | 1 | 58.78 | 6 | SO55268 | 2023-11-29 | 4.70 | 36.64 | 14.69 | |||
SO51823_14 | 2FB1-4AE1-BC | PO8642173409 | 98 | 288 | 502 | 520 | 10 | 2023-10-04 | 400.10 | 10.00 | 2023-09-22 | 2 | 199.85 | 1 | 400.10 | 14 | SO51823 | 2023-09-29 | 32.01 | 399.70 | 200.05 | |||
SO50237_13 | 6856-44BE-87 | PO928122277 | 98 | 288 | 453 | 484 | 10 | 2023-07-04 | 35.99 | 0.90 | 2023-06-22 | 1 | 24.75 | 1 | 35.99 | 13 | SO50237 | 2023-06-29 | 2.88 | 24.75 | 35.99 | |||
SO58920_18 | 944F-4219-85 | PO16501139645 | 98 | 288 | 488 | 142 | 10 | 2024-02-03 | 97.18 | 2.43 | 2024-01-22 | 3 | 41.57 | 1 | 97.18 | 18 | SO58920 | 2024-01-29 | 7.77 | 124.72 | 32.39 | |||
SO71938_3 | 7D23-4E70-B4 | PO8468183315 | 98 | 288 | 434 | 16 | 10 | 2024-08-04 | 713.80 | 17.84 | 2024-07-23 | 2 | 360.94 | 1 | 713.80 | 3 | SO71938 | 2024-07-30 | 57.10 | 721.89 | 356.90 | |||
SO53455_16 | ACD7-4AF3-84 | PO19604185529 | 98 | 288 | 527 | 340 | 10 | 2023-11-04 | 158.43 | 3.96 | 2023-10-23 | 1 | 144.59 | 1 | 158.43 | 16 | SO53455 | 2023-10-30 | 12.67 | 144.59 | 158.43 | |||
SO58905_24 | 79BE-4713-94 | PO19604111681 | 98 | 288 | 588 | 340 | 10 | 2024-02-03 | 461.69 | 11.54 | 2024-01-22 | 1 | 419.78 | 1 | 461.69 | 24 | SO58905 | 2024-01-29 | 36.94 | 419.78 | 461.69 | |||
SO67289_15 | 5B09-42E8-A1 | PO10324110444 | 98 | 288 | 511 | 196 | 10 | 2024-06-04 | 436.91 | 10.92 | 2024-05-23 | 2 | 199.38 | 1 | 436.91 | 15 | SO67289 | 2024-05-30 | 34.95 | 398.75 | 218.45 | |||
SO51771_23 | F78B-4D68-8E | PO1508157846 | 98 | 288 | 477 | 430 | 10 | 2023-10-04 | 11.98 | 0.30 | 2023-09-22 | 4 | 1.87 | 1 | 11.98 | 23 | SO51771 | 2023-09-29 | 0.96 | 7.47 | 2.99 | |||
SO69461_32 | F8C1-4A85-91 | PO1508119064 | 98 | 288 | 374 | 430 | 10 | 2024-07-04 | 2932.02 | 73.30 | 2024-06-22 | 2 | 1554.95 | 1 | 2932.02 | 32 | SO69461 | 2024-06-29 | 234.56 | 3109.90 | 1466.01 | |||
SO47451_7 | 6525-4619-9A | PO8671131661 | 98 | 288 | 409 | 502 | 10 | 2022-11-04 | 627.77 | 15.69 | 2022-10-23 | 3 | 185.82 | 1 | 627.77 | 7 | SO47451 | 2022-10-30 | 50.22 | 557.46 | 209.26 | |||
SO49891_24 | 78CA-4790-95 | PO8410166354 | 98 | 288 | 216 | 3 | 538 | 10 | 14.80 | 2023-06-04 | 296.07 | 7.03 | 2023-05-23 | 16 | 13.88 | 1 | 281.27 | 24 | SO49891 | 2023-05-30 | 22.50 | 222.05 | 18.50 | 0.05 |
SO48771_6 | E98F-4302-92 | PO8410125811 | 98 | 288 | 343 | 538 | 10 | 2023-03-06 | 2348.97 | 58.72 | 2023-02-22 | 5 | 486.71 | 1 | 2348.97 | 6 | SO48771 | 2023-03-01 | 187.92 | 2433.53 | 469.79 | |||
SO67343_4 | 4919-449D-87 | PO8410198369 | 98 | 288 | 463 | 538 | 10 | 2024-06-04 | 102.86 | 2.57 | 2024-05-23 | 7 | 9.16 | 1 | 102.86 | 4 | SO67343 | 2024-05-30 | 8.23 | 64.12 | 14.69 | |||
SO49065_1 | E9BC-440A-9D | PO1508143526 | 98 | 288 | 337 | 430 | 10 | 2023-04-06 | 939.59 | 23.49 | 2023-03-25 | 2 | 486.71 | 1 | 939.59 | 1 | SO49065 | 2023-04-01 | 75.17 | 973.41 | 469.79 | |||
SO67289_10 | 5B09-42E8-A1 | PO10324110444 | 98 | 288 | 543 | 196 | 10 | 2024-06-04 | 74.51 | 1.86 | 2024-05-23 | 2 | 27.57 | 1 | 74.51 | 10 | SO67289 | 2024-05-30 | 5.96 | 55.14 | 37.25 | |||
SO51084_27 | 3C77-43D1-83 | PO19575195218 | 98 | 288 | 568 | 13 | 34 | 10 | 50.11 | 2023-09-03 | 334.06 | 7.10 | 2023-08-22 | 1 | 461.44 | 1 | 283.95 | 27 | SO51084 | 2023-08-29 | 22.72 | 461.44 | 334.06 | 0.15 |
SO53577_1 | A44D-449C-80 | PO5713160840 | 98 | 288 | 492 | 52 | 10 | 2023-11-04 | 1807.04 | 45.18 | 2023-10-23 | 3 | 601.74 | 1 | 1807.04 | 1 | SO53577 | 2023-10-30 | 144.56 | 1805.23 | 602.35 | |||
SO65319_22 | 9F05-4591-9D | PO8671197482 | 98 | 288 | 532 | 502 | 10 | 2024-05-04 | 749.37 | 18.73 | 2024-04-22 | 5 | 136.79 | 1 | 749.37 | 22 | SO65319 | 2024-04-29 | 59.95 | 683.93 | 149.87 | |||
SO59064_41 | AE68-4CAD-B8 | PO8671111477 | 98 | 290 | 543 | 502 | 10 | 2024-02-03 | 186.27 | 4.66 | 2024-01-22 | 5 | 27.57 | 1 | 186.27 | 41 | SO59064 | 2024-01-29 | 14.90 | 137.84 | 37.25 | |||
SO57166_1 | 1E7B-4AA0-99 | PO1218174520 | 98 | 288 | 408 | 412 | 10 | 2024-01-04 | 72.16 | 1.80 | 2023-12-23 | 1 | 53.40 | 1 | 72.16 | 1 | SO57166 | 2023-12-30 | 5.77 | 53.40 | 72.16 |
Generated 2024-09-21 05:25:20.604 UTC