[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > < SKIP 3164 > < TAKE 60 >
60 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO44771_4 | A78D-40A1-9E | PO783176074 | 100 | 286 | 320 | 91 | 1 | 2022-03-28 | 1258.38 | 31.46 | 2022-03-16 | 3 | 413.15 | 1 | 1258.38 | 4 | SO44771 | 2022-03-23 | 100.67 | 1239.44 | 419.46 | |||
| SO44771_5 | A78D-40A1-9E | PO783176074 | 100 | 286 | 285 | 91 | 1 | 2022-03-28 | 357.16 | 8.93 | 2022-03-16 | 2 | 176.20 | 1 | 357.16 | 5 | SO44771 | 2022-03-23 | 28.57 | 352.40 | 178.58 | |||
| SO44771_6 | A78D-40A1-9E | PO783176074 | 100 | 286 | 223 | 91 | 1 | 2022-03-28 | 10.37 | 0.26 | 2022-03-16 | 2 | 5.71 | 1 | 10.37 | 6 | SO44771 | 2022-03-23 | 0.83 | 11.41 | 5.19 | |||
| SO44771_7 | A78D-40A1-9E | PO783176074 | 100 | 286 | 318 | 91 | 1 | 2022-03-28 | 1749.59 | 43.74 | 2022-03-16 | 2 | 884.71 | 1 | 1749.59 | 7 | SO44771 | 2022-03-23 | 139.97 | 1769.42 | 874.79 | |||
| SO44771_8 | A78D-40A1-9E | PO783176074 | 100 | 286 | 338 | 91 | 1 | 2022-03-28 | 1258.38 | 31.46 | 2022-03-16 | 3 | 413.15 | 1 | 1258.38 | 8 | SO44771 | 2022-03-23 | 100.67 | 1239.44 | 419.46 | |||
| SO44771_9 | A78D-40A1-9E | PO783176074 | 100 | 286 | 340 | 91 | 1 | 2022-03-28 | 1258.38 | 31.46 | 2022-03-16 | 3 | 413.15 | 1 | 1258.38 | 9 | SO44771 | 2022-03-23 | 100.67 | 1239.44 | 419.46 | |||
| SO44771_10 | A78D-40A1-9E | PO783176074 | 100 | 286 | 332 | 91 | 1 | 2022-03-28 | 1258.38 | 31.46 | 2022-03-16 | 3 | 413.15 | 1 | 1258.38 | 10 | SO44771 | 2022-03-23 | 100.67 | 1239.44 | 419.46 | |||
| SO44771_11 | A78D-40A1-9E | PO783176074 | 100 | 286 | 336 | 91 | 1 | 2022-03-28 | 1258.38 | 31.46 | 2022-03-16 | 3 | 413.15 | 1 | 1258.38 | 11 | SO44771 | 2022-03-23 | 100.67 | 1239.44 | 419.46 | |||
| SO44771_12 | A78D-40A1-9E | PO783176074 | 100 | 286 | 326 | 91 | 1 | 2022-03-28 | 1258.38 | 31.46 | 2022-03-16 | 3 | 413.15 | 1 | 1258.38 | 12 | SO44771 | 2022-03-23 | 100.67 | 1239.44 | 419.46 | |||
| SO44771_13 | A78D-40A1-9E | PO783176074 | 100 | 286 | 316 | 91 | 1 | 2022-03-28 | 1749.59 | 43.74 | 2022-03-16 | 2 | 884.71 | 1 | 1749.59 | 13 | SO44771 | 2022-03-23 | 139.97 | 1769.42 | 874.79 | |||
| SO44771_14 | A78D-40A1-9E | PO783176074 | 100 | 286 | 312 | 91 | 1 | 2022-03-28 | 12881.77 | 322.04 | 2022-03-16 | 6 | 2171.29 | 1 | 12881.77 | 14 | SO44771 | 2022-03-23 | 1030.54 | 13027.77 | 2146.96 | |||
| SO44771_15 | A78D-40A1-9E | PO783176074 | 100 | 286 | 324 | 91 | 1 | 2022-03-28 | 1677.84 | 41.95 | 2022-03-16 | 4 | 413.15 | 1 | 1677.84 | 15 | SO44771 | 2022-03-23 | 134.23 | 1652.59 | 419.46 | |||
| SO44771_16 | A78D-40A1-9E | PO783176074 | 100 | 286 | 311 | 91 | 1 | 2022-03-28 | 8587.85 | 214.70 | 2022-03-16 | 4 | 2171.29 | 1 | 8587.85 | 16 | SO44771 | 2022-03-23 | 687.03 | 8685.18 | 2146.96 | |||
| SO44771_17 | A78D-40A1-9E | PO783176074 | 100 | 286 | 270 | 91 | 1 | 2022-03-28 | 183.94 | 4.60 | 2022-03-16 | 1 | 181.49 | 1 | 183.94 | 17 | SO44771 | 2022-03-23 | 14.72 | 181.49 | 183.94 | |||
| SO44771_18 | A78D-40A1-9E | PO783176074 | 100 | 286 | 232 | 91 | 1 | 2022-03-28 | 57.68 | 1.44 | 2022-03-16 | 2 | 31.72 | 1 | 57.68 | 18 | SO44771 | 2022-03-23 | 4.61 | 63.45 | 28.84 | |||
| SO44771_19 | A78D-40A1-9E | PO783176074 | 100 | 286 | 212 | 91 | 1 | 2022-03-28 | 60.56 | 1.51 | 2022-03-16 | 3 | 12.03 | 1 | 60.56 | 19 | SO44771 | 2022-03-23 | 4.84 | 36.08 | 20.19 | |||
| SO44771_20 | A78D-40A1-9E | PO783176074 | 100 | 286 | 330 | 91 | 1 | 2022-03-28 | 1258.38 | 31.46 | 2022-03-16 | 3 | 413.15 | 1 | 1258.38 | 20 | SO44771 | 2022-03-23 | 100.67 | 1239.44 | 419.46 | |||
| SO44771_21 | A78D-40A1-9E | PO783176074 | 100 | 286 | 314 | 91 | 1 | 2022-03-28 | 6440.89 | 161.02 | 2022-03-16 | 3 | 2171.29 | 1 | 6440.89 | 21 | SO44771 | 2022-03-23 | 515.27 | 6513.88 | 2146.96 | |||
| SO44771_22 | A78D-40A1-9E | PO783176074 | 100 | 286 | 310 | 91 | 1 | 2022-03-28 | 6440.89 | 161.02 | 2022-03-16 | 3 | 2171.29 | 1 | 6440.89 | 22 | SO44771 | 2022-03-23 | 515.27 | 6513.88 | 2146.96 | |||
| SO44771_23 | A78D-40A1-9E | PO783176074 | 100 | 286 | 319 | 91 | 1 | 2022-03-28 | 2624.38 | 65.61 | 2022-03-16 | 3 | 884.71 | 1 | 2624.38 | 23 | SO44771 | 2022-03-23 | 209.95 | 2654.12 | 874.79 | |||
| SO44771_24 | A78D-40A1-9E | PO783176074 | 100 | 286 | 315 | 91 | 1 | 2022-03-28 | 874.79 | 21.87 | 2022-03-16 | 1 | 884.71 | 1 | 874.79 | 24 | SO44771 | 2022-03-23 | 69.98 | 884.71 | 874.79 | |||
| SO44771_25 | A78D-40A1-9E | PO783176074 | 100 | 286 | 262 | 91 | 1 | 2022-03-28 | 551.81 | 13.80 | 2022-03-16 | 3 | 181.49 | 1 | 551.81 | 25 | SO44771 | 2022-03-23 | 44.15 | 544.46 | 183.94 | |||
| SO44771_26 | A78D-40A1-9E | PO783176074 | 100 | 286 | 322 | 91 | 1 | 2022-03-28 | 419.46 | 10.49 | 2022-03-16 | 1 | 413.15 | 1 | 419.46 | 26 | SO44771 | 2022-03-23 | 33.56 | 413.15 | 419.46 | |||
| SO44771_27 | A78D-40A1-9E | PO783176074 | 100 | 286 | 253 | 91 | 1 | 2022-03-28 | 178.58 | 4.46 | 2022-03-16 | 1 | 176.20 | 1 | 178.58 | 27 | SO44771 | 2022-03-23 | 14.29 | 176.20 | 178.58 | |||
| SO44771_28 | A78D-40A1-9E | PO783176074 | 100 | 286 | 235 | 91 | 1 | 2022-03-28 | 28.84 | 0.72 | 2022-03-16 | 1 | 31.72 | 1 | 28.84 | 28 | SO44771 | 2022-03-23 | 2.31 | 31.72 | 28.84 | |||
| SO44771_29 | A78D-40A1-9E | PO783176074 | 100 | 286 | 220 | 91 | 1 | 2022-03-28 | 60.56 | 1.51 | 2022-03-16 | 3 | 12.03 | 1 | 60.56 | 29 | SO44771 | 2022-03-23 | 4.84 | 36.08 | 20.19 | |||
| SO44771_30 | A78D-40A1-9E | PO783176074 | 100 | 286 | 313 | 91 | 1 | 2022-03-28 | 10734.81 | 268.37 | 2022-03-16 | 5 | 2171.29 | 1 | 10734.81 | 30 | SO44771 | 2022-03-23 | 858.78 | 10856.47 | 2146.96 | |||
| SO44771_31 | A78D-40A1-9E | PO783176074 | 100 | 286 | 317 | 91 | 1 | 2022-03-28 | 2624.38 | 65.61 | 2022-03-16 | 3 | 884.71 | 1 | 2624.38 | 31 | SO44771 | 2022-03-23 | 209.95 | 2654.12 | 874.79 | |||
| SO44771_32 | A78D-40A1-9E | PO783176074 | 100 | 286 | 215 | 91 | 1 | 2022-03-28 | 60.56 | 1.51 | 2022-03-16 | 3 | 12.03 | 1 | 60.56 | 32 | SO44771 | 2022-03-23 | 4.84 | 36.08 | 20.19 | |||
| SO44788_1 | 4CD8-41D6-AE | PO5220181334 | 100 | 282 | 304 | 169 | 1 | 2022-03-28 | 2858.82 | 71.47 | 2022-03-16 | 4 | 617.03 | 1 | 2858.82 | 1 | SO44788 | 2022-03-23 | 228.71 | 2468.11 | 714.70 | |||
| SO44788_2 | 4CD8-41D6-AE | PO5220181334 | 100 | 282 | 346 | 169 | 1 | 2022-03-28 | 10199.97 | 255.00 | 2022-03-16 | 5 | 1912.15 | 1 | 10199.97 | 2 | SO44788 | 2022-03-23 | 816.00 | 9560.77 | 2039.99 | |||
| SO44788_3 | 4CD8-41D6-AE | PO5220181334 | 100 | 282 | 345 | 169 | 1 | 2022-03-28 | 10199.97 | 255.00 | 2022-03-16 | 5 | 1912.15 | 1 | 10199.97 | 3 | SO44788 | 2022-03-23 | 816.00 | 9560.77 | 2039.99 | |||
| SO44788_4 | 4CD8-41D6-AE | PO5220181334 | 100 | 282 | 307 | 169 | 1 | 2022-03-28 | 2167.78 | 54.19 | 2022-03-16 | 3 | 623.84 | 1 | 2167.78 | 4 | SO44788 | 2022-03-23 | 173.42 | 1871.52 | 722.59 | |||
| SO44788_5 | 4CD8-41D6-AE | PO5220181334 | 100 | 282 | 348 | 169 | 1 | 2022-03-28 | 18224.95 | 455.62 | 2022-03-16 | 9 | 1898.09 | 1 | 18224.95 | 5 | SO44788 | 2022-03-23 | 1458.00 | 17082.85 | 2024.99 | |||
| SO44788_6 | 4CD8-41D6-AE | PO5220181334 | 100 | 282 | 293 | 169 | 1 | 2022-03-28 | 722.59 | 18.06 | 2022-03-16 | 1 | 623.84 | 1 | 722.59 | 6 | SO44788 | 2022-03-23 | 57.81 | 623.84 | 722.59 | |||
| SO44788_7 | 4CD8-41D6-AE | PO5220181334 | 100 | 282 | 344 | 169 | 1 | 2022-03-28 | 4079.99 | 102.00 | 2022-03-16 | 2 | 1912.15 | 1 | 4079.99 | 7 | SO44788 | 2022-03-23 | 326.40 | 3824.31 | 2039.99 | |||
| SO67294_39 | 85E2-46A1-BE | PO899165491 | 100 | 289 | 472 | 290 | 1 | 2024-07-27 | 381.00 | 9.53 | 2024-07-15 | 10 | 23.75 | 1 | 381.00 | 39 | SO67294 | 2024-07-22 | 30.48 | 237.49 | 38.10 | |||
| SO67297_1 | 58AA-422C-BB | PO2552176926 | 100 | 286 | 532 | 506 | 1 | 2024-07-27 | 599.50 | 14.99 | 2024-07-15 | 4 | 136.79 | 1 | 599.50 | 1 | SO67297 | 2024-07-22 | 47.96 | 547.14 | 149.87 | |||
| SO67297_2 | 58AA-422C-BB | PO2552176926 | 100 | 286 | 357 | 506 | 1 | 2024-07-27 | 9743.96 | 243.60 | 2024-07-15 | 7 | 1265.62 | 1 | 9743.96 | 2 | SO67297 | 2024-07-22 | 779.52 | 8859.34 | 1391.99 | |||
| SO67297_3 | 58AA-422C-BB | PO2552176926 | 100 | 286 | 524 | 506 | 1 | 2024-07-27 | 316.86 | 7.92 | 2024-07-15 | 2 | 144.59 | 1 | 316.86 | 3 | SO67297 | 2024-07-22 | 25.35 | 289.19 | 158.43 | |||
| SO67297_4 | 58AA-422C-BB | PO2552176926 | 100 | 286 | 596 | 506 | 1 | 2024-07-27 | 1619.97 | 40.50 | 2024-07-15 | 5 | 294.58 | 1 | 1619.97 | 4 | SO67297 | 2024-07-22 | 129.60 | 1472.90 | 323.99 | |||
| SO67297_5 | 58AA-422C-BB | PO2552176926 | 100 | 286 | 543 | 506 | 1 | 2024-07-27 | 37.25 | 0.93 | 2024-07-15 | 1 | 27.57 | 1 | 37.25 | 5 | SO67297 | 2024-07-22 | 2.98 | 27.57 | 37.25 | |||
| SO67297_6 | 58AA-422C-BB | PO2552176926 | 100 | 286 | 525 | 506 | 1 | 2024-07-27 | 158.43 | 3.96 | 2024-07-15 | 1 | 144.59 | 1 | 158.43 | 6 | SO67297 | 2024-07-22 | 12.67 | 144.59 | 158.43 | |||
| SO67297_7 | 58AA-422C-BB | PO2552176926 | 100 | 286 | 359 | 2 | 506 | 1 | 319.46 | 2024-07-27 | 15973.13 | 391.34 | 2024-07-15 | 12 | 1251.98 | 1 | 15653.67 | 7 | SO67297 | 2024-07-22 | 1252.29 | 15023.78 | 1331.09 | 0.02 |
| SO67297_8 | 58AA-422C-BB | PO2552176926 | 100 | 286 | 476 | 4 | 506 | 1 | 111.98 | 2024-07-27 | 1119.84 | 25.20 | 2024-07-15 | 32 | 26.18 | 1 | 1007.86 | 8 | SO67297 | 2024-07-22 | 80.63 | 837.64 | 35.00 | 0.10 |
| SO67297_9 | 58AA-422C-BB | PO2552176926 | 100 | 286 | 587 | 506 | 1 | 2024-07-27 | 923.39 | 23.08 | 2024-07-15 | 2 | 419.78 | 1 | 923.39 | 9 | SO67297 | 2024-07-22 | 73.87 | 839.56 | 461.69 | |||
| SO67297_10 | 58AA-422C-BB | PO2552176926 | 100 | 286 | 590 | 506 | 1 | 2024-07-27 | 1846.78 | 46.17 | 2024-07-15 | 4 | 419.78 | 1 | 1846.78 | 10 | SO67297 | 2024-07-22 | 147.74 | 1679.11 | 461.69 | |||
| SO67297_11 | 58AA-422C-BB | PO2552176926 | 100 | 286 | 515 | 506 | 1 | 2024-07-27 | 48.82 | 1.22 | 2024-07-15 | 3 | 12.04 | 1 | 48.82 | 11 | SO67297 | 2024-07-22 | 3.91 | 36.12 | 16.27 | |||
| SO67297_12 | 58AA-422C-BB | PO2552176926 | 100 | 286 | 474 | 3 | 506 | 1 | 34.65 | 2024-07-27 | 692.90 | 16.46 | 2024-07-15 | 18 | 26.18 | 1 | 658.26 | 12 | SO67297 | 2024-07-22 | 52.66 | 471.17 | 38.49 | 0.05 |
| SO67297_13 | 58AA-422C-BB | PO2552176926 | 100 | 286 | 309 | 506 | 1 | 2024-07-27 | 2456.10 | 61.40 | 2024-07-15 | 3 | 747.20 | 1 | 2456.10 | 13 | SO67297 | 2024-07-22 | 196.49 | 2241.60 | 818.70 | |||
| SO67297_14 | 58AA-422C-BB | PO2552176926 | 100 | 286 | 402 | 506 | 1 | 2024-07-27 | 144.32 | 3.61 | 2024-07-15 | 2 | 53.40 | 1 | 144.32 | 14 | SO67297 | 2024-07-22 | 11.55 | 106.80 | 72.16 | |||
| SO67297_15 | 58AA-422C-BB | PO2552176926 | 100 | 286 | 465 | 506 | 1 | 2024-07-27 | 14.69 | 0.37 | 2024-07-15 | 1 | 9.16 | 1 | 14.69 | 15 | SO67297 | 2024-07-22 | 1.18 | 9.16 | 14.69 | |||
| SO67297_16 | 58AA-422C-BB | PO2552176926 | 100 | 286 | 598 | 506 | 1 | 2024-07-27 | 323.99 | 8.10 | 2024-07-15 | 1 | 294.58 | 1 | 323.99 | 16 | SO67297 | 2024-07-22 | 25.92 | 294.58 | 323.99 | |||
| SO67297_17 | 58AA-422C-BB | PO2552176926 | 100 | 286 | 588 | 506 | 1 | 2024-07-27 | 923.39 | 23.08 | 2024-07-15 | 2 | 419.78 | 1 | 923.39 | 17 | SO67297 | 2024-07-22 | 73.87 | 839.56 | 461.69 | |||
| SO67297_18 | 58AA-422C-BB | PO2552176926 | 100 | 286 | 589 | 506 | 1 | 2024-07-27 | 1385.08 | 34.63 | 2024-07-15 | 3 | 419.78 | 1 | 1385.08 | 18 | SO67297 | 2024-07-22 | 110.81 | 1259.34 | 461.69 | |||
| SO67297_19 | 58AA-422C-BB | PO2552176926 | 100 | 286 | 298 | 506 | 1 | 2024-07-27 | 1619.52 | 40.49 | 2024-07-15 | 2 | 739.04 | 1 | 1619.52 | 19 | SO67297 | 2024-07-22 | 129.56 | 1478.08 | 809.76 | |||
| SO67297_20 | 58AA-422C-BB | PO2552176926 | 100 | 286 | 400 | 506 | 1 | 2024-07-27 | 111.46 | 2.79 | 2024-07-15 | 3 | 27.49 | 1 | 111.46 | 20 | SO67297 | 2024-07-22 | 8.92 | 82.48 | 37.15 | |||
| SO67297_21 | 58AA-422C-BB | PO2552176926 | 100 | 286 | 544 | 506 | 1 | 2024-07-27 | 48.59 | 1.21 | 2024-07-15 | 1 | 35.96 | 1 | 48.59 | 21 | SO67297 | 2024-07-22 | 3.89 | 35.96 | 48.59 | |||
| SO67297_22 | 58AA-422C-BB | PO2552176926 | 100 | 286 | 600 | 506 | 1 | 2024-07-27 | 647.99 | 16.20 | 2024-07-15 | 2 | 294.58 | 1 | 647.99 | 22 | SO67297 | 2024-07-22 | 51.84 | 589.16 | 323.99 | |||
| SO67297_23 | 58AA-422C-BB | PO2552176926 | 100 | 286 | 517 | 506 | 1 | 2024-07-27 | 157.92 | 3.95 | 2024-07-15 | 5 | 23.37 | 1 | 157.92 | 23 | SO67297 | 2024-07-22 | 12.63 | 116.86 | 31.58 |
Generated 2024-11-13 10:02:31.296 UTC