biuan SAP® BUSINESS ONE SDK
DTW Banking / Outgoing Payments / Checks for Payment
API OCHO / / Checksfor Payment
OCHO - Checks for Payment Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CheckKey KEY UNIQUECheck KeyInt
11
PRIMARYYes
CheckNumCheck No.Int
11
BankNumBank CodenVarChar
30
BranchBranchnVarChar
50
BankNameBank NamenVarChar
127
CheckDateCheck DateDate
8
DpstAcctBank Account No.nVarChar
50
DpstBranchBranch for PaymentsInt
6
AcctNumAccount No.nVarChar
50
DetailsDetailsnVarChar
50
TransRefJournal Entry ReferencenVarChar
8
PmntDatePayment DateDate
8
PmntNum KEYPayment No.Int
11OVPM
Outgoing Payments
0VPM_NUMNo
CheckSumCheck AmountNum
20
TrnsfrableNegotiableVarChar
N) No
Y) Yes
1
N
VendorCodeVendor CodenVarChar
15
CurrencyCheck CurrencynVarChar
3
CanceledCanceledVarChar
N) No
Y) Yes
1
N
CardOrAcctBusiness Partner or AccountVarChar
C) BP
A) Account
1
C
PrintedPrintedVarChar
N) No
Y) Yes
1
N
VendorNameVendor NamenVarChar
100
TotalWordsTotal in WordsnVarChar
127
SignatureSignaturenVarChar
30
CheckAcctCustomer Account CodenVarChar
15
TransNum KEYTransaction NumberInt
11OJDT
Journal Entry
0TRANS_NUMNo
LinesSumRow TotalsNum
20
DeductionDeduction AmountNum
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
57
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 OCHO.CheckKey AS 'Check Key', OCHO.CheckNum AS 'Check No.', OCHO.BankNum AS 'Bank Code', OCHO.Branch AS 'Branch', OCHO.BankName AS 'Bank Name', OCHO.CheckDate AS 'Check Date', OCHO.DpstAcct AS 'Bank Account No.', OCHO.DpstBranch AS 'Branch for Payments', OCHO.AcctNum AS 'Account No.', OCHO.Details AS 'Details', OCHO.TransRef AS 'Journal Entry Reference', OCHO.PmntDate AS 'Payment Date', OCHO.PmntNum AS 'Payment No.', OCHO.CheckSum AS 'Check Amount', OCHO.Trnsfrable AS 'Negotiable', OCHO.VendorCode AS 'Vendor Code', OCHO.Currency AS 'Check Currency', OCHO.Canceled AS 'Canceled', OCHO.CardOrAcct AS 'Business Partner or Account', OCHO.Printed AS 'Printed', OCHO.VendorName AS 'Vendor Name', OCHO.TotalWords AS 'Total in Words', OCHO.Signature AS 'Signature', OCHO.CheckAcct AS 'Customer Account Code', OCHO.TransNum AS 'Transaction Number', OCHO.LinesSum AS 'Row Totals', OCHO.Deduction AS 'Deduction Amount', OCHO.DdctPrcnt AS 'Withholding Tax Deduction %', OCHO.Address AS 'Address', OCHO.CreateJdt AS 'Create Journal Entry', OCHO.UpdateDate AS 'Date of Update', OCHO.CreateDate AS 'Creation Date', OCHO.VatTotal AS 'Total Tax', OCHO.VatCalcult AS 'Calculate Tax', OCHO.TaxDate AS 'Document Date', OCHO.DataSource AS 'Data Source', OCHO.SumRfndCln AS 'Deduction Refund Amount', OCHO.UserSign AS 'User Signature', OCHO.PrintedBy AS 'Printed By', OCHO.Transfered AS 'Transferred to next year', OCHO.Instance AS 'Instance', OCHO.LogInstanc AS 'Log Instance', OCHO.ObjType AS 'Object Type', OCHO.CountryCod AS 'Country Code', OCHO.AddrName AS 'Address Name', OCHO.PrnConfrm AS 'Confirm Printing', OCHO.BnkActKey AS 'Bank Account Internal ID', OCHO.CancelDate AS 'Cancelation Date', OCHO.ManualChk AS 'Manual Check', OCHO.BPLId AS 'Branch', OCHO.BPLName AS 'Branch Name', OCHO.VATRegNum AS 'Branch Reg. No.' FROM OCHO AS OCHO

Related information


Checksfor Payment ChecksforPayment Object· Table: OCHO
Represents checks that are not tied to a document. SAP Business One updates the balances of vendor accounts each time you add a check for payment. This object is part of the Banking module. Checks tied to documents are represented by the...

OCHO SQL Table

House Bank Accounts DSC1 SQL Table

Business Place OBPL SQL Table

Countries OCRY SQL Table

Object Settings - History ADP1 SQL Table

Outgoing Payments OVPM SQL Table

Journal Entry OJDT 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