biuan SAP® BUSINESS ONE SDK
SQL Payment Draft - Account List
DTW Payment Draft - Account List
API Payments Accounts / Account Code
PDF4 - Payment Draft - Account List Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocNum KEY UNIQUEDocument NumberInt
11OPDF
Payment Draft		PRIMARYYes
LineIdRow NumberInt
11
AcctCodeAccountnVarChar
15OACT
G/L Accounts
SumAppliedPaidNum
20
AppliedFCPaid in FCNum
20
AppliedSysPaid in SCNum
20
DescripDetailsnVarChar
127
VatGroupTax DefinitionnVarChar
8OVTG
Tax Definition
VatPrcntTax RateNum
20
AcctNameAccount NamenVarChar
100
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
LogInstancLog InstanceInt
11
0
OcrCodeDistribution RulenVarChar
8OOCR
Distribution Rule
ProjectProject CodenVarChar
20OPRJ
Project Codes
GrossAmntGross AmountNum
20
GrssAmntFCGross Amount (FC)Num
20
GrssAmntSCGross Amount (SC)Num
20
AmntBaseBase AmountVarChar
E) Exclude Tax
I) Include Tax
1
VatAmntVAT AmountNum
20
VatAmntFCVAT Amount (FC)Num
20
VatAmntSCVAT Amount (SC)Num
20
UserChaVatUser Changed VATVarChar
N) No
Y) Yes
1
N
TaxTypeIDTax Type Component IDInt
11OSTT
Sales Tax Authorities Type
OcrCode2Distribution Rule2nVarChar
8OOCR
Distribution Rule
OcrCode3Distribution Rule3nVarChar
8OOCR
Distribution Rule
OcrCode4Distribution Rule4nVarChar
8OOCR
Distribution Rule
OcrCode5Distribution Rule5nVarChar
8OOCR
Distribution Rule
SectionSectionInt
11OSEC
Sections
AsseTypeAssessee TypeVarChar
C) Company
P) Others
1
LocCodeLocation CodeInt
11OLCT
Location
MatTypeMaterial TypeInt
11
0
EquVatPerEqualization Tax RateNum
20
EquVatSumEqualization VAT AmountNum
20
EquVatSumFEqualization VAT Amount (FC)Num
20
EquVatSumSEqualization VAT Amount (SC)Num
20

Table relationship map

SELECT statement

SELECT PDF4.DocNum AS 'Document Number', PDF4.LineId AS 'Row Number', PDF4.AcctCode AS 'Account', PDF4.SumApplied AS 'Paid', PDF4.AppliedFC AS 'Paid in FC', PDF4.AppliedSys AS 'Paid in SC', PDF4.Descrip AS 'Details', PDF4.VatGroup AS 'Tax Definition', PDF4.VatPrcnt AS 'Tax Rate', PDF4.AcctName AS 'Account Name', PDF4.ObjType AS 'Object Type', PDF4.LogInstanc AS 'Log Instance', PDF4.OcrCode AS 'Distribution Rule', PDF4.Project AS 'Project Code', PDF4.GrossAmnt AS 'Gross Amount', PDF4.GrssAmntFC AS 'Gross Amount (FC)', PDF4.GrssAmntSC AS 'Gross Amount (SC)', PDF4.AmntBase AS 'Base Amount', PDF4.VatAmnt AS 'VAT Amount', PDF4.VatAmntFC AS 'VAT Amount (FC)', PDF4.VatAmntSC AS 'VAT Amount (SC)', PDF4.UserChaVat AS 'User Changed VAT', PDF4.TaxTypeID AS 'Tax Type Component ID', PDF4.OcrCode2 AS 'Distribution Rule2', PDF4.OcrCode3 AS 'Distribution Rule3', PDF4.OcrCode4 AS 'Distribution Rule4', PDF4.OcrCode5 AS 'Distribution Rule5', PDF4.Section AS 'Section', PDF4.AsseType AS 'Assessee Type', PDF4.LocCode AS 'Location Code', PDF4.MatType AS 'Material Type', PDF4.EquVatPer AS 'Equalization Tax Rate', PDF4.EquVatSum AS 'Equalization VAT Amount', PDF4.EquVatSumF AS 'Equalization VAT Amount (FC)', PDF4.EquVatSumS AS 'Equalization VAT Amount (SC)' FROM PDF4 AS PDF4

Related information


Account Code AccountCode Property· Table: PDF4
Sets or returns the G/L account code of the business partner as defined in Chart of Accounts.Field name: AcctCode.Mandatory property. Length: 15 characters. This is a foreign key to the ChartOfAccounts Object.
· Table: RCT4 PDF4 VPM4    Parent: Payments Accounts Payments_Accounts Object· Table: RCT4 PDF4 VPM4
G/L Accounts OACT SQL Table

Payment Draft OPDF SQL Table

Location OLCT SQL Table

Object Settings - History ADP1 SQL Table

Distribution Rule OOCR SQL Table

Project Codes OPRJ SQL Table

Sections OSEC SQL Table

Sales Tax Authorities Type OSTT 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