|
|
API OCHD
OCHD - Checks for Payment Drafts Table
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
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 Number | Int | 11 | |||||
| BankNum | Bank No. | nVarChar | 30 | |||||
| Branch | Branch | nVarChar | 50 | |||||
| BankName | Bank Name | nVarChar | 127 | |||||
| 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 | 50 | |||||
| TransRef | Transaction Reference | nVarChar | 8 | |||||
| PmntDate | Payment Date | Date | 8 | |||||
| PmntNum KEY | Payment No. | Int | 11 | VPM_NUM | No | |||
| CheckSum | Check Amount | Num | 20 | |||||
| Trnsfrable | Freely Negotiable | VarChar | Y) Yes N) No | 1 | N | |||
| VendorCode | Vendor Code | nVarChar | 15 | |||||
| Currency | Check Currency | nVarChar | 3 | |||||
| Canceled | Canceled | VarChar | Y) Yes N) No | 1 | N | |||
| CardOrAcct | Business Partner or Account | VarChar | C) Card 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 | Credited Account Code | nVarChar | 15 | |||||
| TransNum KEY | Transaction Number | Int | 11 | 0 | TRANS_NUM | No | ||
| LinesSum | Row Totals | Num | 20 | |||||
| Deduction | WTax Deduction - Amt | 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 | 123 | |||
| 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
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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
