biuan SAP® BUSINESS ONE SDK
SQL Banking / PaymentDraft - vat adjustment
API PDF5
PDF5 - PaymentDraft - vat adjustment Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocNum KEY UNIQUEDocument NumberInt
11OPDF
Payment Draft		PRIMARYYes
InvEntryInvoice KeyInt
11
LineNumRow NumberInt
11
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
LogInstancLog InstanceInt
11
0
VatGroupTax GroupnVarChar
8OVTG
Tax Definition
VatPrcntTax %Num
20
VatSumTax AmountNum
20
BaseSumBase AmountNum
20
NoDedSumNon-Deductible AmountNum
20
BaseSumFcBase Amount FCNum
20
VatSumFcTax Amount (FC)Num
20
NoDedSumFcNon-Deductible Amount (FC)Num
20
BaseSumScBase Amount (SC)Num
20
NoDedSumScNon-Deductible Amount (SC)Num
20
VatSumScTax 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
-1
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 PDF5.DocNum AS 'Document Number', PDF5.InvEntry AS 'Invoice Key', PDF5.LineNum AS 'Row Number', PDF5.ObjType AS 'Object Type', PDF5.LogInstanc AS 'Log Instance', PDF5.VatGroup AS 'Tax Group', PDF5.VatPrcnt AS 'Tax %', PDF5.VatSum AS 'Tax Amount', PDF5.BaseSum AS 'Base Amount', PDF5.NoDedSum AS 'Non-Deductible Amount', PDF5.BaseSumFc AS 'Base Amount FC', PDF5.VatSumFc AS 'Tax Amount (FC)', PDF5.NoDedSumFc AS 'Non-Deductible Amount (FC)', PDF5.BaseSumSc AS 'Base Amount (SC)', PDF5.NoDedSumSc AS 'Non-Deductible Amount (SC)', PDF5.VatSumSc AS 'Tax Amount (SC)', PDF5.CashDiscAc AS 'Cash Discount Account', PDF5.BaseObjArr AS 'Base Object Array Number', PDF5.BaseObj AS 'Base Object', PDF5.InstlmntId AS 'Installment ID', PDF5.GroupNum AS 'Group Number', PDF5.LineSeq AS 'Row Sequence', PDF5.EquVatPer AS 'Equalization Tax %', PDF5.EquVatSum AS 'Total Equalization Tax', PDF5.EquVatSumF AS 'Total Equalization Tax (FC)', PDF5.EquVatSumS AS 'Total Equalization Tax (SC)' FROM PDF5 AS PDF5

Related information


Payment Draft OPDF 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