|
|
SAP Business One SDK 10.0 - Database Tables Reference |
A/R Monthly Invoice
Table Name: OMIN
Table Description: A/R Monthly Invoice
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| Entry | Internal Number | Int | 11 | - | Â | Â | Â |
| Number | Monthly Invoice Number | Int | 11 | - | Â | Â | Â |
| Date | Monthly Invoice Issue Date | Date | 8 | - | Â | Â | Â |
| BPCode | BP Code of Monthly Invoice | nVarChar | 15 | - | Â | Â | Â |
| BPName | BP Name of Monthly Invoice | nVarChar | 200 | - | Â | Â | Â |
| Currency | Currency of Monthly Invoice | nVarChar | 3 | - | Â | Â | Â |
| LastBilled | Last Billed | Num | 19.6 | - | Â | Â | Â |
| Paid | Paid in the Period | Num | 19.6 | - | Â | Â | Â |
| CarryForw | Carry Balance Forward | Num | 19.6 | - | Â | Â | Â |
| CurAmount | Current Amount | Num | 19.6 | - | Â | Â | Â |
| BillAmount | Billing Amount | Num | 19.6 | - | Â | Â | Â |
| OBPaid | OB Paid in This Period | Num | 19.6 | - | Â | Â | Â |
| OBLstJENum | Last JE # for OB at Currnt Dte | Int | 11 | - | Â | Â | Â |
| Predeces | Former Monthly Invoice Number | Int | 11 | - | Â | Â | Â |
| Successor | Latter Monthly Invoice Number | Int | 11 | - | Â | Â | Â |
| Series | Series | Int | 11 | - | Â | Â | Â |
| Cancelled | is Canceled | VarChar | 1 | - | N | N | Â |
| Â | Â | Â | Â | Â | Â | Y | Â |
| Address | Bill To | nVarChar | 254 | - | Â | Â | Â |
| BPLId | Branch | Int | 11 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | Entry |