Customer current balance
This table is defined as a view in the database, and contains a summary for each customer with open entries in the Open customer entry table.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is a view in the company databases. |
| View name | CustCurBal | This table is a view and only displayed in the program, it is not stored in the database. |
| API identifier | customerCurrentBalance | The API identifier used in GraphQL. |
| Table no. | 452 | The table number in the data model. |
The following fields exist in this table:
Cust. no.
The customer whom the values on the row belong to.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Cust. no. | Integer |
| Primary key | Yes | Cust. no. |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CustNo | The database field name. |
| API identifier | customerNo | The API identifier used in GraphQL. |
| Number | 19544 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Customer |
|
Last voucher date
The most recent Voucher date in Open customer entry table for the customer where Outstanding amount is not 0 (zero).
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | LtVoDt | The database field name. |
| API identifier | lastVoucherDate | The API identifier used in GraphQL. |
| Number | 19546 |
Number of open entries
The number of open entries in Open customer entry table for the customer where Outstanding amount is not 0 (zero).
| 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 | NoOpenEnt | The database field name. |
| API identifier | numberOfOpenEntries | The API identifier used in GraphQL. |
| Number | 19547 |
Oldest due date
The oldest Due date in Open customer entry table for the customer where Outstanding amount is not 0 (zero).
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | OldDueDt | The database field name. |
| API identifier | oldestDueDate | The API identifier used in GraphQL. |
| Number | 19548 |
Outstanding amount
The sum of Outstanding amount in Open customer entry for the customer 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 | OutAm | The database field name. |
| API identifier | outstandingAmount | The API identifier used in GraphQL. |
| Number | 19545 |