[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SKIP 0 SHUFFLE < SKIP 1062 > < TAKE 31 >
31 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47988_43 | 3979-4615-A9 | PO16733190266 | 19 | 291 | 414 | 533 | 6 | 2023-01-02 | 447.09 | 11.18 | 2022-12-21 | 3 | 110.28 | 1 | 447.09 | 43 | SO47988 | 2022-12-28 | 35.77 | 330.85 | 149.03 | |||
SO49069_9 | 251D-4CF2-8D | PO1914132192 | 19 | 284 | 224 | 66 | 6 | 2023-04-04 | 15.56 | 0.39 | 2023-03-23 | 3 | 5.23 | 1 | 15.56 | 9 | SO49069 | 2023-03-30 | 1.24 | 15.69 | 5.19 | |||
SO45797_13 | B3FE-4436-96 | PO11049120115 | 19 | 284 | 334 | 679 | 6 | 2022-06-02 | 1677.84 | 41.95 | 2022-05-21 | 4 | 413.15 | 1 | 1677.84 | 13 | SO45797 | 2022-05-28 | 134.23 | 1652.59 | 419.46 | |||
SO45781_19 | EB85-4E0C-A3 | PO18444138991 | 19 | 288 | 322 | 227 | 6 | 2022-06-02 | 1677.84 | 41.95 | 2022-05-21 | 4 | 413.15 | 1 | 1677.84 | 19 | SO45781 | 2022-05-28 | 134.23 | 1652.59 | 419.46 | |||
SO50677_2 | FA6C-40A6-9B | PO14239119929 | 19 | 291 | 327 | 550 | 6 | 2023-08-02 | 939.59 | 23.49 | 2023-07-21 | 2 | 486.71 | 1 | 939.59 | 2 | SO50677 | 2023-07-28 | 75.17 | 973.41 | 469.79 | |||
SO69560_6 | B1B6-43F4-BC | PO9077167302 | 19 | 291 | 589 | 100 | 6 | 2024-07-02 | 923.39 | 23.08 | 2024-06-20 | 2 | 419.78 | 1 | 923.39 | 6 | SO69560 | 2024-06-27 | 73.87 | 839.56 | 461.69 | |||
SO47366_54 | DD3E-4DAA-BA | PO17545115575 | 19 | 291 | 242 | 155 | 6 | 2022-11-02 | 2342.45 | 58.56 | 2022-10-21 | 3 | 722.26 | 1 | 2342.45 | 54 | SO47366 | 2022-10-28 | 187.40 | 2166.77 | 780.82 | |||
SO69398_4 | 29DF-4EAC-8D | PO17632193764 | 19 | 291 | 585 | 28 | 6 | 2024-07-02 | 445.41 | 11.14 | 2024-06-20 | 1 | 461.44 | 1 | 445.41 | 4 | SO69398 | 2024-06-27 | 35.63 | 461.44 | 445.41 | |||
SO57022_8 | 9202-4FEB-88 | PO17806175482 | 19 | 291 | 481 | 101 | 6 | 2024-01-02 | 10.79 | 0.27 | 2023-12-21 | 2 | 3.36 | 1 | 10.79 | 8 | SO57022 | 2023-12-28 | 0.86 | 6.72 | 5.39 | |||
SO61248_8 | 67A0-4D10-87 | PO4495126386 | 19 | 291 | 544 | 496 | 6 | 2024-03-03 | 242.97 | 6.07 | 2024-02-20 | 5 | 35.96 | 1 | 242.97 | 8 | SO61248 | 2024-02-27 | 19.44 | 179.80 | 48.59 | |||
SO50710_2 | F253-40D0-82 | PO14210176561 | 19 | 284 | 385 | 30 | 6 | 2023-08-02 | 600.26 | 15.01 | 2023-07-21 | 1 | 605.65 | 1 | 600.26 | 2 | SO50710 | 2023-07-28 | 48.02 | 605.65 | 600.26 | |||
SO50242_22 | A651-4343-86 | PO1595193228 | 19 | 284 | 230 | 426 | 6 | 2023-07-02 | 144.20 | 3.61 | 2023-06-20 | 5 | 29.08 | 1 | 144.20 | 22 | SO50242 | 2023-06-27 | 11.54 | 145.40 | 28.84 | |||
SO48008_2 | D4D5-432B-95 | PO12789161534 | 19 | 291 | 458 | 677 | 6 | 2023-01-02 | 44.99 | 1.12 | 2022-12-21 | 1 | 30.93 | 1 | 44.99 | 2 | SO48008 | 2022-12-28 | 3.60 | 30.93 | 44.99 | |||
SO51781_3 | 63E7-4ABF-A9 | PO20039116715 | 19 | 291 | 214 | 65 | 6 | 2023-10-02 | 83.98 | 2.10 | 2023-09-20 | 4 | 13.09 | 1 | 83.98 | 3 | SO51781 | 2023-09-27 | 6.72 | 52.35 | 20.99 | |||
SO44077_5 | D160-4713-81 | PO19401178507 | 19 | 288 | 322 | 173 | 6 | 2021-11-02 | 838.92 | 20.97 | 2021-10-21 | 2 | 413.15 | 1 | 838.92 | 5 | SO44077 | 2021-10-28 | 67.11 | 826.29 | 419.46 | |||
SO47365_26 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 458 | 678 | 6 | 2022-11-02 | 359.95 | 9.00 | 2022-10-21 | 8 | 30.93 | 1 | 359.95 | 26 | SO47365 | 2022-10-28 | 28.80 | 247.47 | 44.99 | |||
SO50239_2 | E1A7-444D-BB | PO638156203 | 19 | 291 | 224 | 280 | 6 | 2023-07-02 | 36.31 | 0.91 | 2023-06-20 | 7 | 5.23 | 1 | 36.31 | 2 | SO50239 | 2023-06-27 | 2.90 | 36.61 | 5.19 | |||
SO53513_26 | 5E21-438C-B3 | PO10875194431 | 19 | 291 | 563 | 14 | 281 | 6 | 190.73 | 2023-11-02 | 953.63 | 19.07 | 2023-10-21 | 1 | 1481.94 | 1 | 762.90 | 26 | SO53513 | 2023-10-28 | 61.03 | 1481.94 | 953.63 | 0.20 |
SO48761_1 | E39C-4A4E-A3 | PO15312195795 | 19 | 291 | 464 | 299 | 6 | 2023-03-04 | 70.64 | 1.77 | 2023-02-20 | 5 | 9.71 | 1 | 70.64 | 1 | SO48761 | 2023-02-27 | 5.65 | 48.57 | 14.13 | |||
SO65187_1 | E489-4A03-98 | PO14935166058 | 19 | 291 | 565 | 443 | 6 | 2024-05-02 | 445.41 | 11.14 | 2024-04-20 | 1 | 461.44 | 1 | 445.41 | 1 | SO65187 | 2024-04-27 | 35.63 | 461.44 | 445.41 | |||
SO53508_11 | 38E7-428D-9B | PO11194139565 | 19 | 284 | 506 | 48 | 6 | 2023-11-02 | 400.10 | 10.00 | 2023-10-21 | 2 | 199.85 | 1 | 400.10 | 11 | SO53508 | 2023-10-28 | 32.01 | 399.70 | 200.05 | |||
SO46936_21 | 95A0-4327-AA | PO19227121833 | 19 | 284 | 286 | 210 | 6 | 2022-10-02 | 551.81 | 13.80 | 2022-09-20 | 3 | 170.14 | 1 | 551.81 | 21 | SO46936 | 2022-09-27 | 44.15 | 510.43 | 183.94 | |||
SO47670_37 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 242 | 514 | 6 | 2022-12-02 | 780.82 | 19.52 | 2022-11-20 | 1 | 722.26 | 1 | 780.82 | 37 | SO47670 | 2022-11-27 | 62.47 | 722.26 | 780.82 | |||
SO47008_3 | FD36-4D89-AB | PO1595170889 | 19 | 284 | 385 | 426 | 6 | 2022-10-02 | 1200.53 | 30.01 | 2022-09-20 | 2 | 605.65 | 1 | 1200.53 | 3 | SO47008 | 2022-09-27 | 96.04 | 1211.30 | 600.26 | |||
SO59003_5 | 514A-4B62-B4 | PO14239121229 | 19 | 291 | 580 | 550 | 6 | 2024-02-01 | 3061.78 | 76.54 | 2024-01-20 | 3 | 1082.51 | 1 | 3061.78 | 5 | SO59003 | 2024-01-27 | 244.94 | 3247.53 | 1020.59 | |||
SO46616_43 | 1264-43E6-B7 | PO14732122562 | 19 | 291 | 333 | 2 | 514 | 6 | 118.07 | 2022-09-01 | 5903.74 | 144.64 | 2022-08-20 | 13 | 486.71 | 1 | 5785.67 | 43 | SO46616 | 2022-08-27 | 462.85 | 6327.19 | 454.13 | 0.02 |
SO44535_10 | 26EF-4A69-B0 | PO2088169831 | 19 | 288 | 316 | 136 | 6 | 2022-01-02 | 1749.59 | 43.74 | 2021-12-21 | 2 | 884.71 | 1 | 1749.59 | 10 | SO44535 | 2021-12-28 | 139.97 | 1769.42 | 874.79 | |||
SO67268_38 | 9708-4E22-A4 | PO15312122688 | 19 | 291 | 477 | 2 | 299 | 6 | 0.64 | 2024-06-02 | 31.84 | 0.78 | 2024-05-21 | 11 | 1.87 | 1 | 31.20 | 38 | SO67268 | 2024-05-28 | 2.50 | 20.53 | 2.89 | 0.02 |
SO51156_2 | C598-4D75-B4 | PO4930142451 | 19 | 291 | 475 | 425 | 6 | 2023-09-01 | 83.99 | 2.10 | 2023-08-20 | 2 | 26.18 | 1 | 83.99 | 2 | SO51156 | 2023-08-27 | 6.72 | 52.35 | 41.99 | |||
SO43857_4 | 0CD4-4091-9B | PO16733124458 | 19 | 288 | 319 | 533 | 6 | 2021-10-02 | 2624.38 | 65.61 | 2021-09-20 | 3 | 884.71 | 1 | 2624.38 | 4 | SO43857 | 2021-09-27 | 209.95 | 2654.12 | 874.79 | |||
SO48750_26 | 9A71-449E-B6 | PO14732147398 | 19 | 291 | 381 | 514 | 6 | 2023-03-04 | 3001.31 | 75.03 | 2023-02-20 | 5 | 605.65 | 1 | 3001.31 | 26 | SO48750 | 2023-02-27 | 240.11 | 3028.25 | 600.26 |
Generated 2024-09-20 01:34:54.081 UTC