Capital asset balance

This table contains one row for each accounting period having some flow, per capital asset.

PropertyValueDescription
DatabaseCompanyThis table is in the company databases.
SQL namePropBalThe table name in the database.
API identifiercapitalAssetBalanceThe API identifier used in GraphQL.
Table no.172The table number in the data model.

The following fields exist in this table:

Acq.

Investment flow, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL namePurcChThe database field name.
API identifierinvestmentFlowDomesticThe API identifier used in GraphQL.
Number5536 

Acq. in currency

Investment flow, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCPurcChThe database field name.
API identifierinvestmentFlowInCurrencyThe API identifier used in GraphQL.
Number14254 

Acq. in currency 2

Investment flow, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameC2PurcChThe database field name.
API identifierinvestmentFlowInCurrency2The API identifier used in GraphQL.
Number15203 

Addition

Addition flow, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAddChThe database field name.
API identifieradditionFlowDomesticThe API identifier used in GraphQL.
Number5769 

Addition in currency

Addition flow, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCAddChThe database field name.
API identifieradditionFlowInCurrencyThe API identifier used in GraphQL.
Number14257 

Addition in currency 2

Addition flow, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameC2AddChThe database field name.
API identifieradditionFlowInCurrency2The API identifier used in GraphQL.
Number15206 

Cap. asset no.

The capital asset number.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainCap. asset no.Integer
Primary keyYesCap. asset no., Year, Period
Write AccessNoneYou are not allowed to modify the value in this field.
SQL namePropNoThe database field name.
API identifiercapitalAssetNoThe API identifier used in GraphQL.
Number5517 
Table 1. Table relations
To tablePurposeFrom columnsTo columnsComments
Capital assetCapitalAsset
  • Cap. asset no.

CB

Net closing balance , in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiercbDomesticThe API identifier used in GraphQL.
Number5532 

CB acq.

Investment closing balance, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierinvestmentCbDomesticThe API identifier used in GraphQL.
Number5537 

CB acq. in currency

Investment closing balance, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierinvestmentCbInCurrencyThe API identifier used in GraphQL.
Number14255 

CB acq. in currency 2

Investment closing balance, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierinvestmentCbInCurrency2The API identifier used in GraphQL.
Number15204 

CB addition

Addition closing balance, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifieradditionCbDomesticThe API identifier used in GraphQL.
Number5770 

CB addition in currency

Addition closing balance, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifieradditionCbInCurrencyThe API identifier used in GraphQL.
Number14258 

CB addition in currency 2

Addition closing balance, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifieradditionCbInCurrency2The API identifier used in GraphQL.
Number15207 

CB devalue

Devaluation closing balance, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdevaluationCbDomesticThe API identifier used in GraphQL.
Number5543 

CB devalue in currency

Devaluation closing balance, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdevaluationCbInCurrencyThe API identifier used in GraphQL.
Number14264 

CB devalue in currency 2

Devaluation closing balance, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdevaluationCbInCurrency2The API identifier used in GraphQL.
Number15213 

CB discard.

Discarded closing balance, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdiscardedCbDomesticThe API identifier used in GraphQL.
Number5773 

CB discard. in currency

Discarded closing balance, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdiscardedCbInCurrencyThe API identifier used in GraphQL.
Number14273 

CB discard. in currency 2

Discarded closing balance, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdiscardedCbInCurrency2The API identifier used in GraphQL.
Number15222 

CB in currency

Net closing balance , in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiercbInCurrencyThe API identifier used in GraphQL.
Number14250 

CB in currency 2

Net closing balance , in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiercbInCurrency2The API identifier used in GraphQL.
Number15199 

CB revalue

Revaluation closing balance, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierrevaluationCbDomesticThe API identifier used in GraphQL.
Number5540 

CB revalue in currency

Revaluation closing balance, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierrevaluationCbInCurrencyThe API identifier used in GraphQL.
Number14261 

CB revalue in currency 2

Revaluation closing balance, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierrevaluationCbInCurrency2The API identifier used in GraphQL.
Number15210 

CB reversed accum. depreciation

Reversed accumulated depreciation closing balance, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierreversedAccumulatedDepreciationCbDomesticThe API identifier used in GraphQL.
Number8280 

CB reversed accum. depreciation in currency

Reversed accumulated depreciation closing balance, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierreversedAccumulatedDepreciationCbInCurrencyThe API identifier used in GraphQL.
Number14276 

CB reversed accum. depreciation in currency 2

Reversed accumulated depreciation closing balance, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierreversedAccumulatedDepreciationCbInCurrency2The API identifier used in GraphQL.
Number15225 

CB sale

Sales closing balance, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiersalesCbDomesticThe API identifier used in GraphQL.
Number5549 

CB sale in currency

Sales closing balance, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiersalesCbInCurrencyThe API identifier used in GraphQL.
Number14270 

CB sale in currency 2

Sales closing balance, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiersalesCbInCurrency2The API identifier used in GraphQL.
Number15219 

Credit CB

Net credit closing balance , in the default currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnCBCredit
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiercreditCbDomesticThe API identifier used in GraphQL.
Number5534 

Credit CB in currency

Net credit closing balance , in the actual currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnCB in currencyCredit
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiercreditCbInCurrencyThe API identifier used in GraphQL.
Number14252 

Credit CB in currency 2

Net credit closing balance , in currency 2.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnCB in currency 2Credit
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiercreditCbInCurrency2The API identifier used in GraphQL.
Number15201 

Credit flow

Net credit flow , in the default currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnFlowCredit
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiercreditFlowDomesticThe API identifier used in GraphQL.
Number5529 

Credit flow in currency

Net credit flow , in the actual currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnFlow in currencyCredit
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiercreditFlowInCurrencyThe API identifier used in GraphQL.
Number14247 

Credit flow in currency 2

Net credit flow , in currency 2.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnFlow in currency 2Credit
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiercreditFlowInCurrency2The API identifier used in GraphQL.
Number15196 

Credit OB

Net credit opening balance , in the default currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnOBCredit
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiercreditObDomesticThe API identifier used in GraphQL.
Number5524 

Credit OB in currency

Net credit opening balance , in the actual currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnOB in currencyCredit
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiercreditObInCurrencyThe API identifier used in GraphQL.
Number14242 

Credit OB in currency 2

Net credit opening balance , in currency 2.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnOB in currency 2Credit
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiercreditObInCurrency2The API identifier used in GraphQL.
Number15191 

Debit CB

Net debit closing balance , in the default currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnCBDebit
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdebitCbDomesticThe API identifier used in GraphQL.
Number5533 

Debit CB in currency

Net debit closing balance , in the actual currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnCB in currencyDebit
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdebitCbInCurrencyThe API identifier used in GraphQL.
Number14251 

Debit CB in currency 2

Net debit closing balance , in currency 2.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnCB in currency 2Debit
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdebitCbInCurrency2The API identifier used in GraphQL.
Number15200 

Debit flow

Net debit flow , in the default currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnFlowDebit
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdebitFlowDomesticThe API identifier used in GraphQL.
Number5528 

Debit flow in currency

Net debit flow , in the actual currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnFlow in currencyDebit
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdebitFlowInCurrencyThe API identifier used in GraphQL.
Number14246 

Debit flow in currency 2

Net debit flow , in currency 2.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnFlow in currency 2Debit
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdebitFlowInCurrency2The API identifier used in GraphQL.
Number15195 

Debit OB

Net debit opening balance , in the default currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnOBDebit
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdebitObDomesticThe API identifier used in GraphQL.
Number5523 

Debit OB in currency

Net debit opening balance , in the actual currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnOB in currencyDebit
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdebitObInCurrencyThe API identifier used in GraphQL.
Number14241 

Debit OB in currency 2

Net debit opening balance , in currency 2.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnOB in currency 2Debit
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdebitObInCurrency2The API identifier used in GraphQL.
Number15190 

Devaluation

Devaluation flow, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameWrDnChThe database field name.
API identifierdevaluationFlowDomesticThe API identifier used in GraphQL.
Number5542 

Devaluation in currency

Devaluation flow, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCWrDnChThe database field name.
API identifierdevaluationFlowInCurrencyThe API identifier used in GraphQL.
Number14263 

Devaluation in currency 2

Devaluation flow, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameC2WrDnChThe database field name.
API identifierdevaluationFlowInCurrency2The API identifier used in GraphQL.
Number15212 

Discard

Discarded flow, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDiscChThe database field name.
API identifierdiscardedFlowDomesticThe API identifier used in GraphQL.
Number5772 

Discard in currency

Discarded flow, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCDiscChThe database field name.
API identifierdiscardedFlowInCurrencyThe API identifier used in GraphQL.
Number14272 

Discard in currency 2

Discarded flow, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameC2DiscChThe database field name.
API identifierdiscardedFlowInCurrency2The API identifier used in GraphQL.
Number15221 

Flow

Net flow , in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierflowDomesticThe API identifier used in GraphQL.
Number5527 

Flow in currency

Net flow , in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierflowInCurrencyThe API identifier used in GraphQL.
Number14245 

Flow in currency 2

Net flow , in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierflowInCurrency2The API identifier used in GraphQL.
Number15194 

Inv. after CB

Investment after depreciation closing balance, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierinvestmentAfterDepreciationCbDomesticThe API identifier used in GraphQL.
Number12841 

Inv. after CB in currency

Investment after depreciation closing balance, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierinvestmentAfterDepreciationCbInCurrencyThe API identifier used in GraphQL.
Number14291 

Inv. after CB in currency 2

Investment after depreciation closing balance, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierinvestmentAfterDepreciationCbInCurrency2The API identifier used in GraphQL.
Number15240 

Inv. after flow

Investment after depreciation flow, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierinvestmentAfterDepreciationFlowDomesticThe API identifier used in GraphQL.
Number12840 

Inv. after flow in currency

Investment after depreciation flow, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierinvestmentAfterDepreciationFlowInCurrencyThe API identifier used in GraphQL.
Number14290 

Inv. after flow in currency 2

Investment after depreciation flow, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierinvestmentAfterDepreciationFlowInCurrency2The API identifier used in GraphQL.
Number15239 

Inv. after WO OB

Investment after depreciation opening balance, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierinvestmentAfterDepreciationObDomesticThe API identifier used in GraphQL.
Number12839 

Inv. after WO OB in currency

Investment after depreciation opening balance, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierinvestmentAfterDepreciationObInCurrencyThe API identifier used in GraphQL.
Number14289 

Inv. after WO OB in currency 2

Investment after depreciation opening balance, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierinvestmentAfterDepreciationObInCurrency2The API identifier used in GraphQL.
Number15238 

Inv. write off CB

Depreciation of investment closing balance, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdepreciationOfInvestmentCbDomesticThe API identifier used in GraphQL.
Number12685 

Inv. write off CB in currency

Depreciation of investment closing balance, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdepreciationOfInvestmentCbInCurrencyThe API identifier used in GraphQL.
Number14279 

Inv. write off CB in currency 2

Depreciation of investment closing balance, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdepreciationOfInvestmentCbInCurrency2The API identifier used in GraphQL.
Number15228 

Inv. write off flow

Depreciation of investment flow, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL namePuWOChThe database field name.
API identifierdepreciationOfInvestmentFlowDomesticThe API identifier used in GraphQL.
Number12684 

Inv. write off flow in currency

Depreciation of investment flow, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCPuWOChThe database field name.
API identifierdepreciationOfInvestmentFlowInCurrencyThe API identifier used in GraphQL.
Number14278 

Inv. write off flow in currency 2

Depreciation of investment flow, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameC2PuWOChThe database field name.
API identifierdepreciationOfInvestmentFlowInCurrency2The API identifier used in GraphQL.
Number15227 

Inv. write off OB

Depreciation of investment opening balance, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL namePuWOIBThe database field name.
API identifierdepreciationOfInvestmentObDomesticThe API identifier used in GraphQL.
Number12683 

Inv. write off OB in currency

Depreciation of investment opening balance, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCPuWOIBThe database field name.
API identifierdepreciationOfInvestmentObInCurrencyThe API identifier used in GraphQL.
Number14277 

Inv. write off OB in currency 2

Depreciation of investment opening balance, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameC2PuWOIBThe database field name.
API identifierdepreciationOfInvestmentObInCurrency2The API identifier used in GraphQL.
Number15226 

OB

Net opening balance , in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierobDomesticThe API identifier used in GraphQL.
Number5522 

OB acq.

Investment opening balance, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL namePurcIBThe database field name.
API identifierinvestmentObDomesticThe API identifier used in GraphQL.
Number5535 

OB acq. in currency

Investment opening balance, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCPurcIBThe database field name.
API identifierinvestmentObInCurrencyThe API identifier used in GraphQL.
Number14253 

OB acq. in currency 2

Investment opening balance, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameC2PurcIBThe database field name.
API identifierinvestmentObInCurrency2The API identifier used in GraphQL.
Number15202 

OB addition

Addition opening balance, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAddIBThe database field name.
API identifieradditionObDomesticThe API identifier used in GraphQL.
Number5768 

OB addition in currency

Addition opening balance, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCAddIBThe database field name.
API identifieradditionObInCurrencyThe API identifier used in GraphQL.
Number14256 

OB addition in currency 2

Addition opening balance, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameC2AddIBThe database field name.
API identifieradditionObInCurrency2The API identifier used in GraphQL.
Number15205 

OB devalue

Devaluation opening balance, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameWrDnIBThe database field name.
API identifierdevaluationObDomesticThe API identifier used in GraphQL.
Number5541 

OB devalue in currency

Devaluation opening balance, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCWrDnIBThe database field name.
API identifierdevaluationObInCurrencyThe API identifier used in GraphQL.
Number14262 

OB devalue in currency 2

Devaluation opening balance, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameC2WrDnIBThe database field name.
API identifierdevaluationObInCurrency2The API identifier used in GraphQL.
Number15211 

OB discard.

Discarded opening balance, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDiscIBThe database field name.
API identifierdiscardedObDomesticThe API identifier used in GraphQL.
Number5771 

OB discard. in currency

Discarded opening balance, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCDiscIBThe database field name.
API identifierdiscardedObInCurrencyThe API identifier used in GraphQL.
Number14271 

OB discard. in currency 2

Discarded opening balance, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameC2DiscIBThe database field name.
API identifierdiscardedObInCurrency2The API identifier used in GraphQL.
Number15220 

OB in currency

Net opening balance , in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierobInCurrencyThe API identifier used in GraphQL.
Number14240 

OB in currency 2

Net opening balance , in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierobInCurrency2The API identifier used in GraphQL.
Number15189 

OB revalue

Revaluation opening balance, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameWrUpIBThe database field name.
API identifierrevaluationObDomesticThe API identifier used in GraphQL.
Number5538 

OB revalue in currency

Revaluation opening balance, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCWrUpIBThe database field name.
API identifierrevaluationObInCurrencyThe API identifier used in GraphQL.
Number14259 

OB revalue in currency 2

Revaluation opening balance, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameC2WrUpIBThe database field name.
API identifierrevaluationObInCurrency2The API identifier used in GraphQL.
Number15208 

OB reversed accum. depreciation

Reversed accumulated depreciation opening balance, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameWAWrOfIBThe database field name.
API identifierreversedAccumulatedDepreciationObDomesticThe API identifier used in GraphQL.
Number8278 

OB reversed accum. depreciation in currency

Reversed accumulated depreciation opening balance, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCWAWrOIBThe database field name.
API identifierreversedAccumulatedDepreciationObInCurrencyThe API identifier used in GraphQL.
Number14274 

OB reversed accum. depreciation in currency 2

Reversed accumulated depreciation opening balance, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameC2WAWrOIBThe database field name.
API identifierreversedAccumulatedDepreciationObInCurrency2The API identifier used in GraphQL.
Number15223 

OB sale

Sales opening balance, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameSaleIBThe database field name.
API identifiersalesObDomesticThe API identifier used in GraphQL.
Number5547 

OB sale in currency

Sales opening balance, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCSaleIBThe database field name.
API identifiersalesObInCurrencyThe API identifier used in GraphQL.
Number14268 

OB sale in currency 2

Sales opening balance, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameC2SaleIBThe database field name.
API identifiersalesObInCurrency2The API identifier used in GraphQL.
Number15217 

Period

The accounting period.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainPeriodInteger
Primary keyYesCap. asset no., Year, Period
Write AccessNoneYou are not allowed to modify the value in this field.
SQL namePrThe database field name.
API identifierperiodThe API identifier used in GraphQL.
Number5519 
Table 2. Table relations
To tablePurposeFrom columnsTo columnsComments
Accounting periodAccountingPeriod
  • Year
  • Period
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Revaluation

Revaluation flow, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameWrUpChThe database field name.
API identifierrevaluationFlowDomesticThe API identifier used in GraphQL.
Number5539 

Revaluation in currency

Revaluation flow, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCWrUpChThe database field name.
API identifierrevaluationFlowInCurrencyThe API identifier used in GraphQL.
Number14260 

Revaluation in currency 2

Revaluation flow, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameC2WrUpChThe database field name.
API identifierrevaluationFlowInCurrency2The API identifier used in GraphQL.
Number15209 

Reversed accumulated depreciation

Reversed accumulated depreciation flow, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameWAWrOfChThe database field name.
API identifierreversedAccumulatedDepreciationFlowDomesticThe API identifier used in GraphQL.
Number8279 

Reversed accumulated depreciation in currency

Reversed accumulated depreciation flow, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCWAWrOChThe database field name.
API identifierreversedAccumulatedDepreciationFlowInCurrencyThe API identifier used in GraphQL.
Number14275 

Reversed accumulated depreciation in currency 2

Reversed accumulated depreciation flow, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameC2WAWrOChThe database field name.
API identifierreversedAccumulatedDepreciationFlowInCurrency2The API identifier used in GraphQL.
Number15224 

Sale

Sales flow, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameSaleChThe database field name.
API identifiersalesFlowDomesticThe API identifier used in GraphQL.
Number5548 

Sale in currency

Sales flow, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCSaleChThe database field name.
API identifiersalesFlowInCurrencyThe API identifier used in GraphQL.
Number14269 

Sale in currency 2

Sales flow, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameC2SaleChThe database field name.
API identifiersalesFlowInCurrency2The API identifier used in GraphQL.
Number15218 

Sum CB Write off

Sum depreciation closing balance, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiersumDepreciationCbDomesticThe API identifier used in GraphQL.
Number12838 

Sum CB Write off in currency

Sum depreciation closing balance, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiersumDepreciationCbInCurrencyThe API identifier used in GraphQL.
Number14288 

Sum CB Write off in currency 2

Sum depreciation closing balance, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiersumDepreciationCbInCurrency2The API identifier used in GraphQL.
Number15237 

Sum credit CB

Sum credit closing balance , in the default currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiersumCreditCbDomesticThe API identifier used in GraphQL.
Number5531 

Sum credit CB in currency

Sum credit closing balance , in the actual currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiersumCreditCbInCurrencyThe API identifier used in GraphQL.
Number14249 

Sum credit CB in currency 2

Sum credit closing balance , in currency 2.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiersumCreditCbInCurrency2The API identifier used in GraphQL.
Number15198 

Sum credit flow

Sum credit flow , in the default currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCrChThe database field name.
API identifiersumCreditFlowDomesticThe API identifier used in GraphQL.
Number5526 

Sum credit flow in currency

Sum credit flow, in the actual currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCrCurChThe database field name.
API identifiersumCreditFlowInCurrencyThe API identifier used in GraphQL.
Number14244 

Sum credit flow in currency 2

Sum credit flow, in currency 2.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCrCur2ChThe database field name.
API identifiersumCreditFlowInCurrency2The API identifier used in GraphQL.
Number15193 

Sum credit OB

Sum credit opening balance , in the default currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCrIBThe database field name.
API identifiersumCreditObDomesticThe API identifier used in GraphQL.
Number5521 

Sum credit OB in currency

Sum credit opening balance , in the actual currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCrCurIBThe database field name.
API identifiersumCreditObInCurrencyThe API identifier used in GraphQL.
Number14239 

Sum credit OB in currency 2

Sum credit opening balance , in currency 2.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCrCur2IBThe database field name.
API identifiersumCreditObInCurrency2The API identifier used in GraphQL.
Number15188 

Sum debit CB

Sum debit closing balance , in the default currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiersumDebitCbDomesticThe API identifier used in GraphQL.
Number5530 

Sum debit CB in currency

Sum debit closing balance , in the actual currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiersumDebitCbInCurrencyThe API identifier used in GraphQL.
Number14248 

Sum debit CB in currency 2

Sum debit closing balance , in currency 2.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiersumDebitCbInCurrency2The API identifier used in GraphQL.
Number15197 

Sum debit flow

Sum debit flow , in the default currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDbChThe database field name.
API identifiersumDebitFlowDomesticThe API identifier used in GraphQL.
Number5525 

Sum debit flow in currency

Sum debit flow , in the actual currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDbCurChThe database field name.
API identifiersumDebitFlowInCurrencyThe API identifier used in GraphQL.
Number14243 

Sum debit flow in currency 2

Sum debit flow , in currency 2.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDbCur2ChThe database field name.
API identifiersumDebitFlowInCurrency2The API identifier used in GraphQL.
Number15192 

Sum debit OB

Sum debit opening balance , in the default currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDbIBThe database field name.
API identifiersumDebitObDomesticThe API identifier used in GraphQL.
Number5520 

Sum debit OB in currency

Sum debit opening balance , in the actual currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDbCurIBThe database field name.
API identifiersumDebitObInCurrencyThe API identifier used in GraphQL.
Number14238 

Sum debit OB in currency 2

Sum debit opening balance , in currency 2.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDbCur2IBThe database field name.
API identifiersumDebitObInCurrency2The API identifier used in GraphQL.
Number15187 

Sum flow Write off

Sum depreciation flow, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiersumDepreciationFlowDomesticThe API identifier used in GraphQL.
Number12837 

Sum flow Write off in currency

Sum depreciation flow, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiersumDepreciationFlowInCurrencyThe API identifier used in GraphQL.
Number14287 

Sum flow Write off in currency 2

Sum depreciation flow, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiersumDepreciationFlowInCurrency2The API identifier used in GraphQL.
Number15236 

Sum OB Write off

Sum depreciation opening balance, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiersumDepreciationObDomesticThe API identifier used in GraphQL.
Number12836 

Sum OB Write off in currency

Sum depreciation opening balance, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiersumDepreciationObInCurrencyThe API identifier used in GraphQL.
Number14286 

Sum OB Write off in currency 2

Sum depreciation opening balance, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiersumDepreciationObInCurrency2The API identifier used in GraphQL.
Number15235 

Write down after write off CB

Devaluation after depreciation closing balance, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdevaluationAfterDepreciationCbDomesticThe API identifier used in GraphQL.
Number16191 

Write down after write off CB in currency

Devaluation after depreciation closing balance, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdevaluationAfterDepreciationCbInCurrencyThe API identifier used in GraphQL.
Number16198 

Write down after write off CB in currency 2

Devaluation after depreciation closing balance, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdevaluationAfterDepreciationCbInCurrency2The API identifier used in GraphQL.
Number16204 

Write down after write off flow

Devaluation after depreciation flow, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdevaluationAfterDepreciationFlowDomesticThe API identifier used in GraphQL.
Number16192 

Write down after write off flow in currency

Devaluation after depreciation flow, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdevaluationAfterDepreciationFlowInCurrencyThe API identifier used in GraphQL.
Number16197 

Write down after write off flow in currency 2

Devaluation after depreciation flow, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdevaluationAfterDepreciationFlowInCurrency2The API identifier used in GraphQL.
Number16203 

Write down after write off OB

Devaluation after depreciation opening balance, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdevaluationAfterDepreciationObDomesticThe API identifier used in GraphQL.
Number16190 

Write down after write off OB in currency

Devaluation after depreciation opening balance, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdevaluationAfterDepreciationObInCurrencyThe API identifier used in GraphQL.
Number16196 

Write down after write off OB in currency 2

Devaluation after depreciation opening balance, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdevaluationAfterDepreciationObInCurrency2The API identifier used in GraphQL.
Number16202 

Write off add. after WO CB

Addition after depreciation closing balance, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifieradditionAfterDepreciationCbDomesticThe API identifier used in GraphQL.
Number12844 

Write off add. after WO CB in currency

Addition after depreciation closing balance, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifieradditionAfterDepreciationCbInCurrencyThe API identifier used in GraphQL.
Number14294 

Write off add. after WO CB in currency 2

Addition after depreciation closing balance, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifieradditionAfterDepreciationCbInCurrency2The API identifier used in GraphQL.
Number15243 

Write off add. after WO flow

Addition after depreciation flow, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifieradditionAfterDepreciationFlowDomesticThe API identifier used in GraphQL.
Number12843 

Write off add. after WO flow in currency

Addition after depreciation flow, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifieradditionAfterDepreciationFlowInCurrencyThe API identifier used in GraphQL.
Number14293 

Write off add. after WO flow in currency 2

Addition after depreciation flow, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifieradditionAfterDepreciationFlowInCurrency2The API identifier used in GraphQL.
Number15242 

Write off add. after WO OB

Addition after depreciation opening balance, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifieradditionAfterDepreciationObDomesticThe API identifier used in GraphQL.
Number12842 

Write off add. after WO OB in currency

Addition after depreciation opening balance, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifieradditionAfterDepreciationObInCurrencyThe API identifier used in GraphQL.
Number14292 

Write off add. after WO OB in currency 2

Addition after depreciation opening balance, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifieradditionAfterDepreciationObInCurrency2The API identifier used in GraphQL.
Number15241 

Write off add. CB

Depreciation of addition closing balance, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdepreciationOfAdditionCbDomesticThe API identifier used in GraphQL.
Number12691 

Write off add. CB in currency

Depreciation of addition closing balance, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdepreciationOfAdditionCbInCurrencyThe API identifier used in GraphQL.
Number14282 

Write off add. CB in currency 2

Depreciation of addition closing balance, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdepreciationOfAdditionCbInCurrency2The API identifier used in GraphQL.
Number15231 

Write off add. flow

Depreciation of addition flow, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameWOAddChThe database field name.
API identifierdepreciationOfAdditionFlowDomesticThe API identifier used in GraphQL.
Number12690 

Write off add. flow in currency

Depreciation of addition flow, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCWOAddChThe database field name.
API identifierdepreciationOfAdditionFlowInCurrencyThe API identifier used in GraphQL.
Number14281 

Write off add. flow in currency 2

Depreciation of addition flow, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameC2WOAddChThe database field name.
API identifierdepreciationOfAdditionFlowInCurrency2The API identifier used in GraphQL.
Number15230 

Write off add. OB

Depreciation of addition opening balance, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameWOAddIBThe database field name.
API identifierdepreciationOfAdditionObDomesticThe API identifier used in GraphQL.
Number12689 

Write off add. OB in currency

Depreciation of addition opening balance, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCWOAddIBThe database field name.
API identifierdepreciationOfAdditionObInCurrencyThe API identifier used in GraphQL.
Number14280 

Write off add. OB in currency 2

Depreciation of addition opening balance, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameC2WOAddIBThe database field name.
API identifierdepreciationOfAdditionObInCurrency2The API identifier used in GraphQL.
Number15229 

Write off of Write up CB

Depreciation of revaluation closing balance, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdepreciationOfRevaluationCbDomesticThe API identifier used in GraphQL.
Number12697 

Write off of Write up CB in currency

Depreciation of revaluation closing balance, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdepreciationOfRevaluationCbInCurrencyThe API identifier used in GraphQL.
Number14285 

Write off of Write up CB in currency 2

Depreciation of revaluation closing balance, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdepreciationOfRevaluationCbInCurrency2The API identifier used in GraphQL.
Number15234 

Write off of Write up flow

Depreciation of revaluation flow, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameWOWUChThe database field name.
API identifierdepreciationOfRevaluationFlowDomesticThe API identifier used in GraphQL.
Number12696 

Write off of Write up flow in currency

Depreciation of revaluation flow, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCWOWUChThe database field name.
API identifierdepreciationOfRevaluationFlowInCurrencyThe API identifier used in GraphQL.
Number14284 

Write off of Write up flow in currency 2

Depreciation of revaluation flow, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameC2WOWUChThe database field name.
API identifierdepreciationOfRevaluationFlowInCurrency2The API identifier used in GraphQL.
Number15233 

Write off of Write up OB

Depreciation of revaluation opening balance, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameWOWUIBThe database field name.
API identifierdepreciationOfRevaluationObDomesticThe API identifier used in GraphQL.
Number12695 

Write off of Write up OB in currency

Depreciation of revaluation opening balance, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCWOWUIBThe database field name.
API identifierdepreciationOfRevaluationObInCurrencyThe API identifier used in GraphQL.
Number14283 

Write off of Write up OB in currency 2

Depreciation of revaluation opening balance, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameC2WOWUIBThe database field name.
API identifierdepreciationOfRevaluationObInCurrency2The API identifier used in GraphQL.
Number15232 

Write up after write off CB

Revaluation after depreciation closing balance, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierrevaluationAfterDepreciationCbDomesticThe API identifier used in GraphQL.
Number12846 

Write up after write off CB in currency

Revaluation after depreciation closing balance, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierrevaluationAfterDepreciationCbInCurrencyThe API identifier used in GraphQL.
Number14297 

Write up after write off CB in currency 2

Revaluation after depreciation closing balance, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierrevaluationAfterDepreciationCbInCurrency2The API identifier used in GraphQL.
Number15246 

Write up after write off flow

Revaluation after depreciation flow, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierrevaluationAfterDepreciationFlowDomesticThe API identifier used in GraphQL.
Number12847 

Write up after write off flow in currency

Revaluation after depreciation flow, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierrevaluationAfterDepreciationFlowInCurrencyThe API identifier used in GraphQL.
Number14296 

Write up after write off flow in currency 2

Revaluation after depreciation flow, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierrevaluationAfterDepreciationFlowInCurrency2The API identifier used in GraphQL.
Number15245 

Write up after write off OB

Revaluation after depreciation opening balance, in the default currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierrevaluationAfterDepreciationObDomesticThe API identifier used in GraphQL.
Number12845 

Write up after write off OB in currency

Revaluation after depreciation opening balance, in the actual currency.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierrevaluationAfterDepreciationObInCurrencyThe API identifier used in GraphQL.
Number14295 

Write up after write off OB in currency 2

Revaluation after depreciation opening balance, in currency 2.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierrevaluationAfterDepreciationObInCurrency2The API identifier used in GraphQL.
Number15244 

Year

The accounting year.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainYearInteger
Primary keyYesCap. asset no., Year, Period
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameYrThe database field name.
API identifieryearThe API identifier used in GraphQL.
Number5518 
Table 3. Table relations
To tablePurposeFrom columnsTo columnsComments
Accounting periodAccountingPeriod
  • Year
  • Period
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Control columns

Control columns include information about who has changed the record last and when, and which process that is currently editing the record.

Changed by provenance

The provenance for the record change.

A look-up in this field gives you the following list of possible values:

0 - None

1 - UI

10 - External API

20 - GAiA

21 - AI Connect

100 - Internal service

101 - Task automation

102 - AutoInvoice download

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProvenanceInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChPvnThe database field name.
API identifierchangedByProvenanceThe API identifier used in GraphQL.
NumberA unique column number. 

Changed by user

The name of the user that changed the record.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainUser nameText (24)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChUsrThe database field name.
API identifierchangedByUserThe API identifier used in GraphQL.
NumberA unique column number. 

Changed date

The date when the record was changed.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChDtThe database field name.
API identifierchangedDateThe API identifier used in GraphQL.
NumberA unique column number. 

Changed time

The time when the record was changed.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTimeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChTmThe database field name.
API identifierchangedTimeThe API identifier used in GraphQL.
NumberA unique column number. 

Changed time stamp

The date and time when the record was changed.

The field is updated with the UTC time.

This value can be used by external systems to replicate changed data. The column is indexed. 

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDate/timeDateTime
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChTsThe database field name.
API identifierchangedTimestampThe API identifier used in GraphQL.
NumberA unique column number. 

Created by provenance

The provenance for the record creation.

A look-up in this field gives you the following list of possible values:

0 - None

1 - UI

10 - External API

20 - GAiA

21 - AI Connect

100 - Internal service

101 - Task automation

102 - AutoInvoice download

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProvenanceInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCrePvnThe database field name.
API identifiercreatedByProvenanceThe API identifier used in GraphQL.
NumberA unique column number. 

Created by user

The name of the user that created the record.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainUser nameText (24)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreUsrThe database field name.
API identifiercreatedByUserThe API identifier used in GraphQL.
NumberA unique column number. 

Created date

The date when the record was created.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreDtThe database field name.
API identifiercreatedDateThe API identifier used in GraphQL.
NumberA unique column number. 

Created time

The time when the record was created.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTimeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreTmThe database field name.
API identifiercreatedTimeThe API identifier used in GraphQL.
NumberA unique column number. 

Created time stamp

The date and time when the record was created.

The field is updated with the UTC time.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDate/timeDateTime
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreTsThe database field name.
API identifiercreatedTimestampThe API identifier used in GraphQL.
NumberA unique column number. 

Edit status

The current status of the record.

A look-up in this field gives you the following list of possible values:

0 - Unchanged: The record is read, but not changed.

1 - Inserted: The record is new.

2 - Changed: The record is changed.

3 - Deleted: The record is deleted.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainEdit statusInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameLckStThe database field name.
API identifiereditStatusThe API identifier used in GraphQL.
NumberA unique column number. 

Process no

The Process no. from the Active company process table which is currently using or has control of this record.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProcess no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChPrcThe database field name.
API identifierlockedByProcessNoThe API identifier used in GraphQL.
NumberA unique column number. 
Table 4. Table relations
To table Purpose From columns To columns Comments
Active company process CompanyProcess Process no. Process no.