[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SKIP 0 < SKIP 30 > < TAKE 7 >
7 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51108_6 | 8650-4A20-B1 | PO12644151814 | 100 | 285 | 512 | 530 | 5 | 2023-09-03 | 436.91 | 10.92 | 2023-08-22 | 2 | 199.38 | 1 | 436.91 | 6 | SO51108 | 2023-08-29 | 34.95 | 398.75 | 218.45 | |||
SO58971_7 | 319A-4CAC-B1 | PO1537134870 | 100 | 285 | 491 | 611 | 5 | 2024-02-03 | 64.79 | 1.62 | 2024-01-22 | 2 | 41.57 | 1 | 64.79 | 7 | SO58971 | 2024-01-29 | 5.18 | 83.14 | 32.39 | |||
SO43659_9 | 4911-403C-98 | PO522145787 | 100 | 285 | 235 | 676 | 5 | 2021-09-03 | 28.84 | 0.72 | 2021-08-22 | 1 | 31.72 | 1 | 28.84 | 9 | SO43659 | 2021-08-29 | 2.31 | 31.72 | 28.84 | |||
SO47455_16 | 41F3-48C2-B7 | PO9599169586 | 100 | 285 | 337 | 170 | 5 | 2022-11-04 | 1879.18 | 46.98 | 2022-10-23 | 4 | 486.71 | 1 | 1879.18 | 16 | SO47455 | 2022-10-30 | 150.33 | 1946.83 | 469.79 | |||
SO51108_7 | 8650-4A20-B1 | PO12644151814 | 100 | 285 | 525 | 530 | 5 | 2023-09-03 | 316.86 | 7.92 | 2023-08-22 | 2 | 144.59 | 1 | 316.86 | 7 | SO51108 | 2023-08-29 | 25.35 | 289.19 | 158.43 | |||
SO58971_8 | 319A-4CAC-B1 | PO1537134870 | 100 | 285 | 484 | 2 | 611 | 5 | 1.11 | 2024-02-03 | 55.33 | 1.36 | 2024-01-22 | 12 | 2.97 | 1 | 54.23 | 8 | SO58971 | 2024-01-29 | 4.34 | 35.68 | 4.61 | 0.02 |
SO43659_10 | 4911-403C-98 | PO522145787 | 100 | 285 | 218 | 676 | 5 | 2021-09-03 | 34.20 | 0.86 | 2021-08-22 | 6 | 3.40 | 1 | 34.20 | 10 | SO43659 | 2021-08-29 | 2.74 | 20.38 | 5.70 |
Generated 2024-09-21 05:36:44.415 UTC