MatchInvoiceLine query

Contents:

Filters

Filter

Description

Mandatory

Filter

Description

Mandatory

Fbo location

Filters on FBO location. Single or multiple locations can be selected.

YES

Start date (LT) / End date (LT)

Start date and End date for the following criteria:

  • Filters FBO One orderlines that are not yet matched to any 3rd party service suppliers by flight leg arrival/departure date

  • Filters uploaded 3rd party services by service date.

  • Filters FBO One orderlines that were matched manually to order that has the flight legs outside of this  from-before date interval, in this case filtering is done by 3rd party uploaded service date

YES

Match type

Filters on match type defined in 'Admin Match Invoices (Administration)'. Single or multiple types can be selected.

YES

Data provider settings

There are no data provider settings for this query.

Columns

Column

Description

Example

Column

Description

Example

Aircraft registration code

Registration code on match invoice line or order (no dash)

T7GTS

Airport slot name

Arrival or departure airport slot.

T7-1234

Arrival or departure

Arrival or departure indicator for service ‘A' or 'D’

A

Cost center number

Cost center for orderline.

OPS

Debtor name

Debtor name on order.

Empire Aviation Group

Handling station IATA code

FBO location IATA code.

LTN

Ledger number

Ledger number for orderline.

2137

MatchInv charge group

Match type for this match invoice line.

Services

MatchInv charge name

Match invoice line service name - defined by custom value.

TRANSPORT

MatchInv created UTC

Date and time match invoice was created/uploaded.

09-Sep-20

MatchInv excel file

Name of uploaded match invoice template file.

Download Template 52168.xlsx

MatchInv excel rows

Row number for match invoice line.

10

MatchInv number

Match invoice, invoice number.

52167

MatchInv status

Match invoice current status.

Complete

MatchInvLine accrual

Currently the ‘MatchInvLine variance’ to be updated. 

0

MatchInvLine remark

Match invoice line ‘Match comment’.

Supplementary invoice raised

MatchInvLine service DateTime LT

Match invoice line ‘Service DateTime (Lt)' in local time.

06-Sep-20 08:00

MatchInvLine service DateTime UTC

Match invoice line ‘Service DateTime (Lt)' in UTC.

06-Sep-20 07:00

MatchInvLine status

Match invoice line matching status.

Matched

MatchInvLine type

Match invoice line type of match.

Manual

MatchInvLine unmatch reason

Match invoice line ‘Unmatched reason’

REGISTRATION DOES NOT EXIST

MatchInvLine value

Match invoice line ‘Amount’.

210

MatchInvLine variance

Match invoice line variance (difference between ‘Amount’ and ‘Total service value’).

0

Most actual arrival DateTime LT

The most actual arrival time for an order in local time.

03-Sep-20 14:28

Most actual arrival DateTime UTC

The most actual arrival time for an order in UTC.

03-Sep-20 13:28

Most actual departure DateTime LT

The most actual departure time for an order in local time.

06-Sep-20 10:58

Most actual departure DateTime UTC

The most actual departure time for an order in UTC.

06-Sep-20 09:58

Operator name

Operator name on order.

EMPIRE AVIATION SAN MARINO SRL

Order key

Order key.

AMS-4237

OrderlineId

The OrderlineID GUID code for lookups with other queries.

c7e6c892-3986-4e7f-9ce0-4b5c244bc7b7

Product code

The FBO One product code.

CREW TRANSPORT

Supplier name

The supplier name for match invoice line.

First Class Cars

Total service value

The FBO One service value.

210