| Line 7: | Line 7: | ||
==DIY Fields== | ==DIY Fields== | ||
* | * Available field type | ||
:: - Boolean | :: - Boolean | ||
:: - Currency | :: - Currency | ||
| Line 26: | Line 26: | ||
|} | |} | ||
:::---------------------------------------------------------------------------------------------------------------------------------------------------- | :::---------------------------------------------------------------------------------------------------------------------------------------------------- | ||
* User can create DIY Fields either at '''Header Fields''' or '''Item Fields''' | |||
===Header Fields=== | |||
===Item Fields=== | |||
Revision as of 04:04, 9 September 2015
Menu: Tools | DIY | SQL Control Center...
Introduction
This Additional Module where user can self
- Create new field (DIY Fields Module)
- Modified the SQL Accounting (DIY Script Module)
DIY Fields
- Available field type
- - Boolean
- - Currency
- - Date
- - Float
- - Integer
- - Memo
- - Picture
- - String
- For Explaination for Each Data Type may refer to http://www.w3schools.com/sql/sql_datatypes_general.asp
- ----------------------------------------------------------------------------------------------------------------------------------------------------
Avoid use Picture data as it will cause your database size increase very fast.
- ----------------------------------------------------------------------------------------------------------------------------------------------------
- User can create DIY Fields either at Header Fields or Item Fields