Supplier balance
This table contains one row for each accounting period having some flow, per supplier.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | SupBal | The table name in the database. |
| API identifier | supplierBalance | The API identifier used in GraphQL. |
| Table no. | 63 | The table number in the data model. |
The following fields exist in this table:
Age distribution
Amount due up to the first number of days stated (in the default currency), on Balance list for suppliers reports with age distribution.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | ageDistribution1 | The API identifier used in GraphQL. |
| Number | 2265 |
Age distribution
Amount due between the first and second number of days stated (in the default currency), on Balance list for suppliers reports with age distribution.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | ageDistribution2 | The API identifier used in GraphQL. |
| Number | 2266 |
Age distribution
Amount due between the second and third number of days stated (in the default currency), on Balance list for suppliers reports with age distribution.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | ageDistribution3 | The API identifier used in GraphQL. |
| Number | 2267 |
Age distribution
Amount due between the third and fourth number of days stated (in the default currency), on Balance list for suppliers reports with age distribution.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | ageDistribution4 | The API identifier used in GraphQL. |
| Number | 2268 |
Age distribution
Amount due between the fourth and fifth number of days stated (in the default currency), on Balance list for suppliers reports with age distribution.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | ageDistribution5 | The API identifier used in GraphQL. |
| Number | 2269 |
Age distribution
Amount due above the last number of days stated (in the default currency), on Balance list for suppliers reports with age distribution.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | ageDistribution6 | The API identifier used in GraphQL. |
| Number | 2270 |
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. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | cbDomestic | The API identifier used in GraphQL. |
| Number | 1438 |
CB in currency
Net closing balance , in the actual 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. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | cbInCurrency | The API identifier used in GraphQL. |
| Number | 1442 |
CB in currency 2
Net closing balance , in currency 2.
| 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. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | cbInCurrency2 | The API identifier used in GraphQL. |
| Number | 14961 |
CB purchase
Net closing purchase 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. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | cbPurchase | The API identifier used in GraphQL. |
| Number | 1445 |
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. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | cbQuantity | The API identifier used in GraphQL. |
| Number | 2242 |
Credit CB
Net credit closing balance , in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | CB | Credit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditCbDomestic | The API identifier used in GraphQL. |
| Number | 5359 |
Credit CB in currency
Net credit closing balance , in the actual currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | CB in currency | Credit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditCbInCurrency | The API identifier used in GraphQL. |
| Number | 5367 |
Credit CB in currency 2
Net credit closing balance , in currency 2.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | CB in currency 2 | Credit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditCbInCurrency2 | The API identifier used in GraphQL. |
| Number | 14963 |
Credit CB purchase
Net credit closing purchase balance (in the default currency).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | CB purchase | Credit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditCbPurchase | The API identifier used in GraphQL. |
| Number | 5385 |
Credit CB quantity
Net credit closing balance , in quantity.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Source column | CB quantity | Credit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditCbQuantity | The API identifier used in GraphQL. |
| Number | 5375 |
Credit flow
Net credit flow , in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Flow | Credit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditFlowDomestic | The API identifier used in GraphQL. |
| Number | 4656 |
Credit flow in currency
Net credit flow , in the actual currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Flow in currency | Credit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditFlowInCurrency | The API identifier used in GraphQL. |
| Number | 4658 |
Credit flow in currency 2
Net credit flow , in currency 2.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Flow in currency 2 | Credit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditFlowInCurrency2 | The API identifier used in GraphQL. |
| Number | 14958 |
Credit flow quantity
Net credit flow , in quantity.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Source column | Flow quantity | Credit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditFlowQuantity | The API identifier used in GraphQL. |
| Number | 4660 |
Credit OB
Net credit opening balance , in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | OB | Credit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditObDomestic | The API identifier used in GraphQL. |
| Number | 5354 |
Credit OB in currency
Net credit opening balance , in the actual currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | OB in currency | Credit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditObInCurrency | The API identifier used in GraphQL. |
| Number | 5362 |
Credit OB in currency 2
Net credit opening balance , in currency 2.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | OB in currency 2 | Credit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditObInCurrency2 | The API identifier used in GraphQL. |
| Number | 14954 |
Credit OB purchase
Net credit opening purchase balance (in the default currency).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | OB purchase | Credit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditObPurchase | The API identifier used in GraphQL. |
| Number | 5378 |
Credit OB quantity
Net credit opening balance , in quantity.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Source column | OB quantity | Credit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditObQuantity | The API identifier used in GraphQL. |
| Number | 5370 |
Credit purchase
Net credit purchase flow (in the default currency).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Purchase | Credit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditPurchase | The API identifier used in GraphQL. |
| Number | 5381 |
Debit CB
Net debit closing balance , in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | CB | Debit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitCbDomestic | The API identifier used in GraphQL. |
| Number | 5358 |
Debit CB in currency
Net debit closing balance , in the actual currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | CB in currency | Debit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitCbInCurrency | The API identifier used in GraphQL. |
| Number | 5366 |
Debit CB in currency 2
Net debit closing balance , in currency 2.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | CB in currency 2 | Debit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitCbInCurrency2 | The API identifier used in GraphQL. |
| Number | 14962 |
Debit CB purchase
Net debit closing purchase balance (in the default currency).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | CB purchase | Debit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitCbPurchase | The API identifier used in GraphQL. |
| Number | 5384 |
Debit CB quantity
Net debit closing balance , in quantity.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Source column | CB quantity | Debit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitCbQuantity | The API identifier used in GraphQL. |
| Number | 5374 |
Debit flow
Net debit flow , in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Flow | Debit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitFlowDomestic | The API identifier used in GraphQL. |
| Number | 4655 |
Debit flow in currency
Net debit flow , in the actual currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Flow in currency | Debit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitFlowInCurrency | The API identifier used in GraphQL. |
| Number | 4657 |
Debit flow in currency 2
Net debit flow , in currency 2.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Flow in currency 2 | Debit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitFlowInCurrency2 | The API identifier used in GraphQL. |
| Number | 14957 |
Debit flow quantity
Net debit flow , in quantity.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Source column | Flow quantity | Debit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitFlowQuantity | The API identifier used in GraphQL. |
| Number | 4659 |
Debit OB
Net debit opening balance , in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | OB | Debit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitObDomestic | The API identifier used in GraphQL. |
| Number | 5353 |
Debit OB in currency
Net debit opening balance , in the actual currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | OB in currency | Debit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitObInCurrency | The API identifier used in GraphQL. |
| Number | 5361 |
Debit OB in currency 2
Net debit opening balance , in currency 2.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | OB in currency 2 | Debit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitObInCurrency2 | The API identifier used in GraphQL. |
| Number | 14953 |
Debit OB purchase
Net debit opening purchase balance (in the default currency).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | OB purchase | Debit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitObPurchase | The API identifier used in GraphQL. |
| Number | 5377 |
Debit OB quantity
Net debit opening balance , in quantity.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Source column | OB quantity | Debit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitObQuantity | The API identifier used in GraphQL. |
| Number | 5369 |
Debit purchase
Net debit purchase flow (in the default currency).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Purchase | Debit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitPurchase | The API identifier used in GraphQL. |
| Number | 5380 |
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. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | flowDomestic | The API identifier used in GraphQL. |
| Number | 1437 |
Flow in currency
Net flow , in the actual 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. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | flowInCurrency | The API identifier used in GraphQL. |
| Number | 1441 |
Flow in currency 2
Net flow , in currency 2.
| 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. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | flowInCurrency2 | The API identifier used in GraphQL. |
| Number | 14956 |
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. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | flowQuantity | The API identifier used in GraphQL. |
| Number | 2241 |
Not due
Amount not due (in the default currency), on Balance list for suppliers reports with age distribution.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | notDue | The API identifier used in GraphQL. |
| Number | 2264 |
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. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | obDomestic | The API identifier used in GraphQL. |
| Number | 1436 |
OB in currency
Net opening balance , in the actual 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. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | obInCurrency | The API identifier used in GraphQL. |
| Number | 1440 |
OB in currency 2
Net opening balance , in currency 2.
| 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. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | obInCurrency2 | The API identifier used in GraphQL. |
| Number | 14952 |
OB purchase
Net opening purchase 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. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | obPurchase | The API identifier used in GraphQL. |
| Number | 1443 |
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. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | obQuantity | The API identifier used in GraphQL. |
| Number | 2240 |
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 | Sup. 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 | 1432 |
Purchase
Net purchase 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. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | purchase | The API identifier used in GraphQL. |
| Number | 1444 |
Sum credit CB
Sum credit closing balance , in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | sumCreditCbDomestic | The API identifier used in GraphQL. |
| Number | 5357 |
Sum credit CB in currency
Sum credit closing balance , in the actual currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | sumCreditCbInCurrency | The API identifier used in GraphQL. |
| Number | 5365 |
Sum credit CB in currency 2
Sum credit closing balance , in currency 2.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | sumCreditCbInCurrency2 | The API identifier used in GraphQL. |
| Number | 14960 |
Sum credit CB purchase
Sum credit closing purchase balance (in the default currency).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | sumCreditCbPurchase | The API identifier used in GraphQL. |
| Number | 5383 |
Sum credit CB quantity
Sum credit closing balance , in quantity.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | sumCreditCbQuantity | The API identifier used in GraphQL. |
| Number | 5373 |
Sum credit flow
Sum credit flow , in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | CrCh | The database field name. |
| API identifier | sumCreditFlowDomestic | The API identifier used in GraphQL. |
| Number | 5387 |
Sum credit flow in currency
Sum credit flow, in the actual currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | CrCurCh | The database field name. |
| API identifier | sumCreditFlowInCurrency | The API identifier used in GraphQL. |
| Number | 5389 |
Sum credit flow in currency 2
Sum credit flow, in currency 2.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | CrCur2Ch | The database field name. |
| API identifier | sumCreditFlowInCurrency2 | The API identifier used in GraphQL. |
| Number | 14965 |
Sum credit flow quantity
Sum credit flow, in quantity.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | CrQtyCh | The database field name. |
| API identifier | sumCreditFlowQuantity | The API identifier used in GraphQL. |
| Number | 5391 |
Sum credit OB
Sum credit opening balance , in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | CrIB | The database field name. |
| API identifier | sumCreditObDomestic | The API identifier used in GraphQL. |
| Number | 5386 |
Sum credit OB in currency
Sum credit opening balance , in the actual currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | CrCurIB | The database field name. |
| API identifier | sumCreditObInCurrency | The API identifier used in GraphQL. |
| Number | 5388 |
Sum credit OB in currency 2
Sum credit opening balance , in currency 2.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | CrCur2IB | The database field name. |
| API identifier | sumCreditObInCurrency2 | The API identifier used in GraphQL. |
| Number | 14964 |
Sum credit OB purchase
Sum credit opening purchase balance (in the default currency).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | CrPurcIB | The database field name. |
| API identifier | sumCreditObPurchase | The API identifier used in GraphQL. |
| Number | 5392 |
Sum credit OB quantity
Sum credit opening balance , in quantity.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | CrQtyIB | The database field name. |
| API identifier | sumCreditObQuantity | The API identifier used in GraphQL. |
| Number | 5390 |
Sum credit purchase
Sum credit purchase flow (in the default currency).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | CrPurcCh | The database field name. |
| API identifier | sumCreditPurchase | The API identifier used in GraphQL. |
| Number | 5393 |
Sum debit CB
Sum debit closing balance , in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | sumDebitCbDomestic | The API identifier used in GraphQL. |
| Number | 5356 |
Sum debit CB in currency
Sum debit closing balance , in the actual currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | sumDebitCbInCurrency | The API identifier used in GraphQL. |
| Number | 5364 |
Sum debit CB in currency 2
Sum debit closing balance , in currency 2.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | sumDebitCbInCurrency2 | The API identifier used in GraphQL. |
| Number | 14959 |
Sum debit CB purchase
Sum debit closing purchase balance (in the default currency).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | sumDebitCbPurchase | The API identifier used in GraphQL. |
| Number | 5382 |
Sum debit CB quantity
Sum debit closing balance , in quantity.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | sumDebitCbQuantity | The API identifier used in GraphQL. |
| Number | 5372 |
Sum debit flow
Sum debit flow , in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | DbCh | The database field name. |
| API identifier | sumDebitFlowDomestic | The API identifier used in GraphQL. |
| Number | 5355 |
Sum debit flow in currency
Sum debit flow , in the actual currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | DbCurCh | The database field name. |
| API identifier | sumDebitFlowInCurrency | The API identifier used in GraphQL. |
| Number | 5363 |
Sum debit flow in currency 2
Sum debit flow , in currency 2.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | DbCur2Ch | The database field name. |
| API identifier | sumDebitFlowInCurrency2 | The API identifier used in GraphQL. |
| Number | 14955 |
Sum debit flow quantity
Sum debit flow , in quantity.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | DbQtyCh | The database field name. |
| API identifier | sumDebitFlowQuantity | The API identifier used in GraphQL. |
| Number | 5371 |
Sum debit OB
Sum debit opening balance , in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | DbIB | The database field name. |
| API identifier | sumDebitObDomestic | The API identifier used in GraphQL. |
| Number | 5352 |
Sum debit OB in currency
Sum debit opening balance , in the actual currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | DbCurIB | The database field name. |
| API identifier | sumDebitObInCurrency | The API identifier used in GraphQL. |
| Number | 5360 |
Sum debit OB in currency 2
Sum debit opening balance , in currency 2.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | DbCur2IB | The database field name. |
| API identifier | sumDebitObInCurrency2 | The API identifier used in GraphQL. |
| Number | 14951 |
Sum debit OB purchase
Sum debit opening purchase balance (in the default currency).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | DbPurcIB | The database field name. |
| API identifier | sumDebitObPurchase | The API identifier used in GraphQL. |
| Number | 5376 |
Sum debit OB quantity
Sum debit opening balance , in quantity.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | DbQtyIB | The database field name. |
| API identifier | sumDebitObQuantity | The API identifier used in GraphQL. |
| Number | 5368 |
Sum debit purchase
Sum debit purchase flow (in the default currency).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | DbPurcCh | The database field name. |
| API identifier | sumDebitPurchase | The API identifier used in GraphQL. |
| Number | 5379 |
Sup. no.
The supplier 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 | Sup. no. | Integer |
| Primary key | Yes | Sup. no., Year, Period |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SupNo | The database field name. |
| API identifier | supplierNo | The API identifier used in GraphQL. |
| Number | 1433 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Supplier |
|
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 | Sup. 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 | 1431 |
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
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChPvn | The database field name. |
| API identifier | changedByProvenance | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed by user
The name of the user that changed the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | User name | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChUsr | The database field name. |
| API identifier | changedByUser | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed date
The date when the record was changed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChDt | The database field name. |
| API identifier | changedDate | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed time
The time when the record was changed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChTm | The database field name. |
| API identifier | changedTime | The API identifier used in GraphQL. |
| Number | A 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date/time | DateTime |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChTs | The database field name. |
| API identifier | changedTimestamp | The API identifier used in GraphQL. |
| Number | A 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
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CrePvn | The database field name. |
| API identifier | createdByProvenance | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created by user
The name of the user that created the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | User name | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreUsr | The database field name. |
| API identifier | createdByUser | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created date
The date when the record was created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreDt | The database field name. |
| API identifier | createdDate | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created time
The time when the record was created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreTm | The database field name. |
| API identifier | createdTime | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created time stamp
The date and time when the record was created.
The field is updated with the UTC time.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date/time | DateTime |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreTs | The database field name. |
| API identifier | createdTimestamp | The API identifier used in GraphQL. |
| Number | A 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Edit status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | LckSt | The database field name. |
| API identifier | editStatus | The API identifier used in GraphQL. |
| Number | A 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Process no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChPrc | The database field name. |
| API identifier | lockedByProcessNo | The API identifier used in GraphQL. |
| Number | A unique column number. |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Active company process | CompanyProcess | Process no. | Process no. |