[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > < SKIP 180 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47662_46 | 9790-4A85-BE | PO18473142607 | 19 | 291 | 308 | 442 | 6 | 2023-01-26 | 744.27 | 18.61 | 2023-01-14 | 1 | 660.91 | 1 | 744.27 | 46 | SO47662 | 2023-01-21 | 59.54 | 660.91 | 744.27 | |||
SO51096_9 | 2D8A-4DAD-96 | PO14732111307 | 19 | 291 | 386 | 514 | 6 | 2023-10-26 | 672.29 | 16.81 | 2023-10-14 | 1 | 713.08 | 1 | 672.29 | 9 | SO51096 | 2023-10-21 | 53.78 | 713.08 | 672.29 | |||
SO58957_5 | 13BB-49DB-84 | PO10962177270 | 19 | 284 | 533 | 685 | 6 | 2024-03-27 | 299.75 | 7.49 | 2024-03-15 | 2 | 136.79 | 1 | 299.75 | 5 | SO58957 | 2024-03-22 | 23.98 | 273.57 | 149.87 | |||
SO43668_9 | 365D-4C9A-BE | PO14732180295 | 19 | 288 | 315 | 514 | 6 | 2021-10-26 | 1749.59 | 43.74 | 2021-10-14 | 2 | 884.71 | 1 | 1749.59 | 9 | SO43668 | 2021-10-21 | 139.97 | 1769.42 | 874.79 | |||
SO47663_1 | 1B17-4C63-B6 | PO18444192283 | 19 | 291 | 327 | 2 | 227 | 6 | 127.16 | 2023-01-26 | 6357.88 | 155.77 | 2023-01-14 | 14 | 486.71 | 1 | 6230.72 | 1 | SO47663 | 2023-01-21 | 498.46 | 6813.89 | 454.13 | 0.02 |
SO51096_10 | 2D8A-4DAD-96 | PO14732111307 | 19 | 291 | 243 | 514 | 6 | 2023-10-26 | 858.90 | 21.47 | 2023-10-14 | 1 | 868.63 | 1 | 858.90 | 10 | SO51096 | 2023-10-21 | 68.71 | 868.63 | 858.90 | |||
SO58957_6 | 13BB-49DB-84 | PO10962177270 | 19 | 284 | 598 | 685 | 6 | 2024-03-27 | 323.99 | 8.10 | 2024-03-15 | 1 | 294.58 | 1 | 323.99 | 6 | SO58957 | 2024-03-22 | 25.92 | 294.58 | 323.99 | |||
SO43668_10 | 365D-4C9A-BE | PO14732180295 | 19 | 288 | 223 | 514 | 6 | 2021-10-26 | 20.75 | 0.52 | 2021-10-14 | 4 | 5.71 | 1 | 20.75 | 10 | SO43668 | 2021-10-21 | 1.66 | 22.82 | 5.19 | |||
SO47663_2 | 1B17-4C63-B6 | PO18444192283 | 19 | 291 | 385 | 227 | 6 | 2023-01-26 | 1800.79 | 45.02 | 2023-01-14 | 3 | 605.65 | 1 | 1800.79 | 2 | SO47663 | 2023-01-21 | 144.06 | 1816.95 | 600.26 | |||
SO51096_11 | 2D8A-4DAD-96 | PO14732111307 | 19 | 291 | 545 | 514 | 6 | 2023-10-26 | 218.65 | 5.47 | 2023-10-14 | 9 | 17.98 | 1 | 218.65 | 11 | SO51096 | 2023-10-21 | 17.49 | 161.80 | 24.29 | |||
SO58957_7 | 13BB-49DB-84 | PO10962177270 | 19 | 284 | 542 | 685 | 6 | 2024-03-27 | 97.18 | 2.43 | 2024-03-15 | 4 | 17.98 | 1 | 97.18 | 7 | SO58957 | 2024-03-22 | 7.77 | 71.91 | 24.29 | |||
SO43668_11 | 365D-4C9A-BE | PO14732180295 | 19 | 288 | 270 | 514 | 6 | 2021-10-26 | 367.88 | 9.20 | 2021-10-14 | 2 | 181.49 | 1 | 367.88 | 11 | SO43668 | 2021-10-21 | 29.43 | 362.97 | 183.94 | |||
SO47663_3 | 1B17-4C63-B6 | PO18444192283 | 19 | 291 | 286 | 227 | 6 | 2023-01-26 | 735.75 | 18.39 | 2023-01-14 | 4 | 170.14 | 1 | 735.75 | 3 | SO47663 | 2023-01-21 | 58.86 | 680.57 | 183.94 | |||
SO51096_12 | 2D8A-4DAD-96 | PO14732111307 | 19 | 291 | 520 | 514 | 6 | 2023-10-26 | 126.34 | 3.16 | 2023-10-14 | 4 | 23.37 | 1 | 126.34 | 12 | SO51096 | 2023-10-21 | 10.11 | 93.49 | 31.58 | |||
SO58957_8 | 13BB-49DB-84 | PO10962177270 | 19 | 284 | 361 | 685 | 6 | 2024-03-27 | 5507.98 | 137.70 | 2024-03-15 | 4 | 1251.98 | 1 | 5507.98 | 8 | SO58957 | 2024-03-22 | 440.64 | 5007.93 | 1376.99 | |||
SO43668_12 | 365D-4C9A-BE | PO14732180295 | 19 | 288 | 316 | 514 | 6 | 2021-10-26 | 2624.38 | 65.61 | 2021-10-14 | 3 | 884.71 | 1 | 2624.38 | 12 | SO43668 | 2021-10-21 | 209.95 | 2654.12 | 874.79 | |||
SO47663_4 | 1B17-4C63-B6 | PO18444192283 | 19 | 291 | 273 | 227 | 6 | 2023-01-26 | 202.33 | 5.06 | 2023-01-14 | 1 | 187.16 | 1 | 202.33 | 4 | SO47663 | 2023-01-21 | 16.19 | 187.16 | 202.33 | |||
SO51096_13 | 2D8A-4DAD-96 | PO14732111307 | 19 | 291 | 378 | 514 | 6 | 2023-10-26 | 7330.05 | 183.25 | 2023-10-14 | 5 | 1554.95 | 1 | 7330.05 | 13 | SO51096 | 2023-10-21 | 586.40 | 7774.74 | 1466.01 | |||
SO58957_9 | 13BB-49DB-84 | PO10962177270 | 19 | 284 | 596 | 685 | 6 | 2024-03-27 | 323.99 | 8.10 | 2024-03-15 | 1 | 294.58 | 1 | 323.99 | 9 | SO58957 | 2024-03-22 | 25.92 | 294.58 | 323.99 | |||
SO43668_13 | 365D-4C9A-BE | PO14732180295 | 19 | 288 | 324 | 514 | 6 | 2021-10-26 | 1258.38 | 31.46 | 2021-10-14 | 3 | 413.15 | 1 | 1258.38 | 13 | SO43668 | 2021-10-21 | 100.67 | 1239.44 | 419.46 | |||
SO47663_5 | 1B17-4C63-B6 | PO18444192283 | 19 | 291 | 341 | 227 | 6 | 2023-01-26 | 939.59 | 23.49 | 2023-01-14 | 2 | 486.71 | 1 | 939.59 | 5 | SO47663 | 2023-01-21 | 75.17 | 973.41 | 469.79 | |||
SO51096_14 | 2D8A-4DAD-96 | PO14732111307 | 19 | 291 | 246 | 514 | 6 | 2023-10-26 | 858.90 | 21.47 | 2023-10-14 | 1 | 868.63 | 1 | 858.90 | 14 | SO51096 | 2023-10-21 | 68.71 | 868.63 | 858.90 | |||
SO58957_10 | 13BB-49DB-84 | PO10962177270 | 19 | 284 | 402 | 685 | 6 | 2024-03-27 | 216.49 | 5.41 | 2024-03-15 | 3 | 53.40 | 1 | 216.49 | 10 | SO58957 | 2024-03-22 | 17.32 | 160.20 | 72.16 | |||
SO43668_14 | 365D-4C9A-BE | PO14732180295 | 19 | 288 | 342 | 514 | 6 | 2021-10-26 | 838.92 | 20.97 | 2021-10-14 | 2 | 413.15 | 1 | 838.92 | 14 | SO43668 | 2021-10-21 | 67.11 | 826.29 | 419.46 | |||
SO47663_6 | 1B17-4C63-B6 | PO18444192283 | 19 | 291 | 466 | 227 | 6 | 2023-01-26 | 42.39 | 1.06 | 2023-01-14 | 3 | 9.71 | 1 | 42.39 | 6 | SO47663 | 2023-01-21 | 3.39 | 29.14 | 14.13 | |||
SO51096_15 | 2D8A-4DAD-96 | PO14732111307 | 19 | 291 | 376 | 514 | 6 | 2023-10-26 | 8796.06 | 219.90 | 2023-10-14 | 6 | 1554.95 | 1 | 8796.06 | 15 | SO51096 | 2023-10-21 | 703.68 | 9329.69 | 1466.01 | |||
SO58957_11 | 13BB-49DB-84 | PO10962177270 | 19 | 284 | 353 | 685 | 6 | 2024-03-27 | 1391.99 | 34.80 | 2024-03-15 | 1 | 1265.62 | 1 | 1391.99 | 11 | SO58957 | 2024-03-22 | 111.36 | 1265.62 | 1391.99 | |||
SO43668_15 | 365D-4C9A-BE | PO14732180295 | 19 | 288 | 264 | 514 | 6 | 2021-10-26 | 551.81 | 13.80 | 2021-10-14 | 3 | 181.49 | 1 | 551.81 | 15 | SO43668 | 2021-10-21 | 44.15 | 544.46 | 183.94 |
Generated 2024-11-13 07:00:31.161 UTC