biuan SAP® BUSINESS ONE SDK
API PMV8
PMV8 - Incoming Payment - TDS Entries Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocNum KEY UNIQUEDocument NumberInt
11ORCT
Incoming Payment
PRIMARYYes
LineNumRow NumberInt
11
InvType KEYInvoice CategorynVarChar
20
INVOICENo
DocEntryInvoice Internal IDInt
11
DocLineInvoice Row NumberInt
11
ObjectTypeObject TypenVarChar
20ADP1
Object Settings - History
24
LogInstancLog InstanceInt
11
0

Table relationship map

SELECT statement

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

Related information


Incoming Payment ORCT 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