[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > < SKIP 2577 > < TAKE 60 >
60 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46043_1 | 1230-4EA4-83 | PO16791123625 | 100 | 281 | 276 | 36 | 2 | 2023-01-13 | 1070.69 | 26.77 | 2023-01-01 | 3 | 352.14 | 1 | 1070.69 | 1 | SO46043 | 2023-01-08 | 85.66 | 1056.42 | 356.90 |
SO46043_2 | 1230-4EA4-83 | PO16791123625 | 100 | 281 | 272 | 36 | 2 | 2023-01-13 | 367.88 | 9.20 | 2023-01-01 | 2 | 181.49 | 1 | 367.88 | 2 | SO46043 | 2023-01-08 | 29.43 | 362.97 | 183.94 |
SO46043_3 | 1230-4EA4-83 | PO16791123625 | 100 | 281 | 322 | 36 | 2 | 2023-01-13 | 1258.38 | 31.46 | 2023-01-01 | 3 | 413.15 | 1 | 1258.38 | 3 | SO46043 | 2023-01-08 | 100.67 | 1239.44 | 419.46 |
SO46043_4 | 1230-4EA4-83 | PO16791123625 | 100 | 281 | 332 | 36 | 2 | 2023-01-13 | 838.92 | 20.97 | 2023-01-01 | 2 | 413.15 | 1 | 838.92 | 4 | SO46043 | 2023-01-08 | 67.11 | 826.29 | 419.46 |
SO46043_5 | 1230-4EA4-83 | PO16791123625 | 100 | 281 | 264 | 36 | 2 | 2023-01-13 | 183.94 | 4.60 | 2023-01-01 | 1 | 181.49 | 1 | 183.94 | 5 | SO46043 | 2023-01-08 | 14.72 | 181.49 | 183.94 |
SO46043_6 | 1230-4EA4-83 | PO16791123625 | 100 | 281 | 235 | 36 | 2 | 2023-01-13 | 28.84 | 0.72 | 2023-01-01 | 1 | 31.72 | 1 | 28.84 | 6 | SO46043 | 2023-01-08 | 2.31 | 31.72 | 28.84 |
SO46043_7 | 1230-4EA4-83 | PO16791123625 | 100 | 281 | 319 | 36 | 2 | 2023-01-13 | 4373.97 | 109.35 | 2023-01-01 | 5 | 884.71 | 1 | 4373.97 | 7 | SO46043 | 2023-01-08 | 349.92 | 4423.54 | 874.79 |
SO46043_8 | 1230-4EA4-83 | PO16791123625 | 100 | 281 | 315 | 36 | 2 | 2023-01-13 | 1749.59 | 43.74 | 2023-01-01 | 2 | 884.71 | 1 | 1749.59 | 8 | SO46043 | 2023-01-08 | 139.97 | 1769.42 | 874.79 |
SO46043_9 | 1230-4EA4-83 | PO16791123625 | 100 | 281 | 270 | 36 | 2 | 2023-01-13 | 183.94 | 4.60 | 2023-01-01 | 1 | 181.49 | 1 | 183.94 | 9 | SO46043 | 2023-01-08 | 14.72 | 181.49 | 183.94 |
SO46043_10 | 1230-4EA4-83 | PO16791123625 | 100 | 281 | 330 | 36 | 2 | 2023-01-13 | 419.46 | 10.49 | 2023-01-01 | 1 | 413.15 | 1 | 419.46 | 10 | SO46043 | 2023-01-08 | 33.56 | 413.15 | 419.46 |
SO46043_11 | 1230-4EA4-83 | PO16791123625 | 100 | 281 | 253 | 36 | 2 | 2023-01-13 | 178.58 | 4.46 | 2023-01-01 | 1 | 176.20 | 1 | 178.58 | 11 | SO46043 | 2023-01-08 | 14.29 | 176.20 | 178.58 |
SO46043_12 | 1230-4EA4-83 | PO16791123625 | 100 | 281 | 342 | 36 | 2 | 2023-01-13 | 838.92 | 20.97 | 2023-01-01 | 2 | 413.15 | 1 | 838.92 | 12 | SO46043 | 2023-01-08 | 67.11 | 826.29 | 419.46 |
SO46043_13 | 1230-4EA4-83 | PO16791123625 | 100 | 281 | 324 | 36 | 2 | 2023-01-13 | 2936.21 | 73.41 | 2023-01-01 | 7 | 413.15 | 1 | 2936.21 | 13 | SO46043 | 2023-01-08 | 234.90 | 2892.02 | 419.46 |
SO46043_14 | 1230-4EA4-83 | PO16791123625 | 100 | 281 | 285 | 36 | 2 | 2023-01-13 | 357.16 | 8.93 | 2023-01-01 | 2 | 176.20 | 1 | 357.16 | 14 | SO46043 | 2023-01-08 | 28.57 | 352.40 | 178.58 |
SO46043_15 | 1230-4EA4-83 | PO16791123625 | 100 | 281 | 314 | 36 | 2 | 2023-01-13 | 2146.96 | 53.67 | 2023-01-01 | 1 | 2171.29 | 1 | 2146.96 | 15 | SO46043 | 2023-01-08 | 171.76 | 2171.29 | 2146.96 |
SO46043_16 | 1230-4EA4-83 | PO16791123625 | 100 | 281 | 334 | 36 | 2 | 2023-01-13 | 1677.84 | 41.95 | 2023-01-01 | 4 | 413.15 | 1 | 1677.84 | 16 | SO46043 | 2023-01-08 | 134.23 | 1652.59 | 419.46 |
SO46043_17 | 1230-4EA4-83 | PO16791123625 | 100 | 281 | 338 | 36 | 2 | 2023-01-13 | 419.46 | 10.49 | 2023-01-01 | 1 | 413.15 | 1 | 419.46 | 17 | SO46043 | 2023-01-08 | 33.56 | 413.15 | 419.46 |
SO46054_1 | 425B-4504-93 | PO14326187575 | 100 | 281 | 332 | 107 | 2 | 2023-01-13 | 1258.38 | 31.46 | 2023-01-01 | 3 | 413.15 | 1 | 1258.38 | 1 | SO46054 | 2023-01-08 | 100.67 | 1239.44 | 419.46 |
SO46054_2 | 425B-4504-93 | PO14326187575 | 100 | 281 | 322 | 107 | 2 | 2023-01-13 | 1258.38 | 31.46 | 2023-01-01 | 3 | 413.15 | 1 | 1258.38 | 2 | SO46054 | 2023-01-08 | 100.67 | 1239.44 | 419.46 |
SO46054_3 | 425B-4504-93 | PO14326187575 | 100 | 281 | 326 | 107 | 2 | 2023-01-13 | 419.46 | 10.49 | 2023-01-01 | 1 | 413.15 | 1 | 419.46 | 3 | SO46054 | 2023-01-08 | 33.56 | 413.15 | 419.46 |
SO46054_4 | 425B-4504-93 | PO14326187575 | 100 | 281 | 319 | 107 | 2 | 2023-01-13 | 874.79 | 21.87 | 2023-01-01 | 1 | 884.71 | 1 | 874.79 | 4 | SO46054 | 2023-01-08 | 69.98 | 884.71 | 874.79 |
SO46054_5 | 425B-4504-93 | PO14326187575 | 100 | 281 | 324 | 107 | 2 | 2023-01-13 | 1258.38 | 31.46 | 2023-01-01 | 3 | 413.15 | 1 | 1258.38 | 5 | SO46054 | 2023-01-08 | 100.67 | 1239.44 | 419.46 |
SO46054_6 | 425B-4504-93 | PO14326187575 | 100 | 281 | 342 | 107 | 2 | 2023-01-13 | 419.46 | 10.49 | 2023-01-01 | 1 | 413.15 | 1 | 419.46 | 6 | SO46054 | 2023-01-08 | 33.56 | 413.15 | 419.46 |
SO46054_7 | 425B-4504-93 | PO14326187575 | 100 | 281 | 328 | 107 | 2 | 2023-01-13 | 419.46 | 10.49 | 2023-01-01 | 1 | 413.15 | 1 | 419.46 | 7 | SO46054 | 2023-01-08 | 33.56 | 413.15 | 419.46 |
SO46054_8 | 425B-4504-93 | PO14326187575 | 100 | 281 | 315 | 107 | 2 | 2023-01-13 | 2624.38 | 65.61 | 2023-01-01 | 3 | 884.71 | 1 | 2624.38 | 8 | SO46054 | 2023-01-08 | 209.95 | 2654.12 | 874.79 |
SO46054_9 | 425B-4504-93 | PO14326187575 | 100 | 281 | 223 | 107 | 2 | 2023-01-13 | 10.37 | 0.26 | 2023-01-01 | 2 | 5.71 | 1 | 10.37 | 9 | SO46054 | 2023-01-08 | 0.83 | 11.41 | 5.19 |
SO46059_1 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 312 | 270 | 2 | 2023-01-13 | 4293.92 | 107.35 | 2023-01-01 | 2 | 2171.29 | 1 | 4293.92 | 1 | SO46059 | 2023-01-08 | 343.51 | 4342.59 | 2146.96 |
SO46059_2 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 310 | 270 | 2 | 2023-01-13 | 2146.96 | 53.67 | 2023-01-01 | 1 | 2171.29 | 1 | 2146.96 | 2 | SO46059 | 2023-01-08 | 171.76 | 2171.29 | 2146.96 |
SO46059_3 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 336 | 270 | 2 | 2023-01-13 | 838.92 | 20.97 | 2023-01-01 | 2 | 413.15 | 1 | 838.92 | 3 | SO46059 | 2023-01-08 | 67.11 | 826.29 | 419.46 |
SO46059_4 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 330 | 270 | 2 | 2023-01-13 | 419.46 | 10.49 | 2023-01-01 | 1 | 413.15 | 1 | 419.46 | 4 | SO46059 | 2023-01-08 | 33.56 | 413.15 | 419.46 |
SO46059_5 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 340 | 270 | 2 | 2023-01-13 | 419.46 | 10.49 | 2023-01-01 | 1 | 413.15 | 1 | 419.46 | 5 | SO46059 | 2023-01-08 | 33.56 | 413.15 | 419.46 |
SO46059_6 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 264 | 270 | 2 | 2023-01-13 | 183.94 | 4.60 | 2023-01-01 | 1 | 181.49 | 1 | 183.94 | 6 | SO46059 | 2023-01-08 | 14.72 | 181.49 | 183.94 |
SO46059_7 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 338 | 270 | 2 | 2023-01-13 | 419.46 | 10.49 | 2023-01-01 | 1 | 413.15 | 1 | 419.46 | 7 | SO46059 | 2023-01-08 | 33.56 | 413.15 | 419.46 |
SO46059_8 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 318 | 270 | 2 | 2023-01-13 | 2624.38 | 65.61 | 2023-01-01 | 3 | 884.71 | 1 | 2624.38 | 8 | SO46059 | 2023-01-08 | 209.95 | 2654.12 | 874.79 |
SO46059_9 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 262 | 270 | 2 | 2023-01-13 | 183.94 | 4.60 | 2023-01-01 | 1 | 181.49 | 1 | 183.94 | 9 | SO46059 | 2023-01-08 | 14.72 | 181.49 | 183.94 |
SO46059_10 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 311 | 270 | 2 | 2023-01-13 | 4293.92 | 107.35 | 2023-01-01 | 2 | 2171.29 | 1 | 4293.92 | 10 | SO46059 | 2023-01-08 | 343.51 | 4342.59 | 2146.96 |
SO46059_11 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 328 | 270 | 2 | 2023-01-13 | 419.46 | 10.49 | 2023-01-01 | 1 | 413.15 | 1 | 419.46 | 11 | SO46059 | 2023-01-08 | 33.56 | 413.15 | 419.46 |
SO46059_12 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 315 | 270 | 2 | 2023-01-13 | 2624.38 | 65.61 | 2023-01-01 | 3 | 884.71 | 1 | 2624.38 | 12 | SO46059 | 2023-01-08 | 209.95 | 2654.12 | 874.79 |
SO46059_13 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 326 | 270 | 2 | 2023-01-13 | 419.46 | 10.49 | 2023-01-01 | 1 | 413.15 | 1 | 419.46 | 13 | SO46059 | 2023-01-08 | 33.56 | 413.15 | 419.46 |
SO46059_14 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 285 | 270 | 2 | 2023-01-13 | 178.58 | 4.46 | 2023-01-01 | 1 | 176.20 | 1 | 178.58 | 14 | SO46059 | 2023-01-08 | 14.29 | 176.20 | 178.58 |
SO46059_15 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 270 | 270 | 2 | 2023-01-13 | 183.94 | 4.60 | 2023-01-01 | 1 | 181.49 | 1 | 183.94 | 15 | SO46059 | 2023-01-08 | 14.72 | 181.49 | 183.94 |
SO46059_16 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 322 | 270 | 2 | 2023-01-13 | 1258.38 | 31.46 | 2023-01-01 | 3 | 413.15 | 1 | 1258.38 | 16 | SO46059 | 2023-01-08 | 100.67 | 1239.44 | 419.46 |
SO46059_17 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 324 | 270 | 2 | 2023-01-13 | 419.46 | 10.49 | 2023-01-01 | 1 | 413.15 | 1 | 419.46 | 17 | SO46059 | 2023-01-08 | 33.56 | 413.15 | 419.46 |
SO46059_18 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 313 | 270 | 2 | 2023-01-13 | 6440.89 | 161.02 | 2023-01-01 | 3 | 2171.29 | 1 | 6440.89 | 18 | SO46059 | 2023-01-08 | 515.27 | 6513.88 | 2146.96 |
SO46059_19 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 332 | 270 | 2 | 2023-01-13 | 1677.84 | 41.95 | 2023-01-01 | 4 | 413.15 | 1 | 1677.84 | 19 | SO46059 | 2023-01-08 | 134.23 | 1652.59 | 419.46 |
SO46061_1 | 2B65-4F76-8A | PO11716117697 | 100 | 281 | 351 | 144 | 2 | 2023-01-13 | 2024.99 | 50.62 | 2023-01-01 | 1 | 1898.09 | 1 | 2024.99 | 1 | SO46061 | 2023-01-08 | 162.00 | 1898.09 | 2024.99 |
SO46061_2 | 2B65-4F76-8A | PO11716117697 | 100 | 281 | 345 | 144 | 2 | 2023-01-13 | 2039.99 | 51.00 | 2023-01-01 | 1 | 1912.15 | 1 | 2039.99 | 2 | SO46061 | 2023-01-08 | 163.20 | 1912.15 | 2039.99 |
SO49068_6 | 8B30-4893-8C | PO1769149811 | 100 | 283 | 333 | 540 | 2 | 2023-10-16 | 2348.97 | 58.72 | 2023-10-04 | 5 | 486.71 | 1 | 2348.97 | 6 | SO49068 | 2023-10-11 | 187.92 | 2433.53 | 469.79 |
SO49084_1 | 438B-42C5-B0 | PO18183187957 | 100 | 283 | 428 | 667 | 2 | 2023-10-16 | 418.51 | 10.46 | 2023-10-04 | 2 | 185.82 | 1 | 418.51 | 1 | SO49084 | 2023-10-11 | 33.48 | 371.64 | 209.26 |
SO49084_2 | 438B-42C5-B0 | PO18183187957 | 100 | 283 | 364 | 667 | 2 | 2023-10-16 | 1943.98 | 48.60 | 2023-10-04 | 3 | 598.44 | 1 | 1943.98 | 2 | SO49084 | 2023-10-11 | 155.52 | 1795.31 | 647.99 |
SO49084_3 | 438B-42C5-B0 | PO18183187957 | 100 | 283 | 469 | 667 | 2 | 2023-10-16 | 136.76 | 3.42 | 2023-10-04 | 6 | 15.67 | 1 | 136.76 | 3 | SO49084 | 2023-10-11 | 10.94 | 94.03 | 22.79 |
SO49084_4 | 438B-42C5-B0 | PO18183187957 | 100 | 283 | 420 | 667 | 2 | 2023-10-16 | 424.85 | 10.62 | 2023-10-04 | 3 | 104.80 | 1 | 424.85 | 4 | SO49084 | 2023-10-11 | 33.99 | 314.39 | 141.62 |
SO49084_5 | 438B-42C5-B0 | PO18183187957 | 100 | 283 | 421 | 667 | 2 | 2023-10-16 | 588.99 | 14.72 | 2023-10-04 | 3 | 145.28 | 1 | 588.99 | 5 | SO49084 | 2023-10-11 | 47.12 | 435.85 | 196.33 |
SO49084_6 | 438B-42C5-B0 | PO18183187957 | 100 | 283 | 360 | 667 | 2 | 2023-10-16 | 3688.38 | 92.21 | 2023-10-04 | 3 | 1105.81 | 1 | 3688.38 | 6 | SO49084 | 2023-10-11 | 295.07 | 3317.43 | 1229.46 |
SO49084_7 | 438B-42C5-B0 | PO18183187957 | 100 | 283 | 470 | 667 | 2 | 2023-10-16 | 113.97 | 2.85 | 2023-10-04 | 5 | 15.67 | 1 | 113.97 | 7 | SO49084 | 2023-10-11 | 9.12 | 78.35 | 22.79 |
SO49084_8 | 438B-42C5-B0 | PO18183187957 | 100 | 283 | 352 | 667 | 2 | 2023-10-16 | 4971.41 | 124.29 | 2023-10-04 | 4 | 1117.86 | 1 | 4971.41 | 8 | SO49084 | 2023-10-11 | 397.71 | 4471.42 | 1242.85 |
SO49084_9 | 438B-42C5-B0 | PO18183187957 | 100 | 283 | 356 | 667 | 2 | 2023-10-16 | 4971.41 | 124.29 | 2023-10-04 | 4 | 1117.86 | 1 | 4971.41 | 9 | SO49084 | 2023-10-11 | 397.71 | 4471.42 | 1242.85 |
SO49084_10 | 438B-42C5-B0 | PO18183187957 | 100 | 283 | 354 | 667 | 2 | 2023-10-16 | 7457.11 | 186.43 | 2023-10-04 | 6 | 1117.86 | 1 | 7457.11 | 10 | SO49084 | 2023-10-11 | 596.57 | 6707.14 | 1242.85 |
SO49108_1 | 9FF7-43C4-B6 | PO14326188033 | 100 | 283 | 333 | 107 | 2 | 2023-10-16 | 469.79 | 11.74 | 2023-10-04 | 1 | 486.71 | 1 | 469.79 | 1 | SO49108 | 2023-10-11 | 37.58 | 486.71 | 469.79 |
SO49108_2 | 9FF7-43C4-B6 | PO14326188033 | 100 | 283 | 325 | 107 | 2 | 2023-10-16 | 469.79 | 11.74 | 2023-10-04 | 1 | 486.71 | 1 | 469.79 | 2 | SO49108 | 2023-10-11 | 37.58 | 486.71 | 469.79 |
Generated 2025-04-03 01:57:15.741 UTC