[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 2655 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44538_18 | E495-47A9-AD | PO2523126243 | 100 | 287 | 324 | 167 | 4 | 2022-02-23 | 419.46 | 10.49 | 2022-02-11 | 1 | 413.15 | 1 | 419.46 | 18 | SO44538 | 2022-02-18 | 33.56 | 413.15 | 419.46 |
SO48052_16 | FBD0-4407-84 | PO3654150499 | 100 | 283 | 367 | 435 | 4 | 2023-02-23 | 1943.98 | 48.60 | 2023-02-11 | 3 | 598.44 | 1 | 1943.98 | 16 | SO48052 | 2023-02-18 | 155.52 | 1795.31 | 647.99 |
SO61264_14 | 5396-4F0C-B0 | PO5626112601 | 100 | 281 | 545 | 166 | 4 | 2024-04-24 | 97.18 | 2.43 | 2024-04-12 | 4 | 17.98 | 1 | 97.18 | 14 | SO61264 | 2024-04-19 | 7.77 | 71.91 | 24.29 |
SO44538_19 | E495-47A9-AD | PO2523126243 | 100 | 287 | 312 | 167 | 4 | 2022-02-23 | 6440.89 | 161.02 | 2022-02-11 | 3 | 2171.29 | 1 | 6440.89 | 19 | SO44538 | 2022-02-18 | 515.27 | 6513.88 | 2146.96 |
SO48052_17 | FBD0-4407-84 | PO3654150499 | 100 | 283 | 364 | 435 | 4 | 2023-02-23 | 647.99 | 16.20 | 2023-02-11 | 1 | 598.44 | 1 | 647.99 | 17 | SO48052 | 2023-02-18 | 51.84 | 598.44 | 647.99 |
SO61264_15 | 5396-4F0C-B0 | PO5626112601 | 100 | 281 | 436 | 166 | 4 | 2024-04-24 | 1070.69 | 26.77 | 2024-04-12 | 3 | 360.94 | 1 | 1070.69 | 15 | SO61264 | 2024-04-19 | 85.66 | 1082.83 | 356.90 |
SO44538_20 | E495-47A9-AD | PO2523126243 | 100 | 287 | 253 | 167 | 4 | 2022-02-23 | 892.90 | 22.32 | 2022-02-11 | 5 | 176.20 | 1 | 892.90 | 20 | SO44538 | 2022-02-18 | 71.43 | 881.00 | 178.58 |
SO48052_18 | FBD0-4407-84 | PO3654150499 | 100 | 283 | 362 | 435 | 4 | 2023-02-23 | 3688.38 | 92.21 | 2023-02-11 | 3 | 1105.81 | 1 | 3688.38 | 18 | SO48052 | 2023-02-18 | 295.07 | 3317.43 | 1229.46 |
SO61264_16 | 5396-4F0C-B0 | PO5626112601 | 100 | 281 | 390 | 166 | 4 | 2024-04-24 | 2016.88 | 50.42 | 2024-04-12 | 3 | 713.08 | 1 | 2016.88 | 16 | SO61264 | 2024-04-19 | 161.35 | 2139.24 | 672.29 |
SO44538_21 | E495-47A9-AD | PO2523126243 | 100 | 287 | 264 | 167 | 4 | 2022-02-23 | 919.69 | 22.99 | 2022-02-11 | 5 | 181.49 | 1 | 919.69 | 21 | SO44538 | 2022-02-18 | 73.58 | 907.43 | 183.94 |
SO48052_19 | FBD0-4407-84 | PO3654150499 | 100 | 283 | 394 | 435 | 4 | 2023-02-23 | 82.08 | 2.05 | 2023-02-11 | 4 | 15.18 | 1 | 82.08 | 19 | SO48052 | 2023-02-18 | 6.57 | 60.74 | 20.52 |
SO61264_17 | 5396-4F0C-B0 | PO5626112601 | 100 | 281 | 580 | 166 | 4 | 2024-04-24 | 2041.19 | 51.03 | 2024-04-12 | 2 | 1082.51 | 1 | 2041.19 | 17 | SO61264 | 2024-04-19 | 163.30 | 2165.02 | 1020.59 |
SO44538_22 | E495-47A9-AD | PO2523126243 | 100 | 287 | 215 | 167 | 4 | 2022-02-23 | 40.37 | 1.01 | 2022-02-11 | 2 | 12.03 | 1 | 40.37 | 22 | SO44538 | 2022-02-18 | 3.23 | 24.06 | 20.19 |
SO48052_20 | FBD0-4407-84 | PO3654150499 | 100 | 283 | 427 | 435 | 4 | 2023-02-23 | 837.02 | 20.93 | 2023-02-11 | 4 | 185.82 | 1 | 837.02 | 20 | SO48052 | 2023-02-18 | 66.96 | 743.28 | 209.26 |
SO61264_18 | 5396-4F0C-B0 | PO5626112601 | 100 | 281 | 434 | 166 | 4 | 2024-04-24 | 1070.69 | 26.77 | 2024-04-12 | 3 | 360.94 | 1 | 1070.69 | 18 | SO61264 | 2024-04-19 | 85.66 | 1082.83 | 356.90 |
SO44538_23 | E495-47A9-AD | PO2523126243 | 100 | 287 | 340 | 167 | 4 | 2022-02-23 | 2097.29 | 52.43 | 2022-02-11 | 5 | 413.15 | 1 | 2097.29 | 23 | SO44538 | 2022-02-18 | 167.78 | 2065.73 | 419.46 |
SO48052_21 | FBD0-4407-84 | PO3654150499 | 100 | 283 | 352 | 435 | 4 | 2023-02-23 | 3728.56 | 93.21 | 2023-02-11 | 3 | 1117.86 | 1 | 3728.56 | 21 | SO48052 | 2023-02-18 | 298.28 | 3353.57 | 1242.85 |
SO61264_19 | 5396-4F0C-B0 | PO5626112601 | 100 | 281 | 418 | 166 | 4 | 2024-04-24 | 713.80 | 17.84 | 2024-04-12 | 2 | 360.94 | 1 | 713.80 | 19 | SO61264 | 2024-04-19 | 57.10 | 721.89 | 356.90 |
SO44538_24 | E495-47A9-AD | PO2523126243 | 100 | 287 | 315 | 167 | 4 | 2022-02-23 | 3499.18 | 87.48 | 2022-02-11 | 4 | 884.71 | 1 | 3499.18 | 24 | SO44538 | 2022-02-18 | 279.93 | 3538.83 | 874.79 |
SO48052_22 | FBD0-4407-84 | PO3654150499 | 100 | 283 | 391 | 435 | 4 | 2023-02-23 | 88.93 | 2.22 | 2023-02-11 | 1 | 65.81 | 1 | 88.93 | 22 | SO48052 | 2023-02-18 | 7.11 | 65.81 | 88.93 |
SO61264_20 | 5396-4F0C-B0 | PO5626112601 | 100 | 281 | 547 | 166 | 4 | 2024-04-24 | 48.59 | 1.21 | 2024-04-12 | 1 | 35.96 | 1 | 48.59 | 20 | SO61264 | 2024-04-19 | 3.89 | 35.96 | 48.59 |
SO44538_25 | E495-47A9-AD | PO2523126243 | 100 | 287 | 314 | 167 | 4 | 2022-02-23 | 4293.92 | 107.35 | 2022-02-11 | 2 | 2171.29 | 1 | 4293.92 | 25 | SO44538 | 2022-02-18 | 343.51 | 4342.59 | 2146.96 |
SO48052_23 | FBD0-4407-84 | PO3654150499 | 100 | 283 | 409 | 435 | 4 | 2023-02-23 | 627.77 | 15.69 | 2023-02-11 | 3 | 185.82 | 1 | 627.77 | 23 | SO48052 | 2023-02-18 | 50.22 | 557.46 | 209.26 |
SO61268_1 | 6D70-4A56-87 | PO7743118540 | 100 | 287 | 507 | 275 | 4 | 2024-04-24 | 600.16 | 15.00 | 2024-04-12 | 3 | 199.85 | 1 | 600.16 | 1 | SO61268 | 2024-04-19 | 48.01 | 599.56 | 200.05 |
SO44538_26 | E495-47A9-AD | PO2523126243 | 100 | 287 | 328 | 167 | 4 | 2022-02-23 | 1258.38 | 31.46 | 2022-02-11 | 3 | 413.15 | 1 | 1258.38 | 26 | SO44538 | 2022-02-18 | 100.67 | 1239.44 | 419.46 |
SO48052_24 | FBD0-4407-84 | PO3654150499 | 100 | 283 | 396 | 435 | 4 | 2023-02-23 | 224.51 | 5.61 | 2023-02-11 | 3 | 55.38 | 1 | 224.51 | 24 | SO48052 | 2023-02-18 | 17.96 | 166.14 | 74.84 |
SO63146_1 | D28C-4303-BE | PO16762127245 | 100 | 282 | 606 | 259 | 4 | 2024-05-25 | 647.99 | 16.20 | 2024-05-13 | 2 | 343.65 | 1 | 647.99 | 1 | SO63146 | 2024-05-20 | 51.84 | 687.30 | 323.99 |
SO44538_27 | E495-47A9-AD | PO2523126243 | 100 | 287 | 262 | 167 | 4 | 2022-02-23 | 551.81 | 13.80 | 2022-02-11 | 3 | 181.49 | 1 | 551.81 | 27 | SO44538 | 2022-02-18 | 44.15 | 544.46 | 183.94 |
SO48052_25 | FBD0-4407-84 | PO3654150499 | 100 | 283 | 419 | 435 | 4 | 2023-02-23 | 105.29 | 2.63 | 2023-02-11 | 2 | 38.96 | 1 | 105.29 | 25 | SO48052 | 2023-02-18 | 8.42 | 77.92 | 52.65 |
SO63146_2 | D28C-4303-BE | PO16762127245 | 100 | 282 | 580 | 259 | 4 | 2024-05-25 | 2041.19 | 51.03 | 2024-05-13 | 2 | 1082.51 | 1 | 2041.19 | 2 | SO63146 | 2024-05-20 | 163.30 | 2165.02 | 1020.59 |
SO44538_28 | E495-47A9-AD | PO2523126243 | 100 | 287 | 285 | 167 | 4 | 2022-02-23 | 1071.48 | 26.79 | 2022-02-11 | 6 | 176.20 | 1 | 1071.48 | 28 | SO44538 | 2022-02-18 | 85.72 | 1057.20 | 178.58 |
Generated 2024-11-10 09:42:55.071 UTC