[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SKIP 0 < SKIP 3562 > < TAKE 31 >
31 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48012_28 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 457 | 78 | 4 | 2023-01-02 | 44.99 | 1.12 | 2022-12-21 | 1 | 30.93 | 1 | 44.99 | 28 | SO48012 | 2022-12-28 | 3.60 | 30.93 | 44.99 |
SO48012_29 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 383 | 78 | 4 | 2023-01-02 | 1800.79 | 45.02 | 2022-12-21 | 3 | 605.65 | 1 | 1800.79 | 29 | SO48012 | 2022-12-28 | 144.06 | 1816.95 | 600.26 |
SO48012_30 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 221 | 78 | 4 | 2023-01-02 | 161.49 | 4.04 | 2022-12-21 | 8 | 13.88 | 1 | 161.49 | 30 | SO48012 | 2022-12-28 | 12.92 | 111.03 | 20.19 |
SO48012_31 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 429 | 78 | 4 | 2023-01-02 | 648.91 | 16.22 | 2022-12-21 | 2 | 300.12 | 1 | 648.91 | 31 | SO48012 | 2022-12-28 | 51.91 | 600.24 | 324.45 |
SO48012_32 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 422 | 78 | 4 | 2023-01-02 | 270.16 | 6.75 | 2022-12-21 | 4 | 49.98 | 1 | 270.16 | 32 | SO48012 | 2022-12-28 | 21.61 | 199.92 | 67.54 |
SO48012_33 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 375 | 78 | 4 | 2023-01-02 | 2617.88 | 65.45 | 2022-12-21 | 2 | 1320.68 | 1 | 2617.88 | 33 | SO48012 | 2022-12-28 | 209.43 | 2641.37 | 1308.94 |
SO48012_34 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 459 | 78 | 4 | 2023-01-02 | 377.96 | 9.45 | 2022-12-21 | 7 | 37.12 | 1 | 377.96 | 34 | SO48012 | 2022-12-28 | 30.24 | 259.85 | 53.99 |
SO48012_35 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 254 | 78 | 4 | 2023-01-02 | 367.88 | 9.20 | 2022-12-21 | 2 | 170.14 | 1 | 367.88 | 35 | SO48012 | 2022-12-28 | 29.43 | 340.29 | 183.94 |
SO48012_36 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 415 | 78 | 4 | 2023-01-02 | 792.14 | 19.80 | 2022-12-21 | 4 | 146.55 | 1 | 792.14 | 36 | SO48012 | 2022-12-28 | 63.37 | 586.19 | 198.04 |
SO48012_37 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 439 | 78 | 4 | 2023-01-02 | 1561.64 | 39.04 | 2022-12-21 | 2 | 722.26 | 1 | 1561.64 | 37 | SO48012 | 2022-12-28 | 124.93 | 1444.51 | 780.82 |
SO48012_38 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 323 | 78 | 4 | 2023-01-02 | 1409.38 | 35.23 | 2022-12-21 | 3 | 486.71 | 1 | 1409.38 | 38 | SO48012 | 2022-12-28 | 112.75 | 1460.12 | 469.79 |
SO48012_39 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 414 | 78 | 4 | 2023-01-02 | 298.06 | 7.45 | 2022-12-21 | 2 | 110.28 | 1 | 298.06 | 39 | SO48012 | 2022-12-28 | 23.85 | 220.57 | 149.03 |
SO48012_40 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 242 | 78 | 4 | 2023-01-02 | 1561.64 | 39.04 | 2022-12-21 | 2 | 722.26 | 1 | 1561.64 | 40 | SO48012 | 2022-12-28 | 124.93 | 1444.51 | 780.82 |
SO48012_41 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 236 | 78 | 4 | 2023-01-02 | 144.20 | 3.61 | 2022-12-21 | 5 | 29.08 | 1 | 144.20 | 41 | SO48012 | 2022-12-28 | 11.54 | 145.40 | 28.84 |
SO48012_42 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 273 | 78 | 4 | 2023-01-02 | 404.66 | 10.12 | 2022-12-21 | 2 | 187.16 | 1 | 404.66 | 42 | SO48012 | 2022-12-28 | 32.37 | 374.31 | 202.33 |
SO48012_43 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 230 | 78 | 4 | 2023-01-02 | 115.36 | 2.88 | 2022-12-21 | 4 | 29.08 | 1 | 115.36 | 43 | SO48012 | 2022-12-28 | 9.23 | 116.32 | 28.84 |
SO48012_44 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 280 | 78 | 4 | 2023-01-02 | 551.81 | 13.80 | 2022-12-21 | 3 | 170.14 | 1 | 551.81 | 44 | SO48012 | 2022-12-28 | 44.15 | 510.43 | 183.94 |
SO48012_45 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 456 | 78 | 4 | 2023-01-02 | 179.98 | 4.50 | 2022-12-21 | 4 | 30.93 | 1 | 179.98 | 45 | SO48012 | 2022-12-28 | 14.40 | 123.73 | 44.99 |
SO48012_46 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 453 | 78 | 4 | 2023-01-02 | 143.98 | 3.60 | 2022-12-21 | 4 | 24.75 | 1 | 143.98 | 46 | SO48012 | 2022-12-28 | 11.52 | 98.98 | 35.99 |
SO48012_47 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 263 | 78 | 4 | 2023-01-02 | 607.00 | 15.17 | 2022-12-21 | 3 | 187.16 | 1 | 607.00 | 47 | SO48012 | 2022-12-28 | 48.56 | 561.47 | 202.33 |
SO48012_48 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 239 | 78 | 4 | 2023-01-02 | 2342.45 | 58.56 | 2022-12-21 | 3 | 722.26 | 1 | 2342.45 | 48 | SO48012 | 2022-12-28 | 187.40 | 2166.77 | 780.82 |
SO48012_49 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 454 | 78 | 4 | 2023-01-02 | 35.99 | 0.90 | 2022-12-21 | 1 | 24.75 | 1 | 35.99 | 49 | SO48012 | 2022-12-28 | 2.88 | 24.75 | 35.99 |
SO45554_7 | 24D3-4CD4-AB | PO2697134276 | 100 | 282 | 212 | 187 | 4 | 2022-05-02 | 60.56 | 1.51 | 2022-04-20 | 3 | 12.03 | 1 | 60.56 | 7 | SO45554 | 2022-04-27 | 4.84 | 36.08 | 20.19 |
SO45554_8 | 24D3-4CD4-AB | PO2697134276 | 100 | 282 | 307 | 187 | 4 | 2022-05-02 | 722.59 | 18.06 | 2022-04-20 | 1 | 623.84 | 1 | 722.59 | 8 | SO45554 | 2022-04-27 | 57.81 | 623.84 | 722.59 |
SO45554_9 | 24D3-4CD4-AB | PO2697134276 | 100 | 282 | 223 | 187 | 4 | 2022-05-02 | 10.37 | 0.26 | 2022-04-20 | 2 | 5.71 | 1 | 10.37 | 9 | SO45554 | 2022-04-27 | 0.83 | 11.41 | 5.19 |
SO45554_10 | 24D3-4CD4-AB | PO2697134276 | 100 | 282 | 348 | 187 | 4 | 2022-05-02 | 10124.97 | 253.12 | 2022-04-20 | 5 | 1898.09 | 1 | 10124.97 | 10 | SO45554 | 2022-04-27 | 810.00 | 9490.47 | 2024.99 |
SO45554_11 | 24D3-4CD4-AB | PO2697134276 | 100 | 282 | 232 | 187 | 4 | 2022-05-02 | 259.56 | 6.49 | 2022-04-20 | 9 | 31.72 | 1 | 259.56 | 11 | SO45554 | 2022-04-27 | 20.77 | 285.52 | 28.84 |
SO45554_12 | 24D3-4CD4-AB | PO2697134276 | 100 | 282 | 344 | 187 | 4 | 2022-05-02 | 4079.99 | 102.00 | 2022-04-20 | 2 | 1912.15 | 1 | 4079.99 | 12 | SO45554 | 2022-04-27 | 326.40 | 3824.31 | 2039.99 |
SO45555_1 | B11A-41CE-84 | PO3248155143 | 100 | 282 | 296 | 366 | 4 | 2022-05-02 | 1429.41 | 35.74 | 2022-04-20 | 2 | 617.03 | 1 | 1429.41 | 1 | SO45555 | 2022-04-27 | 114.35 | 1234.06 | 714.70 |
SO45555_2 | B11A-41CE-84 | PO3248155143 | 100 | 282 | 292 | 366 | 4 | 2022-05-02 | 818.70 | 20.47 | 2022-04-20 | 1 | 706.81 | 1 | 818.70 | 2 | SO45555 | 2022-04-27 | 65.50 | 706.81 | 818.70 |
SO45555_3 | B11A-41CE-84 | PO3248155143 | 100 | 282 | 351 | 366 | 4 | 2022-05-02 | 16199.95 | 405.00 | 2022-04-20 | 8 | 1898.09 | 1 | 16199.95 | 3 | SO45555 | 2022-04-27 | 1296.00 | 15184.76 | 2024.99 |
Generated 2024-09-19 23:47:02.026 UTC