Templates
Query Reckon templates.
Columns
Name | Type | References | Description |
ID [KEY] | String | The unique identifier of the template. | |
Name | String | The name of the template. | |
IsActive | Boolean | Boolean determining if the template is active. | |
TemplateType | String | The type of template. This may be BuildAssembly, CreditMemo, Estimate, Invoice, PurchaseOrder, SalesOrder, or SalesReceipt. | |
EditSequence | String | A string indicating the revision of the template. | |
TimeCreated | Datetime | The time the template was created. | |
TimeModified | Datetime | The last time the template was modified. |
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 | |
StartModifiedDate | String | This pseudo column is deprecated and should no longer be used. Earliest modified date to search for (in yyyy-MM-dd, MM-dd-yy, MM-dd-yyyy, MM/dd/yy, or MM/dd/yyyy format) | |
EndModifiedDate | String | This pseudo column is deprecated and should no longer be used. Latest modified date to search for (in yyyy-MM-dd, MM-dd-yy, MM-dd-yyyy, MM/dd/yy, or MM/dd/yyyy format). | |
NameMatch | String | This pseudo column is deprecated and should no longer be used. The type of match to use if specifying the name.
The allowed values are CONTAINS, EXACT, STARTSWITH, ENDSWITH. | |
ActiveStatus | String | This pseudo column is deprecated and should no longer be used. Limits the search to active or inactive records only or all records.
The allowed values are ACTIVE, INACTIVE, ALL, NA. The default value is ALL. |