biuan SAP® BUSINESS ONE SDK
SQL Marketing Documents and Receipts / A/R Monthly Invoice
API OMIN
OMIN - A/R Monthly Invoice Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Entry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
NumberMonthly Invoice NumberInt
11
DateMonthly Invoice Issue DateDate
8
BPCodeBP Code of Monthly InvoicenVarChar
15
BPNameBP Name of Monthly InvoicenVarChar
100
CurrencyCurrency of Monthly InvoicenVarChar
3
LastBilledLast BilledNum
20
PaidPaid in the PeriodNum
20
CarryForwCarry Balance ForwardNum
20
CurAmountCurrent AmountNum
20
BillAmountBilling AmountNum
20
OBPaidOB Paid in This PeriodNum
20
OBLstJENumLast JE # for OB at Currnt DteInt
11
PredecesFormer Monthly Invoice NumberInt
11
SuccessorLatter Monthly Invoice NumberInt
11
SeriesSeriesInt
6
Cancelledis CanceledVarChar
N)
Y)
1
N

SELECT statement

SELECT OMIN.Entry AS 'Internal Number', OMIN.Number AS 'Monthly Invoice Number', OMIN.Date AS 'Monthly Invoice Issue Date', OMIN.BPCode AS 'BP Code of Monthly Invoice', OMIN.BPName AS 'BP Name of Monthly Invoice', OMIN.Currency AS 'Currency of Monthly Invoice', OMIN.LastBilled AS 'Last Billed', OMIN.Paid AS 'Paid in the Period', OMIN.CarryForw AS 'Carry Balance Forward', OMIN.CurAmount AS 'Current Amount', OMIN.BillAmount AS 'Billing Amount', OMIN.OBPaid AS 'OB Paid in This Period', OMIN.OBLstJENum AS 'Last JE # for OB at Currnt Dte', OMIN.Predeces AS 'Former Monthly Invoice Number', OMIN.Successor AS 'Latter Monthly Invoice Number', OMIN.Series AS 'Series', OMIN.Cancelled AS 'is Canceled' FROM OMIN AS OMIN

Related information


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