Contracts query

You can download customer contracts using the default ‘Contracts’ report.

Contents:

Filters

Filter

Description

Mandatory

Filter

Description

Mandatory

Administration

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

Contracts that apply to an Administration group will show if filtered Administrations are a member of the group. See How to set customer contracts to multiple Administrations using Administration groups.

YES

Data provider settings

There are no data provider settings for this query.

Columns

Name

Description

Example

Name

Description

Example

Administration group id

Administration group’s unique ID in GUID format.

Will be blank if contract is for a single Administration.

957bbe53-d320-4a80-93f9-bcb4a84ec84b

Administration group name

Administration group’s name the contract applies to. See ‘Product group’ field in contract.

Will be blank if contract is for a single Administration.

ALL

AdministrationId

Administration’s unique ID in GUID format.

Will be blank if contract is for an Administration group.

b224456a-23be-4524-89bd-a5d85db96b3c

AdministrationName

Administration’s name the contract applies to. See ‘Product group’ field in contract.

Will be blank if contract is for an Administration group.

FBO One

AllowRewardProgram

Indicates if the contract allows for reward programs. See ‘Allow reward program' field in contract. See Reward programs (Administration).

TRUE

BillingFormOfPaymentId

Billing form of payment’s unique ID in GUID format.

190f20fb-71e9-4b48-9df0-f0642e270e19

BillingFormOfPaymentName

Billing form of payment for the contract. See 'Order form of payment' field in contract.

BILL EUR

CheckoutRemarksForCustomers

The checkout remarks for users on checkout. See 'Check-out remarks for customer service reps' field in contract.

Fuel release required

ContractId

Contract’s unique ID in GUID format.

860547f9-bc8c-40af-a44a-3e8811e76296

CreditTermDays

The credit term in days for the contract. See 'Credit term in days' field in contract.

15

DebtorContactNo

The debtors contact number for the contract. See ‘Contact number’ field in the contract’s debtor contact.

610010

DebtorId

Debtor contact’s unique ID in GUID format.

cf0212aa-24ba-41e5-a49c-4ddee172f604

DebtorName

The debtors name for the contract. See ‘Organization name’ field in the contract’s debtor contact.

NETJETS TRANSPORTES AEREOS S.A.

DebtorShortName

The debtors short name for the contract. See ‘Short name’ field in the contract’s debtor contact.

NetJets EU

DutyTaxExemptionEnumValue

The duty tax exemption type for the contract in number format. See 'Duty tax exemption type' field in contract, and SKU excise taxes (Administration) Possible values are:

  • 0 = Specify per ticket

  • 1 = Exempt

  • 2 = Not exempt

0

DutyTaxExemptionName

The duty tax exemption type for the contract . See 'Duty tax exemption type' field in contract, and SKU excise taxes (Administration) Possible values are:

  • Specify per ticket

  • Exempt

  • Not exempt

Specify per ticket

ExpiryDate

Expiry date for the contract. See 'Expiry date' field in contract.

01-Jan-21

HidePricesOnCheckoutReceipt

Indicates if prices should be hidden on receipt to the customer. See ‘Hide prices on operators' copy' field in contract.

FALSE

InvoiceSeparatelyFromOtherContracts

Indicates if the contract’s product group should be invoiced separately to other product groups. See 'Must be invoiced separately from other contracts’ field in contract.

TRUE

IsDebtorsOrderNumberRequired

Indicates if the debtor’s order number is required. See 'Is ticket debtor's order number required' field in contract

FALSE

IsExpired

Indicates if the contract has expired based on the expiry date.

FALSE

IsThroughtputContract

Indicates if the contract is throughput into plane. See 'Is throughput (into plane)' field in contract.

FALSE

IsValidForFuelAdditives

Indicates if the contract is valid for fuel additives. See 'Valid for fuel additives (Prist)' field in contract.

FALSE

MustBePaidAtDesk

Indicates if the contract must be paid at front desk. See 'Must be paid at OPS desk' field in contract.

FALSE

NextReviewDate

Next review date for the contract. See 'Next review date' field in contract.

01-Sep-20

ProductGroupId

Contact’s product group unique ID in GUID format.

7de7369e-9b5c-4e31-97be-101b452e9299

ProductGroupName

Product group’s name for the contract. See 'Product group' field in contract.

JET A1 - SPLO | Uplift

Remarks

Free text remarks for the contract. See 'Remarks' field in contract.

Contract added based on network contract arrangement

RequiresCarnetPayment

Indicates if the contract requires carnet payment. See 'Requires carnet payment' field in contract.

FALSE

UnitOfMeasureToChargeInId

Unit of measure’s unique ID in GUID format.

ac3cdbad-72aa-4564-8fc3-2c5abe52131f

UnitOfMeasureToChargeInName

Contract’s unit of measure to charge fuel. See 'Unit of measure to charge fuel in' field in contract.

ltr