biuan SAP® BUSINESS ONE SDK
SQL Banking / Check Register
API Check Lines / Check Line
OCHH - Check Register Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CheckKey KEY UNIQUECheck KeyInt
11
PRIMARYYes
CheckNum KEYCheck NumberInt
11
CHECK_NUMNo
BankCodeBank CodenVarChar
30
BranchBranch NumbernVarChar
50
CashCheckCheck Register AccountnVarChar
15
CheckDateCheck DateDate
8
DetailsDetailsnVarChar
20
CardCodeBP/Account CodenVarChar
15OCRD
Business Partner
RcptDateReceipt DateDate
8
RcptNum KEYReceipt NumberInt
11ORCT
Incoming Payment		RECEIPTNo
CheckSumCheck AmountNum
20
TrnsfrableNegotiableVarChar
Y) Yes
N) No
1
N
DepositedDepositedVarChar
C) As Cash
N) No
S) As Postdated
1
N
ConvertedEndorsedVarChar
Y) Yes
N) No
1
N
VendorEndorsed fornVarChar
15
TransNumPayment TransactionInt
11
DepNum2 KEYPostdated Deposit KeyInt
11ODPT
Postdated Deposit		0DEP_ABS2No
DpstAbs KEYPayment Internal IDInt
11ODPS
Deposit		DEP_ABS1No
BankAcctDeposit AccountnVarChar
15
AcctNumAccount NumbernVarChar
50
CurrencyCheck CurrencynVarChar
3
CanceledCanceledVarChar
Y) Yes
N) No
1
N
RcptLineIdRow Number in ReceiptInt
11
TransferedPostponed to Next YearVarChar
Y) Yes
N) No
1
N
InstanceInstanceInt
6
0
UserIDUser SignatureInt
6OUSR
Users
BankCountrBank CountrynVarChar
3OCRY
Countries
ProjectProject CodenVarChar
20OPRJ
Project Codes
CanceJEAbsCancellation Journal EntryInt
11OJDT
Journal Entry
TempJEAbsTemp. Journal EntryInt
11
CardNameBP/Account NamenVarChar
100

Table relationship map

SELECT statement

SELECT OCHH.CheckKey AS 'Check Key', OCHH.CheckNum AS 'Check Number', OCHH.BankCode AS 'Bank Code', OCHH.Branch AS 'Branch Number', OCHH.CashCheck AS 'Check Register Account', OCHH.CheckDate AS 'Check Date', OCHH.Details AS 'Details', OCHH.CardCode AS 'BP/Account Code', OCHH.RcptDate AS 'Receipt Date', OCHH.RcptNum AS 'Receipt Number', OCHH.CheckSum AS 'Check Amount', OCHH.Trnsfrable AS 'Negotiable', OCHH.Deposited AS 'Deposited', OCHH.Converted AS 'Endorsed', OCHH.Vendor AS 'Endorsed for', OCHH.TransNum AS 'Payment Transaction', OCHH.DepNum2 AS 'Postdated Deposit Key', OCHH.DpstAbs AS 'Payment Internal ID', OCHH.BankAcct AS 'Deposit Account', OCHH.AcctNum AS 'Account Number', OCHH.Currency AS 'Check Currency', OCHH.Canceled AS 'Canceled', OCHH.RcptLineId AS 'Row Number in Receipt', OCHH.Transfered AS 'Postponed to Next Year', OCHH.Instance AS 'Instance', OCHH.UserID AS 'User Signature', OCHH.BankCountr AS 'Bank Country', OCHH.Project AS 'Project Code', OCHH.CanceJEAbs AS 'Cancellation Journal Entry', OCHH.TempJEAbs AS 'Temp. Journal Entry', OCHH.CardName AS 'BP/Account Name' FROM OCHH AS OCHH

Related information


Check Line CheckLine Object· Table: OCHH
Represents the deposits for received checks. Source table: OCHH.
   Parent: Check Lines CheckLines Collection

Check Lines Service CheckLinesService Service· Table: OCHH
The CheckLinesService service enables you to get deposits for received checks. Source table: OCHH.

OCHH SQL Table

Countries OCRY SQL Table

Journal Entry OJDT SQL Table

Business Partner OCRD SQL Table

Postdated Deposit ODPT SQL Table

Deposit ODPS SQL Table

Project Codes OPRJ SQL Table

Incoming Payment ORCT SQL Table

Users OUSR 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