Measure units
Index of tables:

Click here to see the rules for Currency Calculation.

Table tbl_ec_measureunit -- List of measure units5.3

Field name Field description Field type Field size key required default Observation
tc_codecurrency Code of currency VARCHAR 20 yes yes    
tc_descrcurrency Currency description VARCHAR 50       Used only in administration area
tc_symbolcurrency Currency symbol VARCHAR 10   yes   If tc_HTMLsymbolcurrency is empty then this field is used for display in public area (Ex: GBD for United Kingdom Pounds)
tc_HTMLsymbolcurrency HTML symbol currency VARCHAR 10       If the field contains a non empty value then it's used for display in public area (Ex: £ for United Kingdom Pounds -> £)
tc_multdiv Flag to specify if multiply or divide operation will be used in price convertion CHAR 1   yes D Admitted values: D for Divide and M for Multiply
tc_nrdec Number of decimals used in price display INT          

Table tbl_currency_exchange -- Exchange rates5.1

Field name Field description Field type Field size key required default Observation
tce_codecurrency Code of currency VARCHAR 20 yes yes    
tce_codecust Customer code VARCHAR 20 yes     Linked to u_id/u_externalcode from tbl_users; if you fill in this field, let tce_codepricelist=0 or ''
tce_codepricelist Pricelist code VARCHAR 100 yes yes    
tce_datestart The start date to validate exchange rate DATE   yes yes 2000-01-01  
tce_dateend The end date to validate exchange rate DATE       2100-01-01  
tce_exchangerate The VALUE of exchange rate DOUBLE