Fields
GET https://api.letpay.io/myreports/report/fields?reportType=PAYIN
This endpoint retrieve Available Tables and Columns
This endpoint is used to retrieve a list of tables and their respective columns available for a given report type. It is designed to provide metadata necessary for building reports dynamically.
Request
Query Parameters
reportType: (required, string) - Identifies the type of report. The list of available report types can be obtained using the "Get Report Types" endpoint.
Response Body
The response contains metadata about the tables and their fields.
tableName: (string) - The name of the table associated with the given report type.fields: (array of objects) - A list of fields (columns) within the table. Each field includes the following properties:id: (int) - A unique identifier for the field.name: (string) - The name of the field.alias: (string) - An alias or alternate name for the field.description: (string) - A textual description explaining the purpose or meaning of the field.data_type: (string) - The data type of the field (e.g., string, integer, date).size: (string) - The size or length of the field, typically applicable for text-based fields.arithmetic_operators: (array of strings) - A list of arithmetic operators that can be used with the field (e.g., +, -, *, /).aggregation_operators: (array of strings) - A list of aggregation functions that are applicable to the field (e.g., SUM, AVG, COUNT).filters_operators: (array of strings) - Operators allowed for filtering the field (e.g.,=,!=,>,<).dynamic_filters: (array of strings) - Predefined filters dynamically applicable to this field.wraps: (array of strings) - A set of transformation functions or wrappers that can be applied to the field.allowed_values: (array of strings) - A restricted list of acceptable values for this field. If this array is not empty, the field's filter values must be present in the allowed_values list.
Fields
| Table Name | Field | Alias | Description | Data Type |
|---|---|---|---|---|
| payment | id | Payment Id | Unique identifier for the payment record. | VARCHAR |
| payment | amount | Amount | Total amount of the payment transaction (in the specified asset currency). | DECIMAL |
| payment | charge_back_date | Charge Back Date | The date when a chargeback occurred for this payment, if applicable. | DATETIME |
| payment | charge_back_details | Charge Back Details | Details or notes regarding a chargeback associated with this payment (e.g., reason, case ID). | VARCHAR |
| payment | confirmation_date | Confirmation Date | The date when the payment was confirmed | DATETIME |
| payment | created_at | Created At | Timestamp when this payment record was created in the system. | DATETIME |
| payment | customer_amount | Customer Amount | The amount the customer is expected to pay | DECIMAL |
| payment | customer_fee_total | Customer Fee Total | The total fees charged to the customer for this transaction (if any). | DECIMAL |
| payment | details | Details | Additional details or description of the error payment | TEXT |
| payment | error_code | Error Code | An error code if the payment failed or encountered an error (blank or null if successful). | TEXT |
| payment | installments | Installments | Number of installments for this payment (if the customer chose to pay in installments). | INT |
| payment | merchant_amount | Merchant Amount | The amount to be received by the merchant after fees | DECIMAL |
| payment | merchant_fee_total | Merchant Fee Total | The total fees charged to the merchant for this transaction. | DECIMAL |
| payment | method | Method | The payment method used (e.g., credit_card, bank_transfer, PIX, boleto, etc.). | TEXT |
| payment | reference | Reference | Reference identifier for this payment provided by the merchant | TEXT |
| payment | asset_currency_code | Asset Currency Code | Currency code of the asset or funds for this payment (currency in which the amount is denominated). | TEXT |
| payment | contract_id | Contract Id | ID of the contract associated with this payment (defines terms and conditions like fees for the transaction). | TEXT |
| payment | merchant_from_id | Merchant Id | The ID of the merchant from which this payment originated | TEXT |
| payment | person_id | Person Id | ID of the person (individual customer or payee) associated with this payment | INT |
| payment | ip_addr_from | IP Address | IP address from which the payment was initiated (usually the customer’s IP address). | VARCHAR |
| payment | original_amount | Original Amount | The original transaction amount before any currency conversion (in the original local currency). | DECIMAL |
| payment | original_asset_currency_code | Original Currency | The currency code of the original amount | VARCHAR |
| payment | converted_rate | Converted Rate | The exchange rate used to convert the original amount to the payment currency. | DECIMAL |
| payment | payment_code_info | Payment Code Info | A code or reference string for the payment, primarily used to store the pix copia e cola value. It may also be used for other offline methods such as barcodes or reference numbers for boleto or OXXO payments. | DATETIME |
| payment | notification_url | Notification URL | URL to which payment notifications (webhooks) for this transaction should be sent (overrides the default if provided for this transaction). | VARCHAR |
| payment | payment_date_boleto_info | Payment Date Boleto | The date when the boleto (payment slip) was paid/cleared. | VARCHAR |
| payment | delay_capture | Delay Capture | Indicator of whether the payment capture is delayed (true if the payment was authorized but not immediately captured). | BOOLEAN |
| payment | soft_descriptor | Soft Descriptor | Custom text that appears on the customer’s bank or card statement for this payment (the “soft descriptor”). | VARCHAR |
| payment | received_amount | Received Amount | The actual amount of money received/collected for this payment | DECIMAL |
| payment | availability_date | Availability Date | The date when the funds from this payment are expected to become available for payout to the merchant. | DATE |
| payment | sub_statement_id | Sub Statement Id | ID of the sub-statement record that includes this payment | INT |
| payment | settlement_status | Settlement Status | The settlement process status for this payment (e.g., whether it has been settled to the merchant yet) | VARCHAR |
| payment | payment_country | Payment Country | The country associated with this payment | VARCHAR |
| payment | transaction_status | Transaction Status | Overall status of the transaction | VARCHAR |
| person | id | Person Id | Unique identifier for the person record. | INT |
| person | additional_address | Additional Address | Additional address details (e.g., apartment or suite number, complement). | INT |
| person | birth | Birth | Date of birth of the person. | DATE |
| person | city_address | City Address | City of the person’s address. | VARCHAR |
| person | country_address | Country Address | Country of the person’s address | VARCHAR |
| person | created_at | Created At | Timestamp when this person record was created. | DATETIME |
| person | Email address of the person. | VARCHAR | ||
| person | locality_address | Locality Address | Locality or neighborhood of the address. | VARCHAR |
| person | main_address | Main Address | Primary street address of the person (street name and number). | VARCHAR |
| person | name | Name | First name or given name of the person. | VARCHAR |
| person | number_address | Number Address | Street number of the person’s address. | VARCHAR |
| person | state_address | State Address | State or province of the person’s address. | VARCHAR |
| person | surname | Surname | Last name or family name of the person. | VARCHAR |
| person | tax_id | Tax Id | Tax identification number or national ID of the person. | VARCHAR |
| person | telephone_number | Telephone Number | Phone number of the person | VARCHAR |
| person | zip_code | Zip Code | Postal/ZIP code of the person’s address. | VARCHAR |
| person | public_person_id | Public Person Id | Identifier of the person used in combination with the public_card_id to process token-based payments (e.g., for transactions where sensitive card data is replaced by a token). | VARCHAR |
| person | telephone_country | Telephone Country | Country calling code of the person’s phone number. | VARCHAR |
| person | telephone_area | Telephone Area | Telephone area code of the person’s phone number. | VARCHAR |
| person | verified_name | Verified Name | The full name of the person as verified by official documents (e.g., after identity verification). | VARCHAR |
| merchant | corporate_name | Corporate Name | The registered corporate name of the merchant (legal entity name). | VARCHAR |
| merchant | trade_name | Trade Name | Merchant common name. | VARCHAR |
| merchant | description | Description | Short description or overview of the merchant (e.g., brief business description). | VARCHAR |
| merchant | notification_url | Notification Url | The URL where the merchant receives payment notifications (webhooks). | VARCHAR |
| merchant | opening_date | Opening Date | The date when the merchant’s account or business was opened/registered. | DATETIME |
| merchant | primate_activity | Primate Activity | Primary business activity or industry of the merchant. | VARCHAR |
| merchant | tax_id | Tax Id | Tax identification number of the merchant (e.g., company tax ID such as CNPJ). | VARCHAR |
| merchant | telephone_number | Telephone Number | Contact telephone number of the merchant. | VARCHAR |
| merchant | id | Merchant Id | Unique identifier for the merchant. | VARCHAR |
| merchant | url | Url | The merchant’s website URL. | VARCHAR |
| contract | id | Contract Id | Unique identifier for the contract. | VARCHAR |
| contract | active | Active | Indicates if the contract is currently active (true/false). | BOOLEAN |
| contract | created_at | Created At | Timestamp when this contract record was created. | DATETIME |
| contract | merchant_id | Merchant Id | The ID of the merchant to which this contract belongs. | VARCHAR |
| contract | days_to_pay | Days To Pay | The specific days of the month when settlement cycles close (e.g., 1, 8, 15, 23). On these dates, all available transactions are grouped for payout processing. | VARCHAR |
| contract | delta | Delta | The grace period (in days) after the settlement cycle closes during which the company must complete the payout to the merchant. | VARCHAR |
| contract | soft_descriptor | Soft Descriptor | Custom text that appears on the customer’s bank or card statement for this payment (the “soft descriptor”). | VARCHAR |
| contract | type | Type | Payin or Payout | VARCHAR |
| contract | card_security_type | Card Security Type | Specifies card data security requirements for this contract | TEXT |
| sub_statement | id | Sub Statement Id | Unique identifier for the sub-statement record. | INT |
| sub_statement | created_at | Created At | Timestamp when this sub-statement was generated/created. | DATETIME |
| sub_statement | payment_currency | Payment Currency | The currency of the transactions included in this sub-statement. | VARCHAR |
| sub_statement | transaction_count | Transaction Count | The number of transactions included in this sub-statement. | INT |
| sub_statement | tpv | TPV | Total payment volume of all included transactions (sum of all transaction amounts in the payment currency). | DECIMAL |
| sub_statement | chargebacks | Chargebacks | Total amount of chargebacks in this sub-statement (sum of all chargeback transaction amounts). | DECIMAL |
| sub_statement | refunds | Refunds | Total amount of refunds in this sub-statement (sum of all refunded transaction amounts). | DECIMAL |
| sub_statement | settlement_balance | Settlement Balance | The net amount to be settled to the merchant for this sub-statement (after refunds/chargebacks, typically in the settlement currency). | DECIMAL |
| sub_statement | settlement_date | Settlement Date | The date when the settlement (transfer of funds) is scheduled or completed for this sub-statement. | DATE |
| sub_statement | average_fx_rate | Average fx Rate | The average foreign exchange rate applied if converting from the payment currency to the settlement currency. | DECIMAL |
| sub_statement | service_statement_id | Service Statement Id | Identifier of the parent service statement or report that this sub-statement is part of. | INT |
| sub_statement | country_id | Country Id | Identifier of the country associated with this sub-statement | CHAR |
| card | brand | Brand | Card brand or network (e.g., Visa, MasterCard, Amex). | VARCHAR |
| card | bin | Bin | Bank Identification Number (first 6 digits of the card). | VARCHAR |
| card | last_4 | Last 4 | Last four digits of the card number. | VARCHAR |
| payout_transaction | tx_id | Tx Id | Payout Transaction Id. Unique numeric identifier of the payout transaction. | VARCHAR |
| payout_transaction | original_amount | Original Amount | Original Amount. Value of the payout in the original currency. | DECIMAL |
| payout_transaction | original_currency | Original Currency | Original Currency. Currency code of the original amount. | VARCHAR |
| payout_transaction | payment_currency | Payment Currency | Payment Currency. Currency in which the payout is executed. | VARCHAR |
| payout_transaction | payment_country | Payment Country | Payment Country. Country code where the payout is sent. | CHAR |
| payout_transaction | payment_amount | Payment Amount | Payment Amount. Value of the payout in the payment currency. | DECIMAL |
| payout_transaction | payout_method | Payout Method | Payout Method. Method used to deliver the payout (e.g., bank, wallet, pix, SPEI). | VARCHAR |
| payout_transaction | contract_id | Contract Id | Contract Id. Identifier of the contract linked to the payout. | VARCHAR |
| payout_transaction | reference_id | Reference Id | Reference Id. External identifier provided by the merchant when creating the transaction. | VARCHAR |
| payout_transaction | banking_data | Banking Data | Banking Data. Beneficiary’s account or wallet details required to execute the payout. Depending on the payout method and country, this may include bank account numbers, IBAN/SWIFT codes, wallet identifiers, or, in Brazil, a Pix key. | VARCHAR |
| payout_transaction | schedule_date | Schedule Date | Schedule Date. Date when the payout is scheduled to be processed. | DATE |
| payout_transaction | create_date | Create Date | Create Date. Date when the payout was created. | DATETIME |
| payout_transaction | settlement_status | Settlement Status | Settlement Status. Current settlement stage of the payout. | VARCHAR |
| payout_transaction | customer_amount | Customer Amount | Customer Amount. Total amount the customer (beneficiary) actually received from the payout. | DECIMAL |
| payout_transaction | merchant_amount | Merchant Amount | Merchant Amount. Total amount debited from the merchant’s account to fund the payout. | DECIMAL |
| payout_transaction | converted_rate | Converted Rate | Exchange rate applied, if conversion occurred. | DECIMAL |
| payout_transaction | amount | Amount | Amount. Base amount of the payout in the payment currency. | DECIMAL |
| payout_transaction | asset | Asset | Asset. Asset or currency of the payout. | VARCHAR |
| payout_transaction | original_asset | Original Asset | Original Asset. Asset or currency of the original amount. | VARCHAR |
| payout_transaction | customer_fee_total | Customer Fee Total | Customer Fee Total. Fees paid by the customer. Total fees deducted from the amount the customer (beneficiary) would receive. In practice, this reduces the final payout delivered to the customer. | DECIMAL |
| payout_transaction | merchant_fee_total | Merchant Fee Total | Merchant Fee Total. Fees paid by the merchant. | DECIMAL |
| payout_transaction | status | Status | Status. General processing status of the payout. | VARCHAR |
| payout_transaction | sub_statement_id | Sub Statement Id | Sub Statement Id. Reference to the settlement statement entry. | INT |
| payout_transaction | notification_url | Notification Url | Notification URL. Webhook URL for payout notifications. | VARCHAR |
| payout_transaction | end2end_id | End2end Id | End2end Id. End-to-end reference used in banking networks. | VARCHAR |
| payout_transaction | error_code | Error Code | Error Code. Code describing a payout error. | VARCHAR |
| payout_transaction | error_details | Error Details | Error Details. Description of the payout error. | TEXT |
| asset | currency_code | Currency Code | Currency Code. Currency or asset code (e.g., USD, BRL). | VARCHAR |
| asset | active | Active | Active. Indicates if the asset is active. | BOOLEAN |
| asset | description | Description | Description. Full name of the currency or asset. | VARCHAR |
| platform_user | id | Platform User Id | Platform User Id. Unique identifier of the platform user. | VARCHAR |
| platform_user | authority_list | Authority List | Authority List. Roles of the user. | VARCHAR |
| platform_user | Email. Email address of the user. | VARCHAR | ||
| platform_user | name | Name | Name. Full name of the user. | VARCHAR |
| platform_user | username | Username | Username. Login username of the user. | VARCHAR |
| refund | id | Refund Id | Refund Id. Unique identifier of the refund. | INT |
| refund | created_at | Created At | Created At. Date the refund was created. | DATETIME |
| refund | status | Status | Status. Current status of the refund. | VARCHAR |
| refund | refund_amount | Refund Amount | Refund Amount. Value refunded to the customer. | DECIMAL |
| refund | payment_id | Payment Id | Payment Id. Identifier of the original payment. | VARCHAR |
| refund | order_amount | Order Amount | Order Amount. Amount of the original order. | DECIMAL |
| refund | order_currency | Order Currency | Order Currency. Currency of the original order. | VARCHAR |
| refund | refund_currency | Refund Currency | Refund Currency. Currency used for the refund. | VARCHAR |
| refund | availability_date | Availability Date | Availability Date. Date when refund becomes available. | DATE |
| refund | settlement_status | Settlement Status | Settlement Status. Settlement stage of the refund. | VARCHAR |
| refund | notification_url | Notification Url | Notification URL. Webhook URL for refund updates. | VARCHAR |
| refund | sub_statement_id | Sub Statement Id | Sub Statement Id. Reference to the settlement statement. | INT |
| refund | merchant_amount | Merchant Amount | Merchant Amount. Refund amount from merchant’s side. | DECIMAL |
| refund | rate_id | Rate Id | Rate Id. Reference to the FX rate applied. | INT |
| dispute | id | Dispute Id | Dispute Id. Unique identifier of the dispute. | VARCHAR |
| dispute | payment_id | Payment Id | Payment Id. Identifier of the disputed payment. | VARCHAR |
| dispute | dispute_date | Dispute Date | Dispute Date. Date the dispute was raised | DATETIME |
| dispute | expiration_date | Expiration Date | Expiration Date. Deadline for dispute resolution. | DATETIME |
| dispute | created_at | Created At | Created At. Date dispute was recorded in the system. | DATETIME |
| dispute | status | Status | Status. Current status of the dispute. | VARCHAR |
| dispute | reason | Reason | Reason. Reason provided for the dispute. | VARCHAR |
| dispute | amount | Amount | Amount. Value disputed. | DECIMAL |
| dispute | merchant_amount | Merchant Amount | Merchant Amount. Disputed amount from merchant’s perspective. | DECIMAL |
| dispute | availability_date | Availability Date | Availability Date. Date disputed funds are available/finalized. | DATE |
| dispute | settlement_status | Settlement Status | Settlement Status. Financial settlement stage of the dispute. | VARCHAR |
| dispute | sub_statement_id | Sub Statement Id | Sub Statement Id. Reference to settlement statement. | INT |
| transaction_fee | created_at | Created At | Created At. Date the fee record was created. | DATETIME |
| transaction_fee | payment_method | Payment Method | Payment Method. Method linked to the fee. | VARCHAR |
| transaction_fee | fee_type | Fee Type | Category of the fee applied to the transaction. Examples include platform_fee (fees charged by the PSP platform), transaction_fee (processing fee per transaction), refund_fee (fee charged when a refund is processed), and currency_conversion_fee (fee applied when converting between currencies). | VARCHAR |
| transaction_fee | fee_subtype | Fee Subtype | More specific classification of the fee within its main type. Examples include service_fee (general service-related charges) or other sub-categories that provide finer detail about how the fee is applied. | VARCHAR |
| transaction_fee | fee_strategy | Fee Strategy | Fee Strategy. Strategy used to calculate the fee. | VARCHAR |
| transaction_fee | amount | Amount | Amount. Flat fee amount. Fixed Amount | DECIMAL |
| transaction_fee | percent | Percent | Percent. Percentage fee applied. | DECIMAL |
| transaction_fee | calculated_value | Calculated Value | Calculated Value. Total fee charged. | DECIMAL |
| transaction_fee | is_merchant_fee | Is Merchant Fee | Is Merchant Fee. Indicates if the fee is paid by the merchant. | BOOLEAN |
| transaction_fee | payment_id | Payment Id | Payment Id. Payment linked to the fee. | VARCHAR |
| transaction_fee | rate_id | Rate Id | Rate Id. FX rate reference used for the fee. | INT |
| transaction_fee | payout_transaction_id | Payout Transaction Id | Payout Transaction Id. Payout linked to the fee. | INT |
| merchant_activity | activity_date | Activity Date | Activity Date. Date of the merchant activity. | DATETIME |
| merchant_activity | base_amount | Base Amount | Base Amount. Amount in the base currency. | DECIMAL |
| merchant_activity | base_balance_after | Base Balance After | Base Balance After. Balance after the activity in base currency. | DECIMAL |
| merchant_activity | base_balance_before | Base Balance Before | Base Balance Before. Balance before the activity in base currency. | DECIMAL |
| merchant_activity | counter_amount | Counter Amount | Counter Amount. Amount in the counter currency. | DECIMAL |
| merchant_activity | counter_balance_after | Counter Balance After | Counter Balance After. Balance after the activity in counter currency. | DECIMAL |
| merchant_activity | counter_balance_before | Counter Balance Before | Counter Balance Before. Balance before the activity in counter currency. | DECIMAL |
| merchant_activity | created_at | Created_At | Created At. Date the activity record was created. | DATETIME |
| merchant_activity | fee_amount | Fee Amount | Fee Amount. Fee charged in the activity. | DECIMAL |
| merchant_activity | type | Type | Type. Type of merchant activity. | VARCHAR |
| merchant_activity | base_asset_currency_code | Base Aasset Currency Code | Base Asset Currency Code. Code of base currency. | VARCHAR |
| merchant_activity | counter_asset_currency_code | Counter Asset Currency Code | Counter Asset Currency Code. Code of counter currency. | VARCHAR |
Authorization
| AUTHORIZATION | API Key |
|---|---|
| Key | X-Auth-Token |
| Value | MY_ACCESS_TOKEN |
Example Request
- 200 - Success
- 401 - Unauthorized
- 400 - Bad Request
Example Request
200 - Success
curl --location 'https://api.letpay.io/myreports/report/fields?reportType=PAYIN'
--header 'X-Auth-Token: MY_ACCESS_TOKEN' \
--params 'reportType=PAYIN' \
Example Response
Header
Content-Type: application/json
Body
[
{
"tableName": "Merchant",
"fields": [
{
"id": 100,
"alias": "Aggregator Id",
"name": "aggregator_id",
"description": "",
"table_name": "merchant",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 93,
"alias": "Base Asset Currency Code",
"name": "base_asset_currency_code",
"description": "",
"table_name": "merchant",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 82,
"alias": "Billing Address",
"name": "billing_address",
"description": "",
"table_name": "merchant",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 83,
"alias": "Corporate Name",
"name": "corporate_name",
"description": "",
"table_name": "merchant",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 84,
"alias": "Day To Payout",
"name": "day_to_payout",
"description": "",
"table_name": "merchant",
"data_type": "INT",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MAX",
" MIN",
" COUNT"
],
"filters_operators": [
"!=",
" =",
" >=",
" <=",
" >",
" <"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 85,
"alias": "Description",
"name": "description",
"description": "",
"table_name": "merchant",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 97,
"alias": "letpay Owner",
"name": "letpay_owner",
"description": "",
"table_name": "merchant",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 96,
"alias": "Hub Spot Id",
"name": "hub_spot_id",
"description": "",
"table_name": "merchant",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 99,
"alias": "Kyc Id",
"name": "kyc_id",
"description": "",
"table_name": "merchant",
"data_type": "INT",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MAX",
" MIN",
" COUNT"
],
"filters_operators": [
"!=",
" =",
" >=",
" <=",
" >",
" <"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 98,
"alias": "Mcc",
"name": "mcc",
"description": "",
"table_name": "merchant",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 92,
"alias": "Merchant Id",
"name": "id",
"description": "",
"table_name": "merchant",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 86,
"alias": "Notification Url",
"name": "notification_url",
"description": "",
"table_name": "merchant",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 87,
"alias": "Opening Date",
"name": "opening_date",
"description": "",
"table_name": "merchant",
"data_type": "DATETIME",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MIN",
" MAX",
" AVG",
" COUNT"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [
"CURRENT_YEAR",
"CURRENT_MONTH",
"CURRENT_WEEK",
"CURRENT_DAY",
"NOW",
"LAST_90_DAYS",
"LAST_60_DAYS",
"LAST_45_DAYS",
"LAST_30_DAYS",
"LAST_15_DAYS",
"LAST_7_DAYS",
"LAST_DAY"
],
"wraps": [
"YEAR",
"QUARTER",
"MONTH",
"DATE",
"WEEK_OF_YEAR",
"DAY_OF_MONTH",
"DAY_OF_WEEK",
"DAY_OF_YEAR",
"AGE_IN_YEARS",
"AGE_IN_DAYS",
"AGE_IN_HOURS",
"AGE_IN_MINUTES"
]
},
{
"id": 88,
"alias": "Primate Activity",
"name": "primate_activity",
"description": "",
"table_name": "merchant",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 94,
"alias": "Realm",
"name": "realm",
"description": "",
"table_name": "merchant",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 89,
"alias": "Tax Id",
"name": "tax_id",
"description": "",
"table_name": "merchant",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 90,
"alias": "Telephone Number",
"name": "telephone_number",
"description": "",
"table_name": "merchant",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 91,
"alias": "Type",
"name": "type",
"description": "",
"table_name": "merchant",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 95,
"alias": "Url",
"name": "url",
"description": "",
"table_name": "merchant",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
}
]
},
{
"tableName": "Card",
"fields": [
{
"id": 168,
"alias": "Bin",
"name": "bin",
"description": "",
"table_name": "card",
"data_type": "VARCHAR",
"size": 6,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 167,
"alias": "Brand",
"name": "brand",
"description": "",
"table_name": "card",
"data_type": "VARCHAR",
"size": 45,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 169,
"alias": "Last 4",
"name": "last_4",
"description": "",
"table_name": "card",
"data_type": "VARCHAR",
"size": 4,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
}
]
},
{
"tableName": "Transaction Flag",
"fields": [
{
"id": 269,
"alias": "Payment id",
"name": "payment_id",
"description": "",
"table_name": "transaction_flag",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"=",
" !=",
" NOT IN",
" IN",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 268,
"alias": "Transaction Flag Id",
"name": "id",
"description": "",
"table_name": "transaction_flag",
"data_type": "INT",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MAX",
" MIN",
" COUNT"
],
"filters_operators": [
"!=",
" =",
" >=",
" <=",
" >",
" <"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 270,
"alias": "flag",
"name": "flag",
"description": "",
"table_name": "transaction_flag",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"=",
" !=",
" NOT IN",
" IN",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
}
]
},
{
"tableName": "Payment",
"fields": [
{
"id": 2,
"alias": "Amount",
"name": "amount",
"description": "",
"table_name": "payment",
"data_type": "DECIMAL",
"size": 0,
"arithmetic_operators": [
"+",
" -",
" *",
" /",
" %"
],
"aggregation_operators": [
"SUM",
" COUNT",
" AVG",
" MAX",
" MIN",
" STDDEV"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"ABS",
"CEIL",
"FLOOR",
"ROUND2",
"ROUND3",
"ROUND4"
]
},
{
"id": 24,
"alias": "Asset Currency Code",
"name": "asset_currency_code",
"description": "",
"table_name": "payment",
"data_type": "TEXT",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 49,
"alias": "Attempt Reference",
"name": "attempt_reference",
"description": "",
"table_name": "payment",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 50,
"alias": "Availability Date",
"name": "availability_date",
"description": "",
"table_name": "payment",
"data_type": "DATE",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MIN",
" MAX",
" AVG",
" COUNT"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [
"CURRENT_YEAR",
"CURRENT_MONTH",
"CURRENT_WEEK",
"CURRENT_DAY",
"NOW",
"LAST_90_DAYS",
"LAST_60_DAYS",
"LAST_45_DAYS",
"LAST_30_DAYS",
"LAST_15_DAYS",
"LAST_7_DAYS",
"LAST_DAY"
],
"wraps": [
"YEAR",
"QUARTER",
"MONTH",
"DATE",
"WEEK_OF_YEAR",
"DAY_OF_MONTH",
"DAY_OF_WEEK",
"DAY_OF_YEAR",
"HOUR",
"MINUTE",
"AGE_IN_YEARS",
"AGE_IN_DAYS"
]
},
{
"id": 33,
"alias": "Channel",
"name": "channel",
"description": "",
"table_name": "payment",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 3,
"alias": "Charge Back Date",
"name": "charge_back_date",
"description": "",
"table_name": "payment",
"data_type": "DATETIME",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MIN",
" MAX",
" AVG",
" COUNT"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [
"CURRENT_YEAR",
"CURRENT_MONTH",
"CURRENT_WEEK",
"CURRENT_DAY",
"NOW",
"LAST_90_DAYS",
"LAST_60_DAYS",
"LAST_45_DAYS",
"LAST_30_DAYS",
"LAST_15_DAYS",
"LAST_7_DAYS",
"LAST_DAY"
],
"wraps": [
"YEAR",
"QUARTER",
"MONTH",
"DATE",
"WEEK_OF_YEAR",
"DAY_OF_MONTH",
"DAY_OF_WEEK",
"DAY_OF_YEAR",
"AGE_IN_YEARS",
"AGE_IN_DAYS",
"AGE_IN_HOURS",
"AGE_IN_MINUTES"
]
},
{
"id": 4,
"alias": "Charge Back Details",
"name": "charge_back_details",
"description": "",
"table_name": "payment",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 5,
"alias": "Confirmation Date",
"name": "confirmation_date",
"description": "",
"table_name": "payment",
"data_type": "DATETIME",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MIN",
" MAX",
" AVG",
" COUNT"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [
"CURRENT_YEAR",
"CURRENT_MONTH",
"CURRENT_WEEK",
"CURRENT_DAY",
"NOW",
"LAST_90_DAYS",
"LAST_60_DAYS",
"LAST_45_DAYS",
"LAST_30_DAYS",
"LAST_15_DAYS",
"LAST_7_DAYS",
"LAST_DAY"
],
"wraps": [
"YEAR",
"QUARTER",
"MONTH",
"DATE",
"WEEK_OF_YEAR",
"DAY_OF_MONTH",
"DAY_OF_WEEK",
"DAY_OF_YEAR",
"AGE_IN_YEARS",
"AGE_IN_DAYS",
"AGE_IN_HOURS",
"AGE_IN_MINUTES"
]
},
{
"id": 25,
"alias": "Contract Id",
"name": "contract_id",
"description": "",
"table_name": "payment",
"data_type": "TEXT",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 36,
"alias": "Converted Rate",
"name": "converted_rate",
"description": "",
"table_name": "payment",
"data_type": "DECIMAL",
"size": 0,
"arithmetic_operators": [
"+",
" -",
" *",
" /",
" %"
],
"aggregation_operators": [
"SUM",
" COUNT",
" AVG",
" MAX",
" MIN",
" STDDEV"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"ABS",
"CEIL",
"FLOOR",
"ROUND2",
"ROUND3",
"ROUND4"
]
},
{
"id": 30,
"alias": "Country IP",
"name": "country_ip",
"description": "",
"table_name": "payment",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 6,
"alias": "Created At",
"name": "created_at",
"description": "",
"table_name": "payment",
"data_type": "DATETIME",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MIN",
" MAX",
" AVG",
" COUNT"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [
"CURRENT_YEAR",
"CURRENT_MONTH",
"CURRENT_WEEK",
"CURRENT_DAY",
"NOW",
"LAST_90_DAYS",
"LAST_60_DAYS",
"LAST_45_DAYS",
"LAST_30_DAYS",
"LAST_15_DAYS",
"LAST_7_DAYS",
"LAST_DAY"
],
"wraps": [
"YEAR",
"QUARTER",
"MONTH",
"DATE",
"WEEK_OF_YEAR",
"DAY_OF_MONTH",
"DAY_OF_WEEK",
"DAY_OF_YEAR",
"AGE_IN_YEARS",
"AGE_IN_DAYS",
"AGE_IN_HOURS",
"AGE_IN_MINUTES"
]
},
{
"id": 7,
"alias": "Customer Amount",
"name": "customer_amount",
"description": "",
"table_name": "payment",
"data_type": "DECIMAL",
"size": 0,
"arithmetic_operators": [
"+",
" -",
" *",
" /",
" %"
],
"aggregation_operators": [
"SUM",
" COUNT",
" AVG",
" MAX",
" MIN",
" STDDEV"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"ABS",
"CEIL",
"FLOOR",
"ROUND2",
"ROUND3",
"ROUND4"
]
},
{
"id": 8,
"alias": "Customer Fee Total",
"name": "customer_fee_total",
"description": "",
"table_name": "payment",
"data_type": "DECIMAL",
"size": 0,
"arithmetic_operators": [
"+",
" -",
" *",
" /",
" %"
],
"aggregation_operators": [
"SUM",
" COUNT",
" AVG",
" MAX",
" MIN",
" STDDEV"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"ABS",
"CEIL",
"FLOOR",
"ROUND2",
"ROUND3",
"ROUND4"
]
},
{
"id": 44,
"alias": "Delay Capture",
"name": "delay_capture",
"description": "",
"table_name": "payment",
"data_type": "BOOLEAN",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" ="
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 9,
"alias": "Details",
"name": "details",
"description": "",
"table_name": "payment",
"data_type": "TEXT",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 31,
"alias": "Discounted Amount",
"name": "discounted_amount",
"description": "",
"table_name": "payment",
"data_type": "DECIMAL",
"size": 0,
"arithmetic_operators": [
"+",
" -",
" *",
" /",
" %"
],
"aggregation_operators": [
"SUM",
" COUNT",
" AVG",
" MAX",
" MIN",
" STDDEV"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"ABS",
"CEIL",
"FLOOR",
"ROUND2",
"ROUND3",
"ROUND4"
]
},
{
"id": 10,
"alias": "Error Code",
"name": "error_code",
"description": "",
"table_name": "payment",
"data_type": "TEXT",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 11,
"alias": "Gateway Id",
"name": "gateway_id",
"description": "",
"table_name": "payment",
"data_type": "TEXT",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 12,
"alias": "Gateway Order Id",
"name": "gateway_order_id",
"description": "",
"table_name": "payment",
"data_type": "TEXT",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 29,
"alias": "IP Address",
"name": "ip_addr_from",
"description": "",
"table_name": "payment",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 13,
"alias": "Installments",
"name": "installments",
"description": "",
"table_name": "payment",
"data_type": "INT",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MAX",
" MIN",
" COUNT"
],
"filters_operators": [
"!=",
" =",
" >=",
" <=",
" >",
" <"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 14,
"alias": "Merchant Amount",
"name": "merchant_amount",
"description": "",
"table_name": "payment",
"data_type": "DECIMAL",
"size": 0,
"arithmetic_operators": [
"+",
" -",
" *",
" /",
" %"
],
"aggregation_operators": [
"SUM",
" COUNT",
" AVG",
" MAX",
" MIN",
" STDDEV"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"ABS",
"CEIL",
"FLOOR",
"ROUND2",
"ROUND3",
"ROUND4"
]
},
{
"id": 15,
"alias": "Merchant Fee Total",
"name": "merchant_fee_total",
"description": "",
"table_name": "payment",
"data_type": "DECIMAL",
"size": 0,
"arithmetic_operators": [
"+",
" -",
" *",
" /",
" %"
],
"aggregation_operators": [
"SUM",
" COUNT",
" AVG",
" MAX",
" MIN",
" STDDEV"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"ABS",
"CEIL",
"FLOOR",
"ROUND2",
"ROUND3",
"ROUND4"
]
},
{
"id": 26,
"alias": "Merchant Id",
"name": "merchant_from_id",
"description": "",
"table_name": "payment",
"data_type": "TEXT",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 43,
"alias": "Merchant Signature Id",
"name": "merchant_signature_id",
"description": "",
"table_name": "payment",
"data_type": "INT",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MAX",
" MIN",
" COUNT"
],
"filters_operators": [
"!=",
" =",
" >=",
" <=",
" >",
" <"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 16,
"alias": "Method",
"name": "method",
"description": "",
"table_name": "payment",
"data_type": "TEXT",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 17,
"alias": "Msg Gateway",
"name": "msg_gateway",
"description": "",
"table_name": "payment",
"data_type": "TEXT",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 39,
"alias": "Notification URL",
"name": "notification_url",
"description": "",
"table_name": "payment",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 34,
"alias": "Original Amount",
"name": "original_amount",
"description": "",
"table_name": "payment",
"data_type": "DECIMAL",
"size": 0,
"arithmetic_operators": [
"+",
" -",
" *",
" /",
" %"
],
"aggregation_operators": [
"SUM",
" COUNT",
" AVG",
" MAX",
" MIN",
" STDDEV"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"ABS",
"CEIL",
"FLOOR",
"ROUND2",
"ROUND3",
"ROUND4"
]
},
{
"id": 35,
"alias": "Original Currency",
"name": "original_asset_currency_code",
"description": "",
"table_name": "payment",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 38,
"alias": "Payment Code Info",
"name": "payment_code_info",
"description": "",
"table_name": "payment",
"data_type": "VARCHAR",
"size": 1024,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 53,
"alias": "Payment Country",
"name": "payment_country",
"description": "",
"table_name": "payment",
"data_type": "VARCHAR",
"size": 2,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 40,
"alias": "Payment Date Boleto",
"name": "payment_date_boleto_info",
"description": "",
"table_name": "payment",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 1,
"alias": "Payment Id",
"name": "id",
"description": "",
"table_name": "payment",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 32,
"alias": "Payment Info",
"name": "payment_info",
"description": "",
"table_name": "payment",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 18,
"alias": "Payment Status Gateway",
"name": "payment_status_gateway",
"description": "",
"table_name": "payment",
"data_type": "TEXT",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 41,
"alias": "Payment Value Boleto",
"name": "payment_value_boleto_info",
"description": "",
"table_name": "payment",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 37,
"alias": "Payout Id",
"name": "payoutid",
"description": "",
"table_name": "payment",
"data_type": "INT",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MAX",
" MIN",
" COUNT"
],
"filters_operators": [
"!=",
" =",
" >=",
" <=",
" >",
" <"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 19,
"alias": "Payout Status",
"name": "payout_status",
"description": "",
"table_name": "payment",
"data_type": "TEXT",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 27,
"alias": "Person Id",
"name": "person_id",
"description": "",
"table_name": "payment",
"data_type": "INT",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MAX",
" MIN",
" COUNT"
],
"filters_operators": [
"!=",
" =",
" >=",
" <=",
" >",
" <"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 28,
"alias": "Quotation Id",
"name": "quotation_id",
"description": "",
"table_name": "payment",
"data_type": "INT",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MAX",
" MIN",
" COUNT"
],
"filters_operators": [
"!=",
" =",
" >=",
" <=",
" >",
" <"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 48,
"alias": "Received Amount",
"name": "received_amount",
"description": "",
"table_name": "payment",
"data_type": "DECIMAL",
"size": 0,
"arithmetic_operators": [
"+",
" -",
" *",
" /",
" %"
],
"aggregation_operators": [
"SUM",
" COUNT",
" AVG",
" MAX",
" MIN",
" STDDEV"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"ABS",
"CEIL",
"FLOOR",
"ROUND2",
"ROUND3",
"ROUND4"
]
},
{
"id": 20,
"alias": "Reference",
"name": "reference",
"description": "",
"table_name": "payment",
"data_type": "TEXT",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 46,
"alias": "Risk Analysis External Transaction Id",
"name": "risk_analysis_external_transaction_id",
"description": "",
"table_name": "payment",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 45,
"alias": "Risk Analysis Id",
"name": "risk_analysis_id",
"description": "",
"table_name": "payment",
"data_type": "INT",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MAX",
" MIN",
" COUNT"
],
"filters_operators": [
"!=",
" =",
" >=",
" <=",
" >",
" <"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 42,
"alias": "Score",
"name": "score",
"description": "",
"table_name": "payment",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 52,
"alias": "Settlement Status",
"name": "settlement_status",
"description": "",
"table_name": "payment",
"data_type": "VARCHAR",
"size": 45,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 47,
"alias": "Soft Descriptor",
"name": "soft_descriptor",
"description": "",
"table_name": "payment",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 21,
"alias": "Status",
"name": "status",
"description": "",
"table_name": "payment",
"data_type": "TEXT",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 22,
"alias": "Status Date",
"name": "status_date",
"description": "",
"table_name": "payment",
"data_type": "DATETIME",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MIN",
" MAX",
" AVG",
" COUNT"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [
"CURRENT_YEAR",
"CURRENT_MONTH",
"CURRENT_WEEK",
"CURRENT_DAY",
"NOW",
"LAST_90_DAYS",
"LAST_60_DAYS",
"LAST_45_DAYS",
"LAST_30_DAYS",
"LAST_15_DAYS",
"LAST_7_DAYS",
"LAST_DAY"
],
"wraps": [
"YEAR",
"QUARTER",
"MONTH",
"DATE",
"WEEK_OF_YEAR",
"DAY_OF_MONTH",
"DAY_OF_WEEK",
"DAY_OF_YEAR",
"AGE_IN_YEARS",
"AGE_IN_DAYS",
"AGE_IN_HOURS",
"AGE_IN_MINUTES"
]
},
{
"id": 51,
"alias": "Sub Statement Id",
"name": "sub_statement_id",
"description": "",
"table_name": "payment",
"data_type": "INT",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MAX",
" MIN",
" COUNT"
],
"filters_operators": [
"!=",
" =",
" >=",
" <=",
" >",
" <"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 54,
"alias": "Transaction Status",
"name": "transaction_status",
"description": "",
"table_name": "payment",
"data_type": "VARCHAR",
"size": 100,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [
"CREATED ",
"DISPUTE ",
"DISPUTE_FINAL ",
"PARTIALLY_REFUNDED ",
"PAID ",
"REFUNDED ",
"ERROR ",
"PROCESSING ",
"DECLINED ",
"CANCELED ",
"PRE_AUTHORIZED ",
"DISPUTE_REFUNDED"
],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 23,
"alias": "Type",
"name": "type",
"description": "",
"table_name": "payment",
"data_type": "TEXT",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
}
]
},
{
"tableName": "Rate",
"fields": [
{
"id": 102,
"alias": "Amount",
"name": "amount",
"description": "",
"table_name": "rate",
"data_type": "DECIMAL",
"size": 0,
"arithmetic_operators": [
"+",
" -",
" *",
" /",
" %"
],
"aggregation_operators": [
"SUM",
" COUNT",
" AVG",
" MAX",
" MIN",
" STDDEV"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"ABS",
"CEIL",
"FLOOR",
"ROUND2",
"ROUND3",
"ROUND4"
]
},
{
"id": 105,
"alias": "Base Asset Currency Code",
"name": "base_asset_currency_code",
"description": "",
"table_name": "rate",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 106,
"alias": "Counter Asset Currency Code",
"name": "counter_asset_currency_code",
"description": "",
"table_name": "rate",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 103,
"alias": "Created At",
"name": "created_at",
"description": "",
"table_name": "rate",
"data_type": "DATETIME",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MIN",
" MAX",
" AVG",
" COUNT"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [
"CURRENT_YEAR",
"CURRENT_MONTH",
"CURRENT_WEEK",
"CURRENT_DAY",
"NOW",
"LAST_90_DAYS",
"LAST_60_DAYS",
"LAST_45_DAYS",
"LAST_30_DAYS",
"LAST_15_DAYS",
"LAST_7_DAYS",
"LAST_DAY"
],
"wraps": [
"YEAR",
"QUARTER",
"MONTH",
"DATE",
"WEEK_OF_YEAR",
"DAY_OF_MONTH",
"DAY_OF_WEEK",
"DAY_OF_YEAR",
"AGE_IN_YEARS",
"AGE_IN_DAYS",
"AGE_IN_HOURS",
"AGE_IN_MINUTES"
]
},
{
"id": 104,
"alias": "Quote Date",
"name": "quote_date",
"description": "",
"table_name": "rate",
"data_type": "DATETIME",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MIN",
" MAX",
" AVG",
" COUNT"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [
"CURRENT_YEAR",
"CURRENT_MONTH",
"CURRENT_WEEK",
"CURRENT_DAY",
"NOW",
"LAST_90_DAYS",
"LAST_60_DAYS",
"LAST_45_DAYS",
"LAST_30_DAYS",
"LAST_15_DAYS",
"LAST_7_DAYS",
"LAST_DAY"
],
"wraps": [
"YEAR",
"QUARTER",
"MONTH",
"DATE",
"WEEK_OF_YEAR",
"DAY_OF_MONTH",
"DAY_OF_WEEK",
"DAY_OF_YEAR",
"AGE_IN_YEARS",
"AGE_IN_DAYS",
"AGE_IN_HOURS",
"AGE_IN_MINUTES"
]
},
{
"id": 101,
"alias": "Rate Id",
"name": "id",
"description": "",
"table_name": "rate",
"data_type": "INT",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MAX",
" MIN",
" COUNT"
],
"filters_operators": [
"!=",
" =",
" >=",
" <=",
" >",
" <"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 107,
"alias": "Type",
"name": "type",
"description": "",
"table_name": "rate",
"data_type": "INT",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MAX",
" MIN",
" COUNT"
],
"filters_operators": [
"!=",
" =",
" >=",
" <=",
" >",
" <"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
}
]
},
{
"tableName": "Dispute",
"fields": [
{
"id": 236,
"alias": "Amount",
"name": "amount",
"description": "",
"table_name": "dispute",
"data_type": "DECIMAL",
"size": 0,
"arithmetic_operators": [
"+",
" -",
" *",
" /",
" %"
],
"aggregation_operators": [
"SUM",
" COUNT",
" AVG",
" MAX",
" MIN",
" STDDEV"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"ABS",
"CEIL",
"FLOOR",
"ROUND2",
"ROUND3",
"ROUND4"
]
},
{
"id": 238,
"alias": "Availability Date",
"name": "availability_date",
"description": "",
"table_name": "dispute",
"data_type": "DATE",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MIN",
" MAX",
" AVG",
" COUNT"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [
"CURRENT_YEAR",
"CURRENT_MONTH",
"CURRENT_WEEK",
"CURRENT_DAY",
"NOW",
"LAST_90_DAYS",
"LAST_60_DAYS",
"LAST_45_DAYS",
"LAST_30_DAYS",
"LAST_15_DAYS",
"LAST_7_DAYS",
"LAST_DAY"
],
"wraps": [
"YEAR",
"QUARTER",
"MONTH",
"DATE",
"WEEK_OF_YEAR",
"DAY_OF_MONTH",
"DAY_OF_WEEK",
"DAY_OF_YEAR",
"HOUR",
"MINUTE",
"AGE_IN_YEARS",
"AGE_IN_DAYS"
]
},
{
"id": 233,
"alias": "Created At",
"name": "created_at",
"description": "",
"table_name": "dispute",
"data_type": "DATETIME",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MIN",
" MAX",
" AVG",
" COUNT"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [
"CURRENT_YEAR",
"CURRENT_MONTH",
"CURRENT_WEEK",
"CURRENT_DAY",
"NOW",
"LAST_90_DAYS",
"LAST_60_DAYS",
"LAST_45_DAYS",
"LAST_30_DAYS",
"LAST_15_DAYS",
"LAST_7_DAYS",
"LAST_DAY"
],
"wraps": [
"YEAR",
"QUARTER",
"MONTH",
"DATE",
"WEEK_OF_YEAR",
"DAY_OF_MONTH",
"DAY_OF_WEEK",
"DAY_OF_YEAR",
"AGE_IN_YEARS",
"AGE_IN_DAYS",
"AGE_IN_HOURS",
"AGE_IN_MINUTES"
]
},
{
"id": 231,
"alias": "Dispute Date",
"name": "dispute_date",
"description": "",
"table_name": "dispute",
"data_type": "DATETIME",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MIN",
" MAX",
" AVG",
" COUNT"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [
"CURRENT_YEAR",
"CURRENT_MONTH",
"CURRENT_WEEK",
"CURRENT_DAY",
"NOW",
"LAST_90_DAYS",
"LAST_60_DAYS",
"LAST_45_DAYS",
"LAST_30_DAYS",
"LAST_15_DAYS",
"LAST_7_DAYS",
"LAST_DAY"
],
"wraps": [
"YEAR",
"QUARTER",
"MONTH",
"DATE",
"WEEK_OF_YEAR",
"DAY_OF_MONTH",
"DAY_OF_WEEK",
"DAY_OF_YEAR",
"AGE_IN_YEARS",
"AGE_IN_DAYS",
"AGE_IN_HOURS",
"AGE_IN_MINUTES"
]
},
{
"id": 229,
"alias": "Dispute Id",
"name": "id",
"description": "",
"table_name": "dispute",
"data_type": "VARCHAR",
"size": 40,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 232,
"alias": "Expiration Date",
"name": "expiration_date",
"description": "",
"table_name": "dispute",
"data_type": "DATETIME",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MIN",
" MAX",
" AVG",
" COUNT"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [
"CURRENT_YEAR",
"CURRENT_MONTH",
"CURRENT_WEEK",
"CURRENT_DAY",
"NOW",
"LAST_90_DAYS",
"LAST_60_DAYS",
"LAST_45_DAYS",
"LAST_30_DAYS",
"LAST_15_DAYS",
"LAST_7_DAYS",
"LAST_DAY"
],
"wraps": [
"YEAR",
"QUARTER",
"MONTH",
"DATE",
"WEEK_OF_YEAR",
"DAY_OF_MONTH",
"DAY_OF_WEEK",
"DAY_OF_YEAR",
"AGE_IN_YEARS",
"AGE_IN_DAYS",
"AGE_IN_HOURS",
"AGE_IN_MINUTES"
]
},
{
"id": 237,
"alias": "Merchant Amount",
"name": "merchant_amount",
"description": "",
"table_name": "dispute",
"data_type": "DECIMAL",
"size": 0,
"arithmetic_operators": [
"+",
" -",
" *",
" /",
" %"
],
"aggregation_operators": [
"SUM",
" COUNT",
" AVG",
" MAX",
" MIN",
" STDDEV"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"ABS",
"CEIL",
"FLOOR",
"ROUND2",
"ROUND3",
"ROUND4"
]
},
{
"id": 230,
"alias": "Payment Id",
"name": "payment_id",
"description": "",
"table_name": "dispute",
"data_type": "VARCHAR",
"size": 40,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 235,
"alias": "Reason",
"name": "reason",
"description": "",
"table_name": "dispute",
"data_type": "VARCHAR",
"size": 1024,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 239,
"alias": "Settlement Status",
"name": "settlement_status",
"description": "",
"table_name": "dispute",
"data_type": "VARCHAR",
"size": 20,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 234,
"alias": "Status",
"name": "status",
"description": "",
"table_name": "dispute",
"data_type": "VARCHAR",
"size": 30,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 240,
"alias": "Sub Statement Id",
"name": "sub_statement_id",
"description": "",
"table_name": "dispute",
"data_type": "INT",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MAX",
" MIN",
" COUNT"
],
"filters_operators": [
"!=",
" =",
" >=",
" <=",
" >",
" <"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
}
]
},
{
"tableName": "Person",
"fields": [
{
"id": 56,
"alias": "Additional Address",
"name": "additional_address",
"description": "",
"table_name": "person",
"data_type": "INT",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MAX",
" MIN",
" COUNT"
],
"filters_operators": [
"!=",
" =",
" >=",
" <=",
" >",
" <"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 57,
"alias": "Birth",
"name": "birth",
"description": "",
"table_name": "person",
"data_type": "DATE",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MIN",
" MAX",
" AVG",
" COUNT"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [
"CURRENT_YEAR",
"CURRENT_MONTH",
"CURRENT_WEEK",
"CURRENT_DAY",
"NOW",
"LAST_90_DAYS",
"LAST_60_DAYS",
"LAST_45_DAYS",
"LAST_30_DAYS",
"LAST_15_DAYS",
"LAST_7_DAYS",
"LAST_DAY"
],
"wraps": [
"YEAR",
"QUARTER",
"MONTH",
"DATE",
"WEEK_OF_YEAR",
"DAY_OF_MONTH",
"DAY_OF_WEEK",
"DAY_OF_YEAR",
"HOUR",
"MINUTE",
"AGE_IN_YEARS",
"AGE_IN_DAYS"
]
},
{
"id": 58,
"alias": "City Address",
"name": "city_address",
"description": "",
"table_name": "person",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 59,
"alias": "Country Address",
"name": "country_address",
"description": "",
"table_name": "person",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 60,
"alias": "Created At",
"name": "created_at",
"description": "",
"table_name": "person",
"data_type": "DATETIME",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MIN",
" MAX",
" AVG",
" COUNT"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [
"CURRENT_YEAR",
"CURRENT_MONTH",
"CURRENT_WEEK",
"CURRENT_DAY",
"NOW",
"LAST_90_DAYS",
"LAST_60_DAYS",
"LAST_45_DAYS",
"LAST_30_DAYS",
"LAST_15_DAYS",
"LAST_7_DAYS",
"LAST_DAY"
],
"wraps": [
"YEAR",
"QUARTER",
"MONTH",
"DATE",
"WEEK_OF_YEAR",
"DAY_OF_MONTH",
"DAY_OF_WEEK",
"DAY_OF_YEAR",
"AGE_IN_YEARS",
"AGE_IN_DAYS",
"AGE_IN_HOURS",
"AGE_IN_MINUTES"
]
},
{
"id": 61,
"alias": "Email",
"name": "email",
"description": "",
"table_name": "person",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 62,
"alias": "Execute Payments",
"name": "execute_payments",
"description": "",
"table_name": "person",
"data_type": "BOOLEAN",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" ="
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 63,
"alias": "Fathers Name",
"name": "fathers_name",
"description": "",
"table_name": "person",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 64,
"alias": "Gateway Id",
"name": "gateway_id",
"description": "",
"table_name": "person",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 65,
"alias": "Locality Address",
"name": "locality_address",
"description": "",
"table_name": "person",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 66,
"alias": "Main Address",
"name": "main_address",
"description": "",
"table_name": "person",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 67,
"alias": "Mothers Name",
"name": "mothers_name",
"description": "",
"table_name": "person",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 68,
"alias": "Name",
"name": "name",
"description": "",
"table_name": "person",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 69,
"alias": "Number Address",
"name": "number_address",
"description": "",
"table_name": "person",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 70,
"alias": "Pep",
"name": "pep",
"description": "",
"table_name": "person",
"data_type": "BOOLEAN",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" ="
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 71,
"alias": "Percent Of Company",
"name": "percent_of_company",
"description": "",
"table_name": "person",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 55,
"alias": "Person Id",
"name": "id",
"description": "",
"table_name": "person",
"data_type": "INT",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MAX",
" MIN",
" COUNT"
],
"filters_operators": [
"!=",
" =",
" >=",
" <=",
" >",
" <"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 78,
"alias": "Public Person Id",
"name": "public_person_id",
"description": "",
"table_name": "person",
"data_type": "VARCHAR",
"size": 50,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 77,
"alias": "Score",
"name": "score",
"description": "",
"table_name": "person",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 72,
"alias": "State Address",
"name": "state_address",
"description": "",
"table_name": "person",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 73,
"alias": "Surname",
"name": "surname",
"description": "",
"table_name": "person",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 74,
"alias": "Tax Id",
"name": "tax_id",
"description": "",
"table_name": "person",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 80,
"alias": "Telephone Area",
"name": "telephone_area",
"description": "",
"table_name": "person",
"data_type": "VARCHAR",
"size": 5,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 79,
"alias": "Telephone Country",
"name": "telephone_country",
"description": "",
"table_name": "person",
"data_type": "VARCHAR",
"size": 5,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 75,
"alias": "Telephone Number",
"name": "telephone_number",
"description": "",
"table_name": "person",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 81,
"alias": "Verified Name",
"name": "verified_name",
"description": "",
"table_name": "person",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 76,
"alias": "Zip Code",
"name": "zip_code",
"description": "",
"table_name": "person",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" =",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
}
]
},
{
"tableName": "Risk Analysis",
"fields": [
{
"id": 150,
"alias": "Advice",
"name": "advice",
"description": "",
"table_name": "risk_analysis",
"data_type": "VARCHAR",
"size": 45,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 149,
"alias": "Channel",
"name": "channel",
"description": "",
"table_name": "risk_analysis",
"data_type": "VARCHAR",
"size": 45,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 152,
"alias": "Data",
"name": "data",
"description": "",
"table_name": "risk_analysis",
"data_type": "VARCHAR",
"size": 1024,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 153,
"alias": "Error Code",
"name": "error_code",
"description": "",
"table_name": "risk_analysis",
"data_type": "INT",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MAX",
" MIN",
" COUNT"
],
"filters_operators": [
"!=",
" =",
" >=",
" <=",
" >",
" <"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 154,
"alias": "Error Message",
"name": "error_message",
"description": "",
"table_name": "risk_analysis",
"data_type": "VARCHAR",
"size": 200,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 148,
"alias": "External Id",
"name": "external_id",
"description": "",
"table_name": "risk_analysis",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 151,
"alias": "Last Check",
"name": "last_check",
"description": "",
"table_name": "risk_analysis",
"data_type": "DATE",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MIN",
" MAX",
" AVG",
" COUNT"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [
"CURRENT_YEAR",
"CURRENT_MONTH",
"CURRENT_WEEK",
"CURRENT_DAY",
"NOW",
"LAST_90_DAYS",
"LAST_60_DAYS",
"LAST_45_DAYS",
"LAST_30_DAYS",
"LAST_15_DAYS",
"LAST_7_DAYS",
"LAST_DAY"
],
"wraps": [
"YEAR",
"QUARTER",
"MONTH",
"DATE",
"WEEK_OF_YEAR",
"DAY_OF_MONTH",
"DAY_OF_WEEK",
"DAY_OF_YEAR",
"HOUR",
"MINUTE",
"AGE_IN_YEARS",
"AGE_IN_DAYS"
]
},
{
"id": 147,
"alias": "Risk Analysis Id",
"name": "id",
"description": "",
"table_name": "risk_analysis",
"data_type": "INT",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MAX",
" MIN",
" COUNT"
],
"filters_operators": [
"!=",
" =",
" >=",
" <=",
" >",
" <"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
}
]
},
{
"tableName": "Asset",
"fields": [
{
"id": 205,
"alias": "Active",
"name": "active",
"description": "",
"table_name": "asset",
"data_type": "BOOLEAN",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"!=",
" ="
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 206,
"alias": "Created At",
"name": "created_at",
"description": "",
"table_name": "asset",
"data_type": "DATETIME",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MIN",
" MAX",
" AVG",
" COUNT"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [
"CURRENT_YEAR",
"CURRENT_MONTH",
"CURRENT_WEEK",
"CURRENT_DAY",
"NOW",
"LAST_90_DAYS",
"LAST_60_DAYS",
"LAST_45_DAYS",
"LAST_30_DAYS",
"LAST_15_DAYS",
"LAST_7_DAYS",
"LAST_DAY"
],
"wraps": [
"YEAR",
"QUARTER",
"MONTH",
"DATE",
"WEEK_OF_YEAR",
"DAY_OF_MONTH",
"DAY_OF_WEEK",
"DAY_OF_YEAR",
"AGE_IN_YEARS",
"AGE_IN_DAYS",
"AGE_IN_HOURS",
"AGE_IN_MINUTES"
]
},
{
"id": 204,
"alias": "Currency Code",
"name": "currency_code",
"description": "",
"table_name": "asset",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 207,
"alias": "Description",
"name": "description",
"description": "",
"table_name": "asset",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
}
]
},
{
"tableName": "Refund",
"fields": [
{
"id": 222,
"alias": "Availability Date",
"name": "availability_date",
"description": "",
"table_name": "refund",
"data_type": "DATE",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MIN",
" MAX",
" AVG",
" COUNT"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [
"CURRENT_YEAR",
"CURRENT_MONTH",
"CURRENT_WEEK",
"CURRENT_DAY",
"NOW",
"LAST_90_DAYS",
"LAST_60_DAYS",
"LAST_45_DAYS",
"LAST_30_DAYS",
"LAST_15_DAYS",
"LAST_7_DAYS",
"LAST_DAY"
],
"wraps": [
"YEAR",
"QUARTER",
"MONTH",
"DATE",
"WEEK_OF_YEAR",
"DAY_OF_MONTH",
"DAY_OF_WEEK",
"DAY_OF_YEAR",
"HOUR",
"MINUTE",
"AGE_IN_YEARS",
"AGE_IN_DAYS"
]
},
{
"id": 214,
"alias": "Created At",
"name": "created_at",
"description": "",
"table_name": "refund",
"data_type": "DATETIME",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MIN",
" MAX",
" AVG",
" COUNT"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [
"CURRENT_YEAR",
"CURRENT_MONTH",
"CURRENT_WEEK",
"CURRENT_DAY",
"NOW",
"LAST_90_DAYS",
"LAST_60_DAYS",
"LAST_45_DAYS",
"LAST_30_DAYS",
"LAST_15_DAYS",
"LAST_7_DAYS",
"LAST_DAY"
],
"wraps": [
"YEAR",
"QUARTER",
"MONTH",
"DATE",
"WEEK_OF_YEAR",
"DAY_OF_MONTH",
"DAY_OF_WEEK",
"DAY_OF_YEAR",
"AGE_IN_YEARS",
"AGE_IN_DAYS",
"AGE_IN_HOURS",
"AGE_IN_MINUTES"
]
},
{
"id": 225,
"alias": "Gateway Id",
"name": "gateway_id",
"description": "",
"table_name": "refund",
"data_type": "VARCHAR",
"size": 5,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 215,
"alias": "Last Status At",
"name": "last_status_at",
"description": "",
"table_name": "refund",
"data_type": "DATETIME",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MIN",
" MAX",
" AVG",
" COUNT"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [
"CURRENT_YEAR",
"CURRENT_MONTH",
"CURRENT_WEEK",
"CURRENT_DAY",
"NOW",
"LAST_90_DAYS",
"LAST_60_DAYS",
"LAST_45_DAYS",
"LAST_30_DAYS",
"LAST_15_DAYS",
"LAST_7_DAYS",
"LAST_DAY"
],
"wraps": [
"YEAR",
"QUARTER",
"MONTH",
"DATE",
"WEEK_OF_YEAR",
"DAY_OF_MONTH",
"DAY_OF_WEEK",
"DAY_OF_YEAR",
"AGE_IN_YEARS",
"AGE_IN_DAYS",
"AGE_IN_HOURS",
"AGE_IN_MINUTES"
]
},
{
"id": 227,
"alias": "Merchant Amount",
"name": "merchant_amount",
"description": "",
"table_name": "refund",
"data_type": "DECIMAL",
"size": 0,
"arithmetic_operators": [
"+",
" -",
" *",
" /",
" %"
],
"aggregation_operators": [
"SUM",
" COUNT",
" AVG",
" MAX",
" MIN",
" STDDEV"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"ABS",
"CEIL",
"FLOOR",
"ROUND2",
"ROUND3",
"ROUND4"
]
},
{
"id": 224,
"alias": "Notification Url",
"name": "notification_url",
"description": "",
"table_name": "refund",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 219,
"alias": "Order Amount",
"name": "order_amount",
"description": "",
"table_name": "refund",
"data_type": "DECIMAL",
"size": 0,
"arithmetic_operators": [
"+",
" -",
" *",
" /",
" %"
],
"aggregation_operators": [
"SUM",
" COUNT",
" AVG",
" MAX",
" MIN",
" STDDEV"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"ABS",
"CEIL",
"FLOOR",
"ROUND2",
"ROUND3",
"ROUND4"
]
},
{
"id": 220,
"alias": "Order Currency",
"name": "order_currency",
"description": "",
"table_name": "refund",
"data_type": "VARCHAR",
"size": 5,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 218,
"alias": "Payment Id",
"name": "payment_id",
"description": "",
"table_name": "refund",
"data_type": "VARCHAR",
"size": 50,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 228,
"alias": "Rate Id",
"name": "rate_id",
"description": "",
"table_name": "refund",
"data_type": "INT",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MAX",
" MIN",
" COUNT"
],
"filters_operators": [
"!=",
" =",
" >=",
" <=",
" >",
" <"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 217,
"alias": "Refund Amount",
"name": "refund_amount",
"description": "",
"table_name": "refund",
"data_type": "DECIMAL",
"size": 0,
"arithmetic_operators": [
"+",
" -",
" *",
" /",
" %"
],
"aggregation_operators": [
"SUM",
" COUNT",
" AVG",
" MAX",
" MIN",
" STDDEV"
],
"filters_operators": [
"=",
" !=",
" >",
" <",
" >=",
" <="
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"ABS",
"CEIL",
"FLOOR",
"ROUND2",
"ROUND3",
"ROUND4"
]
},
{
"id": 221,
"alias": "Refund Currency",
"name": "refund_currency",
"description": "",
"table_name": "refund",
"data_type": "VARCHAR",
"size": 5,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 213,
"alias": "Refund Id",
"name": "id",
"description": "",
"table_name": "refund",
"data_type": "INT",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MAX",
" MIN",
" COUNT"
],
"filters_operators": [
"!=",
" =",
" >=",
" <=",
" >",
" <"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
},
{
"id": 223,
"alias": "Settlement Status",
"name": "settlement_status",
"description": "",
"table_name": "refund",
"data_type": "VARCHAR",
"size": 15,
"arithmetic_operators": [],
"aggregation_operators": [
"COUNT"
],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 216,
"alias": "Status",
"name": "status",
"description": "",
"table_name": "refund",
"data_type": "VARCHAR",
"size": 255,
"arithmetic_operators": [],
"aggregation_operators": [],
"filters_operators": [
"=",
" !=",
" IN",
" NOT IN",
" LIKE",
" ILIKE"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": [
"UPPER",
"LOWER",
"TRIM",
"LENGTH"
]
},
{
"id": 226,
"alias": "Sub Statement Id",
"name": "sub_statement_id",
"description": "",
"table_name": "refund",
"data_type": "INT",
"size": 0,
"arithmetic_operators": [],
"aggregation_operators": [
"MAX",
" MIN",
" COUNT"
],
"filters_operators": [
"!=",
" =",
" >=",
" <=",
" >",
" <"
],
"allowed_values": [],
"dynamic_filters": [],
"wraps": []
}
]
}
]
Example Request
401 - Unauthorized
curl --location -g 'https://api.letpay.io/myreports/report/fields?reportType=PAYIN' \
--header 'X-Auth-Token: MY_ACCESS_TOKEN' \
Example Response
Header
Content-Type: application/json
Body
{
"message": "Invalid or expired token",
"code": 0,
"details": {}
}
Example Request
400 - Bad Request
curl --location -g 'https://api.letpay.io/myreports/report/fields?reportType=PAYIN' \
--header 'X-Auth-Token: MY_ACCESS_TOKEN' \
Example Response
Header
Content-Type: application/json
Body
{
"message": "Invalid value for ReportType",
"code": 0,
"details": {
"Expect": "[PAYIN, PAYOUT, MERCHANT, FI-CE, PERSON]",
"Found": "PAYIO"
}
}