A list of sales invoice lines.
View Name: vw_KPISaleLines
Filter: Sales Invoice Status R (released) or V (revising)
Features: Company, Business Unit
Transactional: Yes, by SIDate
| Field | Type | Description |
|---|---|---|
| SINo | int | Sales Invoice Number |
| SILine | smallint | Line Number |
| CompCode | varchar | Company Code |
| CustCode | varchar | Customer Code |
| CustName | varchar | Customer Name |
| BUnit | varchar | Business Unit Code |
| BUnitName | varchar | Business Unit Name |
| SIDate | datetime | Sales Invoice Date |
| LineAmt | decimal | Line Amount (no tax) |
| PartNo | varchar | Item Number |
| ItemDes | varchar | Item Description |
| ProdFam | varchar | Product Family |
| ProdFamName | varchar | Product Family Name |
