ManualJournals
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | String | True | The journal line index combined with the Id of the manual journal. |
ManualJournalId | String | False | The Id of the manual journal. |
Narration | String | False | A description of the journal being posted. |
JournalLine_LineAmount | Decimal | False | The total for the line item. This value is positive for debits and negative for credits. |
JournalLine_AccountCode | String | False | The account code that identifies the account. |
JournalLine_Description | String | False | The description for the manual journal. |
JournalLine_TaxType | String | False | This field can be used to override the default tax code for the selected account. |
JournalLine_TrackingCategory1_CategoryId | String | False | The Id of a tracking category. The API allows two optional tracking categories to be defined. |
JournalLine_TrackingCategory1_CategoryName | String | False | The name of a tracking category. The API allows two optional tracking categories to be defined. |
JournalLine_TrackingCategory1_OptionId | String | False | The Id of a tracking category. The API allows two optional tracking categories to be defined. |
JournalLine_TrackingCategory1_OptionName | String | False | The option of a tracking category. The API allows two optional tracking categories to be defined. |
JournalLine_TrackingCategory1_Option_Stat | String | False | The status of a tracking category. The API allows two optional tracking categories to be defined. |
JournalLine_TrackingCategory2_CategoryId | String | False | The Id of a tracking category. The API allows two optional tracking categories to be defined. |
JournalLine_TrackingCategory2_CategoryName | String | False | The name of a tracking category. The API allows two optional tracking categories to be defined. |
JournalLine_TrackingCategory2_OptionId | String | False | The Id of a tracking category. The API allows two optional tracking categories to be defined. |
JournalLine_TrackingCategory2_OptionName | String | False | The option of a tracking category. The API allows two optional tracking categories to be defined. |
JournalLine_TrackingCategory2_Option_Stat | String | False | The status of a tracking category. The API allows two optional tracking categories to be defined. |
JournalLineAggregate | String | False | Used to define JournalLine rows using XML values. Should be provided on INSERT only. |
Date | Date | False | The date the journal was posted. |
Status | String | False | The status code for the manual journal. The valid values are VALID, POSTED, DELETED, and VOIDED. |
URL | String | False | A link to a source document. |
ShowOnCashBasisReports | Boolean | False | This field indicates whether this journal should be included on cash-basis reports. The default value is true. |
LineAmountTypes | String | False | The line amount type, which specifies whether line amounts include tax (default). When this field is not specified, line amount totals do not include tax. The valid values are Exclusive, Inclusive, and NoTax. |
UpdatedDateUTC | Datetime | True | The date when the manual journal was last updated. |
HasAttachments | Boolean | True | This field indicates whether the invoice has an attachment. |
TenantId | String | False | The ID of the tenant to query instead of the connection tenant |
Last updated