ChartOfAccounts - biuan.com SDK Developer

SQL

Finance /

G/L Accounts

DTW Financials / Chart of Accounts

API Chart Of Accounts

Chart Of Accounts Object

Description

ChartOfAccounts is a business object that represents the General Ledger (G/L) accounts in the Finance module.

This object enables you to:

Add a G/L account.
Retrieve a G/L account by its key.
Update a G/L account.
Remove a G/L account.
Save the object in XML format.

Source table: OACT.

Object Model

ChartOfAccounts

Browser (DataBrowser)

Remarks

The Chart of Accounts is an index of all G/L accounts that are used by one or more companies. For every G/L account there is an account number, an account description, and information that determines the function of the account.

You have to assign a Chart of Accounts to every company. This Chart of Accounts becomes operative after you carry out posting for these businesses in your daily business.

After choosing the most suitable Chart of Accounts, you can customize your choice by adding, adjusting, and changing. However, once posting were made to Chart of Accounts you cannot delete it.

Mandatory fields in SAP Business One: Code or FormatCode (when working with account segmentation), and FatherAccountKey.

To display the form in the application:

Select Financials --> Chart of Accounts (or Edit Chart of Accounts).

SAP® B1 DI-API C# definition

public class ChartOfAccountsClass : IChartOfAccounts, ChartOfAccounts { public virtual int AccountLevel { get; } public virtual SPEDContabilAccountPurposeCode AccountPurposeCode { get; set; } public virtual BoAccountTypes AccountType { get; set; } public virtual string AcctCurrency { get; set; } public virtual BoYesNoEnum ActiveAccount { get; set; } public virtual BoYesNoEnum AllowChangeVatGroup { get; set; } public virtual BoYesNoEnum AllowMultipleLinking { get; set; } public virtual double Balance { get; } public virtual double Balance_FrgnCurr { get; } public virtual double Balance_syscurr { get; } public virtual BoYesNoEnum BlockManualPosting { get; set; } public virtual int BPLID { get; set; } public virtual string BPLName { get; } public virtual DataBrowser Browser { get; } public virtual BoYesNoEnum BudgetAccount { get; set; } public virtual BoYesNoEnum CashAccount { get; set; } public virtual int Category { get; set; } public virtual string Code { get; set; } public virtual string DataExportCode { get; set; } public virtual int DatevAccount { get; set; } public virtual BoYesNoEnum DatevAutoAccount { get; set; } public virtual BoYesNoEnum DatevFirstDataEntry { get; set; } public virtual string DefaultVatGroup { get; set; } public virtual string Details { get; set; } public virtual BoYesNoEnum DistributionRule2Relevant { get; set; } public virtual BoYesNoEnum DistributionRule3Relevant { get; set; } public virtual BoYesNoEnum DistributionRule4Relevant { get; set; } public virtual BoYesNoEnum DistributionRule5Relevant { get; set; } public virtual BoYesNoEnum DistributionRuleRelevant { get; set; } public virtual string ExternalCode { get; set; } public virtual int ExternalReconNo { get; } public virtual string FatherAccountKey { get; set; } public virtual string ForeignName { get; set; } public virtual string FormatCode { get; set; } public virtual BoYesNoEnum FrozenFor { get; set; } public virtual DateTime FrozenFrom { get; set; } public virtual string FrozenRemarks { get; set; } public virtual DateTime FrozenTo { get; set; } public virtual int InternalReconNo { get; } public virtual BoYesNoEnum LiableForAdvances { get; set; } public virtual string LoadingFactorCode { get; set; } public virtual string LoadingFactorCode2 { get; set; } public virtual string LoadingFactorCode3 { get; set; } public virtual string LoadingFactorCode4 { get; set; } public virtual string LoadingFactorCode5 { get; set; } public virtual BoYesNoEnum LoadingType { get; set; } public virtual BoYesNoEnum LockManualTransaction { get; set; } public virtual string Name { get; set; } public virtual string PlanningLevel { get; set; } public virtual BoYesNoEnum PrimaryAccount { get; } public virtual string ProjectCode { get; set; } public virtual BoYesNoEnum ProjectRelevant { get; set; } public virtual BoYesNoEnum Protected { get; set; } public virtual BoYesNoEnum RateConversion { get; set; } public virtual BoYesNoEnum ReconciledAccount { get; set; } public virtual string ReferentialAccountCode { get; set; } public virtual BoYesNoEnum RevaluationCoordinated { get; set; } public virtual BoYesNoEnum TaxExemptAccount { get; set; } public virtual BoYesNoEnum TaxLiableAccount { get; set; } public virtual string TransactionCode { get; set; } public virtual SAPbobsCOM.UserFields UserFields { get; } public virtual BoYesNoEnum ValidFor { get; set; } public virtual DateTime ValidFrom { get; set; } public virtual string ValidRemarks { get; set; } public virtual DateTime ValidTo { get; set; } public virtual string VATRegNum { get; } public extern ChartOfAccountsClass(); public virtual extern int Add(); public virtual extern string GetAsXML(); public virtual extern bool GetByKey(string AccountCode); public virtual extern int Remove(); public virtual extern void SaveToFile( string FileName); public virtual extern void SaveXML( ref string FileName); public virtual extern int Update(); }

Related information

BoAccountTypes Enumeration

Specifies the type of account in Chart of Accounts.

Parent: Chart Of Accounts ChartOfAccounts Object· Table: OACT

SPEDContabilAccountPurposeCode Enumeration

Parent: Chart Of Accounts ChartOfAccounts Object· Table: OACT

PeriodCategory Object

The PeriodCategory object is a data structure related to the CompanyService. The PeriodCategory object provides two types of properties: Properties that access existing Accounts and function as foreign keys to ChartOfAccounts Object....

Parent: Company Service CompanyService Service