GLDocBatch

PX.Objects.GL

34 of 34 fields

	Field Name	Type	Display Name	Foreign Key
	`BatchNbr`Default Navigation	`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.
	`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".
	`BatchType`	`varchar(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`Default Navigation	`int`	Branch	Branch
Description:Identifier of the Branch, to which the batch belongs. Corresponds to the Branch.BranchID field.
	`ControlTotal`	`decimal(19, 4)`	Control Total	-
Description:The control total of the batch in the base currency of the company. See also CuryControlTotal.
	`CreatedByID`Default Navigation	`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(19, 4)`		-
Description:The total credit amount of the batch in the base currency of the company. See also CuryCreditTotal.
	`CuryControlTotal`	`decimal(19, 4)`	Control Total	-
Description:The control total of the batch in its currency.
	`CuryCreditTotal`	`decimal(19, 4)`	Credit Total	-
Description:The total credit amount of the batch in its currency. See also CreditTotal.
	`CuryDebitTotal`	`decimal(19, 4)`	Debit Total	-
Description:The total debit amount of the batch in its currency. See also DebitTotal.
	`CuryID`Default Navigation	`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`	`datetime2`	Transaction Date	-
Description:The date of the batch, specified by user. Defaults to the current Business Date.
	`DebitTotal`	`decimal(19, 4)`		-
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`Default Navigation	`char(6)`	Post Period	-
Description:No description available
	`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`Default Navigation	`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`Default Navigation	`int`	Ledger	Ledger
Description:No description available
	`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.
	`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)`		-
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.
	`Selected`Nonexistent in DB	`bit`	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`	`char(6)`		-
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.
	`tstamp`	`timestamp`		-
Description:No description available
	`Voided`	`bit`		-
Description:Indicates whether the batch has been voided.