[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE SKIP 254 < SKIP 2062 > < TAKE 31 >
31 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50306_7 | D376-4A40-86 | PO5858194676 | 100 | 285 | 470 | 566 | 5 | 2023-08-23 | 45.59 | 1.14 | 2023-08-11 | 2 | 15.67 | 1 | 45.59 | 7 | SO50306 | 2023-08-18 | 3.65 | 31.34 | 22.79 |
SO65248_2 | A7B5-4EE1-98 | PO9599164617 | 100 | 285 | 214 | 170 | 5 | 2024-06-23 | 41.99 | 1.05 | 2024-06-11 | 2 | 13.09 | 1 | 41.99 | 2 | SO65248 | 2024-06-18 | 3.36 | 26.17 | 20.99 |
SO46028_20 | 7BBE-413C-83 | PO19546126425 | 100 | 285 | 315 | 206 | 5 | 2022-08-23 | 874.79 | 21.87 | 2022-08-11 | 1 | 884.71 | 1 | 874.79 | 20 | SO46028 | 2022-08-18 | 69.98 | 884.71 | 874.79 |
SO46971_13 | 5CEA-463B-A2 | PO15051144269 | 100 | 285 | 358 | 207 | 5 | 2022-11-23 | 4917.84 | 122.95 | 2022-11-11 | 4 | 1105.81 | 1 | 4917.84 | 13 | SO46971 | 2022-11-18 | 393.43 | 4423.24 | 1229.46 |
SO57162_25 | 83B5-43A6-BD | PO3596174424 | 100 | 285 | 587 | 476 | 5 | 2024-02-23 | 923.39 | 23.08 | 2024-02-11 | 2 | 419.78 | 1 | 923.39 | 25 | SO57162 | 2024-02-18 | 73.87 | 839.56 | 461.69 |
SO48062_9 | DB45-43CB-82 | PO5568119115 | 100 | 285 | 458 | 422 | 5 | 2023-02-23 | 89.99 | 2.25 | 2023-02-11 | 2 | 30.93 | 1 | 89.99 | 9 | SO48062 | 2023-02-18 | 7.20 | 61.87 | 44.99 |
SO49090_6 | BA90-48D0-89 | PO11571148651 | 100 | 285 | 343 | 512 | 5 | 2023-05-26 | 939.59 | 23.49 | 2023-05-14 | 2 | 486.71 | 1 | 939.59 | 6 | SO49090 | 2023-05-21 | 75.17 | 973.41 | 469.79 |
SO46045_16 | 9345-48CB-A5 | PO16327127643 | 100 | 285 | 229 | 584 | 5 | 2022-08-23 | 144.20 | 3.61 | 2022-08-11 | 5 | 31.72 | 1 | 144.20 | 16 | SO46045 | 2022-08-18 | 11.54 | 158.62 | 28.84 |
SO48730_20 | C918-466B-B1 | PO522152463 | 100 | 285 | 470 | 676 | 5 | 2023-04-25 | 205.15 | 5.13 | 2023-04-13 | 9 | 15.67 | 1 | 205.15 | 20 | SO48730 | 2023-04-20 | 16.41 | 141.04 | 22.79 |
SO44306_19 | 464C-43BA-9F | PO1189114917 | 100 | 285 | 332 | 423 | 5 | 2022-01-23 | 1677.84 | 41.95 | 2022-01-11 | 4 | 413.15 | 1 | 1677.84 | 19 | SO44306 | 2022-01-18 | 134.23 | 1652.59 | 419.46 |
SO49443_1 | 80CD-42C1-AB | PO435152332 | 100 | 285 | 422 | 651 | 5 | 2023-06-23 | 67.54 | 1.69 | 2023-06-11 | 1 | 49.98 | 1 | 67.54 | 1 | SO49443 | 2023-06-18 | 5.40 | 49.98 | 67.54 |
SO44562_6 | 1856-47B2-AD | PO7598190472 | 100 | 285 | 334 | 45 | 5 | 2022-02-23 | 419.46 | 10.49 | 2022-02-11 | 1 | 413.15 | 1 | 419.46 | 6 | SO44562 | 2022-02-18 | 33.56 | 413.15 | 419.46 |
SO61230_3 | B9F1-4FF8-B4 | PO12644163346 | 100 | 285 | 597 | 530 | 5 | 2024-04-24 | 647.99 | 16.20 | 2024-04-12 | 2 | 294.58 | 1 | 647.99 | 3 | SO61230 | 2024-04-19 | 51.84 | 589.16 | 323.99 |
SO47449_8 | 65DE-4129-86 | PO9048199215 | 100 | 285 | 410 | 652 | 5 | 2022-12-24 | 36.45 | 0.91 | 2022-12-12 | 1 | 26.97 | 1 | 36.45 | 8 | SO47449 | 2022-12-19 | 2.92 | 26.97 | 36.45 |
SO49090_15 | BA90-48D0-89 | PO11571148651 | 100 | 285 | 369 | 512 | 5 | 2023-05-26 | 1466.01 | 36.65 | 2023-05-14 | 1 | 1518.79 | 1 | 1466.01 | 15 | SO49090 | 2023-05-21 | 117.28 | 1518.79 | 1466.01 |
SO71839_2 | 8F89-4B1E-A8 | PO1537119063 | 100 | 285 | 564 | 611 | 5 | 2024-09-23 | 11443.54 | 286.09 | 2024-09-11 | 8 | 1481.94 | 1 | 11443.54 | 2 | SO71839 | 2024-09-18 | 915.48 | 11855.50 | 1430.44 |
SO46056_15 | 4B9A-4022-AA | PO12586180466 | 100 | 285 | 296 | 278 | 5 | 2022-08-23 | 1429.41 | 35.74 | 2022-08-11 | 2 | 617.03 | 1 | 1429.41 | 15 | SO46056 | 2022-08-18 | 114.35 | 1234.06 | 714.70 |
SO49090_19 | BA90-48D0-89 | PO11571148651 | 100 | 285 | 371 | 512 | 5 | 2023-05-26 | 3926.81 | 98.17 | 2023-05-14 | 3 | 1320.68 | 1 | 3926.81 | 19 | SO49090 | 2023-05-21 | 314.15 | 3962.05 | 1308.94 |
SO71839_40 | 8F89-4B1E-A8 | PO1537119063 | 100 | 285 | 572 | 611 | 5 | 2024-09-23 | 890.82 | 22.27 | 2024-09-11 | 2 | 461.44 | 1 | 890.82 | 40 | SO71839 | 2024-09-18 | 71.27 | 922.89 | 445.41 |
SO51137_4 | A47F-4FEF-94 | PO9889144162 | 100 | 285 | 515 | 494 | 5 | 2023-10-23 | 32.54 | 0.81 | 2023-10-11 | 2 | 12.04 | 1 | 32.54 | 4 | SO51137 | 2023-10-18 | 2.60 | 24.08 | 16.27 |
SO47965_9 | 953F-437D-84 | PO19546111394 | 100 | 285 | 433 | 206 | 5 | 2023-02-23 | 973.36 | 24.33 | 2023-02-11 | 3 | 300.12 | 1 | 973.36 | 9 | SO47965 | 2023-02-18 | 77.87 | 900.36 | 324.45 |
SO55304_1 | CB2B-4767-9D | PO4176184346 | 100 | 285 | 384 | 458 | 5 | 2024-01-23 | 672.29 | 16.81 | 2024-01-11 | 1 | 713.08 | 1 | 672.29 | 1 | SO55304 | 2024-01-18 | 53.78 | 713.08 | 672.29 |
SO47455_25 | 41F3-48C2-B7 | PO9599169586 | 100 | 285 | 459 | 170 | 5 | 2022-12-24 | 53.99 | 1.35 | 2022-12-12 | 1 | 37.12 | 1 | 53.99 | 25 | SO47455 | 2022-12-19 | 4.32 | 37.12 | 53.99 |
SO46995_4 | 9CEA-4AC3-95 | PO11542113352 | 100 | 285 | 323 | 62 | 5 | 2022-11-23 | 469.79 | 11.74 | 2022-11-11 | 1 | 486.71 | 1 | 469.79 | 4 | SO46995 | 2022-11-18 | 37.58 | 486.71 | 469.79 |
SO46387_25 | 5AA4-4F68-A1 | PO9599173396 | 100 | 285 | 324 | 170 | 5 | 2022-09-23 | 1258.38 | 31.46 | 2022-09-11 | 3 | 413.15 | 1 | 1258.38 | 25 | SO46387 | 2022-09-18 | 100.67 | 1239.44 | 419.46 |
SO65207_15 | B20E-440F-A3 | PO1537156240 | 100 | 285 | 568 | 611 | 5 | 2024-06-23 | 1781.64 | 44.54 | 2024-06-11 | 4 | 461.44 | 1 | 1781.64 | 15 | SO65207 | 2024-06-18 | 142.53 | 1845.78 | 445.41 |
SO57190_1 | F86C-45A6-B4 | PO9773165531 | 100 | 285 | 555 | 8 | 5 | 2024-02-23 | 63.90 | 1.60 | 2024-02-11 | 1 | 47.29 | 1 | 63.90 | 1 | SO57190 | 2024-02-18 | 5.11 | 47.29 | 63.90 |
SO45805_3 | 4E35-406B-B7 | PO3393138494 | 100 | 285 | 313 | 549 | 5 | 2022-07-24 | 2146.96 | 53.67 | 2022-07-12 | 1 | 2171.29 | 1 | 2146.96 | 3 | SO45805 | 2022-07-19 | 171.76 | 2171.29 | 2146.96 |
SO51693_21 | 6FEB-4D5B-92 | PO19546179477 | 100 | 285 | 388 | 206 | 5 | 2023-11-23 | 2016.88 | 50.42 | 2023-11-11 | 3 | 713.08 | 1 | 2016.88 | 21 | SO51693 | 2023-11-18 | 161.35 | 2139.24 | 672.29 |
SO47416_32 | 6B45-44AB-84 | PO2813155355 | 100 | 281 | 368 | 90 | 5 | 2022-12-24 | 14660.10 | 366.50 | 2022-12-12 | 10 | 1518.79 | 1 | 14660.10 | 32 | SO47416 | 2022-12-19 | 1172.81 | 15187.86 | 1466.01 |
SO61228_11 | 06C7-43A1-85 | PO9831151400 | 100 | 285 | 222 | 81 | 5 | 2024-04-24 | 41.99 | 1.05 | 2024-04-12 | 2 | 13.09 | 1 | 41.99 | 11 | SO61228 | 2024-04-19 | 3.36 | 26.17 | 20.99 |
Generated 2024-11-10 23:38:36.078 UTC