A list of quote lines.
View Name: vw_KPIQuoteLines
Filter: Revised or Released
Features: Company, Business Unit
Transactional? Yes, by QuoteDate
| Field | Type | Description |
|---|---|---|
| QuoteNo | varchar | Quote No (primary key) |
| CompCode | varchar | Company Code |
| CustCode | varchar | Customer Code |
| CustName | varchar | Customer Name |
| QuoteDate | datetime | Quote Date |
| BUnit | varchar | Business Unit Code |
| LineNetPrice | decimal | Quote Price not including tax (LinePrice-DiscAmt) |
| PartNo | varchar | Item Number |
| ItemDes | varchar | Item Description |
| ProdFam | varchar | Product Family |
| ProdFamName | varchar | Product Family Name |
| QuoteType | varchar | Quote Type |
| ExpireDate | datetime | Quote Expiration Date |
| IsExpired | bit | 1 = Expired, 0 = Not Expired |
