Collaterals Search

Top  Previous  Next

Information on the Collaterals tab screen may be filtered using different search criteria.  Three search fields are date related.  The first is a date range type selector.  You may select to search on the start date range, end date range or a specific period.  Dates may be entered in the From and Until fields to define a date range.

 

collateral_search_tab

 

There is also a general search box where different search phases may be entered.  Note that the default search type is “contains” unless specified below.  The collaterals list can be filtered both using the search box and dates.  For example, a search may be done on financing agreement (=name of the credit line) and on showing only active collaterals (end date is empty).

 

The following are the search fields which may be used.

 

Field

Description

bl-no

The document number when type = Floating

city-or-port

The city or port where the delivery is or will be (destination of delivery, or city/port of the warehouse, or city/port of the buyer)

document

The document number, being either the BL (when floating), the warrant (when stored) or the invoice (when sold).

end-date

The end date. Empty dates can be found using date-end - and non-empty ones using date-end +.

financing-agreement

The name of the financing agreement.

financing-bank

The bank in the financing agreement.

financing-bank-account

The bank account in the financing agreement.

financing-reference

the reference number of the financing

financing-type

The type of financing = Credit Line or Self (Self-financed goods are not yet displayed in this release.)

invoice-amount

The amount of the invoice when type = Sale and the invoice exists.

invoice-no

The document number when type = Sale and the invoice exists.

invoice-status

The paid/not paid status of the invoice when type = Sale and the invoice exists.

location

The location of the goods which is either a delivery number and vessel name (when floating), or a warehouse name (when stored), or a buyer name (when sold).

quantity

The quantity (a number).

quantity-unit

The quantity unit.

start-date

The start date of the collateral.

type

The type of collateral = Floating or Inventory or Sale.

warrant-no

The document number when type = Inventory.