biuan SAP® BUSINESS ONE SDK
DTW Financials / Budget Setup / Budget / Budget - Rows
API Budget / Budget Lines
BGT1 - Budget - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
BudgId KEY UNIQUEBudget KeyInt
11OBGT
Budget
PRIMARYYes
Line_IDRow NumberInt
11
0
DebLTotalMonthly Budget - Deb.Num
20
CredLTotalMonthly Budget - Cr.Num
20
DebSTotalMonthly Budget - SC Deb.Num
20
CredSTotalMonthly Budget - SC Cr.Num
20
DebRLTotalMonthly Bal. - Deb.Num
20
CrdRLTotalMonthly Bal. - Cr.Num
20
DebRSTotalMonthly Bal. - SC Deb.Num
20
CrdRSTotalMonthly Bal. - SC Cred.Num
20
FtrIDRLSumFut. Monthly Incomes SC Cr.Num
20
FtrIDRSSumFut. Monthly Incomes SC Deb.Num
20
FtrICRLSumFut. Incomes - Cr.Num
20
FtrICRSSumFut. Incomes - Sys. Cr.Num
20
FtrODRLSumFut. Expen - Local Deb.Num
20
FtrODRSSumFut.Expen - SC Deb.Num
20
FtrOCRLSumFut.Expen - Local Cr.Num
20
FtrOCRSSumFut.Expen - Sys. Cr.Num
20
MonthPrcnt% of annual budget amountNum
20
LineMemoRow DetailsnVarChar
50
InstanceInstanceInt
11OBGS
Budget Scenario
1
AcctCodeAccount CodenVarChar
15
UserSignUser SignatureInt
6OUSR
Users

Table relationship map

SELECT statement

SELECT BGT1.BudgId AS 'Budget Key', BGT1.Line_ID AS 'Row Number', BGT1.DebLTotal AS 'Monthly Budget - Deb.', BGT1.CredLTotal AS 'Monthly Budget - Cr.', BGT1.DebSTotal AS 'Monthly Budget - SC Deb.', BGT1.CredSTotal AS 'Monthly Budget - SC Cr.', BGT1.DebRLTotal AS 'Monthly Bal. - Deb.', BGT1.CrdRLTotal AS 'Monthly Bal. - Cr.', BGT1.DebRSTotal AS 'Monthly Bal. - SC Deb.', BGT1.CrdRSTotal AS 'Monthly Bal. - SC Cred.', BGT1.FtrIDRLSum AS 'Fut. Monthly Incomes SC Cr.', BGT1.FtrIDRSSum AS 'Fut. Monthly Incomes SC Deb.', BGT1.FtrICRLSum AS 'Fut. Incomes - Cr.', BGT1.FtrICRSSum AS 'Fut. Incomes - Sys. Cr.', BGT1.FtrODRLSum AS 'Fut. Expen - Local Deb.', BGT1.FtrODRSSum AS 'Fut.Expen - SC Deb.', BGT1.FtrOCRLSum AS 'Fut.Expen - Local Cr.', BGT1.FtrOCRSSum AS 'Fut.Expen - Sys. Cr.', BGT1.MonthPrcnt AS '% of annual budget amount', BGT1.LineMemo AS 'Row Details', BGT1.Instance AS 'Instance', BGT1.AcctCode AS 'Account Code', BGT1.UserSign AS 'User Signature' FROM BGT1 AS BGT1

Related information


Budget Lines Budget_Lines Object· Table: BGT1
Budget_Lines is a child object of Budget object and represents the budget item details of an account. Source table: BGT1.
   Parent: Budget Budget Object· Table: OBGT
Budget OBGT SQL Table

Budget Scenario OBGS 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