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.
使用できる値は次のとおりです。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.
使用できる値は次のとおりです。ACTIVE, INACTIVE, ALL, NA デフォルト値はALLです。 |