PDFTemplates
Create, update, delete, and query PDFTemplates table.
Table Specific Information
Select
You can query the PDFTemplates table using any criteria in the WHERE clause. The connector will use the SuiteCRM API to filter the results.
SELECT * FROM [PDF Templates] WHERE Active = true
Insert
Create a pdf template by specifying any writable column.
INSERT INTO [PDF Templates] (Active, Name) VALUES (true, 'Test Template')
Update
You can update any pdf template column that is writable, by specifying the Id.
UPDATE [PDF Templates] SET Active = false WHERE Id = '6e1d3749-7e1c-f19c-251d-5b855e30b695'
Delete
Remove a pdf template by specifying the Id.
DELETE FROM [PDF Templates] WHERE Id = '5fddceac-8715-d1f1-efa3-5b854ab921a6'
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | String | False |
The unique identifier for the pdf template. |
| Active | Bool | False |
Whether or not the template is active. |
| Assigned_to | String | False |
The assignee of the template. |
| Assigned_User_Id | String | False |
The unique identifier of the assignee. |
| Body | String | False |
Content of the template's body. |
| Created_By | String | False |
The Id of the user who created the template. |
| Created_By2 | String | False |
The name of the user who created the template. |
| Date_Created | Datetime | False |
Date when the template was created. |
| Date_Modified | Datetime | False |
Date when the template was modified. |
| Deleted | Bool | False |
Whether the template was deleted. |
| Footer | String | False |
The content of the template's footer. |
| Header | String | False |
The content of the template's header. |
| Insert_Fields | String | False |
The fields that can be inserted. |
| Load_Sample | String | False |
The content of the template's sample. |
| Margin_Bottom | Int | False |
Value of the bottom margin for the template. |
| Margin_Footer | Int | False |
Value of the margin for the template's footer. |
| Margin_Header | Int | False |
Value of the margin for the template's header. |
| Margin_Left | Int | False |
Value of the left margin for the template. |
| Margin_Right | Int | False |
Value of the right margin for the template. |
| Margin_Top | Int | False |
Value of the top margin for the template. |
| Modified_By | String | False |
The Id of the user who modified the template. |
| Modified_By2 | String | False |
The name of the user who modified the template. |
| Name | String | False |
The template's name. |
| Orientation | String | False |
Orientation of the template. |
| Page_Size | String | False |
The size of the template. |
| Type | String | False |
The type of the template. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Rows@Next | String |
Identifier for the next page of results. Do not set this value manually. |