deposit_paid_bills_debt_operations

Creates, updates, deletes, gets or lists a deposit_paid_bills_debt_operations resource.

Overview

Name	deposit_paid_bills_debt_operations
Type	Resource
Id	ovh.me.deposit_paid_bills_debt_operations

Fields

The following fields are returned by SELECT queries:

get

successful operation

Name	Datatype	Description
deposit_order_id	integer	Order id associated to the deposit (wire: depositOrderId)
operation_id	integer	(wire: operationId)
amount	object	Amount of the operation
date	string (date-time)	Date the operation took place on
status	string	Status of the operation (CANCELLED, DONE, FAILED, PAID, PENDING, TODO)
type	string	Type of movement this operation represents (BANK_TRANSFER_MANUAL, CANCEL, CASH_MANUAL, CHECK_MANUAL, CREDITCARD, CREDITCARD_AUTOMATIC, CREDITCARD_MANUAL, CREDIT_ACCOUNT_AUTOMATIC, CREDIT_CARD_AUTOMATIC, CREDIT_CARD_MANUAL, CURRENT_ACCOUNT_AUTOMATIC, CURRENT_ACCOUNT_MANUAL, DOMESTIC_CARD_AUTOMATIC, DOMESTIC_CARD_MANUAL, EDINAR_MANUAL, ENTERPRISE_AUTOMATIC, ENTERPRISE_MANUAL, IDEAL_AUTOMATIC, IDEAL_MANUAL, INTERNAL_TRUSTED_ACCOUNT_AUTOMATIC, INTERNAL_TRUSTED_ACCOUNT_MANUAL, MULTIBANCO_AUTOMATIC, MULTIBANCO_MANUAL, ORDER, PAYPAL_AUTOMATIC, PAYPAL_MANUAL, PAYU_AUTOMATIC, PAYU_MANUAL, RECOVERY_TRANSFER_AUTOMATIC, REFUND, REFUND_CHECK, REFUND_CREDITCARD, REFUND_CREDIT_ACCOUNT, REFUND_CREDIT_CARD, REFUND_CURRENT_ACCOUNT, REFUND_DOMESTIC_CARD, REFUND_ENTERPRISE, REFUND_IDEAL, REFUND_INTERNAL_TRUSTED_ACCOUNT, REFUND_LOSS, REFUND_MULTIBANCO, REFUND_PAYPAL, REFUND_PAYU, REFUND_RUPAY, REFUND_SEPA, REFUND_SEPA_DIRECT_DEBIT, REFUND_TRANSFER, REFUND_UNKNOWN, RUPAY_AUTOMATIC, RUPAY_MANUAL, SEPA_AUTOMATIC, SEPA_DIRECT_DEBIT_AUTOMATIC, SEPA_DIRECT_DEBIT_MANUAL, TRANSFER_MANUAL, UNPAID_CHECK, UNPAID_CREDITCARD, UNPAID_CREDIT_ACCOUNT, UNPAID_CREDIT_CARD, UNPAID_CURRENT_ACCOUNT, UNPAID_DOMESTIC_CARD, UNPAID_ENTERPRISE, UNPAID_IDEAL, UNPAID_INTERNAL_TRUSTED_ACCOUNT, UNPAID_MULTIBANCO, UNPAID_PAYPAL, UNPAID_PAYU, UNPAID_RUPAY, UNPAID_SEPA, UNPAID_SEPA_DIRECT_DEBIT, UNPAID_WITHDRAW, WARRANT_MANUAL, WITHDRAW_AUTOMATIC)

list

Operation that happend on a debt

Name	Datatype	Description
deposit_order_id	integer	Order id associated to the deposit (wire: depositOrderId)
operation_id	integer	(wire: operationId)
amount	object	Amount of the operation
date	string (date-time)	Date the operation took place on
status	string	Status of the operation (CANCELLED, DONE, FAILED, PAID, PENDING, TODO)
type	string	Type of movement this operation represents (BANK_TRANSFER_MANUAL, CANCEL, CASH_MANUAL, CHECK_MANUAL, CREDITCARD, CREDITCARD_AUTOMATIC, CREDITCARD_MANUAL, CREDIT_ACCOUNT_AUTOMATIC, CREDIT_CARD_AUTOMATIC, CREDIT_CARD_MANUAL, CURRENT_ACCOUNT_AUTOMATIC, CURRENT_ACCOUNT_MANUAL, DOMESTIC_CARD_AUTOMATIC, DOMESTIC_CARD_MANUAL, EDINAR_MANUAL, ENTERPRISE_AUTOMATIC, ENTERPRISE_MANUAL, IDEAL_AUTOMATIC, IDEAL_MANUAL, INTERNAL_TRUSTED_ACCOUNT_AUTOMATIC, INTERNAL_TRUSTED_ACCOUNT_MANUAL, MULTIBANCO_AUTOMATIC, MULTIBANCO_MANUAL, ORDER, PAYPAL_AUTOMATIC, PAYPAL_MANUAL, PAYU_AUTOMATIC, PAYU_MANUAL, RECOVERY_TRANSFER_AUTOMATIC, REFUND, REFUND_CHECK, REFUND_CREDITCARD, REFUND_CREDIT_ACCOUNT, REFUND_CREDIT_CARD, REFUND_CURRENT_ACCOUNT, REFUND_DOMESTIC_CARD, REFUND_ENTERPRISE, REFUND_IDEAL, REFUND_INTERNAL_TRUSTED_ACCOUNT, REFUND_LOSS, REFUND_MULTIBANCO, REFUND_PAYPAL, REFUND_PAYU, REFUND_RUPAY, REFUND_SEPA, REFUND_SEPA_DIRECT_DEBIT, REFUND_TRANSFER, REFUND_UNKNOWN, RUPAY_AUTOMATIC, RUPAY_MANUAL, SEPA_AUTOMATIC, SEPA_DIRECT_DEBIT_AUTOMATIC, SEPA_DIRECT_DEBIT_MANUAL, TRANSFER_MANUAL, UNPAID_CHECK, UNPAID_CREDITCARD, UNPAID_CREDIT_ACCOUNT, UNPAID_CREDIT_CARD, UNPAID_CURRENT_ACCOUNT, UNPAID_DOMESTIC_CARD, UNPAID_ENTERPRISE, UNPAID_IDEAL, UNPAID_INTERNAL_TRUSTED_ACCOUNT, UNPAID_MULTIBANCO, UNPAID_PAYPAL, UNPAID_PAYU, UNPAID_RUPAY, UNPAID_SEPA, UNPAID_SEPA_DIRECT_DEBIT, UNPAID_WITHDRAW, WARRANT_MANUAL, WITHDRAW_AUTOMATIC)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	bill_id, deposit_id, operation_id		Get this object properties
list	select	bill_id, deposit_id	deposit_order_id, x_pagination_mode	All operations related to these debts

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
api_host	string	The OVHcloud API host. Selected by OVH_ENDPOINT (ovh-eu, ovh-ca or ovh-us; default ovh-eu). (default: api.eu.ovhcloud.com, x-stackQL-envVarSelector: {"envVar":"OVH_ENDPOINT","default":"ovh-eu","values":{"ovh-eu":"api.eu.ovhcloud.com","ovh-ca":"api.ca.ovhcloud.com","ovh-us":"api.us.ovhcloud.com"}})
bill_id	string	(wire: billId)
deposit_id	string	(wire: depositId)
operation_id	integer	(wire: operationId)
deposit_order_id	integer	Filter the value of depositOrderId property (=) (wire: depositOrderId)
x_pagination_mode	string	Sent as CachedObjectList-Pages by default so the list returns the full objects rather than their identifiers. (wire: X-Pagination-Mode)

SELECT examples

get

Get this object properties

SELECT
deposit_order_id,
operation_id,
amount,
date,
status,
type
FROM ovh.me.deposit_paid_bills_debt_operations
WHERE bill_id = '{{ bill_id }}' -- required
AND deposit_id = '{{ deposit_id }}' -- required
AND operation_id = '{{ operation_id }}' -- required
;

list

All operations related to these debts

SELECT
deposit_order_id,
operation_id,
amount,
date,
status,
type
FROM ovh.me.deposit_paid_bills_debt_operations
WHERE bill_id = '{{ bill_id }}' -- required
AND deposit_id = '{{ deposit_id }}' -- required
AND deposit_order_id = '{{ deposit_order_id }}'
AND x_pagination_mode = '{{ x_pagination_mode }}'
;