biuan SAP® BUSINESS ONE SDK
SQL Banking / Payment - VAT Adjustment
API PMN5
PMN5 - Payment - VAT Adjustment Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocNum KEY UNIQUEDocument NumberInt
11OPMN
PRIMARYYes
InvEntryInvoice No.Int
11
LineNumRow NumberInt
11
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History		24
LogInstancLog InstanceInt
11
0
VatGroupTax GroupnVarChar
8OVTG
Tax Definition
VatPrcntTax %Num
20
VatSumTax AmountNum
20
BaseSumBase AmountNum
20
NoDedSumNondeductible AmountNum
20
BaseSumFcBase Amount (FC)Num
20
VatSumFcTax Amount (FC)Num
20
NoDedSumFcNondeductible Amount (FC)Num
20
BaseSumScBase Amount (SC)Num
20
NoDedSumScNondeductible Amount (SC)Num
20
VatSumScVAT Amount (SC)Num
20
CashDiscAcCash Discount AccountnVarChar
15
BaseObjArrBase Object Array NumberInt
6
1
BaseObjBase ObjectInt
11
13
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 PMN5.DocNum AS 'Document Number', PMN5.InvEntry AS 'Invoice No.', PMN5.LineNum AS 'Row Number', PMN5.ObjType AS 'Object Type', PMN5.LogInstanc AS 'Log Instance', PMN5.VatGroup AS 'Tax Group', PMN5.VatPrcnt AS 'Tax %', PMN5.VatSum AS 'Tax Amount', PMN5.BaseSum AS 'Base Amount', PMN5.NoDedSum AS 'Nondeductible Amount', PMN5.BaseSumFc AS 'Base Amount (FC)', PMN5.VatSumFc AS 'Tax Amount (FC)', PMN5.NoDedSumFc AS 'Nondeductible Amount (FC)', PMN5.BaseSumSc AS 'Base Amount (SC)', PMN5.NoDedSumSc AS 'Nondeductible Amount (SC)', PMN5.VatSumSc AS 'VAT Amount (SC)', PMN5.CashDiscAc AS 'Cash Discount Account', PMN5.BaseObjArr AS 'Base Object Array Number', PMN5.BaseObj AS 'Base Object', PMN5.InstlmntId AS 'Installment ID', PMN5.GroupNum AS 'Group Number', PMN5.LineSeq AS 'Row Sequence', PMN5.EquVatPer AS 'Equalization Tax %', PMN5.EquVatSum AS 'Total Equalization Tax', PMN5.EquVatSumF AS 'Total Equalization Tax (FC)', PMN5.EquVatSumS AS 'Total Equalization Tax (SC)' FROM PMN5 AS PMN5

Related information


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