pending_selling_amount: This implies differently depending on the type of transaction:

Invoice and Debit Note: This indicates the amount that is still payable (to you) from your Customer from the Selling Amount.

Receipt and Credit Note: This indicates the amount that is still available in the transaction for utilization by your Customer,
from the Selling Amount.

pending_accounting_amount: This implies differently depending on the type of transaction:

Invoice and Debit Note: This indicates the amount in your own Accounting Currency Symbol equivalent of the amount still payable (to you)
by your Customer.

Receipt and Credit Note: This indicates the amount in your own Accounting Currency Symbol equivalent of the amount still available in the
transaction for utilization by your Customer.

description: This is the description given for the transaction.

transaction_date: This is the date when the transaction occurred.

product_transaction_key: This implies differently depending on the type of transaction:

Invoice and Debit Note: This indicates the type of Product this transaction is for.

Example:

If the Product Transaction Key displayed is salesreversal-deletion-domcno, then it indicates that this transaction is for the deletion of a .COM domain name.

If the Product Transaction Key displayed is salesreversal-deletion-hosting, then it indicates that this transaction is for the deletion of a Web Services Order.

Receipt and Credit Note: This will be a unique transaction key used to identify the transaction.

total_receipt_affected: This indicates whether this transaction increased or decreased the Total Receipts of the Customer. The following
are the values that you can expect:

true: This indicates that this transaction affected the Total Receipts figure of the Customer. In case of Invoice and Debit Note transactions, this implies that the
Customer's Total Receipts figure got depleted. While in case of Receipt and Credit Note transactions, this implies that the Customer's Total Receipts figure increased.

false: This indicates that this transaction did not affect the Total Receipts figure of the Customer.

is_greedy: This indicates if the Invoice or Debit Note transaction is Greedy. The following
are the values that you can expect:

true: This indicates that this Invoice or Debit Note transaction is Greedy.

false: This indicates that this Invoice or Debit Note transaction is not Greedy.

pending_selling_amount: This implies differently depending on the type of transaction:

Invoice and Debit Note: This indicates the amount that is still payable (by you) to
from their Selling Amount.

Receipt and Credit Note: This indicates the amount that is still available in the transaction for utilization by you,
from the Selling Amount.

pending_accounting_amount: This implies differently depending on the type of transaction:

Invoice and Debit Note: This indicates the amount in your own Accounting Currency Symbol equivalent of the amount still payable (by you)
to .

Receipt and Credit Note: This indicates the amount in your own Accounting Currency Symbol equivalent of the amount still available in the
transaction for utilization by you.

description: This is the description given for the transaction.

transaction_date: This is the date when the transaction occurred.

product_transaction_key: This implies differently depending on the type of transaction:

Invoice and Debit Note: This indicates the type of Product this transaction is for.

Example:

If the Product Transaction Key displayed is salesreversal-deletion-domcno, then it indicates that this transaction is for the deletion of a .COM domain name.

If the Product Transaction Key displayed is salesreversal-deletion-hosting, then it indicates that this transaction is for the deletion of a Web Services Order.

Receipt and Credit Note: This will be a unique transaction key used to identify the transaction.

total_receipt_affected: This indicates whether this transaction increased or decreased your Total Receipts figure. The following
are the values that you can expect:

true: This indicates that this transaction affected your Total Receipts figure. In case of Invoice and Debit Note transactions, this implies that your Total Receipts
figure got depleted. While in case of Receipt and Credit Note transactions, this implies that your Total Receipts figure increased.

false: This indicates that this transaction did not affect your Total Receipts figure.

is_greedy: This indicates if the Invoice or Debit Note transaction is Greedy. The following
are the values that you can expect:

true: This indicates that this Invoice or Debit Note transaction is Greedy.

false: This indicates that this Invoice or Debit Note transaction is not Greedy.

pending_selling_amount: This implies differently depending on the type of transaction:

Invoice and Debit Note: This indicates the amount that is still payable (to you) from your Sub-Reseller from the Selling Amount.

Receipt and Credit Note: This indicates the amount that is still available in the transaction for utilization by your Sub-Reseller,
from the Selling Amount.

pending_accounting_amount: This implies differently depending on the type of transaction:

Invoice and Debit Note: This indicates the amount in your own Accounting Currency Symbol equivalent of the amount still payable (to you)
by your Sub-Reseller.

Receipt and Credit Note: This indicates the amount in your own Accounting Currency Symbol equivalent of the amount still available in the
transaction for utilization by your Sub-Reseller.

description: This is the description given for the transaction.

transaction_date: This is the date when the transaction occurred.

product_transaction_key: This implies differently depending on the type of transaction:

Invoice and Debit Note: This indicates the type of Product this transaction is for.

Example:

If the Product Transaction Key displayed is salesreversal-deletion-domcno, then it indicates that this transaction is for the deletion of a .COM domain name.

If the Product Transaction Key displayed is salesreversal-deletion-hosting, then it indicates that this transaction is for the deletion of a Web Services Order.

Receipt and Credit Note: This will be a unique transaction key used to identify the transaction.

total_receipt_affected: This indicates whether this transaction increased or decreased the Total Receipts of the Sub-Reseller. The following
are the values that you can expect:

true: This indicates that this transaction affected the Total Receipts figure of the Sub-Reseller. In case of Invoice and Debit Note transactions, this implies that the
Sub-Reseller's Total Receipts figure got depleted. While in case of Receipt and Credit Note transactions, this implies that the Sub-Reseller's Total Receipts figure increased.

false: This indicates that this transaction did not affect the Total Receipts figure of the Sub-Reseller.

is_greedy: This indicates if the Invoice or Debit Note transaction is Greedy. The following
are the values that you can expect:

true: This indicates that this Invoice or Debit Note transaction is Greedy.

false: This indicates that this Invoice or Debit Note transaction is not Greedy.

Selecting this option generates a report of transactions performed against your Customers' / Sub-Resellers' Accounts. The difference between the sum total of all positive entries and the sum total of all negative entries for a Customer / Sub-Reseller reflects the associated Debit Account Balance. The report contains the following fields:

debit_transaction_id: This is the Transaction Id of a debit (Invoice / Debit Note) transaction. For a transaction (of the type forex_diff) involving Foreign Exchange Gain / Loss, it is the Transaction ID of the debit transaction which got balanced against a credit (Receipt / Credit Note) transaction.

credit_transaction_id: This is the Transaction Id of a credit (Receipt / Credit Note) transaction. For a transaction (of the type forex_diff) involving Foreign Exchange Gain / Loss, it is the Transaction ID of the credit transaction which got balanced against a debit (Invoice / Debit Note) transaction.

userid: This is the User Id.

user_company: This is the Company Name specified in the User's profile.

selling_amount: This indicates the transaction amount applicable to the User.

Selecting this option generates a report indicating whether you incurred a Profit or Loss by selling our various Products and Services to your Sub-Resellers and Customers. This Report would be useful to you only if your Selling Currency differs from your Accounting Currency within our system. The report contains the following fields:

debit_transaction_id: This is the Transaction ID of the debit (Invoice / Debit Note) transaction which got balanced against a credit (Receipt / Credit Note) transaction.

credit_transaction_id: This is the Transaction ID of the credit (Receipt / Credit Note) transaction which got balanced against a debit (Invoice / Debit Note) transaction.

userid: This is the User Id.

product_key: This is indicates the type of Product for which the transaction was recorded.

transaction_type: This is the Type of transaction. The following are the values that you can expect:

debit: This indicates that the transaction is a Debit Note.

invoice: This indicates that the transaction is an Invoice.

role: This is Type of user associated with the transaction. The role may either be:

customer

reseller

serviceprovider

user_country: This is the Country specified in the User's profile.

forex_diff: This indicates the foreign exchange gain or loss incurred on the transaction.

transaction_time: This is indicates the timestamp when the transaction was recorded under the System.

Click the From textbox. In the datepicker pop-up, select the date from when you would like the report to be generated from.

Click the To textbox. In the datepicker pop-up, select the date until when you would like the report to be generated for.

In the Email textbox, mention the email address where you would like to have this Report emailed.

Note

Upon delivery of the Report to the abovementioned email address, a notification mail is sent to your Sales email address confirming that the Report has been sent (to that email address). This notice ensures
that your Sales Team is aware of such a Report having been sent to some other email address.

Date Requested: This indicates the date when the report generation was requested by you.

Report Type: This is the type of report you requested.

Time Period: This is the time range you requested this report for.

Emailed To: This indicates the email address you requested to send this report to.

Status: The following are the values that you can expect:

Waiting to be processed: This indicates that the report you requested is queued by the server and will be processed shortly.

Note

Upon submission of your report generation request, the Data Export Task History would immediately display the status as Waiting to be processed.
You may click the Refresh icon besides Data Export Task History in the interface to know if your request has been processed by the server.

Executing: This indicates that the report is being processed by the server.

Completed: This indicates that the report has been emailed to the email address you mentioned.

Execution failed: This indicates that the report generation failed.

Note

Typically, this happens when the time range you specified to generate the report, caused the system to generate a report larger than 10 Megabytes (MB) in size.

It is recommended that you select a shorter time range and retry.

Request cancelled: This indicates that the report you requested has been cancelled by. Contact our Technical Support Team at to discuss
this development.

Note

The name(Anchor: fname) of the report file emailed to you is in the following format:

report__-_.csv.zip

Note

You may unzip/unpack the zip file with any commercial or freeware software, such as:

Software

Platform

License Type

WinZip

PC

Commercial

WinRar

PC, Mac (Only Command Line)

Commercial

7-Zip

PC

Freeware

The Unarchiver

Mac

Freeware

Following is the description of each of the parts of the filename:

reportKey: This indicates the type of report being generated. The following
are the values that you can expect:

Report Key

Report name

contacts

Contacts

customers

Customer Details

prodDigicert

Product Orders - Digital Certificates

prodDomain

Product Orders - Domains

prodWeb

Product Orders - Web Services

prodMDHosting

Product Orders - Multi Domain Hosting

prodResHosting

Product Orders - Reseller Hosting

resellers

Reseller Details

txnCustomers

Transactions with Customers

txnParent

Transactions with Parent Reseller

txnSubResellers

Transactions with Sub-Resellers

balanceReport

Balance Report

forexReport

Forex Report

pgReport

Payment Gateway Report

receiptReport

Receipt Report

salesReport

Sales Report

taxReport

Tax Report

startDate: This indicates the From date of the report that you selected. This is in YYYYMMDD format,
starting from 00:00:00 hrs GMT on this date.

endDate: This indicates the To date of the report that you selected. This is in YYYYMMDD format,
till 23:59:59 hrs GMT on this date.