[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SKIP 0 < SKIP 3765 > < TAKE 30 >
30 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51113_15 | C890-4CA6-90 | PO11136135505 | 19 | 284 | 573 | 120 | 6 | 2023-09-01 | 1430.44 | 35.76 | 2023-08-20 | 1 | 1481.94 | 1 | 1430.44 | 15 | SO51113 | 2023-08-27 | 114.44 | 1481.94 | 1430.44 | |||
SO51113_16 | C890-4CA6-90 | PO11136135505 | 19 | 284 | 523 | 120 | 6 | 2023-09-01 | 31.58 | 0.79 | 2023-08-20 | 1 | 23.37 | 1 | 31.58 | 16 | SO51113 | 2023-08-27 | 2.53 | 23.37 | 31.58 | |||
SO51113_17 | C890-4CA6-90 | PO11136135505 | 19 | 284 | 231 | 120 | 6 | 2023-09-01 | 29.99 | 0.75 | 2023-08-20 | 1 | 38.49 | 1 | 29.99 | 17 | SO51113 | 2023-08-27 | 2.40 | 38.49 | 29.99 | |||
SO51113_18 | C890-4CA6-90 | PO11136135505 | 19 | 284 | 565 | 13 | 120 | 6 | 50.11 | 2023-09-01 | 334.06 | 7.10 | 2023-08-20 | 1 | 461.44 | 1 | 283.95 | 18 | SO51113 | 2023-08-27 | 22.72 | 461.44 | 334.06 | 0.15 |
SO51113_19 | C890-4CA6-90 | PO11136135505 | 19 | 284 | 568 | 13 | 120 | 6 | 50.11 | 2023-09-01 | 334.06 | 7.10 | 2023-08-20 | 1 | 461.44 | 1 | 283.95 | 19 | SO51113 | 2023-08-27 | 22.72 | 461.44 | 334.06 | 0.15 |
SO51114_1 | 27F4-4785-B5 | PO11049111057 | 19 | 284 | 384 | 679 | 6 | 2023-09-01 | 672.29 | 16.81 | 2023-08-20 | 1 | 713.08 | 1 | 672.29 | 1 | SO51114 | 2023-08-27 | 53.78 | 713.08 | 672.29 | |||
SO51116_1 | B371-45B5-B0 | PO10527115387 | 19 | 284 | 490 | 480 | 6 | 2023-09-01 | 194.36 | 4.86 | 2023-08-20 | 6 | 41.57 | 1 | 194.36 | 1 | SO51116 | 2023-08-27 | 15.55 | 249.43 | 32.39 | |||
SO51116_2 | B371-45B5-B0 | PO10527115387 | 19 | 284 | 214 | 11 | 480 | 6 | 14.17 | 2023-09-01 | 94.47 | 2.01 | 2023-08-20 | 6 | 13.09 | 1 | 80.30 | 2 | SO51116 | 2023-08-27 | 6.42 | 78.52 | 15.75 | 0.15 |
SO51116_3 | B371-45B5-B0 | PO10527115387 | 19 | 284 | 472 | 480 | 6 | 2023-09-01 | 152.40 | 3.81 | 2023-08-20 | 4 | 23.75 | 1 | 152.40 | 3 | SO51116 | 2023-08-27 | 12.19 | 95.00 | 38.10 | |||
SO51116_4 | B371-45B5-B0 | PO10527115387 | 19 | 284 | 231 | 480 | 6 | 2023-09-01 | 89.98 | 2.25 | 2023-08-20 | 3 | 38.49 | 1 | 89.98 | 4 | SO51116 | 2023-08-27 | 7.20 | 115.48 | 29.99 | |||
SO51116_5 | B371-45B5-B0 | PO10527115387 | 19 | 284 | 222 | 11 | 480 | 6 | 14.17 | 2023-09-01 | 94.47 | 2.01 | 2023-08-20 | 6 | 13.09 | 1 | 80.30 | 5 | SO51116 | 2023-08-27 | 6.42 | 78.52 | 15.75 | 0.15 |
SO46622_5 | 1009-4D99-85 | PO13862155069 | 19 | 291 | 358 | 119 | 6 | 2022-09-01 | 2458.92 | 61.47 | 2022-08-20 | 2 | 1105.81 | 1 | 2458.92 | 5 | SO46622 | 2022-08-27 | 196.71 | 2211.62 | 1229.46 | |||
SO46622_6 | 1009-4D99-85 | PO13862155069 | 19 | 291 | 469 | 2 | 119 | 6 | 5.29 | 2022-09-01 | 264.41 | 6.48 | 2022-08-20 | 12 | 15.67 | 1 | 259.12 | 6 | SO46622 | 2022-08-27 | 20.73 | 188.05 | 22.03 | 0.02 |
SO46622_7 | 1009-4D99-85 | PO13862155069 | 19 | 291 | 428 | 119 | 6 | 2022-09-01 | 837.02 | 20.93 | 2022-08-20 | 4 | 185.82 | 1 | 837.02 | 7 | SO46622 | 2022-08-27 | 66.96 | 743.28 | 209.26 | |||
SO46622_8 | 1009-4D99-85 | PO13862155069 | 19 | 291 | 352 | 119 | 6 | 2022-09-01 | 9942.81 | 248.57 | 2022-08-20 | 8 | 1117.86 | 1 | 9942.81 | 8 | SO46622 | 2022-08-27 | 795.43 | 8942.85 | 1242.85 | |||
SO46622_9 | 1009-4D99-85 | PO13862155069 | 19 | 291 | 470 | 4 | 119 | 6 | 51.29 | 2022-09-01 | 512.87 | 11.54 | 2022-08-20 | 27 | 15.67 | 1 | 461.58 | 9 | SO46622 | 2022-08-27 | 36.93 | 423.11 | 19.00 | 0.10 |
SO46622_10 | 1009-4D99-85 | PO13862155069 | 19 | 291 | 411 | 119 | 6 | 2022-09-01 | 250.83 | 6.27 | 2022-08-20 | 2 | 92.81 | 1 | 250.83 | 10 | SO46622 | 2022-08-27 | 20.07 | 185.61 | 125.42 | |||
SO46622_11 | 1009-4D99-85 | PO13862155069 | 19 | 291 | 364 | 119 | 6 | 2022-09-01 | 3887.96 | 97.20 | 2022-08-20 | 6 | 598.44 | 1 | 3887.96 | 11 | SO46622 | 2022-08-27 | 311.04 | 3590.61 | 647.99 | |||
SO46622_12 | 1009-4D99-85 | PO13862155069 | 19 | 291 | 356 | 119 | 6 | 2022-09-01 | 3728.56 | 93.21 | 2022-08-20 | 3 | 1117.86 | 1 | 3728.56 | 12 | SO46622 | 2022-08-27 | 298.28 | 3353.57 | 1242.85 | |||
SO46622_13 | 1009-4D99-85 | PO13862155069 | 19 | 291 | 360 | 119 | 6 | 2022-09-01 | 1229.46 | 30.74 | 2022-08-20 | 1 | 1105.81 | 1 | 1229.46 | 13 | SO46622 | 2022-08-27 | 98.36 | 1105.81 | 1229.46 | |||
SO46622_14 | 1009-4D99-85 | PO13862155069 | 19 | 291 | 427 | 119 | 6 | 2022-09-01 | 209.26 | 5.23 | 2022-08-20 | 1 | 185.82 | 1 | 209.26 | 14 | SO46622 | 2022-08-27 | 16.74 | 185.82 | 209.26 | |||
SO46622_15 | 1009-4D99-85 | PO13862155069 | 19 | 291 | 366 | 119 | 6 | 2022-09-01 | 3887.96 | 97.20 | 2022-08-20 | 6 | 598.44 | 1 | 3887.96 | 15 | SO46622 | 2022-08-27 | 311.04 | 3590.61 | 647.99 | |||
SO46622_16 | 1009-4D99-85 | PO13862155069 | 19 | 291 | 419 | 119 | 6 | 2022-09-01 | 157.94 | 3.95 | 2022-08-20 | 3 | 38.96 | 1 | 157.94 | 16 | SO46622 | 2022-08-27 | 12.64 | 116.88 | 52.65 | |||
SO46622_17 | 1009-4D99-85 | PO13862155069 | 19 | 291 | 365 | 119 | 6 | 2022-09-01 | 1943.98 | 48.60 | 2022-08-20 | 3 | 598.44 | 1 | 1943.98 | 17 | SO46622 | 2022-08-27 | 155.52 | 1795.31 | 647.99 | |||
SO46622_18 | 1009-4D99-85 | PO13862155069 | 19 | 291 | 354 | 119 | 6 | 2022-09-01 | 4971.41 | 124.29 | 2022-08-20 | 4 | 1117.86 | 1 | 4971.41 | 18 | SO46622 | 2022-08-27 | 397.71 | 4471.42 | 1242.85 | |||
SO46622_19 | 1009-4D99-85 | PO13862155069 | 19 | 291 | 468 | 119 | 6 | 2022-09-01 | 22.79 | 0.57 | 2022-08-20 | 1 | 15.67 | 1 | 22.79 | 19 | SO46622 | 2022-08-27 | 1.82 | 15.67 | 22.79 | |||
SO46622_20 | 1009-4D99-85 | PO13862155069 | 19 | 291 | 399 | 119 | 6 | 2022-09-01 | 67.55 | 1.69 | 2022-08-20 | 2 | 24.99 | 1 | 67.55 | 20 | SO46622 | 2022-08-27 | 5.40 | 49.99 | 33.77 | |||
SO46632_1 | F4B8-4BCF-81 | PO11078120656 | 19 | 284 | 397 | 246 | 6 | 2022-09-01 | 24.29 | 0.61 | 2022-08-20 | 1 | 17.98 | 1 | 24.29 | 1 | SO46632 | 2022-08-27 | 1.94 | 17.98 | 24.29 | |||
SO46639_1 | 7CDF-4BF8-8E | PO10527141970 | 19 | 284 | 343 | 480 | 6 | 2022-09-01 | 469.79 | 11.74 | 2022-08-20 | 1 | 486.71 | 1 | 469.79 | 1 | SO46639 | 2022-08-27 | 37.58 | 486.71 | 469.79 | |||
SO46639_2 | 7CDF-4BF8-8E | PO10527141970 | 19 | 284 | 433 | 480 | 6 | 2022-09-01 | 973.36 | 24.33 | 2022-08-20 | 3 | 300.12 | 1 | 973.36 | 2 | SO46639 | 2022-08-27 | 77.87 | 900.36 | 324.45 |
Generated 2024-09-20 01:30:49.425 UTC