biuan SAP® BUSINESS ONE SDK
API ACHO
ACHO - Checks for Payment - History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CheckKey KEY UNIQUECheck KeyInt
11
PRIMARYYes
CheckNumCheck NumberInt
11
BankNumBank CodenVarChar
30
BranchBranchnVarChar
50
BankNameBank NamenVarChar
127
CheckDateCheck DateDate
8
DpstAcctBank Account NumbernVarChar
50
DpstBranchBranch for PaymentsInt
6
AcctNumAccount NumbernVarChar
50
DetailsDetailsnVarChar
50
TransRefJournal Entry ReferencenVarChar
8
PmntDatePayment DateDate
8
PmntNumPayment No.Int
11OVPM
Outgoing Payments
0
CheckSumCheck AmountNum
20
TrnsfrableNegotiableVarChar
N) No
Y) Yes
1
N
VendorCodeVendor CodenVarChar
15
CurrencyCheck CurrencynVarChar
3
CanceledCanceledVarChar
N) No
Y) Yes
1
N
CardOrAcctG/L Acct/BP CodeVarChar
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
TransNumTransaction NumberInt
11OJDT
Journal Entry
0
LinesSumRow TotalsNum
20
DeductionDeduction AmountNum
20
DdctPrcntWithholding Tax Ded. %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 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



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates