[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > < SKIP 579 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO43868_1 | 5E0C-45B4-9D | PO14848158712 | 19 | 288 | 310 | 478 | 6 | 2021-11-23 | 2146.96 | 53.67 | 2021-11-11 | 1 | 2171.29 | 1 | 2146.96 | 1 | SO43868 | 2021-11-18 | 171.76 | 2171.29 | 2146.96 | |||
| SO47670_13 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 216 | 514 | 6 | 2023-01-23 | 201.87 | 5.05 | 2023-01-11 | 10 | 13.88 | 1 | 201.87 | 13 | SO47670 | 2023-01-18 | 16.15 | 138.78 | 20.19 | |||
| SO51116_23 | B371-45B5-B0 | PO10527115387 | 19 | 284 | 547 | 480 | 6 | 2023-10-23 | 145.78 | 3.64 | 2023-10-11 | 3 | 35.96 | 1 | 145.78 | 23 | SO51116 | 2023-10-18 | 11.66 | 107.88 | 48.59 | |||
| SO58972_34 | 07C8-43BD-85 | PO1798131785 | 19 | 291 | 587 | 10 | 6 | 2024-03-24 | 923.39 | 23.08 | 2024-03-12 | 2 | 419.78 | 1 | 923.39 | 34 | SO58972 | 2024-03-19 | 73.87 | 839.56 | 461.69 | |||
| SO43879_1 | EDC5-4BD5-8F | PO11600128380 | 19 | 288 | 326 | 569 | 6 | 2021-11-23 | 1258.38 | 31.46 | 2021-11-11 | 3 | 413.15 | 1 | 1258.38 | 1 | SO43879 | 2021-11-18 | 100.67 | 1239.44 | 419.46 | |||
| SO47670_14 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 335 | 514 | 6 | 2023-01-23 | 1409.38 | 35.23 | 2023-01-11 | 3 | 486.71 | 1 | 1409.38 | 14 | SO47670 | 2023-01-18 | 112.75 | 1460.12 | 469.79 | |||
| SO51124_1 | 5EEF-4271-BB | PO1711177181 | 19 | 291 | 357 | 245 | 6 | 2023-10-23 | 1391.99 | 34.80 | 2023-10-11 | 1 | 1265.62 | 1 | 1391.99 | 1 | SO51124 | 2023-10-18 | 111.36 | 1265.62 | 1391.99 | |||
| SO58972_35 | 07C8-43BD-85 | PO1798131785 | 19 | 291 | 512 | 10 | 6 | 2024-03-24 | 655.36 | 16.38 | 2024-03-12 | 3 | 199.38 | 1 | 655.36 | 35 | SO58972 | 2024-03-19 | 52.43 | 598.13 | 218.45 | |||
| SO43879_2 | EDC5-4BD5-8F | PO11600128380 | 19 | 288 | 328 | 569 | 6 | 2021-11-23 | 838.92 | 20.97 | 2021-11-11 | 2 | 413.15 | 1 | 838.92 | 2 | SO43879 | 2021-11-18 | 67.11 | 826.29 | 419.46 | |||
| SO47670_15 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 333 | 514 | 6 | 2023-01-23 | 939.59 | 23.49 | 2023-01-11 | 2 | 486.71 | 1 | 939.59 | 15 | SO47670 | 2023-01-18 | 75.17 | 973.41 | 469.79 | |||
| SO51124_2 | 5EEF-4271-BB | PO1711177181 | 19 | 291 | 555 | 245 | 6 | 2023-10-23 | 383.40 | 9.59 | 2023-10-11 | 6 | 47.29 | 1 | 383.40 | 2 | SO51124 | 2023-10-18 | 30.67 | 283.72 | 63.90 | |||
| SO58972_36 | 07C8-43BD-85 | PO1798131785 | 19 | 291 | 596 | 10 | 6 | 2024-03-24 | 323.99 | 8.10 | 2024-03-12 | 1 | 294.58 | 1 | 323.99 | 36 | SO58972 | 2024-03-19 | 25.92 | 294.58 | 323.99 | |||
| SO43879_3 | EDC5-4BD5-8F | PO11600128380 | 19 | 288 | 322 | 569 | 6 | 2021-11-23 | 1258.38 | 31.46 | 2021-11-11 | 3 | 413.15 | 1 | 1258.38 | 3 | SO43879 | 2021-11-18 | 100.67 | 1239.44 | 419.46 | |||
| SO47670_16 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 453 | 514 | 6 | 2023-01-23 | 287.95 | 7.20 | 2023-01-11 | 8 | 24.75 | 1 | 287.95 | 16 | SO47670 | 2023-01-18 | 23.04 | 197.97 | 35.99 | |||
| SO51124_3 | 5EEF-4271-BB | PO1711177181 | 19 | 291 | 515 | 245 | 6 | 2023-10-23 | 97.63 | 2.44 | 2023-10-11 | 6 | 12.04 | 1 | 97.63 | 3 | SO51124 | 2023-10-18 | 7.81 | 72.25 | 16.27 | |||
| SO58972_37 | 07C8-43BD-85 | PO1798131785 | 19 | 291 | 597 | 10 | 6 | 2024-03-24 | 971.98 | 24.30 | 2024-03-12 | 3 | 294.58 | 1 | 971.98 | 37 | SO58972 | 2024-03-19 | 77.76 | 883.74 | 323.99 | |||
| SO43879_4 | EDC5-4BD5-8F | PO11600128380 | 19 | 288 | 330 | 569 | 6 | 2021-11-23 | 838.92 | 20.97 | 2021-11-11 | 2 | 413.15 | 1 | 838.92 | 4 | SO43879 | 2021-11-18 | 67.11 | 826.29 | 419.46 | |||
| SO47670_17 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 459 | 514 | 6 | 2023-01-23 | 161.98 | 4.05 | 2023-01-11 | 3 | 37.12 | 1 | 161.98 | 17 | SO47670 | 2023-01-18 | 12.96 | 111.36 | 53.99 | |||
| SO51124_4 | 5EEF-4271-BB | PO1711177181 | 19 | 291 | 359 | 245 | 6 | 2023-10-23 | 4130.98 | 103.27 | 2023-10-11 | 3 | 1251.98 | 1 | 4130.98 | 4 | SO51124 | 2023-10-18 | 330.48 | 3755.94 | 1376.99 | |||
| SO58972_38 | 07C8-43BD-85 | PO1798131785 | 19 | 291 | 490 | 10 | 6 | 2024-03-24 | 161.97 | 4.05 | 2024-03-12 | 5 | 41.57 | 1 | 161.97 | 38 | SO58972 | 2024-03-19 | 12.96 | 207.86 | 32.39 | |||
| SO43879_5 | EDC5-4BD5-8F | PO11600128380 | 19 | 288 | 232 | 569 | 6 | 2021-11-23 | 57.68 | 1.44 | 2021-11-11 | 2 | 31.72 | 1 | 57.68 | 5 | SO43879 | 2021-11-18 | 4.61 | 63.45 | 28.84 | |||
| SO47670_18 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 370 | 514 | 6 | 2023-01-23 | 4398.03 | 109.95 | 2023-01-11 | 3 | 1518.79 | 1 | 4398.03 | 18 | SO47670 | 2023-01-18 | 351.84 | 4556.36 | 1466.01 | |||
| SO51124_5 | 5EEF-4271-BB | PO1711177181 | 19 | 291 | 524 | 2 | 245 | 6 | 42.88 | 2023-10-23 | 2144.09 | 52.53 | 2023-10-11 | 14 | 144.59 | 1 | 2101.20 | 5 | SO51124 | 2023-10-18 | 168.10 | 2024.31 | 153.15 | 0.02 |
| SO58972_39 | 07C8-43BD-85 | PO1798131785 | 19 | 291 | 598 | 10 | 6 | 2024-03-24 | 971.98 | 24.30 | 2024-03-12 | 3 | 294.58 | 1 | 971.98 | 39 | SO58972 | 2024-03-19 | 77.76 | 883.74 | 323.99 | |||
| SO43879_6 | EDC5-4BD5-8F | PO11600128380 | 19 | 288 | 262 | 569 | 6 | 2021-11-23 | 735.75 | 18.39 | 2021-11-11 | 4 | 181.49 | 1 | 735.75 | 6 | SO43879 | 2021-11-18 | 58.86 | 725.94 | 183.94 | |||
| SO47670_19 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 271 | 514 | 6 | 2023-01-23 | 809.33 | 20.23 | 2023-01-11 | 4 | 187.16 | 1 | 809.33 | 19 | SO47670 | 2023-01-18 | 64.75 | 748.63 | 202.33 | |||
| SO51124_6 | 5EEF-4271-BB | PO1711177181 | 19 | 291 | 551 | 245 | 6 | 2023-10-23 | 158.43 | 3.96 | 2023-10-11 | 1 | 144.59 | 1 | 158.43 | 6 | SO51124 | 2023-10-18 | 12.67 | 144.59 | 158.43 | |||
| SO58972_40 | 07C8-43BD-85 | PO1798131785 | 19 | 291 | 542 | 10 | 6 | 2024-03-24 | 48.59 | 1.21 | 2024-03-12 | 2 | 17.98 | 1 | 48.59 | 40 | SO58972 | 2024-03-19 | 3.89 | 35.96 | 24.29 |
Generated 2024-11-10 14:17:42.018 UTC