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

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocNum KEY UNIQUEDocument NumberInt
11ORCT
Incoming Payment		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
11OCHH
Check Register
BnkActKeyBank Account No.Int
11DSC1
House Bank Accounts
ManualChkManual CheckVarChar
N) No
Y) Yes
1
N

Table relationship map

SELECT statement

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

Related information


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

Check Register OCHH SQL Table

G/L Accounts OACT SQL Table

Countries OCRY SQL Table

Currency Codes OCRN SQL Table

Incoming Payment ORCT 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