biuan SAP® BUSINESS ONE SDK
SQL Banking / Outgoing Payments - Vat Adjustment
API VPM5
VPM5 - Outgoing Payments - Vat Adjustment Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocNum KEY UNIQUEDocument NumberInt
11OVPM
Outgoing Payments		PRIMARYYes
InvEntryInvoice KeyInt
11
LineNumRow NumberInt
11
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History		46
LogInstancLog InstanceInt
11
0
VatGroupTax GroupnVarChar
8OVTG
Tax Definition
VatPrcntTax %Num
20
VatSumTax AmountNum
20
BaseSumBase AmountNum
20
NoDedSumNon-Deductible AmountNum
20
BaseSumFcBase Amount (FC)Num
20
VatSumFcTax Amount (FC)Num
20
NoDedSumFcNon-Deductible Amount (FC)Num
20
BaseSumScBase Amount (SC)Num
20
NoDedSumScNon-Deductible Amount (SC)Num
20
VatSumScVAT Amount (SC)Num
20
CashDiscAcCash Discount AccountnVarChar
15
BaseObjArrBase Object Array NumberInt
6
1
BaseObjBase ObjectInt
11
18
InstlmntIdInstallment IDInt
6
0
GroupNumGroup NumberInt
11
0
LineSeqRow SequenceInt
11
EquVatPerEqualization Tax %Num
20
EquVatSumTotal Equalization TaxNum
20
EquVatSumFTotal Equalization Tax (FC)Num
20
EquVatSumSTotal Equalization Tax (SC)Num
20

Table relationship map

SELECT statement

SELECT VPM5.DocNum AS 'Document Number', VPM5.InvEntry AS 'Invoice Key', VPM5.LineNum AS 'Row Number', VPM5.ObjType AS 'Object Type', VPM5.LogInstanc AS 'Log Instance', VPM5.VatGroup AS 'Tax Group', VPM5.VatPrcnt AS 'Tax %', VPM5.VatSum AS 'Tax Amount', VPM5.BaseSum AS 'Base Amount', VPM5.NoDedSum AS 'Non-Deductible Amount', VPM5.BaseSumFc AS 'Base Amount (FC)', VPM5.VatSumFc AS 'Tax Amount (FC)', VPM5.NoDedSumFc AS 'Non-Deductible Amount (FC)', VPM5.BaseSumSc AS 'Base Amount (SC)', VPM5.NoDedSumSc AS 'Non-Deductible Amount (SC)', VPM5.VatSumSc AS 'VAT Amount (SC)', VPM5.CashDiscAc AS 'Cash Discount Account', VPM5.BaseObjArr AS 'Base Object Array Number', VPM5.BaseObj AS 'Base Object', VPM5.InstlmntId AS 'Installment ID', VPM5.GroupNum AS 'Group Number', VPM5.LineSeq AS 'Row Sequence', VPM5.EquVatPer AS 'Equalization Tax %', VPM5.EquVatSum AS 'Total Equalization Tax', VPM5.EquVatSumF AS 'Total Equalization Tax (FC)', VPM5.EquVatSumS AS 'Total Equalization Tax (SC)' FROM VPM5 AS VPM5

Related information


Outgoing Payments OVPM SQL Table

Object Settings - History ADP1 SQL Table

Tax Definition OVTG 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