[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SKIP 0 SHUFFLE < SKIP 1250 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50289_11 | 0809-4DE4-93 | PO3480117331 | 100 | 281 | 371 | 436 | 4 | 2023-07-02 | 3926.81 | 98.17 | 2023-06-20 | 3 | 1320.68 | 1 | 3926.81 | 11 | SO50289 | 2023-06-27 | 314.15 | 3962.05 | 1308.94 | |||
SO51090_64 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 542 | 475 | 4 | 2023-09-01 | 48.59 | 1.21 | 2023-08-20 | 2 | 17.98 | 1 | 48.59 | 64 | SO51090 | 2023-08-27 | 3.89 | 35.96 | 24.29 | |||
SO44314_7 | 6FDF-4206-A7 | PO5626111923 | 100 | 283 | 238 | 166 | 4 | 2021-12-02 | 1516.15 | 37.90 | 2021-11-20 | 2 | 747.97 | 1 | 1516.15 | 7 | SO44314 | 2021-11-27 | 121.29 | 1495.94 | 758.08 | |||
SO57062_15 | D146-4B3C-BB | PO11745129321 | 100 | 282 | 546 | 97 | 4 | 2024-01-02 | 149.02 | 3.73 | 2023-12-21 | 4 | 27.57 | 1 | 149.02 | 15 | SO57062 | 2023-12-28 | 11.92 | 110.27 | 37.25 | |||
SO47994_19 | 284B-45A1-94 | PO15196121630 | 100 | 282 | 286 | 258 | 4 | 2023-01-02 | 367.88 | 9.20 | 2022-12-21 | 2 | 170.14 | 1 | 367.88 | 19 | SO47994 | 2022-12-28 | 29.43 | 340.29 | 183.94 | |||
SO45798_25 | 3FA4-4459-BD | PO10817199969 | 100 | 287 | 314 | 203 | 4 | 2022-06-02 | 2146.96 | 53.67 | 2022-05-21 | 1 | 2171.29 | 1 | 2146.96 | 25 | SO45798 | 2022-05-28 | 171.76 | 2171.29 | 2146.96 | |||
SO59013_24 | C224-4535-BA | PO5597199820 | 100 | 281 | 532 | 75 | 4 | 2024-02-01 | 299.75 | 7.49 | 2024-01-20 | 2 | 136.79 | 1 | 299.75 | 24 | SO59013 | 2024-01-27 | 23.98 | 273.57 | 149.87 | |||
SO47056_51 | 53BF-4950-9E | PO7656118289 | 100 | 282 | 233 | 403 | 4 | 2022-10-02 | 230.72 | 5.77 | 2022-09-20 | 8 | 29.08 | 1 | 230.72 | 51 | SO47056 | 2022-09-27 | 18.46 | 232.65 | 28.84 | |||
SO67305_12 | CBB5-42BF-9E | PO16298111473 | 100 | 287 | 498 | 599 | 4 | 2024-06-02 | 1204.69 | 30.12 | 2024-05-21 | 2 | 601.74 | 1 | 1204.69 | 12 | SO67305 | 2024-05-28 | 96.38 | 1203.49 | 602.35 | |||
SO47018_52 | E622-43B1-98 | PO2523197473 | 100 | 287 | 339 | 167 | 4 | 2022-10-02 | 3288.56 | 82.21 | 2022-09-20 | 7 | 486.71 | 1 | 3288.56 | 52 | SO47018 | 2022-09-27 | 263.08 | 3406.95 | 469.79 | |||
SO45810_7 | 2A16-4AA7-89 | PO5626186069 | 100 | 283 | 262 | 166 | 4 | 2022-06-02 | 735.75 | 18.39 | 2022-05-21 | 4 | 181.49 | 1 | 735.75 | 7 | SO45810 | 2022-05-28 | 58.86 | 725.94 | 183.94 | |||
SO65160_33 | 9375-44FE-94 | PO19343172976 | 100 | 282 | 225 | 24 | 4 | 2024-05-02 | 37.76 | 0.94 | 2024-04-20 | 7 | 6.92 | 1 | 37.76 | 33 | SO65160 | 2024-04-27 | 3.02 | 48.46 | 5.39 | |||
SO48311_32 | AAD7-4EBC-A1 | PO16472177233 | 100 | 287 | 254 | 239 | 4 | 2023-02-01 | 183.94 | 4.60 | 2023-01-20 | 1 | 170.14 | 1 | 183.94 | 32 | SO48311 | 2023-01-27 | 14.72 | 170.14 | 183.94 | |||
SO46625_32 | 361B-4CAF-A2 | PO13688113829 | 100 | 282 | 294 | 475 | 4 | 2022-09-01 | 744.27 | 18.61 | 2022-08-20 | 1 | 660.91 | 1 | 744.27 | 32 | SO46625 | 2022-08-27 | 59.54 | 660.91 | 744.27 | |||
SO43912_5 | 69B6-46F8-A4 | PO7656175368 | 100 | 282 | 235 | 403 | 4 | 2021-10-02 | 86.52 | 2.16 | 2021-09-20 | 3 | 31.72 | 1 | 86.52 | 5 | SO43912 | 2021-09-27 | 6.92 | 95.17 | 28.84 | |||
SO44777_17 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 351 | 366 | 4 | 2022-02-01 | 16199.95 | 405.00 | 2022-01-20 | 8 | 1898.09 | 1 | 16199.95 | 17 | SO44777 | 2022-01-27 | 1296.00 | 15184.76 | 2024.99 | |||
SO59027_1 | C142-4AAA-AB | PO6757122081 | 100 | 281 | 400 | 21 | 4 | 2024-02-01 | 37.15 | 0.93 | 2024-01-20 | 1 | 27.49 | 1 | 37.15 | 1 | SO59027 | 2024-01-27 | 2.97 | 27.49 | 37.15 | |||
SO48780_14 | F139-41F4-83 | PO5626121558 | 100 | 281 | 417 | 166 | 4 | 2023-03-04 | 324.45 | 8.11 | 2023-02-20 | 1 | 300.12 | 1 | 324.45 | 14 | SO48780 | 2023-02-27 | 25.96 | 300.12 | 324.45 | |||
SO47024_20 | F254-4053-A3 | PO3654136382 | 100 | 283 | 352 | 435 | 4 | 2022-10-02 | 3728.56 | 93.21 | 2022-09-20 | 3 | 1117.86 | 1 | 3728.56 | 20 | SO47024 | 2022-09-27 | 298.28 | 3353.57 | 1242.85 | |||
SO47434_9 | 6848-4C33-98 | PO5539145068 | 100 | 282 | 362 | 61 | 4 | 2022-11-02 | 3688.38 | 92.21 | 2022-10-21 | 3 | 1105.81 | 1 | 3688.38 | 9 | SO47434 | 2022-10-28 | 295.07 | 3317.43 | 1229.46 | |||
SO49498_4 | D9E7-4090-86 | PO16472151816 | 100 | 287 | 329 | 2 | 239 | 4 | 127.16 | 2023-05-02 | 6357.88 | 155.77 | 2023-04-20 | 14 | 486.71 | 1 | 6230.72 | 4 | SO49498 | 2023-04-27 | 498.46 | 6813.89 | 454.13 | 0.02 |
SO47016_3 | 205E-4F0A-81 | PO2320157867 | 100 | 282 | 385 | 529 | 4 | 2022-10-02 | 600.26 | 15.01 | 2022-09-20 | 1 | 605.65 | 1 | 600.26 | 3 | SO47016 | 2022-09-27 | 48.02 | 605.65 | 600.26 | |||
SO51745_6 | C261-441D-A5 | PO11745132954 | 100 | 282 | 234 | 97 | 4 | 2023-10-02 | 29.99 | 0.75 | 2023-09-20 | 1 | 38.49 | 1 | 29.99 | 6 | SO51745 | 2023-09-27 | 2.40 | 38.49 | 29.99 | |||
SO48378_2 | 2FD7-4721-9D | PO6786131738 | 100 | 283 | 323 | 3 | 4 | 2023-02-01 | 939.59 | 23.49 | 2023-01-20 | 2 | 486.71 | 1 | 939.59 | 2 | SO48378 | 2023-01-27 | 75.17 | 973.41 | 469.79 | |||
SO59068_26 | B7CC-4A9D-86 | PO9715112509 | 100 | 281 | 531 | 490 | 4 | 2024-02-01 | 449.62 | 11.24 | 2024-01-20 | 3 | 136.79 | 1 | 449.62 | 26 | SO59068 | 2024-01-27 | 35.97 | 410.36 | 149.87 | |||
SO50688_31 | C55C-41B0-92 | PO10701178438 | 100 | 282 | 221 | 2 | 133 | 4 | 4.68 | 2023-08-02 | 234.16 | 5.74 | 2023-07-21 | 12 | 13.88 | 1 | 229.48 | 31 | SO50688 | 2023-07-28 | 18.36 | 166.54 | 19.51 | 0.02 |
SO65232_6 | 3D4B-4E94-8F | PO9715132845 | 100 | 281 | 361 | 490 | 4 | 2024-05-02 | 4130.98 | 103.27 | 2024-04-20 | 3 | 1251.98 | 1 | 4130.98 | 6 | SO65232 | 2024-04-27 | 330.48 | 3755.94 | 1376.99 | |||
SO51121_16 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 380 | 491 | 4 | 2023-09-01 | 4398.03 | 109.95 | 2023-08-20 | 3 | 1554.95 | 1 | 4398.03 | 16 | SO51121 | 2023-08-27 | 351.84 | 4664.84 | 1466.01 | |||
SO63187_1 | 7AD7-4EDD-95 | PO15747121981 | 100 | 281 | 390 | 471 | 4 | 2024-04-03 | 672.29 | 16.81 | 2024-03-22 | 1 | 713.08 | 1 | 672.29 | 1 | SO63187 | 2024-03-29 | 53.78 | 713.08 | 672.29 | |||
SO45286_1 | AE6F-4379-99 | PO16762133534 | 100 | 282 | 315 | 259 | 4 | 2022-04-04 | 874.79 | 21.87 | 2022-03-23 | 1 | 884.71 | 1 | 874.79 | 1 | SO45286 | 2022-03-30 | 69.98 | 884.71 | 874.79 | |||
SO49523_17 | 852E-47A8-A9 | PO3915144057 | 100 | 281 | 445 | 130 | 4 | 2023-05-02 | 35.99 | 0.90 | 2023-04-20 | 1 | 24.75 | 1 | 35.99 | 17 | SO49523 | 2023-04-27 | 2.88 | 24.75 | 35.99 | |||
SO69528_31 | 2644-4747-86 | PO6438163496 | 100 | 272 | 531 | 309 | 4 | 2024-07-02 | 149.87 | 3.75 | 2024-06-20 | 1 | 136.79 | 1 | 149.87 | 31 | SO69528 | 2024-06-27 | 11.99 | 136.79 | 149.87 | |||
SO49890_45 | 9B22-4240-83 | PO7859114282 | 100 | 272 | 327 | 3 | 221 | 4 | 366.05 | 2023-06-02 | 7320.96 | 173.87 | 2023-05-21 | 17 | 486.71 | 1 | 6954.91 | 45 | SO49890 | 2023-05-28 | 556.39 | 8274.01 | 430.64 | 0.05 |
SO63285_2 | 6316-44BB-8E | PO3480176259 | 100 | 281 | 477 | 436 | 4 | 2024-04-03 | 11.98 | 0.30 | 2024-03-22 | 4 | 1.87 | 1 | 11.98 | 2 | SO63285 | 2024-03-29 | 0.96 | 7.47 | 2.99 | |||
SO51856_22 | E170-419C-92 | PO3654183134 | 100 | 281 | 514 | 435 | 4 | 2023-10-02 | 255.60 | 6.39 | 2023-09-20 | 4 | 47.29 | 1 | 255.60 | 22 | SO51856 | 2023-09-27 | 20.45 | 189.14 | 63.90 | |||
SO48313_7 | 5D5B-4BBC-AB | PO16182116781 | 100 | 287 | 224 | 23 | 4 | 2023-02-01 | 5.19 | 0.13 | 2023-01-20 | 1 | 5.23 | 1 | 5.19 | 7 | SO48313 | 2023-01-27 | 0.41 | 5.23 | 5.19 | |||
SO49851_6 | 14FB-4B97-95 | PO2494142030 | 100 | 281 | 358 | 184 | 4 | 2023-06-02 | 7376.75 | 184.42 | 2023-05-21 | 6 | 1105.81 | 1 | 7376.75 | 6 | SO49851 | 2023-05-28 | 590.14 | 6634.86 | 1229.46 | |||
SO43678_1 | FBD8-4CE4-8B | PO10817150168 | 100 | 287 | 322 | 203 | 4 | 2021-09-01 | 419.46 | 10.49 | 2021-08-20 | 1 | 413.15 | 1 | 419.46 | 1 | SO43678 | 2021-08-27 | 33.56 | 413.15 | 419.46 | |||
SO50252_45 | B5DA-491E-A9 | PO2523194031 | 100 | 287 | 385 | 167 | 4 | 2023-07-02 | 2401.05 | 60.03 | 2023-06-20 | 4 | 605.65 | 1 | 2401.05 | 45 | SO50252 | 2023-06-27 | 192.08 | 2422.60 | 600.26 | |||
SO57085_26 | D1E5-454C-85 | PO2523188219 | 100 | 287 | 222 | 167 | 4 | 2024-01-02 | 83.98 | 2.10 | 2023-12-21 | 4 | 13.09 | 1 | 83.98 | 26 | SO57085 | 2023-12-28 | 6.72 | 52.35 | 20.99 | |||
SO50748_6 | 5FBE-4B52-B2 | PO6786143310 | 100 | 281 | 457 | 3 | 4 | 2023-08-02 | 134.98 | 3.37 | 2023-07-21 | 3 | 30.93 | 1 | 134.98 | 6 | SO50748 | 2023-07-28 | 10.80 | 92.80 | 44.99 | |||
SO48311_50 | AAD7-4EBC-A1 | PO16472177233 | 100 | 287 | 459 | 239 | 4 | 2023-02-01 | 215.98 | 5.40 | 2023-01-20 | 4 | 37.12 | 1 | 215.98 | 50 | SO48311 | 2023-01-27 | 17.28 | 148.48 | 53.99 | |||
SO46638_22 | 9659-44CE-A2 | PO10817110834 | 100 | 287 | 371 | 203 | 4 | 2022-09-01 | 1308.94 | 32.72 | 2022-08-20 | 1 | 1320.68 | 1 | 1308.94 | 22 | SO46638 | 2022-08-27 | 104.72 | 1320.68 | 1308.94 | |||
SO65310_7 | 65CB-474A-9D | PO6786169596 | 100 | 281 | 477 | 3 | 4 | 2024-05-02 | 11.98 | 0.30 | 2024-04-20 | 4 | 1.87 | 1 | 11.98 | 7 | SO65310 | 2024-04-27 | 0.96 | 7.47 | 2.99 | |||
SO63280_25 | C73E-4203-80 | PO3654118854 | 100 | 281 | 556 | 435 | 4 | 2024-04-03 | 421.18 | 10.53 | 2024-03-22 | 4 | 77.92 | 1 | 421.18 | 25 | SO63280 | 2024-03-29 | 33.69 | 311.67 | 105.29 | |||
SO49074_4 | F3B3-405D-83 | PO2320167746 | 100 | 282 | 383 | 529 | 4 | 2023-04-04 | 600.26 | 15.01 | 2023-03-23 | 1 | 605.65 | 1 | 600.26 | 4 | SO49074 | 2023-03-30 | 48.02 | 605.65 | 600.26 | |||
SO47360_1 | FED4-48AA-97 | PO18125158675 | 100 | 287 | 414 | 311 | 4 | 2022-11-02 | 149.03 | 3.73 | 2022-10-21 | 1 | 110.28 | 1 | 149.03 | 1 | SO47360 | 2022-10-28 | 11.92 | 110.28 | 149.03 | |||
SO50720_13 | 38E2-4AA6-B4 | PO9715181953 | 100 | 281 | 397 | 490 | 4 | 2023-08-02 | 72.88 | 1.82 | 2023-07-21 | 3 | 17.98 | 1 | 72.88 | 13 | SO50720 | 2023-07-28 | 5.83 | 53.93 | 24.29 | |||
SO50310_14 | FCBD-48EE-A9 | PO6438126969 | 100 | 281 | 358 | 309 | 4 | 2023-07-02 | 6147.29 | 153.68 | 2023-06-20 | 5 | 1105.81 | 1 | 6147.29 | 14 | SO50310 | 2023-06-27 | 491.78 | 5529.05 | 1229.46 | |||
SO57085_29 | D1E5-454C-85 | PO2523188219 | 100 | 287 | 380 | 167 | 4 | 2024-01-02 | 2932.02 | 73.30 | 2023-12-21 | 2 | 1554.95 | 1 | 2932.02 | 29 | SO57085 | 2023-12-28 | 234.56 | 3109.90 | 1466.01 | |||
SO55276_27 | 81AA-41E5-B0 | PO2755182998 | 100 | 282 | 497 | 205 | 4 | 2023-12-02 | 2409.38 | 60.23 | 2023-11-20 | 4 | 601.74 | 1 | 2409.38 | 27 | SO55276 | 2023-11-27 | 192.75 | 2406.97 | 602.35 | |||
SO71783_18 | 7E03-4B8A-BA | PO19343113609 | 100 | 282 | 471 | 3 | 24 | 4 | 26.19 | 2024-08-02 | 523.88 | 12.44 | 2024-07-21 | 15 | 23.75 | 1 | 497.68 | 18 | SO71783 | 2024-07-28 | 39.81 | 356.24 | 34.93 | 0.05 |
SO51833_6 | 67A5-4BBC-8F | PO5684113634 | 100 | 282 | 474 | 3 | 385 | 4 | 44.27 | 2023-10-02 | 885.37 | 21.03 | 2023-09-20 | 23 | 26.18 | 1 | 841.10 | 6 | SO51833 | 2023-09-27 | 67.29 | 602.05 | 38.49 | 0.05 |
SO48363_40 | A9C9-4B7B-9B | PO3915186343 | 100 | 283 | 381 | 130 | 4 | 2023-02-01 | 6002.63 | 150.07 | 2023-01-20 | 10 | 605.65 | 1 | 6002.63 | 40 | SO48363 | 2023-01-27 | 480.21 | 6056.49 | 600.26 | |||
SO45536_14 | 260C-4755-B2 | PO15167166424 | 100 | 283 | 312 | 273 | 4 | 2022-05-02 | 4293.92 | 107.35 | 2022-04-20 | 2 | 2171.29 | 1 | 4293.92 | 14 | SO45536 | 2022-04-27 | 343.51 | 4342.59 | 2146.96 | |||
SO63201_25 | 8299-4DE4-AD | PO15689136917 | 100 | 281 | 390 | 328 | 4 | 2024-04-03 | 4706.06 | 117.65 | 2024-03-22 | 7 | 713.08 | 1 | 4706.06 | 25 | SO63201 | 2024-03-29 | 376.48 | 4991.56 | 672.29 | |||
SO46338_11 | 0BAC-4D7E-AD | PO15834128897 | 100 | 283 | 220 | 417 | 4 | 2022-08-02 | 40.37 | 1.01 | 2022-07-21 | 2 | 12.03 | 1 | 40.37 | 11 | SO46338 | 2022-07-28 | 3.23 | 24.06 | 20.19 | |||
SO46103_15 | 1902-406D-BF | PO7830116487 | 100 | 283 | 292 | 40 | 4 | 2022-07-02 | 1637.40 | 40.94 | 2022-06-20 | 2 | 706.81 | 1 | 1637.40 | 15 | SO46103 | 2022-06-27 | 130.99 | 1413.62 | 818.70 | |||
SO46663_15 | 0EA2-42AA-A4 | PO6409112370 | 100 | 283 | 271 | 292 | 4 | 2022-09-01 | 202.33 | 5.06 | 2022-08-20 | 1 | 187.16 | 1 | 202.33 | 15 | SO46663 | 2022-08-27 | 16.19 | 187.16 | 202.33 | |||
SO47434_31 | 6848-4C33-98 | PO5539145068 | 100 | 282 | 460 | 61 | 4 | 2022-11-02 | 215.98 | 5.40 | 2022-10-21 | 4 | 37.12 | 1 | 215.98 | 31 | SO47434 | 2022-10-28 | 17.28 | 148.48 | 53.99 | |||
SO47422_17 | 9D8D-4481-B6 | PO3915123127 | 100 | 283 | 424 | 130 | 4 | 2022-11-02 | 428.47 | 10.71 | 2022-10-21 | 2 | 158.53 | 1 | 428.47 | 17 | SO47422 | 2022-10-28 | 34.28 | 317.07 | 214.24 | |||
SO43692_10 | BFA9-470E-B4 | PO7859187017 | 100 | 287 | 215 | 221 | 4 | 2021-09-01 | 60.56 | 1.51 | 2021-08-20 | 3 | 12.03 | 1 | 60.56 | 10 | SO43692 | 2021-08-27 | 4.84 | 36.08 | 20.19 |
Generated 2024-09-19 20:54:33.889 UTC