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) |