RRPproxy Homepage
RRPproxy Homepage

QueryAccountingList

The QueryAccountingList command gives you a detailed overview of all transactions in your account.

Possible Gateways

The command QueryAccountingList is available via the following gateways:

Required Parameters

The following parameters are standard parameters for this command.

Command

COMMAND = QueryAccountingList
MINDATE = (DATE)

Response

code = (INT)
description = (TEXT)
property[ACCOUNTING_DATE][n] = (DATE)
property[ACCOUNTING_TYPE][n] = (TEXT)
property[ACCOUNTING_DESCRIPTION][n] = (TEXT)
property[ACCOUNTING_AMOUNT][n] = (INT)
property[ACCOUNTING_PRICE][n] = (DECIMAL)
property[ACCOUNTING_VAT][n] = (DECIMAL)
property[ACCOUNTING_VAT_PRICE][n] = (DECIMAL)
property[ACCOUNTING_CURRENCY][n] = (TEXT)
property[EXCHANGE_RATE][n] = (DECIMAL)
property[EXCHANGE_CURRENCY][n] = (TEXT)
property[INVOICE_PERIOD][n] = (TEXT)
property[SUBRESELLER][n] = (TEXT)
property[ACCOUNTING_PRICING][n] = (TEXT)
property[OPENING_BALANCE][0] = (DECIMAL)
property[OPENING_BALANCE_PRICE][0] = (DECIMAL)
property[OPENING_BALANCE_VAT_PRICE][0] = (DECIMAL)
property[SUM][0] = (DECIMAL)
property[SUM_PRICE][0] = (DECIMAL)
property[SUM_VAT_PRICE][0] = (DECIMAL)
property[COUNT][0] = (INT)
property[FIRST][0] = (INT)
property[LAST][0] = (INT)
property[LIMIT][0] = (INT)
property[TOTAL][0] = (INT)

Attributes

ACCOUNTING_DATE Date of this transaction
ACCOUNTING_TYPE Type of the transaction
ACCOUNTING_DESCRIPTION Description of the transaction
ACCOUNTING_AMOUNT Amount used for charging this transaction
ACCOUNTING_PRICE Price charged during this transaction
ACCOUNTING_VAT VAT used for this transaction
ACCOUNTING_VAT_PRICE V.A.T. charged during this transaction
ACCOUNTING_CURRENCY Currency used to charge this transaction
EXCHANGE_RATE Exchange rate used to convert the charged currency to your account currency
EXCHANGE_CURRENCY Exchange currency
INVOICE_PERIOD Period valid for this transaction
SUBRESELLER The registrarname of the subresller that caused this accounting
ACCOUNTING_PRICING Shows what pricing was used to calculate the accounting e.g. PREMIUM,PROMO, RAM or STANDARD.
MINDATE Search accountings younger than this date
OPENING_BALANCE Balance of the account at the beginning of this list
OPENING_BALANCE_PRICE Balance of your account at the beginning of the list (excluded V.A.T.)
OPENING_BALANCE_VAT_PRICE V.A.T. balance of your account at the beginning of the list
SUM Sum of all transactions (including V.A.T.) in this list
SUM_PRICE Sum of all transactions in this list (excluding V.A.T.)
SUM_VAT_PRICE V.A.T. sum of all transactions in this list
COUNT Total number of accountings shown
FIRST Pointer to the first shown ID
LAST Pointer to the last shown ID
LIMIT The limit given in the command
TOTAL Total number of existing accountings

Optional

The following parameters are optional for this command.

Command

COMMAND = QueryAccountingList
OBJECT = (TEXT)
MAXDATE = (TEXT)
REGISTRAR = (TEXT)
ORDER = ASC|DESC
ORDERBY = ACCOUNTINGDATE|ACCOUNTINGTYPE|ACCOUNTINGOBJECT
WIDE = 0|1
ACCOUNTINGTYPE = (TEXT)
GENERATELIST = 0|1
SENDLISTEMAIL = (EMAILS)
FIRST = (INT)
LIMIT = (INT)

Response

code = (INT)
description = (TEXT)
property[ACCOUNTING_DATE][n] = (DATE)
property[ACCOUNTING_TYPE][n] = (TEXT)
property[ACCOUNTING_DESCRIPTION][n] = (TEXT)
property[ACCOUNTING_AMOUNT][n] = (INT)
property[ACCOUNTING_PRICE][n] = (DECIMAL)
property[ACCOUNTING_VAT][n] = (DECIMAL)
property[ACCOUNTING_VAT_PRICE][n] = (DECIMAL)
property[ACCOUNTING_CURRENCY][n] = (TEXT)
property[EXCHANGE_RATE][n] = (DECIMAL)
property[EXCHANGE_CURRENCY][n] = (TEXT)
property[INVOICE_PERIOD][n] = (TEXT)
property[SUBRESELLER][n] = (TEXT)
property[ACCOUNTING_PRICING][n] = (TEXT)
property[OPENING_BALANCE][0] = (DECIMAL)
property[OPENING_BALANCE_PRICE][0] = (DECIMAL)
property[OPENING_BALANCE_VAT_PRICE][0] = (DECIMAL)
property[SUM][0] = (DECIMAL)
property[SUM_PRICE][0] = (DECIMAL)
property[SUM_VAT_PRICE][0] = (DECIMAL)
property[COUNT][0] = (INT)
property[FIRST][0] = (INT)
property[LAST][0] = (INT)
property[LIMIT][0] = (INT)
property[TOTAL][0] = (INT)

Attributes

OBJECT Show only accountings for this object (optional)
MAXDATE Search accountings older than this date (optional)
REGISTRAR Show accountings from this registrar (optional)
ORDER Order resulting list in this direction (optional)
ORDERBY Order resulting list by this column (optional)
WIDE Show more or less details (optional)
ACCOUNTINGTYPE Show only accountings for this accountingtype (optional)
GENERATELIST Show result on screen|Generate a CSV File and upload to ftp or send by email (optional)
SENDLISTEMAIL Email address where the CSV will be sent to (optional)
FIRST Start the output of results from this item (optional)
LIMIT Show only this many items in the response (optional)

Wedomains :)