Supplier current balance
This table is defined as a view in the database, and contains a summary for each supplier with open entries in the Open supplier entry table.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is a view in the company databases. |
| View name | SupCurBal | This table is a view and only displayed in the program, it is not stored in the database. |
| API identifier | supplierCurrentBalance | The API identifier used in GraphQL. |
| Table no. | 453 | The table number in the data model. |
The following fields exist in this table:
Last voucher date
The most recent Voucher date in Open supplier entry table for the supplier 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 | 19551 |
Number of open entries
The number of open entries in Open supplier entry table for the supplier 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 | 19552 |
Oldest due date
The oldest Due date in Open supplier entry table for the supplier 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 | 19553 |
Outstanding amount
The sum of Outstanding amount in Open supplier entry for the supplier 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 | 19550 |
Sup. no.
The supplier 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 | Sup. no. | Integer |
| Primary key | Yes | Sup. no. |
| 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 | 19549 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Supplier |
|