Measure units |
![]() |
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 |