CA
CABankTran
The main properties of CA bank transactions and their classes. CA bank transactions are edited on the Process Bank Transactions (CA306000) form (which corresponds to the CABankTransactionsMaint graph).
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AcctNameNonexistent in DB | int? | Business Account Name | BAccountR | |
Description:The name of the vendor or customer associated with the document. | ||||
AllowedOperations | nvarchar(2) | Allowed Operations | - | |
Description:No description available | ||||
ApplyRuleEnabledNonexistent in DB | bool? | Create Rule Enabled | - | |
Description:Specifies (if set to "true") that the button "Create Rule" is enabled. This is a virtual field and it has no representation in the database. | ||||
BankFeedAccountMapID | uniqueidentifier | Bank Feed Account | CABankFeedAccountMapping | |
Description:Indicates that the bank transaction was retrieved from the bank feed account that relates to the bank feed in the multiple mapping mode. | ||||
CardNumber | nvarchar(25) | Card Number | - | |
Description:No description available | ||||
CashAccountID | int | Cash Account | CashAccount | |
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. | ||||
ChargeDrCr | char(1) | - | ||
Description:No description available | ||||
ChargeTaxCalcMode | char(1) | Charge Tax Calculation Mode | - | |
Description:The tax calculation mode, which defines which amounts (tax-inclusive or tax-exclusive) should be entered in the detail lines of a document. This field is displayed only if the FeaturesSet.NetGrossEntryMode field is set to "true". The field can have one of the following values: ""T"" (Tax Settings): The tax amount for the document is calculated according to the settings of the applicable tax or taxes. ""G"" (Gross): The amount in the document detail line includes a tax or taxes. ""N"" (Net): The amount in the document detail line does not include taxes. | ||||
ChargeTaxZoneID | nvarchar(10) | Charge Tax Zone | TaxZone | |
Description:The tax zone that applies to the bank transaction. Corresponds to the value of the TaxZone.TaxZoneID field. | ||||
ChargeTypeID | nvarchar(10) | Charge Type | CAEntryType | |
Description:The identifier of an entry type that is used as a template for a new cash transaction to be created to match the selected bank transaction. The field is displayed if the "Multiple Documents" option is selected. This field is displayed on the Match to Invoices tab of on the Process Bank Transactions (CA306000) form. Corresponds to the CAEntryType.EntryTypeId field. | ||||
ChildsCount | int | - | ||
Description:No description available | ||||
ClearDateNonexistent in DB | DateTime? | - | ||
Description:No description available | ||||
ClearedNonexistent in DB | bool? | - | ||
Description:No description available | ||||
CountAdjustments | int | - | ||
Description:No description available | ||||
CountExpenseReceiptDetailMatchesNonexistent in DB | int? | - | ||
Description:The count of matched expense receipts. This is a virtual field and it has no representation in the database. | ||||
CountInvoiceMatchesNonexistent in DB | int? | - | ||
Description:The count of matched invoices. This is a virtual field and it has no representation in the database. | ||||
CountMatchesNonexistent in DB | int? | - | ||
Description:The count of matched payments. This is a virtual field and it has no representation in the database. | ||||
CreateDocument | bit | Create | - | |
Description:Specifies (if set to "true") that a new payment will be created for the selected bank transactions. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CuryApplAmt | decimal | Application Amount | - | |
Description:The amount of the application for this payment. This field is displayed if the ""AP"" or ""AR"" option is selected in the OrigModule field. | ||||
CuryApplAmtCA | decimal | Detail Total | - | |
Description:The amount of the transaction for which the documents (to match the bank transaction) are added. Represented in the selected currency. This field is displayed if the "CA" option is selected in the OrigModule field. | ||||
CuryApplAmtMatch | decimal | Matched Amount | - | |
Description:The amount of the application for this payment. This field is displayed if the ""AP"" or ""AR"" option is selected in the OrigModule field. | ||||
CuryApplAmtMatchToInvoiceNonexistent in DB | decimal? | Matched Amount | - | |
Description:The amount of the application for this payment. This field is displayed if the ""AP"" or ""AR"" option is selected in the OrigModule field. | ||||
CuryApplAmtMatchToPaymentNonexistent in DB | decimal? | Matched Amount | - | |
Description:The amount of the application for this payment. This field is displayed if the ""AP"" or ""AR"" option is selected in the OrigModule field. | ||||
CuryChargeAmt | decimal | Charge Amount | - | |
Description:The amount of the charge including tax (if applicable). | ||||
CuryChargeTaxAmt | decimal | Charge Tax Amount | - | |
Description:The amount of the charge including tax (if applicable). | ||||
CuryCreditAmtNonexistent in DB | 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. | ||||
CuryDebitAmtNonexistent in DB | 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. | ||||
CuryDetailsWithTaxesTotal | decimal | Amount | - | |
Description:The sum of all details and exclusive taxes in the selected currency. | ||||
CuryDisplayCreditAmtNonexistent in DB | decimal? | Orig. Disbursement | - | |
Description:The amount of the disbursement in the selected currency. This is a virtual field and it has no representation in the database. | ||||
CuryDisplayDebitAmtNonexistent in DB | decimal? | Orig. 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 | Currency | |
Description:The identifier of currency of the bank transaction. | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:The identifier of the exchange rate record for the bank transaction amount. Corresponds to the CurrencyInfo.CuryInfoID field. | ||||
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. | ||||
CuryOrigTranAmt | decimal | CuryOrigTranAmt | - | |
Description:The amount of the original bank transaction in the selected currency. | ||||
CuryTaxRoundDiff | decimal | Rounding Diff. | - | |
Description:The difference between the original document amount and the rounded amount in the selected currency. | ||||
CuryTaxTotal | decimal | Tax Total | - | |
Description:The total amount of tax paid on the document in the selected currency. | ||||
CuryTotalAmtNonexistent in DB | decimal? | Total Amount | - | |
Description:The total amount of the created document in the selected currency. This field is displayed if the ""AP"" or ""AR"" option is selected in the OrigModule field. This is a virtual field and it has no representation in the database. | ||||
CuryTotalAmtCopyNonexistent in DB | decimal? | Transaction Amount | - | |
Description:The copy of the CuryTotalAmt field. The total amount of the created document in the selected currency. This is a virtual field and it has no representation in the database. | ||||
CuryTotalAmtDisplayNonexistent in DB | decimal? | Transaction Amount | - | |
Description:The copy of the CuryTotalAmt field. The total amount of the created document in the selected currency. This is a virtual field and it has no representation in the database. | ||||
CuryTranAmt | decimal | CuryTranAmt | - | |
Description:The amount of the bank transaction in the selected currency. | ||||
CuryUnappliedBalNonexistent in DB | decimal? | Unapplied Balance | - | |
Description:The unapplied balance of the document in the selected currency. This field is displayed if the ""AP"" or ""AR"" option is selected in the OrigModule field. This is a virtual field and it has no representation in the database. | ||||
CuryUnappliedBalCA | decimal | Discrepancy | - | |
Description:The balance of the transaction for which you can add the documents. This field is displayed if the "CA" option is selected in the OrigModule field. This is a virtual field and it has no representation in the database. | ||||
CuryUnappliedBalMatchNonexistent in DB | decimal? | Unmatched Amount | - | |
Description:The unapplied balance of the document in the selected currency. This is a virtual field and it has no representation in the database. | ||||
CuryUnappliedBalMatchToInvoiceNonexistent in DB | decimal? | Unmatched Amount | - | |
Description:The unapplied balance of the document in the selected currency. This is a virtual field and it has no representation in the database. | ||||
CuryUnappliedBalMatchToPaymentNonexistent in DB | decimal? | Unmatched Amount | - | |
Description:The unapplied balance of the document in the selected currency. This is a virtual field and it has no representation in the database. | ||||
CuryVatExemptTotal | decimal | VAT Exempt Total | - | |
Description:The document total that is exempt from VAT in the selected currency. This total is calculated as the taxable amount for the tax with the Tax.ExemptTax field set to "true" (that is, the Include in VAT Exempt Total check box selected on the Taxes (TX205000) form). | ||||
CuryVatTaxableTotal | decimal | VAT Taxable Total | - | |
Description:The document total that is subjected to VAT in the selected currency. The field is displayed only if the Tax.IncludeInTaxable field is set to "true" (that is, the Include in VAT Exempt Total check box is selected on the Taxes (TX205000) form). | ||||
CuryWOAmtNonexistent in DB | decimal? | Write-Off Amount | - | |
Description:The total amount of write-offs specified for documents to be applied in the selected currency. This field is displayed if the ""AR"" option is selected in the OrigModule field. | ||||
DetailErrorCount | int | - | ||
Description:Number of records with errors in the details table. | ||||
DetailsWithTaxesTotal | decimal | - | ||
Description:The sum of all details and exclusive taxes in the base currency. | ||||
DocTypeNonexistent in DB | string? | - | ||
Description:No description available | ||||
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. | ||||
DrCr | char(1) | DrCr | - | |
Description:The balance type of the bank transaction. The field can have one of the following values: ""D"": Receipt, ""C"": Disbursement | ||||
EntryTypeID | nvarchar(10) | Entry Type ID | CAEntryType | |
Description:The identifier of an entry type that is used as a template for a new cash transaction to be created to match the selected bank transaction. The field is displayed if the "CA" option is selected in the OrigModule field. This field is displayed on the Create Payment tab of on the Process Bank Transactions (CA306000) form. Corresponds to the CAEntryType.EntryTypeId field. | ||||
EntryTypeID1Nonexistent in DB | string | Entry Type ID | CAEntryType | |
Description:The copy of the EntryTypeID field. This field is displayed on the Match to Payments tab of on the Process Bank Transactions (CA306000) form. | ||||
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. | ||||
ExtTranIDRef | bigint | - | ||
Description:No description available | ||||
FeedID | nvarchar(50) | - | ||
Description:No description available | ||||
FullDocumentMatchedNonexistent in DB | bool? | 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. | ||||
FullProcessedNonexistent in DB | bool? | Processed | - | |
Description:Specifies (if set to "true") that this bank transaction is processed. | ||||
HasAdjustmentsNonexistent in DBObsolete | bool? | - | ||
Description:No description available | ||||
HeaderRefNbr | nvarchar(15) | Statement Nbr. | CABankTranHeader | |
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. | ||||
InvoiceInfo1Nonexistent in DB | string | Invoice Nbr. | - | |
Description:The copy of the InvoiceInfo field. This field is displayed on the Match to Payments tab of on the Process Bank Transactions (CA306000) form. | ||||
InvoiceNotFound | bit | - | ||
Description:Specifies (if set to "true") that the invoice for matching to this bank transaction wasn't found. | ||||
IsAutoMatchOnlyNonexistent in DB | bool? | Auto-Match Only | - | |
Description:Specifies (if set to "true") that the bank transaction is locked by the external system for manual matching and auto-matching with documents on Match to Invoices, Match to Expence Receipt and Create Document tabs. The value corresponds to the opposite value of the parent record field CABankTranHeader.ManualMatchingAllowed. | ||||
LastAutoMatchDate | datetime | Last Auto-Match Date | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineCntr | int | - | ||
Description:The counter of related adjustments. The "PXParentAttribute" from the CABankTranAdjustment.AdjNbr field links on this field. | ||||
LineCntrCA | int | - | ||
Description:The counter of related details. The "PXParentAttribute" from the CABankTranDetail.LineNbr field links on this field. | ||||
LineCntrMatch | int | - | ||
Description:The counter of related details. The "PXParentAttribute" from the CABankTranMatch.LineNbr field links on this field. | ||||
MatchReason | nvarchar(1) | Match Reason | - | |
Description:No description available | ||||
MatchReceiptsAndDisbursements | bit | Match to Receipts and Disbursements | - | |
Description:Specifies (if set to "true") that the selected bank transaction can be matched to multiple documents with any amount and any direction. | ||||
MatchStatsInfoNonexistent in DB | string | MatchStatsInfo | - | |
Description:The user-friendly brief description of the status of the selected transaction. The field is displayed in the bottom of the table with bank transactions on the Process Bank Transactions (CA306000) form. This is a virtual field and it has no representation in the database. | ||||
MatchedToExistingNonexistent in DB | bool? | Matched | - | |
Description:Specifies (if set to "true") that this bank transaction is matched to the transaction in the system. This is a virtual field and it has no representation in the database. | ||||
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. | ||||
MatchingFinPeriodID | string | Fin. Period | FinPeriod | |
Description:No description available | ||||
MatchingPaymentDate | datetime | Payment Date | - | |
Description:No description available | ||||
MultipleMatching | bit | Match to Multiple Documents | - | |
Description:Specifies (if set to "true") that the selected bank transaction can be matched to multiple invoices. | ||||
MultipleMatchingToPayments | bit | Match to Multiple Payments | - | |
Description:Specifies (if set to "true") that the selected bank transaction can be matched to multiple payments. | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrigCuryID | nvarchar(5) | Orig. Currency | CurrencyInfo | |
Description:The currency of the matching document. | ||||
OrigDrCr | char(1) | DrCr | - | |
Description:The balance type of the original bank transaction. The field can have one of the following values: ""D"": Receipt, ""C"": Disbursement | ||||
OrigModule | char(2) | Module | - | |
Description:The original module of the matching document. This field is displayed on the Create Payment tab of on the Process Bank Transactions (CA306000) form. The field can have one of the following values: ""AP"": Accounts Payable, ""AR"": Accounts Receivable, ""CA"": Cash Management. | ||||
OrigModule1Nonexistent in DB | string | Module | - | |
Description:The copy of the OrigModule field. This field is displayed on the Match to Payments tab of on the Process Bank Transactions (CA306000) form. | ||||
PMInstanceID | int | Card/Account Nbr. | CustomerPaymentMethod | |
Description:The identifier of the credit card or account that is used by a customer or vendor for the document. This field is displayed on the Create Payment tab of on the Process Bank Transactions (CA306000) form. | ||||
PMInstanceIDCopyNonexistent in DB | int? | Card/Account Nbr. | CustomerPaymentMethod | |
Description:The copy of the PMInstanceID field. This field is displayed on the Match to Invoices tab of on the Process Bank Transactions (CA306000) form. | ||||
ParentTranID | int | ID | CABankTran | |
Description:The unique identifier of the CA bank transaction. This field is the key field. | ||||
PayeeAddress1 | nvarchar(256) | Payee Address1 | - | |
Description:The payee address, if any, specified for a transaction. | ||||
PayeeBAccountID | int | Business Account | BAccount | |
Description:The vendor or customer associated with the document, by its business account ID. 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. | ||||
PayeeBAccountID1Nonexistent in DB | int? | Business Account | BAccountR | |
Description:The copy of the PayeeBAccountID field. This field is displayed on the Match to Payments tab of on the Process Bank Transactions (CA306000) form. | ||||
PayeeBAccountIDCopyNonexistent in DB | int? | Business Account | BAccountR | |
Description:The copy of the PayeeBAccountID field. This field is displayed on the Match to Invoices tab of on the Process Bank Transactions (CA306000) form. | ||||
PayeeCity | nvarchar(256) | Payee City | - | |
Description:The payee city, if any, specified for a transaction. | ||||
PayeeLocationID | int | Location | Location | |
Description:The location of the vendor or customer. 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. | ||||
PayeeLocationID1Nonexistent in DB | int? | Location | Location | |
Description:The copy of the PayeeLocationID field. This field is displayed on the Match to Payments tab of on the Process Bank Transactions (CA306000) form. | ||||
PayeeLocationIDCopy | int | Location | - | |
Description:The copy of the PayeeLocationID field . This field is displayed on the Match to Invoices tab of on the Process Bank Transactions (CA306000) form. | ||||
PayeeName | nvarchar(256) | Payee/Payer | - | |
Description:The payee name, if any, specified for a transaction. | ||||
PayeePhone | nvarchar(256) | Payee Phone | - | |
Description:The payee phone, if any, specified for a transaction. | ||||
PayeePostalCode | nvarchar(256) | Payee Postal Code | - | |
Description:The payee postal code, if any, specified for a transaction. | ||||
PayeeState | nvarchar(256) | Payee State | - | |
Description:The payee state, if any, specified for a transaction. | ||||
PaymentMethodID | nvarchar(10) | Payment Method | PaymentMethod | |
Description:The payment method used by a customer or vendor for the document. 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. | ||||
PaymentMethodID1Nonexistent in DB | string | Payment Method | PaymentMethod | |
Description:The copy of the PaymentMethodID field. This field is displayed on the Match to Payments tab of on the Process Bank Transactions (CA306000) form. | ||||
PaymentMethodIDCopyNonexistent in DB | string | Payment Method | PaymentMethod | |
Description:The copy of the PaymentMethodID field. This field is displayed on the Match to Invoices tab of on the Process Bank Transactions (CA306000) form. | ||||
Processed | bit | Processed | - | |
Description:Specifies (if set to "true") that this bank transaction is processed. | ||||
RuleAppliedNonexistent in DB | bool? | Rule Applied | - | |
Description:Specifies (if set to "true") that the rule was applied to clear the transaction on the Process Bank Transactions (CA306000) form. | ||||
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 | ||||
Source | 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". | ||||
TaxCalcMode | char(1) | Tax Calculation Mode | - | |
Description:The tax calculation mode, which defines which amounts (tax-inclusive or tax-exclusive) should be entered in the detail lines of a document. This field is displayed only if the FeaturesSet.NetGrossEntryMode field is set to "true". The field can have one of the following values: ""T"" (Tax Settings): The tax amount for the document is calculated according to the settings of the applicable tax or taxes. ""G"" (Gross): The amount in the document detail line includes a tax or taxes. ""N"" (Net): The amount in the document detail line does not include taxes. | ||||
TaxRoundDiff | decimal | - | ||
Description:The difference between the original document amount and the rounded amount in the base currency. | ||||
TaxTotal | decimal | - | ||
Description:The total amount of tax paid on the document in the base currency. | ||||
TaxZoneID | nvarchar(10) | Tax Zone | TaxZone | |
Description:The tax zone that applies to the bank transaction. Corresponds to the value of the TaxZone.TaxZoneID field. | ||||
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. | ||||
TranEntryDate | datetime | Tran. Entry Date | - | |
Description:The bank transaction entry date. | ||||
TranID | int | ID | - | |
Description:The unique identifier of the CA bank transaction. This field is the key field. | ||||
TranPeriodID | string | - | ||
Description:No description available | ||||
TranType | char(1) | Type | CABankTranHeader | |
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 | ||||
UnappliedBalCA | decimal | - | ||
Description:The amount of the transaction in the base currency. | ||||
UnmatchedChilds | int | - | ||
Description:No description available | ||||
UnprocessedChilds | int | - | ||
Description:No description available | ||||
UserDesc | nvarchar(512) | Custom Tran. Desc. | - | |
Description:The description of the bank transaction. You can use this field to specify a user description of the bank transaction while keeping the original bank description (TranDesc) untouched. | ||||
VatExemptTotal | decimal | - | ||
Description:The document total that is exempt from VAT in the base currency. | ||||
VatTaxableTotal | decimal | - | ||
Description:The document total that is subjected to VAT in the base currency. | ||||
WOAmtNonexistent in DB | decimal? | - | ||
Description:The total amount of write-offs specified for documents to be applied in the base currency. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||