📚 SAP Business One SDK Help

Table Name: OCHD

Table Description: Checks for Payment Drafts

Field Description Type Size Related Default Value Constraints
CheckKey Check Key Int 11 -      
CheckNum Check Number Int 11 -      
BankNum Bank No. nVarChar 30 -      
Branch Branch nVarChar 50 -      
BankName Bank Name nVarChar 250 -      
CheckDate Cashing Date Date 8 -      
DpstAcct Bank Account Number nVarChar 50 -      
DpstBranch Branch for Payments Int 6 -      
AcctNum Account No. nVarChar 50 -      
Details Details nVarChar 254 -      
TransRef Transaction Reference nVarChar 11 -      
PmntDate Payment Date Date 8 -      
PmntNum Payment No. Int 11 OVPM      
CheckSum Check Amount Num 19.6 -      
Trnsfrable Freely Negotiable VarChar 1 - N Y Yes
            N No
VendorCode Vendor Code nVarChar 15 -      
Currency Check Currency nVarChar 3 -      
Canceled Canceled VarChar 1 - N Y Yes
            N No
CardOrAcct Business Partner or Account VarChar 1 - C C Card
            A Account
Printed Printed VarChar 1 - N N No
            Y Yes
VendorName Vendor Name nVarChar 200 -      
TotalWords Total in Words nVarChar 254 -      
Signature Signature nVarChar 30 -      
CheckAcct Credited Account Code nVarChar 15 -      
TransNum Transaction Number Int 11 OJDT 0    
LinesSum Row Totals Num 19.6 -      
Deduction WTax Deduction - Amt Num 19.6 -      
DdctPrcnt Withholding Tax Deduction % Num 19.6 -      
Address Address nVarChar 254 -      
CreateJdt Create Journal Entry VarChar 1 - Y N No
            Y Yes
UpdateDate Date of Update Date 8 -      
CreateDate Creation Date Date 8 -      
VatTotal Total Tax Num 19.6 -      
VatCalcult Calculate Tax VarChar 1 - N Y Yes
            N No
TaxDate Document Date Date 8 -      
DataSource Data Source VarChar 1 - N N Unknown
            I Interface
            U Update
            M Import
            O DI API
            S Service Layer
            W Web Client
            A Doc. Generation Wizard
            D Restore Wizard
            P Partner Implementation
            T Year Transfer
SumRfndCln Deduction Refund Amount Num 19.6 -      
UserSign User Signature Int 6 OUSR      
PrintedBy Printed By Int 6 -      
Transfered Transferred to next year VarChar 1 - N Y Yes
            N No
Instance Instance Int 6 - 0    
LogInstanc Log Instance Int 11 - 0    
ObjType Object Type nVarChar 20 ADP1 123    
CountryCod Country/Region Code nVarChar 3 OCRY      
AddrName Address Name nVarChar 50 -      
PrnConfrm Confirm Printing VarChar 1 - N N No
            Y Yes
BnkActKey Bank Account Internal ID Int 11 DSC1      
CancelDate Cancelation Date Date 8 -      
ManualChk Manual Check VarChar 1 - N N No
            Y Yes
BPLId Branch Int 11 OBPL      
BPLName Branch Name nVarChar 200 -      
VATRegNum Branch Reg. No. nVarChar 32 -      
Endorse Endorse VarChar 1 - N N No
            Y Yes
EndorsChNo Endorsable Check No. Int 11 OCHH      
UserSign2 Updating User - History Int 6 OUSR      
DPPStatus Data Protection Status VarChar 1 - N N None
            D Erased
AtcEntry Attachment Entry Int 11 OATC      
Attachment Attachment Text 16 -      
ECheck E-Check VarChar 1 - N Y Yes
            N No
VersionNum Version Number nVarChar 13 -      
EnAcctNum Encryption of Account Number Text 16 -      
EncryptIV Encrypt IV nVarChar 100 -      
Key Unique Field
PRIMARY Yes CheckKey
VPM_NUM No PmntNum
TRANS_NUM No TransNum