CABankTranRule

PX.Objects.CA

27 of 27 fields

	Field Name	Type	Display Name	Foreign Key
	`RuleID`Default Navigation	`int`	Rule ID	-
Description:No description available
	`Action`	`char(1)`	Action	-
Description:No description available
	`AmountMatchingMode`	`char(1)`	Matching Mode	-
Description:The mode of the transaction amount matching. The following options are available: ""N"" (None): The amount criterion is not used; ""E"" (Equal): The transaction amount must be equal to the number specified in the Amount box; ""B"" (Between): The transaction amount must be in the range of the numbers specified in the Amount and the Max. Amount boxes.
	`BankDrCr`	`char(1)`	Debit/Credit	-
Description:Indicates whether this rule should be applied to receipt or disbursement bank transactions. Corresponds to the CABankTran.DrCr field. Mandatory.
	`BankTranCashAccountID`Default Navigation	`int`	Cash Account	CashAccount
Description:The Cash Account for the rule. When specified, the rule will be applied only to the transactions on this Cash Account. Corresponds to the CashAccount.CashAccountID field.
	`BankTranDescription`	`nvarchar(512)`	Tran. Description	-
Description:Represents the text used to identify transactions, to which the rule should be applied. Transaction must contain the text in the description.
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`	Created On	-
Description:No description available
	`CuryMinTranAmt`Nonexistent in DB	`decimal`	Min. Amount	-
Description:Transaction amount in the currency of the transaction. When specified together with appropriate value in the AmountMatchingMode field, the rule will be applied only to the transactions with matching amount. In case the AmountMatchingMode is set to "Between", the value in this field is used as a lower bound for transaction amount. Corresponds to the CABankTran.CuryMinTranAmt field.
	`CuryTranAmt`	`decimal(19, 4)`	Amount	-
Description:Transaction amount in the currency of the transaction. When specified together with appropriate value in the AmountMatchingMode field, the rule will be applied only to the transactions with matching amount. In case the AmountMatchingMode is set to "Between", the value in this field is used as a lower bound for transaction amount. Corresponds to the CABankTran.CuryTranAmt field.
	`Description`	`nvarchar(256)`	Rule Description	-
Description:Description of the rule. Does not affect any functionality.
	`DocumentEntryTypeID`Default Navigation	`nchar(10)`	Resulting Entry Type	CAEntryType
Description:No description available
	`DocumentModule`	`char(2)`	Resulting Document Module	-
Description:The module of the document generated by the rule. Default is "CA". Now this is the only supported value. Mandatory.
	`IsActive`	`bit`	Active	-
Description:No description available
	`LastModifiedByID`Default Navigation	`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
	`MatchDescriptionCase`	`bit`	Match Case	-
Description:Indicates whether the case should be matched when the system attempts to apply the rule. When set to "true" the description of the transactions will be scanned for presence of the specified text with respect to case. Otherwise, the case will be ignored during string comparison. Defaults to "false".
	`MaxCuryTranAmt`	`decimal(19, 4)`	Max. Amount	-
Description:Maximum transaction amount in the currency of the transaction, which the rule should match. Used only when the AmountMatchingMode is set to "Between" Matching is done on the CABankTran.CuryTranAmt field.
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`PayeeName`	`nvarchar(256)`	Payee/Payer	-
Description:The payee/payer name, if any, specified for a transaction rule.
	`TranCode`	`nvarchar(35)`	Tran. Code	-
Description:The transaction code that the rule should match. Corresponds to the CABankTran.TranCode field.
	`TranCuryID`Default Navigation	`nchar(5)`	Currency	Currency
Description:Code of the Currency. If specified, the rule will be applied only to the transactions in the respective currency.
	`tstamp`	`timestamp`		-
Description:No description available
	`UseDescriptionWildcards`	`bit`	Use Wildcards (*, ?)	-
Description:When set to "true", indicates that the system must treat '' and '?' characters in the BankTranDescription as wildcards ('' matches 0 or more arbitrary symbols, '?' matches one arbitrary symbol). Defaults to "false".
	`UsePayeeNameWildcards`	`bit`	Use Wildcards (*, ?)	-
Description:When set to "true", indicates that the system must treat '' and '?' characters in the PayeeName as wildcards ('' matches 0 or more arbitrary symbols, '?' matches one arbitrary symbol). Defaults to "false".