CA
CABankTransactionsEnq.CABankTranHistory
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
CATranID | bigint | Document Number | - | |
Description:No description available | ||||
CashAccountID | int | Cash Account | - | |
Description:The cash account specified on the bank statement for which you want to upload bank transactions. This field is a part of the compound key of the document. Corresponds to the CashAccount.CashAccountID field. | ||||
CreateDocument | bit | Create | - | |
Description:Specifies (if set to "true") that a new payment will be created for the selected bank transactions. | ||||
CuryCreditAmt | decimal | Disbursement | - | |
Description:The amount of the disbursement in the selected currency. This is a virtual field and it has no representation in the database. | ||||
CuryDebitAmt | decimal | Receipt | - | |
Description:The amount of the receipt in the selected currency. This is a virtual field and it has no representation in the database. | ||||
CuryID | nvarchar(5) | Currency | - | |
Description:The identifier of currency of the bank transaction. | ||||
CuryMatchedCreditAmtNonexistent in DB | decimal? | Matched Disbursement | - | |
Description:No description available | ||||
CuryMatchedDebitAmtNonexistent in DB | decimal? | Matched Receipt | - | |
Description:No description available | ||||
CuryOrigCreditAmtNonexistent in DB | decimal? | Orig. Disbursement | - | |
Description:The amount of the original disbursement in the selected currency. This is a virtual field and it has no representation in the database. | ||||
CuryOrigDebitAmtNonexistent in DB | decimal? | Orig. Receipt | - | |
Description:The amount of the original receipt in the selected currency. This is a virtual field and it has no representation in the database. | ||||
DocumentMatched | bit | Matched | - | |
Description:Specifies (if set to "true") that this bank transaction is matched to the payment and ready to be processed. That is, the bank transaction has been matched to an existing transaction in the system, or details of a new document that matches this transaction have been specified. | ||||
ExtRefNbr | nvarchar(40) | Ext. Ref. Nbr. | - | |
Description:The external reference number of the transaction. | ||||
ExtTranID | nvarchar(255) | Ext. Tran. ID | - | |
Description:The external identifier of the transaction. | ||||
HeaderRefNbr | nvarchar(15) | Statement Nbr. | - | |
Description:The reference number of the imported bank statement (CABankTranHeader), which the system generates automatically in accordance with the numbering sequence assigned to statements on the Cash Management Preferences (CA101000) form. | ||||
Hidden | bit | Hidden | - | |
Description:Specifies (if set to "true") that this bank transaction has been hidden from the statement on the Process Bank Transactions (CA306000) form. | ||||
HistMatchedToInvoice | bit | Matched to Invoice | - | |
Description:Specifies (if set to "true") that this bank transaction is matched to the invoice. | ||||
InvoiceInfo | nvarchar(256) | Invoice Nbr. | - | |
Description:The reference number of the document (invoice or bill) generated to match a payment. This field is displayed if the ""AP"" or ""AR"" option is selected in the OrigModule field. This field is displayed on the Create Payment tab of on the Process Bank Transactions (CA306000) form. | ||||
MatchedDocType | char(3) | Type | - | |
Description:No description available | ||||
MatchedModule | char(2) | Module | - | |
Description:No description available | ||||
MatchedRefNbr | nvarchar(15) | Reference Nbr. | - | |
Description:No description available | ||||
MatchedReferenceCD | nvarchar(30) | Business Account | BAccountR | |
Description:No description available | ||||
MatchedReferenceID | int | - | ||
Description:No description available | ||||
MatchedReferenceName | nvarchar(255) | Business Account Name | - | |
Description:No description available | ||||
MatchedToExpenseReceiptNonexistent in DB | bool? | Matched To Expense Receipt | - | |
Description:Specifies (if set to "true") that this bank transaction is matched to the Expense Receipt. This is a virtual field and it has no representation in the database. | ||||
MatchedToInvoiceNonexistent in DB | bool? | Matched to Invoice | - | |
Description:Specifies (if set to "true") that this bank transaction is matched to the invoice. This is a virtual field and it has no representation in the database. | ||||
ParentTranID | int | ID | - | |
Description:The unique identifier of the CA bank transaction. This field is the key field. | ||||
PayeeName | nvarchar(256) | Payee Name | - | |
Description:The payee name, if any, specified for a transaction. | ||||
Processed | bit | Processed | - | |
Description:Specifies (if set to "true") that this bank transaction is processed. | ||||
RuleID | int | Applied Rule | CABankTranRule | |
Description:The identifier of the rule that was applied to the bank transaction to create a document. Corresponds to the CABankTranRule.RuleID field. | ||||
SortOrderNonexistent in DB | int? | - | ||
Description:No description available | ||||
Splitted | bit | Split | - | |
Description:Specifies (if set to "true") that this bank transaction is splitted. That is, the bank transaction has been matched to an existing transaction in the system, or details of a new document that matches this transaction have been specified. | ||||
SplittedIconNonexistent in DB | string | Split | - | |
Description:No description available | ||||
StatusNonexistent in DB | string | Match Type | - | |
Description:The status of the bank transaction. This is a virtual field and it has no representation in the database. The field can have one of the following values: ""M"": The bank transaction is matched to the payment and ready to be processed. ""I"": The bank transaction is matched to the invoice. ""C"": The bank transactions will be matched to a new payment. ""H"": The bank transaction is hidden from the statement on the Process Bank Transactions (CA306000) form. "string.Empty": The DocumentMatched, MatchedToInvoice, CreateDocument, and Hidden flags are set to "false". | ||||
TranCode | nvarchar(35) | Tran. Code | - | |
Description:The external code from the bank. | ||||
TranDate | datetime | Tran. Date | - | |
Description:The transaction date. | ||||
TranDesc | nvarchar(512) | Tran. Desc | - | |
Description:The description of the bank transaction. | ||||
TranID | int | ID | - | |
Description:The unique identifier of the CA bank transaction. This field is the key field. | ||||
TranType | char(1) | Type | - | |
Description:The type of the bank tansaction. The field is linked to the CABankTranHeader.TranType field. The field can have one of the following values: ""S"": Bank Statement Import, ""I"": Payments Import | ||||