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