|
|
API ACHO
ACHO - Checks for Payment - History 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
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 Code | nVarChar | 30 | |||||
| Branch | Branch | nVarChar | 50 | |||||
| BankName | Bank Name | nVarChar | 127 | |||||
| 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 | 50 | |||||
| TransRef | Journal Entry Reference | nVarChar | 8 | |||||
| PmntDate | Payment Date | Date | 8 | |||||
| PmntNum | Payment No. | Int | 11 | OVPM Outgoing Payments | 0 | |||
| 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 | G/L Acct/BP Code | 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 | Transaction Number | Int | 11 | OJDT Journal Entry | 0 | |||
| LinesSum | Row Totals | Num | 20 | |||||
| Deduction | Deduction Amount | Num | 20 | |||||
| DdctPrcnt | Withholding Tax Ded. % | 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
ACHO.CheckKey AS 'Check Key',
ACHO.CheckNum AS 'Check Number',
ACHO.BankNum AS 'Bank Code',
ACHO.Branch AS 'Branch',
ACHO.BankName AS 'Bank Name',
ACHO.CheckDate AS 'Check Date',
ACHO.DpstAcct AS 'Bank Account Number',
ACHO.DpstBranch AS 'Branch for Payments',
ACHO.AcctNum AS 'Account Number',
ACHO.Details AS 'Details',
ACHO.TransRef AS 'Journal Entry Reference',
ACHO.PmntDate AS 'Payment Date',
ACHO.PmntNum AS 'Payment No.',
ACHO.CheckSum AS 'Check Amount',
ACHO.Trnsfrable AS 'Negotiable',
ACHO.VendorCode AS 'Vendor Code',
ACHO.Currency AS 'Check Currency',
ACHO.Canceled AS 'Canceled',
ACHO.CardOrAcct AS 'G/L Acct/BP Code',
ACHO.Printed AS 'Printed',
ACHO.VendorName AS 'Vendor Name',
ACHO.TotalWords AS 'Total in Words',
ACHO.Signature AS 'Signature',
ACHO.CheckAcct AS 'Customer Account Code',
ACHO.TransNum AS 'Transaction Number',
ACHO.LinesSum AS 'Row Totals',
ACHO.Deduction AS 'Deduction Amount',
ACHO.DdctPrcnt AS 'Withholding Tax Ded. %',
ACHO.Address AS 'Address',
ACHO.CreateJdt AS 'Create Journal Entry',
ACHO.UpdateDate AS 'Date of Update',
ACHO.CreateDate AS 'Creation Date',
ACHO.VatTotal AS 'Total Tax',
ACHO.VatCalcult AS 'Calculate Tax',
ACHO.TaxDate AS 'Document Date',
ACHO.DataSource AS 'Data Source',
ACHO.SumRfndCln AS 'Deduction Refund Amount',
ACHO.UserSign AS 'User Signature',
ACHO.PrintedBy AS 'Printed By',
ACHO.Transfered AS 'Transferred to Next Year',
ACHO.Instance AS 'Instance',
ACHO.LogInstanc AS 'Log Instance',
ACHO.ObjType AS 'Object Type',
ACHO.CountryCod AS 'Country Code',
ACHO.AddrName AS 'Address Name',
ACHO.PrnConfrm AS 'Confirm Printing',
ACHO.BnkActKey AS 'Bank Account Internal ID',
ACHO.CancelDate AS 'Cancelation Date',
ACHO.ManualChk AS 'Manual Check',
ACHO.BPLId AS 'Branch',
ACHO.BPLName AS 'Branch Name',
ACHO.VATRegNum AS 'Branch Reg. No.'
FROM ACHO AS ACHO
Related information
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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
