|
|
SQL 
Banking / 
Checks for Payment
DTW Banking / Outgoing Payments / Checks for Payment
API OCHO / / Checksfor Payment
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | CheckKey KEY UNIQUE | Check Key | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| CheckNum | Check No. | Int | 11 | |||||
| BankNum | Bank Code | nVarChar | 30 | |||||
| Branch | Branch | nVarChar | 50 | |||||
| BankName | Bank Name | nVarChar | 127 | |||||
| CheckDate | Check Date | Date | 8 | |||||
| DpstAcct | Bank Account No. | nVarChar | 50 | |||||
| DpstBranch | Branch for Payments | Int | 6 | |||||
| AcctNum | Account No. | nVarChar | 50 | |||||
| Details | Details | nVarChar | 50 | |||||
| TransRef | Journal Entry Reference | nVarChar | 8 | |||||
| PmntDate | Payment Date | Date | 8 | |||||
| PmntNum KEY | Payment No. | Int | 11 | OVPM Outgoing Payments | 0 | VPM_NUM | No | |
| CheckSum | Check Amount | Num | 20 | |||||
| Trnsfrable | Negotiable | VarChar | N) No Y) Yes | 1 | N | |||
| VendorCode | Vendor Code | nVarChar | 15 | |||||
| Currency | Check Currency | nVarChar | 3 | |||||
| Canceled | Canceled | VarChar | N) No Y) Yes | 1 | N | |||
| CardOrAcct | Business Partner or Account | VarChar | C) BP A) Account | 1 | C | |||
| Printed | Printed | VarChar | N) No Y) Yes | 1 | N | |||
| VendorName | Vendor Name | nVarChar | 100 | |||||
| TotalWords | Total in Words | nVarChar | 127 | |||||
| Signature | Signature | nVarChar | 30 | |||||
| CheckAcct | Customer Account Code | nVarChar | 15 | |||||
| TransNum KEY | Transaction Number | Int | 11 | OJDT Journal Entry | 0 | TRANS_NUM | No | |
| LinesSum | Row Totals | Num | 20 | |||||
| Deduction | Deduction Amount | Num | 20 | |||||
| DdctPrcnt | Withholding Tax Deduction % | Num | 20 | |||||
| Address | Address | nVarChar | 127 | |||||
| CreateJdt | Create Journal Entry | VarChar | N) No Y) Yes | 1 | Y | |||
| UpdateDate | Date of Update | Date | 8 | |||||
| CreateDate | Creation Date | Date | 8 | |||||
| VatTotal | Total Tax | Num | 20 | |||||
| VatCalcult | Calculate Tax | VarChar | Y) Yes N) No | 1 | N | |||
| TaxDate | Document Date | Date | 8 | |||||
| DataSource | Data Source | VarChar | 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 | |||
| SumRfndCln | Deduction Refund Amount | Num | 20 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| PrintedBy | Printed By | Int | 6 | |||||
| Transfered | Transferred to next year | VarChar | Y) Yes N) No | 1 | N | |||
| Instance | Instance | Int | 6 | 0 | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 57 | |||
| CountryCod | Country Code | nVarChar | 3 | OCRY Countries | ||||
| AddrName | Address Name | nVarChar | 50 | |||||
| PrnConfrm | Confirm Printing | VarChar | N) No Y) Yes | 1 | N | |||
| BnkActKey | Bank Account Internal ID | Int | 11 | DSC1 House Bank Accounts | ||||
| CancelDate | Cancelation Date | Date | 8 | |||||
| ManualChk | Manual Check | VarChar | N) No Y) Yes | 1 | N | |||
| BPLId | Branch | Int | 11 | OBPL Business Place | ||||
| BPLName | Branch Name | nVarChar | 100 | |||||
| VATRegNum | Branch 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
ChecksforPayment
Enumeration
Method
Object
Property
AccountNumber
DTW DB
Address
DTW DB
AddressName
DTW DB
BankCode
DTW DB
BankName
DB
Branch
DTW DB
Canceled
DB
CardOrAccount
DTW DB
CheckAmount
DB
CheckDate
DTW DB
CheckKey
DTW DB
CheckNumber
DTW DB
CountryCode
DTW DB
CreateJournalEntry
DTW DB
CreationDate
DB
CustomerAccountCode
DTW DB
DeductionRefundAmount
DTW DB
Details
DTW DB
JournalEntryReference
DTW DB
ManualCheck
DTW DB
PaymentDate
DTW DB
PaymentNo
DB
Printed
DB
PrintedBy
DB
Signature
DTW DB
TaxDate
DB
TaxTotal
DB
TotalinWords
DTW DB
Transferable
DTW DB
UpdateDate
DB
VendorCode
DTW DB
VendorName
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates