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 |
---|---|---|
Administration |
Filters on Administration. Required for contract columns. A single Administration can be chosen only. |
YES |
|
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. |
|
Email 2 |
The accounting/back office email for the contact. See ‘Email 2 (Back office)’ field in contact. |
|
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 |
Comments
0 comments
Please sign in to leave a comment.