CABatch

PX.Objects.CA

39 of 39 fields

	Field Name	Type	Display Name	Foreign Key
	`BatchNbr`Default Navigation	`nvarchar(15)`	Reference Nbr.	-
Description:The user-friendly unique identifier of the batch number. This field is the key field.
	`BatchSeqNbr`	`nvarchar(15)`	Batch Seq. Number	-
Description:The unique number automatically assigned to the batch.
	`BranchID`Default Navigation	`int`	Branch	Branch
Description:No description available
	`Canceled`	`bit`	Canceled	-
Description:Specifies (if set to "true") that the batch is canceled and its details were removed.
	`CashAccountID`Default Navigation	`int`	Cash Account	CashAccount
Description:No description available
	`ClearDate`	`datetime2`	Clear Date	-
Description:The date when the document was cleared.
	`Cleared`	`bit`	Cleared	-
Description:Specifies (if set to "true") that the document was cleared with the reconciliation source, generally based on preliminary information.
	`CountOfPayments`	`int`	Payment Count	-
Description:No description available
	`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
	`CuryDetailTotal`	`decimal(19, 4)`	Batch Total	-
Description:The total amount for the batch, calculated as the sum of all payment amounts in the selected currency.
	`CuryID`Default Navigation	`nvarchar(5)`	Currency	Currency
Description:The currency of the payment. Corresponds to the currency of the cash account. Depends on the CABatch.CashAccountID field.
	`DateSeqNbr`	`smallint`	Seq. Number Within Day	-
Description:The unique number automatically assigned to the batch to distinguish it from other batches generated during the same day.
	`DetailTotal`	`decimal(19, 4)`		-
Description:The total amount for the batch, calculated as the sum of all payment amounts in the base currency.
	`Exported`	`bit`	Exported	-
Description:Specifies (if set to "true") that the batch is exported.
	`ExportFileName`	`nvarchar(60)`	Exported File Name	-
Description:The name of the exported file.
	`ExportTime`	`datetime2`	File Export Time	-
Description:The time when the export was performed.
	`ExtRefNbr`	`nvarchar(40)`	Document Ref.	-
Description:Any document that holds information about the batch as required by your company's internal policies.
	`Hold`	`bit`	Hold	-
Description:Specifies (if set to "true") that the batch is on hold and cannot be exported.
	`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
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`OrigModule`	`char(2)`	Module	-
Description:Module from which the document originates.
	`PaymentMethodID`Default Navigation	`nvarchar(10)`	Payment Method	PaymentMethod
Description:The payment method associated with the cash account. Only payment methods that allow batch creation appear in the list. Payment methods are defined on the Payment Methods (CA204000) form.
	`Reconciled`	`bit`		-
Description:Specifies (if set to "true") that the document is included in the reconciliation statement as a reconciled document. This field can be set to "true" only for batches for the cash accounts that have CashAccount.MatchToBatch set to true.
	`ReconDate`	`datetime2`		-
Description:The date when the document was reconciled.
	`ReconNbr`	`nvarchar(15)`		CARecon
Description:If the document was reconciled, the field contains the number of the reconciliation that includes this document.
	`ReferenceID`Default Navigation	`int`	Bank	BAccount
Description:No description available
	`Released`	`bit`	Released	-
Description:Specifies (if set to "true") that the batch is released.
	`SkipExport`	`bit`	Release Batch Payment Before Export	-
Description:Specifies what workflow is applied to the batch: if set to "true" the batch should it be exported before release.. if set to "false" the batch should it be released before export.
	`Status`Nonexistent in DB	`nchar(1)`	Status	-
Description:The status of the batch, which the system assigns automatically. This is a virtual field and it has no representation in the database. A batch can have one of the following statuses: ""H"": On Hold, ""B"": Balanced, ""R"": Released.
	`Total`Nonexistent in DB	`decimal`		-
Description:No description available
	`TranDate`	`datetime2`	Batch Date	-
Description:The date when the batch was created.
	`TranDesc`	`nvarchar(256)`	Description	-
Description:A description of the batch, which may help to identify it.
	`tstamp`	`timestamp`		-
Description:No description available
	`VoidDate`	`datetime`	Void Date	-
Description:The date when the batch payments was voided.
	`Voided`	`bit`	Voided	-
Description:Specifies (if set to "true") that the batch is voided.