[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 2790 > < TAKE 28 >
28 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO61184_44 | F33C-4C57-BD | PO16298116527 | 100 | 287 | 214 | 599 | 4 | 2024-04-28 | 83.98 | 2.10 | 2024-04-16 | 4 | 13.09 | 1 | 83.98 | 44 | SO61184 | 2024-04-23 | 6.72 | 52.35 | 20.99 | |||
SO45060_11 | 39B0-42BB-92 | PO10817172372 | 100 | 287 | 336 | 203 | 4 | 2022-04-29 | 419.46 | 10.49 | 2022-04-17 | 1 | 413.15 | 1 | 419.46 | 11 | SO45060 | 2022-04-24 | 33.56 | 413.15 | 419.46 | |||
SO48012_12 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 433 | 78 | 4 | 2023-02-27 | 1946.72 | 48.67 | 2023-02-15 | 6 | 300.12 | 1 | 1946.72 | 12 | SO48012 | 2023-02-22 | 155.74 | 1800.71 | 324.45 | |||
SO51825_45 | E395-4F72-84 | PO6525184188 | 100 | 281 | 511 | 345 | 4 | 2023-11-27 | 873.82 | 21.85 | 2023-11-15 | 4 | 199.38 | 1 | 873.82 | 45 | SO51825 | 2023-11-22 | 69.91 | 797.50 | 218.45 | |||
SO61188_1 | 0CFA-4338-90 | PO12528143455 | 100 | 282 | 560 | 331 | 4 | 2024-04-28 | 2186.73 | 54.67 | 2024-04-16 | 3 | 755.15 | 1 | 2186.73 | 1 | SO61188 | 2024-04-23 | 174.94 | 2265.45 | 728.91 | |||
SO45060_12 | 39B0-42BB-92 | PO10817172372 | 100 | 287 | 312 | 203 | 4 | 2022-04-29 | 4293.92 | 107.35 | 2022-04-17 | 2 | 2171.29 | 1 | 4293.92 | 12 | SO45060 | 2022-04-24 | 343.51 | 4342.59 | 2146.96 | |||
SO48012_13 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 461 | 78 | 4 | 2023-02-27 | 161.98 | 4.05 | 2023-02-15 | 3 | 37.12 | 1 | 161.98 | 13 | SO48012 | 2023-02-22 | 12.96 | 111.36 | 53.99 | |||
SO51825_46 | E395-4F72-84 | PO6525184188 | 100 | 281 | 513 | 345 | 4 | 2023-11-27 | 218.45 | 5.46 | 2023-11-15 | 1 | 199.38 | 1 | 218.45 | 46 | SO51825 | 2023-11-22 | 17.48 | 199.38 | 218.45 | |||
SO61188_2 | 0CFA-4338-90 | PO12528143455 | 100 | 282 | 565 | 331 | 4 | 2024-04-28 | 1781.64 | 44.54 | 2024-04-16 | 4 | 461.44 | 1 | 1781.64 | 2 | SO61188 | 2024-04-23 | 142.53 | 1845.78 | 445.41 | |||
SO45060_13 | 39B0-42BB-92 | PO10817172372 | 100 | 287 | 340 | 203 | 4 | 2022-04-29 | 838.92 | 20.97 | 2022-04-17 | 2 | 413.15 | 1 | 838.92 | 13 | SO45060 | 2022-04-24 | 67.11 | 826.29 | 419.46 | |||
SO48012_14 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 464 | 78 | 4 | 2023-02-27 | 70.64 | 1.77 | 2023-02-15 | 5 | 9.71 | 1 | 70.64 | 14 | SO48012 | 2023-02-22 | 5.65 | 48.57 | 14.13 | |||
SO51827_1 | B106-4221-AD | PO4611117026 | 100 | 287 | 585 | 13 | 131 | 4 | 100.22 | 2023-11-27 | 668.12 | 14.20 | 2023-11-15 | 2 | 461.44 | 1 | 567.90 | 1 | SO51827 | 2023-11-22 | 45.43 | 922.89 | 334.06 | 0.15 |
SO61188_3 | 0CFA-4338-90 | PO12528143455 | 100 | 282 | 586 | 331 | 4 | 2024-04-28 | 1336.23 | 33.41 | 2024-04-16 | 3 | 461.44 | 1 | 1336.23 | 3 | SO61188 | 2024-04-23 | 106.90 | 1384.33 | 445.41 | |||
SO45060_14 | 39B0-42BB-92 | PO10817172372 | 100 | 287 | 330 | 203 | 4 | 2022-04-29 | 838.92 | 20.97 | 2022-04-17 | 2 | 413.15 | 1 | 838.92 | 14 | SO45060 | 2022-04-24 | 67.11 | 826.29 | 419.46 | |||
SO48012_15 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 377 | 78 | 4 | 2023-02-27 | 5235.75 | 130.89 | 2023-02-15 | 4 | 1320.68 | 1 | 5235.75 | 15 | SO48012 | 2023-02-22 | 418.86 | 5282.74 | 1308.94 | |||
SO51827_2 | B106-4221-AD | PO4611117026 | 100 | 287 | 576 | 131 | 4 | 2023-11-27 | 2860.88 | 71.52 | 2023-11-15 | 2 | 1481.94 | 1 | 2860.88 | 2 | SO51827 | 2023-11-22 | 228.87 | 2963.88 | 1430.44 | |||
SO61188_4 | 0CFA-4338-90 | PO12528143455 | 100 | 282 | 564 | 331 | 4 | 2024-04-28 | 2860.88 | 71.52 | 2024-04-16 | 2 | 1481.94 | 1 | 2860.88 | 4 | SO61188 | 2024-04-23 | 228.87 | 2963.88 | 1430.44 | |||
SO45060_15 | 39B0-42BB-92 | PO10817172372 | 100 | 287 | 324 | 203 | 4 | 2022-04-29 | 838.92 | 20.97 | 2022-04-17 | 2 | 413.15 | 1 | 838.92 | 15 | SO45060 | 2022-04-24 | 67.11 | 826.29 | 419.46 | |||
SO48012_16 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 335 | 78 | 4 | 2023-02-27 | 939.59 | 23.49 | 2023-02-15 | 2 | 486.71 | 1 | 939.59 | 16 | SO48012 | 2023-02-22 | 75.17 | 973.41 | 469.79 | |||
SO51827_3 | B106-4221-AD | PO4611117026 | 100 | 287 | 564 | 14 | 131 | 4 | 762.90 | 2023-11-27 | 3814.51 | 76.29 | 2023-11-15 | 4 | 1481.94 | 1 | 3051.61 | 3 | SO51827 | 2023-11-22 | 244.13 | 5927.75 | 953.63 | 0.20 |
SO61188_5 | 0CFA-4338-90 | PO12528143455 | 100 | 282 | 575 | 331 | 4 | 2024-04-28 | 4291.33 | 107.28 | 2024-04-16 | 3 | 1481.94 | 1 | 4291.33 | 5 | SO61188 | 2024-04-23 | 343.31 | 4445.81 | 1430.44 | |||
SO45060_16 | 39B0-42BB-92 | PO10817172372 | 100 | 287 | 311 | 203 | 4 | 2022-04-29 | 4293.92 | 107.35 | 2022-04-17 | 2 | 2171.29 | 1 | 4293.92 | 16 | SO45060 | 2022-04-24 | 343.51 | 4342.59 | 2146.96 | |||
SO48012_17 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 265 | 78 | 4 | 2023-02-27 | 202.33 | 5.06 | 2023-02-15 | 1 | 187.16 | 1 | 202.33 | 17 | SO48012 | 2023-02-22 | 16.19 | 187.16 | 202.33 | |||
SO51827_4 | B106-4221-AD | PO4611117026 | 100 | 287 | 506 | 131 | 4 | 2023-11-27 | 400.10 | 10.00 | 2023-11-15 | 2 | 199.85 | 1 | 400.10 | 4 | SO51827 | 2023-11-22 | 32.01 | 399.70 | 200.05 | |||
SO61188_6 | 0CFA-4338-90 | PO12528143455 | 100 | 282 | 561 | 331 | 4 | 2024-04-28 | 4291.33 | 107.28 | 2024-04-16 | 3 | 1481.94 | 1 | 4291.33 | 6 | SO61188 | 2024-04-23 | 343.31 | 4445.81 | 1430.44 | |||
SO45060_17 | 39B0-42BB-92 | PO10817172372 | 100 | 287 | 319 | 203 | 4 | 2022-04-29 | 874.79 | 21.87 | 2022-04-17 | 1 | 884.71 | 1 | 874.79 | 17 | SO45060 | 2022-04-24 | 69.98 | 884.71 | 874.79 | |||
SO48012_18 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 224 | 78 | 4 | 2023-02-27 | 46.68 | 1.17 | 2023-02-15 | 9 | 5.23 | 1 | 46.68 | 18 | SO48012 | 2023-02-22 | 3.73 | 47.07 | 5.19 | |||
SO51827_5 | B106-4221-AD | PO4611117026 | 100 | 287 | 571 | 13 | 131 | 4 | 100.22 | 2023-11-27 | 668.12 | 14.20 | 2023-11-15 | 2 | 461.44 | 1 | 567.90 | 5 | SO51827 | 2023-11-22 | 45.43 | 922.89 | 334.06 | 0.15 |
Generated 2024-11-14 17:52:57.679 UTC