[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '10' > SHUFFLE SKIP 2000 < SKIP 687 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO71832_13 | 269D-4F59-82 | PO10353140756 | 98 | 288 | 543 | 88 | 10 | 2024-09-22 | 37.25 | 0.93 | 2024-09-10 | 1 | 27.57 | 1 | 37.25 | 13 | SO71832 | 2024-09-17 | 2.98 | 27.57 | 37.25 | |||
SO61175_3 | 5850-42D5-A1 | PO19575149991 | 98 | 288 | 571 | 34 | 10 | 2024-04-23 | 445.41 | 11.14 | 2024-04-11 | 1 | 461.44 | 1 | 445.41 | 3 | SO61175 | 2024-04-18 | 35.63 | 461.44 | 445.41 | |||
SO63170_18 | 9588-481B-B3 | PO957184615 | 98 | 288 | 471 | 376 | 10 | 2024-05-24 | 190.50 | 4.76 | 2024-05-12 | 5 | 23.75 | 1 | 190.50 | 18 | SO63170 | 2024-05-19 | 15.24 | 118.75 | 38.10 | |||
SO69456_44 | CCD9-4C53-AB | PO957172965 | 98 | 288 | 359 | 376 | 10 | 2024-08-22 | 4130.98 | 103.27 | 2024-08-10 | 3 | 1251.98 | 1 | 4130.98 | 44 | SO69456 | 2024-08-17 | 330.48 | 3755.94 | 1376.99 | |||
SO69558_30 | 0B27-4F3C-97 | PO8642129578 | 98 | 288 | 494 | 520 | 10 | 2024-08-22 | 602.35 | 15.06 | 2024-08-10 | 1 | 601.74 | 1 | 602.35 | 30 | SO69558 | 2024-08-17 | 48.19 | 601.74 | 602.35 | |||
SO49891_36 | 78CA-4790-95 | PO8410166354 | 98 | 288 | 265 | 538 | 10 | 2023-07-23 | 404.66 | 10.12 | 2023-07-11 | 2 | 187.16 | 1 | 404.66 | 36 | SO49891 | 2023-07-18 | 32.37 | 374.31 | 202.33 | |||
SO58959_30 | 1330-4B17-AF | PO10353115061 | 98 | 288 | 524 | 88 | 10 | 2024-03-23 | 316.86 | 7.92 | 2024-03-11 | 2 | 144.59 | 1 | 316.86 | 30 | SO58959 | 2024-03-18 | 25.35 | 289.19 | 158.43 | |||
SO53562_30 | 9FC2-4D08-A7 | PO8468156175 | 98 | 288 | 604 | 16 | 10 | 2023-12-23 | 971.98 | 24.30 | 2023-12-11 | 3 | 343.65 | 1 | 971.98 | 30 | SO53562 | 2023-12-18 | 77.76 | 1030.95 | 323.99 | |||
SO50722_15 | 126E-410B-A5 | PO8468186428 | 98 | 290 | 263 | 16 | 10 | 2023-09-22 | 607.00 | 15.17 | 2023-09-10 | 3 | 187.16 | 1 | 607.00 | 15 | SO50722 | 2023-09-17 | 48.56 | 561.47 | 202.33 | |||
SO53573_18 | F674-4899-B9 | PO8671117198 | 98 | 288 | 525 | 502 | 10 | 2023-12-23 | 633.72 | 15.84 | 2023-12-11 | 4 | 144.59 | 1 | 633.72 | 18 | SO53573 | 2023-12-18 | 50.70 | 578.38 | 158.43 | |||
SO51083_6 | 742D-4BE9-A5 | PO696130231 | 98 | 288 | 214 | 11 | 232 | 10 | 2.36 | 2023-10-22 | 15.75 | 0.33 | 2023-10-10 | 1 | 13.09 | 1 | 13.38 | 6 | SO51083 | 2023-10-17 | 1.07 | 13.09 | 15.75 | 0.15 |
SO51815_10 | 9899-4418-B8 | PO8729139087 | 98 | 290 | 576 | 556 | 10 | 2023-11-22 | 2860.88 | 71.52 | 2023-11-10 | 2 | 1481.94 | 1 | 2860.88 | 10 | SO51815 | 2023-11-17 | 228.87 | 2963.88 | 1430.44 | |||
SO71784_7 | B186-4413-B4 | PO19285135919 | 98 | 288 | 566 | 448 | 10 | 2024-09-22 | 445.41 | 11.14 | 2024-09-10 | 1 | 461.44 | 1 | 445.41 | 7 | SO71784 | 2024-09-17 | 35.63 | 461.44 | 445.41 | |||
SO46669_39 | 7080-4FDD-BD | PO8410183627 | 98 | 288 | 385 | 538 | 10 | 2022-10-22 | 600.26 | 15.01 | 2022-10-10 | 1 | 605.65 | 1 | 600.26 | 39 | SO46669 | 2022-10-17 | 48.02 | 605.65 | 600.26 | |||
SO55270_2 | F26D-4C3A-88 | PO696117622 | 98 | 288 | 225 | 232 | 10 | 2024-01-22 | 37.76 | 0.94 | 2024-01-10 | 7 | 6.92 | 1 | 37.76 | 2 | SO55270 | 2024-01-17 | 3.02 | 48.46 | 5.39 | |||
SO49862_3 | 61B7-41AA-B2 | PO14355148051 | 98 | 288 | 343 | 286 | 10 | 2023-07-23 | 939.59 | 23.49 | 2023-07-11 | 2 | 486.71 | 1 | 939.59 | 3 | SO49862 | 2023-07-18 | 75.17 | 973.41 | 469.79 | |||
SO57083_34 | 37CC-47DA-BC | PO1508182511 | 98 | 288 | 222 | 430 | 10 | 2024-02-22 | 83.98 | 2.10 | 2024-02-10 | 4 | 13.09 | 1 | 83.98 | 34 | SO57083 | 2024-02-17 | 6.72 | 52.35 | 20.99 | |||
SO59063_15 | 81BA-420E-80 | PO8468196044 | 98 | 288 | 465 | 16 | 10 | 2024-03-23 | 58.78 | 1.47 | 2024-03-11 | 4 | 9.16 | 1 | 58.78 | 15 | SO59063 | 2024-03-18 | 4.70 | 36.64 | 14.69 | |||
SO59063_30 | 81BA-420E-80 | PO8468196044 | 98 | 288 | 605 | 16 | 10 | 2024-03-23 | 647.99 | 16.20 | 2024-03-11 | 2 | 343.65 | 1 | 647.99 | 30 | SO59063 | 2024-03-18 | 51.84 | 687.30 | 323.99 | |||
SO48399_2 | 6F99-4A8C-8E | PO10295180528 | 98 | 288 | 358 | 322 | 10 | 2023-03-24 | 1229.46 | 30.74 | 2023-03-12 | 1 | 1105.81 | 1 | 1229.46 | 2 | SO48399 | 2023-03-19 | 98.36 | 1105.81 | 1229.46 | |||
SO51143_17 | 5AF9-4974-90 | PO8410118711 | 98 | 288 | 376 | 538 | 10 | 2023-10-22 | 1466.01 | 36.65 | 2023-10-10 | 1 | 1554.95 | 1 | 1466.01 | 17 | SO51143 | 2023-10-17 | 117.28 | 1554.95 | 1466.01 | |||
SO57018_1 | 0B70-430B-BC | PO19053173016 | 98 | 288 | 560 | 178 | 10 | 2024-02-22 | 1457.82 | 36.45 | 2024-02-10 | 2 | 755.15 | 1 | 1457.82 | 1 | SO57018 | 2024-02-17 | 116.63 | 1510.30 | 728.91 | |||
SO71832_15 | 269D-4F59-82 | PO10353140756 | 98 | 288 | 511 | 88 | 10 | 2024-09-22 | 1092.27 | 27.31 | 2024-09-10 | 5 | 199.38 | 1 | 1092.27 | 15 | SO71832 | 2024-09-17 | 87.38 | 996.88 | 218.45 | |||
SO53495_2 | 8AC6-488E-B4 | PO13050166548 | 98 | 288 | 580 | 160 | 10 | 2023-12-23 | 4082.38 | 102.06 | 2023-12-11 | 4 | 1082.51 | 1 | 4082.38 | 2 | SO53495 | 2023-12-18 | 326.59 | 4330.04 | 1020.59 | |||
SO51084_24 | 3C77-43D1-83 | PO19575195218 | 98 | 288 | 576 | 34 | 10 | 2023-10-22 | 1430.44 | 35.76 | 2023-10-10 | 1 | 1481.94 | 1 | 1430.44 | 24 | SO51084 | 2023-10-17 | 114.44 | 1481.94 | 1430.44 | |||
SO69456_34 | CCD9-4C53-AB | PO957172965 | 98 | 288 | 515 | 376 | 10 | 2024-08-22 | 32.54 | 0.81 | 2024-08-10 | 2 | 12.04 | 1 | 32.54 | 34 | SO69456 | 2024-08-17 | 2.60 | 24.08 | 16.27 | |||
SO51771_10 | F78B-4D68-8E | PO1508157846 | 98 | 288 | 234 | 430 | 10 | 2023-11-22 | 209.96 | 5.25 | 2023-11-10 | 7 | 38.49 | 1 | 209.96 | 10 | SO51771 | 2023-11-17 | 16.80 | 269.45 | 29.99 | |||
SO67308_4 | B524-4A52-98 | PO14355172166 | 98 | 288 | 234 | 286 | 10 | 2024-07-23 | 119.98 | 3.00 | 2024-07-11 | 4 | 38.49 | 1 | 119.98 | 4 | SO67308 | 2024-07-18 | 9.60 | 153.97 | 29.99 | |||
SO69461_12 | F8C1-4A85-91 | PO1508119064 | 98 | 288 | 384 | 430 | 10 | 2024-08-22 | 672.29 | 16.81 | 2024-08-10 | 1 | 713.08 | 1 | 672.29 | 12 | SO69461 | 2024-08-17 | 53.78 | 713.08 | 672.29 | |||
SO69456_1 | CCD9-4C53-AB | PO957172965 | 98 | 288 | 490 | 376 | 10 | 2024-08-22 | 161.97 | 4.05 | 2024-08-10 | 5 | 41.57 | 1 | 161.97 | 1 | SO69456 | 2024-08-17 | 12.96 | 207.86 | 32.39 | |||
SO69554_12 | 7525-4F6A-93 | PO8584128240 | 98 | 288 | 583 | 592 | 10 | 2024-08-22 | 2041.19 | 51.03 | 2024-08-10 | 2 | 1082.51 | 1 | 2041.19 | 12 | SO69554 | 2024-08-17 | 163.30 | 2165.02 | 1020.59 |
Generated 2024-11-09 22:40:38.351 UTC