[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SKIP 0 SHUFFLE SKIP 1312 < SKIP 250 > < TAKE 62 >
62 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50272_15 | E0A6-4CFA-90 | PO11745174916 | 100 | 282 | 221 | 97 | 4 | 2023-07-03 | 40.37 | 1.01 | 2023-06-21 | 2 | 13.88 | 1 | 40.37 | 15 | SO50272 | 2023-06-28 | 3.23 | 27.76 | 20.19 | |||
SO46374_11 | 67B2-494E-90 | PO5597118034 | 100 | 283 | 220 | 75 | 4 | 2022-08-03 | 121.12 | 3.03 | 2022-07-22 | 6 | 12.03 | 1 | 121.12 | 11 | SO46374 | 2022-07-29 | 9.69 | 72.17 | 20.19 | |||
SO59027_23 | C142-4AAA-AB | PO6757122081 | 100 | 281 | 588 | 21 | 4 | 2024-02-02 | 461.69 | 11.54 | 2024-01-21 | 1 | 419.78 | 1 | 461.69 | 23 | SO59027 | 2024-01-28 | 36.94 | 419.78 | 461.69 | |||
SO48080_43 | 4DC7-4772-87 | PO7656157590 | 100 | 282 | 458 | 403 | 4 | 2023-01-03 | 224.97 | 5.62 | 2022-12-22 | 5 | 30.93 | 1 | 224.97 | 43 | SO48080 | 2022-12-29 | 18.00 | 154.67 | 44.99 | |||
SO47018_17 | E622-43B1-98 | PO2523197473 | 100 | 287 | 370 | 167 | 4 | 2022-10-03 | 4398.03 | 109.95 | 2022-09-21 | 3 | 1518.79 | 1 | 4398.03 | 17 | SO47018 | 2022-09-28 | 351.84 | 4556.36 | 1466.01 | |||
SO43692_3 | BFA9-470E-B4 | PO7859187017 | 100 | 287 | 315 | 221 | 4 | 2021-09-02 | 6998.35 | 174.96 | 2021-08-21 | 8 | 884.71 | 1 | 6998.35 | 3 | SO43692 | 2021-08-28 | 559.87 | 7077.67 | 874.79 | |||
SO47687_10 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 387 | 203 | 4 | 2022-12-03 | 1200.53 | 30.01 | 2022-11-21 | 2 | 605.65 | 1 | 1200.53 | 10 | SO47687 | 2022-11-28 | 96.04 | 1211.30 | 600.26 | |||
SO47458_18 | 5D5A-47FC-AE | PO9686113121 | 100 | 282 | 412 | 457 | 4 | 2022-11-03 | 360.26 | 9.01 | 2022-10-22 | 2 | 133.30 | 1 | 360.26 | 18 | SO47458 | 2022-10-29 | 28.82 | 266.59 | 180.13 | |||
SO61218_42 | 8441-4C6F-89 | PO13688193778 | 100 | 282 | 222 | 475 | 4 | 2024-03-04 | 167.95 | 4.20 | 2024-02-21 | 8 | 13.09 | 1 | 167.95 | 42 | SO61218 | 2024-02-28 | 13.44 | 104.69 | 20.99 | |||
SO47034_25 | A5AA-46C3-92 | PO4843149248 | 100 | 287 | 441 | 257 | 4 | 2022-10-03 | 2342.45 | 58.56 | 2022-09-21 | 3 | 722.26 | 1 | 2342.45 | 25 | SO47034 | 2022-09-28 | 187.40 | 2166.77 | 780.82 | |||
SO67325_7 | 981F-41CE-8A | PO7859144943 | 100 | 287 | 374 | 221 | 4 | 2024-06-03 | 2932.02 | 73.30 | 2024-05-22 | 2 | 1554.95 | 1 | 2932.02 | 7 | SO67325 | 2024-05-29 | 234.56 | 3109.90 | 1466.01 | |||
SO49821_34 | 0B9B-460C-BC | PO551117366 | 100 | 281 | 373 | 4 | 4 | 2023-06-03 | 6544.69 | 163.62 | 2023-05-22 | 5 | 1320.68 | 1 | 6544.69 | 34 | SO49821 | 2023-05-29 | 523.58 | 6603.42 | 1308.94 | |||
SO69536_31 | 9646-48B3-9E | PO3654177498 | 100 | 281 | 592 | 16 | 435 | 4 | 90.40 | 2024-07-03 | 226.00 | 3.39 | 2024-06-21 | 2 | 308.22 | 1 | 135.60 | 31 | SO69536 | 2024-06-28 | 10.85 | 616.44 | 113.00 | 0.40 |
SO50226_7 | 75E5-4EFD-A7 | PO12499165634 | 100 | 282 | 456 | 78 | 4 | 2023-07-03 | 179.98 | 4.50 | 2023-06-21 | 4 | 30.93 | 1 | 179.98 | 7 | SO50226 | 2023-06-28 | 14.40 | 123.73 | 44.99 | |||
SO48080_6 | 4DC7-4772-87 | PO7656157590 | 100 | 282 | 230 | 403 | 4 | 2023-01-03 | 57.68 | 1.44 | 2022-12-22 | 2 | 29.08 | 1 | 57.68 | 6 | SO48080 | 2022-12-29 | 4.61 | 58.16 | 28.84 | |||
SO51856_16 | E170-419C-92 | PO3654183134 | 100 | 281 | 559 | 435 | 4 | 2023-10-03 | 48.58 | 1.21 | 2023-09-21 | 4 | 8.99 | 1 | 48.58 | 16 | SO51856 | 2023-09-28 | 3.89 | 35.95 | 12.14 | |||
SO59030_1 | C626-4025-A7 | PO2349177874 | 100 | 282 | 546 | 6 | 4 | 2024-02-02 | 37.25 | 0.93 | 2024-01-21 | 1 | 27.57 | 1 | 37.25 | 1 | SO59030 | 2024-01-28 | 2.98 | 27.57 | 37.25 | |||
SO50748_17 | 5FBE-4B52-B2 | PO6786143310 | 100 | 281 | 456 | 3 | 4 | 2023-08-03 | 314.96 | 7.87 | 2023-07-22 | 7 | 30.93 | 1 | 314.96 | 17 | SO50748 | 2023-07-29 | 25.20 | 216.53 | 44.99 | |||
SO67292_6 | 09EF-4688-BB | PO551144976 | 100 | 281 | 583 | 4 | 4 | 2024-06-03 | 3061.78 | 76.54 | 2024-05-22 | 3 | 1082.51 | 1 | 3061.78 | 6 | SO67292 | 2024-05-29 | 244.94 | 3247.53 | 1020.59 | |||
SO71782_10 | CA08-4A9B-8D | PO19372114749 | 100 | 282 | 578 | 582 | 4 | 2024-08-03 | 2915.64 | 72.89 | 2024-07-22 | 4 | 755.15 | 1 | 2915.64 | 10 | SO71782 | 2024-07-29 | 233.25 | 3020.60 | 728.91 | |||
SO50208_15 | 6993-49B4-8B | PO15689114248 | 100 | 281 | 417 | 328 | 4 | 2023-07-03 | 1297.81 | 32.45 | 2023-06-21 | 4 | 300.12 | 1 | 1297.81 | 15 | SO50208 | 2023-06-28 | 103.82 | 1200.48 | 324.45 | |||
SO55315_2 | 9AA0-4252-9B | PO2436179352 | 100 | 282 | 576 | 241 | 4 | 2023-12-03 | 2860.88 | 71.52 | 2023-11-21 | 2 | 1481.94 | 1 | 2860.88 | 2 | SO55315 | 2023-11-28 | 228.87 | 2963.88 | 1430.44 | |||
SO48775_9 | E56E-4C8C-AA | PO10817145980 | 100 | 287 | 389 | 203 | 4 | 2023-03-05 | 1800.79 | 45.02 | 2023-02-21 | 3 | 605.65 | 1 | 1800.79 | 9 | SO48775 | 2023-02-28 | 144.06 | 1816.95 | 600.26 | |||
SO65269_23 | 999D-45C9-AA | PO4640162431 | 100 | 287 | 597 | 648 | 4 | 2024-05-03 | 971.98 | 24.30 | 2024-04-21 | 3 | 294.58 | 1 | 971.98 | 23 | SO65269 | 2024-04-28 | 77.76 | 883.74 | 323.99 | |||
SO45571_15 | BAA6-412D-87 | PO7569141774 | 100 | 287 | 229 | 608 | 4 | 2022-05-03 | 28.84 | 0.72 | 2022-04-21 | 1 | 31.72 | 1 | 28.84 | 15 | SO45571 | 2022-04-28 | 2.31 | 31.72 | 28.84 | |||
SO65315_21 | 0FFB-4EB5-A3 | PO6757194680 | 100 | 281 | 603 | 21 | 4 | 2024-05-03 | 145.79 | 3.64 | 2024-04-21 | 2 | 53.94 | 1 | 145.79 | 21 | SO65315 | 2024-04-28 | 11.66 | 107.88 | 72.89 | |||
SO49058_41 | BD1B-4C7F-A9 | PO12499147561 | 100 | 282 | 265 | 78 | 4 | 2023-04-05 | 202.33 | 5.06 | 2023-03-24 | 1 | 187.16 | 1 | 202.33 | 41 | SO49058 | 2023-03-31 | 16.19 | 187.16 | 202.33 | |||
SO50226_39 | 75E5-4EFD-A7 | PO12499165634 | 100 | 282 | 461 | 78 | 4 | 2023-07-03 | 107.99 | 2.70 | 2023-06-21 | 2 | 37.12 | 1 | 107.99 | 39 | SO50226 | 2023-06-28 | 8.64 | 74.24 | 53.99 | |||
SO57128_24 | 52E0-4277-80 | PO6525176590 | 100 | 281 | 552 | 345 | 4 | 2024-01-03 | 54.89 | 1.37 | 2023-12-22 | 1 | 40.62 | 1 | 54.89 | 24 | SO57128 | 2023-12-29 | 4.39 | 40.62 | 54.89 | |||
SO61261_1 | A0C4-4351-92 | PO5394179748 | 100 | 281 | 472 | 94 | 4 | 2024-03-04 | 38.10 | 0.95 | 2024-02-21 | 1 | 23.75 | 1 | 38.10 | 1 | SO61261 | 2024-02-28 | 3.05 | 23.75 | 38.10 | |||
SO47034_32 | A5AA-46C3-92 | PO4843149248 | 100 | 287 | 341 | 257 | 4 | 2022-10-03 | 2348.97 | 58.72 | 2022-09-21 | 5 | 486.71 | 1 | 2348.97 | 32 | SO47034 | 2022-09-28 | 187.92 | 2433.53 | 469.79 | |||
SO53621_40 | 9324-4A3D-83 | PO9715186811 | 100 | 281 | 357 | 490 | 4 | 2023-11-03 | 12527.95 | 313.20 | 2023-10-22 | 9 | 1265.62 | 1 | 12527.95 | 40 | SO53621 | 2023-10-29 | 1002.24 | 11390.58 | 1391.99 | |||
SO67298_17 | F9FB-4B4C-92 | PO2755196827 | 100 | 282 | 579 | 205 | 4 | 2024-06-03 | 3644.55 | 91.11 | 2024-05-22 | 5 | 755.15 | 1 | 3644.55 | 17 | SO67298 | 2024-05-29 | 291.56 | 3775.75 | 728.91 | |||
SO45535_16 | BDC5-404A-8E | PO15138174425 | 100 | 283 | 322 | 93 | 4 | 2022-05-03 | 838.92 | 20.97 | 2022-04-21 | 2 | 413.15 | 1 | 838.92 | 16 | SO45535 | 2022-04-28 | 67.11 | 826.29 | 419.46 | |||
SO57138_17 | CD80-4144-8A | PO5684168325 | 100 | 282 | 400 | 385 | 4 | 2024-01-03 | 74.30 | 1.86 | 2023-12-22 | 2 | 27.49 | 1 | 74.30 | 17 | SO57138 | 2023-12-29 | 5.94 | 54.99 | 37.15 | |||
SO51121_20 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 231 | 491 | 4 | 2023-09-02 | 119.98 | 3.00 | 2023-08-21 | 4 | 38.49 | 1 | 119.98 | 20 | SO51121 | 2023-08-28 | 9.60 | 153.97 | 29.99 | |||
SO48012_17 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 265 | 78 | 4 | 2023-01-03 | 202.33 | 5.06 | 2022-12-22 | 1 | 187.16 | 1 | 202.33 | 17 | SO48012 | 2022-12-29 | 16.19 | 187.16 | 202.33 | |||
SO69409_8 | 09C5-4089-8B | PO16762188016 | 100 | 282 | 580 | 259 | 4 | 2024-07-03 | 3061.78 | 76.54 | 2024-06-21 | 3 | 1082.51 | 1 | 3061.78 | 8 | SO69409 | 2024-06-28 | 244.94 | 3247.53 | 1020.59 | |||
SO43912_13 | 69B6-46F8-A4 | PO7656175368 | 100 | 282 | 314 | 403 | 4 | 2021-10-03 | 2146.96 | 53.67 | 2021-09-21 | 1 | 2171.29 | 1 | 2146.96 | 13 | SO43912 | 2021-09-28 | 171.76 | 2171.29 | 2146.96 | |||
SO47018_40 | E622-43B1-98 | PO2523197473 | 100 | 287 | 230 | 167 | 4 | 2022-10-03 | 115.36 | 2.88 | 2022-09-21 | 4 | 29.08 | 1 | 115.36 | 40 | SO47018 | 2022-09-28 | 9.23 | 116.32 | 28.84 | |||
SO51827_8 | B106-4221-AD | PO4611117026 | 100 | 287 | 552 | 131 | 4 | 2023-10-03 | 109.79 | 2.74 | 2023-09-21 | 2 | 40.62 | 1 | 109.79 | 8 | SO51827 | 2023-09-28 | 8.78 | 81.24 | 54.89 | |||
SO47369_17 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 337 | 239 | 4 | 2022-11-03 | 939.59 | 23.49 | 2022-10-22 | 2 | 486.71 | 1 | 939.59 | 17 | SO47369 | 2022-10-29 | 75.17 | 973.41 | 469.79 | |||
SO50748_44 | 5FBE-4B52-B2 | PO6786143310 | 100 | 281 | 254 | 3 | 4 | 2023-08-03 | 367.88 | 9.20 | 2023-07-22 | 2 | 170.14 | 1 | 367.88 | 44 | SO50748 | 2023-07-29 | 29.43 | 340.29 | 183.94 | |||
SO65183_20 | 4E49-448C-93 | PO16269127603 | 100 | 287 | 487 | 624 | 4 | 2024-05-03 | 32.99 | 0.82 | 2024-04-21 | 1 | 20.57 | 1 | 32.99 | 20 | SO65183 | 2024-04-28 | 2.64 | 20.57 | 32.99 | |||
SO50289_22 | 0809-4DE4-93 | PO3480117331 | 100 | 281 | 327 | 436 | 4 | 2023-07-03 | 2348.97 | 58.72 | 2023-06-21 | 5 | 486.71 | 1 | 2348.97 | 22 | SO50289 | 2023-06-28 | 187.92 | 2433.53 | 469.79 | |||
SO61211_7 | F16E-45D3-94 | PO13659160415 | 100 | 287 | 587 | 437 | 4 | 2024-03-04 | 461.69 | 11.54 | 2024-02-21 | 1 | 419.78 | 1 | 461.69 | 7 | SO61211 | 2024-02-28 | 36.94 | 419.78 | 461.69 | |||
SO50214_17 | 97D5-41D3-8F | PO15196120916 | 100 | 282 | 333 | 258 | 4 | 2023-07-03 | 1879.18 | 46.98 | 2023-06-21 | 4 | 486.71 | 1 | 1879.18 | 17 | SO50214 | 2023-06-28 | 150.33 | 1946.83 | 469.79 | |||
SO51714_20 | D33A-4EAE-B1 | PO15689195197 | 100 | 281 | 378 | 328 | 4 | 2023-10-03 | 8796.06 | 219.90 | 2023-09-21 | 6 | 1554.95 | 1 | 8796.06 | 20 | SO51714 | 2023-09-28 | 703.68 | 9329.69 | 1466.01 | |||
SO55256_25 | 686E-4D36-8B | PO12528136439 | 100 | 282 | 569 | 331 | 4 | 2023-12-03 | 445.41 | 11.14 | 2023-11-21 | 1 | 461.44 | 1 | 445.41 | 25 | SO55256 | 2023-11-28 | 35.63 | 461.44 | 445.41 | |||
SO47989_3 | A1B2-4EFB-A7 | PO15921198782 | 100 | 287 | 325 | 77 | 4 | 2023-01-03 | 1409.38 | 35.23 | 2022-12-22 | 3 | 486.71 | 1 | 1409.38 | 3 | SO47989 | 2022-12-29 | 112.75 | 1460.12 | 469.79 | |||
SO55256_29 | 686E-4D36-8B | PO12528136439 | 100 | 282 | 570 | 331 | 4 | 2023-12-03 | 890.82 | 22.27 | 2023-11-21 | 2 | 461.44 | 1 | 890.82 | 29 | SO55256 | 2023-11-28 | 71.27 | 922.89 | 445.41 | |||
SO48080_2 | 4DC7-4772-87 | PO7656157590 | 100 | 282 | 236 | 403 | 4 | 2023-01-03 | 86.52 | 2.16 | 2022-12-22 | 3 | 29.08 | 1 | 86.52 | 2 | SO48080 | 2022-12-29 | 6.92 | 87.24 | 28.84 | |||
SO51842_16 | 2A39-4E97-9A | PO4843199898 | 100 | 287 | 408 | 257 | 4 | 2023-10-03 | 144.32 | 3.61 | 2023-09-21 | 2 | 53.40 | 1 | 144.32 | 16 | SO51842 | 2023-09-28 | 11.55 | 106.80 | 72.16 | |||
SO55249_3 | 0527-4C9D-BA | PO13688172507 | 100 | 282 | 514 | 475 | 4 | 2023-12-03 | 127.80 | 3.20 | 2023-11-21 | 2 | 47.29 | 1 | 127.80 | 3 | SO55249 | 2023-11-28 | 10.22 | 94.57 | 63.90 | |||
SO50721_2 | E836-480F-AA | PO16182137721 | 100 | 287 | 358 | 23 | 4 | 2023-08-03 | 4917.84 | 122.95 | 2023-07-22 | 4 | 1105.81 | 1 | 4917.84 | 2 | SO50721 | 2023-07-29 | 393.43 | 4423.24 | 1229.46 | |||
SO47677_15 | 2C43-407F-B3 | PO13688179339 | 100 | 282 | 360 | 475 | 4 | 2022-12-03 | 1229.46 | 30.74 | 2022-11-21 | 1 | 1105.81 | 1 | 1229.46 | 15 | SO47677 | 2022-11-28 | 98.36 | 1105.81 | 1229.46 | |||
SO44790_1 | C8CF-4ECD-A1 | PO5974142949 | 100 | 282 | 328 | 330 | 4 | 2022-02-02 | 838.92 | 20.97 | 2022-01-21 | 2 | 413.15 | 1 | 838.92 | 1 | SO44790 | 2022-01-28 | 67.11 | 826.29 | 419.46 | |||
SO48341_9 | A747-471B-97 | PO10701176180 | 100 | 282 | 358 | 133 | 4 | 2023-02-02 | 9835.67 | 245.89 | 2023-01-21 | 8 | 1105.81 | 1 | 9835.67 | 9 | SO48341 | 2023-01-28 | 786.85 | 8846.48 | 1229.46 | |||
SO49538_29 | CB52-4E7E-9B | PO6786132021 | 100 | 281 | 373 | 3 | 4 | 2023-05-03 | 1308.94 | 32.72 | 2023-04-21 | 1 | 1320.68 | 1 | 1308.94 | 29 | SO49538 | 2023-04-28 | 104.72 | 1320.68 | 1308.94 | |||
SO51745_19 | C261-441D-A5 | PO11745132954 | 100 | 282 | 378 | 97 | 4 | 2023-10-03 | 8796.06 | 219.90 | 2023-09-21 | 6 | 1554.95 | 1 | 8796.06 | 19 | SO51745 | 2023-09-28 | 703.68 | 9329.69 | 1466.01 | |||
SO65157_14 | 51FF-4A62-89 | PO19372154832 | 100 | 282 | 577 | 582 | 4 | 2024-05-03 | 2186.73 | 54.67 | 2024-04-21 | 3 | 755.15 | 1 | 2186.73 | 14 | SO65157 | 2024-04-28 | 174.94 | 2265.45 | 728.91 | |||
SO44755_12 | 3B0A-428C-99 | PO15167120207 | 100 | 283 | 336 | 273 | 4 | 2022-02-02 | 838.92 | 20.97 | 2022-01-21 | 2 | 413.15 | 1 | 838.92 | 12 | SO44755 | 2022-01-28 | 67.11 | 826.29 | 419.46 |
Generated 2024-09-20 19:27:35.383 UTC