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 |