CARecon

PX.Objects.CA

41 of 41 fields

	Field Name	Type	Display Name	Foreign Key
	`CashAccountID`Default Navigation	`int`	Cash Account	CashAccount
Description:The cash account under reconciliation.
	`ReconNbr`Default Navigation	`nvarchar(15)`	Ref. Number	-
Description:No description available
	`Approved`	`bit`		-
Description:An indicator of whether the current reconciliation statement has been approved.
	`CountCredit`	`int`	Disbursement Count	-
Description:The number of reconciled disbursements.
	`CountDebit`	`int`	Receipt Count	-
Description:The number of reconciled receipts.
	`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
	`CuryBalance`	`decimal(19, 4)`	Statement Balance	-
Description:The balance of the current bank statement in the selected currency, which user should enter manually for the current reconciliation statement.
	`CuryBegBalance`	`decimal(19, 4)`	Beginning Balance	-
Description:The balance of the previous reconciliation statement in the selected currency. The value of the field defaults to the reconciled balance of the previous statement.
	`CuryDiffBalance`	`decimal(19, 6)`	Difference	-
Description:The difference between the reconciled balance and the statement balance.
	`CuryID`Default Navigation	`nvarchar(5)`	Currency	Currency
Description:The currency of the cash account.
	`CuryInfoID`	`bigint`		CurrencyInfo
Description:Identifier of the CurrencyInfo object associated with the reconciliation statement. Corresponds to the CurrencyInfo.CurrencyInfoID field. The value is generated automatically.
	`CuryReconciledBalance`	`decimal(19, 6)`	Reconciled Balance	-
Description:The beginning balance of the statement plus the cleared receipts minus the cleared disbursements.
	`CuryReconciledCredits`	`decimal(19, 6)`	Reconciled Disb.	-
Description:The total amount of reconciled disbursements on the statement in the selected currency.
	`CuryReconciledDebits`	`decimal(19, 6)`	Reconciled Receipts	-
Description:The total amount of reconciled receipts on the statement in the selected currency.
	`CuryReconciledTurnover`Nonexistent in DB	`unspecified`	Reconciled Turnover	-
Description:Turnover of the reconciliation statement in the selected currency. Equals the following value: CARecon.CuryReconciledDebits minus CARecon.CuryReconciledCredits.
	`EmployeeID`Default Navigation	`int`	Owner	EPEmployee
Description:The ID of the user who created the cash transaction.
	`ExcludeFromApproval`	`bit`		-
Description:An indicator of whether the current reconciliation statement should be excluded from the approval process. This property is maintained on the graph level.
	`Hold`	`bit`	Hold	-
Description:Indicates (if set to "true") that the reconciliation statement is on hold and can be saved unbalanced.
	`IsUserLoadDocumentsTill`Nonexistent in DB	`bit`		-
Description:The field indicates if user set LoadDocumentsTill, or was it set by CAOptimizeLoadDateAttribute.
	`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
	`LastReconDate`	`datetime2`	Last Reconciliation Date	-
Description:The date of the most recent CARecon for this cash account, if one exists.
	`LoadDocumentsTill`Nonexistent in DB	`datetime`	Load Documents Up To	-
Description:The latest date for documents to be loaded to the list.
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`OwnerID`Default NavigationNonexistent in DB	`int`	Approver	Contact
Description:The ID of the employee who was assigned to approve the transaction.
	`Reconciled`	`bit`	Reconciled	-
Description:Indicates (if set to "true") that the reconciliation statement was completed and cannot be edited anymore.
	`ReconciledCredits`	`decimal(19, 6)`	Reconciled Disb.	-
Description:The total amount of reconciled disbursements on the statement in the base currency.
	`ReconciledDebits`	`decimal(19, 6)`	Reconciled Receipts	-
Description:The total amount of reconciled receipts on the statement in the base currency.
	`ReconciledTurnover`Nonexistent in DB	`unspecified`	Reconciled Turnover	-
Description:Turnover of the reconciliation statement in the base currency. Equals the following value: CARecon.ReconciledDebits minus CARecon.ReconciledCredits.
	`ReconDate`	`datetime2`	Reconciliation Date	-
Description:The date when the reconciliation statement was released and closed. A user can change the date up to the release.
	`Rejected`	`bit`		-
Description:An indicator of whether the current reconciliation statement has been rejected.
	`Selected`Nonexistent in DB	`bit`	Selected	-
Description:No description available
	`ShowBatchPayments`	`bit`	Bank Transactions Are Matched to Batch Payments	-
Description:Specifies (if set to "true") that all transactions included in the batch are considered as a single transaction. Defaults to the value of CashAccount.MatchToBatch.
	`SkipVoided`	`bit`	Voided Transactions Are Skipped	-
Description:Specifies (if set to "true") that the direct transaction and the reversing transaction are considered as a single transaction. Defaults to the value of CASetup.SkipVoided. The CAReconEntry.Skip(CATran, CATran, bool) method is used to determine whether both transactions (CATran) are shown on the form or only the aggregated one is shown.
	`Status`	`char(1)`	Status	-
Description:No description available
	`tstamp`	`timestamp`		-
Description:No description available
	`Voided`	`bit`	Voided	-
Description:Indicates (if set to "true") that the reconciliation statement was voided.
	`WorkgroupID`Default NavigationNonexistent in DB	`int`	Approval Workgroup ID	EPCompanyTree
Description:The ID of the workgroup that was assigned to approve the transaction.