biuan SAP® BUSINESS ONE SDK
SQL Banking / Checks for Payment / Checks for Payment - Rows
DTW Banking / Outgoing Payments / Checks for Payment / Checks for Payment - Rows
API Checksfor Payment / Checksfor Payment Lines
CHO1 - Checks for Payment - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CheckKey KEY UNIQUESAP Business One Internal KeyInt
11OCHO
Checks for Payment		PRIMARYYes
LineIdRow NumberInt
11
LineDitailRow DetailsnVarChar
40
LineMoneyRow TotalNum
20
LineCurrRow CurrencynVarChar
3
LineAcctRow AccountnVarChar
15
Line_A_CBusiness Partner or AccountVarChar
1
0
CodeTax DefinitionnVarChar
8OVTG
Tax Definition
CredAcctCredited AccountnVarChar
15OACT
G/L Accounts
TotalLineRow TotalNum
20
VatPercentTax %:Num
20
UserSignUser SignatureInt
6OUSR
Users
LogInstancLog InstanceInt
11
0
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History		57
LineMnyLCRow Total (LC)Num
20
LineMnySCRow Total (SC)Num
20
LineMnyFCRow Total (FC)Num
20
TotLineLCRow Total (LC)Num
20
TotLineSCRow Total (SC)Num
20
TotLineFCRow Total (FC)Num
20

Table relationship map

SELECT statement

SELECT CHO1.CheckKey AS 'SAP Business One Internal Key', CHO1.LineId AS 'Row Number', CHO1.LineDitail AS 'Row Details', CHO1.LineMoney AS 'Row Total', CHO1.LineCurr AS 'Row Currency', CHO1.LineAcct AS 'Row Account', CHO1.Line_A_C AS 'Business Partner or Account', CHO1.Code AS 'Tax Definition', CHO1.CredAcct AS 'Credited Account', CHO1.TotalLine AS 'Row Total', CHO1.VatPercent AS 'Tax %:', CHO1.UserSign AS 'User Signature', CHO1.LogInstanc AS 'Log Instance', CHO1.ObjType AS 'Object Type', CHO1.LineMnyLC AS 'Row Total (LC)', CHO1.LineMnySC AS 'Row Total (SC)', CHO1.LineMnyFC AS 'Row Total (FC)', CHO1.TotLineLC AS 'Row Total (LC)', CHO1.TotLineSC AS 'Row Total (SC)', CHO1.TotLineFC AS 'Row Total (FC)' FROM CHO1 AS CHO1

Related information


Checksfor Payment Lines ChecksforPaymentLines Object· Table: CHO1
ChecksforPaymentLines is a child object of the ChecksforPayment object that represents the appendix of the check. Source table: CHO1.
   Parent: Checksfor Payment ChecksforPayment Object· Table: OCHO
Checks for Payment OCHO SQL Table

Tax Definition OVTG SQL Table

G/L Accounts OACT SQL Table

Object Settings - History ADP1 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