[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 2412 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO43906_6 | BA78-4228-89 | PO6438197212 | 100 | 283 | 229 | 309 | 4 | 2021-11-23 | 86.52 | 2.16 | 2021-11-11 | 3 | 31.72 | 1 | 86.52 | 6 | SO43906 | 2021-11-18 | 6.92 | 95.17 | 28.84 | |||
SO47685_19 | CC2F-4D47-8C | PO11484129630 | 100 | 281 | 447 | 594 | 2 | 2023-01-23 | 45.00 | 1.13 | 2023-01-11 | 3 | 10.31 | 1 | 45.00 | 19 | SO47685 | 2023-01-18 | 3.60 | 30.94 | 15.00 | |||
SO51122_12 | D915-4225-97 | PO551181465 | 100 | 281 | 545 | 4 | 4 | 2023-10-23 | 170.06 | 4.25 | 2023-10-11 | 7 | 17.98 | 1 | 170.06 | 12 | SO51122 | 2023-10-18 | 13.60 | 125.84 | 24.29 | |||
SO43906_7 | BA78-4228-89 | PO6438197212 | 100 | 283 | 223 | 309 | 4 | 2021-11-23 | 36.31 | 0.91 | 2021-11-11 | 7 | 5.71 | 1 | 36.31 | 7 | SO43906 | 2021-11-18 | 2.90 | 39.94 | 5.19 | |||
SO47685_20 | CC2F-4D47-8C | PO11484129630 | 100 | 281 | 358 | 594 | 2 | 2023-01-23 | 6147.29 | 153.68 | 2023-01-11 | 5 | 1105.81 | 1 | 6147.29 | 20 | SO47685 | 2023-01-18 | 491.78 | 5529.05 | 1229.46 | |||
SO51122_13 | D915-4225-97 | PO551181465 | 100 | 281 | 520 | 4 | 4 | 2023-10-23 | 31.58 | 0.79 | 2023-10-11 | 1 | 23.37 | 1 | 31.58 | 13 | SO51122 | 2023-10-18 | 2.53 | 23.37 | 31.58 | |||
SO43906_8 | BA78-4228-89 | PO6438197212 | 100 | 283 | 345 | 309 | 4 | 2021-11-23 | 2039.99 | 51.00 | 2021-11-11 | 1 | 1912.15 | 1 | 2039.99 | 8 | SO43906 | 2021-11-18 | 163.20 | 1912.15 | 2039.99 | |||
SO47685_21 | CC2F-4D47-8C | PO11484129630 | 100 | 281 | 456 | 594 | 2 | 2023-01-23 | 134.98 | 3.37 | 2023-01-11 | 3 | 30.93 | 1 | 134.98 | 21 | SO47685 | 2023-01-18 | 10.80 | 92.80 | 44.99 | |||
SO51122_14 | D915-4225-97 | PO551181465 | 100 | 281 | 434 | 4 | 4 | 2023-10-23 | 1784.49 | 44.61 | 2023-10-11 | 5 | 360.94 | 1 | 1784.49 | 14 | SO51122 | 2023-10-18 | 142.76 | 1804.71 | 356.90 | |||
SO43906_9 | BA78-4228-89 | PO6438197212 | 100 | 283 | 347 | 309 | 4 | 2021-11-23 | 6119.98 | 153.00 | 2021-11-11 | 3 | 1912.15 | 1 | 6119.98 | 9 | SO43906 | 2021-11-18 | 489.60 | 5736.46 | 2039.99 | |||
SO47685_22 | CC2F-4D47-8C | PO11484129630 | 100 | 281 | 224 | 594 | 2 | 2023-01-23 | 5.19 | 0.13 | 2023-01-11 | 1 | 5.23 | 1 | 5.19 | 22 | SO47685 | 2023-01-18 | 0.41 | 5.23 | 5.19 | |||
SO51122_15 | D915-4225-97 | PO551181465 | 100 | 281 | 240 | 4 | 4 | 2023-10-23 | 1717.80 | 42.95 | 2023-10-11 | 2 | 868.63 | 1 | 1717.80 | 15 | SO51122 | 2023-10-18 | 137.42 | 1737.27 | 858.90 | |||
SO43906_10 | BA78-4228-89 | PO6438197212 | 100 | 283 | 346 | 309 | 4 | 2021-11-23 | 2039.99 | 51.00 | 2021-11-11 | 1 | 1912.15 | 1 | 2039.99 | 10 | SO43906 | 2021-11-18 | 163.20 | 1912.15 | 2039.99 | |||
SO47685_23 | CC2F-4D47-8C | PO11484129630 | 100 | 281 | 464 | 594 | 2 | 2023-01-23 | 56.52 | 1.41 | 2023-01-11 | 4 | 9.71 | 1 | 56.52 | 23 | SO47685 | 2023-01-18 | 4.52 | 38.85 | 14.13 | |||
SO51122_16 | D915-4225-97 | PO551181465 | 100 | 281 | 482 | 3 | 4 | 4 | 4.94 | 2023-10-23 | 98.89 | 2.35 | 2023-10-11 | 20 | 3.36 | 1 | 93.95 | 16 | SO51122 | 2023-10-18 | 7.52 | 67.25 | 4.94 | 0.05 |
SO43906_11 | BA78-4228-89 | PO6438197212 | 100 | 283 | 349 | 309 | 4 | 2021-11-23 | 6074.98 | 151.87 | 2021-11-11 | 3 | 1898.09 | 1 | 6074.98 | 11 | SO43906 | 2021-11-18 | 486.00 | 5694.28 | 2024.99 | |||
SO47685_24 | CC2F-4D47-8C | PO11484129630 | 100 | 281 | 352 | 594 | 2 | 2023-01-23 | 8699.96 | 217.50 | 2023-01-11 | 7 | 1117.86 | 1 | 8699.96 | 24 | SO47685 | 2023-01-18 | 696.00 | 7824.99 | 1242.85 | |||
SO51122_17 | D915-4225-97 | PO551181465 | 100 | 281 | 547 | 4 | 4 | 2023-10-23 | 145.78 | 3.64 | 2023-10-11 | 3 | 35.96 | 1 | 145.78 | 17 | SO51122 | 2023-10-18 | 11.66 | 107.88 | 48.59 | |||
SO43906_12 | BA78-4228-89 | PO6438197212 | 100 | 283 | 215 | 309 | 4 | 2021-11-23 | 20.19 | 0.50 | 2021-11-11 | 1 | 12.03 | 1 | 20.19 | 12 | SO43906 | 2021-11-18 | 1.61 | 12.03 | 20.19 | |||
SO47685_25 | CC2F-4D47-8C | PO11484129630 | 100 | 281 | 458 | 594 | 2 | 2023-01-23 | 314.96 | 7.87 | 2023-01-11 | 7 | 30.93 | 1 | 314.96 | 25 | SO47685 | 2023-01-18 | 25.20 | 216.53 | 44.99 | |||
SO51122_18 | D915-4225-97 | PO551181465 | 100 | 281 | 243 | 4 | 4 | 2023-10-23 | 1717.80 | 42.95 | 2023-10-11 | 2 | 868.63 | 1 | 1717.80 | 18 | SO51122 | 2023-10-18 | 137.42 | 1737.27 | 858.90 | |||
SO43906_13 | BA78-4228-89 | PO6438197212 | 100 | 283 | 220 | 309 | 4 | 2021-11-23 | 40.37 | 1.01 | 2021-11-11 | 2 | 12.03 | 1 | 40.37 | 13 | SO43906 | 2021-11-18 | 3.23 | 24.06 | 20.19 | |||
SO47685_26 | CC2F-4D47-8C | PO11484129630 | 100 | 281 | 365 | 594 | 2 | 2023-01-23 | 1295.99 | 32.40 | 2023-01-11 | 2 | 598.44 | 1 | 1295.99 | 26 | SO47685 | 2023-01-18 | 103.68 | 1196.87 | 647.99 | |||
SO51122_19 | D915-4225-97 | PO551181465 | 100 | 281 | 483 | 4 | 4 | 2023-10-23 | 72.00 | 1.80 | 2023-10-11 | 1 | 44.88 | 1 | 72.00 | 19 | SO51122 | 2023-10-18 | 5.76 | 44.88 | 72.00 |
Generated 2024-11-10 21:08:00.861 UTC