[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '10' > SHUFFLE SKIP 2000 SKIP 500 < SKIP 1000 > < TAKE 1000
20 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO57018_2 | 0B70-430B-BC | PO19053173016 | 98 | 288 | 554 | 178 | 10 | 2024-02-22 | 54.94 | 1.37 | 2024-02-10 | 1 | 40.66 | 1 | 54.94 | 2 | SO57018 | 2024-02-17 | 4.40 | 40.66 | 54.94 | |||
SO71938_13 | 7D23-4E70-B4 | PO8468183315 | 98 | 288 | 583 | 16 | 10 | 2024-09-22 | 5102.97 | 127.57 | 2024-09-10 | 5 | 1082.51 | 1 | 5102.97 | 13 | SO71938 | 2024-09-17 | 408.24 | 5412.55 | 1020.59 | |||
SO71936_25 | 95F1-4758-A0 | PO8671170385 | 98 | 288 | 556 | 502 | 10 | 2024-09-22 | 315.88 | 7.90 | 2024-09-10 | 3 | 77.92 | 1 | 315.88 | 25 | SO71936 | 2024-09-17 | 25.27 | 233.75 | 105.29 | |||
SO57180_4 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 562 | 520 | 10 | 2024-02-22 | 2860.88 | 71.52 | 2024-02-10 | 2 | 1481.94 | 1 | 2860.88 | 4 | SO57180 | 2024-02-17 | 228.87 | 2963.88 | 1430.44 | |||
SO53458_49 | 0728-4E88-9F | PO19285149036 | 98 | 288 | 490 | 3 | 448 | 10 | 23.76 | 2023-12-23 | 475.11 | 11.28 | 2023-12-11 | 16 | 41.57 | 1 | 451.36 | 49 | SO53458 | 2023-12-18 | 36.11 | 665.16 | 29.69 | 0.05 |
SO48386_30 | 7AB1-4817-8F | PO8468170337 | 98 | 288 | 456 | 16 | 10 | 2023-03-24 | 224.97 | 5.62 | 2023-03-12 | 5 | 30.93 | 1 | 224.97 | 30 | SO48386 | 2023-03-19 | 18.00 | 154.67 | 44.99 | |||
SO53458_33 | 0728-4E88-9F | PO19285149036 | 98 | 288 | 491 | 2 | 448 | 10 | 8.14 | 2023-12-23 | 407.08 | 9.97 | 2023-12-11 | 13 | 41.57 | 1 | 398.94 | 33 | SO53458 | 2023-12-18 | 31.92 | 540.44 | 31.31 | 0.02 |
SO48031_5 | 9EAA-4023-94 | PO957142471 | 98 | 288 | 230 | 376 | 10 | 2023-02-22 | 144.20 | 3.61 | 2023-02-10 | 5 | 29.08 | 1 | 144.20 | 5 | SO48031 | 2023-02-17 | 11.54 | 145.40 | 28.84 | |||
SO47009_6 | 8F7C-4372-A2 | PO1508115971 | 98 | 288 | 323 | 430 | 10 | 2022-11-22 | 469.79 | 11.74 | 2022-11-10 | 1 | 486.71 | 1 | 469.79 | 6 | SO47009 | 2022-11-17 | 37.58 | 486.71 | 469.79 | |||
SO47006_23 | 142D-4F23-BF | PO957186440 | 98 | 288 | 216 | 376 | 10 | 2022-11-22 | 60.56 | 1.51 | 2022-11-10 | 3 | 13.88 | 1 | 60.56 | 23 | SO47006 | 2022-11-17 | 4.84 | 41.63 | 20.19 | |||
SO53577_31 | A44D-449C-80 | PO5713160840 | 98 | 288 | 601 | 52 | 10 | 2023-12-23 | 129.58 | 3.24 | 2023-12-11 | 4 | 23.97 | 1 | 129.58 | 31 | SO53577 | 2023-12-18 | 10.37 | 95.89 | 32.39 | |||
SO58959_23 | 1330-4B17-AF | PO10353115061 | 98 | 288 | 353 | 88 | 10 | 2024-03-23 | 2783.99 | 69.60 | 2024-03-11 | 2 | 1265.62 | 1 | 2783.99 | 23 | SO58959 | 2024-03-18 | 222.72 | 2531.24 | 1391.99 | |||
SO48084_9 | 6C3E-4F2C-A4 | PO8584164060 | 98 | 290 | 323 | 592 | 10 | 2023-02-22 | 1879.18 | 46.98 | 2023-02-10 | 4 | 486.71 | 1 | 1879.18 | 9 | SO48084 | 2023-02-17 | 150.33 | 1946.83 | 469.79 | |||
SO51771_31 | F78B-4D68-8E | PO1508157846 | 98 | 288 | 287 | 430 | 10 | 2023-11-22 | 404.66 | 10.12 | 2023-11-10 | 2 | 204.63 | 1 | 404.66 | 31 | SO51771 | 2023-11-17 | 32.37 | 409.25 | 202.33 | |||
SO59063_4 | 81BA-420E-80 | PO8468196044 | 98 | 288 | 481 | 16 | 10 | 2024-03-23 | 10.79 | 0.27 | 2024-03-11 | 2 | 3.36 | 1 | 10.79 | 4 | SO59063 | 2024-03-18 | 0.86 | 6.72 | 5.39 | |||
SO51143_20 | 5AF9-4974-90 | PO8410118711 | 98 | 288 | 217 | 11 | 538 | 10 | 56.68 | 2023-10-22 | 377.89 | 8.03 | 2023-10-10 | 24 | 13.09 | 1 | 321.21 | 20 | SO51143 | 2023-10-17 | 25.70 | 314.07 | 15.75 | 0.15 |
SO50728_17 | 4054-4DE7-86 | PO8671171267 | 98 | 288 | 308 | 502 | 10 | 2023-09-22 | 3721.36 | 93.03 | 2023-09-10 | 5 | 660.91 | 1 | 3721.36 | 17 | SO50728 | 2023-09-17 | 297.71 | 3304.57 | 744.27 | |||
SO47009_21 | 8F7C-4372-A2 | PO1508115971 | 98 | 288 | 448 | 430 | 10 | 2022-11-22 | 35.98 | 0.90 | 2022-11-10 | 3 | 8.25 | 1 | 35.98 | 21 | SO47009 | 2022-11-17 | 2.88 | 24.74 | 11.99 | |||
SO57185_7 | 683A-464C-8C | PO8729178515 | 98 | 290 | 552 | 556 | 10 | 2024-02-22 | 109.79 | 2.74 | 2024-02-10 | 2 | 40.62 | 1 | 109.79 | 7 | SO57185 | 2024-02-17 | 8.78 | 81.24 | 54.89 | |||
SO55236_25 | F466-42CE-8B | PO19575117252 | 98 | 288 | 488 | 34 | 10 | 2024-01-22 | 161.97 | 4.05 | 2024-01-10 | 5 | 41.57 | 1 | 161.97 | 25 | SO55236 | 2024-01-17 | 12.96 | 207.86 | 32.39 |
Generated 2024-11-09 22:34:54.859 UTC