General ledger period balances
This table is defined as a view in the database, and contains one row for each accounting period having some flow, per general ledger account.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is a view in the company databases. |
| View name | AcBalV | This table is a view and only displayed in the program, it is not stored in the database. |
| API identifier | generalLedgerPeriodBalance | The API identifier used in GraphQL. |
| Table no. | 456 | The table number in the data model. |
The following fields exist in this table:
Account no.
The general ledger account number.
Note:
If you double-click or press * in
this field, you can look up a value in the related table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| Primary key | Yes | Account no., Year, Period |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AcNo | The database field name. |
| API identifier | accountNo | The API identifier used in GraphQL. |
| Number | 19588 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | GeneralLedgerAccount |
|
CB
Net closing balance , in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AmCb | The database field name. |
| API identifier | cbDomestic | The API identifier used in GraphQL. |
| Number | 19593 |
CB quantity
Net closing balance , in quantity.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | QtyCb | The database field name. |
| API identifier | cbQuantity | The API identifier used in GraphQL. |
| Number | 19596 |
Flow
Net flow , in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AmFlow | The database field name. |
| API identifier | flowDomestic | The API identifier used in GraphQL. |
| Number | 19592 |
Flow quantity
Net flow , in quantity.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | QtyFlow | The database field name. |
| API identifier | flowQuantity | The API identifier used in GraphQL. |
| Number | 19595 |
OB
Net opening balance , in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AmOb | The database field name. |
| API identifier | obDomestic | The API identifier used in GraphQL. |
| Number | 19591 |
OB quantity
Net opening balance , in quantity.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | QtyOb | The database field name. |
| API identifier | obQuantity | The API identifier used in GraphQL. |
| Number | 19594 |
Period
The accounting period.
Note:
If you double-click or press * in
this field, you can look up a value in the related table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Period | Integer |
| Primary key | Yes | Account no., Year, Period |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Pr | The database field name. |
| API identifier | period | The API identifier used in GraphQL. |
| Number | 19590 |
Year
The accounting year.
Note:
If you double-click or press * in
this field, you can look up a value in the related table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Year | Integer |
| Primary key | Yes | Account no., Year, Period |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Yr | The database field name. |
| API identifier | year | The API identifier used in GraphQL. |
| Number | 19589 |