{"id":3304,"date":"2017-02-07T11:45:46","date_gmt":"2017-02-07T11:45:46","guid":{"rendered":"http:\/\/www.erplybooks.com\/report-generator-api-documentation\/"},"modified":"2023-07-07T07:19:13","modified_gmt":"2023-07-07T07:19:13","slug":"report-generator-api-documentation","status":"publish","type":"page","link":"https:\/\/www.erplybooks.com\/ru\/report-generator-api-documentation\/","title":{"rendered":"Report Generator API Documentation"},"content":{"rendered":"
\n

General<\/h2>\n<\/div>\n
\n
\n

This document describes the different datatypes that ERPLY Books’ report generator API uses. To see the entire POST data, go to a custom report and click on «JSON». This will give you an example of the same query sent through the API.<\/p>\n<\/div>\n

You can find the general manual for the report generator here<\/a><\/p>\n

To access the rest of ERPLY Books’ API, click here<\/a>.
\nTo find out about custom types, click here<\/a>.<\/p>\n<\/div>\n

\n
\n

API Token<\/h3>\n

In order to use ERPLY Books’s Report generator through the API, you need to send POST requests to https:\/\/api.erplybooks.com\/api\/report_generator<\/code>. Additionally, you have to provide a token. For example, if your token is 25is6ho0tld7kft9b56rg6l3feeqr6ckiaatjuu<\/code> , then the complete URL will look like this:https:\/\/api.erplybooks.com\/api\/report_generator?token=25is6ho0tld7kft9b56rg6l3feeqr6ckiaatjuu<\/code><\/p>\n<\/div>\n<\/div>\n

\n
\n

Supported Tables<\/h3>\n

Using the API you can access the following tables:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Table<\/th>\nDescription<\/th>\n<\/tr>\n
DOCUMENT<\/a><\/td>\nInvoices<\/td>\n<\/tr>\n
PAYMENT<\/a><\/td>\nPayments done on invoices<\/td>\n<\/tr>\n
ARTICLE_ROW<\/a><\/td>\nRows on a single invoice (different items, for example)<\/td>\n<\/tr>\n
ACCOUNT<\/a><\/td>\nBank accounts<\/td>\n<\/tr>\n
ACCOUNT_ENTRY<\/a><\/td>\nTransactions that affect a specific account.<\/td>\n<\/tr>\n
TRANSACTION_ENTRY<\/a><\/td>\nComplete transactions that usually contain several account entries.<\/td>\n<\/tr>\n
ENTITY<\/a><\/td>\nCustomers, suppliers and other contacts<\/td>\n<\/tr>\n
TAX_RATE<\/a><\/td>\nTax rates<\/td>\n<\/tr>\n
PROJECT<\/a><\/td>\nProjects<\/td>\n<\/tr>\n
ARTICLE<\/a><\/td>\nArticles<\/td>\n<\/tr>\n
PARTNER_SYNC_HISTORY<\/a><\/td>\nSynchronization history<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/a><\/td>\nCan contain various data, like integration settings and saved custom reports<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/a><\/td>\nContains info about the organisation<\/td>\n<\/tr>\n
USER_ORGANISATION_ROLE<\/a><\/td>\nInfo about user roles<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
\n
\n

Operations<\/h3>\n<\/div>\n
\n

Supported Operations<\/h3>\n

When adding parameters to your search queries, these are the available operations:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n
Operation<\/th>\nDescription<\/th>\n<\/tr>\n
IN<\/td>\nEquals<\/td>\n<\/tr>\n
NOT_IN<\/td>\nDoesn’t equal<\/td>\n<\/tr>\n
LIKE<\/td>\nContains<\/td>\n<\/tr>\n
IS_NULL<\/td>\nIs empty<\/td>\n<\/tr>\n
NOT_NULL<\/td>\nIs not empty<\/td>\n<\/tr>\n
MORE_THAN<\/td>\nIs More than<\/td>\n<\/tr>\n
MORE_THAN_EQUAL<\/td>\nIs more than or is equal<\/td>\n<\/tr>\n
LESS_THAN<\/td>\nIs less than<\/td>\n<\/tr>\n
LESS_THAN_EQUAL<\/td>\nIs less than or is equal<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
\n
\n

Dictionary<\/h3>\n<\/div>\n
\n

Supported Fields<\/h3>\n

The following table lists all possible fields from all tables. We highly recommend that, instead of creating JSON queries manually, you use our front-end report generator module and the JSON creator provided. If you have any questions, please contact us at support@erplybooks.com<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Table<\/th>\nField<\/th>\nDatatype<\/th>\n<\/tr>\n<\/thead>\n
DOCUMENT<\/td>\nID<\/td>\nTEXT<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nDOCUMENT_INFO_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nNUMBER<\/td>\nTEXT<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nCUSTOMER_ENTITY_ID<\/td>\nCUSTOMER<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nDATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nTYPE_CODE<\/td>\nDOCUMENT_TYPE<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nLANGUAGE_CODE<\/td>\nLANGUAGE<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nCURRENCY_CODE<\/td>\nCURRENCY<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nSUM_NO_VAT<\/td>\nNUMBER<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nSUM_WITH_VAT<\/td>\nNUMBER<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nSUM_PAID<\/td>\nNUMBER<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nROUNDING_TRANSACTION_ENTRY_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nOWNER_ORGANISATION_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nVAT_PERCENT<\/td>\nTEXT<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nREFERENCE_NUMBER<\/td>\nTEXT<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nMAIN_DISCOUNT<\/td>\nTEXT<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nDEADLINE_DATE<\/td>\nDATE<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nPENALTY_PERCENT<\/td>\nTEXT<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nINFO<\/td>\nTEXT<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nHASH<\/td>\nTEXT<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nPRINTED_INFO<\/td>\nTEXT<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nPROJECT_ID<\/td>\nPROJECT<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nCODE<\/td>\nTEXT<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nREFERRING_IDENTIFIER<\/td>\nTEXT<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nTRANSACTION_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nPARTNER_DOCUMENT_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nVAT_TOTAL_ROUNDING_TRANSACTION_ENTRY_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nMAIN_PROJECT_ID<\/td>\nPROJECT<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nDOCUMENT_STATUS_TYPE_CODE<\/td>\nDOCUMENT_STATUS_TYPE<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nPROJECTS<\/td>\nTEXT<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nCREATOR_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nCREATE_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nMOD_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nMOD_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nDEL_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
DOCUMENT<\/td>\nDEL_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
PAYMENT<\/td>\nID<\/td>\nTEXT<\/td>\n<\/tr>\n
PAYMENT<\/td>\nSUM_MOVED<\/td>\nNUMBER<\/td>\n<\/tr>\n
PAYMENT<\/td>\nTYPE_CODE<\/td>\nPAYMENT_TYPE<\/td>\n<\/tr>\n
PAYMENT<\/td>\nDATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
PAYMENT<\/td>\nTRANSACTION_ENTRY_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
PAYMENT<\/td>\nACCOUNT_ID<\/td>\nACCOUNT<\/td>\n<\/tr>\n
PAYMENT<\/td>\nDOCUMENT_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
PAYMENT<\/td>\nCURRENCY_CODE<\/td>\nCURRENCY<\/td>\n<\/tr>\n
PAYMENT<\/td>\nINFO<\/td>\nTEXT<\/td>\n<\/tr>\n
PAYMENT<\/td>\nARCHIVING_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
PAYMENT<\/td>\nPARTNER_PAYMENT_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
PAYMENT<\/td>\nENTITY_ID<\/td>\nCUSTOMER<\/td>\n<\/tr>\n
PAYMENT<\/td>\nIMPORTED<\/td>\nBOOLEAN<\/td>\n<\/tr>\n
PAYMENT<\/td>\nORIGINAL_SUM<\/td>\nNUMBER<\/td>\n<\/tr>\n
PAYMENT<\/td>\nORGANISATION_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
PAYMENT<\/td>\nPARTNER_DOCUMENT_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
PAYMENT<\/td>\nDOCUMENT_STATUS_TYPE_CODE<\/td>\nDOCUMENT_STATUS_TYPE<\/td>\n<\/tr>\n
PAYMENT<\/td>\nCURRENCY_RATE<\/td>\nTEXT<\/td>\n<\/tr>\n
PAYMENT<\/td>\nPROJECT_ID<\/td>\nPROJECT<\/td>\n<\/tr>\n
PAYMENT<\/td>\nMAIN_PROJECT_ID<\/td>\nPROJECT<\/td>\n<\/tr>\n
PAYMENT<\/td>\nSTATUS_CHANGE_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
PAYMENT<\/td>\nENTITY_NAME<\/td>\nTEXT<\/td>\n<\/tr>\n
PAYMENT<\/td>\nPARENT_PAYMENT_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
PAYMENT<\/td>\nPROJECTS<\/td>\nTEXT<\/td>\n<\/tr>\n
PAYMENT<\/td>\nCREATOR_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
PAYMENT<\/td>\nCREATE_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
PAYMENT<\/td>\nMOD_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
PAYMENT<\/td>\nMOD_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
PAYMENT<\/td>\nDEL_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
PAYMENT<\/td>\nDEL_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
ARTICLE_ROW<\/td>\nID<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE_ROW<\/td>\nARTICLE_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE_ROW<\/td>\nNAME<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE_ROW<\/td>\nQUANTITY<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE_ROW<\/td>\nDATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
ARTICLE_ROW<\/td>\nPRICE<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE_ROW<\/td>\nVAT_PERCENT<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE_ROW<\/td>\nTYPE_CODE<\/td>\nARTICLE_ROW_TYPE<\/td>\n<\/tr>\n
ARTICLE_ROW<\/td>\nEXTRA_CHARGE<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE_ROW<\/td>\nDOCUMENT_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE_ROW<\/td>\nTRANSACTION_ENTRY_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE_ROW<\/td>\nDISCOUNT<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE_ROW<\/td>\nUNIT_CODE<\/td>\nUNIT<\/td>\n<\/tr>\n
ARTICLE_ROW<\/td>\nCODE<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE_ROW<\/td>\nVAT_ACCOUNT_ID<\/td>\nACCOUNT<\/td>\n<\/tr>\n
ARTICLE_ROW<\/td>\nEXPENSE_ACCOUNT_ID<\/td>\nACCOUNT<\/td>\n<\/tr>\n
ARTICLE_ROW<\/td>\nREVENUE_ACCOUNT_ID<\/td>\nACCOUNT<\/td>\n<\/tr>\n
ARTICLE_ROW<\/td>\nPROJECT_ID<\/td>\nPROJECT<\/td>\n<\/tr>\n
ARTICLE_ROW<\/td>\nRESIDUAL_VALUE<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE_ROW<\/td>\nORGANISATION_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE_ROW<\/td>\nTAX_RATE_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE_ROW<\/td>\nMAIN_PROJECT_ID<\/td>\nPROJECT<\/td>\n<\/tr>\n
ARTICLE_ROW<\/td>\nACTIVITY_ITEM_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE_ROW<\/td>\nPROJECTS<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE_ROW<\/td>\nCREATOR_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE_ROW<\/td>\nCREATE_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
ARTICLE_ROW<\/td>\nMOD_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE_ROW<\/td>\nMOD_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
ARTICLE_ROW<\/td>\nDEL_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE_ROW<\/td>\nDEL_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
ACCOUNT<\/td>\nID<\/td>\nTEXT<\/td>\n<\/tr>\n
ACCOUNT<\/td>\nORGANISATION_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ACCOUNT<\/td>\nNUMBER<\/td>\nTEXT<\/td>\n<\/tr>\n
ACCOUNT<\/td>\nNAME<\/td>\nTEXT<\/td>\n<\/tr>\n
ACCOUNT<\/td>\nSALDO_SUM<\/td>\nNUMBER<\/td>\n<\/tr>\n
ACCOUNT<\/td>\nINCOME_TYPE_CODE<\/td>\nINCOME_TYPE<\/td>\n<\/tr>\n
ACCOUNT<\/td>\nBALANCE_TYPE_CODE<\/td>\nBALANCE_TYPE<\/td>\n<\/tr>\n
ACCOUNT<\/td>\nTYPE_CODE<\/td>\nACCOUNT_TYPE<\/td>\n<\/tr>\n
ACCOUNT<\/td>\nCASH_FLOW_TYPE_CODE<\/td>\nCASH_FLOW_TYPE<\/td>\n<\/tr>\n
ACCOUNT<\/td>\nDESCRIPTION<\/td>\nTEXT<\/td>\n<\/tr>\n
ACCOUNT<\/td>\nCURRENCY_CODE<\/td>\nCURRENCY<\/td>\n<\/tr>\n
ACCOUNT<\/td>\nPARTNER_ACCOUNT_ID<\/td>\nACCOUNT<\/td>\n<\/tr>\n
ACCOUNT<\/td>\nTAX_RATE_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ACCOUNT<\/td>\nCREATOR_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ACCOUNT<\/td>\nCREATE_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
ACCOUNT<\/td>\nMOD_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ACCOUNT<\/td>\nMOD_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
ACCOUNT<\/td>\nDEL_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ACCOUNT<\/td>\nDEL_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
ACCOUNT_ENTRY<\/td>\nID<\/td>\nTEXT<\/td>\n<\/tr>\n
ACCOUNT_ENTRY<\/td>\nACCOUNT_ID<\/td>\nACCOUNT<\/td>\n<\/tr>\n
ACCOUNT_ENTRY<\/td>\nTRANSACTION_ENTRY_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ACCOUNT_ENTRY<\/td>\nDEBIT_SUM<\/td>\nNUMBER<\/td>\n<\/tr>\n
ACCOUNT_ENTRY<\/td>\nCREDIT_SUM<\/td>\nNUMBER<\/td>\n<\/tr>\n
ACCOUNT_ENTRY<\/td>\nDESCRIPTION<\/td>\nTEXT<\/td>\n<\/tr>\n
ACCOUNT_ENTRY<\/td>\nOP_DATE<\/td>\nDATE<\/td>\n<\/tr>\n
ACCOUNT_ENTRY<\/td>\nCURRENCY_CODE<\/td>\nCURRENCY<\/td>\n<\/tr>\n
ACCOUNT_ENTRY<\/td>\nORGANISATION_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ACCOUNT_ENTRY<\/td>\nPROJECT_ID<\/td>\nPROJECT<\/td>\n<\/tr>\n
ACCOUNT_ENTRY<\/td>\nMAIN_PROJECT_ID<\/td>\nPROJECT<\/td>\n<\/tr>\n
ACCOUNT_ENTRY<\/td>\nACTIVITY_ITEM_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ACCOUNT_ENTRY<\/td>\nPROJECTS<\/td>\nTEXT<\/td>\n<\/tr>\n
ACCOUNT_ENTRY<\/td>\nCREATOR_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ACCOUNT_ENTRY<\/td>\nCREATE_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
ACCOUNT_ENTRY<\/td>\nMOD_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ACCOUNT_ENTRY<\/td>\nMOD_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
TRANSACTION_ENTRY<\/td>\nID<\/td>\nTEXT<\/td>\n<\/tr>\n
TRANSACTION_ENTRY<\/td>\nORGANISATION_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
TRANSACTION_ENTRY<\/td>\nSUM<\/td>\nNUMBER<\/td>\n<\/tr>\n
TRANSACTION_ENTRY<\/td>\nOP_DATE<\/td>\nDATE<\/td>\n<\/tr>\n
TRANSACTION_ENTRY<\/td>\nDESCRIPTION<\/td>\nTEXT<\/td>\n<\/tr>\n
TRANSACTION_ENTRY<\/td>\nTYPE_CODE<\/td>\nTRANSACTION_TYPE<\/td>\n<\/tr>\n
TRANSACTION_ENTRY<\/td>\nCODE<\/td>\nTEXT<\/td>\n<\/tr>\n
TRANSACTION_ENTRY<\/td>\nPERCENT<\/td>\nTEXT<\/td>\n<\/tr>\n
TRANSACTION_ENTRY<\/td>\nPROJECT_ID<\/td>\nPROJECT<\/td>\n<\/tr>\n
TRANSACTION_ENTRY<\/td>\nTAX_RATE_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
TRANSACTION_ENTRY<\/td>\nCURRENCY_RATE<\/td>\nTEXT<\/td>\n<\/tr>\n
TRANSACTION_ENTRY<\/td>\nMAIN_PROJECT_ID<\/td>\nPROJECT<\/td>\n<\/tr>\n
TRANSACTION_ENTRY<\/td>\nPROJECTS<\/td>\nTEXT<\/td>\n<\/tr>\n
TRANSACTION_ENTRY<\/td>\nCREATOR_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
TRANSACTION_ENTRY<\/td>\nCREATE_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
TRANSACTION_ENTRY<\/td>\nMOD_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
TRANSACTION_ENTRY<\/td>\nMOD_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
TRANSACTION_ENTRY<\/td>\nDEL_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
TRANSACTION_ENTRY<\/td>\nDEL_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
ENTITY<\/td>\nID<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nCODE<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nBILLING_NAME<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nENTITY_TYPE_CODE<\/td>\nENTITY_TYPE<\/td>\n<\/tr>\n
ENTITY<\/td>\nREGISTRATION_CODE<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nVAT_NUMBER<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nINFO<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nREFERENCE_NUMBER<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nPENALTY_PERCENT<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nDEADLINE_DAYS<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nDISCOUNT<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nCONTACT_ENTITY_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nCONTACT_LEGAL_ADDRESS<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nCONTACT_LEGAL_POSTCODE<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nCONTACT_EMAIL<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nCONTACT_ACTUAL_COUNTRY_ISO2<\/td>\nCOUNTRY_TYPE<\/td>\n<\/tr>\n
ENTITY<\/td>\nCONTACT_ACTUAL_POSTCODE<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nCONTACT_MOBILE<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nCONTACT_PHONE<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nCONTACT_WEBSITE<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nCONTACT_FAX<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nCONTACT_ACTUAL_ADDRESS<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nCONTACT_LEGAL_COUNTRY_ISO2<\/td>\nCOUNTRY_TYPE<\/td>\n<\/tr>\n
ENTITY<\/td>\nIMAGE_FILENAME<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nPARTNER_CUSTOMER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nPARTNER_SUPPLIER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nBANK_NAME<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nBANK_ACCOUNT_NUMBER<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nBANK_IBAN<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nBANK_SWIFT<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nBANK_IDENTIFICATOR<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nORGANISATION_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nCUSTOMER<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nSUPPLIER<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nCUSTOMER_DEBIT_ACCOUNT_ID<\/td>\nACCOUNT<\/td>\n<\/tr>\n
ENTITY<\/td>\nCUSTOMER_CREDIT_ACCOUNT_ID<\/td>\nACCOUNT<\/td>\n<\/tr>\n
ENTITY<\/td>\nSUPPLIER_DEBIT_ACCOUNT_ID<\/td>\nACCOUNT<\/td>\n<\/tr>\n
ENTITY<\/td>\nSUPPLIER_CREDIT_ACCOUNT_ID<\/td>\nACCOUNT<\/td>\n<\/tr>\n
ENTITY<\/td>\nCREATOR_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nCREATE_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
ENTITY<\/td>\nMOD_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nMOD_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
ENTITY<\/td>\nDEL_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ENTITY<\/td>\nDEL_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
TAX_RATE<\/td>\nID<\/td>\nTEXT<\/td>\n<\/tr>\n
TAX_RATE<\/td>\nORGANISATION_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
TAX_RATE<\/td>\nPERCENT<\/td>\nTEXT<\/td>\n<\/tr>\n
TAX_RATE<\/td>\nDESCRIPTION<\/td>\nTEXT<\/td>\n<\/tr>\n
TAX_RATE<\/td>\nTYPE_CODE<\/td>\nTAX_RATE_TYPE<\/td>\n<\/tr>\n
TAX_RATE<\/td>\nPARTNER_TAX_RATE_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
TAX_RATE<\/td>\nDEBIT_ACCOUNT_ID<\/td>\nACCOUNT<\/td>\n<\/tr>\n
TAX_RATE<\/td>\nCREDIT_ACCOUNT_ID<\/td>\nACCOUNT<\/td>\n<\/tr>\n
TAX_RATE<\/td>\nREVENUE_ACCOUNT_ID<\/td>\nACCOUNT<\/td>\n<\/tr>\n
TAX_RATE<\/td>\nCOEFFICIENT<\/td>\nTEXT<\/td>\n<\/tr>\n
TAX_RATE<\/td>\nCREATOR_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
TAX_RATE<\/td>\nCREATE_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
TAX_RATE<\/td>\nMOD_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
TAX_RATE<\/td>\nMOD_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
TAX_RATE<\/td>\nDEL_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
TAX_RATE<\/td>\nDEL_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
PROJECT<\/td>\nID<\/td>\nTEXT<\/td>\n<\/tr>\n
PROJECT<\/td>\nORGANISATION_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
PROJECT<\/td>\nNAME<\/td>\nTEXT<\/td>\n<\/tr>\n
PROJECT<\/td>\nAFFIRMED<\/td>\nBOOLEAN<\/td>\n<\/tr>\n
PROJECT<\/td>\nDESCRIPTION<\/td>\nTEXT<\/td>\n<\/tr>\n
PROJECT<\/td>\nPARTNER_PROJECT_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
PROJECT<\/td>\nSYNC_ERPLY_USERS<\/td>\nBOOLEAN<\/td>\n<\/tr>\n
PROJECT<\/td>\nMAIN_PROJECT_ID<\/td>\nPROJECT<\/td>\n<\/tr>\n
PROJECT<\/td>\nCREATOR_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
PROJECT<\/td>\nCREATE_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
PROJECT<\/td>\nMOD_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
PROJECT<\/td>\nMOD_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
PROJECT<\/td>\nDEL_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
PROJECT<\/td>\nDEL_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
ARTICLE<\/td>\nID<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE<\/td>\nORGANISATION_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE<\/td>\nTYPE_CODE<\/td>\nARTICLE_TYPE<\/td>\n<\/tr>\n
ARTICLE<\/td>\nNAME<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE<\/td>\nEXPENSE_ACCOUNT_ID<\/td>\nACCOUNT<\/td>\n<\/tr>\n
ARTICLE<\/td>\nASSET_ACCOUNT_ID<\/td>\nACCOUNT<\/td>\n<\/tr>\n
ARTICLE<\/td>\nCODE<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE<\/td>\nVAT_PERCENT<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE<\/td>\nINFO<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE<\/td>\nUNIT_CODE<\/td>\nUNIT<\/td>\n<\/tr>\n
ARTICLE<\/td>\nPARTNER_ARTICLE_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE<\/td>\nREVENUE_ACCOUNT_ID<\/td>\nACCOUNT<\/td>\n<\/tr>\n
ARTICLE<\/td>\nTAX_RATE_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE<\/td>\nLIFESPAN<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE<\/td>\nCREATOR_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE<\/td>\nCREATE_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
ARTICLE<\/td>\nMOD_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE<\/td>\nMOD_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
ARTICLE<\/td>\nDEL_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ARTICLE<\/td>\nDEL_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
PARTNER_SYNC_HISTORY<\/td>\nID<\/td>\nTEXT<\/td>\n<\/tr>\n
PARTNER_SYNC_HISTORY<\/td>\nORGANISATION_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
PARTNER_SYNC_HISTORY<\/td>\nPARTNER_TYPE_CODE<\/td>\nPARTNER_TYPE<\/td>\n<\/tr>\n
PARTNER_SYNC_HISTORY<\/td>\nTASK_NAME<\/td>\nTEXT<\/td>\n<\/tr>\n
PARTNER_SYNC_HISTORY<\/td>\nSTART_TIME<\/td>\nTEXT<\/td>\n<\/tr>\n
PARTNER_SYNC_HISTORY<\/td>\nSTOP_TIME<\/td>\nTEXT<\/td>\n<\/tr>\n
PARTNER_SYNC_HISTORY<\/td>\nSYNC_STATUS_TYPE_CODE<\/td>\nSYNC_STATUS_TYPE<\/td>\n<\/tr>\n
PARTNER_SYNC_HISTORY<\/td>\nSYNC_FROM_TIME<\/td>\nTEXT<\/td>\n<\/tr>\n
PARTNER_SYNC_HISTORY<\/td>\nCREATOR_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
PARTNER_SYNC_HISTORY<\/td>\nCREATE_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
PARTNER_SYNC_HISTORY<\/td>\nMOD_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
PARTNER_SYNC_HISTORY<\/td>\nMOD_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nid<\/td>\nTEXT<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nACTIVITY_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nTYPE_CODE<\/td>\nACTIVITY_ITEM_TYPE<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nDESCRIPTION<\/td>\nTEXT<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nVALUE<\/td>\nTEXT<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nNAME<\/td>\nTEXT<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nROW<\/td>\nTEXT<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nCOLUMN<\/td>\nTEXT<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nTRANSACTION_ENTRY_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nORGANISATION_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nENTITY_ID<\/td>\nCUSTOMER<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nDATE_FROM<\/td>\nDATE<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nDATE_TO<\/td>\nDATE<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nDECIMAL_VALUE<\/td>\nTEXT<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nPROJECT_ID<\/td>\nPROJECT<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nMAIN_PROJECT_ID<\/td>\nPROJECT<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nALTERNATIVE_VALUE<\/td>\nTEXT<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nALTERNATIVE_VALUE2<\/td>\nTEXT<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nALTERNATIVE_VALUE3<\/td>\nTEXT<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nALTERNATIVE_VALUE4<\/td>\nTEXT<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nALTERNATIVE_VALUE5<\/td>\nTEXT<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nALTERNATIVE_VALUE6<\/td>\nTEXT<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nALTERNATIVE_VALUE7<\/td>\nTEXT<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nALTERNATIVE_VALUE8<\/td>\nTEXT<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nALTERNATIVE_VALUE9<\/td>\nTEXT<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nCREATOR_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nCREATE_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nMOD_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nMOD_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nDEL_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ACTIVITY_ITEM<\/td>\nDEL_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nID<\/td>\nTEXT<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nORGANISATION_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nPENALTY_PERCENT<\/td>\nTEXT<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nMAIN_LANGUAGE_CODE<\/td>\nLANGUAGE<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nMAIN_CURRENCY_CODE<\/td>\nCURRENCY<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nIF_VAT_LIABLE<\/td>\nBOOLEAN<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nFIRST_INVOICE_NUMBER<\/td>\nTEXT<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nDEADLINE_DAYS<\/td>\nTEXT<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nDIGITS_AFTER_ROUNDING<\/td>\nTEXT<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nDEFAULT_EXTRA_CHARGE<\/td>\nTEXT<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nDOC_EMAIL_TEXT<\/td>\nTEXT<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nREFERRAL_CODE<\/td>\nTEXT<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nREFERRED_REFERRAL_CODE<\/td>\nTEXT<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nDATE_FORMAT_CODE<\/td>\nTEXT<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nERPLY_CLIENT_CODE<\/td>\nTEXT<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nERPLY_LAST_SYNC_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nERPLY_CUSTOMER_ENTITY_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nPRICEPLAN_TYPE_CODE<\/td>\nPRICEPLAN_TYPE<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nLOCKING_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nCREATE_TRANSACTIONS_BEFORE_LOCKED_DATE<\/td>\nBOOLEAN<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nRECONCILING_DATE<\/td>\nDATE<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nUSE_ARTICLE_DESCRIPTION<\/td>\nTEXT<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nSYNC_WAYBILLS<\/td>\nBOOLEAN<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nAUTOMATIC_BANK_INTEGRATION<\/td>\nBOOLEAN<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nDASHBOARD_CODE<\/td>\nTEXT<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nUSE_DOCUMENT_CONFIRMATION<\/td>\nBOOLEAN<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nEXTERNAL_INTEGRATIONS<\/td>\nTEXT<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nUSE_MULTIPLE_PROJECTS<\/td>\nBOOLEAN<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nCREATOR_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nCREATE_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nMOD_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nMOD_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nDEL_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
ORGANISATION_TERM<\/td>\nDEL_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
USER_ORGANISATION_ROLE<\/td>\nID<\/td>\nTEXT<\/td>\n<\/tr>\n
USER_ORGANISATION_ROLE<\/td>\nUSER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
USER_ORGANISATION_ROLE<\/td>\nORGANISATION_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
USER_ORGANISATION_ROLE<\/td>\nORGANISATION_ROLE_CODE<\/td>\nORG_ROLE<\/td>\n<\/tr>\n
USER_ORGANISATION_ROLE<\/td>\nPROJECT_ID<\/td>\nPROJECT<\/td>\n<\/tr>\n
USER_ORGANISATION_ROLE<\/td>\nCREATOR_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
USER_ORGANISATION_ROLE<\/td>\nCREATE_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
USER_ORGANISATION_ROLE<\/td>\nMOD_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
USER_ORGANISATION_ROLE<\/td>\nMOD_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
USER_ORGANISATION_ROLE<\/td>\nDEL_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
USER_ORGANISATION_ROLE<\/td>\nDEL_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
CURRENCY_RATE<\/td>\nID<\/td>\nTEXT<\/td>\n<\/tr>\n
CURRENCY_RATE<\/td>\nCURRENCY_CODE<\/td>\nCURRENCY<\/td>\n<\/tr>\n
CURRENCY_RATE<\/td>\nBASE_CURRENCY_CODE<\/td>\nCURRENCY<\/td>\n<\/tr>\n
CURRENCY_RATE<\/td>\nRATE_VALUE<\/td>\nTEXT<\/td>\n<\/tr>\n
CURRENCY_RATE<\/td>\nCREATOR_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
CURRENCY_RATE<\/td>\nCREATE_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
CURRENCY_RATE<\/td>\nMOD_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
CURRENCY_RATE<\/td>\nMOD_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n
CURRENCY_RATE<\/td>\nDEL_USER_ID<\/td>\nTEXT<\/td>\n<\/tr>\n
CURRENCY_RATE<\/td>\nDEL_DATETIME<\/td>\nDATE<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

General This document describes the different datatypes that ERPLY Books’ report generator API uses. To see the entire POST data, go to a custom report and click on «JSON». This will give you an example of the same query sent through the API. You can find the general manual for the report generator here To […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":86,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[739],"tags":[740,1127,1128],"class_list":["post-3304","page","type-page","status-publish","hentry","category-integrations-ru","tag-api-ru","tag-document-ru","tag-report-generator-ru"],"_links":{"self":[{"href":"https:\/\/www.erplybooks.com\/ru\/wp-json\/wp\/v2\/pages\/3304","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.erplybooks.com\/ru\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.erplybooks.com\/ru\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.erplybooks.com\/ru\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.erplybooks.com\/ru\/wp-json\/wp\/v2\/comments?post=3304"}],"version-history":[{"count":0,"href":"https:\/\/www.erplybooks.com\/ru\/wp-json\/wp\/v2\/pages\/3304\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.erplybooks.com\/ru\/wp-json\/wp\/v2\/media?parent=3304"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.erplybooks.com\/ru\/wp-json\/wp\/v2\/categories?post=3304"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.erplybooks.com\/ru\/wp-json\/wp\/v2\/tags?post=3304"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}