biuan SAP® BUSINESS ONE SDK
API MIN1
MIN1 - Monthly Invoice Report Document Information Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
MinvNumMonthly Invoice NumberInt
11
AbsEntryDocument Internal IDInt
11
DocNumDocument NumberInt
11
DocTypeDocument Object IDnVarChar
13) A/R Invoice
14) A/R 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
ClosedDocument Closed?VarChar
Y)
N)
1
N
MINumWnClsInternal Number for Closed DocumentInt
11
Entry KEY UNIQUEMonthly Invoice EntryInt
11OMIN
A/R Monthly Invoice
PRIMARYYes

SELECT statement

SELECT MIN1.MinvNum AS 'Monthly Invoice Number', MIN1.AbsEntry AS 'Document Internal ID', MIN1.DocNum AS 'Document Number', MIN1.DocType AS 'Document Object ID', MIN1.DocDate AS 'Document Posting Date', MIN1.DocDueDate AS 'Document Due Date', MIN1.DocClsDate AS 'Document Closing Date', MIN1.DocAmount AS 'Total Amount', MIN1.DocExpense AS 'Document Expense', MIN1.DocDiscSum AS 'Document Discount Sum', MIN1.DocRound AS 'Document Rounding', MIN1.DocTax AS 'Document Tax Amount', MIN1.Closed AS 'Document Closed?', MIN1.MINumWnCls AS 'Internal Number for Closed Document', MIN1.Entry AS 'Monthly Invoice Entry' FROM MIN1 AS MIN1

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