JournalItems
Journal line items.
Table Specific Information
Select
The connector will process all filters client side.
Columns
Name | Type | References | Description |
JournalID [KEY] | Uuid | Unique identifier in the form of a guid. | |
Amount | Double | Dollar amount posted to the line of the transaction. | |
IsCredit | Boolean | True indicates the amount posted to the account as a credit. False indicates the amount posted to the account as a debit. | |
IsOverriddenTaxAmount | Boolean | True indicates the tax amount has been altered. False indicates the tax amount has not been altered. | |
Memo | String | Memo text applied to the line of the transaction. | |
RowID [KEY] | Integer | Sequence of the entry within the general journal set. | |
TaxAmount | Double | Tax amount for the line of the journal if using an applicable TaxCode. | |
RowVersion | String | Row version for the item. Required to udpate an existing line. | |
AccountID | Uuid |
Accounts.ID | Unique identifier for the account in the form of a guid. |
AccountDisplayID | String | Account code. Format includes separator ie 4-1100 | |
AccountName | String | Name of the account. | |
AccountURI | String | Uniform resource identifier associated with the account object. | |
JobID | Uuid |
Jobs.ID | Unique job identifier in the form of a guid. |
JobNumber | String | Number assigned to the job. | |
JobName | String | Name assigned to the job. | |
JobURI | String | Uniform resource identifier associated with the job object. | |
TaxCodeID | Uuid |
TaxCodes.ID | Unique guid identifier belonging to the assigned tax code. |
TaxCodeCode | String | 3 digit tax code. | |
TaxCodeURI | String | Uniform resource identifier associated with the tax code object. |