The Card On File query is used to export all cards stored on file from online payments.
Contents
Filters
|
Filter |
Description |
Mandatory |
|---|---|---|
|
Filters on the 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 |
|
Filters on the 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 |
|
Payment gateway account |
Filters on payment gateway showing cards on file for the specific account. If left blank then all accounts are shown. |
NO |
Data provider settings
There are no data provider settings for this query.
Columns
|
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 Cards On File (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 |
Comments
0 comments
Please sign in to leave a comment.