[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 4470 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51130_35 | F38F-411F-B2 | PO18473180006 | 19 | 291 | 603 | 442 | 6 | 2023-09-02 | 145.79 | 3.64 | 2023-08-21 | 2 | 53.94 | 1 | 145.79 | 35 | SO51130 | 2023-08-28 | 11.66 | 107.88 | 72.89 | |||
SO58993_3 | EEB4-42E9-B9 | PO14297167367 | 100 | 285 | 564 | 627 | 5 | 2024-02-02 | 4291.33 | 107.28 | 2024-01-21 | 3 | 1481.94 | 1 | 4291.33 | 3 | SO58993 | 2024-01-28 | 343.31 | 4445.81 | 1430.44 | |||
SO44101_2 | F33F-41D4-81 | PO11977181307 | 100 | 285 | 324 | 675 | 5 | 2021-11-03 | 838.92 | 20.97 | 2021-10-22 | 2 | 413.15 | 1 | 838.92 | 2 | SO44101 | 2021-10-29 | 67.11 | 826.29 | 419.46 | |||
SO47724_5 | FDA2-4CD7-92 | PO8787160870 | 100 | 282 | 368 | 523 | 3 | 2022-12-03 | 5864.04 | 146.60 | 2022-11-21 | 4 | 1518.79 | 1 | 5864.04 | 5 | SO47724 | 2022-11-28 | 469.12 | 6075.15 | 1466.01 | |||
SO51130_36 | F38F-411F-B2 | PO18473180006 | 19 | 291 | 512 | 442 | 6 | 2023-09-02 | 436.91 | 10.92 | 2023-08-21 | 2 | 199.38 | 1 | 436.91 | 36 | SO51130 | 2023-08-28 | 34.95 | 398.75 | 218.45 | |||
SO58993_4 | EEB4-42E9-B9 | PO14297167367 | 100 | 285 | 571 | 627 | 5 | 2024-02-02 | 445.41 | 11.14 | 2024-01-21 | 1 | 461.44 | 1 | 445.41 | 4 | SO58993 | 2024-01-28 | 35.63 | 461.44 | 445.41 | |||
SO44101_3 | F33F-41D4-81 | PO11977181307 | 100 | 285 | 310 | 675 | 5 | 2021-11-03 | 8587.85 | 214.70 | 2021-10-22 | 4 | 2171.29 | 1 | 8587.85 | 3 | SO44101 | 2021-10-29 | 687.03 | 8685.18 | 2146.96 | |||
SO47724_6 | FDA2-4CD7-92 | PO8787160870 | 100 | 282 | 389 | 523 | 3 | 2022-12-03 | 600.26 | 15.01 | 2022-11-21 | 1 | 605.65 | 1 | 600.26 | 6 | SO47724 | 2022-11-28 | 48.02 | 605.65 | 600.26 | |||
SO51130_37 | F38F-411F-B2 | PO18473180006 | 19 | 291 | 594 | 442 | 6 | 2023-09-02 | 677.99 | 16.95 | 2023-08-21 | 2 | 308.22 | 1 | 677.99 | 37 | SO51130 | 2023-08-28 | 54.24 | 616.44 | 338.99 | |||
SO58993_5 | EEB4-42E9-B9 | PO14297167367 | 100 | 285 | 576 | 627 | 5 | 2024-02-02 | 1430.44 | 35.76 | 2024-01-21 | 1 | 1481.94 | 1 | 1430.44 | 5 | SO58993 | 2024-01-28 | 114.44 | 1481.94 | 1430.44 | |||
SO44101_4 | F33F-41D4-81 | PO11977181307 | 100 | 285 | 262 | 675 | 5 | 2021-11-03 | 183.94 | 4.60 | 2021-10-22 | 1 | 181.49 | 1 | 183.94 | 4 | SO44101 | 2021-10-29 | 14.72 | 181.49 | 183.94 | |||
SO47724_7 | FDA2-4CD7-92 | PO8787160870 | 100 | 282 | 415 | 523 | 3 | 2022-12-03 | 396.07 | 9.90 | 2022-11-21 | 2 | 146.55 | 1 | 396.07 | 7 | SO47724 | 2022-11-28 | 31.69 | 293.09 | 198.04 | |||
SO51130_38 | F38F-411F-B2 | PO18473180006 | 19 | 291 | 544 | 442 | 6 | 2023-09-02 | 388.75 | 9.72 | 2023-08-21 | 8 | 35.96 | 1 | 388.75 | 38 | SO51130 | 2023-08-28 | 31.10 | 287.68 | 48.59 | |||
SO58993_6 | EEB4-42E9-B9 | PO14297167367 | 100 | 285 | 548 | 627 | 5 | 2024-02-02 | 145.78 | 3.64 | 2024-01-21 | 3 | 35.96 | 1 | 145.78 | 6 | SO58993 | 2024-01-28 | 11.66 | 107.88 | 48.59 | |||
SO44102_1 | BAC5-4B76-AB | PO11426145969 | 100 | 285 | 319 | 386 | 5 | 2021-11-03 | 1749.59 | 43.74 | 2021-10-22 | 2 | 884.71 | 1 | 1749.59 | 1 | SO44102 | 2021-10-29 | 139.97 | 1769.42 | 874.79 | |||
SO47724_8 | FDA2-4CD7-92 | PO8787160870 | 100 | 282 | 414 | 523 | 3 | 2022-12-03 | 298.06 | 7.45 | 2022-11-21 | 2 | 110.28 | 1 | 298.06 | 8 | SO47724 | 2022-11-28 | 23.85 | 220.57 | 149.03 | |||
SO51130_39 | F38F-411F-B2 | PO18473180006 | 19 | 291 | 558 | 442 | 6 | 2023-09-02 | 1700.96 | 42.52 | 2023-08-21 | 7 | 179.82 | 1 | 1700.96 | 39 | SO51130 | 2023-08-28 | 136.08 | 1258.71 | 242.99 | |||
SO58993_7 | EEB4-42E9-B9 | PO14297167367 | 100 | 285 | 562 | 627 | 5 | 2024-02-02 | 2860.88 | 71.52 | 2024-01-21 | 2 | 1481.94 | 1 | 2860.88 | 7 | SO58993 | 2024-01-28 | 228.87 | 2963.88 | 1430.44 | |||
SO44102_2 | BAC5-4B76-AB | PO11426145969 | 100 | 285 | 326 | 386 | 5 | 2021-11-03 | 419.46 | 10.49 | 2021-10-22 | 1 | 413.15 | 1 | 419.46 | 2 | SO44102 | 2021-10-29 | 33.56 | 413.15 | 419.46 | |||
SO47724_9 | FDA2-4CD7-92 | PO8787160870 | 100 | 282 | 373 | 523 | 3 | 2022-12-03 | 3926.81 | 98.17 | 2022-11-21 | 3 | 1320.68 | 1 | 3926.81 | 9 | SO47724 | 2022-11-28 | 314.15 | 3962.05 | 1308.94 | |||
SO51130_40 | F38F-411F-B2 | PO18473180006 | 19 | 291 | 532 | 442 | 6 | 2023-09-02 | 1049.12 | 26.23 | 2023-08-21 | 7 | 136.79 | 1 | 1049.12 | 40 | SO51130 | 2023-08-28 | 83.93 | 957.50 | 149.87 | |||
SO58993_8 | EEB4-42E9-B9 | PO14297167367 | 100 | 285 | 574 | 627 | 5 | 2024-02-02 | 2860.88 | 71.52 | 2024-01-21 | 2 | 1481.94 | 1 | 2860.88 | 8 | SO58993 | 2024-01-28 | 228.87 | 2963.88 | 1430.44 | |||
SO44102_3 | BAC5-4B76-AB | PO11426145969 | 100 | 285 | 232 | 386 | 5 | 2021-11-03 | 86.52 | 2.16 | 2021-10-22 | 3 | 31.72 | 1 | 86.52 | 3 | SO44102 | 2021-10-29 | 6.92 | 95.17 | 28.84 | |||
SO47724_10 | FDA2-4CD7-92 | PO8787160870 | 100 | 282 | 464 | 523 | 3 | 2022-12-03 | 28.26 | 0.71 | 2022-11-21 | 2 | 9.71 | 1 | 28.26 | 10 | SO47724 | 2022-11-28 | 2.26 | 19.43 | 14.13 | |||
SO51131_1 | D489-4DF3-A2 | PO16298169856 | 100 | 287 | 490 | 2 | 599 | 4 | 6.89 | 2023-09-02 | 344.46 | 8.44 | 2023-08-21 | 11 | 41.57 | 1 | 337.57 | 1 | SO51131 | 2023-08-28 | 27.01 | 457.30 | 31.31 | 0.02 |
SO58993_9 | EEB4-42E9-B9 | PO14297167367 | 100 | 285 | 558 | 627 | 5 | 2024-02-02 | 728.98 | 18.22 | 2024-01-21 | 3 | 179.82 | 1 | 728.98 | 9 | SO58993 | 2024-01-28 | 58.32 | 539.45 | 242.99 | |||
SO44102_4 | BAC5-4B76-AB | PO11426145969 | 100 | 285 | 342 | 386 | 5 | 2021-11-03 | 419.46 | 10.49 | 2021-10-22 | 1 | 413.15 | 1 | 419.46 | 4 | SO44102 | 2021-10-29 | 33.56 | 413.15 | 419.46 | |||
SO47724_11 | FDA2-4CD7-92 | PO8787160870 | 100 | 282 | 331 | 523 | 3 | 2022-12-03 | 2348.97 | 58.72 | 2022-11-21 | 5 | 486.71 | 1 | 2348.97 | 11 | SO47724 | 2022-11-28 | 187.92 | 2433.53 | 469.79 | |||
SO51131_2 | D489-4DF3-A2 | PO16298169856 | 100 | 287 | 488 | 2 | 599 | 4 | 7.52 | 2023-09-02 | 375.77 | 9.21 | 2023-08-21 | 12 | 41.57 | 1 | 368.26 | 2 | SO51131 | 2023-08-28 | 29.46 | 498.87 | 31.31 | 0.02 |
SO58993_10 | EEB4-42E9-B9 | PO14297167367 | 100 | 285 | 586 | 627 | 5 | 2024-02-02 | 445.41 | 11.14 | 2024-01-21 | 1 | 461.44 | 1 | 445.41 | 10 | SO58993 | 2024-01-28 | 35.63 | 461.44 | 445.41 | |||
SO44102_5 | BAC5-4B76-AB | PO11426145969 | 100 | 285 | 322 | 386 | 5 | 2021-11-03 | 838.92 | 20.97 | 2021-10-22 | 2 | 413.15 | 1 | 838.92 | 5 | SO44102 | 2021-10-29 | 67.11 | 826.29 | 419.46 |
Generated 2024-09-20 10:00:22.126 UTC