JDBC Driver for Exact Online

Build 24.0.9060

GeneralJournalEntryLines

Usage information for the operation GeneralJournalEntryLines.rsd.

Columns

Name Type ReadOnly Description
ID [KEY] String True

The ID column for the table GeneralJournalEntryLines.

Account String False

The Account column for the table GeneralJournalEntryLines.

AccountCode String False

The AccountCode column for the table GeneralJournalEntryLines.

AccountName String False

The AccountName column for the table GeneralJournalEntryLines.

AmountDC Double False

The AmountDC column for the table GeneralJournalEntryLines.

AmountFC Double False

The AmountFC column for the table GeneralJournalEntryLines.

AmountVATDC Double False

The AmountVATDC column for the table GeneralJournalEntryLines.

AmountVATFC Double False

The AmountVATFC column for the table GeneralJournalEntryLines.

Asset String False

The Asset column for the table GeneralJournalEntryLines.

AssetCode String False

The AssetCode column for the table GeneralJournalEntryLines.

AssetDescription String False

The AssetDescription column for the table GeneralJournalEntryLines.

CostCenter String False

The CostCenter column for the table GeneralJournalEntryLines.

CostCenterDescription String False

The CostCenterDescription column for the table GeneralJournalEntryLines.

CostUnit String False

The CostUnit column for the table GeneralJournalEntryLines.

CostUnitDescription String False

The CostUnitDescription column for the table GeneralJournalEntryLines.

Created Datetime False

The Created column for the table GeneralJournalEntryLines.

Creator String False

The Creator column for the table GeneralJournalEntryLines.

CreatorFullName String False

The CreatorFullName column for the table GeneralJournalEntryLines.

Date Datetime False

The Date column for the table GeneralJournalEntryLines.

Description String False

The Description column for the table GeneralJournalEntryLines.

Division Int False

The Division column for the table GeneralJournalEntryLines.

Document String False

The Document column for the table GeneralJournalEntryLines.

DocumentNumber Int False

The DocumentNumber column for the table GeneralJournalEntryLines.

DocumentSubject String False

The DocumentSubject column for the table GeneralJournalEntryLines.

EntryID String False

The EntryID column for the table GeneralJournalEntryLines.

EntryNumber Int False

The EntryNumber column for the table GeneralJournalEntryLines.

GLAccount String False

The GLAccount column for the table GeneralJournalEntryLines.

GLAccountCode String False

The GLAccountCode column for the table GeneralJournalEntryLines.

GLAccountDescription String False

The GLAccountDescription column for the table GeneralJournalEntryLines.

LineNumber Int False

The LineNumber column for the table GeneralJournalEntryLines.

Modified Datetime False

The Modified column for the table GeneralJournalEntryLines.

Modifier String False

The Modifier column for the table GeneralJournalEntryLines.

ModifierFullName String False

The ModifierFullName column for the table GeneralJournalEntryLines.

Notes String False

The Notes column for the table GeneralJournalEntryLines.

OffsetID String False

The OffsetID column for the table GeneralJournalEntryLines.

OurRef Int False

The OurRef column for the table GeneralJournalEntryLines.

Project String False

The Project column for the table GeneralJournalEntryLines.

ProjectCode String False

The ProjectCode column for the table GeneralJournalEntryLines.

ProjectDescription String False

The ProjectDescription column for the table GeneralJournalEntryLines.

Quantity Double False

The Quantity column for the table GeneralJournalEntryLines.

VATBaseAmountDC Double False

The VATBaseAmountDC column for the table GeneralJournalEntryLines.

VATBaseAmountFC Double False

The VATBaseAmountFC column for the table GeneralJournalEntryLines.

VATCode String False

The VATCode column for the table GeneralJournalEntryLines.

VATCodeDescription String False

The VATCodeDescription column for the table GeneralJournalEntryLines.

VATPercentage Double False

The VATPercentage column for the table GeneralJournalEntryLines.

VATType String False

The VATType column for the table GeneralJournalEntryLines.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060