[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SKIP 0 SHUFFLE < SKIP 1314 > < TAKE 62 >
62 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49869_23 | A2BD-4A89-93 | PO9657193666 | 100 | 285 | 459 | 315 | 5 | 2023-07-24 | 107.99 | 2.70 | 2023-07-12 | 2 | 37.12 | 1 | 107.99 | 23 | SO49869 | 2023-07-19 | 8.64 | 74.24 | 53.99 |
SO48730_6 | C918-466B-B1 | PO522152463 | 100 | 285 | 360 | 676 | 5 | 2023-04-25 | 3688.38 | 92.21 | 2023-04-13 | 3 | 1105.81 | 1 | 3688.38 | 6 | SO48730 | 2023-04-20 | 295.07 | 3317.43 | 1229.46 |
SO48090_8 | E7D1-44A3-B2 | PO9512117066 | 100 | 285 | 333 | 135 | 5 | 2023-02-23 | 1409.38 | 35.23 | 2023-02-11 | 3 | 486.71 | 1 | 1409.38 | 8 | SO48090 | 2023-02-18 | 112.75 | 1460.12 | 469.79 |
SO51081_44 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 527 | 676 | 5 | 2023-10-23 | 475.29 | 11.88 | 2023-10-11 | 3 | 144.59 | 1 | 475.29 | 44 | SO51081 | 2023-10-18 | 38.02 | 433.78 | 158.43 |
SO69510_8 | 20D6-41A2-8F | PO5568198481 | 100 | 285 | 474 | 422 | 5 | 2024-08-23 | 335.95 | 8.40 | 2024-08-11 | 8 | 26.18 | 1 | 335.95 | 8 | SO69510 | 2024-08-18 | 26.88 | 209.41 | 41.99 |
SO47457_1 | 37E5-4B0F-9D | PO9744168861 | 100 | 285 | 399 | 98 | 5 | 2022-12-24 | 33.77 | 0.84 | 2022-12-12 | 1 | 24.99 | 1 | 33.77 | 1 | SO47457 | 2022-12-19 | 2.70 | 24.99 | 33.77 |
SO71866_33 | 029A-46BE-80 | PO14297151936 | 100 | 285 | 514 | 627 | 5 | 2024-09-23 | 127.80 | 3.20 | 2024-09-11 | 2 | 47.29 | 1 | 127.80 | 33 | SO71866 | 2024-09-18 | 10.22 | 94.57 | 63.90 |
SO46996_23 | 775B-42D6-A5 | PO11571149031 | 100 | 285 | 422 | 512 | 5 | 2022-11-23 | 135.08 | 3.38 | 2022-11-11 | 2 | 49.98 | 1 | 135.08 | 23 | SO46996 | 2022-11-18 | 10.81 | 99.96 | 67.54 |
SO44775_4 | A5AD-45A6-B0 | PO1943133380 | 100 | 285 | 232 | 525 | 5 | 2022-03-25 | 28.84 | 0.72 | 2022-03-13 | 1 | 31.72 | 1 | 28.84 | 4 | SO44775 | 2022-03-20 | 2.31 | 31.72 | 28.84 |
SO44304_7 | D34C-4225-A3 | PO10179168311 | 100 | 285 | 347 | 27 | 5 | 2022-01-23 | 8159.98 | 204.00 | 2022-01-11 | 4 | 1912.15 | 1 | 8159.98 | 7 | SO44304 | 2022-01-18 | 652.80 | 7648.62 | 2039.99 |
SO61217_1 | 9B9A-4C8B-93 | PO9889149314 | 100 | 285 | 512 | 494 | 5 | 2024-04-24 | 218.45 | 5.46 | 2024-04-12 | 1 | 199.38 | 1 | 218.45 | 1 | SO61217 | 2024-04-19 | 17.48 | 199.38 | 218.45 |
SO46045_28 | 9345-48CB-A5 | PO16327127643 | 100 | 285 | 215 | 584 | 5 | 2022-08-23 | 121.12 | 3.03 | 2022-08-11 | 6 | 12.03 | 1 | 121.12 | 28 | SO46045 | 2022-08-18 | 9.69 | 72.17 | 20.19 |
SO50234_4 | 97E1-4282-8B | PO10150134950 | 100 | 285 | 454 | 9 | 5 | 2023-08-23 | 71.99 | 1.80 | 2023-08-11 | 2 | 24.75 | 1 | 71.99 | 4 | SO50234 | 2023-08-18 | 5.76 | 49.49 | 35.99 |
SO46996_38 | 775B-42D6-A5 | PO11571149031 | 100 | 285 | 321 | 512 | 5 | 2022-11-23 | 469.79 | 11.74 | 2022-11-11 | 1 | 486.71 | 1 | 469.79 | 38 | SO46996 | 2022-11-18 | 37.58 | 486.71 | 469.79 |
SO46604_2 | 8062-4A97-B3 | PO522154989 | 100 | 285 | 366 | 676 | 5 | 2022-10-23 | 4535.96 | 113.40 | 2022-10-11 | 7 | 598.44 | 1 | 4535.96 | 2 | SO46604 | 2022-10-18 | 362.88 | 4189.05 | 647.99 |
SO44786_2 | 805D-42F3-9C | PO5307147108 | 100 | 285 | 288 | 369 | 5 | 2022-03-25 | 722.59 | 18.06 | 2022-03-13 | 1 | 623.84 | 1 | 722.59 | 2 | SO44786 | 2022-03-20 | 57.81 | 623.84 | 722.59 |
SO51705_17 | DFFB-4C23-BD | PO16965171069 | 100 | 285 | 583 | 441 | 5 | 2023-11-23 | 1020.59 | 25.51 | 2023-11-11 | 1 | 1082.51 | 1 | 1020.59 | 17 | SO51705 | 2023-11-18 | 81.65 | 1082.51 | 1020.59 |
SO65207_18 | B20E-440F-A3 | PO1537156240 | 100 | 285 | 577 | 611 | 5 | 2024-06-23 | 2186.73 | 54.67 | 2024-06-11 | 3 | 755.15 | 1 | 2186.73 | 18 | SO65207 | 2024-06-18 | 174.94 | 2265.45 | 728.91 |
SO47424_5 | 9DF2-4A59-AE | PO4089167750 | 100 | 285 | 354 | 368 | 5 | 2022-12-24 | 1242.85 | 31.07 | 2022-12-12 | 1 | 1117.86 | 1 | 1242.85 | 5 | SO47424 | 2022-12-19 | 99.43 | 1117.86 | 1242.85 |
SO45340_1 | 9ADF-4A2D-B6 | PO7714194147 | 100 | 285 | 319 | 495 | 5 | 2022-05-26 | 874.79 | 21.87 | 2022-05-14 | 1 | 884.71 | 1 | 874.79 | 1 | SO45340 | 2022-05-21 | 69.98 | 884.71 | 874.79 |
SO51874_10 | 0176-4E11-91 | PO9773132815 | 100 | 285 | 496 | 8 | 5 | 2023-11-23 | 602.35 | 15.06 | 2023-11-11 | 1 | 601.74 | 1 | 602.35 | 10 | SO51874 | 2023-11-18 | 48.19 | 601.74 | 602.35 |
SO45077_2 | 4002-46AC-B7 | PO10179199539 | 100 | 285 | 292 | 27 | 5 | 2022-04-25 | 2456.10 | 61.40 | 2022-04-13 | 3 | 706.81 | 1 | 2456.10 | 2 | SO45077 | 2022-04-20 | 196.49 | 2120.43 | 818.70 |
SO49149_21 | D41E-4EFF-A5 | PO5858123072 | 100 | 285 | 396 | 566 | 5 | 2023-05-26 | 74.84 | 1.87 | 2023-05-14 | 1 | 55.38 | 1 | 74.84 | 21 | SO49149 | 2023-05-21 | 5.99 | 55.38 | 74.84 |
SO47416_51 | 6B45-44AB-84 | PO2813155355 | 100 | 281 | 280 | 90 | 5 | 2022-12-24 | 919.69 | 22.99 | 2022-12-12 | 5 | 170.14 | 1 | 919.69 | 51 | SO47416 | 2022-12-19 | 73.58 | 850.71 | 183.94 |
SO47725_34 | 2501-4A1D-99 | PO9831133395 | 100 | 285 | 433 | 81 | 5 | 2023-01-23 | 648.91 | 16.22 | 2023-01-11 | 2 | 300.12 | 1 | 648.91 | 34 | SO47725 | 2023-01-18 | 51.91 | 600.24 | 324.45 |
SO46943_1 | 6F43-4A10-80 | PO18560122957 | 100 | 285 | 263 | 531 | 5 | 2022-11-23 | 809.33 | 20.23 | 2022-11-11 | 4 | 187.16 | 1 | 809.33 | 1 | SO46943 | 2022-11-18 | 64.75 | 748.63 | 202.33 |
SO65298_1 | 9BA8-4452-B9 | PO319112809 | 100 | 272 | 546 | 116 | 5 | 2024-06-23 | 37.25 | 0.93 | 2024-06-11 | 1 | 27.57 | 1 | 37.25 | 1 | SO65298 | 2024-06-18 | 2.98 | 27.57 | 37.25 |
SO43676_4 | 11BA-4D19-B7 | PO11861165059 | 100 | 281 | 348 | 17 | 5 | 2021-10-23 | 6074.98 | 151.87 | 2021-10-11 | 3 | 1898.09 | 1 | 6074.98 | 4 | SO43676 | 2021-10-18 | 486.00 | 5694.28 | 2024.99 |
SO50231_18 | B2CA-498D-9B | PO11571129150 | 100 | 285 | 265 | 512 | 5 | 2023-08-23 | 202.33 | 5.06 | 2023-08-11 | 1 | 187.16 | 1 | 202.33 | 18 | SO50231 | 2023-08-18 | 16.19 | 187.16 | 202.33 |
SO61257_6 | B93D-4A2D-BA | PO3741176337 | 100 | 285 | 605 | 404 | 5 | 2024-04-24 | 323.99 | 8.10 | 2024-04-12 | 1 | 343.65 | 1 | 323.99 | 6 | SO61257 | 2024-04-19 | 25.92 | 343.65 | 323.99 |
SO46090_21 | 987E-4B5B-B6 | PO5858172038 | 100 | 285 | 223 | 566 | 5 | 2022-08-23 | 10.37 | 0.26 | 2022-08-11 | 2 | 5.71 | 1 | 10.37 | 21 | SO46090 | 2022-08-18 | 0.83 | 11.41 | 5.19 |
SO71948_21 | DCEE-428D-87 | PO9599179297 | 100 | 285 | 374 | 170 | 5 | 2024-09-23 | 7330.05 | 183.25 | 2024-09-11 | 5 | 1554.95 | 1 | 7330.05 | 21 | SO71948 | 2024-09-18 | 586.40 | 7774.74 | 1466.01 |
SO51147_32 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 465 | 81 | 5 | 2023-10-23 | 88.16 | 2.20 | 2023-10-11 | 6 | 9.16 | 1 | 88.16 | 32 | SO51147 | 2023-10-18 | 7.05 | 54.96 | 14.69 |
SO48766_37 | A56F-4A7B-AD | PO9831126274 | 100 | 285 | 286 | 81 | 5 | 2023-04-25 | 183.94 | 4.60 | 2023-04-13 | 1 | 170.14 | 1 | 183.94 | 37 | SO48766 | 2023-04-20 | 14.72 | 170.14 | 183.94 |
SO67260_12 | 6224-4229-B8 | PO522163557 | 100 | 285 | 543 | 676 | 5 | 2024-07-24 | 37.25 | 0.93 | 2024-07-12 | 1 | 27.57 | 1 | 37.25 | 12 | SO67260 | 2024-07-19 | 2.98 | 27.57 | 37.25 |
SO69465_33 | B8B2-4B14-99 | PO2842153886 | 100 | 285 | 583 | 700 | 5 | 2024-08-23 | 1020.59 | 25.51 | 2024-08-11 | 1 | 1082.51 | 1 | 1020.59 | 33 | SO69465 | 2024-08-18 | 81.65 | 1082.51 | 1020.59 |
SO47424_2 | 9DF2-4A59-AE | PO4089167750 | 100 | 285 | 410 | 368 | 5 | 2022-12-24 | 36.45 | 0.91 | 2022-12-12 | 1 | 26.97 | 1 | 36.45 | 2 | SO47424 | 2022-12-19 | 2.92 | 26.97 | 36.45 |
SO49836_30 | 0E32-48F7-89 | PO12644185975 | 100 | 285 | 456 | 530 | 5 | 2023-07-24 | 224.97 | 5.62 | 2023-07-12 | 5 | 30.93 | 1 | 224.97 | 30 | SO49836 | 2023-07-19 | 18.00 | 154.67 | 44.99 |
SO44518_18 | 359F-48A3-B9 | PO12586169040 | 100 | 285 | 307 | 278 | 5 | 2022-02-23 | 1445.19 | 36.13 | 2022-02-11 | 2 | 623.84 | 1 | 1445.19 | 18 | SO44518 | 2022-02-18 | 115.62 | 1247.68 | 722.59 |
SO63245_15 | 1025-4AD1-A1 | PO5800120355 | 100 | 285 | 512 | 63 | 5 | 2024-05-25 | 655.36 | 16.38 | 2024-05-13 | 3 | 199.38 | 1 | 655.36 | 15 | SO63245 | 2024-05-20 | 52.43 | 598.13 | 218.45 |
SO47424_4 | 9DF2-4A59-AE | PO4089167750 | 100 | 285 | 399 | 368 | 5 | 2022-12-24 | 67.55 | 1.69 | 2022-12-12 | 2 | 24.99 | 1 | 67.55 | 4 | SO47424 | 2022-12-19 | 5.40 | 49.99 | 33.77 |
SO43659_2 | 4911-403C-98 | PO522145787 | 100 | 285 | 350 | 676 | 5 | 2021-10-23 | 6074.98 | 151.87 | 2021-10-11 | 3 | 1898.09 | 1 | 6074.98 | 2 | SO43659 | 2021-10-18 | 486.00 | 5694.28 | 2024.99 |
SO49170_5 | B501-448E-96 | PO10150180753 | 100 | 285 | 445 | 9 | 5 | 2023-05-26 | 71.99 | 1.80 | 2023-05-14 | 2 | 24.75 | 1 | 71.99 | 5 | SO49170 | 2023-05-21 | 5.76 | 49.49 | 35.99 |
SO49110_1 | DB44-4376-BD | PO16211161509 | 100 | 285 | 420 | 99 | 5 | 2023-05-26 | 141.62 | 3.54 | 2023-05-14 | 1 | 104.80 | 1 | 141.62 | 1 | SO49110 | 2023-05-21 | 11.33 | 104.80 | 141.62 |
SO45300_13 | 650B-4342-95 | PO12586158748 | 100 | 285 | 345 | 278 | 5 | 2022-05-26 | 18359.95 | 459.00 | 2022-05-14 | 9 | 1912.15 | 1 | 18359.95 | 13 | SO45300 | 2022-05-21 | 1468.80 | 17209.39 | 2039.99 |
SO44488_24 | 18BD-4C15-81 | PO19546136242 | 100 | 285 | 235 | 206 | 5 | 2022-02-23 | 57.68 | 1.44 | 2022-02-11 | 2 | 31.72 | 1 | 57.68 | 24 | SO44488 | 2022-02-18 | 4.61 | 63.45 | 28.84 |
SO46672_49 | FFCF-4848-99 | PO9831178966 | 100 | 285 | 343 | 81 | 5 | 2022-10-23 | 1409.38 | 35.23 | 2022-10-11 | 3 | 486.71 | 1 | 1409.38 | 49 | SO46672 | 2022-10-18 | 112.75 | 1460.12 | 469.79 |
SO48018_32 | 5D69-492B-A1 | PO11571175810 | 100 | 285 | 341 | 512 | 5 | 2023-02-23 | 939.59 | 23.49 | 2023-02-11 | 2 | 486.71 | 1 | 939.59 | 32 | SO48018 | 2023-02-18 | 75.17 | 973.41 | 469.79 |
SO44764_2 | 85B4-4420-81 | PO11426178608 | 100 | 285 | 324 | 386 | 5 | 2022-03-25 | 419.46 | 10.49 | 2022-03-13 | 1 | 413.15 | 1 | 419.46 | 2 | SO44764 | 2022-03-20 | 33.56 | 413.15 | 419.46 |
SO44101_2 | F33F-41D4-81 | PO11977181307 | 100 | 285 | 324 | 675 | 5 | 2021-12-24 | 838.92 | 20.97 | 2021-12-12 | 2 | 413.15 | 1 | 838.92 | 2 | SO44101 | 2021-12-19 | 67.11 | 826.29 | 419.46 |
SO47053_13 | 686D-414B-82 | PO7598127510 | 100 | 285 | 439 | 45 | 5 | 2022-11-23 | 3123.27 | 78.08 | 2022-11-11 | 4 | 722.26 | 1 | 3123.27 | 13 | SO47053 | 2022-11-18 | 249.86 | 2889.03 | 780.82 |
SO48063_3 | AEA4-4489-90 | PO5858143254 | 100 | 285 | 366 | 566 | 5 | 2023-02-23 | 1943.98 | 48.60 | 2023-02-11 | 3 | 598.44 | 1 | 1943.98 | 3 | SO48063 | 2023-02-18 | 155.52 | 1795.31 | 647.99 |
SO69474_7 | 2DD3-46CB-BD | PO18560139140 | 100 | 285 | 471 | 531 | 5 | 2024-08-23 | 114.30 | 2.86 | 2024-08-11 | 3 | 23.75 | 1 | 114.30 | 7 | SO69474 | 2024-08-18 | 9.14 | 71.25 | 38.10 |
SO48393_18 | 5B6A-41B6-BF | PO9599137631 | 100 | 285 | 422 | 170 | 5 | 2023-03-25 | 202.62 | 5.07 | 2023-03-13 | 3 | 49.98 | 1 | 202.62 | 18 | SO48393 | 2023-03-20 | 16.21 | 149.94 | 67.54 |
SO57074_11 | FF65-4261-97 | PO9918191120 | 100 | 285 | 492 | 260 | 5 | 2024-02-23 | 3011.73 | 75.29 | 2024-02-11 | 5 | 601.74 | 1 | 3011.73 | 11 | SO57074 | 2024-02-18 | 240.94 | 3008.72 | 602.35 |
SO46631_11 | D8CB-44CB-87 | PO11861116846 | 100 | 281 | 468 | 17 | 5 | 2022-10-23 | 45.59 | 1.14 | 2022-10-11 | 2 | 15.67 | 1 | 45.59 | 11 | SO46631 | 2022-10-18 | 3.65 | 31.34 | 22.79 |
SO49869_22 | A2BD-4A89-93 | PO9657193666 | 100 | 285 | 236 | 315 | 5 | 2023-07-24 | 57.68 | 1.44 | 2023-07-12 | 2 | 29.08 | 1 | 57.68 | 22 | SO49869 | 2023-07-19 | 4.61 | 58.16 | 28.84 |
SO46604_30 | 8062-4A97-B3 | PO522154989 | 100 | 285 | 468 | 676 | 5 | 2022-10-23 | 45.59 | 1.14 | 2022-10-11 | 2 | 15.67 | 1 | 45.59 | 30 | SO46604 | 2022-10-18 | 3.65 | 31.34 | 22.79 |
SO67348_26 | 4BD1-4782-A3 | PO9889141767 | 100 | 285 | 590 | 494 | 5 | 2024-07-24 | 1385.08 | 34.63 | 2024-07-12 | 3 | 419.78 | 1 | 1385.08 | 26 | SO67348 | 2024-07-19 | 110.81 | 1259.34 | 461.69 |
SO50191_2 | 1DDA-4B5A-95 | PO19546193423 | 100 | 285 | 422 | 206 | 5 | 2023-08-23 | 135.08 | 3.38 | 2023-08-11 | 2 | 49.98 | 1 | 135.08 | 2 | SO50191 | 2023-08-18 | 10.81 | 99.96 | 67.54 |
SO51780_15 | 30C4-4B8F-AA | PO18560115626 | 100 | 285 | 490 | 531 | 5 | 2023-11-23 | 161.97 | 4.05 | 2023-11-11 | 5 | 41.57 | 1 | 161.97 | 15 | SO51780 | 2023-11-18 | 12.96 | 207.86 | 32.39 |
SO43694_11 | EC3D-48E0-A6 | PO9657130250 | 100 | 285 | 220 | 315 | 5 | 2021-10-23 | 100.93 | 2.52 | 2021-10-11 | 5 | 12.03 | 1 | 100.93 | 11 | SO43694 | 2021-10-18 | 8.07 | 60.14 | 20.19 |
Generated 2024-11-10 09:11:32.193 UTC