[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '284' > < SKIP 563 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48036_17 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 265 | 66 | 6 | 2022-10-20 | 1011.66 | 25.29 | 2022-10-08 | 5 | 187.16 | 1 | 1011.66 | 17 | SO48036 | 2022-10-15 | 80.93 | 935.79 | 202.33 | |||
SO44547_21 | 801C-4288-87 | PO4901179982 | 19 | 284 | 322 | 84 | 6 | 2021-10-20 | 2097.29 | 52.43 | 2021-10-08 | 5 | 413.15 | 1 | 2097.29 | 21 | SO44547 | 2021-10-15 | 167.78 | 2065.73 | 419.46 | |||
SO48036_18 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 433 | 66 | 6 | 2022-10-20 | 324.45 | 8.11 | 2022-10-08 | 1 | 300.12 | 1 | 324.45 | 18 | SO48036 | 2022-10-15 | 25.96 | 300.12 | 324.45 | |||
SO44547_22 | 801C-4288-87 | PO4901179982 | 19 | 284 | 328 | 84 | 6 | 2021-10-20 | 838.92 | 20.97 | 2021-10-08 | 2 | 413.15 | 1 | 838.92 | 22 | SO44547 | 2021-10-15 | 67.11 | 826.29 | 419.46 | |||
SO48036_19 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 435 | 66 | 6 | 2022-10-20 | 973.36 | 24.33 | 2022-10-08 | 3 | 300.12 | 1 | 973.36 | 19 | SO48036 | 2022-10-15 | 77.87 | 900.36 | 324.45 | |||
SO44547_23 | 801C-4288-87 | PO4901179982 | 19 | 284 | 215 | 84 | 6 | 2021-10-20 | 181.68 | 4.54 | 2021-10-08 | 9 | 12.03 | 1 | 181.68 | 23 | SO44547 | 2021-10-15 | 14.53 | 108.25 | 20.19 | |||
SO48036_20 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 453 | 66 | 6 | 2022-10-20 | 143.98 | 3.60 | 2022-10-08 | 4 | 24.75 | 1 | 143.98 | 20 | SO48036 | 2022-10-15 | 11.52 | 98.98 | 35.99 | |||
SO44547_24 | 801C-4288-87 | PO4901179982 | 19 | 284 | 324 | 84 | 6 | 2021-10-20 | 2936.21 | 73.41 | 2021-10-08 | 7 | 413.15 | 1 | 2936.21 | 24 | SO44547 | 2021-10-15 | 234.90 | 2892.02 | 419.46 | |||
SO48036_21 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 456 | 66 | 6 | 2022-10-20 | 179.98 | 4.50 | 2022-10-08 | 4 | 30.93 | 1 | 179.98 | 21 | SO48036 | 2022-10-15 | 14.40 | 123.73 | 44.99 | |||
SO44547_25 | 801C-4288-87 | PO4901179982 | 19 | 284 | 276 | 84 | 6 | 2021-10-20 | 1070.69 | 26.77 | 2021-10-08 | 3 | 352.14 | 1 | 1070.69 | 25 | SO44547 | 2021-10-15 | 85.66 | 1056.42 | 356.90 | |||
SO48036_22 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 389 | 66 | 6 | 2022-10-20 | 600.26 | 15.01 | 2022-10-08 | 1 | 605.65 | 1 | 600.26 | 22 | SO48036 | 2022-10-15 | 48.02 | 605.65 | 600.26 | |||
SO44547_26 | 801C-4288-87 | PO4901179982 | 19 | 284 | 342 | 84 | 6 | 2021-10-20 | 2516.75 | 62.92 | 2021-10-08 | 6 | 413.15 | 1 | 2516.75 | 26 | SO44547 | 2021-10-15 | 201.34 | 2478.88 | 419.46 | |||
SO48036_23 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 459 | 66 | 6 | 2022-10-20 | 269.97 | 6.75 | 2022-10-08 | 5 | 37.12 | 1 | 269.97 | 23 | SO48036 | 2022-10-15 | 21.60 | 185.60 | 53.99 | |||
SO44547_27 | 801C-4288-87 | PO4901179982 | 19 | 284 | 272 | 84 | 6 | 2021-10-20 | 551.81 | 13.80 | 2021-10-08 | 3 | 181.49 | 1 | 551.81 | 27 | SO44547 | 2021-10-15 | 44.15 | 544.46 | 183.94 | |||
SO48036_24 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 343 | 66 | 6 | 2022-10-20 | 1409.38 | 35.23 | 2022-10-08 | 3 | 486.71 | 1 | 1409.38 | 24 | SO48036 | 2022-10-15 | 112.75 | 1460.12 | 469.79 | |||
SO44547_28 | 801C-4288-87 | PO4901179982 | 19 | 284 | 315 | 2 | 84 | 6 | 219.86 | 2021-10-20 | 10993.24 | 269.33 | 2021-10-08 | 13 | 884.71 | 1 | 10773.38 | 28 | SO44547 | 2021-10-15 | 861.87 | 11501.21 | 845.63 | 0.02 |
SO48036_25 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 335 | 66 | 6 | 2022-10-20 | 939.59 | 23.49 | 2022-10-08 | 2 | 486.71 | 1 | 939.59 | 25 | SO48036 | 2022-10-15 | 75.17 | 973.41 | 469.79 | |||
SO44547_29 | 801C-4288-87 | PO4901179982 | 19 | 284 | 223 | 84 | 6 | 2021-10-20 | 51.87 | 1.30 | 2021-10-08 | 10 | 5.71 | 1 | 51.87 | 29 | SO44547 | 2021-10-15 | 4.15 | 57.05 | 5.19 | |||
SO48036_26 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 373 | 66 | 6 | 2022-10-20 | 2617.88 | 65.45 | 2022-10-08 | 2 | 1320.68 | 1 | 2617.88 | 26 | SO48036 | 2022-10-15 | 209.43 | 2641.37 | 1308.94 | |||
SO44747_1 | 0914-46F6-9D | PO17719150324 | 19 | 284 | 324 | 631 | 6 | 2021-11-19 | 419.46 | 10.49 | 2021-11-07 | 1 | 413.15 | 1 | 419.46 | 1 | SO44747 | 2021-11-14 | 33.56 | 413.15 | 419.46 | |||
SO48036_27 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 417 | 66 | 6 | 2022-10-20 | 324.45 | 8.11 | 2022-10-08 | 1 | 300.12 | 1 | 324.45 | 27 | SO48036 | 2022-10-15 | 25.96 | 300.12 | 324.45 | |||
SO44747_2 | 0914-46F6-9D | PO17719150324 | 19 | 284 | 223 | 631 | 6 | 2021-11-19 | 10.37 | 0.26 | 2021-11-07 | 2 | 5.71 | 1 | 10.37 | 2 | SO44747 | 2021-11-14 | 0.83 | 11.41 | 5.19 | |||
SO48036_28 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 263 | 66 | 6 | 2022-10-20 | 404.66 | 10.12 | 2022-10-08 | 2 | 187.16 | 1 | 404.66 | 28 | SO48036 | 2022-10-15 | 32.37 | 374.31 | 202.33 | |||
SO44747_3 | 0914-46F6-9D | PO17719150324 | 19 | 284 | 319 | 631 | 6 | 2021-11-19 | 3499.18 | 87.48 | 2021-11-07 | 4 | 884.71 | 1 | 3499.18 | 3 | SO44747 | 2021-11-14 | 279.93 | 3538.83 | 874.79 | |||
SO48036_29 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 339 | 66 | 6 | 2022-10-20 | 469.79 | 11.74 | 2022-10-08 | 1 | 486.71 | 1 | 469.79 | 29 | SO48036 | 2022-10-15 | 37.58 | 486.71 | 469.79 | |||
SO44747_4 | 0914-46F6-9D | PO17719150324 | 19 | 284 | 342 | 631 | 6 | 2021-11-19 | 838.92 | 20.97 | 2021-11-07 | 2 | 413.15 | 1 | 838.92 | 4 | SO44747 | 2021-11-14 | 67.11 | 826.29 | 419.46 | |||
SO48036_30 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 329 | 2 | 66 | 6 | 118.07 | 2022-10-20 | 5903.74 | 144.64 | 2022-10-08 | 13 | 486.71 | 1 | 5785.67 | 30 | SO48036 | 2022-10-15 | 462.85 | 6327.19 | 454.13 | 0.02 |
SO44747_5 | 0914-46F6-9D | PO17719150324 | 19 | 284 | 326 | 631 | 6 | 2021-11-19 | 838.92 | 20.97 | 2021-11-07 | 2 | 413.15 | 1 | 838.92 | 5 | SO44747 | 2021-11-14 | 67.11 | 826.29 | 419.46 | |||
SO48036_31 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 233 | 66 | 6 | 2022-10-20 | 144.20 | 3.61 | 2022-10-08 | 5 | 29.08 | 1 | 144.20 | 31 | SO48036 | 2022-10-15 | 11.54 | 145.40 | 28.84 | |||
SO44747_6 | 0914-46F6-9D | PO17719150324 | 19 | 284 | 332 | 631 | 6 | 2021-11-19 | 838.92 | 20.97 | 2021-11-07 | 2 | 413.15 | 1 | 838.92 | 6 | SO44747 | 2021-11-14 | 67.11 | 826.29 | 419.46 | |||
SO48036_32 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 460 | 66 | 6 | 2022-10-20 | 161.98 | 4.05 | 2022-10-08 | 3 | 37.12 | 1 | 161.98 | 32 | SO48036 | 2022-10-15 | 12.96 | 111.36 | 53.99 | |||
SO44747_7 | 0914-46F6-9D | PO17719150324 | 19 | 284 | 322 | 631 | 6 | 2021-11-19 | 419.46 | 10.49 | 2021-11-07 | 1 | 413.15 | 1 | 419.46 | 7 | SO44747 | 2021-11-14 | 33.56 | 413.15 | 419.46 | |||
SO48036_33 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 381 | 66 | 6 | 2022-10-20 | 3001.31 | 75.03 | 2022-10-08 | 5 | 605.65 | 1 | 3001.31 | 33 | SO48036 | 2022-10-15 | 240.11 | 3028.25 | 600.26 | |||
SO44747_8 | 0914-46F6-9D | PO17719150324 | 19 | 284 | 232 | 631 | 6 | 2021-11-19 | 28.84 | 0.72 | 2021-11-07 | 1 | 31.72 | 1 | 28.84 | 8 | SO44747 | 2021-11-14 | 2.31 | 31.72 | 28.84 | |||
SO48036_34 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 383 | 66 | 6 | 2022-10-20 | 600.26 | 15.01 | 2022-10-08 | 1 | 605.65 | 1 | 600.26 | 34 | SO48036 | 2022-10-15 | 48.02 | 605.65 | 600.26 | |||
SO44747_9 | 0914-46F6-9D | PO17719150324 | 19 | 284 | 315 | 631 | 6 | 2021-11-19 | 3499.18 | 87.48 | 2021-11-07 | 4 | 884.71 | 1 | 3499.18 | 9 | SO44747 | 2021-11-14 | 279.93 | 3538.83 | 874.79 | |||
SO48036_35 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 457 | 66 | 6 | 2022-10-20 | 224.97 | 5.62 | 2022-10-08 | 5 | 30.93 | 1 | 224.97 | 35 | SO48036 | 2022-10-15 | 18.00 | 154.67 | 44.99 | |||
SO44765_1 | 54D5-4FF7-BB | PO11107155025 | 19 | 284 | 232 | 156 | 6 | 2021-11-19 | 86.52 | 2.16 | 2021-11-07 | 3 | 31.72 | 1 | 86.52 | 1 | SO44765 | 2021-11-14 | 6.92 | 95.17 | 28.84 | |||
SO48036_36 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 216 | 66 | 6 | 2022-10-20 | 141.31 | 3.53 | 2022-10-08 | 7 | 13.88 | 1 | 141.31 | 36 | SO48036 | 2022-10-15 | 11.30 | 97.15 | 20.19 | |||
SO44765_2 | 54D5-4FF7-BB | PO11107155025 | 19 | 284 | 332 | 156 | 6 | 2021-11-19 | 838.92 | 20.97 | 2021-11-07 | 2 | 413.15 | 1 | 838.92 | 2 | SO44765 | 2021-11-14 | 67.11 | 826.29 | 419.46 | |||
SO48036_37 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 331 | 66 | 6 | 2022-10-20 | 1409.38 | 35.23 | 2022-10-08 | 3 | 486.71 | 1 | 1409.38 | 37 | SO48036 | 2022-10-15 | 112.75 | 1460.12 | 469.79 | |||
SO44765_3 | 54D5-4FF7-BB | PO11107155025 | 19 | 284 | 328 | 156 | 6 | 2021-11-19 | 419.46 | 10.49 | 2021-11-07 | 1 | 413.15 | 1 | 419.46 | 3 | SO44765 | 2021-11-14 | 33.56 | 413.15 | 419.46 | |||
SO48036_38 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 462 | 66 | 6 | 2022-10-20 | 28.26 | 0.71 | 2022-10-08 | 2 | 9.71 | 1 | 28.26 | 38 | SO48036 | 2022-10-15 | 2.26 | 19.43 | 14.13 | |||
SO44765_4 | 54D5-4FF7-BB | PO11107155025 | 19 | 284 | 326 | 156 | 6 | 2021-11-19 | 419.46 | 10.49 | 2021-11-07 | 1 | 413.15 | 1 | 419.46 | 4 | SO44765 | 2021-11-14 | 33.56 | 413.15 | 419.46 | |||
SO48036_39 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 327 | 66 | 6 | 2022-10-20 | 939.59 | 23.49 | 2022-10-08 | 2 | 486.71 | 1 | 939.59 | 39 | SO48036 | 2022-10-15 | 75.17 | 973.41 | 469.79 | |||
SO44765_5 | 54D5-4FF7-BB | PO11107155025 | 19 | 284 | 322 | 156 | 6 | 2021-11-19 | 838.92 | 20.97 | 2021-11-07 | 2 | 413.15 | 1 | 838.92 | 5 | SO44765 | 2021-11-14 | 67.11 | 826.29 | 419.46 | |||
SO48036_40 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 368 | 66 | 6 | 2022-10-20 | 2932.02 | 73.30 | 2022-10-08 | 2 | 1518.79 | 1 | 2932.02 | 40 | SO48036 | 2022-10-15 | 234.56 | 3037.57 | 1466.01 | |||
SO44765_6 | 54D5-4FF7-BB | PO11107155025 | 19 | 284 | 262 | 156 | 6 | 2021-11-19 | 183.94 | 4.60 | 2021-11-07 | 1 | 181.49 | 1 | 183.94 | 6 | SO44765 | 2021-11-14 | 14.72 | 181.49 | 183.94 | |||
SO48036_41 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 422 | 66 | 6 | 2022-10-20 | 67.54 | 1.69 | 2022-10-08 | 1 | 49.98 | 1 | 67.54 | 41 | SO48036 | 2022-10-15 | 5.40 | 49.98 | 67.54 | |||
SO44765_7 | 54D5-4FF7-BB | PO11107155025 | 19 | 284 | 315 | 156 | 6 | 2021-11-19 | 874.79 | 21.87 | 2021-11-07 | 1 | 884.71 | 1 | 874.79 | 7 | SO44765 | 2021-11-14 | 69.98 | 884.71 | 874.79 | |||
SO48036_42 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 273 | 66 | 6 | 2022-10-20 | 202.33 | 5.06 | 2022-10-08 | 1 | 187.16 | 1 | 202.33 | 42 | SO48036 | 2022-10-15 | 16.19 | 187.16 | 202.33 | |||
SO44765_8 | 54D5-4FF7-BB | PO11107155025 | 19 | 284 | 319 | 156 | 6 | 2021-11-19 | 874.79 | 21.87 | 2021-11-07 | 1 | 884.71 | 1 | 874.79 | 8 | SO44765 | 2021-11-14 | 69.98 | 884.71 | 874.79 | |||
SO48038_1 | AF3A-47B6-B4 | PO2117194241 | 19 | 284 | 224 | 444 | 6 | 2022-10-20 | 5.19 | 0.13 | 2022-10-08 | 1 | 5.23 | 1 | 5.19 | 1 | SO48038 | 2022-10-15 | 0.41 | 5.23 | 5.19 | |||
SO44765_9 | 54D5-4FF7-BB | PO11107155025 | 19 | 284 | 324 | 156 | 6 | 2021-11-19 | 419.46 | 10.49 | 2021-11-07 | 1 | 413.15 | 1 | 419.46 | 9 | SO44765 | 2021-11-14 | 33.56 | 413.15 | 419.46 | |||
SO48038_2 | AF3A-47B6-B4 | PO2117194241 | 19 | 284 | 456 | 444 | 6 | 2022-10-20 | 134.98 | 3.37 | 2022-10-08 | 3 | 30.93 | 1 | 134.98 | 2 | SO48038 | 2022-10-15 | 10.80 | 92.80 | 44.99 | |||
SO44765_10 | 54D5-4FF7-BB | PO11107155025 | 19 | 284 | 342 | 156 | 6 | 2021-11-19 | 838.92 | 20.97 | 2021-11-07 | 2 | 413.15 | 1 | 838.92 | 10 | SO44765 | 2021-11-14 | 67.11 | 826.29 | 419.46 | |||
SO48038_3 | AF3A-47B6-B4 | PO2117194241 | 19 | 284 | 354 | 444 | 6 | 2022-10-20 | 1242.85 | 31.07 | 2022-10-08 | 1 | 1117.86 | 1 | 1242.85 | 3 | SO48038 | 2022-10-15 | 99.43 | 1117.86 | 1242.85 | |||
SO44765_11 | 54D5-4FF7-BB | PO11107155025 | 19 | 284 | 223 | 156 | 6 | 2021-11-19 | 25.93 | 0.65 | 2021-11-07 | 5 | 5.71 | 1 | 25.93 | 11 | SO44765 | 2021-11-14 | 2.07 | 28.53 | 5.19 | |||
SO48038_4 | AF3A-47B6-B4 | PO2117194241 | 19 | 284 | 470 | 3 | 444 | 6 | 15.67 | 2022-10-20 | 313.42 | 7.44 | 2022-10-08 | 15 | 15.67 | 1 | 297.75 | 4 | SO48038 | 2022-10-15 | 23.82 | 235.06 | 20.89 | 0.05 |
SO44766_1 | 81D1-4AD0-8F | PO10585113288 | 19 | 284 | 218 | 498 | 6 | 2021-11-19 | 17.10 | 0.43 | 2021-11-07 | 3 | 3.40 | 1 | 17.10 | 1 | SO44766 | 2021-11-14 | 1.37 | 10.19 | 5.70 | |||
SO48038_5 | AF3A-47B6-B4 | PO2117194241 | 19 | 284 | 458 | 444 | 6 | 2022-10-20 | 224.97 | 5.62 | 2022-10-08 | 5 | 30.93 | 1 | 224.97 | 5 | SO48038 | 2022-10-15 | 18.00 | 154.67 | 44.99 | |||
SO44766_2 | 81D1-4AD0-8F | PO10585113288 | 19 | 284 | 344 | 498 | 6 | 2021-11-19 | 2039.99 | 51.00 | 2021-11-07 | 1 | 1912.15 | 1 | 2039.99 | 2 | SO44766 | 2021-11-14 | 163.20 | 1912.15 | 2039.99 |
Generated 2024-07-07 11:43:34.809 UTC