| Line 35: | Line 35: | ||
! Name !! Description | ! Name !! Description | ||
|- | |- | ||
| | | Name|| | ||
* Field name | |||
* Only Alphanumeric & no spacing | |||
|- | |- | ||
| | | Data Type || | ||
* Type of Field | |||
|- | |- | ||
| | | Size || | ||
* The Field Size | |||
* Only applicable for '''Float''', '''Integer''' & '''String''' Data Type | |||
|- | |- | ||
| | | Sub Size || Example | ||
|- | |- | ||
| | | Caption || Example | ||
|- | |- | ||
| | | Required || Example | ||
|- | |- | ||
| | | Default Value || Example | ||
|- | |- | ||
| | | Display Format || Example | ||
|- | |- | ||
| | | Load || Reload again the Script from the Database | ||
|- | |- | ||
| | | Load From File || Load Script from the Text File | ||
|- | |- | ||
| | | Save || Save Current Script | ||
|- | |- | ||
| | | Save To File || Save Current Script to Text File | ||
|} | |} | ||
===Header Fields=== | ===Header Fields=== | ||
===Item Fields=== | ===Item Fields=== | ||
Revision as of 06:53, 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
- In each Field had the below interface
Name Description Name - Field name
- Only Alphanumeric & no spacing
Data Type - Type of Field
Size - The Field Size
- Only applicable for Float, Integer & String Data Type
Sub Size Example Caption Example Required Example Default Value Example Display Format Example Load Reload again the Script from the Database Load From File Load Script from the Text File Save Save Current Script Save To File Save Current Script to Text File