[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 469 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47673_12 | AFCF-4DA6-99 | PO13862175462 | 19 | 291 | 358 | 119 | 6 | 2023-01-22 | 2458.92 | 61.47 | 2023-01-10 | 2 | 1105.81 | 1 | 2458.92 | 12 | SO47673 | 2023-01-17 | 196.71 | 2211.62 | 1229.46 | |||
SO51092_49 | FB68-47B7-9D | PO15312133079 | 19 | 291 | 482 | 299 | 6 | 2023-10-22 | 10.79 | 0.27 | 2023-10-10 | 2 | 3.36 | 1 | 10.79 | 49 | SO51092 | 2023-10-17 | 0.86 | 6.72 | 5.39 | |||
SO47673_13 | AFCF-4DA6-99 | PO13862175462 | 19 | 291 | 419 | 119 | 6 | 2023-01-22 | 105.29 | 2.63 | 2023-01-10 | 2 | 38.96 | 1 | 105.29 | 13 | SO47673 | 2023-01-17 | 8.42 | 77.92 | 52.65 | |||
SO51093_1 | 1897-4E77-A7 | PO15022183049 | 100 | 289 | 534 | 560 | 1 | 2023-10-22 | 149.87 | 3.75 | 2023-10-10 | 1 | 136.79 | 1 | 149.87 | 1 | SO51093 | 2023-10-17 | 11.99 | 136.79 | 149.87 | |||
SO47673_14 | AFCF-4DA6-99 | PO13862175462 | 19 | 291 | 410 | 119 | 6 | 2023-01-22 | 36.45 | 0.91 | 2023-01-10 | 1 | 26.97 | 1 | 36.45 | 14 | SO47673 | 2023-01-17 | 2.92 | 26.97 | 36.45 | |||
SO51094_1 | 39DF-419F-B9 | PO14616117012 | 6 | 296 | 564 | 14 | 634 | 9 | 190.73 | 2023-10-22 | 953.63 | 19.07 | 2023-10-10 | 1 | 1481.94 | 1 | 762.90 | 1 | SO51094 | 2023-10-17 | 61.03 | 1481.94 | 953.63 | 0.20 |
SO47673_15 | AFCF-4DA6-99 | PO13862175462 | 19 | 291 | 409 | 119 | 6 | 2023-01-22 | 418.51 | 10.46 | 2023-01-10 | 2 | 185.82 | 1 | 418.51 | 15 | SO47673 | 2023-01-17 | 33.48 | 371.64 | 209.26 | |||
SO51094_2 | 39DF-419F-B9 | PO14616117012 | 6 | 296 | 568 | 13 | 634 | 9 | 50.11 | 2023-10-22 | 334.06 | 7.10 | 2023-10-10 | 1 | 461.44 | 1 | 283.95 | 2 | SO51094 | 2023-10-17 | 22.72 | 461.44 | 334.06 | 0.15 |
SO47673_16 | AFCF-4DA6-99 | PO13862175462 | 19 | 291 | 399 | 119 | 6 | 2023-01-22 | 33.77 | 0.84 | 2023-01-10 | 1 | 24.99 | 1 | 33.77 | 16 | SO47673 | 2023-01-17 | 2.70 | 24.99 | 33.77 | |||
SO51094_3 | 39DF-419F-B9 | PO14616117012 | 6 | 296 | 561 | 14 | 634 | 9 | 381.45 | 2023-10-22 | 1907.26 | 38.15 | 2023-10-10 | 2 | 1481.94 | 1 | 1525.80 | 3 | SO51094 | 2023-10-17 | 122.06 | 2963.88 | 953.63 | 0.20 |
SO47673_17 | AFCF-4DA6-99 | PO13862175462 | 19 | 291 | 420 | 119 | 6 | 2023-01-22 | 283.23 | 7.08 | 2023-01-10 | 2 | 104.80 | 1 | 283.23 | 17 | SO47673 | 2023-01-17 | 22.66 | 209.59 | 141.62 | |||
SO51094_4 | 39DF-419F-B9 | PO14616117012 | 6 | 296 | 552 | 634 | 9 | 2023-10-22 | 54.89 | 1.37 | 2023-10-10 | 1 | 40.62 | 1 | 54.89 | 4 | SO51094 | 2023-10-17 | 4.39 | 40.62 | 54.89 | |||
SO47673_18 | AFCF-4DA6-99 | PO13862175462 | 19 | 291 | 427 | 119 | 6 | 2023-01-22 | 627.77 | 15.69 | 2023-01-10 | 3 | 185.82 | 1 | 627.77 | 18 | SO47673 | 2023-01-17 | 50.22 | 557.46 | 209.26 | |||
SO51094_5 | 39DF-419F-B9 | PO14616117012 | 6 | 296 | 576 | 634 | 9 | 2023-10-22 | 1430.44 | 35.76 | 2023-10-10 | 1 | 1481.94 | 1 | 1430.44 | 5 | SO51094 | 2023-10-17 | 114.44 | 1481.94 | 1430.44 | |||
SO47673_19 | AFCF-4DA6-99 | PO13862175462 | 19 | 291 | 297 | 119 | 6 | 2023-01-22 | 1472.29 | 36.81 | 2023-01-10 | 2 | 653.70 | 1 | 1472.29 | 19 | SO47673 | 2023-01-17 | 117.78 | 1307.39 | 736.15 | |||
SO51094_6 | 39DF-419F-B9 | PO14616117012 | 6 | 296 | 559 | 634 | 9 | 2023-10-22 | 12.14 | 0.30 | 2023-10-10 | 1 | 8.99 | 1 | 12.14 | 6 | SO51094 | 2023-10-17 | 0.97 | 8.99 | 12.14 | |||
SO47673_20 | AFCF-4DA6-99 | PO13862175462 | 19 | 291 | 469 | 3 | 119 | 6 | 18.81 | 2023-01-22 | 376.10 | 8.93 | 2023-01-10 | 18 | 15.67 | 1 | 357.30 | 20 | SO47673 | 2023-01-17 | 28.58 | 282.08 | 20.89 | 0.05 |
SO51094_7 | 39DF-419F-B9 | PO14616117012 | 6 | 296 | 579 | 634 | 9 | 2023-10-22 | 1457.82 | 36.45 | 2023-10-10 | 2 | 755.15 | 1 | 1457.82 | 7 | SO51094 | 2023-10-17 | 116.63 | 1510.30 | 728.91 | |||
SO47673_21 | AFCF-4DA6-99 | PO13862175462 | 19 | 291 | 354 | 119 | 6 | 2023-01-22 | 2485.70 | 62.14 | 2023-01-10 | 2 | 1117.86 | 1 | 2485.70 | 21 | SO47673 | 2023-01-17 | 198.86 | 2235.71 | 1242.85 | |||
SO51095_1 | 9E89-4758-94 | PO14413190533 | 100 | 287 | 547 | 383 | 4 | 2023-10-22 | 97.19 | 2.43 | 2023-10-10 | 2 | 35.96 | 1 | 97.19 | 1 | SO51095 | 2023-10-17 | 7.78 | 71.92 | 48.59 | |||
SO47674_1 | D724-43A2-B7 | PO13949139803 | 100 | 281 | 327 | 643 | 3 | 2023-01-22 | 939.59 | 23.49 | 2023-01-10 | 2 | 486.71 | 1 | 939.59 | 1 | SO47674 | 2023-01-17 | 75.17 | 973.41 | 469.79 | |||
SO51095_2 | 9E89-4758-94 | PO14413190533 | 100 | 287 | 546 | 383 | 4 | 2023-10-22 | 74.51 | 1.86 | 2023-10-10 | 2 | 27.57 | 1 | 74.51 | 2 | SO51095 | 2023-10-17 | 5.96 | 55.14 | 37.25 | |||
SO47674_2 | D724-43A2-B7 | PO13949139803 | 100 | 281 | 323 | 643 | 3 | 2023-01-22 | 2348.97 | 58.72 | 2023-01-10 | 5 | 486.71 | 1 | 2348.97 | 2 | SO47674 | 2023-01-17 | 187.92 | 2433.53 | 469.79 | |||
SO51095_3 | 9E89-4758-94 | PO14413190533 | 100 | 287 | 434 | 383 | 4 | 2023-10-22 | 356.90 | 8.92 | 2023-10-10 | 1 | 360.94 | 1 | 356.90 | 3 | SO51095 | 2023-10-17 | 28.55 | 360.94 | 356.90 | |||
SO47674_3 | D724-43A2-B7 | PO13949139803 | 100 | 281 | 422 | 643 | 3 | 2023-01-22 | 202.62 | 5.07 | 2023-01-10 | 3 | 49.98 | 1 | 202.62 | 3 | SO47674 | 2023-01-17 | 16.21 | 149.94 | 67.54 | |||
SO51095_4 | 9E89-4758-94 | PO14413190533 | 100 | 287 | 545 | 383 | 4 | 2023-10-22 | 24.29 | 0.61 | 2023-10-10 | 1 | 17.98 | 1 | 24.29 | 4 | SO51095 | 2023-10-17 | 1.94 | 17.98 | 24.29 | |||
SO47674_4 | D724-43A2-B7 | PO13949139803 | 100 | 281 | 333 | 643 | 3 | 2023-01-22 | 2818.76 | 70.47 | 2023-01-10 | 6 | 486.71 | 1 | 2818.76 | 4 | SO47674 | 2023-01-17 | 225.50 | 2920.24 | 469.79 | |||
SO51095_5 | 9E89-4758-94 | PO14413190533 | 100 | 287 | 287 | 383 | 4 | 2023-10-22 | 202.33 | 5.06 | 2023-10-10 | 1 | 204.63 | 1 | 202.33 | 5 | SO51095 | 2023-10-17 | 16.19 | 204.63 | 202.33 | |||
SO47674_5 | D724-43A2-B7 | PO13949139803 | 100 | 281 | 325 | 643 | 3 | 2023-01-22 | 939.59 | 23.49 | 2023-01-10 | 2 | 486.71 | 1 | 939.59 | 5 | SO47674 | 2023-01-17 | 75.17 | 973.41 | 469.79 | |||
SO51095_6 | 9E89-4758-94 | PO14413190533 | 100 | 287 | 482 | 383 | 4 | 2023-10-22 | 48.55 | 1.21 | 2023-10-10 | 9 | 3.36 | 1 | 48.55 | 6 | SO51095 | 2023-10-17 | 3.88 | 30.26 | 5.39 | |||
SO51096_1 | 2D8A-4DAD-96 | PO14732111307 | 19 | 291 | 440 | 514 | 6 | 2023-10-22 | 2576.70 | 64.42 | 2023-10-10 | 3 | 868.63 | 1 | 2576.70 | 1 | SO51096 | 2023-10-17 | 206.14 | 2605.90 | 858.90 |
Generated 2024-11-10 01:44:01.004 UTC