[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '3' > < SKIP 644 > < TAKE 28 >
28 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48004_24 | DC8C-40DC-8F | PO13572118942 | 100 | 287 | 327 | 527 | 3 | 2023-01-04 | 939.59 | 23.49 | 2022-12-23 | 2 | 486.71 | 1 | 939.59 | 24 | SO48004 | 2022-12-30 | 75.17 | 973.41 | 469.79 |
SO48004_25 | DC8C-40DC-8F | PO13572118942 | 100 | 287 | 343 | 527 | 3 | 2023-01-04 | 2818.76 | 70.47 | 2022-12-23 | 6 | 486.71 | 1 | 2818.76 | 25 | SO48004 | 2022-12-30 | 225.50 | 2920.24 | 469.79 |
SO48004_26 | DC8C-40DC-8F | PO13572118942 | 100 | 287 | 370 | 527 | 3 | 2023-01-04 | 2932.02 | 73.30 | 2022-12-23 | 2 | 1518.79 | 1 | 2932.02 | 26 | SO48004 | 2022-12-30 | 234.56 | 3037.57 | 1466.01 |
SO48004_27 | DC8C-40DC-8F | PO13572118942 | 100 | 287 | 323 | 527 | 3 | 2023-01-04 | 469.79 | 11.74 | 2022-12-23 | 1 | 486.71 | 1 | 469.79 | 27 | SO48004 | 2022-12-30 | 37.58 | 486.71 | 469.79 |
SO48004_28 | DC8C-40DC-8F | PO13572118942 | 100 | 287 | 385 | 527 | 3 | 2023-01-04 | 2401.05 | 60.03 | 2022-12-23 | 4 | 605.65 | 1 | 2401.05 | 28 | SO48004 | 2022-12-30 | 192.08 | 2422.60 | 600.26 |
SO48004_29 | DC8C-40DC-8F | PO13572118942 | 100 | 287 | 368 | 527 | 3 | 2023-01-04 | 2932.02 | 73.30 | 2022-12-23 | 2 | 1518.79 | 1 | 2932.02 | 29 | SO48004 | 2022-12-30 | 234.56 | 3037.57 | 1466.01 |
SO48004_30 | DC8C-40DC-8F | PO13572118942 | 100 | 287 | 331 | 527 | 3 | 2023-01-04 | 939.59 | 23.49 | 2022-12-23 | 2 | 486.71 | 1 | 939.59 | 30 | SO48004 | 2022-12-30 | 75.17 | 973.41 | 469.79 |
SO48013_1 | 12C7-44E7-8D | PO12122129065 | 100 | 283 | 407 | 22 | 3 | 2023-01-04 | 262.41 | 6.56 | 2022-12-23 | 4 | 48.55 | 1 | 262.41 | 1 | SO48013 | 2022-12-30 | 20.99 | 194.18 | 65.60 |
SO48013_2 | 12C7-44E7-8D | PO12122129065 | 100 | 283 | 414 | 22 | 3 | 2023-01-04 | 149.03 | 3.73 | 2022-12-23 | 1 | 110.28 | 1 | 149.03 | 2 | SO48013 | 2022-12-30 | 11.92 | 110.28 | 149.03 |
SO48013_3 | 12C7-44E7-8D | PO12122129065 | 100 | 283 | 254 | 22 | 3 | 2023-01-04 | 735.75 | 18.39 | 2022-12-23 | 4 | 170.14 | 1 | 735.75 | 3 | SO48013 | 2022-12-30 | 58.86 | 680.57 | 183.94 |
SO48013_4 | 12C7-44E7-8D | PO12122129065 | 100 | 283 | 273 | 22 | 3 | 2023-01-04 | 202.33 | 5.06 | 2022-12-23 | 1 | 187.16 | 1 | 202.33 | 4 | SO48013 | 2022-12-30 | 16.19 | 187.16 | 202.33 |
SO48013_5 | 12C7-44E7-8D | PO12122129065 | 100 | 283 | 435 | 22 | 3 | 2023-01-04 | 324.45 | 8.11 | 2022-12-23 | 1 | 300.12 | 1 | 324.45 | 5 | SO48013 | 2022-12-30 | 25.96 | 300.12 | 324.45 |
SO48013_6 | 12C7-44E7-8D | PO12122129065 | 100 | 283 | 417 | 22 | 3 | 2023-01-04 | 324.45 | 8.11 | 2022-12-23 | 1 | 300.12 | 1 | 324.45 | 6 | SO48013 | 2022-12-30 | 25.96 | 300.12 | 324.45 |
SO48024_1 | AC8E-4930-AD | PO10788155512 | 100 | 281 | 221 | 468 | 3 | 2023-01-04 | 20.19 | 0.50 | 2022-12-23 | 1 | 13.88 | 1 | 20.19 | 1 | SO48024 | 2022-12-30 | 1.61 | 13.88 | 20.19 |
SO48044_1 | EA45-4BAB-9F | PO3045182366 | 100 | 283 | 271 | 58 | 3 | 2023-01-04 | 202.33 | 5.06 | 2022-12-23 | 1 | 187.16 | 1 | 202.33 | 1 | SO48044 | 2022-12-30 | 16.19 | 187.16 | 202.33 |
SO48044_2 | EA45-4BAB-9F | PO3045182366 | 100 | 283 | 447 | 58 | 3 | 2023-01-04 | 15.00 | 0.38 | 2022-12-23 | 1 | 10.31 | 1 | 15.00 | 2 | SO48044 | 2022-12-30 | 1.20 | 10.31 | 15.00 |
SO48045_1 | 3C43-40BF-B3 | PO3074117939 | 100 | 283 | 412 | 237 | 3 | 2023-01-04 | 180.13 | 4.50 | 2022-12-23 | 1 | 133.30 | 1 | 180.13 | 1 | SO48045 | 2022-12-30 | 14.41 | 133.30 | 180.13 |
SO48045_2 | 3C43-40BF-B3 | PO3074117939 | 100 | 283 | 409 | 237 | 3 | 2023-01-04 | 209.26 | 5.23 | 2022-12-23 | 1 | 185.82 | 1 | 209.26 | 2 | SO48045 | 2022-12-30 | 16.74 | 185.82 | 209.26 |
SO48045_3 | 3C43-40BF-B3 | PO3074117939 | 100 | 283 | 297 | 237 | 3 | 2023-01-04 | 736.15 | 18.40 | 2022-12-23 | 1 | 653.70 | 1 | 736.15 | 3 | SO48045 | 2022-12-30 | 58.89 | 653.70 | 736.15 |
SO48045_4 | 3C43-40BF-B3 | PO3074117939 | 100 | 283 | 464 | 237 | 3 | 2023-01-04 | 28.26 | 0.71 | 2022-12-23 | 2 | 9.71 | 1 | 28.26 | 4 | SO48045 | 2022-12-30 | 2.26 | 19.43 | 14.13 |
SO48065_1 | 1B78-4DE6-BC | PO5771120852 | 100 | 282 | 213 | 79 | 3 | 2023-01-04 | 40.37 | 1.01 | 2022-12-23 | 2 | 13.88 | 1 | 40.37 | 1 | SO48065 | 2022-12-30 | 3.23 | 27.76 | 20.19 |
SO48065_2 | 1B78-4DE6-BC | PO5771120852 | 100 | 282 | 325 | 79 | 3 | 2023-01-04 | 2818.76 | 70.47 | 2022-12-23 | 6 | 486.71 | 1 | 2818.76 | 2 | SO48065 | 2022-12-30 | 225.50 | 2920.24 | 469.79 |
SO48065_3 | 1B78-4DE6-BC | PO5771120852 | 100 | 282 | 379 | 79 | 3 | 2023-01-04 | 2617.88 | 65.45 | 2022-12-23 | 2 | 1320.68 | 1 | 2617.88 | 3 | SO48065 | 2022-12-30 | 209.43 | 2641.37 | 1308.94 |
SO48065_4 | 1B78-4DE6-BC | PO5771120852 | 100 | 282 | 233 | 79 | 3 | 2023-01-04 | 173.04 | 4.33 | 2022-12-23 | 6 | 29.08 | 1 | 173.04 | 4 | SO48065 | 2022-12-30 | 13.84 | 174.48 | 28.84 |
SO48065_5 | 1B78-4DE6-BC | PO5771120852 | 100 | 282 | 263 | 79 | 3 | 2023-01-04 | 1416.32 | 35.41 | 2022-12-23 | 7 | 187.16 | 1 | 1416.32 | 5 | SO48065 | 2022-12-30 | 113.31 | 1310.10 | 202.33 |
SO48065_6 | 1B78-4DE6-BC | PO5771120852 | 100 | 282 | 339 | 79 | 3 | 2023-01-04 | 1409.38 | 35.23 | 2022-12-23 | 3 | 486.71 | 1 | 1409.38 | 6 | SO48065 | 2022-12-30 | 112.75 | 1460.12 | 469.79 |
SO48065_7 | 1B78-4DE6-BC | PO5771120852 | 100 | 282 | 337 | 79 | 3 | 2023-01-04 | 1409.38 | 35.23 | 2022-12-23 | 3 | 486.71 | 1 | 1409.38 | 7 | SO48065 | 2022-12-30 | 112.75 | 1460.12 | 469.79 |
SO48065_8 | 1B78-4DE6-BC | PO5771120852 | 100 | 282 | 327 | 79 | 3 | 2023-01-04 | 469.79 | 11.74 | 2022-12-23 | 1 | 486.71 | 1 | 469.79 | 8 | SO48065 | 2022-12-30 | 37.58 | 486.71 | 469.79 |
Generated 2024-09-21 17:17:37.168 UTC