AgedReceivablesByContact

Columns

Name

Type

Description

ID [KEY]

String

The row number, combined with the contact ID.

ContactId

String

The ID of the contact this is reporting on.

Date

Datetime

The Date the invoice is created.

Reference

String

Sale order reference for this bill.

DueDate

Datetime

Date the amount is due.

Overdue

Decimal

Amount due passed due date.

Currency

String

The currency used for all fields but DueLocal. Is empty if multi-currency is not in use.

Total

Decimal

Total amount due.

Paid

Decimal

Amount paid.

Credited

Decimal

Amount credited.

Due

Decimal

Amount due.

DueLocal

Decimal

Amount due in the default organisation currency.

TenantId

String

The ID of the tenant to query instead of the connection tenant

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name

Type

Description

fromDate

Datetime

Show all payable invoices from this date for contact.

toDate

Datetime

Show all payable invoices to this date for the contact.

Last updated