{{js_dataform}}<\/div>
<\/div>"
}
},
"columns": [
{
"Field": "accountID",
"Type": "int(10)",
"Null": "NO",
"Key": "PRI",
"Default": null,
"Extra": "auto_increment",
"mytype": "INT",
"size": 10,
"fieldname": "accountID",
"myextra": "auto_increment",
"noupdate": 1,
"noinsert": 1
},
{
"Field": "clientID",
"Type": "int(10)",
"Null": "NO",
"Key": "",
"Default": null,
"Extra": "",
"mytype": "INT",
"size": 10,
"fieldname": "clientID",
"myextra": "",
"noupdate": 1,
"noinsert": 1
},
{
"Field": "accountnumber",
"Type": "varchar(50)",
"Null": "NO",
"Key": "",
"Default": null,
"Extra": "",
"mytype": "VARCHAR",
"size": 50,
"fieldname": "accountnumber",
"myextra": ""
},
{
"Field": "name1",
"Type": "varchar(50)",
"Null": "YES",
"Key": "",
"Default": null,
"Extra": "",
"mytype": "VARCHAR",
"size": 50,
"fieldname": "name1",
"myextra": ""
},
{
"Field": "name2",
"Type": "varchar(50)",
"Null": "YES",
"Key": "",
"Default": null,
"Extra": "",
"mytype": "VARCHAR",
"size": 50,
"fieldname": "name2",
"myextra": ""
},
{
"Field": "street",
"Type": "varchar(50)",
"Null": "YES",
"Key": "",
"Default": null,
"Extra": "",
"mytype": "VARCHAR",
"size": 50,
"fieldname": "street",
"myextra": ""
},
{
"Field": "country",
"Type": "varchar(10)",
"Null": "YES",
"Key": "",
"Default": null,
"Extra": "",
"mytype": "VARCHAR",
"size": 10,
"fieldname": "country",
"myextra": ""
},
{
"Field": "code",
"Type": "varchar(10)",
"Null": "YES",
"Key": "",
"Default": null,
"Extra": "",
"mytype": "VARCHAR",
"size": 10,
"fieldname": "code",
"myextra": ""
},
{
"Field": "city",
"Type": "varchar(50)",
"Null": "YES",
"Key": "",
"Default": null,
"Extra": "",
"mytype": "VARCHAR",
"size": 50,
"fieldname": "city",
"myextra": ""
},
{
"Field": "phone",
"Type": "varchar(50)",
"Null": "YES",
"Key": "",
"Default": null,
"Extra": "",
"mytype": "VARCHAR",
"size": 50,
"fieldname": "phone",
"myextra": ""
},
{
"Field": "mobile",
"Type": "varchar(50)",
"Null": "YES",
"Key": "",
"Default": null,
"Extra": "",
"mytype": "VARCHAR",
"size": 50,
"fieldname": "mobile",
"myextra": ""
},
{
"Field": "email",
"Type": "varchar(250)",
"Null": "YES",
"Key": "",
"Default": null,
"Extra": "",
"mytype": "VARCHAR",
"size": 250,
"fieldname": "email",
"myextra": ""
},
{
"Field": "website",
"Type": "varchar(100)",
"Null": "YES",
"Key": "",
"Default": null,
"Extra": "",
"mytype": "VARCHAR",
"size": 100,
"fieldname": "website",
"myextra": ""
},
{
"Field": "fax",
"Type": "varchar(50)",
"Null": "YES",
"Key": "",
"Default": null,
"Extra": "",
"mytype": "VARCHAR",
"size": 50,
"fieldname": "fax",
"myextra": ""
},
{
"Field": "facebook",
"Type": "varchar(100)",
"Null": "YES",
"Key": "",
"Default": null,
"Extra": "",
"mytype": "VARCHAR",
"size": 100,
"fieldname": "facebook",
"myextra": ""
},
{
"Field": "memo",
"Type": "text",
"Null": "YES",
"Key": "",
"Default": null,
"Extra": "",
"mytype": "TEXT",
"size": 0,
"fieldname": "memo",
"myextra": ""
},
{
"Field": "categoryID",
"Type": "int(10)",
"Null": "YES",
"Key": "",
"Default": null,
"Extra": "",
"mytype": "INT",
"size": 10,
"fieldname": "categoryID",
"myextra": ""
},
{
"Field": "representativeID",
"Type": "int(10)",
"Null": "YES",
"Key": "",
"Default": null,
"Extra": "",
"mytype": "INT",
"size": 10,
"fieldname": "representativeID",
"myextra": ""
},
{
"Field": "estimatedturnover",
"Type": "decimal(10,2)",
"Null": "YES",
"Key": "",
"Default": null,
"Extra": "",
"mytype": "DECIMAL",
"size": 10,
"fieldname": "estimatedturnover",
"myextra": ""
},
{
"Field": "firstcontact",
"Type": "date",
"Null": "YES",
"Key": "",
"Default": null,
"Extra": "",
"mytype": "DATE",
"size": 0,
"fieldname": "firstcontact",
"myextra": ""
},
{
"Field": "datetimecreated",
"Type": "datetime",
"Null": "NO",
"Key": "",
"Default": null,
"Extra": "",
"mytype": "DATETIME",
"size": 0,
"fieldname": "datetimecreated",
"myextra": ""
},
{
"Field": "creatorID",
"Type": "int(10)",
"Null": "NO",
"Key": "",
"Default": null,
"Extra": "",
"mytype": "INT",
"size": 10,
"fieldname": "creatorID",
"myextra": "",
"noupdate": 1,
"noinsert": 1
}
],
"tabulator": {
"columns": [
{
"title": "accountID",
"field": "accountID",
"headerFilter": true,
"hozAlign": "right",
"width": "80",
"visible": false
},
{
"title": "accountnumber",
"field": "accountnumber",
"headerFilter": true
},
{
"title": "name1",
"field": "name1",
"headerFilter": true
},
{
"title": "name2",
"field": "name2",
"headerFilter": true
},
{
"title": "street",
"field": "street",
"headerFilter": true
},
{
"title": "country",
"field": "country",
"headerFilter": true
},
{
"title": "code",
"field": "code",
"headerFilter": true
},
{
"title": "city",
"field": "city",
"headerFilter": true
},
{
"title": "phone",
"field": "phone",
"headerFilter": true
},
{
"title": "mobile",
"field": "mobile",
"headerFilter": true,
"visible": false
},
{
"title": "email",
"field": "email",
"headerFilter": true,
"visible": false
},
{
"title": "website",
"field": "website",
"headerFilter": true,
"visible": false
},
{
"title": "fax",
"field": "fax",
"headerFilter": true,
"visible": false
},
{
"title": "facebook",
"field": "facebook",
"headerFilter": true,
"visible": false
},
{
"title": "memo",
"field": "memo",
"headerFilter": true,
"visible": false
},
{
"title": "categoryID",
"field": "categoryID",
"headerFilter": true,
"hozAlign": "right",
"width": "80",
"visible": false
},
{
"title": "representativeID",
"field": "representativeID",
"headerFilter": true,
"hozAlign": "right",
"width": "80",
"visible": false
},
{
"title": "estimatedturnover",
"field": "estimatedturnover",
"headerFilter": true,
"hozAlign": "right",
"width": "80",
"formatter": "money",
"formatterParams": {
"decimal": "GLOBALS_decimal_point",
"thousand": "GLOBALS_thousands_sep",
"precision": "2"
},
"visible": false
},
{
"title": "firstcontact",
"field": "firstcontact",
"headerFilter": "input",
"width": 120,
"formatter": "datetime",
"formatterParams": {
"inputFormat": "yyyy-MM-dd",
"outputFormat": "GLOBALS_tabulatordateformat"
},
"visible": false
},
{
"title": "datetimecreated",
"field": "datetimecreated",
"headerFilter": "input",
"width": 160,
"formatter": "datetime",
"formatterParams": {
"inputFormat": "yyyy-MM-dd HH:mm:ss",
"outputFormat": "GLOBALS_tabulatordatetimeformat"
},
"visible": false
},
{
"title": "creatorID",
"field": "creatorID",
"headerFilter": true,
"hozAlign": "right",
"width": "80",
"visible": false
}
]
},
"k8form": {
"selector": ".js_dataform",
"templatetype": "masterform",
"fields": [
{
"name": "accountID",
"type": "hidden",
"label": "accountID"
},
{
"name": "accountnumber",
"type": "text",
"label": "accountnumber",
"attributes": {
"maxlength": 50
}
},
{
"name": "name1",
"type": "text",
"label": "name1",
"attributes": {
"maxlength": 50
}
},
{
"name": "name2",
"type": "text",
"label": "name2",
"attributes": {
"maxlength": 50
}
},
{
"name": "street",
"type": "text",
"label": "street",
"attributes": {
"maxlength": 50
}
},
{
"name": "country",
"type": "text",
"label": "country",
"attributes": {
"maxlength": 10
}
},
{
"name": "code",
"type": "text",
"label": "code",
"attributes": {
"maxlength": 10
}
},
{
"name": "city",
"type": "text",
"label": "city",
"attributes": {
"maxlength": 50
}
},
{
"name": "phone",
"type": "text",
"label": "phone",
"attributes": {
"maxlength": 50
}
},
{
"name": "mobile",
"type": "text",
"label": "mobile",
"attributes": {
"maxlength": 50
}
},
{
"name": "email",
"type": "text",
"label": "email",
"attributes": {
"maxlength": 250
}
},
{
"name": "website",
"type": "text",
"label": "website",
"attributes": {
"maxlength": 100
}
},
{
"name": "fax",
"type": "text",
"label": "fax",
"attributes": {
"maxlength": 50
}
},
{
"name": "facebook",
"type": "text",
"label": "facebook",
"attributes": {
"maxlength": 100
}
},
{
"name": "memo",
"tagName": "textarea",
"label": "memo"
},
{
"name": "categoryID",
"type": "number",
"label": "categoryID"
},
{
"name": "representativeID",
"type": "number",
"label": "representativeID"
},
{
"name": "estimatedturnover",
"type": "number",
"label": "estimatedturnover"
},
{
"name": "firstcontact",
"type": "date",
"label": "firstcontact"
}
]
}
}
the copy clipboard method is not supported in IE8 and earlier.