|
|
SAP Business One SDK 10.0 - Database Tables Reference |
A/P Monthly Invoice - Document
Table Name: MIV1
Table Description: A/P Monthly Invoice - Document
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| MinvNum | Monthly Invoice Number | Int | 11 | - | Â | Â | Â |
| AbsEntry | Internal Key | Int | 11 | - | Â | Â | Â |
| DocNum | Document Number | Int | 11 | - | Â | Â | Â |
| DocType | Document Object ID | nVarChar | 20 | - | Â | 18 | A/P Invoice |
| Â | Â | Â | Â | Â | Â | 19 | A/P Credit Memo |
| DocDate | Document Posting Date | Date | 8 | - | Â | Â | Â |
| DocDueDate | Document Due Date | Date | 8 | - | Â | Â | Â |
| DocClsDate | Document Closing Date | Date | 8 | - | Â | Â | Â |
| DocAmount | Total Amount | Num | 19.6 | - | Â | Â | Â |
| DocExpense | Document Expense | Num | 19.6 | - | Â | Â | Â |
| DocDiscSum | Document Discount Sum | Num | 19.6 | - | Â | Â | Â |
| DocRound | Document Rounding | Num | 19.6 | - | Â | Â | Â |
| DocTax | Document Tax Amount | Num | 19.6 | - | Â | Â | Â |
| Closed | Is Document closed in MI | VarChar | 1 | - | N | Y | Closed |
| Â | Â | Â | Â | Â | Â | N | Not Closed |
| MINumWnCls | absEntry when doc closed | Int | 11 | - | Â | Â | Â |
| Entry | Monthly Invoice Entry | Int | 11 | OMIV | Â | Â | Â |
| DocOrigin | Document Origin | VarChar | 1 | - | M | M | Manual |
| Â | Â | Â | Â | Â | Â | A | Automatic |
| Key | Unique | Field |
| PRIMARY | Yes | Entry |
| Â | Â | DocType |
| Â | Â | AbsEntry |