GL
GLDocBatch
Represents a batch of documents edited through the Journal Vouchers (GL304000) form.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BatchNbr | nvarchar(15) | Batch Number | - | |
Description:Key field. Auto-generated unique number of the document batch. The number is generated from the Numbering Sequence specified in the GLSetup.DocBatchNumberingID field of the GL preferences record. | ||||
BatchType | nvarchar(3) | Type | - | |
Description:The type of the batch. Allowed values are: ""H"" - Normal, ""R"" - Recurring, ""C"" - Consolidation, ""T"" - Trial Balance, ""RCL"" - Reclassification. Defaults to ""H"" - Normal. | ||||
BranchID | int | Branch | Branch | |
Description:Identifier of the Branch, to which the batch belongs. Corresponds to the Branch.BranchID field. | ||||
ControlTotal | decimal | Control Total | - | |
Description:The control total of the batch in the base currency of the company. See also CuryControlTotal. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
CreditTotal | decimal | - | ||
Description:The total credit amount of the batch in the base currency of the company. See also CuryCreditTotal. | ||||
CuryControlTotal | decimal | Control Total | - | |
Description:The control total of the batch in its currency. | ||||
CuryCreditTotal | decimal | Credit Total | - | |
Description:The total credit amount of the batch in its currency. See also CreditTotal. | ||||
CuryDebitTotal | decimal | Debit Total | - | |
Description:The total debit amount of the batch in its currency. See also DebitTotal. | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:The code of the Currency of the batch. Defaults to the base currency of the company. | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:Identifier of the CurrencyInfo record associated with the batch. Corresponds to the PCurrencyInfo.CurrencyInfoID field. | ||||
DateEntered | datetime | Transaction Date | - | |
Description:The date of the batch, specified by user. Defaults to the current Business Date. | ||||
DebitTotal | decimal | - | ||
Description:The total debit amount of the batch in the base currency of the company. See also CuryDebitTotal. | ||||
Description | nvarchar(255) | Description | - | |
Description:The description of the batch. | ||||
FinPeriodID | string | Post Period | FinPeriod | |
Description:Identifier of the Financial Period, to which the batch belongs. By default the period is deducted from the date of the batch. Can be overriden by user. | ||||
Hold | bit | Hold | - | |
Description:Indicates whether the batch is on hold. Defaults to "true", if the GLSetup.VouchersHoldEntry flag is set in the preferences of the module, and to "false" otherwise. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
LedgerID | int | Ledger | Ledger | |
Description:Identifier of the Ledger, to which the batch belongs. Corresponds to the Ledger.LedgerID field. | ||||
LineCntr | int | - | ||
Description:The counter of the document lines, used internally to assign consistent numbers to newly created lines. It is not recommended to rely on this field to determine the exact count of lines, because it might not reflect the latter under some conditions. | ||||
Module | char(2) | Module | - | |
Description:The code of the module, to which the batch belongs. Defaults to "GL". Allowed values are: "GL", "AP", "AR", "CM", "CA", "IN", "DR", "FA", "PM", "TX", "SO", "PO". | ||||
NoteID | uniqueidentifier | - | ||
Description:Identifier of the Note object, associated with the document. Corresponds to the Note.NoteID field. | ||||
OrigBatchNbr | nvarchar(15) | Orig. Batch Number | Batch | |
Description:The number of the batch, from which this batch originates. | ||||
OrigModule | char(2) | Batch | ||
Description:The code of the module, from which the batch originates. | ||||
Posted | bit | - | ||
Description:Indicates whether the batch has been posted. | ||||
Released | bit | - | ||
Description:Indicates whether the batch has been released. | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:Indicates whether the record is selected for mass processing or not. | ||||
Status | char(1) | Status | - | |
Description:Read-only field reflecting the status of the batch. The value of the field can not be changed directly and depends on the status flags of the batch: Posted, Voided, Released, Hold. Possible values are: ""H"" - Hold, ""B"" - Balanced, ""C"" - Completed, ""V"" - Voided, ""R"" - Released. | ||||
TranPeriodID | string | - | ||
Description:Identifier of the Financial Period of the batch. Determined by the date of the batch. Unlike the FinPeriodID field, the value of this field can't be overriden by user and always reflects the period corresponding to the date of the batch. | ||||
Voided | bit | - | ||
Description:Indicates whether the batch has been voided. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||