[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SKIP 0 < SKIP 2199 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51781_1 | 63E7-4ABF-A9 | PO20039116715 | 19 | 291 | 491 | 65 | 6 | 2023-10-04 | 194.36 | 4.86 | 2023-09-22 | 6 | 41.57 | 1 | 194.36 | 1 | SO51781 | 2023-09-29 | 15.55 | 249.43 | 32.39 |
SO63136_18 | 0873-484A-AE | PO18328125904 | 19 | 284 | 380 | 552 | 6 | 2024-04-05 | 4398.03 | 109.95 | 2024-03-24 | 3 | 1554.95 | 1 | 4398.03 | 18 | SO63136 | 2024-03-31 | 351.84 | 4664.84 | 1466.01 |
SO44750_18 | B71E-4BBF-B5 | PO17574147002 | 19 | 288 | 347 | 678 | 6 | 2022-02-03 | 4079.99 | 102.00 | 2022-01-22 | 2 | 1912.15 | 1 | 4079.99 | 18 | SO44750 | 2022-01-29 | 326.40 | 3824.31 | 2039.99 |
SO47670_2 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 339 | 514 | 6 | 2022-12-04 | 2348.97 | 58.72 | 2022-11-22 | 5 | 486.71 | 1 | 2348.97 | 2 | SO47670 | 2022-11-29 | 187.92 | 2433.53 | 469.79 |
SO51781_2 | 63E7-4ABF-A9 | PO20039116715 | 19 | 291 | 477 | 65 | 6 | 2023-10-04 | 11.98 | 0.30 | 2023-09-22 | 4 | 1.87 | 1 | 11.98 | 2 | SO51781 | 2023-09-29 | 0.96 | 7.47 | 2.99 |
SO63136_19 | 0873-484A-AE | PO18328125904 | 19 | 284 | 372 | 552 | 6 | 2024-04-05 | 7330.05 | 183.25 | 2024-03-24 | 5 | 1554.95 | 1 | 7330.05 | 19 | SO63136 | 2024-03-31 | 586.40 | 7774.74 | 1466.01 |
SO44750_19 | B71E-4BBF-B5 | PO17574147002 | 19 | 288 | 220 | 678 | 6 | 2022-02-03 | 60.56 | 1.51 | 2022-01-22 | 3 | 12.03 | 1 | 60.56 | 19 | SO44750 | 2022-01-29 | 4.84 | 36.08 | 20.19 |
SO47670_3 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 460 | 514 | 6 | 2022-12-04 | 53.99 | 1.35 | 2022-11-22 | 1 | 37.12 | 1 | 53.99 | 3 | SO47670 | 2022-11-29 | 4.32 | 37.12 | 53.99 |
SO51781_3 | 63E7-4ABF-A9 | PO20039116715 | 19 | 291 | 214 | 65 | 6 | 2023-10-04 | 83.98 | 2.10 | 2023-09-22 | 4 | 13.09 | 1 | 83.98 | 3 | SO51781 | 2023-09-29 | 6.72 | 52.35 | 20.99 |
SO63136_20 | 0873-484A-AE | PO18328125904 | 19 | 284 | 491 | 552 | 6 | 2024-04-05 | 161.97 | 4.05 | 2024-03-24 | 5 | 41.57 | 1 | 161.97 | 20 | SO63136 | 2024-03-31 | 12.96 | 207.86 | 32.39 |
SO44750_20 | B71E-4BBF-B5 | PO17574147002 | 19 | 288 | 212 | 678 | 6 | 2022-02-03 | 60.56 | 1.51 | 2022-01-22 | 3 | 12.03 | 1 | 60.56 | 20 | SO44750 | 2022-01-29 | 4.84 | 36.08 | 20.19 |
SO47670_4 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 286 | 514 | 6 | 2022-12-04 | 735.75 | 18.39 | 2022-11-22 | 4 | 170.14 | 1 | 735.75 | 4 | SO47670 | 2022-11-29 | 58.86 | 680.57 | 183.94 |
SO51781_4 | 63E7-4ABF-A9 | PO20039116715 | 19 | 291 | 544 | 65 | 6 | 2023-10-04 | 97.19 | 2.43 | 2023-09-22 | 2 | 35.96 | 1 | 97.19 | 4 | SO51781 | 2023-09-29 | 7.78 | 71.92 | 48.59 |
SO63136_21 | 0873-484A-AE | PO18328125904 | 19 | 284 | 582 | 552 | 6 | 2024-04-05 | 4082.38 | 102.06 | 2024-03-24 | 4 | 1082.51 | 1 | 4082.38 | 21 | SO63136 | 2024-03-31 | 326.59 | 4330.04 | 1020.59 |
SO44750_21 | B71E-4BBF-B5 | PO17574147002 | 19 | 288 | 232 | 678 | 6 | 2022-02-03 | 173.04 | 4.33 | 2022-01-22 | 6 | 31.72 | 1 | 173.04 | 21 | SO44750 | 2022-01-29 | 13.84 | 190.35 | 28.84 |
SO47670_5 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 224 | 514 | 6 | 2022-12-04 | 51.87 | 1.30 | 2022-11-22 | 10 | 5.23 | 1 | 51.87 | 5 | SO47670 | 2022-11-29 | 4.15 | 52.30 | 5.19 |
SO51781_5 | 63E7-4ABF-A9 | PO20039116715 | 19 | 291 | 225 | 65 | 6 | 2023-10-04 | 37.76 | 0.94 | 2023-09-22 | 7 | 6.92 | 1 | 37.76 | 5 | SO51781 | 2023-09-29 | 3.02 | 48.46 | 5.39 |
SO63136_22 | 0873-484A-AE | PO18328125904 | 19 | 284 | 584 | 552 | 6 | 2024-04-05 | 647.99 | 16.20 | 2024-03-24 | 2 | 343.65 | 1 | 647.99 | 22 | SO63136 | 2024-03-31 | 51.84 | 687.30 | 323.99 |
SO44750_22 | B71E-4BBF-B5 | PO17574147002 | 19 | 288 | 223 | 678 | 6 | 2022-02-03 | 41.49 | 1.04 | 2022-01-22 | 8 | 5.71 | 1 | 41.49 | 22 | SO44750 | 2022-01-29 | 3.32 | 45.64 | 5.19 |
SO47670_6 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 254 | 514 | 6 | 2022-12-04 | 919.69 | 22.99 | 2022-11-22 | 5 | 170.14 | 1 | 919.69 | 6 | SO47670 | 2022-11-29 | 73.58 | 850.71 | 183.94 |
SO51781_6 | 63E7-4ABF-A9 | PO20039116715 | 19 | 291 | 359 | 65 | 6 | 2023-10-04 | 4130.98 | 103.27 | 2023-09-22 | 3 | 1251.98 | 1 | 4130.98 | 6 | SO51781 | 2023-09-29 | 330.48 | 3755.94 | 1376.99 |
SO63136_23 | 0873-484A-AE | PO18328125904 | 19 | 284 | 376 | 552 | 6 | 2024-04-05 | 5864.04 | 146.60 | 2024-03-24 | 4 | 1554.95 | 1 | 5864.04 | 23 | SO63136 | 2024-03-31 | 469.12 | 6219.79 | 1466.01 |
SO44750_23 | B71E-4BBF-B5 | PO17574147002 | 19 | 288 | 218 | 678 | 6 | 2022-02-03 | 28.50 | 0.71 | 2022-01-22 | 5 | 3.40 | 1 | 28.50 | 23 | SO44750 | 2022-01-29 | 2.28 | 16.98 | 5.70 |
SO47670_7 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 263 | 514 | 6 | 2022-12-04 | 1416.32 | 35.41 | 2022-11-22 | 7 | 187.16 | 1 | 1416.32 | 7 | SO47670 | 2022-11-29 | 113.31 | 1310.10 | 202.33 |
SO51781_7 | 63E7-4ABF-A9 | PO20039116715 | 19 | 291 | 400 | 65 | 6 | 2023-10-04 | 111.46 | 2.79 | 2023-09-22 | 3 | 27.49 | 1 | 111.46 | 7 | SO51781 | 2023-09-29 | 8.92 | 82.48 | 37.15 |
SO63136_24 | 0873-484A-AE | PO18328125904 | 19 | 284 | 225 | 552 | 6 | 2024-04-05 | 16.18 | 0.40 | 2024-03-24 | 3 | 6.92 | 1 | 16.18 | 24 | SO63136 | 2024-03-31 | 1.29 | 20.77 | 5.39 |
SO44750_24 | B71E-4BBF-B5 | PO17574147002 | 19 | 288 | 296 | 678 | 6 | 2022-02-03 | 2858.82 | 71.47 | 2022-01-22 | 4 | 617.03 | 1 | 2858.82 | 24 | SO44750 | 2022-01-29 | 228.71 | 2468.11 | 714.70 |
SO47670_8 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 233 | 514 | 6 | 2022-12-04 | 173.04 | 4.33 | 2022-11-22 | 6 | 29.08 | 1 | 173.04 | 8 | SO47670 | 2022-11-29 | 13.84 | 174.48 | 28.84 |
SO51781_8 | 63E7-4ABF-A9 | PO20039116715 | 19 | 291 | 490 | 65 | 6 | 2023-10-04 | 226.76 | 5.67 | 2023-09-22 | 7 | 41.57 | 1 | 226.76 | 8 | SO51781 | 2023-09-29 | 18.14 | 291.01 | 32.39 |
SO63136_25 | 0873-484A-AE | PO18328125904 | 19 | 284 | 483 | 552 | 6 | 2024-04-05 | 144.00 | 3.60 | 2024-03-24 | 2 | 44.88 | 1 | 144.00 | 25 | SO63136 | 2024-03-31 | 11.52 | 89.76 | 72.00 |
SO44765_1 | 54D5-4FF7-BB | PO11107155025 | 19 | 284 | 232 | 156 | 6 | 2022-02-03 | 86.52 | 2.16 | 2022-01-22 | 3 | 31.72 | 1 | 86.52 | 1 | SO44765 | 2022-01-29 | 6.92 | 95.17 | 28.84 |
Generated 2024-09-21 14:23:20.075 UTC