[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 618 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51714_25 | D33A-4EAE-B1 | PO15689195197 | 100 | 281 | 408 | 328 | 4 | 2023-10-04 | 216.49 | 5.41 | 2023-09-22 | 3 | 53.40 | 1 | 216.49 | 25 | SO51714 | 2023-09-29 | 17.32 | 160.20 | 72.16 | |||
SO51139_9 | 892A-4EAD-98 | PO7743143396 | 100 | 287 | 495 | 275 | 4 | 2023-09-03 | 3011.73 | 75.29 | 2023-08-22 | 5 | 601.74 | 1 | 3011.73 | 9 | SO51139 | 2023-08-29 | 240.94 | 3008.72 | 602.35 | |||
SO44538_7 | E495-47A9-AD | PO2523126243 | 100 | 287 | 270 | 167 | 4 | 2022-01-04 | 367.88 | 9.20 | 2021-12-23 | 2 | 181.49 | 1 | 367.88 | 7 | SO44538 | 2021-12-30 | 29.43 | 362.97 | 183.94 | |||
SO50743_10 | C1F5-4D36-9F | PO4640120853 | 100 | 287 | 469 | 2 | 648 | 4 | 5.73 | 2023-08-04 | 286.44 | 7.02 | 2023-07-23 | 13 | 15.67 | 1 | 280.72 | 10 | SO50743 | 2023-07-30 | 22.46 | 203.72 | 22.03 | 0.02 |
SO53459_13 | 9828-4F27-B0 | PO19372154638 | 100 | 282 | 222 | 582 | 4 | 2023-11-04 | 146.96 | 3.67 | 2023-10-23 | 7 | 13.09 | 1 | 146.96 | 13 | SO53459 | 2023-10-30 | 11.76 | 91.60 | 20.99 | |||
SO44120_8 | E001-437D-A1 | PO5597155510 | 100 | 283 | 346 | 75 | 4 | 2021-11-04 | 8159.98 | 204.00 | 2021-10-23 | 4 | 1912.15 | 1 | 8159.98 | 8 | SO44120 | 2021-10-30 | 652.80 | 7648.62 | 2039.99 | |||
SO45555_11 | B11A-41CE-84 | PO3248155143 | 100 | 282 | 350 | 366 | 4 | 2022-05-04 | 4049.99 | 101.25 | 2022-04-22 | 2 | 1898.09 | 1 | 4049.99 | 11 | SO45555 | 2022-04-29 | 324.00 | 3796.19 | 2024.99 | |||
SO47700_33 | 5C46-42DE-AD | PO2494132198 | 100 | 283 | 458 | 184 | 4 | 2022-12-04 | 449.94 | 11.25 | 2022-11-22 | 10 | 30.93 | 1 | 449.94 | 33 | SO47700 | 2022-11-29 | 36.00 | 309.33 | 44.99 | |||
SO50208_38 | 6993-49B4-8B | PO15689114248 | 100 | 281 | 422 | 328 | 4 | 2023-07-04 | 337.70 | 8.44 | 2023-06-22 | 5 | 49.98 | 1 | 337.70 | 38 | SO50208 | 2023-06-29 | 27.02 | 249.89 | 67.54 | |||
SO47715_7 | 88F3-4A20-BE | PO6409117675 | 100 | 283 | 327 | 292 | 4 | 2022-12-04 | 469.79 | 11.74 | 2022-11-22 | 1 | 486.71 | 1 | 469.79 | 7 | SO47715 | 2022-11-29 | 37.58 | 486.71 | 469.79 | |||
SO48758_4 | 709A-4AE0-B1 | PO13688180139 | 100 | 282 | 221 | 475 | 4 | 2023-03-06 | 80.75 | 2.02 | 2023-02-22 | 4 | 13.88 | 1 | 80.75 | 4 | SO48758 | 2023-03-01 | 6.46 | 55.51 | 20.19 | |||
SO47439_20 | D4B6-4746-BE | PO6786128920 | 100 | 283 | 459 | 3 | 4 | 2022-11-04 | 377.96 | 9.45 | 2022-10-23 | 7 | 37.12 | 1 | 377.96 | 20 | SO47439 | 2022-10-30 | 30.24 | 259.85 | 53.99 | |||
SO51106_24 | 3D96-4D27-92 | PO12528166058 | 100 | 282 | 571 | 13 | 331 | 4 | 300.65 | 2023-09-03 | 2004.35 | 42.59 | 2023-08-22 | 6 | 461.44 | 1 | 1703.69 | 24 | SO51106 | 2023-08-29 | 136.30 | 2768.67 | 334.06 | 0.15 |
SO48309_1 | 2F58-4438-98 | PO17226184242 | 100 | 283 | 325 | 561 | 4 | 2023-02-03 | 469.79 | 11.74 | 2023-01-22 | 1 | 486.71 | 1 | 469.79 | 1 | SO48309 | 2023-01-29 | 37.58 | 486.71 | 469.79 | |||
SO49076_21 | 8DE0-4335-95 | PO2523199507 | 100 | 287 | 458 | 167 | 4 | 2023-04-06 | 269.96 | 6.75 | 2023-03-25 | 6 | 30.93 | 1 | 269.96 | 21 | SO49076 | 2023-04-01 | 21.60 | 185.60 | 44.99 | |||
SO46964_32 | B3E6-43CC-A2 | PO15689139014 | 100 | 283 | 415 | 328 | 4 | 2022-10-04 | 1782.32 | 44.56 | 2022-09-22 | 9 | 146.55 | 1 | 1782.32 | 32 | SO46964 | 2022-09-29 | 142.59 | 1318.92 | 198.04 | |||
SO59068_6 | B7CC-4A9D-86 | PO9715112509 | 100 | 281 | 357 | 490 | 4 | 2024-02-03 | 6959.97 | 174.00 | 2024-01-22 | 5 | 1265.62 | 1 | 6959.97 | 6 | SO59068 | 2024-01-29 | 556.80 | 6328.10 | 1391.99 | |||
SO45532_9 | 1342-4F90-B0 | PO15834119448 | 100 | 283 | 223 | 417 | 4 | 2022-05-04 | 5.19 | 0.13 | 2022-04-22 | 1 | 5.71 | 1 | 5.19 | 9 | SO45532 | 2022-04-29 | 0.41 | 5.71 | 5.19 | |||
SO55256_10 | 686E-4D36-8B | PO12528136439 | 100 | 282 | 575 | 331 | 4 | 2023-12-04 | 1430.44 | 35.76 | 2023-11-22 | 1 | 1481.94 | 1 | 1430.44 | 10 | SO55256 | 2023-11-29 | 114.44 | 1481.94 | 1430.44 | |||
SO44564_3 | 142F-443C-90 | PO7656157194 | 100 | 282 | 312 | 403 | 4 | 2022-01-04 | 6440.89 | 161.02 | 2021-12-23 | 3 | 2171.29 | 1 | 6440.89 | 3 | SO44564 | 2021-12-30 | 515.27 | 6513.88 | 2146.96 | |||
SO44127_4 | E778-471D-8A | PO7569162058 | 100 | 287 | 304 | 608 | 4 | 2021-11-04 | 1429.41 | 35.74 | 2021-10-23 | 2 | 617.03 | 1 | 1429.41 | 4 | SO44127 | 2021-10-30 | 114.35 | 1234.06 | 714.70 | |||
SO49125_10 | D58B-4B43-AA | PO3654156335 | 100 | 281 | 358 | 435 | 4 | 2023-04-06 | 2458.92 | 61.47 | 2023-03-25 | 2 | 1105.81 | 1 | 2458.92 | 10 | SO49125 | 2023-04-01 | 196.71 | 2211.62 | 1229.46 | |||
SO51845_50 | 6AB8-4CEA-A9 | PO3799111961 | 100 | 282 | 542 | 312 | 4 | 2023-10-04 | 48.59 | 1.21 | 2023-09-22 | 2 | 17.98 | 1 | 48.59 | 50 | SO51845 | 2023-09-29 | 3.89 | 35.96 | 24.29 | |||
SO47400_23 | F0B3-44C1-8F | PO10701186775 | 100 | 282 | 294 | 133 | 4 | 2022-11-04 | 744.27 | 18.61 | 2022-10-23 | 1 | 660.91 | 1 | 744.27 | 23 | SO47400 | 2022-10-30 | 59.54 | 660.91 | 744.27 |
Generated 2024-09-21 07:50:06.077 UTC