biuan SAP® BUSINESS ONE SDK
SQL Outgoing Payments - Check Rows
DTW Outgoing Payments - Check Rows
API Payments Checks / Accountt Num
VPM1 - Outgoing Payments - Check Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocNum KEY UNIQUEDocument NumberInt
11OVPM
Outgoing Payments		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		46
LogInstancLog InstanceInt
11
0
CountryCodCountry CodenVarChar
3OCRY
Countries
CheckActChecking AccountnVarChar
15OACT
G/L Accounts
CheckAbsInternal Check NumberInt
11OCHO
Checks for Payment
BnkActKeyBank Account No.Int
11DSC1
House Bank Accounts
ManualChkManual CheckVarChar
N) No
Y) Yes
1
N

Table relationship map

SELECT statement

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

Related information


Accountt Num AccounttNum Property· Table: VPM1
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

Outgoing Payments OVPM 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