GLTransactionLines
Return a list of: GLTransactionLines
Columns
| Name | Type | Description |
| ExtensionsExtensionAggregate | String | |
| AuditTrailCode | String | |
| BatchKeyCreatedDateTime | Datetime | |
| BatchId | String | |
| BatchKeySource | String | |
| CurrencyKeyISOCode | String | |
| ExchangeDate | Datetime | |
| ExchangeRate | Decimal | |
| IntercompanyId | Int | |
| IntercompanyOriginalJournalId | Int | |
| IsVoided | Bool | |
| KeyDate | Datetime | |
| KeyJournalId | Int | |
| LedgerType | String | |
| LinesExtensionsExtensionAggregate | String | |
| LinesDescription | String | |
| LinesExchangeDate | Datetime | |
| LinesExchangeRate | Decimal | |
| LinesGLAccountId | String | |
| LinesGLAccountKeyIsEncrypted | Bool | |
| LinesIntercompanyId | Int | |
| LinesKeySequenceNumber [KEY] | Int | |
| LinesKeyTransactionKeyDate [KEY] | Datetime | |
| LinesKeyTransactionKeyJournalId [KEY] | Int | |
| LinesOriginatingDocumentControlId | String | |
| LinesOriginatingDocumentDescription | String | |
| LinesOriginatingDocumentId | String | |
| LinesOriginatingDocumentMasterId | String | |
| LinesOriginatingDocumentMasterName | String | |
| LinesOriginatingDocumentSequenceNumber | Int | |
| LinesOriginatingDocumentType | Int | |
| LinesTaxAmountCurrency | String | |
| LinesTaxAmount | Decimal | |
| LinesTaxDetailId | String | |
| LinesTaxGLAccountId | String | |
| LinesTaxGLAccountKeyIsEncrypted | Bool | |
| ModifiedBy | String | |
| ModifiedDate | Datetime | |
| OriginatingDocumentAuditTrailCode | String | |
| OriginatingDocumentPostedDate | Datetime | |
| OriginatingDocumentSeries | String | |
| PostedBy | String | |
| Reference | String | |
| SourceDocumentId | String | |
| TransactionState | String |
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 |
| PagingColumn | String |