The Invoice Line data provider/query returns the order-related data relevant to an invoice. For receipt-related information please use the receipt data providers.
The data provider can be used for building an invoice or even a single-page invoice RDL-based template.
Filters
|
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 the 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 |
|---|---|---|---|
|
ShowStringInBarcode |
Boolean |
TRUE |
Shows the barcode number as text below the barcode. 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. |
|
BarcodeWidth |
Integer |
200 |
The width in pixels of the barcode image. |
|
BarcodeHeight |
Integer |
60 |
The height in pixels of the barcode image. |
|
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. |
|
BarcodeFontSize |
Integer |
9 |
The font size is used to display the number text below the barcode. Note: ‘ShowStringInBarcode’ needs to be set to TRUE for this setting to have any effect. |
Columns
|
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 |
|
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. |
|
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 |
|
- MAKE ALL CHEQUES PAYABLE TO: MONEY TRANSFERS TO:
|
|
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. |
|
|
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:
|
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:
|
4613 Phasellus Rd. |
|
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
Comments
0 comments
Please sign in to leave a comment.