biuan SAP® BUSINESS ONE SDK
SQL Banking / Outgoing Payments - Tax Amount per Document
API VPM7
VPM7 - Outgoing Payments - Tax Amount per Document Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocNum KEY UNIQUEDocument NumberInt
11OVPM
Outgoing Payments		PRIMARYYes
LineSeqRow SequenceInt
11
InvoiceSeqInvoice Sequence NumberInt
11
ValueDateDue DateDate
8
Inv4SeqINV4 Sequence NumberInt
11
TaxSumTax AmountNum
20
TaxSumFrgnTax Amount (FC)Num
20
TaxSumSysTax Amount (SC)Num
20
BaseSumBase AmountNum
20
BaseSumFrgBase Amount (FC)Num
20
BaseSumSysBase Amount (SC)Num
20
ObjectTypeObject TypenVarChar
20ADP1
Object Settings - History		46
LogInstancLog InstanceInt
11
0

Table relationship map

SELECT statement

SELECT VPM7.DocNum AS 'Document Number', VPM7.LineSeq AS 'Row Sequence', VPM7.InvoiceSeq AS 'Invoice Sequence Number', VPM7.ValueDate AS 'Due Date', VPM7.Inv4Seq AS 'INV4 Sequence Number', VPM7.TaxSum AS 'Tax Amount', VPM7.TaxSumFrgn AS 'Tax Amount (FC)', VPM7.TaxSumSys AS 'Tax Amount (SC)', VPM7.BaseSum AS 'Base Amount', VPM7.BaseSumFrg AS 'Base Amount (FC)', VPM7.BaseSumSys AS 'Base Amount (SC)', VPM7.ObjectType AS 'Object Type', VPM7.LogInstanc AS 'Log Instance' FROM VPM7 AS VPM7

Related information


Outgoing Payments OVPM SQL Table

Object Settings - History ADP1 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