Deal Report

The report structure depends on whether the deal contains voyage data.

For deals with voyage information, the report displays voyage-related fields such as Vessel, Voyage, and Comment.

For deals without voyages (e.g., deals of type Goods S&P, Forwarding, or Payment Agency Agreement), the report includes additional columns such as Fact Quantity, End Date, Cargo, Destination Country, and Subtype. In this layout, the Comment column is not displayed.

If the selected dataset contains both types of deals, the system generates two separate reports: one for deals with voyages and another for deals without voyages.

The report includes fields from multiple system objects.
The list below represents the full set of columns used across both Deal Report and Deal Report for Period.

Deal Fields

Columns describing the deal itself:

• Id Deal

• Deal Number

• Type

• Destination Country

• Cargo

• End Date

• Estimated Quantity (Cargo)

Estimate Fields

Columns related to estimates linked to the deal:

• Comment

• Estimated in Basis

• Estimated

• Estimate Currency

Invoice Fields

Columns describing invoices generated from estimates:

• Id Invoice

• Vessel

• Voyage

• Subtype

• Invoice Number

• Invoice Date

• Client

• Payer

• Issued By

• Fact Quantity

• Fact in Basis

• Fact

• Fact Currency

• Status

• Pay Status

Payment Fields

Columns containing payment data linked to invoices:

• Id Payment

• Payment Purpose

• Payment Date

• Payment Currency

• Payment Amount

• Payment Amount in Basis

• Paid Amount

• Credited for Invoice

• Payment ROE Basis

• Inverse ROE Basis

• Paid in Basis ($Paid Amount × Payment ROE Basis$ )

• Account Holder

• Bank

Reconciliation Field

• Reconciliation Info: Additional information if the payment is part of a reconciliation operation.