Contacts query

The contacts query is used to export the contacts data for reporting, showing each contact per row.

You can download the contacts using the default ‘Contacts’ report.

Contents

Filters

Filter

Description

Mandatory

Filter

Description

Mandatory

Administration

Filters on Administration. Required for contract columns.

A single Administration can be chosen only.

YES

  • AOC expiration date from

  • AOC expiration date before

Filter between AOC expiration date using ‘from date’ or ‘before date’, using both 'from' and 'before' creates a data range. Will only show if Administration uses AOC.

If AOC expiration from/before is set, then contacts with no AOC expiration will be excluded.

NO

Data provider settings

There are no data provider settings for this query.

Columns

Name

Description

Example

Address 1

First line of the contact’s address. See ‘Address 1' field in contact.

K Letisti 549 - Hangar C

Address 2

Second line of the contact’s address. See ‘Address 2’ field in contact.

Airport Ruzyne  South

Administration name

Administration chosen in query filters.

JZRH

AdministrationContactNo

Administration specific contact number for chosen Administration in query filters. See 'Administration contact number' field in contact.

10015

AOC expire date

Expiry date for the AOC for the contact. See 'AOC valid until' field in contact.

12-31-20

AOC number

AOC number for the contact. See 'AOC number' field in contact.

CZ-8

Batch invoice

Indicates if the contact’s orders are batched into a single invoice. See 'Batch multiple orders into a single invoice' field in contact.

TRUE

Carrier code

Airline carrier code for the contact (this may be the airlines callsign). See ‘Carrier code’ field in contact.

BAIR

Charge VAT

VAT treatment for the contact, this may differ per Administration. See ‘Charge VAT’ field in contact.

Controlled by VAT calculator (Swiss VAT)

City

City for the contact. See 'City' field in contact.

Praha 6

Consolidate invoices

Indicates if the contact’s invoices are included in entry export files. See 'Include invoices in entry export file' field in contact.

TRUE

Contact category name

The type of contact; possible values are: ‘Organization’ or ‘Person’.

Organization

Contact ID

Contact’s unique ID in GUID format.

99440387-b2bf-4c9e-92b0-d7ee1dc4a783

Contact no.

The accounting contact number for the contact. See ‘Contact number' field in contact.

2025012

Contract next review date

The contract review date specified in the primary contract, for information purposes only. See Contracts (Administration).

12-20-20

Contract remarks

The contract remarks specified in the primary contract, see Contracts (Administration).

I have checked and you can give 10 days.

Country code

Country name and code for the contact’s address. See ‘Country’ field in contact.

Czech Republic (CZ)

Country code for VAT

Country name and code for the contact’s VAT treatment. See ‘Country for VAT purposes’ field in contact.

Czech Republic (CZ)

Credit term days

The contract credit term in days specified in the primary contract, see Contracts (Administration).

10

Date of birth

Date of birth of the contact, see ‘Date of birth’ field in contact.

Applicable to Person contacts only.

01-01-80

Default debtor order no.

Contact’s default debtor order number displayed on invoices. See 'Invoice reference number' field in contact.

123456

Department

Department of the contact, see ‘Department’ field in contact.

Applicable to Person contacts only.

Operations

Disable payment cards on file

Indicates if payment cards on file can be stored against this contact. See 'Disable keeping payment cards on file' field in contact.

FALSE

Email 1

The operational/front office email for the contact. See ‘Email 1 (Operations)’ field in contact.

ops@absjets.com

Email 2

The accounting/back office email for the contact. See ‘Email 2 (Back office)’ field in contact.

invoices@absjets.com

Fax

Fax number for the contact. See ‘Fax’ field in contact.

+420(220)112623

First name

First name for the contact. See ‘First name’ field in contact.

Applicable to Person contacts only.

Adam

Has AOC for airside VAT exemption purposes

Indicates if the contact has AOC exemption for VAT; possible values are: ‘Unknown’, ‘No’, ‘Yes’. See 'Has AOC for airside VAT exemption purposes' field in contact.

Yes

Hide prices on operator's copy

Indicates if the prices should be shown on the operator’s copy in the primary contract. See Contracts (Administration), .

FALSE

Initials

Initials for the contact. See ‘Initials’ field in contact.

Applicable to Person contacts only.

AM

Invoice ledger

This column is no longer used and is for backward compatibility only.

 

Is active

Indicates if the contact is marked as active. See ‘Is active’ field in contact.

TRUE

Is crew member

Indicates if the contact is marked as a crew member. See ‘Type of contact’ field in contact.

Applicable to Person contacts only.

FALSE

Is debtor

Indicates if the contact is marked as a debtor. See ‘Type of contact’ field in contact.

TRUE

Is headquarter

Indicates if the contact is marked as a headquarter. See Add Headquarter - add/edit screen.

FALSE

Is operator

Indicates if the contact is marked as a operator. See ‘Type of contact’ field in contact.

TRUE

Is organization

Indicates if the contact is an organization.

TRUE

Is PAX

Indicates if the contact is marked as a passenger. See ‘Type of contact’ field in contact.

Applicable to Person contacts only.

FALSE

Is staff member

Indicates if the contact is marked as a staff member for an organization. See ‘This contact is not part of an organization’ field in contact.

Applicable to Person contacts only.

FALSE

Is supplier

Indicates if the contact is marked as a supplier. See 'Type of contact' field in contact.

FALSE

Is trip support provider

Indicates if the contact is marked as a trip support provider. See 'Type of contact' field in contact.

TRUE

Job title

Job title for the contact. See ‘Job title’ field in contact.

Applicable to Person contacts only.

Support

Last name

Last name for the contact. See ‘Last name’ field in contact.

Applicable to Person contacts only.

Marriott

Name

The official name for the contact. See ‘Organization name' field in contact.

ABS Jets, a.s.

Operator type name

The operator type for the contact. See ‘Operator type’ field in contact. See Operator types (Administration).

Commercial

Override auto attach JSON to email invoice

Indicates if the contact is overriding the Administration default for attaching the invoice JSON file when sending an invoice by email. If blank, then the Administration’s setting is taken. See ‘Auto attach JSON file to email invoice’ field in contact.

TRUE

Parent organization contact country code

The parent organization country and code for the contact. See ‘Organization’ field in contact.

Applicable to Person contacts only.

Czech Republic (CZ)

Parent organization contact name

The parent organization name for the contact. See ‘Organization’ field in contact.

Applicable to Person contacts only.

ABS Jets a.s.

Pay VAT

This column is no longer used and is for backward compatibility only.

 

Pay VAT from AOC

Indicates if AOC is used for VAT purposes for the contact (controlled by VAT calculator). See 'Charge VAT' field in contact.

TRUE

Pay VAT from product

Indicates if the product’s VAT is used for the contact (controlled by product). See 'Charge VAT' field in contact.

FALSE

Phone 1

The operational/front office phone number for the contact. See ‘Phone 1’ field in contact.

+420(220)123456

Phone 2

The accounting/back office phone number for the contact. See ‘Phone 2’ field in contact.

+420(220)123456

Restricted to fbo location group

The FBO location group the contact is restricted to, if blank contact is unrestricted. See ‘Restricted to FBO location group’ field in contact.

JNED

RestrictedToFboLocationGroupId

Restricted to FBO location group’s unique ID in GUID format.

f0037a81-664d-4fbe-98de-1286816cb779

Short name

The operational short name for the contact. See 'Short name' field in contact.

ABS Jets, a.s.

SITA

SITA number for the contact. See ‘SITA’ field in contact.

LKPRABPX

Staff number

Staff number for the contact. See 'Employee number / staff number' field in contact.

Applicable to Person contacts only.

12345

State

The address state/county for the contact. See 'State' field in contact.

Prague

Validate AOC from operator

Indicates if the operator’s AOC determines the VAT for this contact, for example: the contact is a debtor only.

FALSE

Validation key

This column is no longer used and is for backward compatibility only.

 

VAT number

VAT number for the contact. See 'VAT number' field in contact.

CZ 12345678

VAT remark

VAT remark for the contact. See 'VAT remark' field in contact.

Military - VAT exempt

Website URL

Website URL for the contact. See 'Website' field in contact.

www.absjets.com

Zip code

The address Zip code/postal code for the contact. See 'Zip code' field in contact.

161 00