CA
CASetup
The main properties of cash management preferences and their classes. Cash management preferences are edited on the Cash Management Preferences (CA101000) form (which corresponds to the CASetupMaint graph).
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AllowEmptyFITID | bit | Allow Empty FITID | - | |
Description:Specifies (if set to "true") that the system ignores the empty FITID value (the value, which is uploaded to the Ext. Tran. ID column on the Import Bank Transactions (CA306500) form) when you import the bank statement file. | ||||
AllowMatchingCreditMemo | bit | Allow Matching to Credit Memo | - | |
Description:Specifies (if set to "true") that credit memo are available for matching to bank transactions on the Process Bank Transactions (CA306000) form. | ||||
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. | ||||
AllowMatchingToUnreleasedBatch | bit | Allow Matching to Unreleased Batch Payments | - | |
Description:Specifies (if set to "true") that unreleased batch payments are available for matching to bank transactions on the Process Bank Transactions (CA306000) form. | ||||
AmountWeight | decimal | Amount Weight | - | |
Description:No description available | ||||
AutoPostOption | bit | Automatically Post to GL on Release | - | |
Description:Specifies (if set to "true") that cash transactions are automatically posted to General Ledger on release. | ||||
AveragePaymentDelay | decimal | Average Payment Delay | - | |
Description:No description available | ||||
BankFeedNumberingID | nvarchar | Bank Feed Numbering Sequence | Numbering | |
Description:No description available | ||||
BatchNumberingID | nvarchar(10) | Batch Numbering Sequence | Numbering | |
Description:The numbering sequence to be used for the identifiers of batches originating in the Cash Management module. Corresponds to the value of the Numbering.NumberingID field. | ||||
CABatchNumberingID | nvarchar(10) | Payment Batch Numbering Sequence | Numbering | |
Description:The numbering sequence to be used for the identifiers of batches of payments. Corresponds to the value of the Numbering.NumberingID field. | ||||
CAStatementNumberingID | nvarchar(10) | Bank Statement Numbering Sequence | Numbering | |
Description:The numbering sequence to be used for the identifiers of bank statements. Corresponds to the value of the Numbering.NumberingID field. | ||||
CalcBalCreditClearedUnreleased | bit | Unreleased Cleared | - | |
Description:Specifies (if set to "true") that unreleased and cleared disbursements are included in calculation of available balances of cash accounts. | ||||
CalcBalCreditUnclearedReleased | bit | Released Uncleared | - | |
Description:Specifies (if set to "true") that released and uncleared disbursements are included in calculation of available balances of cash accounts. | ||||
CalcBalCreditUnclearedUnreleased | bit | Unreleased Uncleared | - | |
Description:Specifies (if set to "true") that unreleased and uncleared disbursements are included in calculation of available balances of cash accounts. | ||||
CalcBalDebitClearedUnreleased | bit | Unreleased Cleared | - | |
Description:Specifies (if set to "true") that unreleased and cleared receipts are included in calculation of available balances of cash accounts. | ||||
CalcBalDebitUnclearedReleased | bit | Released Uncleared | - | |
Description:Specifies (if set to "true") that released and uncleared receipts are included in calculation of available balances of cash accounts. | ||||
CalcBalDebitUnclearedUnreleased | bit | Unreleased Uncleared | - | |
Description:Specifies (if set to "true") that unreleased and uncleared receipts are included in calculation of available balances of cash accounts. | ||||
CorpCardNumberingID | nvarchar(10) | Corporate Card Numbering Sequence | Numbering | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CuryDiffThreshold | decimal | Amount Difference Threshold (%) | - | |
Description:No description available | ||||
DateCompareWeight | decimal | Doc. Date Weight | - | |
Description:The relative weight of the evaluated difference between the dates of the bank transaction and the cash transaction. | ||||
DateMeanOffset | decimal | Payment Clearing Average Delay | - | |
Description:The average number of days for a payment to be cleared with the bank. | ||||
DateRangeDefault | char(1) | Default Date Range | - | |
Description:The range (starting with the current business date) to be used by default on Cash Management reports: Day, Week, Month, or Financial Period. | ||||
DateSigma | decimal | Estimated Deviation (Days) | - | |
Description:The number of days before and after the average delay date during which 50% of payments are generally cleared. | ||||
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 | ||||
DisbursementTranDaysAfter | int | Days After Bank Transaction Date | - | |
Description:For the system to categorize a cash transaction as matching, the maximum number of days between the date of the selected transaction on the bank statement and the date of a receipt. | ||||
DisbursementTranDaysBefore | int | Days Before Bank Transaction Date | - | |
Description:For the system to categorize a cash transaction as matching, the maximum number of days between the date of a cash transaction (receipt) and the selected transaction on the bank statement. | ||||
EmptyRefNbrMatching | bit | Consider Empty Ref. Nbr. as Matching | - | |
Description:Specifies (if set to "true") that batch payments with empty ref number are available for matching to bank transactions on the Process Bank Transactions (CA306000) form. | ||||
HoldEntry | bit | Hold Transactions on Entry | - | |
Description:Specifies (if set to "true") that newly entered transactions will by default get the On Hold status on entry. | ||||
IgnoreCuryCheckOnImport | bit | Ignore Currency Check on Bank Statement Import | - | |
Description:Specifies (if set to "true") that the system ignores the currency check when you import bank statements. | ||||
ImportToSingleAccount | bit | Import Bank Statement to Single Cash Account | - | |
Description:Specifies (if set to "true") that importing a bank statement from a file should be performed to only a specific cash account. The user can import the data only after the user has selected the cash account on the Import Bank Transactions (CA306500) form. | ||||
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. | ||||
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. | ||||
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 | - | ||
Description:No description available | ||||
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 | ||||
PayeeCompareWeight | decimal | Doc. Payee Weight | - | |
Description:The relative weight of the evaluated difference between the names of the customer (or vendor) on the bank transaction and the cash transaction. | ||||
ReceiptTranDaysAfter | int | Days After Bank Transaction Date | - | |
Description:For the system to categorize a cash transaction as matching, the maximum number of days between the date of the selected transaction on the bank statement and the date of a receipt. | ||||
ReceiptTranDaysBefore | int | Days Before Bank Transaction Date | - | |
Description:For the system to categorize a cash transaction as matching, the maximum number of days between the date of a cash transaction (disbursement) and the selected transaction on the bank statement. | ||||
RefNbrCompareWeight | decimal | Ref. Nbr. Weight | - | |
Description:The relative weight of the evaluated difference between the reference numbers of the bank transaction and the cash transaction. | ||||
RegisterNumberingID | nvarchar(10) | Transaction Numbering Sequence | Numbering | |
Description:The numbering sequence to be used for the identifiers of cash adjustments or direct cash transactions. Corresponds to the value of the Numbering.NumberingID field. | ||||
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 | ||||
ReleaseAP | bit | Release AP Documents from CA Module | - | |
Description:Specifies (if set to "true") that Accounts Payable documents can be released from the Cash Management module. If the value of the field is "false", Accounts Payable documents can be released only from the Accounts Payable module. | ||||
ReleaseAR | bit | Release AR Documents from CA Module | - | |
Description:Specifies (if set to "true") that Accounts Receivable documents can be released from the Cash Management module. If the value of the field is "false", Accounts Receivable documents can be released only from the Accounts Receivable module. | ||||
RequireControlTaxTotal | bit | Validate Tax Totals on Entry | - | |
Description:Specifies (if set to "true") that the Tax Amount box is added to the Summary area of the Transactions (CA304000) form, so a user can enter the tax amount manually in the transaction. | ||||
RequireControlTotal | bit | Validate Control Totals on Entry | - | |
Description:Specifies (if set to "true") that the Control Total box is added to the Summary area of the Transactions (CA304000) form, so a user can enter the transaction amount manually. This amount will be validated when users enter transactions. | ||||
RequireExtRefNbr | bit | Require Document Ref. Nbr. on Entry | - | |
Description:Specifies (if set to "true") that users must fill in the Document Ref. box for new cash transactions and deposits. | ||||
SkipReconciled | bit | Skip Reconciled Transactions in Matching | - | |
Description:Specifies (if set to "true") that the system skip voided transactions during the reconciliation process if both the original and the voided transactions are registered in the same financial period. | ||||
SkipVoided | bit | Skip Voided Transactions | - | |
Description:Specifies (if set to "true") that the system skip voided transactions during the reconciliation process if both the original and the voided transactions are registered in the same financial period. | ||||
StatementImportTypeName | nvarchar(255) | Statement Import Service | PXBqlTable | |
Description:The service to be used for importing bank statements if the Import Bank Statements to Single Cash Account check box is cleared. | ||||
TransferNumberingID | nvarchar(10) | Transfer Numbering Sequence | Numbering | |
Description:The numbering sequence to be used for the identifiers of transfers. Corresponds to the value of the Numbering.NumberingID field. | ||||
TransitAcctId | int | Cash-In-Transit Account | Account | |
Description:The special multi-currency asset account used (when necessary) as an intermediate account for currency conversions performed during funds transfers. Corresponds to the value of the Account.accountID field. | ||||
TransitSubID | int | Cash-In-Transit Subaccount | Sub | |
Description:The special multi-currency asset subaccount used (when necessary) as an intermediate account for currency conversions performed during funds transfers. Corresponds to the value of the Sub.SubID field. | ||||
UnknownPaymentEntryTypeID | nvarchar(10) | Unrecognized Receipts Type | CAEntryType | |
Description:The entry type (configured for processing unrecognized payments and for payment reclassification) to be used by default on the Reclassify Payments (CA506500) form. | ||||
ValidateDataConsistencyOnRelease | bit | Validate data consistency on Release | - | |
Description:Specifies (if set to "true") that the system validates data consistency on the release of cash transactions and deposits. The validation is described in the CAReleaseProcess.CheckMultipleGLPosting method. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||