biuan SAP® BUSINESS ONE SDK
API BOE1
BOE1 - Bill of Exchange for Payment - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
BoeKey KEY UNIQUESBO Internal KeyInt
11OBOE
Bill of Exchange for Payment
PRIMARYYes
LineIdRow No.Int
11
LineDitailRow DetailsnVarChar
40
LineMoneyRow TotalNum
20
LineCurrRow CurrencynVarChar
3OCRN
Currency Codes
LineAcctRow AccountnVarChar
15
Line_A_CBP/AccountVarChar
1
0
CodeTax DefinitionnVarChar
8OVTG
Tax Definition
CredAcctCredited AccountnVarChar
15OACT
G/L Accounts
TotalLineRow TotalNum
20
VatPercentTax %:Num
20
UserSignUser SignatureInt
11OUSR
Users
LogInstancLog InstanceInt
11
0

Table relationship map

SELECT statement

SELECT BOE1.BoeKey AS 'SBO Internal Key', BOE1.LineId AS 'Row No.', BOE1.LineDitail AS 'Row Details', BOE1.LineMoney AS 'Row Total', BOE1.LineCurr AS 'Row Currency', BOE1.LineAcct AS 'Row Account', BOE1.Line_A_C AS 'BP/Account', BOE1.Code AS 'Tax Definition', BOE1.CredAcct AS 'Credited Account', BOE1.TotalLine AS 'Row Total', BOE1.VatPercent AS 'Tax %:', BOE1.UserSign AS 'User Signature', BOE1.LogInstanc AS 'Log Instance' FROM BOE1 AS BOE1

Related information


Bill of Exchange for Payment OBOE SQL Table

Tax Definition OVTG SQL Table

G/L Accounts OACT SQL Table

Currency Codes OCRN 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