[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 1028 > < TAKE 62 >
62 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44770_7 | D260-44B2-BE | PO667193267 | 100 | 287 | 332 | 365 | 4 | 2022-02-03 | 419.46 | 10.49 | 2022-01-22 | 1 | 413.15 | 1 | 419.46 | 7 | SO44770 | 2022-01-29 | 33.56 | 413.15 | 419.46 |
SO44770_8 | D260-44B2-BE | PO667193267 | 100 | 287 | 315 | 365 | 4 | 2022-02-03 | 2624.38 | 65.61 | 2022-01-22 | 3 | 884.71 | 1 | 2624.38 | 8 | SO44770 | 2022-01-29 | 209.95 | 2654.12 | 874.79 |
SO44776_1 | 289E-464B-BE | PO2697147596 | 100 | 282 | 347 | 187 | 4 | 2022-02-03 | 10199.97 | 255.00 | 2022-01-22 | 5 | 1912.15 | 1 | 10199.97 | 1 | SO44776 | 2022-01-29 | 816.00 | 9560.77 | 2039.99 |
SO44776_2 | 289E-464B-BE | PO2697147596 | 100 | 282 | 349 | 187 | 4 | 2022-02-03 | 4049.99 | 101.25 | 2022-01-22 | 2 | 1898.09 | 1 | 4049.99 | 2 | SO44776 | 2022-01-29 | 324.00 | 3796.19 | 2024.99 |
SO44776_3 | 289E-464B-BE | PO2697147596 | 100 | 282 | 346 | 187 | 4 | 2022-02-03 | 10199.97 | 255.00 | 2022-01-22 | 5 | 1912.15 | 1 | 10199.97 | 3 | SO44776 | 2022-01-29 | 816.00 | 9560.77 | 2039.99 |
SO44776_4 | 289E-464B-BE | PO2697147596 | 100 | 282 | 235 | 187 | 4 | 2022-02-03 | 86.52 | 2.16 | 2022-01-22 | 3 | 31.72 | 1 | 86.52 | 4 | SO44776 | 2022-01-29 | 6.92 | 95.17 | 28.84 |
SO44776_5 | 289E-464B-BE | PO2697147596 | 100 | 282 | 292 | 187 | 4 | 2022-02-03 | 818.70 | 20.47 | 2022-01-22 | 1 | 706.81 | 1 | 818.70 | 5 | SO44776 | 2022-01-29 | 65.50 | 706.81 | 818.70 |
SO44776_6 | 289E-464B-BE | PO2697147596 | 100 | 282 | 215 | 187 | 4 | 2022-02-03 | 40.37 | 1.01 | 2022-01-22 | 2 | 12.03 | 1 | 40.37 | 6 | SO44776 | 2022-01-29 | 3.23 | 24.06 | 20.19 |
SO44776_7 | 289E-464B-BE | PO2697147596 | 100 | 282 | 351 | 187 | 4 | 2022-02-03 | 6074.98 | 151.87 | 2022-01-22 | 3 | 1898.09 | 1 | 6074.98 | 7 | SO44776 | 2022-01-29 | 486.00 | 5694.28 | 2024.99 |
SO44776_8 | 289E-464B-BE | PO2697147596 | 100 | 282 | 223 | 187 | 4 | 2022-02-03 | 20.75 | 0.52 | 2022-01-22 | 4 | 5.71 | 1 | 20.75 | 8 | SO44776 | 2022-01-29 | 1.66 | 22.82 | 5.19 |
SO44776_9 | 289E-464B-BE | PO2697147596 | 100 | 282 | 218 | 187 | 4 | 2022-02-03 | 17.10 | 0.43 | 2022-01-22 | 3 | 3.40 | 1 | 17.10 | 9 | SO44776 | 2022-01-29 | 1.37 | 10.19 | 5.70 |
SO44776_10 | 289E-464B-BE | PO2697147596 | 100 | 282 | 293 | 187 | 4 | 2022-02-03 | 1445.19 | 36.13 | 2022-01-22 | 2 | 623.84 | 1 | 1445.19 | 10 | SO44776 | 2022-01-29 | 115.62 | 1247.68 | 722.59 |
SO44776_11 | 289E-464B-BE | PO2697147596 | 100 | 282 | 344 | 187 | 4 | 2022-02-03 | 10199.97 | 255.00 | 2022-01-22 | 5 | 1912.15 | 1 | 10199.97 | 11 | SO44776 | 2022-01-29 | 816.00 | 9560.77 | 2039.99 |
SO44776_12 | 289E-464B-BE | PO2697147596 | 100 | 282 | 229 | 187 | 4 | 2022-02-03 | 28.84 | 0.72 | 2022-01-22 | 1 | 31.72 | 1 | 28.84 | 12 | SO44776 | 2022-01-29 | 2.31 | 31.72 | 28.84 |
SO44776_13 | 289E-464B-BE | PO2697147596 | 100 | 282 | 220 | 187 | 4 | 2022-02-03 | 40.37 | 1.01 | 2022-01-22 | 2 | 12.03 | 1 | 40.37 | 13 | SO44776 | 2022-01-29 | 3.23 | 24.06 | 20.19 |
SO44776_14 | 289E-464B-BE | PO2697147596 | 100 | 282 | 348 | 187 | 4 | 2022-02-03 | 4049.99 | 101.25 | 2022-01-22 | 2 | 1898.09 | 1 | 4049.99 | 14 | SO44776 | 2022-01-29 | 324.00 | 3796.19 | 2024.99 |
SO44776_15 | 289E-464B-BE | PO2697147596 | 100 | 282 | 212 | 187 | 4 | 2022-02-03 | 40.37 | 1.01 | 2022-01-22 | 2 | 12.03 | 1 | 40.37 | 15 | SO44776 | 2022-01-29 | 3.23 | 24.06 | 20.19 |
SO44776_16 | 289E-464B-BE | PO2697147596 | 100 | 282 | 232 | 187 | 4 | 2022-02-03 | 57.68 | 1.44 | 2022-01-22 | 2 | 31.72 | 1 | 57.68 | 16 | SO44776 | 2022-01-29 | 4.61 | 63.45 | 28.84 |
SO44777_1 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 232 | 366 | 4 | 2022-02-03 | 57.68 | 1.44 | 2022-01-22 | 2 | 31.72 | 1 | 57.68 | 1 | SO44777 | 2022-01-29 | 4.61 | 63.45 | 28.84 |
SO44777_2 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 223 | 366 | 4 | 2022-02-03 | 10.37 | 0.26 | 2022-01-22 | 2 | 5.71 | 1 | 10.37 | 2 | SO44777 | 2022-01-29 | 0.83 | 11.41 | 5.19 |
SO44777_3 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 220 | 366 | 4 | 2022-02-03 | 60.56 | 1.51 | 2022-01-22 | 3 | 12.03 | 1 | 60.56 | 3 | SO44777 | 2022-01-29 | 4.84 | 36.08 | 20.19 |
SO44777_4 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 348 | 366 | 4 | 2022-02-03 | 16199.95 | 405.00 | 2022-01-22 | 8 | 1898.09 | 1 | 16199.95 | 4 | SO44777 | 2022-01-29 | 1296.00 | 15184.76 | 2024.99 |
SO44777_5 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 349 | 366 | 4 | 2022-02-03 | 18224.95 | 455.62 | 2022-01-22 | 9 | 1898.09 | 1 | 18224.95 | 5 | SO44777 | 2022-01-29 | 1458.00 | 17082.85 | 2024.99 |
SO44777_6 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 345 | 366 | 4 | 2022-02-03 | 4079.99 | 102.00 | 2022-01-22 | 2 | 1912.15 | 1 | 4079.99 | 6 | SO44777 | 2022-01-29 | 326.40 | 3824.31 | 2039.99 |
SO44777_7 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 300 | 366 | 4 | 2022-02-03 | 809.76 | 20.24 | 2022-01-22 | 1 | 699.09 | 1 | 809.76 | 7 | SO44777 | 2022-01-29 | 64.78 | 699.09 | 809.76 |
SO44777_8 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 304 | 366 | 4 | 2022-02-03 | 714.70 | 17.87 | 2022-01-22 | 1 | 617.03 | 1 | 714.70 | 8 | SO44777 | 2022-01-29 | 57.18 | 617.03 | 714.70 |
SO44777_9 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 307 | 366 | 4 | 2022-02-03 | 2890.38 | 72.26 | 2022-01-22 | 4 | 623.84 | 1 | 2890.38 | 9 | SO44777 | 2022-01-29 | 231.23 | 2495.36 | 722.59 |
SO44777_10 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 346 | 366 | 4 | 2022-02-03 | 10199.97 | 255.00 | 2022-01-22 | 5 | 1912.15 | 1 | 10199.97 | 10 | SO44777 | 2022-01-29 | 816.00 | 9560.77 | 2039.99 |
SO44777_11 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 347 | 366 | 4 | 2022-02-03 | 8159.98 | 204.00 | 2022-01-22 | 4 | 1912.15 | 1 | 8159.98 | 11 | SO44777 | 2022-01-29 | 652.80 | 7648.62 | 2039.99 |
SO44777_12 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 235 | 366 | 4 | 2022-02-03 | 86.52 | 2.16 | 2022-01-22 | 3 | 31.72 | 1 | 86.52 | 12 | SO44777 | 2022-01-29 | 6.92 | 95.17 | 28.84 |
SO44777_13 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 296 | 366 | 4 | 2022-02-03 | 2144.11 | 53.60 | 2022-01-22 | 3 | 617.03 | 1 | 2144.11 | 13 | SO44777 | 2022-01-29 | 171.53 | 1851.08 | 714.70 |
SO44777_14 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 212 | 366 | 4 | 2022-02-03 | 80.75 | 2.02 | 2022-01-22 | 4 | 12.03 | 1 | 80.75 | 14 | SO44777 | 2022-01-29 | 6.46 | 48.11 | 20.19 |
SO44777_15 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 215 | 366 | 4 | 2022-02-03 | 60.56 | 1.51 | 2022-01-22 | 3 | 12.03 | 1 | 60.56 | 15 | SO44777 | 2022-01-29 | 4.84 | 36.08 | 20.19 |
SO44777_16 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 350 | 366 | 4 | 2022-02-03 | 12149.96 | 303.75 | 2022-01-22 | 6 | 1898.09 | 1 | 12149.96 | 16 | SO44777 | 2022-01-29 | 972.00 | 11388.57 | 2024.99 |
SO44777_17 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 351 | 366 | 4 | 2022-02-03 | 16199.95 | 405.00 | 2022-01-22 | 8 | 1898.09 | 1 | 16199.95 | 17 | SO44777 | 2022-01-29 | 1296.00 | 15184.76 | 2024.99 |
SO44777_18 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 292 | 366 | 4 | 2022-02-03 | 3274.80 | 81.87 | 2022-01-22 | 4 | 706.81 | 1 | 3274.80 | 18 | SO44777 | 2022-01-29 | 261.98 | 2827.24 | 818.70 |
SO44777_19 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 344 | 366 | 4 | 2022-02-03 | 4079.99 | 102.00 | 2022-01-22 | 2 | 1912.15 | 1 | 4079.99 | 19 | SO44777 | 2022-01-29 | 326.40 | 3824.31 | 2039.99 |
SO44777_20 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 218 | 366 | 4 | 2022-02-03 | 17.10 | 0.43 | 2022-01-22 | 3 | 3.40 | 1 | 17.10 | 20 | SO44777 | 2022-01-29 | 1.37 | 10.19 | 5.70 |
SO44781_1 | 32AD-4737-BB | PO4002147144 | 100 | 282 | 223 | 674 | 4 | 2022-02-03 | 5.19 | 0.13 | 2022-01-22 | 1 | 5.71 | 1 | 5.19 | 1 | SO44781 | 2022-01-29 | 0.41 | 5.71 | 5.19 |
SO44781_2 | 32AD-4737-BB | PO4002147144 | 100 | 282 | 342 | 674 | 4 | 2022-02-03 | 419.46 | 10.49 | 2022-01-22 | 1 | 413.15 | 1 | 419.46 | 2 | SO44781 | 2022-01-29 | 33.56 | 413.15 | 419.46 |
SO44783_1 | 8DE2-4684-BC | PO4640171635 | 100 | 287 | 223 | 648 | 4 | 2022-02-03 | 20.75 | 0.52 | 2022-01-22 | 4 | 5.71 | 1 | 20.75 | 1 | SO44783 | 2022-01-29 | 1.66 | 22.82 | 5.19 |
SO44783_2 | 8DE2-4684-BC | PO4640171635 | 100 | 287 | 307 | 648 | 4 | 2022-02-03 | 722.59 | 18.06 | 2022-01-22 | 1 | 623.84 | 1 | 722.59 | 2 | SO44783 | 2022-01-29 | 57.81 | 623.84 | 722.59 |
SO44783_3 | 8DE2-4684-BC | PO4640171635 | 100 | 287 | 346 | 648 | 4 | 2022-02-03 | 4079.99 | 102.00 | 2022-01-22 | 2 | 1912.15 | 1 | 4079.99 | 3 | SO44783 | 2022-01-29 | 326.40 | 3824.31 | 2039.99 |
SO44783_4 | 8DE2-4684-BC | PO4640171635 | 100 | 287 | 218 | 648 | 4 | 2022-02-03 | 34.20 | 0.86 | 2022-01-22 | 6 | 3.40 | 1 | 34.20 | 4 | SO44783 | 2022-01-29 | 2.74 | 20.38 | 5.70 |
SO44783_5 | 8DE2-4684-BC | PO4640171635 | 100 | 287 | 235 | 648 | 4 | 2022-02-03 | 28.84 | 0.72 | 2022-01-22 | 1 | 31.72 | 1 | 28.84 | 5 | SO44783 | 2022-01-29 | 2.31 | 31.72 | 28.84 |
SO44783_6 | 8DE2-4684-BC | PO4640171635 | 100 | 287 | 215 | 648 | 4 | 2022-02-03 | 40.37 | 1.01 | 2022-01-22 | 2 | 12.03 | 1 | 40.37 | 6 | SO44783 | 2022-01-29 | 3.23 | 24.06 | 20.19 |
SO44783_7 | 8DE2-4684-BC | PO4640171635 | 100 | 287 | 348 | 648 | 4 | 2022-02-03 | 8099.98 | 202.50 | 2022-01-22 | 4 | 1898.09 | 1 | 8099.98 | 7 | SO44783 | 2022-01-29 | 648.00 | 7592.38 | 2024.99 |
SO44783_8 | 8DE2-4684-BC | PO4640171635 | 100 | 287 | 232 | 648 | 4 | 2022-02-03 | 144.20 | 3.61 | 2022-01-22 | 5 | 31.72 | 1 | 144.20 | 8 | SO44783 | 2022-01-29 | 11.54 | 158.62 | 28.84 |
SO44783_9 | 8DE2-4684-BC | PO4640171635 | 100 | 287 | 351 | 648 | 4 | 2022-02-03 | 4049.99 | 101.25 | 2022-01-22 | 2 | 1898.09 | 1 | 4049.99 | 9 | SO44783 | 2022-01-29 | 324.00 | 3796.19 | 2024.99 |
SO44783_10 | 8DE2-4684-BC | PO4640171635 | 100 | 287 | 212 | 648 | 4 | 2022-02-03 | 60.56 | 1.51 | 2022-01-22 | 3 | 12.03 | 1 | 60.56 | 10 | SO44783 | 2022-01-29 | 4.84 | 36.08 | 20.19 |
SO44783_11 | 8DE2-4684-BC | PO4640171635 | 100 | 287 | 350 | 648 | 4 | 2022-02-03 | 4049.99 | 101.25 | 2022-01-22 | 2 | 1898.09 | 1 | 4049.99 | 11 | SO44783 | 2022-01-29 | 324.00 | 3796.19 | 2024.99 |
SO44783_12 | 8DE2-4684-BC | PO4640171635 | 100 | 287 | 349 | 648 | 4 | 2022-02-03 | 4049.99 | 101.25 | 2022-01-22 | 2 | 1898.09 | 1 | 4049.99 | 12 | SO44783 | 2022-01-29 | 324.00 | 3796.19 | 2024.99 |
SO44783_13 | 8DE2-4684-BC | PO4640171635 | 100 | 287 | 220 | 648 | 4 | 2022-02-03 | 60.56 | 1.51 | 2022-01-22 | 3 | 12.03 | 1 | 60.56 | 13 | SO44783 | 2022-01-29 | 4.84 | 36.08 | 20.19 |
SO44783_14 | 8DE2-4684-BC | PO4640171635 | 100 | 287 | 345 | 648 | 4 | 2022-02-03 | 4079.99 | 102.00 | 2022-01-22 | 2 | 1912.15 | 1 | 4079.99 | 14 | SO44783 | 2022-01-29 | 326.40 | 3824.31 | 2039.99 |
SO44783_15 | 8DE2-4684-BC | PO4640171635 | 100 | 287 | 219 | 648 | 4 | 2022-02-03 | 5.70 | 0.14 | 2022-01-22 | 1 | 3.40 | 1 | 5.70 | 15 | SO44783 | 2022-01-29 | 0.46 | 3.40 | 5.70 |
SO44783_16 | 8DE2-4684-BC | PO4640171635 | 100 | 287 | 229 | 648 | 4 | 2022-02-03 | 86.52 | 2.16 | 2022-01-22 | 3 | 31.72 | 1 | 86.52 | 16 | SO44783 | 2022-01-29 | 6.92 | 95.17 | 28.84 |
SO44787_1 | CFC8-46AC-A7 | PO5597180446 | 100 | 283 | 349 | 75 | 4 | 2022-02-03 | 6074.98 | 151.87 | 2022-01-22 | 3 | 1898.09 | 1 | 6074.98 | 1 | SO44787 | 2022-01-29 | 486.00 | 5694.28 | 2024.99 |
SO44787_2 | CFC8-46AC-A7 | PO5597180446 | 100 | 283 | 344 | 75 | 4 | 2022-02-03 | 12239.96 | 306.00 | 2022-01-22 | 6 | 1912.15 | 1 | 12239.96 | 2 | SO44787 | 2022-01-29 | 979.20 | 11472.93 | 2039.99 |
SO44787_3 | CFC8-46AC-A7 | PO5597180446 | 100 | 283 | 347 | 75 | 4 | 2022-02-03 | 2039.99 | 51.00 | 2022-01-22 | 1 | 1912.15 | 1 | 2039.99 | 3 | SO44787 | 2022-01-29 | 163.20 | 1912.15 | 2039.99 |
SO44787_4 | CFC8-46AC-A7 | PO5597180446 | 100 | 283 | 296 | 75 | 4 | 2022-02-03 | 1429.41 | 35.74 | 2022-01-22 | 2 | 617.03 | 1 | 1429.41 | 4 | SO44787 | 2022-01-29 | 114.35 | 1234.06 | 714.70 |
SO44787_5 | CFC8-46AC-A7 | PO5597180446 | 100 | 283 | 215 | 75 | 4 | 2022-02-03 | 20.19 | 0.50 | 2022-01-22 | 1 | 12.03 | 1 | 20.19 | 5 | SO44787 | 2022-01-29 | 1.61 | 12.03 | 20.19 |
SO44787_6 | CFC8-46AC-A7 | PO5597180446 | 100 | 283 | 292 | 75 | 4 | 2022-02-03 | 818.70 | 20.47 | 2022-01-22 | 1 | 706.81 | 1 | 818.70 | 6 | SO44787 | 2022-01-29 | 65.50 | 706.81 | 818.70 |
Generated 2024-09-21 07:31:24.046 UTC