Skip to main content
CA

CARecon

PX.Objects.CAScreenCA302000Release 2025.2

The header of the reconciliation statement. Reconciliation statements are edited on the Reconciliation Statements (CA302000) form (which corresponds to the CAReconEntry graph).

Field NameTypeDisplay NameForeign Key
Approved
bit-
Description:An indicator of whether the current reconciliation statement has been approved.
CashAccountIDDefault Navigation
intCash AccountCashAccount
Description:The cash account under reconciliation.
CountCredit
intDisbursement Count-
Description:The number of reconciled disbursements.
CountDebit
intReceipt Count-
Description:The number of reconciled receipts.
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime
datetimeCreated On-
Description:No description available
CuryBalance
decimalStatement Balance-
Description:The balance of the current bank statement in the selected currency, which user should enter manually for the current reconciliation statement.
CuryBegBalance
decimalBeginning 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
decimalDifference-
Description:The difference between the reconciled balance and the statement balance.
CuryIDDefault Navigation
nvarchar(5)CurrencyCurrency
Description:The currency of the cash account.
CuryInfoID
bigintCurrencyInfo
Description:Identifier of the CurrencyInfo object associated with the reconciliation statement. Corresponds to the CurrencyInfo.CurrencyInfoID field. The value is generated automatically.
CuryReconciledBalance
decimalReconciled Balance-
Description:The beginning balance of the statement plus the cleared receipts minus the cleared disbursements.
CuryReconciledCredits
decimalReconciled Disb.-
Description:The total amount of reconciled disbursements on the statement in the selected currency.
CuryReconciledDebits
decimalReconciled Receipts-
Description:The total amount of reconciled receipts on the statement in the selected currency.
CuryReconciledTurnoverNonexistent in DB
decimal?Reconciled Turnover-
Description:Turnover of the reconciliation statement in the selected currency. Equals the following value: CARecon.CuryReconciledDebits minus CARecon.CuryReconciledCredits.
EmployeeIDDefault Navigation
intOwner-
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
bitHold-
Description:Indicates (if set to "true") that the reconciliation statement is on hold and can be saved unbalanced.
IsUserLoadDocumentsTillNonexistent in DB
bool?-
Description:The field indicates if user set LoadDocumentsTill, or was it set by CAOptimizeLoadDateAttribute.
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
char(8)-
Description:No description available
LastModifiedDateTime
datetimeLast Modified On-
Description:No description available
LastReconDate
datetimeLast Reconciliation Date-
Description:The date of the most recent CARecon for this cash account, if one exists.
LoadDocumentsTillNonexistent 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
OwnerIDDefault Navigation
intApproverContact
Description:The ID of the employee who was assigned to approve the transaction.
ReconDate
datetimeReconciliation Date-
Description:The date when the reconciliation statement was released and closed. A user can change the date up to the release.
ReconNbrDefault Navigation
nvarchar(15)Ref. Number-
Description:The identification number of the reconciliation statement, which the system assigns when the user saves the statement.
Reconciled
bitReconciled-
Description:Indicates (if set to "true") that the reconciliation statement was completed and cannot be edited anymore.
ReconciledCredits
decimalReconciled Disb.-
Description:The total amount of reconciled disbursements on the statement in the base currency.
ReconciledDebits
decimalReconciled Receipts-
Description:The total amount of reconciled receipts on the statement in the base currency.
ReconciledTurnoverNonexistent in DB
decimal?Reconciled Turnover-
Description:Turnover of the reconciliation statement in the base currency. Equals the following value: CARecon.ReconciledDebits minus CARecon.ReconciledCredits.
Rejected
bit-
Description:An indicator of whether the current reconciliation statement has been rejected.
SelectedNonexistent in DB
bool?Selected-
Description:No description available
ShowBatchPayments
bitBank 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
bitVoided 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:The current status of the statement. This field can have one of the values defined by CADocStatus.ListAttribute.
Voided
bitVoided-
Description:Indicates (if set to "true") that the reconciliation statement was voided.
WorkgroupIDDefault NavigationNonexistent in DB
int?Approval Workgroup IDEPCompanyTree
Description:The ID of the workgroup that was assigned to approve the transaction.
tstamp
timestamp-
Description:No description available