Card On File query

Contents:

Filters

Filter

Description

Mandatory

Filter

Description

Mandatory

  • Card On File Created (UTC) On Or After / Card On File Created (UTC) Before

  • Card On File Created (LT) On Or After / Card On File Created (LT) Before

Filters on card on file created date. Use both on or after and before to create a data range.

Note: ‘Card On File Created’ UTC and LT filters cannot be used together.

NO

  • Card On File Deactivated (UTC) On Or After / Card On File Deactivated (UTC) Before

  • Card On File Deactivated (LT) On Or After / Card On File Deactivated (LT) Before

Filters on card on file deactivated date. Use both on or after and before to create a data range.

Note: ‘Card On File Deactivated’ UTC and LT filters cannot be used together.

NO

Card On File Expiry Date On Or After / Card On File Expiry Date Before

Filters on card on file expired date. Use both on or after and before to create a data range.

NO

Data provider settings

There are no data provider settings for this query.

Columns

Name

Description

Example

Name

Description

Example

Aircraft Registration Display Name

Aircraft registration display name the card on file can be used for. See 'Aircraft registration' field in Payment Cards On File (Administration).

Format: Registration code (Short name)

060500 (G550)

Aircraft Registration Id

The aircraft registration linked to the card on file’s unique ID in GUID format.

37ea3569-6061-496a-80a0-485316299b28

Alias

Alias for the card on file. See 'Alias' field in Payment Cards On File (Administration).

Format: Form of Payment Display Name, Number Last 4 Digits

AHT Air Card Retail, 7114

Card On File Id

The card on file’s unique ID in GUID format.

76b4cfdf-0f86-4a3b-909f-16beeef4abd2

Created Utc

Date in UTC the card on file was created and stored. See 'CreatedUTC' field in Payment Cards On File (Administration).

08-Feb-20

Deactivated At Utc

Date in UTC the card on file was deactivated. See 'Deactivated at UTC' field in Payment Cards On File (Administration).

03-May-20

Deactivated Days

Days ago from current time in UTC the card was deactivated.

-260

Deactivation Reason

Reason for card on file deactivation. See 'Deactivation reason' field in Payment Cards On File (Administration).

Expired Card

Debtor Or Operator Contact Display Name

Debtor or operator contact display name the card on file can be used for. See 'Debtor or operator' field in Payment Cards On File (Administration).

Format: Organization name (Contact number)

US Air Force (100243)

Debtor Or Operator Contact Id

The debtor or operator’s unique ID in GUID format.

be171c87-cd02-45a4-a74a-5c041a89c198

Expire In Days

Days until card on file expires based upon the difference between the current date in UTC to expiry date.

529

Expiry Date

Date the card on file was deactivated. See 'ExpiryDate' field in Payment Cards On File (Administration).

30-Jun-22

Form Of Payment Display Name

Form of payment display name for the card on file. See 'Form of payment' field in Payment Cards On File (Administration).

AHT Air Card Retail

Form Of Payment Id

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

07be0500-3c17-4c79-8039-d1f229cb78bc

Is Active

Indicates if the card on file is still active for use. See ‘Is active’ field in Payment Cards On File (Administration).

TRUE

Number Last 4 Digits

Last 4 digits of the card on file long number.

7114

Payment Gateway Account Id

The payment gateway account’s unique ID in GUID format.

df8a5b56-c0f2-402c-b9a4-5ea2c07c02d1

Payment Gateway Account Name

Payment gateway account name used for the card on file. See 'Name' field in Payment Gateways (Administration).

AHT payment gateway - Munich

Payment Receipt Recipients

List of email payment recipients for when payment is authorized using the card on file. See 'Payment receipt recipients' field in Payment Cards On File (Administration).

ChiefPilot@gmail.com

Remarks

Free text remarks for the card on file. See 'Remarks' field in Payment Cards On File (Administration).

Card stored on pilot request