CABankTran

PX.Objects.CA

121 of 121 fields

	Field Name	Type	Display Name	Foreign Key
	`TranID`	`int`	ID	-
Description:The unique identifier of the CA bank transaction. This field is the key field.
	`AcctName`Default NavigationNonexistent in DB	`int`	Business Account Name	BAccount
Description:The name of the vendor or customer associated with the document.
	`AllowedOperations`	`nvarchar(2)`	Allowed Operations	-
Description:No description available
	`ApplyRuleEnabled`Nonexistent in DB	`bit`	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.
	`CardNumber`	`varchar(25)`	Card Number	-
Description:No description available
	`CashAccountID`Default Navigation	`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`	`nvarchar(1)`	Charge Tax Calculation Mode	-
Description:No description available
	`ChargeTaxZoneID`Default Navigation	`nvarchar(10)`	Charge Tax Zone	TaxZone
Description:No description available
	`ChargeTypeID`Default Navigation	`nvarchar(10)`	Charge Type	CAEntryType
Description:No description available
	`ClearDate`Nonexistent in DB	`datetime`		-
Description:No description available
	`Cleared`Nonexistent in DB	`bit`		-
Description:No description available
	`CountAdjustments`	`int`		-
Description:No description available
	`CountExpenseReceiptDetailMatches`Nonexistent in DB	`int`	CountExpenseReceiptDetailMatches	-
Description:The count of matched expense receipts. This is a virtual field and it has no representation in the database.
	`CountInvoiceMatches`Nonexistent in DB	`int`	CountInvoiceMatches	-
Description:The count of matched invoices. This is a virtual field and it has no representation in the database.
	`CountMatches`Nonexistent in DB	`int`	CountMatches	-
Description:The count of matched payments. This is a virtual field and it has no representation in the database.
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`		-
Description:No description available
	`CreateDocument`	`bit`	Create	-
Description:Specifies (if set to "true") that a new payment will be created for the selected bank transactions.
	`CuryApplAmt`	`decimal(19, 4)`	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(19, 4)`	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(19, 4)`	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.
	`CuryApplAmtMatchToInvoice`Nonexistent 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.
	`CuryApplAmtMatchToPayment`Nonexistent 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(19, 4)`	Charge Amount	-
Description:The amount of the charge including tax (if applicable).
	`CuryChargeTaxAmt`	`decimal(19, 4)`	Charge Tax Amount	-
Description:The amount of the charge including tax (if applicable).
	`CuryCreditAmt`Nonexistent 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.
	`CuryDebitAmt`Nonexistent 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(19, 4)`	Amount	-
Description:The sum of all details and exclusive taxes in the selected currency.
	`CuryID`Default Navigation	`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.
	`CuryTaxRoundDiff`	`decimal(19, 4)`	Rounding Diff.	-
Description:The difference between the original document amount and the rounded amount in the selected currency.
	`CuryTaxTotal`	`decimal(19, 4)`	Tax Total	-
Description:The total amount of tax paid on the document in the selected currency.
	`CuryTotalAmt`Nonexistent 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.
	`CuryTotalAmtCopy`Nonexistent 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.
	`CuryTotalAmtDisplay`Nonexistent 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(19, 4)`	CuryTranAmt	-
Description:The amount of the bank transaction in the selected currency.
	`CuryUnappliedBal`Nonexistent 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(19, 4)`	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.
	`CuryUnappliedBalMatch`Nonexistent 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.
	`CuryUnappliedBalMatchToInvoice`Nonexistent 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.
	`CuryUnappliedBalMatchToPayment`Nonexistent 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(19, 4)`	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(19, 4)`	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).
	`CuryWOAmt`Nonexistent 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:No description available
	`DetailsWithTaxesTotal`	`decimal(19, 4)`		-
Description:The sum of all details and exclusive taxes in the base currency.
	`DocType`Nonexistent in DB	`nchar(3)`		-
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`Default Navigation	`nvarchar(10)`	Entry Type ID	CAEntryType
Description:No description available
	`EntryTypeID1`Default NavigationNonexistent in DB	`nvarchar(10)`	Entry Type ID	CAEntryType
Description:No description available
	`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.
	`HasAdjustments`Obsolete	`bit`		-
Description:No description available
	`HeaderRefNbr`	`nvarchar(15)`	Statement Nbr.	CABankTranHeader
Description:No description available
	`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.
	`InvoiceInfo1`Nonexistent in DB	`nvarchar(256)`	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.
	`LastAutoMatchDate`	`datetime`	Last Auto-Match Date	-
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`		-
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.
	`MatchedToExisting`Nonexistent in DB	`bit`	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.
	`MatchedToExpenseReceipt`Nonexistent in DB	`bit`	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.
	`MatchedToInvoice`Nonexistent in DB	`bit`	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`Default Navigation	`char(6)`	Fin. Period	-
Description:No description available
	`MatchingPaymentDate`	`datetime2`	Payment Date	-
Description:No description available
	`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.
	`MatchStatsInfo`Nonexistent in DB	`nvarchar(MAX)`	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.
	`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`Default Navigation	`nvarchar(5)`	Orig. Currency	Currency
Description:The currency of the matching document.
	`OrigModule`	`char(2)`	Module	-
Description:No description available
	`OrigModule1`Nonexistent in DB	`nchar(2)`	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.
	`PayeeAddress1`	`nvarchar(256)`	Payee Address1	-
Description:The payee address, if any, specified for a transaction.
	`PayeeBAccountID`Default Navigation	`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.
	`PayeeBAccountID1`Default NavigationNonexistent in DB	`int`	Business Account	BAccount
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.
	`PayeeBAccountIDCopy`Default NavigationNonexistent in DB	`int`	Business Account	BAccount
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`Default Navigation	`int`	Location	Location
Description:No description available
	`PayeeLocationID1`Default NavigationNonexistent 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`Default NavigationNonexistent in DB	`int`	Location	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`Default Navigation	`nvarchar(10)`	Payment Method	PaymentMethod
Description:No description available
	`PaymentMethodID1`Default NavigationNonexistent in DB	`nvarchar(10)`	Payment Method	PaymentMethod
Description:No description available
	`PaymentMethodIDCopy`Default NavigationNonexistent in DB	`nvarchar(10)`	Payment Method	PaymentMethod
Description:No description available
	`PMInstanceID`Default Navigation	`int`	Card/Account Nbr.	CustomerPaymentMethod
Description:No description available
	`PMInstanceIDCopy`Default NavigationNonexistent in DB	`int`	Card/Account Nbr.	CustomerPaymentMethod
Description:No description available
	`Processed`	`bit`	Processed	-
Description:Specifies (if set to "true") that this bank transaction is processed.
	`RuleApplied`Nonexistent in DB	`bit`	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`Default Navigation	`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.
	`SortOrder`Nonexistent in DB	`int`		-
Description:No description available
	`Status`Nonexistent in DB	`nchar(1)`	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:No description available
	`TaxRoundDiff`	`decimal(19, 4)`		-
Description:The difference between the original document amount and the rounded amount in the base currency.
	`TaxTotal`	`decimal(19, 4)`		-
Description:The total amount of tax paid on the document in the base currency.
	`TaxZoneID`Default Navigation	`nvarchar(10)`	Tax Zone	TaxZone
Description:No description available
	`TranCode`	`nvarchar(35)`	Tran. Code	-
Description:The external code from the bank.
	`TranDate`	`datetime2`	Tran. Date	-
Description:The transaction date.
	`TranDesc`	`nvarchar(512)`	Tran. Desc	-
Description:The description of the bank transaction.
	`TranEntryDate`	`datetime2`	Tran. Entry Date	-
Description:The bank transaction entry date.
	`TranPeriodID`	`char(6)`		-
Description:No description available
	`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
	`tstamp`	`timestamp`		-
Description:No description available
	`UnappliedBalCA`	`decimal(19, 4)`		-
Description:The amount of the transaction in the base currency.
	`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(19, 4)`		-
Description:The document total that is exempt from VAT in the base currency.
	`VatTaxableTotal`	`decimal(19, 4)`		-
Description:The document total that is subjected to VAT in the base currency.
	`WOAmt`Nonexistent in DB	`decimal`		-
Description:The total amount of write-offs specified for documents to be applied in the base currency.