biuan SAP® BUSINESS ONE SDK
API MIV2
MIV2 - A/P Monthly Invoice - Item Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
MinvNumMonthly Invoice NumberInt
11
DocNumDocument NumberInt
11
DocTypeDocument TypenVarChar
18) A/P Invoice
19) A/P Credit Memo
20
DocDateDocument DateDate
8
LineNumLine numberInt
11
ItemCodeItem No.nVarChar
20
ItemNameItem NamenVarChar
100
ItemPriceItem PriceNum
20
ItemCurrItem CurrencynVarChar
3
ItemRateCurrency Exchange RateNum
20
ItemQuanItem QuantityNum
20
ItemTypeItem TypeVarChar
I) Item
E) Expense
R) Rounding
T) Tax Amount
S) Service
D) Down Payment Paid
W) WTax Amount
1
I
ItemTotalNet TotalNum
20
TaxAmountTax Amount of Line LevelNum
20
LineTotalGross TotalNum
20
Entry KEY UNIQUEMonthly Invoice EntryInt
11OMIV
A/P Monthly Invoice
PRIMARYYes
AbsEntryDocument EntryInt
11

SELECT statement

SELECT MIV2.MinvNum AS 'Monthly Invoice Number', MIV2.DocNum AS 'Document Number', MIV2.DocType AS 'Document Type', MIV2.DocDate AS 'Document Date', MIV2.LineNum AS 'Line number', MIV2.ItemCode AS 'Item No.', MIV2.ItemName AS 'Item Name', MIV2.ItemPrice AS 'Item Price', MIV2.ItemCurr AS 'Item Currency', MIV2.ItemRate AS 'Currency Exchange Rate', MIV2.ItemQuan AS 'Item Quantity', MIV2.ItemType AS 'Item Type', MIV2.ItemTotal AS 'Net Total', MIV2.TaxAmount AS 'Tax Amount of Line Level', MIV2.LineTotal AS 'Gross Total', MIV2.Entry AS 'Monthly Invoice Entry', MIV2.AbsEntry AS 'Document Entry' FROM MIV2 AS MIV2

Related information


A/P Monthly Invoice OMIV SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates