SQL Control Center

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
Example	Example
Example	Example
Example	Example
Example	Example
Example	Example
Example	Example
Example	Example
Example	Example
Example	Example
Example	Example
Example	Example
Example	Example