| Column Name | Data Type | Is Key | Short description |
| ProductKey | int | | Key to Product dimension |
| CustomerKey | int | | Key to Customer dimension |
| OrderDateKey | int | | Key to Date dim |
| DueDateKey | int | | Key to Date dim |
| OrderInfoKey | smallint | | Key to OrderInfo dimension |
| PromotionKey | smallint | | Key to Promotion dimension |
| CurrencyKey | smallint | | Key to Currency dim |
| SalesRepKey | int | | Key to Employee dimension |
| InsertAuditKey | int | | Key to Audit dimension for row insertion |
| UpdateAuditKey | int | | Key to Audit dim for row last updated |
| SalesOrderNum | int | | Sales order number from trxn system |
| SalesOrderLineNum | int | | Sales order line number |
| SalesOrderRevisionNum | tinyint | | Sales order revision number |
| OrderQty | smallint | | Quantity of this item in this order |
| UnitPriceUSD | money | | Standard price for this item |
| ExtendedAmtUSD | money | | Price * Quantity |
| UnitPriceDiscountPct | float | | Discount % applied to this line item in this order, if any |
| DiscountUSD | money | | Discount in US Dollars |
| ProductStdCostUSD | money | | Product's cost of goods sold |
| TotalProductCostUSD | money | | COGS * Quantity |
| SalesAmtUSD | money | | ExtendedAmt adjusted for discounts (LineTotal from the trxn system) |
| SalesAmtLocal | money | | Sales Amount, in local currency |
| TaxUSD | money | | Tax Amount, prorated across items in the order |
| TaxLocal | money | | Tax Amount, in local currency |
| FreightUSD | money | | Freight Amount, prorated across items in the order |
| FreightLocal | money | | Freight Amount, in local currency |
| CustomerPONum | varchar | | Purchase Order Number from the transaction system |