📚 SAP Business One SDK Help

Table Name: ACHO

Table Description: Checks for Payment - History

Field Description Type Size Related Default Value Constraints
CheckKey Check Key Int 11 -      
CheckNum Check Number Int 11 -      
BankNum Bank Code nVarChar 30 -      
Branch Branch nVarChar 50 -      
BankName Bank Name nVarChar 250 -      
CheckDate Check Date Date 8 -      
DpstAcct Bank Account Number nVarChar 50 -      
DpstBranch Branch for Payments Int 6 -      
AcctNum Account Number nVarChar 50 -      
Details Details nVarChar 254 -      
TransRef Journal Entry Reference nVarChar 11 -      
PmntDate Payment Date Date 8 -      
PmntNum Payment No. Int 11 OVPM 0    
CheckSum Check Amount Num 19.6 -      
Trnsfrable Negotiable VarChar 1 - N N No
            Y Yes
VendorCode Vendor Code nVarChar 15 -      
Currency Check Currency nVarChar 3 -      
Canceled Canceled VarChar 1 - N N No
            Y Yes
CardOrAcct G/L Acct/BP Code VarChar 1 - C C BP
            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 Customer Account Code nVarChar 15 -      
TransNum Transaction Number Int 11 OJDT 0    
LinesSum Row Totals Num 19.6 -      
Deduction Deduction Amount Num 19.6 -      
DdctPrcnt Withholding Tax Ded. % 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 57    
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
    LogInstanc
VPM_NUM No PmntNum
TRANS_NUM No TransNum