Product data summary query

The Product data summary query is used to export all product data, showing a line per product, per FBO location.

Contents:

Filters

Filter

Description

Mandatory

Filter

Description

Mandatory

Fbo location

Filters on FBO location where the product is available. Single or multiple FBO locations can be selected. If not set, all locations are shown.

NO

Data provider settings

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

Setting

Type

Default

Description

Setting

Type

Default

Description

SortByProductCode

Boolean

False

Sort by product code A-Z. If false, the sort is by the sort index (lower number first).

Columns

Name

Description

Example

Allow supplier selection

Indicates if the supplier drop down is shown for the product. See 'Show supplier pick-list’ field in product.

FALSE

Auto add workflows

The order workflows the product is set to auto-add to, where the product is used in ‘Product to add’ field in an auto-add. See ‘Applies to Order workflow' field in Auto-add products (Administration).

Note: If product is ‘Product to add’ for multiple order workflows, each will be separated by a comma.

ArrivalOnlyOrder, DepartureOnlyOrder, HandlingOrder, Scheduled Flight

Available in Add Services screen

Indicates if the product can be added in bulk in the ‘Add multiple services’ screen. See 'Available in 'Add Services' screen’ field in product.

FALSE

Calculation Priority

Calculation priority of the product. See 'Calculation Priority’ field in product.

5

Can arrival/departure indicator be changed

Indicates if the product’s arrival/departure indicator can be changed. See 'Can arrival/departure indicator be changed’ field in product.

FALSE

Can be added more than once

Indicates if the product can be added more than once. See 'Can be added more than once’ field in product.

TRUE

Can be manually added

Indicates if the product can be manually added. See 'Can be manually added’ field in product.

FALSE

Can override VAT code

Indicates if the product’s VAT code can be overridden. See 'Can override VAT code’ field in product.

FALSE

Caption for supplier's order number

Supplier order number caption for the product (if blank, then ‘Supplier’s order number’ is shown). See 'Caption for supplier's order number’ field in product.

Airport Invoice

Collapse group

The collapse behavior for the product. See 'Group product collapse type' field in product. Possible values are:

  • Expanded

  • Collapsed on Customer Invoice and Reports

  • Collapsed on Customer Invoice Only

Expanded

Column for amount

Not in use. Will show ‘Amount’ always.

Amount

Contains mutually exclusive price components

Indicates if the product contains mutually exclusive price components. See 'Contains mutually exclusive fuel-price schemes' field in product

FALSE

Cost center

The cost center number for the product. See 'Cost center’ field in product.

FBO

Cost center description

The cost center description. See 'Cost center’ field in product.

40400 Direct Costs DUS

Custom property for unit price formula

The custom property assigned to the product for unit price calculation. See 'Custom Property for unit price formula' field in product.

PricingValue

Decimals in quantity

The decimals in the quantity of the product. See 'Decimals in quantity’ field in product.

0

Default arrival/departure indicator

Indicates if the default movement indicator is ‘Arrival’ See 'Default arrival/departure indicator’ field in product.

TRUE

Description

The product description. See 'Description (on invoice)’ field in product.

Mandatory Infrastructure Discount

EC Reversed Vat Category

The product’s EC reversed VAT category. See 'VAT category for EC reversed purposes' field in product.

  • NotReversed

  • Services

  • Goods

NotReversed

Export codes

Custom values applied to the product. Each custom value is separated by a comma.

Product Code with VAT: 4411, Product Code without VAT: 4111, Service Revenue Groups(ALL FBO's): Third Party Revenue

Export values

Custom values applied to the product. Each custom value is separated by a comma.

Duplicates ‘Export codes’

Product Code with VAT: 4411, Product Code without VAT: 4111, Service Revenue Groups(ALL FBO's): Third Party Revenue

FBO location short name

FBO location short name the product is available to. See ‘FBO location’ field in 'All locations’ tab of the product.

If a product is available to multiple locations, multiple rows will show in the report per location.

DUS

Has price reference date for child services

Indicates has a price reference date for child services. See 'Has price reference date for child services' field in product.

FALSE

Hide from planboard until

Length of time before departure the product is hidden from the planboard. See 'Hide from planboard until’ field in product.

30

Hide invoice to follow

Indicates if the product’s invoice to follow is disabled. See ‘Hide 'invoice to follow’ field in product.

FALSE

Identifies Applicable Price Scheme

Indicates if the product identifies the applicable fuel price scheme. See 'Identifies the applicable fuel price scheme' field in product.

FALSE

Is active

Indicates if the product is active. See 'Is active’ field in product.

TRUE

Is airside product

Indicates if the product is an airside product. See ‘Is airside product’ or 'Is Aircraft Handling Service’ (if UK VAT 2) field in product.

TRUE

Is arrival/departure indicator applicable

Indicates if the movement indicator is applicable for the header product. See 'Is arrival/departure indicator applicable for group-header product’ field in product.

FALSE

Is cost allow enter sales price in parent product

Indicates if the product is a cost product allowing the sales price entered in the parent product for markup. See 'Is Cost, Allow enter sales price in Parent Product' field in product. Possible values:

  • No

  • Adhoc Markup

  • Yes - Fixed Markup

No

Is delivery date applicable

Indicates if the delivery date is applicable. See 'Is delivery date applicable’ field in product.

FALSE

Is EC reversed VAT applicable

Indicates if the product is EC reversed VAT applicable. From 'VAT category for EC reversed purposes’ field possible values:

  • NotReversed = FALSE

  • Services = TRUE

  • Goods = TRUE

FALSE

Is group

Indicates if the product is a group. See 'Is group’ field in product.

FALSE

Is group with quantity and supplier

Indicates if the product is a group with quantity and supplier. See 'Is group with quantity and supplier’ field in product.

FALSE

Is supplier invoice required

Indicates if the supplier invoice is required. See 'Is supplier's invoice required’ field in product. See Supplier invoices (Back office) page.

FALSE

Is supply order HTML format

Indicates if the supply order email will send in HTML format or in plain text. See 'Is Supply Order Email in HTML Format’ field in product.

TRUE

Is Visible In Comms One Handling Confirmation

Indicates if the product is visible in Comms One. See 'Show on confirmation in Comms One’ field in product.

FALSE

Ledger compress

Indicates if the ledger set on the product is compressed. See ‘Ledger’ field in product, and 'Compress’ field in Ledgers (Administration) page.

FALSE

Ledger description

Ledger description for the product. See 'Ledger’ field in product, and 'Description’ field in Ledgers (Administration) page.

Handling fees

Ledger number

Ledger number for the product. See 'Ledger’ field in product, and 'Ledger number’ field in Ledgers (Administration) page.

200

Ledger type

Ledger type for the product. See 'Ledger’ field in product, and 'Ledger type’ field in Ledgers (Administration) page.

P

Most specific description

The product’s specific description for the FBO location. If not defined, the standard product description is shown. See 'Specific description for this FBO location’ field in product.

Mandatory Infrastructure Discount

Number of decimals

Product’s number of decimals for unit price. See 'Decimals in unit price’ field in product.

2

OpsCategory

Ops category defined in the product (product icon) See 'OPS Category’ field in product.

Handling

OpsCategoryIcon

The Ops category icon name. See 'Icon’ field in OPS Product Category Icons page.

mdi mdi-account

Parking position price category

The parking price category for the product. See 'Parking position price category’ field in product.

Airport Parking

Price calculator

The price calculator set for the product. See 'Price calculator’ field in product.

PPPBusLib.ParkingPer24HoursCalculator

Price calculator settings

Price calculator settings of the product. See 'Price calculator settings’ field in product.

ChargingInterval=0.00:10;MultiplyByTons=false;timeBandFrom =0.00:00;timeBandBelow=0.03:00;

Price calculator unit price formula

The price calculator unit price formula. See 'Unit price calculation formula' field in product. See How to setup a unit price based on a C# formula.

((Func<decimal?>)(() => {
decimal? result = null;

if (input.UnitPrice.HasValue && input.MtowInKg.HasValue)
{
int mtowTons = Convert.ToInt32(Math.Ceiling((input.MtowInKg.Value / 1000M)));
var roundedPower = Math.Round((decimal)Math.Pow((double)mtowTons / 50, 0.7), 4, MidpointRounding.AwayFromZero);
result = input.UnitPrice * roundedPower;
}

return (decimal?)result;
}))();

Price is mandatory

Indicates if the price is mandatory for the product. See 'Is price mandatory’ field in product.

FALSE

Product code

Product code for the product. See 'Product code’ field in product.

MIC DISCOUNT (DUS)

Product ID

Product’s unique ID in GUID format.

85c707d1-fae5-4105-9da8-f193ac08c1b6

Product URL

The URL for the product.

Add ‘https://***.fbo.one/fbo1#/classic/’ in front for a direct link. *** = FBO One instance.

~/Product.aspx?Productid=85c707d1-fae5-4105-9da8-f193ac08c1b6

QRCode

Allows generating a QR code using data from other columns, see How to add a QR code to a report.

 

Remarks

Free-text remarks for the product. See 'Remarks’ field in product.

Discount product for DUS

Send supply order email

Indicates if supply order email’s are sent from product. See 'Send supply order by email’ field in product.

FALSE

Service delivery date time display

Indicates which date/time format should be displayed for the order screen for service delivery dates. See 'Service delivery date/time display' in product and How to specify Delivery Date/Time format on-screen for more information. 

ShowUtc

Show arrival/departure indicator

Indicates if the movement indicator is shown in order. See 'Show arrival/departure indicator on order screen’ field in product.

FALSE

Show bulletin board attachments in transitions

Indicates if bulletin board message attachments can be attached to 3rd party services. See 'Show bulletin board attachments in transitions' field in product, and https://amsterdam.jira.com/wiki/spaces/MAN/pages/2124742849 for more information.

FALSE

Show in order screen if price is 0

Indicates if the product is shown in order if price is 0. See 'Show on the order screen if price is 0’ field in product.

FALSE

Show in ramp screen

Indicates if the product is shown in Classic Ramp screen. See 'Show in ramp order screen’ field in product.

FALSE

Show in touch add services quick list

Indicates if the product is shown in Classic Ramp add services quick list. See 'Show in ramp/line services add services short list’ field in product.

FALSE

Show on handling order if price is 0

Indicates if the product is shown on receipt/invoice if the price is 0. See 'Show on receipt and invoice if price is 0’ field in product.

FALSE

Show on handling request/confirmation

Indicates if the product is shown on order reports, e.g. Handling confirmation / Handling request. See 'Show on the customer handling confirmation and the in-house handling request report’ field in product.

FALSE

Show service date on handling order

Indicates if the service date of the product is shown on the receipt/invoice. See 'Show service delivery date on receipt’ field in product.

FALSE

Show sub-total

Indicates if the product sub-total is shown. Applicable to group products. See 'Show group sub-total on receipt’ field in product.

TRUE

Show supplier name on reports

Indicates if the product supplier name is shown on the receipt/invoice. See 'Show supplier name on receipt/invoice’ field in product.

FALSE

Show unit and quantity on invoice

Indicates if the unit price and quantity is shown on the invoice. See 'Show unit price and quantity on invoice’ field in product.

TRUE

SKU Duty tax name

SKU duty tax name for the product. See ‘SKU duty tax’ field in product, and 'Name’ field in SKU excise taxes (Administration) page.

Duty tax

SKU name

SKU name for the product. See ‘Stock keeping unit’ field in product, and 'Name’ field in SKUs (Stock keeping units) (Administration) page.

JET A1

Sort index

The sort index for the product. See 'Sort index’ field in product.

0

Specific description

The product’s specific description. See 'Specific description for this FBO location’ field in product.

Mandatory Infrastructure Discount

Subadmin code

The sub administration code used for suppliers. See ‘Sub administration’ field in 'Suppliers’ tab in the product, and 'SubAdminCode’ field in Sub administrations (Administration).

Note: If multiple sub admins are added, each will be separated by a comma.

80128, 80001

Subadmin description

The sub administration description used for suppliers. See ‘Sub administration’ field in ‘Suppliers’ tab in the product, and 'Description’ field in Sub administrations (Administration).

Note: If multiple sub admins are added, each will be separated by a comma.

RES AeroChefs | EHRD, RES Doelen Limousine | EHAM

Supplier ID

Supplier contact’s unique ID in GUID format.

Note: If multiple suppliers are added, each will be separated by a comma

ddfdcc99-9022-4f17-b6fa-cb299abb3cf6, 1bcfa492-ad34-4801-beb2-e8e5ab1703dc

Supplier name

List of product’s suppliers by name. See 'Supplier contact' field in 'Suppliers’ tab in the product.

Note: If multiple suppliers are added, each will be separated by a comma

AeroChefs Rotterdam, ACompany Special Services Schiphol

Supplier order number mandatory

Indicates if the supplier order number is mandatory. See 'Is supplier's order number mandatory’ field in product.

FALSE

Supplier product code

List of product’s suppliers product code for reporting. See 'Supplier product code' field in 'Suppliers’ tab in the product.

Note: If multiple suppliers are added, each will be separated by a comma.

AB, AC

Supplier shortest name

List of product’s suppliers shortest name. See 'Short name' field in supplier contact.

Note: If multiple suppliers are added, each will be separated by a comma.

Aerochefs RTM, ACompany

Supply order subject template text

The product’s default supply order subject template. See ‘Edit Supply order template’ link in product details screen and the 'Supply order subject template’ field.

New supply order ~ProductCode~ for ~OperatorName~

Supply order template text

The product’s default supply order template. See 'Edit Supply order template’ link in product details screen and the 'Supply order template’ field.

ATTN: ~SupplierContactName~

Dear Duty Manager,

Please find below a ~ProductCode~ request for the following flight internally referenced as ~OrderKey~

Operator:~OperatorName~ based in ~OperatorCity~, ~OperatorCountry~

Billed to: ~DebtorName~ based in ~DebtorCity~, ~DebtorCountry~

Registration: ~RegistrationCode~ Type: ~AircraftTypeIcaoCode~ MtowKg: ~MtowKg~

Please confirm reception and subsequent approval to ~Reports-Email~.

Best regards,

~EmployeeFirstName~
FBO Customer Service

Take quantity from group

Indicates if the product takes quantity from group header product. From 'Take quantity from group’ field possible values:

  • None (quantity from self) = FALSE

  • Quantity from group = TRUE

  • Absolute quantity from group = TRUE

  • Progress time from group = TRUE

FALSE

Take supplier and sku from group

Indicates if the product takes supplier and SKU from group header. See 'Take supplier and stock keeping unit from group’ field in product.

FALSE

Unit code

Unit code for the product. See 'Unit code’ field in product.

item

Unit duration in seconds

Unit’s duration in seconds for the product. See 'DurationInSeconds’ field in the Units (Administration) page.

3600

Use delivery date as price reference date

Indicates if the delivery date is used a price reference for the product. See 'Use delivery date or service date as price reference date’ field in product.

FALSE

Use VAT code from parent

Indicates if the VAT code is taken from the parent product. See 'Use VAT code from parent product’ field in product.

FALSE

VAT code

VAT Code for the product. See 'VAT code’ field in product.

A4 Normal VAT

VAT Percentage

VAT percentage for the product. See 'Percentage’ field in VAT codes (Administration) page.

16

Warn if pending on cancelling order

Indicates if a warning shows on cancelling order if product is not complete. See 'Warn if pending on cancelling order’ field in product.

FALSE

Workflow

Workflow name for the product. See 'Workflow start transitions’ field in product, and 'Name’ field in Service workflows (Administration) page.

Notam Task (NED)

Workflow description

Workflow description for the product. See ‘Workflow start transitions’ field in product, and 'Description’ field in Service workflows (Administration) page.

Secondary workflow | Print Notams