[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > < SKIP 1368 > < TAKE 31 >
31 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44778_13 | 32B2-4FA6-81 | PO3190112662 | 100 | 281 | 326 | 575 | 2 | 2022-03-25 | 2516.75 | 62.92 | 2022-03-13 | 6 | 413.15 | 1 | 2516.75 | 13 | SO44778 | 2022-03-20 | 201.34 | 2478.88 | 419.46 | |||
SO51810_22 | 0D49-491D-BD | PO7453119597 | 100 | 283 | 384 | 108 | 2 | 2023-11-23 | 4033.76 | 100.84 | 2023-11-11 | 6 | 713.08 | 1 | 4033.76 | 22 | SO51810 | 2023-11-18 | 322.70 | 4278.48 | 672.29 | |||
SO44778_14 | 32B2-4FA6-81 | PO3190112662 | 100 | 281 | 315 | 575 | 2 | 2022-03-25 | 4373.97 | 109.35 | 2022-03-13 | 5 | 884.71 | 1 | 4373.97 | 14 | SO44778 | 2022-03-20 | 349.92 | 4423.54 | 874.79 | |||
SO51810_23 | 0D49-491D-BD | PO7453119597 | 100 | 283 | 390 | 108 | 2 | 2023-11-23 | 1344.59 | 33.61 | 2023-11-11 | 2 | 713.08 | 1 | 1344.59 | 23 | SO51810 | 2023-11-18 | 107.57 | 1426.16 | 672.29 | |||
SO44778_15 | 32B2-4FA6-81 | PO3190112662 | 100 | 281 | 272 | 575 | 2 | 2022-03-25 | 183.94 | 4.60 | 2022-03-13 | 1 | 181.49 | 1 | 183.94 | 15 | SO44778 | 2022-03-20 | 14.72 | 181.49 | 183.94 | |||
SO51810_24 | 0D49-491D-BD | PO7453119597 | 100 | 283 | 237 | 108 | 2 | 2023-11-23 | 209.96 | 5.25 | 2023-11-11 | 7 | 38.49 | 1 | 209.96 | 24 | SO51810 | 2023-11-18 | 16.80 | 269.45 | 29.99 | |||
SO44778_16 | 32B2-4FA6-81 | PO3190112662 | 100 | 281 | 276 | 575 | 2 | 2022-03-25 | 713.80 | 17.84 | 2022-03-13 | 2 | 352.14 | 1 | 713.80 | 16 | SO44778 | 2022-03-20 | 57.10 | 704.28 | 356.90 | |||
SO51810_25 | 0D49-491D-BD | PO7453119597 | 100 | 283 | 580 | 108 | 2 | 2023-11-23 | 8164.75 | 204.12 | 2023-11-11 | 8 | 1082.51 | 1 | 8164.75 | 25 | SO51810 | 2023-11-18 | 653.18 | 8660.08 | 1020.59 | |||
SO44778_17 | 32B2-4FA6-81 | PO3190112662 | 100 | 281 | 334 | 575 | 2 | 2022-03-25 | 419.46 | 10.49 | 2022-03-13 | 1 | 413.15 | 1 | 419.46 | 17 | SO44778 | 2022-03-20 | 33.56 | 413.15 | 419.46 | |||
SO51810_26 | 0D49-491D-BD | PO7453119597 | 100 | 283 | 434 | 108 | 2 | 2023-11-23 | 2141.39 | 53.53 | 2023-11-11 | 6 | 360.94 | 1 | 2141.39 | 26 | SO51810 | 2023-11-18 | 171.31 | 2165.66 | 356.90 | |||
SO44778_18 | 32B2-4FA6-81 | PO3190112662 | 100 | 281 | 319 | 575 | 2 | 2022-03-25 | 7873.15 | 196.83 | 2022-03-13 | 9 | 884.71 | 1 | 7873.15 | 18 | SO44778 | 2022-03-20 | 629.85 | 7962.37 | 874.79 | |||
SO51810_27 | 0D49-491D-BD | PO7453119597 | 100 | 283 | 472 | 108 | 2 | 2023-11-23 | 76.20 | 1.91 | 2023-11-11 | 2 | 23.75 | 1 | 76.20 | 27 | SO51810 | 2023-11-18 | 6.10 | 47.50 | 38.10 | |||
SO44778_19 | 32B2-4FA6-81 | PO3190112662 | 100 | 281 | 264 | 575 | 2 | 2022-03-25 | 367.88 | 9.20 | 2022-03-13 | 2 | 181.49 | 1 | 367.88 | 19 | SO44778 | 2022-03-20 | 29.43 | 362.97 | 183.94 | |||
SO51810_28 | 0D49-491D-BD | PO7453119597 | 100 | 283 | 287 | 108 | 2 | 2023-11-23 | 809.33 | 20.23 | 2023-11-11 | 4 | 204.63 | 1 | 809.33 | 28 | SO51810 | 2023-11-18 | 64.75 | 818.50 | 202.33 | |||
SO44778_20 | 32B2-4FA6-81 | PO3190112662 | 100 | 281 | 285 | 575 | 2 | 2022-03-25 | 357.16 | 8.93 | 2022-03-13 | 2 | 176.20 | 1 | 357.16 | 20 | SO44778 | 2022-03-20 | 28.57 | 352.40 | 178.58 | |||
SO51810_29 | 0D49-491D-BD | PO7453119597 | 100 | 283 | 374 | 108 | 2 | 2023-11-23 | 8796.06 | 219.90 | 2023-11-11 | 6 | 1554.95 | 1 | 8796.06 | 29 | SO51810 | 2023-11-18 | 703.68 | 9329.69 | 1466.01 | |||
SO44778_21 | 32B2-4FA6-81 | PO3190112662 | 100 | 281 | 328 | 575 | 2 | 2022-03-25 | 838.92 | 20.97 | 2022-03-13 | 2 | 413.15 | 1 | 838.92 | 21 | SO44778 | 2022-03-20 | 67.11 | 826.29 | 419.46 | |||
SO51810_30 | 0D49-491D-BD | PO7453119597 | 100 | 283 | 480 | 108 | 2 | 2023-11-23 | 5.50 | 0.14 | 2023-11-11 | 4 | 0.86 | 1 | 5.50 | 30 | SO51810 | 2023-11-18 | 0.44 | 3.43 | 1.37 | |||
SO44782_1 | 8A91-4DA7-97 | PO4408110571 | 100 | 281 | 334 | 143 | 2 | 2022-03-25 | 419.46 | 10.49 | 2022-03-13 | 1 | 413.15 | 1 | 419.46 | 1 | SO44782 | 2022-03-20 | 33.56 | 413.15 | 419.46 | |||
SO51810_31 | 0D49-491D-BD | PO7453119597 | 100 | 283 | 481 | 108 | 2 | 2023-11-23 | 5.39 | 0.13 | 2023-11-11 | 1 | 3.36 | 1 | 5.39 | 31 | SO51810 | 2023-11-18 | 0.43 | 3.36 | 5.39 | |||
SO44782_2 | 8A91-4DA7-97 | PO4408110571 | 100 | 281 | 338 | 143 | 2 | 2022-03-25 | 419.46 | 10.49 | 2022-03-13 | 1 | 413.15 | 1 | 419.46 | 2 | SO44782 | 2022-03-20 | 33.56 | 413.15 | 419.46 | |||
SO51810_32 | 0D49-491D-BD | PO7453119597 | 100 | 283 | 471 | 3 | 108 | 2 | 41.91 | 2023-11-23 | 838.20 | 19.91 | 2023-11-11 | 24 | 23.75 | 1 | 796.29 | 32 | SO51810 | 2023-11-18 | 63.70 | 569.98 | 34.93 | 0.05 |
SO44782_3 | 8A91-4DA7-97 | PO4408110571 | 100 | 281 | 330 | 143 | 2 | 2022-03-25 | 419.46 | 10.49 | 2022-03-13 | 1 | 413.15 | 1 | 419.46 | 3 | SO44782 | 2022-03-20 | 33.56 | 413.15 | 419.46 | |||
SO51810_33 | 0D49-491D-BD | PO7453119597 | 100 | 283 | 463 | 108 | 2 | 2023-11-23 | 88.16 | 2.20 | 2023-11-11 | 6 | 9.16 | 1 | 88.16 | 33 | SO51810 | 2023-11-18 | 7.05 | 54.96 | 14.69 | |||
SO44782_4 | 8A91-4DA7-97 | PO4408110571 | 100 | 281 | 313 | 143 | 2 | 2022-03-25 | 2146.96 | 53.67 | 2022-03-13 | 1 | 2171.29 | 1 | 2146.96 | 4 | SO44782 | 2022-03-20 | 171.76 | 2171.29 | 2146.96 | |||
SO51810_34 | 0D49-491D-BD | PO7453119597 | 100 | 283 | 222 | 108 | 2 | 2023-11-23 | 209.94 | 5.25 | 2023-11-11 | 10 | 13.09 | 1 | 209.94 | 34 | SO51810 | 2023-11-18 | 16.80 | 130.86 | 20.99 | |||
SO44782_5 | 8A91-4DA7-97 | PO4408110571 | 100 | 281 | 342 | 143 | 2 | 2022-03-25 | 1258.38 | 31.46 | 2022-03-13 | 3 | 413.15 | 1 | 1258.38 | 5 | SO44782 | 2022-03-20 | 100.67 | 1239.44 | 419.46 | |||
SO51810_35 | 0D49-491D-BD | PO7453119597 | 100 | 283 | 225 | 2 | 108 | 2 | 1.15 | 2023-11-23 | 57.36 | 1.41 | 2023-11-11 | 11 | 6.92 | 1 | 56.21 | 35 | SO51810 | 2023-11-18 | 4.50 | 76.15 | 5.21 | 0.02 |
SO44782_6 | 8A91-4DA7-97 | PO4408110571 | 100 | 281 | 314 | 143 | 2 | 2022-03-25 | 6440.89 | 161.02 | 2022-03-13 | 3 | 2171.29 | 1 | 6440.89 | 6 | SO44782 | 2022-03-20 | 515.27 | 6513.88 | 2146.96 | |||
SO51810_36 | 0D49-491D-BD | PO7453119597 | 100 | 283 | 606 | 108 | 2 | 2023-11-23 | 1943.96 | 48.60 | 2023-11-11 | 6 | 343.65 | 1 | 1943.96 | 36 | SO51810 | 2023-11-18 | 155.52 | 2061.90 | 323.99 | |||
SO44782_7 | 8A91-4DA7-97 | PO4408110571 | 100 | 281 | 264 | 143 | 2 | 2022-03-25 | 367.88 | 9.20 | 2022-03-13 | 2 | 181.49 | 1 | 367.88 | 7 | SO44782 | 2022-03-20 | 29.43 | 362.97 | 183.94 |
Generated 2024-11-10 20:04:37.017 UTC