biuan SAP® BUSINESS ONE SDK
API OMIV
OMIV - A/P Monthly Invoice Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Entry KEY UNIQUEInternal KeyInt
11
PRIMARYYes
Number KEY UNIQUEMonthly Invoice NumberInt
11
NumberYes
DateIssued DateDate
8
BPCodeVendor CodenVarChar
15
BPNameVendor NamenVarChar
100
CurrencyCurrencynVarChar
3
LastBilledLast BilledNum
20
PaidPaid in the PeriodNum
20
CarryForwCarry ForwardNum
20
CurAmountCurrent AmountNum
20
BillAmountBilling AmountNum
20
OBPaidOB Paid in this PeriodNum
20
OBLstJENumOB Last JE Num in the PeriodInt
11
PredecesThe Former MI NumInt
11
SuccessorThe Latter MI NumInt
11
SeriesSeriesInt
6
CancelledIs CanceledVarChar
N)
Y)
1
N

SELECT statement

SELECT OMIV.Entry AS 'Internal Key', OMIV.Number AS 'Monthly Invoice Number', OMIV.Date AS 'Issued Date', OMIV.BPCode AS 'Vendor Code', OMIV.BPName AS 'Vendor Name', OMIV.Currency AS 'Currency', OMIV.LastBilled AS 'Last Billed', OMIV.Paid AS 'Paid in the Period', OMIV.CarryForw AS 'Carry Forward', OMIV.CurAmount AS 'Current Amount', OMIV.BillAmount AS 'Billing Amount', OMIV.OBPaid AS 'OB Paid in this Period', OMIV.OBLstJENum AS 'OB Last JE Num in the Period', OMIV.Predeces AS 'The Former MI Num', OMIV.Successor AS 'The Latter MI Num', OMIV.Series AS 'Series', OMIV.Cancelled AS 'Is Canceled' FROM OMIV AS OMIV

Related information


OMIV SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates