[ROOT] / doc / toc / ARAdventureWorksOLAP / Enum / FactInternetSaleP
CarrierTrackingNumber , CustomerPONumber , DimCurrencyId , DimCustomerId , DimProductId , DimPromotionId , DimSalesTerritoryId , DueDate , Freight , OrderDate , SalesAmount , SalesOrderLineNumber , SalesOrderNumber , ShipDate , TaxAmt , TotalProductCost
Describes class FactInternetSale.
| CarrierTrackingNumber | |
| CustomerPONumber | |
| DimCurrencyId | Called 'CurrencyKey' in original sample database |
| DimCustomerId | Called 'CustomerKey' in original sample database |
| DimProductId | Called 'ProductKey' in original sample database |
| DimPromotionId | Called 'PromotionKey' in original sample database. Note: All instances of 'DimPromotionId = 1' (No discount) has been filtered out at import |
| DimSalesTerritoryId | Called 'SalesTerritoryKey' in original sample database. |
| DueDate | Called 'DueDateKey' in original sample database (link to DimDate) |
| Freight | |
| OrderDate | Called 'OrderDateKey' in original sample database (link to DimDate) |
| SalesAmount | |
| SalesOrderLineNumber | SalesOrderNumber plus SalesOrderLineNumber constitutes primary key of FactInternetSale |
| SalesOrderNumber | SalesOrderNumber plus SalesOrderLineNumber constitutes primary key of FactInternetSale |
| ShipDate | Called 'ShipDateKey' in original sample database (link to DimDate) |
| TaxAmt | |
| TotalProductCost |
Generated 2024-04-25 17:31:00.049 UTC