Dans cet article
In Banana Accounting javascript extensions, when referring to tables and columns, you must always use the correct nameXml.
Each table and each column has a proper nameXml. With the nameXml, tables and columns can be accessed to read the data they contain.
All columns of Documents table are shown below with their nameXml.
Documents table
The Documents table is used to include attachments like images, logos, text documents, HTML codes, Markdown codes, CSS stylesheet codes and Javascript Extensions codes.
All nameXml of the table columns are listed below:
- SysCod
- Links
- Section
- RowId
This column is used to indicate the identification of the row. - Description
This column is used to indicate a description for the row. - Attachments
This column is used to include an attachment. - ArchivedDate
- ArchivedNotes
Documents columns structure
The list of columns is shown below in JSON format, with also additional information for each column.
{
"nameXml": "Documents",
"columns": [
{
"nameXml": "SysCod",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "",
"excludeFromPrinting": "",
"header": "SysCod",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 100
},
{
"nameXml": "Links",
"alignment": "left",
"dataType": "links",
"decimal": "",
"description": "Links to external documents",
"excludeFromPrinting": "",
"header": "Links",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 600
},
{
"nameXml": "Section",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "",
"excludeFromPrinting": "",
"header": "Section",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 120
},
{
"nameXml": "RowId",
"alignment": "center",
"dataType": "text",
"decimal": "",
"description": "Row Id",
"excludeFromPrinting": "",
"header": "Id",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": true,
"width": 400
},
{
"nameXml": "Description",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "",
"excludeFromPrinting": "",
"header": "Description",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": true,
"width": 600
},
{
"nameXml": "Attachments",
"alignment": "left",
"dataType": "mime",
"decimal": "",
"description": "Attachments",
"excludeFromPrinting": "",
"header": "Attachments",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": true,
"width": 600
},
{
"nameXml": "ArchivedDate",
"alignment": "right",
"dataType": "date",
"decimal": "",
"description": "Archived date",
"excludeFromPrinting": "",
"header": "Arch.Date",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 200
},
{
"nameXml": "ArchivedNotes",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "Archived notes",
"excludeFromPrinting": "",
"header": "Archived Notes",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 600
}
]
}