CA
CashAccount
The details and settings of cash accounts.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccountID | int | Account | Account | |
Description:No description available | ||||
AcctSettingsAllowedNonexistent in DB | bool? | Account Settings Allowed | - | |
Description:No description available | ||||
Active | bit | Active | - | |
Description:No description available | ||||
AdditionalInformationNonexistent in DB | string | - | ||
Description:No description available | ||||
AllowMatchingCreditMemo | bit | Allow Matching to Credit Memo | - | |
Description:Gets sets AllowMatchingCreditMemo | ||||
AllowMatchingDebitAdjustment | bit | Allow Matching to Debit Adjustment | - | |
Description:Specifies (if set to "true") that debit adjustments are available for matching to bank transactions on the Process Bank Transactions (CA306000) form. | ||||
AllowOverrideCuryNonexistent in DB | bool? | Enable Currency Override | - | |
Description:If set to "true", indicates that the currency of customer documents (which is specified by CashAccount.CuryID) can be overridden by a user during document entry. /// | ||||
AllowOverrideRateNonexistent in DB | bool? | Enable Rate Override | - | |
Description:If set to "true", indicates that the currency rate for customer documents (which is calculated by the system from the currency rate history) can be overridden by a user during document entry. | ||||
AmountWeight | decimal | Amount Weight | - | |
Description:Gets sets AmountWeight | ||||
AveragePaymentDelay | decimal | Average Payment Delay | - | |
Description:No description available | ||||
BankFeedStatusNonexistent in DB | string | Status | - | |
Description:No description available | ||||
BankFeedStatusEligibiltyNonexistent in DB | bool? | - | ||
Description:No description available | ||||
BankFeedsAllowedNonexistent in DB | bool? | Bank Feed Feature Installed | - | |
Description:No description available | ||||
BaseCuryID | nvarchar(5) | - | ||
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CashAccountCD | nvarchar(10) | Cash Account | - | |
Description:No description available | ||||
CashAccountID | int | - | ||
Description:No description available | ||||
ClearingAccount | bit | Clearing Account | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
CuryDiffThreshold | decimal | Amount Difference Threshold (%) | - | |
Description:Gets sets CuryDiffThreshold | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
CuryRateTypeID | nvarchar(6) | Curr. Rate Type | CurrencyRateType | |
Description:No description available | ||||
DateComparePercentNonexistent in DB | decimal? | % | - | |
Description:Gets sets DateComparePercent | ||||
DateCompareWeight | decimal | Doc. Date Weight | - | |
Description:Gets sets DateCompareWeight | ||||
DateMeanOffset | decimal | Payment Clearing Average Delay | - | |
Description:Gets sets DateMeanOffset | ||||
DateSigma | decimal | Estimated Deviation (Days) | - | |
Description:Gets sets DateSigma | ||||
DaysAfterInvoiceDueDate | int | Days After Due Date | - | |
Description:The maximum number of days between the invoice due date and the date of the selected bank transaction, to classify invoice as a match, if bank transaction date later than invoice due date | ||||
DaysBeforeInvoiceDiscountDate | int | Days Before Discount Date | - | |
Description:The maximum number of days between the invoice discount date and the date of the selected bank transaction, to classify invoice as a match | ||||
DaysBeforeInvoiceDueDate | int | Days Before Due Date | - | |
Description:The maximum number of days between the date of the selected bank transaction and the invoice due date, to classify invoice as a match, if bank transaction date earlier than invoice due date | ||||
Descr | nvarchar(60) | Description | - | |
Description:No description available | ||||
DisbursementTranDaysAfter | int | Days After Bank Transaction Date | - | |
Description:Gets sets DisbursementTranDaysAfter | ||||
DisbursementTranDaysBefore | int | Days Before Bank Transaction Date | - | |
Description:Gets sets DisbursementTranDaysBefore | ||||
EmptyRefNbrMatching | bit | Consider Empty Ref. Nbr. as Matching | - | |
Description:Gets sets EmptyRefNbrMatching | ||||
ExpenseReceiptAmountComparePercentNonexistent in DB | decimal? | - | ||
Description:Gets sets ExpenseReceiptAmountComparePercent | ||||
ExpenseReceiptDateComparePercentNonexistent in DB | decimal? | - | ||
Description:Gets sets ExpenseReceiptDateComparePercent | ||||
ExpenseReceiptRefNbrComparePercentNonexistent in DB | decimal? | - | ||
Description:Gets sets ExpenseReceiptRefNbrComparePercent | ||||
ExtRefNbr | nvarchar(40) | External Ref. Number | - | |
Description:No description available | ||||
HasBankFeedNonexistent in DB | bool? | - | ||
Description:No description available | ||||
InvoiceDateComparePercentNonexistent in DB | decimal? | % | - | |
Description:Gets sets InvoiceDateComparePercent | ||||
InvoiceDateCompareWeight | decimal | Doc. Date Weight | - | |
Description:The relative weight of the evaluated difference between the dates of the bank transaction and the invoice. | ||||
InvoiceDateSigma | decimal | Estimated Deviation (Days) | - | |
Description:No description available | ||||
InvoiceFilterByCashAccount | bit | Match by Cash Account | - | |
Description:Specifies (if set to "true") that only Invoices with the same cash account or empty cash account should be selected for matching with bank transactions on the Process Bank Transactions (CA306000) form. | ||||
InvoiceFilterByDate | bit | Match by Discount and Due Date | - | |
Description:Specifies (if set to "true") that invoices will be filtered by dates for matching to bank transactions on the Process Bank Transactions (CA306000) form. | ||||
InvoicePayeeComparePercentNonexistent in DB | decimal? | % | - | |
Description:Gets sets InvoicePayeeComparePercent | ||||
InvoicePayeeCompareWeight | decimal | Doc. Payee Weight | - | |
Description:The relative weight of the evaluated difference between the names of the customer on the bank transaction and the invoice. | ||||
InvoiceRefNbrComparePercentNonexistent in DB | decimal? | % | - | |
Description:Gets sets RefNbrComparePercent | ||||
InvoiceRefNbrCompareWeight | decimal | Ref. Nbr. Weight | - | |
Description:The relative weight of the evaluated difference between the reference numbers of the bank transaction and the invoice. | ||||
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 | ||||
MatchSettingsPerAccount | bit | - | ||
Description:Gets sets MatchSettingsPerAccount | ||||
MatchThreshold | decimal | Absolute Relevance Threshold | - | |
Description:Absolute Relevance Threshold used in auto-matching of transactions. Document will be matched automatically to a bank transaction if: 1. If it's the only match and Match Relevance > Relative Relevance Threshold 2. There is any number of matches and the best match has Match Relevance > Absolute Relevance Threshold 3. There is any number of matches and Match Relevance of the best match - Match Relevance of the second best match>= Relative Relevance Threshold | ||||
MatchToBatch | bit | Match Bank Transactions to Batch Payments | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
PTInstancesAllowedNonexistent in DB | bool? | Cards Allowed | - | |
Description:No description available | ||||
PayeeComparePercentNonexistent in DB | decimal? | % | - | |
Description:Gets sets PayeeComparePercent | ||||
PayeeCompareWeight | decimal | Doc. Payee Weight | - | |
Description:Gets sets PayeeCompareWeight | ||||
RatioInRelevanceCalculationLabelNonexistent in DB | string | - | ||
Description:Gets sets RatioInRelevanceCalculationLabel | ||||
ReceiptTranDaysAfter | int | Days After Bank Transaction Date | - | |
Description:Gets sets ReceiptTranDaysAfter | ||||
ReceiptTranDaysBefore | int | Days Before Bank Transaction Date | - | |
Description:Gets sets ReceiptTranDaysBefore | ||||
ReconNumberingID | nvarchar(10) | Reconciliation Numbering Sequence | Numbering | |
Description:No description available | ||||
Reconcile | bit | Requires Reconciliation | - | |
Description:No description available | ||||
RefNbrComparePercentNonexistent in DB | decimal? | % | - | |
Description:Gets sets RefNbrComparePercent | ||||
RefNbrCompareWeight | decimal | Ref. Nbr. Weight | - | |
Description:Gets sets RefNbrCompareWeight | ||||
ReferenceID | int | Bank ID | Vendor | |
Description:No description available | ||||
RelativeMatchThreshold | decimal | Relative Relevance Threshold | - | |
Description:Relative Relevance Threshold used in auto-matching of transactions. Document will be matched automatically to a bank transaction if: 1. If it's the only match and Match Relevance > Relative Relevance Threshold 2. There is any number of matches and the best match has Match Relevance > Absolute Relevance Threshold 3. There is any number of matches and Match Relevance of the best match - Match Relevance of the second best match>= Relative Relevance Threshold | ||||
RestrictVisibilityWithBranch | bit | Restrict Visibility with Branch | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
Signature | nvarchar(255) | Signature | - | |
Description:No description available | ||||
SignatureDescr | nvarchar(60) | Name | - | |
Description:No description available | ||||
SkipVoided | bit | Skip Voided Transactions During Matching | - | |
Description:Gets sets SkipVoided | ||||
StatementImportTypeName | nvarchar(255) | Statement Import Service | PXBqlTable | |
Description:No description available | ||||
SubID | int | Subaccount | Sub | |
Description:No description available | ||||
UseForCorpCard | bit | Use for Corporate Cards | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||