biuan SAP® BUSINESS ONE SDK
SQL Payment Draft - Checks
DTW Payment Draft - Checks
API Payments Checks / Accountt Num
PDF1 - Payment Draft - Checks Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocNum KEY UNIQUEDocument NumberInt
11OPDF
Payment Draft		PRIMARYYes
LineIDRow NumberInt
11
DueDateCheck DateDate
8
CheckNumCheck NumberInt
11
BankCodeAccount No.nVarChar
30
-1
BranchBranch NumbernVarChar
50
AcctNumAccount NumbernVarChar
50
DetailsDetailsnVarChar
127
TrnsfrableNegotiableVarChar
Y) Yes
N) No
1
N
CheckSumCheck AmountNum
20
CurrencyCheck CurrencynVarChar
3OCRN
Currency Codes
FlagsFlagsInt
11
0
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History		24
LogInstancLog InstanceInt
11
0
CountryCodCountry CodenVarChar
3OCRY
Countries
CheckActChecking AccountnVarChar
15OACT
G/L Accounts
CheckAbsCheck ID EntryInt
11OCHO
Checks for Payment
BnkActKeyBank Account Internal IDInt
11DSC1
House Bank Accounts
ManualChkManual CheckVarChar
N) No
Y) Yes
1
N

Table relationship map

SELECT statement

SELECT PDF1.DocNum AS 'Document Number', PDF1.LineID AS 'Row Number', PDF1.DueDate AS 'Check Date', PDF1.CheckNum AS 'Check Number', PDF1.BankCode AS 'Account No.', PDF1.Branch AS 'Branch Number', PDF1.AcctNum AS 'Account Number', PDF1.Details AS 'Details', PDF1.Trnsfrable AS 'Negotiable', PDF1.CheckSum AS 'Check Amount', PDF1.Currency AS 'Check Currency', PDF1.Flags AS 'Flags', PDF1.ObjType AS 'Object Type', PDF1.LogInstanc AS 'Log Instance', PDF1.CountryCod AS 'Country Code', PDF1.CheckAct AS 'Checking Account', PDF1.CheckAbs AS 'Check ID Entry', PDF1.BnkActKey AS 'Bank Account Internal ID', PDF1.ManualChk AS 'Manual Check' FROM PDF1 AS PDF1

Related information


Accountt Num AccounttNum Property· Table: PDF1
Sets or returns the bank account number of the check.Field name: AcctNum.Length: 50 characters.
· Table: RCT1 PDF1 VPM1    Parent: Payments Checks Payments_Checks Object· Table: RCT1 PDF1 VPM1
House Bank Accounts DSC1 SQL Table

Checks for Payment OCHO SQL Table

G/L Accounts OACT SQL Table

Countries OCRY SQL Table

Currency Codes OCRN SQL Table

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