[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 7075 > < TAKE 24 >
24 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49100_2 | BD42-4470-A8 | PO17603154869 | 19 | 284 | 233 | 12 | 6 | 2023-04-06 | 115.36 | 2.88 | 2023-03-25 | 4 | 29.08 | 1 | 115.36 | 2 | SO49100 | 2023-04-01 | 9.23 | 116.32 | 28.84 | |||
SO55297_38 | 2455-4B60-A5 | PO4495126679 | 19 | 291 | 363 | 496 | 6 | 2023-12-04 | 6884.97 | 172.12 | 2023-11-22 | 5 | 1251.98 | 1 | 6884.97 | 38 | SO55297 | 2023-11-29 | 550.80 | 6259.91 | 1376.99 | |||
SO47365_25 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 426 | 678 | 6 | 2022-11-04 | 1046.28 | 26.16 | 2022-10-23 | 5 | 185.82 | 1 | 1046.28 | 25 | SO47365 | 2022-10-30 | 83.70 | 929.10 | 209.26 | |||
SO61177_21 | DA64-4BC0-A0 | PO18473117778 | 19 | 291 | 517 | 442 | 6 | 2024-03-05 | 31.58 | 0.79 | 2024-02-22 | 1 | 23.37 | 1 | 31.58 | 21 | SO61177 | 2024-02-29 | 2.53 | 23.37 | 31.58 | |||
SO46607_19 | C1B5-40D6-8D | PO18444137892 | 19 | 291 | 377 | 227 | 6 | 2022-09-03 | 6544.69 | 163.62 | 2022-08-22 | 5 | 1320.68 | 1 | 6544.69 | 19 | SO46607 | 2022-08-29 | 523.58 | 6603.42 | 1308.94 | |||
SO44537_1 | 583D-4D33-9D | PO2175178820 | 19 | 288 | 229 | 137 | 6 | 2022-01-04 | 57.68 | 1.44 | 2021-12-23 | 2 | 31.72 | 1 | 57.68 | 1 | SO44537 | 2021-12-30 | 4.61 | 63.45 | 28.84 | |||
SO53600_5 | 8E02-463C-A5 | PO2233133950 | 19 | 291 | 217 | 262 | 6 | 2023-11-04 | 104.97 | 2.62 | 2023-10-23 | 5 | 13.09 | 1 | 104.97 | 5 | SO53600 | 2023-10-30 | 8.40 | 65.43 | 20.99 | |||
SO50203_8 | 821E-4862-9A | PO17603125956 | 19 | 284 | 343 | 3 | 12 | 6 | 452.18 | 2023-07-04 | 9043.53 | 214.78 | 2023-06-22 | 21 | 486.71 | 1 | 8591.36 | 8 | SO50203 | 2023-06-29 | 687.31 | 10220.84 | 430.64 | 0.05 |
SO57154_14 | 464B-46A4-B6 | PO1856185040 | 19 | 291 | 237 | 263 | 6 | 2024-01-04 | 149.97 | 3.75 | 2023-12-23 | 5 | 38.49 | 1 | 149.97 | 14 | SO57154 | 2023-12-30 | 12.00 | 192.46 | 29.99 | |||
SO49484_14 | B25F-4DF4-8E | PO18299142683 | 19 | 291 | 459 | 118 | 6 | 2023-05-04 | 161.98 | 4.05 | 2023-04-22 | 3 | 37.12 | 1 | 161.98 | 14 | SO49484 | 2023-04-29 | 12.96 | 111.36 | 53.99 | |||
SO59002_2 | A4A7-481C-A3 | PO14210147786 | 19 | 284 | 287 | 30 | 6 | 2024-02-03 | 202.33 | 5.06 | 2024-01-22 | 1 | 204.63 | 1 | 202.33 | 2 | SO59002 | 2024-01-29 | 16.19 | 204.63 | 202.33 | |||
SO58932_6 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 572 | 408 | 6 | 2024-02-03 | 1336.23 | 33.41 | 2024-01-22 | 3 | 461.44 | 1 | 1336.23 | 6 | SO58932 | 2024-01-29 | 106.90 | 1384.33 | 445.41 | |||
SO46607_9 | C1B5-40D6-8D | PO18444137892 | 19 | 291 | 417 | 227 | 6 | 2022-09-03 | 973.36 | 24.33 | 2022-08-22 | 3 | 300.12 | 1 | 973.36 | 9 | SO46607 | 2022-08-29 | 77.87 | 900.36 | 324.45 | |||
SO51818_18 | B8CE-4C91-A9 | PO9077115532 | 19 | 291 | 589 | 100 | 6 | 2023-10-04 | 461.69 | 11.54 | 2023-09-22 | 1 | 419.78 | 1 | 461.69 | 18 | SO51818 | 2023-09-29 | 36.94 | 419.78 | 461.69 | |||
SO43661_14 | 4E0A-4F89-AE | PO18473189620 | 19 | 288 | 350 | 442 | 6 | 2021-09-03 | 4049.99 | 101.25 | 2021-08-22 | 2 | 1898.09 | 1 | 4049.99 | 14 | SO43661 | 2021-08-29 | 324.00 | 3796.19 | 2024.99 | |||
SO45781_25 | EB85-4E0C-A3 | PO18444138991 | 19 | 288 | 266 | 227 | 6 | 2022-06-04 | 183.94 | 4.60 | 2022-05-23 | 1 | 181.49 | 1 | 183.94 | 25 | SO45781 | 2022-05-30 | 14.72 | 181.49 | 183.94 | |||
SO50689_28 | 20BC-4161-86 | PO10614135588 | 19 | 291 | 368 | 461 | 6 | 2023-08-04 | 2932.02 | 73.30 | 2023-07-23 | 2 | 1518.79 | 1 | 2932.02 | 28 | SO50689 | 2023-07-30 | 234.56 | 3037.57 | 1466.01 | |||
SO58956_19 | 36A4-4154-AB | PO11194174095 | 19 | 284 | 579 | 48 | 6 | 2024-02-03 | 2186.73 | 54.67 | 2024-01-22 | 3 | 755.15 | 1 | 2186.73 | 19 | SO58956 | 2024-01-29 | 174.94 | 2265.45 | 728.91 | |||
SO71828_8 | 73A0-490C-B1 | PO11194153355 | 19 | 284 | 496 | 48 | 6 | 2024-08-04 | 2409.38 | 60.23 | 2024-07-23 | 4 | 601.74 | 1 | 2409.38 | 8 | SO71828 | 2024-07-30 | 192.75 | 2406.97 | 602.35 | |||
SO55263_1 | 10F0-498D-AE | PO11136189942 | 19 | 284 | 560 | 120 | 6 | 2023-12-04 | 1457.82 | 36.45 | 2023-11-22 | 2 | 755.15 | 1 | 1457.82 | 1 | SO55263 | 2023-11-29 | 116.63 | 1510.30 | 728.91 | |||
SO69540_20 | 75AA-4D8C-83 | PO1856168639 | 19 | 291 | 576 | 263 | 6 | 2024-07-04 | 2860.88 | 71.52 | 2024-06-22 | 2 | 1481.94 | 1 | 2860.88 | 20 | SO69540 | 2024-06-29 | 228.87 | 2963.88 | 1430.44 | |||
SO71800_8 | 6DBE-44CC-BD | PO15544127760 | 19 | 284 | 567 | 282 | 6 | 2024-08-04 | 1781.64 | 44.54 | 2024-07-23 | 4 | 461.44 | 1 | 1781.64 | 8 | SO71800 | 2024-07-30 | 142.53 | 1845.78 | 445.41 | |||
SO71794_2 | C39A-4835-99 | PO17574111985 | 19 | 291 | 524 | 678 | 6 | 2024-08-04 | 633.72 | 15.84 | 2024-07-23 | 4 | 144.59 | 1 | 633.72 | 2 | SO71794 | 2024-07-30 | 50.70 | 578.38 | 158.43 | |||
SO49052_3 | 8769-409E-94 | PO16733182723 | 19 | 291 | 373 | 533 | 6 | 2023-04-06 | 9162.56 | 229.06 | 2023-03-25 | 7 | 1320.68 | 1 | 9162.56 | 3 | SO49052 | 2023-04-01 | 733.01 | 9244.79 | 1308.94 |
Generated 2024-09-21 13:49:16.350 UTC