biuan SAP® BUSINESS ONE SDK
SQL Marketing Documents and Receipts / A/P Monthly Invoice - Document
API MIV1
MIV1 - A/P Monthly Invoice - Document Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
MinvNumMonthly Invoice NumberInt
11
AbsEntryInternal KeyInt
11
DocNumDocument NumberInt
11
DocTypeDocument Object IDnVarChar
18) A/P Invoice
19) A/P Credit Memo
20
DocDateDocument Posting DateDate
8
DocDueDateDocument Due DateDate
8
DocClsDateDocument Closing DateDate
8
DocAmountTotal AmountNum
20
DocExpenseDocument ExpenseNum
20
DocDiscSumDocument Discount SumNum
20
DocRoundDocument RoundingNum
20
DocTaxDocument Tax AmountNum
20
ClosedIs Document closed in MIVarChar
Y) Closed
N) Not Closed
1
N
MINumWnClsabsEntry when doc closedInt
11
Entry KEY UNIQUEMonthly Invoice EntryInt
11OMIV
A/P Monthly Invoice		PRIMARYYes

SELECT statement

SELECT MIV1.MinvNum AS 'Monthly Invoice Number', MIV1.AbsEntry AS 'Internal Key', MIV1.DocNum AS 'Document Number', MIV1.DocType AS 'Document Object ID', MIV1.DocDate AS 'Document Posting Date', MIV1.DocDueDate AS 'Document Due Date', MIV1.DocClsDate AS 'Document Closing Date', MIV1.DocAmount AS 'Total Amount', MIV1.DocExpense AS 'Document Expense', MIV1.DocDiscSum AS 'Document Discount Sum', MIV1.DocRound AS 'Document Rounding', MIV1.DocTax AS 'Document Tax Amount', MIV1.Closed AS 'Is Document closed in MI', MIV1.MINumWnCls AS 'absEntry when doc closed', MIV1.Entry AS 'Monthly Invoice Entry' FROM MIV1 AS MIV1

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