The Contracts query is used to export customer Contract data, showing each contract per row.
You can download customer contracts using the default ‘Contracts’ report.
Contents
Filters
|
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. |
YES |
Data provider settings
There are no data provider settings for this query.
Columns
|
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 |
|
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 |
|
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 |
Comments
0 comments
Please sign in to leave a comment.