Excel Add-in: Explanation of functions

Function

Result

CO_DATA

Content of the fields in the administration information file

FILE_FIELD

Retrieving fields from the database

FILE_FIRST

The first record from a file

FILE_NEXT

The next record from a file

IS_HIDDEN

Value = 'TRUE': the cell is hidden; value = 'FALSE': the cell is visible < /FONT >

HR_DATA

Include the field value of a Resource (Personnel).

Function

Result

ACC_BAL

Balance of an account or a series of accounts

ACC_BAL_DATE

Balance of an account or a series of accounts based on date

ACC_DATA

Content of the fields in the general ledger account file

BUDGET_CC

Budget balance of a cost center per general ledger account, sub-classification or classification

BUDGET_CU

Budget balance of a cost unit per general ledger account, sub-classification or classification

BUDGET_BAL

Budget balance of a budget per general ledger account, cost center or cost unit

CC_BAL

Balance of a cost center per account or series of accounts

CC_BAL_DATE

Balance of a cost center on date per account or series of accounts

CC_DATA

Content of the fields in the cost units file

CC_MAIN_CLASS

Balance of a cost center per classification or series of classifications

CC_MAIN_CLASS_DATE

Balance of a cost center on date per classification or series of classifications

CC_SUB_CLASS

balance of a cost center per sub-classification or series of sub-classifications

CC_SUB_CLASS_DATE

Balance of a cost center on date per sub-classification or series of sub-classifications

CU_BAL

Balance of a cost unit per account or series of accounts

CU_BAL_DATE

Balance of a cost unit on date per account or series of accounts

CU_DATA

Content of the fields in the cost units file

CU_MAIN_CLASS 

Balance of the cost unit per classification or series of classifications

CU_MAIN_CLASS_DATE

Balance of a cost unit on date per classification or series of classifications

CU_SUB_CLASS

Balance of a cost unit per sub-classification or series of sub-classifications

CU_SUB_CLASS_DATE

Balance of a cost unit on date per sub-classification or series of sub-classifications

CURR_CODE_DATA

Content of the fields in the currency code file

CURR_INFO

Standard or secondary currency code 

EXCHANGE_RATE

Exchange rate that corresponds to a currency code

GL_BAL

Balance of a cost center and cost unit per general ledger account or series of general ledger accounts

GL_BAL_DATE

Balance of a cost center and cost unit on date per general ledger account or series of general ledger accounts

GL_TRANS

Balance of all the transactions on a general ledger account

GL_TRANS_DATE

Balance of all the transactions on a general ledger account by date

MAIN_CLASS_BAL

Balance of a classification or a series of classifications

MAIN_CLASS_BAL_DATE

Balance of a classification or a series of classifications on date

MAIN_CLASS_DATA

The content of the fields in the classifications file

SUB_CLASS_BAL

Balance of a sub-classification or a series of sub-classifications

SUB_CLASS_BAL_DATE

Balance of a sub-classification or a series of sub-classifications by date

SUB_CLASS_DATA

The content of the fields in the sub-classifications file

Function

Result

CRD_DATA

Content of the fields in the creditors file

CRD_OUTSTAN_ALL

Information about all the outstanding items that are less than a specified number of days old

CRD_OUTSTANDING

Information about one outstanding item

DEB_DATA

Content of the fields in the debtors file

DEB_OUTSTAN_ALL

Information about all the outstanding items that are less than a specified number of days old

DEB_OUTSTANDING

Information about one outstanding item

Function

Result

ITEM_DATA

Include the field value of an item in the worksheet

ITEM_DELIVERY

Include the delivery time for an item in the worksheet

ITEM_GROUP_DATA

Include the field value of an item group in the worksheet

STOCK_INFO

Include stock positions of an item in the worksheet

REV_DEBTOR

Revenue statistics per debtor and/or representative

REV_DEBTOR_FY

Revenue statistics per debtor and/or representative, whereby a selection can be made on financial year

REV_GROUP

Information about revenue statistics from the administration

REV_GROUP_FY

Information about revenue statistics from the administration, whereby a selection can be made on financial year

REV_ITEM

Revenue statistics per item and/or debtor

REV_ITEM_FY

Revenue statistics per item and/or debtor, whereby a selection can be made on financial year

Function

Result

PROJ_DATA

Include the field value of a project in the worksheet

PROJ_FIN_DATA

Include financial information about a project in the worksheet

PROJ_LEDGER

Include transactions per project general ledger account in the worksheet

PROJ_TOTAL_EMP 

Include transaction totals per employee in the worksheet

PROJ_TOTAL_MACH

Include transaction totals per material unit in the worksheet