biuan SAP® BUSINESS ONE SDK
API OCHD
OCHD - Checks for Payment Drafts Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CheckKey KEY UNIQUECheck KeyInt
11
PRIMARYYes
CheckNumCheck NumberInt
11
BankNumBank No.nVarChar
30
BranchBranchnVarChar
50
BankNameBank NamenVarChar
127
CheckDateCashing DateDate
8
DpstAcctBank Account NumbernVarChar
50
DpstBranchBranch for PaymentsInt
6
AcctNumAccount No.nVarChar
50
DetailsDetailsnVarChar
50
TransRefTransaction ReferencenVarChar
8
PmntDatePayment DateDate
8
PmntNum KEYPayment No.Int
11
VPM_NUMNo
CheckSumCheck AmountNum
20
TrnsfrableFreely NegotiableVarChar
Y) Yes
N) No
1
N
VendorCodeVendor CodenVarChar
15
CurrencyCheck CurrencynVarChar
3
CanceledCanceledVarChar
Y) Yes
N) No
1
N
CardOrAcctBusiness Partner or AccountVarChar
C) Card
A) Account
1
C
PrintedPrintedVarChar
N) No
Y) Yes
1
N
VendorNameVendor NamenVarChar
100
TotalWordsTotal in WordsnVarChar
127
SignatureSignaturenVarChar
30
CheckAcctCredited Account CodenVarChar
15
TransNum KEYTransaction NumberInt
11
0TRANS_NUMNo
LinesSumRow TotalsNum
20
DeductionWTax Deduction - AmtNum
20
DdctPrcntWithholding Tax Deduction %Num
20
AddressAddressnVarChar
127
CreateJdtCreate Journal EntryVarChar
N) No
Y) Yes
1
Y
UpdateDateDate of UpdateDate
8
CreateDateCreation DateDate
8
VatTotalTotal TaxNum
20
VatCalcultCalculate TaxVarChar
Y) Yes
N) No
1
N
TaxDateDocument DateDate
8
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
SumRfndClnDeduction Refund AmountNum
20
UserSignUser SignatureInt
6OUSR
Users
PrintedByPrinted ByInt
6
TransferedTransferred to next yearVarChar
Y) Yes
N) No
1
N
InstanceInstanceInt
6
0
LogInstancLog InstanceInt
11
0
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
123
CountryCodCountry CodenVarChar
3OCRY
Countries
AddrNameAddress NamenVarChar
50
PrnConfrmConfirm PrintingVarChar
N) No
Y) Yes
1
N
BnkActKeyBank Account Internal IDInt
11DSC1
House Bank Accounts
CancelDateCancelation DateDate
8
ManualChkManual CheckVarChar
N) No
Y) Yes
1
N
BPLIdBranchInt
11OBPL
Business Place
BPLNameBranch NamenVarChar
100
VATRegNumBranch Reg. No.nVarChar
32

Table relationship map

SELECT statement

SELECT OCHD.CheckKey AS 'Check Key', OCHD.CheckNum AS 'Check Number', OCHD.BankNum AS 'Bank No.', OCHD.Branch AS 'Branch', OCHD.BankName AS 'Bank Name', OCHD.CheckDate AS 'Cashing Date', OCHD.DpstAcct AS 'Bank Account Number', OCHD.DpstBranch AS 'Branch for Payments', OCHD.AcctNum AS 'Account No.', OCHD.Details AS 'Details', OCHD.TransRef AS 'Transaction Reference', OCHD.PmntDate AS 'Payment Date', OCHD.PmntNum AS 'Payment No.', OCHD.CheckSum AS 'Check Amount', OCHD.Trnsfrable AS 'Freely Negotiable', OCHD.VendorCode AS 'Vendor Code', OCHD.Currency AS 'Check Currency', OCHD.Canceled AS 'Canceled', OCHD.CardOrAcct AS 'Business Partner or Account', OCHD.Printed AS 'Printed', OCHD.VendorName AS 'Vendor Name', OCHD.TotalWords AS 'Total in Words', OCHD.Signature AS 'Signature', OCHD.CheckAcct AS 'Credited Account Code', OCHD.TransNum AS 'Transaction Number', OCHD.LinesSum AS 'Row Totals', OCHD.Deduction AS 'WTax Deduction - Amt', OCHD.DdctPrcnt AS 'Withholding Tax Deduction %', OCHD.Address AS 'Address', OCHD.CreateJdt AS 'Create Journal Entry', OCHD.UpdateDate AS 'Date of Update', OCHD.CreateDate AS 'Creation Date', OCHD.VatTotal AS 'Total Tax', OCHD.VatCalcult AS 'Calculate Tax', OCHD.TaxDate AS 'Document Date', OCHD.DataSource AS 'Data Source', OCHD.SumRfndCln AS 'Deduction Refund Amount', OCHD.UserSign AS 'User Signature', OCHD.PrintedBy AS 'Printed By', OCHD.Transfered AS 'Transferred to next year', OCHD.Instance AS 'Instance', OCHD.LogInstanc AS 'Log Instance', OCHD.ObjType AS 'Object Type', OCHD.CountryCod AS 'Country Code', OCHD.AddrName AS 'Address Name', OCHD.PrnConfrm AS 'Confirm Printing', OCHD.BnkActKey AS 'Bank Account Internal ID', OCHD.CancelDate AS 'Cancelation Date', OCHD.ManualChk AS 'Manual Check', OCHD.BPLId AS 'Branch', OCHD.BPLName AS 'Branch Name', OCHD.VATRegNum AS 'Branch Reg. No.' FROM OCHD AS OCHD

Related information


OCHD SQL Table

House Bank Accounts DSC1 SQL Table

Business Place OBPL SQL Table

Countries OCRY SQL Table

Object Settings - History ADP1 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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates