[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 4652 > < TAKE 24 >
24 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44117_14 | 37DA-4DAE-BD | PO4408172413 | 100 | 281 | 334 | 143 | 2 | 2021-11-03 | 419.46 | 10.49 | 2021-10-22 | 1 | 413.15 | 1 | 419.46 | 14 | SO44117 | 2021-10-29 | 33.56 | 413.15 | 419.46 | |||
SO47962_20 | 3B2C-487D-99 | PO19923193438 | 100 | 281 | 305 | 18 | 3 | 2023-01-03 | 2944.58 | 73.61 | 2022-12-22 | 4 | 653.70 | 1 | 2944.58 | 20 | SO47962 | 2022-12-29 | 235.57 | 2614.79 | 736.15 | |||
SO51154_19 | 2A76-4451-99 | PO7859157852 | 100 | 287 | 390 | 221 | 4 | 2023-09-02 | 2016.88 | 50.42 | 2023-08-21 | 3 | 713.08 | 1 | 2016.88 | 19 | SO51154 | 2023-08-28 | 161.35 | 2139.24 | 672.29 | |||
SO44117_15 | 37DA-4DAE-BD | PO4408172413 | 100 | 281 | 262 | 143 | 2 | 2021-11-03 | 183.94 | 4.60 | 2021-10-22 | 1 | 181.49 | 1 | 183.94 | 15 | SO44117 | 2021-10-29 | 14.72 | 181.49 | 183.94 | |||
SO47962_21 | 3B2C-487D-99 | PO19923193438 | 100 | 281 | 356 | 18 | 3 | 2023-01-03 | 2485.70 | 62.14 | 2022-12-22 | 2 | 1117.86 | 1 | 2485.70 | 21 | SO47962 | 2022-12-29 | 198.86 | 2235.71 | 1242.85 | |||
SO51154_20 | 2A76-4451-99 | PO7859157852 | 100 | 287 | 384 | 221 | 4 | 2023-09-02 | 1344.59 | 33.61 | 2023-08-21 | 2 | 713.08 | 1 | 1344.59 | 20 | SO51154 | 2023-08-28 | 107.57 | 1426.16 | 672.29 | |||
SO44117_16 | 37DA-4DAE-BD | PO4408172413 | 100 | 281 | 328 | 143 | 2 | 2021-11-03 | 419.46 | 10.49 | 2021-10-22 | 1 | 413.15 | 1 | 419.46 | 16 | SO44117 | 2021-10-29 | 33.56 | 413.15 | 419.46 | |||
SO47962_22 | 3B2C-487D-99 | PO19923193438 | 100 | 281 | 421 | 18 | 3 | 2023-01-03 | 1177.97 | 29.45 | 2022-12-22 | 6 | 145.28 | 1 | 1177.97 | 22 | SO47962 | 2022-12-29 | 94.24 | 871.70 | 196.33 | |||
SO51154_21 | 2A76-4451-99 | PO7859157852 | 100 | 287 | 581 | 221 | 4 | 2023-09-02 | 5102.97 | 127.57 | 2023-08-21 | 5 | 1082.51 | 1 | 5102.97 | 21 | SO51154 | 2023-08-28 | 408.24 | 5412.55 | 1020.59 | |||
SO44118_1 | 3069-41E8-84 | PO4147180314 | 100 | 282 | 326 | 222 | 3 | 2021-11-03 | 419.46 | 10.49 | 2021-10-22 | 1 | 413.15 | 1 | 419.46 | 1 | SO44118 | 2021-10-29 | 33.56 | 413.15 | 419.46 | |||
SO47962_23 | 3B2C-487D-99 | PO19923193438 | 100 | 281 | 360 | 18 | 3 | 2023-01-03 | 3688.38 | 92.21 | 2022-12-22 | 3 | 1105.81 | 1 | 3688.38 | 23 | SO47962 | 2022-12-29 | 295.07 | 3317.43 | 1229.46 | |||
SO51154_22 | 2A76-4451-99 | PO7859157852 | 100 | 287 | 480 | 221 | 4 | 2023-09-02 | 8.24 | 0.21 | 2023-08-21 | 6 | 0.86 | 1 | 8.24 | 22 | SO51154 | 2023-08-28 | 0.66 | 5.14 | 1.37 | |||
SO44118_2 | 3069-41E8-84 | PO4147180314 | 100 | 282 | 324 | 222 | 3 | 2021-11-03 | 1258.38 | 31.46 | 2021-10-22 | 3 | 413.15 | 1 | 1258.38 | 2 | SO44118 | 2021-10-29 | 100.67 | 1239.44 | 419.46 | |||
SO47962_24 | 3B2C-487D-99 | PO19923193438 | 100 | 281 | 362 | 18 | 3 | 2023-01-03 | 1229.46 | 30.74 | 2022-12-22 | 1 | 1105.81 | 1 | 1229.46 | 24 | SO47962 | 2022-12-29 | 98.36 | 1105.81 | 1229.46 | |||
SO51154_23 | 2A76-4451-99 | PO7859157852 | 100 | 287 | 217 | 11 | 221 | 4 | 23.62 | 2023-09-02 | 157.46 | 3.35 | 2023-08-21 | 10 | 13.09 | 1 | 133.84 | 23 | SO51154 | 2023-08-28 | 10.71 | 130.86 | 15.75 | 0.15 |
SO44118_3 | 3069-41E8-84 | PO4147180314 | 100 | 282 | 319 | 222 | 3 | 2021-11-03 | 1749.59 | 43.74 | 2021-10-22 | 2 | 884.71 | 1 | 1749.59 | 3 | SO44118 | 2021-10-29 | 139.97 | 1769.42 | 874.79 | |||
SO47963_1 | 9A95-4541-91 | PO19691179567 | 19 | 291 | 469 | 353 | 6 | 2023-01-03 | 45.59 | 1.14 | 2022-12-22 | 2 | 15.67 | 1 | 45.59 | 1 | SO47963 | 2022-12-29 | 3.65 | 31.34 | 22.79 | |||
SO51154_24 | 2A76-4451-99 | PO7859157852 | 100 | 287 | 222 | 11 | 221 | 4 | 23.62 | 2023-09-02 | 157.46 | 3.35 | 2023-08-21 | 10 | 13.09 | 1 | 133.84 | 24 | SO51154 | 2023-08-28 | 10.71 | 130.86 | 15.75 | 0.15 |
SO44119_1 | 6300-4202-8C | PO4640166555 | 100 | 287 | 218 | 648 | 4 | 2021-11-03 | 34.20 | 0.86 | 2021-10-22 | 6 | 3.40 | 1 | 34.20 | 1 | SO44119 | 2021-10-29 | 2.74 | 20.38 | 5.70 | |||
SO47963_2 | 9A95-4541-91 | PO19691179567 | 19 | 291 | 360 | 353 | 6 | 2023-01-03 | 2458.92 | 61.47 | 2022-12-22 | 2 | 1105.81 | 1 | 2458.92 | 2 | SO47963 | 2022-12-29 | 196.71 | 2211.62 | 1229.46 | |||
SO51154_25 | 2A76-4451-99 | PO7859157852 | 100 | 287 | 463 | 2 | 221 | 4 | 3.12 | 2023-09-02 | 156.25 | 3.83 | 2023-08-21 | 11 | 9.16 | 1 | 153.12 | 25 | SO51154 | 2023-08-28 | 12.25 | 100.75 | 14.20 | 0.02 |
SO44119_2 | 6300-4202-8C | PO4640166555 | 100 | 287 | 220 | 648 | 4 | 2021-11-03 | 60.56 | 1.51 | 2021-10-22 | 3 | 12.03 | 1 | 60.56 | 2 | SO44119 | 2021-10-29 | 4.84 | 36.08 | 20.19 | |||
SO47963_3 | 9A95-4541-91 | PO19691179567 | 19 | 291 | 358 | 353 | 6 | 2023-01-03 | 2458.92 | 61.47 | 2022-12-22 | 2 | 1105.81 | 1 | 2458.92 | 3 | SO47963 | 2022-12-29 | 196.71 | 2211.62 | 1229.46 | |||
SO51154_26 | 2A76-4451-99 | PO7859157852 | 100 | 287 | 491 | 3 | 221 | 4 | 28.21 | 2023-09-02 | 564.20 | 13.40 | 2023-08-21 | 19 | 41.57 | 1 | 535.99 | 26 | SO51154 | 2023-08-28 | 42.88 | 789.87 | 29.69 | 0.05 |
Generated 2024-09-21 00:43:51.911 UTC