Invoice line query

The Invoice Line data provider/query returns the order related data relevant for a invoice. For receipt related information please use the receipt data providers.

The data provider can be used for building a invoice or even single page invoice RDL based template.

Filters

Filter

Description

Mandatory

Filter

Description

Mandatory

Administration

Filters on Administration. Single or multiple Administrations can be selected.

YES

Invoice

Filters on the Invoice ID. The Invoice ID can be found in the Classic screen when on Invoice page, in the browser address bar after ‘Invoiceid=’, e.g.

YES

Data provider settings

The following ‘Data provider settings’ can be set in Reports (Administration) for the query of a report. All settings must be separated by a semi-colon ';'. If not specified the default settings apply.

 

Setting

Type

Default

Description

Setting

Type

Default

Description

ShowStringInBarcode

Boolean

TRUE

Shows the barcode number as text below the barcode. See How to add a scannable barcode to the invoice. For example:

IncludeCheckSumDigitInBarcode

Boolean

TRUE

Includes a checksum to ensure that if the invoice number changes, the barcode shows that the invoice has been changed. See How to add a scannable barcode to the invoice.

BarcodeWidth

Integer

200

The width in pixels of the barcode image. See How to add a scannable barcode to the invoice.

BarcodeHeight

Integer

60

The height in pixels of the barcode image. See How to add a scannable barcode to the invoice.

BarcodeFont

String

Courier New

The font used to display the number text below the barcode. Note: ‘ShowStringInBarcode’ needs to be set to TRUE for this setting to have any effect. See How to add a scannable barcode to the invoice.

BarcodeFontSize

Integer

9

The font size used to display the number text below the barcode. Note: ‘ShowStringInBarcode’ needs to be set to TRUE for this setting to have any effect. See How to add a scannable barcode to the invoice.

Columns

Column

Description

Example

Column

Description

Example

AccountsReceivableAddressLine1

Accounts receivable address line 1’ defined in Administrations (Administration), see Administration (Fields).

Thermiekstraat 24

AccountsReceivableAddressLine2

Accounts receivable address line 2’ defined in Administrations (Administration), see Administration (Fields).

 Schiphol Airport

AccountsReceivableCity

Accounts receivable city’ defined in Administrations (Administration), see Administration (Fields).

Amsterdam

AccountsReceivableCountry

Accounts receivable country’ defined in Administrations (Administration), see Administration (Fields).

Netherlands

AccountsReceivableName

Accounts receivable name’ defined in Administrations (Administration), see Administration (Fields).

FBO One

AccountsReceivableVatNo

Accounts receivable vatno’ defined in Administrations (Administration), see Administration (Fields).

NL 1234 5678

AccountsReceivableZipCode

AccountsReceivableZipCode’ defined in Administrations (Administration), see Administration (Fields).

1117 BG

Charged currency code

 

EUR

Debtor address

 

Air Charlie 13
11 Boulthurst Way
HURST GREEN
RH8 0HT, Surrey
United Kingdom

Debtor address 1

 

11 Boulthurst Way

Debtor address 2

 

HURST GREEN

Debtor city

 

 

Debtor contact number

 

ROA001

Debtor country

 

United Kingdom

Debtor Invoice Reference Number

 

 

Debtor state

 

Surrey

Debtor VAT number

 

-

Debtor zip code

 

RH8 0HT

DebtorName

 

Air Charlie 13

Form of payment name on invoice

 

Direct Debit

Form of payment short name

 

DIRECT DEBIT EUR

Invoice date formatted

 

29-Oct-21

Invoice footer

 

VAT Registration No: GB 123 4567 89. FBO One is a subsidary of Regional Airport Ltd.
Registered Office: FBO One, Amsterdam

Invoice grand total decimal

 

0

Invoice grand total excl VAT decimal

 

0

Invoice grand total excl VAT formatted

 

0.00

Invoice grand total formatted

 

0.00

Invoice grand total in words

 

 

Invoice grand total in words caption

 

Invoice amount in words:

Invoice grand total VAT decimal

 

0

Invoice grand total VAT formatted

 

0.00

Invoice header

 

VAT Registration Number: GB 123 4567 89 | Business Registration Number: 12345678

Invoice ID

The Invoice unique ID in GUID format.

b9bfbc6c-269d-4dcb-877b-7f76f90eb138

Invoice number

The invoice number.

1014966

Invoice remarks

 

-
PLEASE DIRECT ALL ENQUIRIES TO:
Accounts Department
Accounts@fboone.com

MAKE ALL CHEQUES PAYABLE TO:
FBO One. Passenger Terminal, Main Road, Amsterdam, 1117 BC

MONEY TRANSFERS TO:
De Nederlandsche Bank
Account No: 11111111 | Sort Code 12-34-56
Swift: NL1234
IBAN Code: GB12 BARC 2345 6789 0123 45

 

Invoice title

Invoice title’ defined in Administrations (Administration), see Administration (Fields).

SUMMARY OF ORDER *TEST*

InvoiceAmountDueDecimal

 

0

InvoiceAmountDueFormatted

 

0.00

InvoiceCreatedDateTimeLt

 

12/10/2021 3:08:17 PM

InvoiceCreatedDateTimeUtc

 

12/10/2021 3:08:17 PM

InvoiceGrandTotalInBookedCurrencyDecimal

 

0

InvoiceGrandTotalInBookedCurrencyFormatted

 

0.00

InvoiceGrandTotalVATInBookedCurrencyDecimal

 

0

InvoiceGrandTotalVATInBookedCurrencyFormatted

 

0.00

InvoiceInternalRemarks

 

 

InvoiceNumberBarcode39

Invoice number barcode. See How to add a scannable barcode to the invoice for more information.

Is credit invoice

Indicates if the invoice is a credit invoice with the grand total as a negative charged amount.

FALSE

IsSinglePageInvoice

Indicates if the invoice is a single page invoice indicated by the following:

  • Invoice contains 1 Order only, and is not a batch invoice containing multiple Orders

  • Administration setting 'Generate single page invoices' is enabled.

TRUE

LogoImage

Shows the logo defined in FBO location. See 'Report logo' field in FBO locations (Administration).

OperatorAddressExclName

Debtor address formatted - excluding name (defined in Add Organization - add/edit screen) showing the following:

  • Address 1

  • Address 2

  • Zipcode City State

  • Country

4613 Phasellus Rd.
Socuéllamos
70332 Ciudad Real, Castilla - La Mancha
Spain

OperatorNameExclContactNumber

The invoices opeator’s ‘Organization name’ defined in Add Organization - add/edit screen.

Air Charlie 13

Order description

Shows the Order description - applicable for invoice cover pages.

Format:

OrderReceiptTitle RegistrationCode | HandlingStationICAOCode | Order transaction date | Operator Handling Number | Debtor Order number

If fuel only order:

OrderReceiptTitle RegistrationCode | HandlingStationICAOCode | Order transaction date | Operator Handling Number | Debtor Order number | Ticket: FuelTicketNumber | FuelTicketDebtorOrderNumber

RECEIPT NXNAB | EGKB | 16-Mar-20

Order grand total excl VAT formatted

 

0.00

Order grand total incl VAT formatted

 

0.00

Order grand total VAT formatted

 

0.00

Order ID

The Order unique ID in GUID format.

For invoices containing more than one order (batch invoices), multiple Order IDs will show on individual rows.

af710d11-6159-4b34-8caf-88b735ed31be

Order key

The Order key contained in the invoice.

For invoices containing more than one order (batch invoices), multiple Order IDs will show on individual rows.

FBO-60066

Payment due date

Invoice due date based upon the invoice date plus the payment (credit) term days for the debtor.

4/6/2020 12:00:00 AM

Payment due date formatted

Invoice due date based upon the invoice date plus the payment (credit) term days for the debtor. Outputted in text format using the 'ShortDateFormatString' application/FBO location setting.

30-Oct-21

Payment term days

Payment (credit) term in days for the invoice to be paid, defined by the debtor’s contract.

30

Payment term description

Payment (credit) term in days for the invoice to be paid, defined by the debtor’s contract, along with the due date formatted (using the ‘ShortDateFormatString' application/FBO location setting). Will show 'On delivery’ if debtor has 0 days of credit.

30 days (06-Apr-20)

QRCode

 

 

See also

Invoice VAT subtotal line query

Invoice alternative currency line query

Invoice RDL template

Receipt queries

Receipt RDL template