[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE < SKIP 82 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51824_27 | A1F7-477E-BA | PO5800114202 | 100 | 285 | 398 | 63 | 5 | 2023-10-03 | 53.45 | 1.34 | 2023-09-21 | 2 | 19.78 | 1 | 53.45 | 27 | SO51824 | 2023-09-28 | 4.28 | 39.55 | 26.72 | |||
SO59035_4 | AE6B-46E2-82 | PO4089135854 | 100 | 285 | 359 | 368 | 5 | 2024-02-02 | 2753.99 | 68.85 | 2024-01-21 | 2 | 1251.98 | 1 | 2753.99 | 4 | SO59035 | 2024-01-28 | 220.32 | 2503.96 | 1376.99 | |||
SO43861_17 | 0CC0-4166-9E | PO16327172067 | 100 | 285 | 316 | 584 | 5 | 2021-10-03 | 1749.59 | 43.74 | 2021-09-21 | 2 | 884.71 | 1 | 1749.59 | 17 | SO43861 | 2021-09-28 | 139.97 | 1769.42 | 874.79 | |||
SO53524_36 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 572 | 13 | 611 | 5 | 350.76 | 2023-11-03 | 2338.40 | 49.69 | 2023-10-22 | 7 | 461.44 | 1 | 1987.64 | 36 | SO53524 | 2023-10-29 | 159.01 | 3230.11 | 334.06 | 0.15 |
SO48090_3 | E7D1-44A3-B2 | PO9512117066 | 100 | 285 | 329 | 135 | 5 | 2023-01-03 | 939.59 | 23.49 | 2022-12-22 | 2 | 486.71 | 1 | 939.59 | 3 | SO48090 | 2022-12-29 | 75.17 | 973.41 | 469.79 | |||
SO46933_8 | 4D88-4B51-BF | PO19546168601 | 100 | 285 | 435 | 206 | 5 | 2022-10-03 | 1297.81 | 32.45 | 2022-09-21 | 4 | 300.12 | 1 | 1297.81 | 8 | SO46933 | 2022-09-28 | 103.82 | 1200.48 | 324.45 | |||
SO69465_21 | B8B2-4B14-99 | PO2842153886 | 100 | 285 | 581 | 700 | 5 | 2024-07-03 | 3061.78 | 76.54 | 2024-06-21 | 3 | 1082.51 | 1 | 3061.78 | 21 | SO69465 | 2024-06-28 | 244.94 | 3247.53 | 1020.59 | |||
SO45805_2 | 4E35-406B-B7 | PO3393138494 | 100 | 285 | 311 | 549 | 5 | 2022-06-03 | 2146.96 | 53.67 | 2022-05-22 | 1 | 2171.29 | 1 | 2146.96 | 2 | SO45805 | 2022-05-29 | 171.76 | 2171.29 | 2146.96 | |||
SO69419_5 | 09D7-42E3-8E | PO15051119574 | 100 | 285 | 475 | 207 | 5 | 2024-07-03 | 167.98 | 4.20 | 2024-06-21 | 4 | 26.18 | 1 | 167.98 | 5 | SO69419 | 2024-06-28 | 13.44 | 104.71 | 41.99 | |||
SO50726_10 | A80B-408E-B3 | PO9599192861 | 100 | 285 | 271 | 170 | 5 | 2023-08-03 | 1213.99 | 30.35 | 2023-07-22 | 6 | 187.16 | 1 | 1213.99 | 10 | SO50726 | 2023-07-29 | 97.12 | 1122.94 | 202.33 | |||
SO47725_11 | 2501-4A1D-99 | PO9831133395 | 100 | 285 | 368 | 81 | 5 | 2022-12-03 | 7330.05 | 183.25 | 2022-11-21 | 5 | 1518.79 | 1 | 7330.05 | 11 | SO47725 | 2022-11-28 | 586.40 | 7593.93 | 1466.01 | |||
SO57027_4 | 15A6-4057-85 | PO16965111189 | 100 | 285 | 580 | 441 | 5 | 2024-01-03 | 4082.38 | 102.06 | 2023-12-22 | 4 | 1082.51 | 1 | 4082.38 | 4 | SO57027 | 2023-12-29 | 326.59 | 4330.04 | 1020.59 | |||
SO65248_5 | A7B5-4EE1-98 | PO9599164617 | 100 | 285 | 390 | 170 | 5 | 2024-05-03 | 2016.88 | 50.42 | 2024-04-21 | 3 | 713.08 | 1 | 2016.88 | 5 | SO65248 | 2024-04-28 | 161.35 | 2139.24 | 672.29 | |||
SO43902_1 | E3ED-44B5-B2 | PO5858178400 | 100 | 285 | 229 | 566 | 5 | 2021-10-03 | 28.84 | 0.72 | 2021-09-21 | 1 | 31.72 | 1 | 28.84 | 1 | SO43902 | 2021-09-28 | 2.31 | 31.72 | 28.84 | |||
SO44304_7 | D34C-4225-A3 | PO10179168311 | 100 | 285 | 347 | 27 | 5 | 2021-12-03 | 8159.98 | 204.00 | 2021-11-21 | 4 | 1912.15 | 1 | 8159.98 | 7 | SO44304 | 2021-11-28 | 652.80 | 7648.62 | 2039.99 | |||
SO67277_38 | 9AB3-4F34-85 | PO12644174121 | 100 | 272 | 511 | 530 | 5 | 2024-06-03 | 873.82 | 21.85 | 2024-05-22 | 4 | 199.38 | 1 | 873.82 | 38 | SO67277 | 2024-05-29 | 69.91 | 797.50 | 218.45 | |||
SO51718_18 | 27D3-4968-89 | PO15051113417 | 100 | 285 | 491 | 207 | 5 | 2023-10-03 | 129.58 | 3.24 | 2023-09-21 | 4 | 41.57 | 1 | 129.58 | 18 | SO51718 | 2023-09-28 | 10.37 | 166.29 | 32.39 | |||
SO51108_18 | 8650-4A20-B1 | PO12644151814 | 100 | 285 | 488 | 530 | 5 | 2023-09-02 | 194.36 | 4.86 | 2023-08-21 | 6 | 41.57 | 1 | 194.36 | 18 | SO51108 | 2023-08-28 | 15.55 | 249.43 | 32.39 | |||
SO49836_6 | 0E32-48F7-89 | PO12644185975 | 100 | 285 | 468 | 530 | 5 | 2023-06-03 | 45.59 | 1.14 | 2023-05-22 | 2 | 15.67 | 1 | 45.59 | 6 | SO49836 | 2023-05-29 | 3.65 | 31.34 | 22.79 | |||
SO46933_16 | 4D88-4B51-BF | PO19546168601 | 100 | 285 | 417 | 206 | 5 | 2022-10-03 | 648.91 | 16.22 | 2022-09-21 | 2 | 300.12 | 1 | 648.91 | 16 | SO46933 | 2022-09-28 | 51.91 | 600.24 | 324.45 | |||
SO47026_17 | 123B-481F-8F | PO3596190739 | 100 | 285 | 366 | 476 | 5 | 2022-10-03 | 1943.98 | 48.60 | 2022-09-21 | 3 | 598.44 | 1 | 1943.98 | 17 | SO47026 | 2022-09-28 | 155.52 | 1795.31 | 647.99 | |||
SO53563_29 | C955-44BD-A8 | PO9599165865 | 100 | 285 | 604 | 170 | 5 | 2023-11-03 | 1619.97 | 40.50 | 2023-10-22 | 5 | 343.65 | 1 | 1619.97 | 29 | SO53563 | 2023-10-29 | 129.60 | 1718.25 | 323.99 | |||
SO47965_18 | 953F-437D-84 | PO19546111394 | 100 | 285 | 389 | 206 | 5 | 2023-01-03 | 1800.79 | 45.02 | 2022-12-22 | 3 | 605.65 | 1 | 1800.79 | 18 | SO47965 | 2022-12-29 | 144.06 | 1816.95 | 600.26 | |||
SO49473_1 | EAA2-43E2-87 | PO2813142084 | 100 | 283 | 333 | 90 | 5 | 2023-05-03 | 2348.97 | 58.72 | 2023-04-21 | 5 | 486.71 | 1 | 2348.97 | 1 | SO49473 | 2023-04-28 | 187.92 | 2433.53 | 469.79 | |||
SO50315_1 | EDB3-4074-A9 | PO7598160779 | 100 | 285 | 429 | 45 | 5 | 2023-07-03 | 973.36 | 24.33 | 2023-06-21 | 3 | 300.12 | 1 | 973.36 | 1 | SO50315 | 2023-06-28 | 77.87 | 900.36 | 324.45 | |||
SO58974_18 | FB64-4792-81 | PO2813115918 | 100 | 283 | 467 | 90 | 5 | 2024-02-02 | 58.78 | 1.47 | 2024-01-21 | 4 | 9.16 | 1 | 58.78 | 18 | SO58974 | 2024-01-28 | 4.70 | 36.64 | 14.69 | |||
SO71839_2 | 8F89-4B1E-A8 | PO1537119063 | 100 | 285 | 564 | 611 | 5 | 2024-08-03 | 11443.54 | 286.09 | 2024-07-22 | 8 | 1481.94 | 1 | 11443.54 | 2 | SO71839 | 2024-07-29 | 915.48 | 11855.50 | 1430.44 | |||
SO50703_30 | 4A3D-44CB-B3 | PO2813140706 | 100 | 283 | 456 | 90 | 5 | 2023-08-03 | 359.95 | 9.00 | 2023-07-22 | 8 | 30.93 | 1 | 359.95 | 30 | SO50703 | 2023-07-29 | 28.80 | 247.47 | 44.99 |
Generated 2024-09-20 20:28:47.149 UTC