biuan SAP® BUSINESS ONE SDK
API MIN2
MIN2 - Item Imformation of MI Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
MinvNumMonthly Invoice NumberInt
11
DocNumDocument NumberInt
11
DocTypeDocument TypenVarChar
13) A/R Invoice
14) A/R Credit Memo
20
DocDateDocument DateDate
8
LineNumRow NumberInt
11
ItemCodeItem No.nVarChar
20
ItemNameItem NamenVarChar
100
ItemPriceItem PriceNum
20
ItemCurrItem CurrencynVarChar
3
itemRateCurrency PriceNum
20
ItemQuanItem QuantityNum
20
ItemTypeItem TypeVarChar
I)
E)
D)
R)
T)
S)
P)
W)
1
I
ItemTotalItem TotalNum
20
TaxAmountTax AmountNum
20
LineTotalRow TotalNum
20
Entry KEY UNIQUEMonthly Invoice EntryInt
11OMIN
A/R Monthly Invoice
PRIMARYYes
AbsEntryDocument EntryInt
11

SELECT statement

SELECT MIN2.MinvNum AS 'Monthly Invoice Number', MIN2.DocNum AS 'Document Number', MIN2.DocType AS 'Document Type', MIN2.DocDate AS 'Document Date', MIN2.LineNum AS 'Row Number', MIN2.ItemCode AS 'Item No.', MIN2.ItemName AS 'Item Name', MIN2.ItemPrice AS 'Item Price', MIN2.ItemCurr AS 'Item Currency', MIN2.itemRate AS 'Currency Price', MIN2.ItemQuan AS 'Item Quantity', MIN2.ItemType AS 'Item Type', MIN2.ItemTotal AS 'Item Total', MIN2.TaxAmount AS 'Tax Amount', MIN2.LineTotal AS 'Row Total', MIN2.Entry AS 'Monthly Invoice Entry', MIN2.AbsEntry AS 'Document Entry' FROM MIN2 AS MIN2

Related information


A/R Monthly Invoice OMIN 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