CA
CASetup
PX.Objects.CA64 of 64 fields
| 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(9, 6) | 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(9, 4) | Average Payment Delay | - | |
Description:No description available | ||||
BatchNumberingID | nvarchar(10) | Batch Numbering Sequence | Numbering | |
Description:No description available | ||||
CABatchNumberingID | nvarchar(10) | Payment Batch Numbering Sequence | Numbering | |
Description:No description available | ||||
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. | ||||
CAStatementNumberingID | nvarchar(10) | Bank Statement Numbering Sequence | Numbering | |
Description:No description available | ||||
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(9, 6) | Amount Difference Threshold (%) | - | |
Description:No description available | ||||
DateCompareWeight | decimal(9, 6) | Doc. Date Weight | - | |
Description:The relative weight of the evaluated difference between the dates of the bank transaction and the cash transaction. | ||||
DateMeanOffset | decimal(9, 4) | 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(9, 4) | 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(9, 6) | Doc. Date Weight | - | |
Description:The relative weight of the evaluated difference between the dates of the bank transaction and the invoice. | ||||
InvoiceDateSigma | decimal(9, 4) | 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(9, 6) | 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(9, 6) | 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(9, 6) | Absolute Relevance Threshold | - | |
Description:No description available | ||||
PayeeCompareWeight | decimal(9, 6) | 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(9, 6) | 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:No description available | ||||
RelativeMatchThreshold | decimal(9, 6) | Relative Relevance Threshold | - | |
Description:No description available | ||||
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 | - | |
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:No description available | ||||
TransitAcctId | int | Cash-In-Transit Account | Account | |
Description:No description available | ||||
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. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnknownPaymentEntryTypeID | nvarchar(10) | Unrecognized Receipts Type | CAEntryType | |
Description:No description available | ||||
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. | ||||