FOURA™ Reference Documentation
In This Topic
KPI Sales Invoice Lines
In This Topic

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
See Also

Dashboards