biuan SAP® BUSINESS ONE SDK
SQL Banking / Checks for Payment Drafts - Rows
API CHD1
CHD1 - Checks for Payment Drafts - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CheckKey KEY UNIQUESAP Business One Internal KeyInt
11OCHD
Checks for Payment Drafts		PRIMARYYes
LineIdRow No.Int
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		123
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 CHD1.CheckKey AS 'SAP Business One Internal Key', CHD1.LineId AS 'Row No.', CHD1.LineDitail AS 'Row Details', CHD1.LineMoney AS 'Row Total', CHD1.LineCurr AS 'Row Currency', CHD1.LineAcct AS 'Row Account', CHD1.Line_A_C AS 'Business Partner or Account', CHD1.Code AS 'Tax Definition', CHD1.CredAcct AS 'Credited Account', CHD1.TotalLine AS 'Row Total', CHD1.VatPercent AS 'Tax %:', CHD1.UserSign AS 'User Signature', CHD1.LogInstanc AS 'Log Instance', CHD1.ObjType AS 'Object Type', CHD1.LineMnyLC AS 'Row Total (LC)', CHD1.LineMnySC AS 'Row Total (SC)', CHD1.LineMnyFC AS 'Row Total (FC)', CHD1.TotLineLC AS 'Row Total (LC)', CHD1.TotLineSC AS 'Row Total (SC)', CHD1.TotLineFC AS 'Row Total (FC)' FROM CHD1 AS CHD1

Related information


Checks for Payment Drafts OCHD 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