biuan SAP® BUSINESS ONE SDK
API VPM8
VPM8 - Outgoing Payment - TDS Entries Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocNum KEY UNIQUEDocument NumberInt
11OVPM
Outgoing Payments
PRIMARYYes
LineNumRow NumberInt
11
InvType KEYInvoice CategorynVarChar
-1) All Transactions
204) A/P Down Payment
18) A/P Invoice
19) A/P Credit Memo
10000079) TDS Adjustment
20
-1INVOICENo
DocEntryInvoice Internal IDInt
11
DocLineInvoice Row NumberInt
11
ObjectTypeObject TypenVarChar
20ADP1
Object Settings - History
46
LogInstancLog InstanceInt
11
0

Table relationship map

SELECT statement

SELECT VPM8.DocNum AS 'Document Number', VPM8.LineNum AS 'Row Number', VPM8.InvType AS 'Invoice Category', VPM8.DocEntry AS 'Invoice Internal ID', VPM8.DocLine AS 'Invoice Row Number', VPM8.ObjectType AS 'Object Type', VPM8.LogInstanc AS 'Log Instance' FROM VPM8 AS VPM8

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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates