Skip to main content
CA

CASetup

PX.Objects.CA
Field NameTypeDisplay NameForeign Key
AllowEmptyFITID
bitAllow 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
bitAllow 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
bitAllow 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
bitAllow 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
bitAutomatically 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
BatchNumberingIDDefault Navigation
nvarchar(10)Batch Numbering SequenceNumbering
Description:No description available
CABatchNumberingIDDefault Navigation
nvarchar(10)Payment Batch Numbering SequenceNumbering
Description:No description available
CalcBalCreditClearedUnreleased
bitUnreleased Cleared-
Description:Specifies (if set to "true") that unreleased and cleared disbursements are included in calculation of available balances of cash accounts.
CalcBalCreditUnclearedReleased
bitReleased Uncleared-
Description:Specifies (if set to "true") that released and uncleared disbursements are included in calculation of available balances of cash accounts.
CalcBalCreditUnclearedUnreleased
bitUnreleased Uncleared-
Description:Specifies (if set to "true") that unreleased and uncleared disbursements are included in calculation of available balances of cash accounts.
CalcBalDebitClearedUnreleased
bitUnreleased Cleared-
Description:Specifies (if set to "true") that unreleased and cleared receipts are included in calculation of available balances of cash accounts.
CalcBalDebitUnclearedReleased
bitReleased Uncleared-
Description:Specifies (if set to "true") that released and uncleared receipts are included in calculation of available balances of cash accounts.
CalcBalDebitUnclearedUnreleased
bitUnreleased Uncleared-
Description:Specifies (if set to "true") that unreleased and uncleared receipts are included in calculation of available balances of cash accounts.
CAStatementNumberingIDDefault Navigation
nvarchar(10)Bank Statement Numbering SequenceNumbering
Description:No description available
CorpCardNumberingIDDefault Navigation
nvarchar(10)Corporate Card Numbering SequenceNumbering
Description:No description available
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
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
intDays 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
intDays 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
intDays 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
intDays 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
intDays 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
bitConsider 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
bitHold Transactions on Entry-
Description:Specifies (if set to "true") that newly entered transactions will by default get the On Hold status on entry.
IgnoreCuryCheckOnImport
bitIgnore 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
bitImport 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
bitMatch 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
bitMatch 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.
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
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
intDays 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
intDays 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.
RegisterNumberingIDDefault Navigation
nvarchar(10)Transaction Numbering SequenceNumbering
Description:No description available
RelativeMatchThreshold
decimal(9, 6)Relative Relevance Threshold-
Description:No description available
ReleaseAP
bitRelease 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
bitRelease 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
bitValidate 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
bitValidate 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
bitRequire 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
bitSkip 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
bitSkip 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.
StatementImportTypeNameDefault Navigation
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.
TransferNumberingIDDefault Navigation
nvarchar(10)Transfer Numbering SequenceNumbering
Description:No description available
TransitAcctIdDefault Navigation
intCash-In-Transit AccountAccount
Description:No description available
TransitSubIDDefault Navigation
intCash-In-Transit SubaccountSub
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
UnknownPaymentEntryTypeIDDefault Navigation
nvarchar(10)Unrecognized Receipts TypeCAEntryType
Description:No description available
ValidateDataConsistencyOnRelease
bitValidate 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.