BankFeedTransaction

PX.Objects.CA

75 of 75 fields

	Field Name	Type	Display Name	Foreign Key
	`TransactionID`Nonexistent in DB	`nvarchar(MAX)`	Transaction ID	-
Description:No description available
	`AccountID`Nonexistent in DB	`nvarchar(MAX)`	Account ID	-
Description:No description available
	`AccountName`Nonexistent in DB	`nvarchar(MAX)`	Bank Account Name	-
Description:Contains data about the account name from the file.
	`AccountOwner`Nonexistent in DB	`nvarchar(MAX)`	Account Owner	-
Description:No description available
	`AccountStringId`Nonexistent in DB	`nvarchar(MAX)`	Account String ID	-
Description:Contains data from service's field account_id
	`Address`Nonexistent in DB	`nvarchar(MAX)`	Address	-
Description:Contains data from service's field address
	`Amount`Nonexistent in DB	`decimal`	Amount	-
Description:No description available
	`AuthorizedDate`Nonexistent in DB	`datetime`	Authorized Date	-
Description:Contains data from service's field authorized_date
	`AuthorizedDatetime`Nonexistent in DB	`datetime`	Authorized Datetime	-
Description:Contains data from service's field authorized_datetime
	`ByOrderOf`Nonexistent in DB	`nvarchar(MAX)`	By Order Of	-
Description:Contains data from service's field by_order_of
	`CardNumber`Nonexistent in DB	`nvarchar(MAX)`	Card Number	-
Description:Contains data about the card number from the file.
	`Category`Nonexistent in DB	`nvarchar(MAX)`	Category	-
Description:No description available
	`CategoryGuid`Nonexistent in DB	`nvarchar(MAX)`	Category GUID	-
Description:Contains data from service's field category_guid
	`CheckNumber`Nonexistent in DB	`nvarchar(MAX)`	Check Number	-
Description:No description available
	`City`Nonexistent in DB	`nvarchar(MAX)`	City	-
Description:Contains data from service's field city
	`Country`Nonexistent in DB	`nvarchar(MAX)`	Country	-
Description:Contains data from service's field country
	`CreatedAt`Nonexistent in DB	`datetime`	Created At	-
Description:Contains data from service's field created_at
	`CreditAmount`Nonexistent in DB	`decimal`	Receipt Amount	-
Description:Contains data about the credit amount from the file.
	`Date`Nonexistent in DB	`datetime`	Date	-
Description:No description available
	`DatetimeValue`Nonexistent in DB	`datetime`	Datetime Value	-
Description:Contains data from service's field datetime
	`DebitAmount`Nonexistent in DB	`decimal`	Disbursement Amount	-
Description:Contains data about the debit amount from the file.
	`DebitCreditParameter`Nonexistent in DB	`nvarchar(MAX)`	Debit/Credit Property in Separate Column	-
Description:Contains data about the debit/credit parameter from the file.
	`ExtendedTransactionType`Nonexistent in DB	`nvarchar(MAX)`	Extended Transaction Type	-
Description:Contains data from service's field extended_transaction_type
	`ExtRefNbr`Nonexistent in DB	`nvarchar(MAX)`	Ext. Ref. Nbr.	-
Description:Contains data about the external ref. number from the file.
	`Id`Nonexistent in DB	`nvarchar(MAX)`	ID	-
Description:Contains data from service's field id
	`InvoiceInfo`Nonexistent in DB	`nvarchar(MAX)`	Invoice Nbr.	-
Description:Contains data about the invoice number from the file.
	`IsBillPay`Nonexistent in DB	`bit`	Is Bill Pay	-
Description:Contains data from service's field is_bill_pay
	`IsDirectDeposit`Nonexistent in DB	`bit`	Is Direct Deposit	-
Description:Contains data from service's field is_direct_deposit
	`IsExpense`Nonexistent in DB	`bit`	Is Expense	-
Description:Contains data from service's field is_expense
	`IsFee`Nonexistent in DB	`bit`	Is Fee	-
Description:Contains data from service's field is_fee
	`IsIncome`Nonexistent in DB	`bit`	Is Income	-
Description:Contains data from service's field is_income
	`IsInternational`Nonexistent in DB	`bit`	Is International	-
Description:Contains data from service's field is_international
	`IsoCurrencyCode`Nonexistent in DB	`nvarchar(MAX)`	Currency Code	-
Description:No description available
	`IsOverdraftFee`Nonexistent in DB	`bit`	Is Overdraft Fee	-
Description:Contains data from service's field is_overdraft_fee
	`IsPayrollAdvance`Nonexistent in DB	`bit`	Is Payroll Advance	-
Description:Contains data from service's field is_payroll_advance
	`IsRecurring`Nonexistent in DB	`bit`	Is Recurring	-
Description:Contains data from service's field is_recurring
	`IsSubscription`Nonexistent in DB	`bit`	Is Subscription	-
Description:Contains data from service's field is_subcription
	`Latitude`Nonexistent in DB	`decimal`	Latitude	-
Description:Contains data from service's field latitude
	`LocalizedDescription`Nonexistent in DB	`nvarchar(MAX)`	Localized Description	-
Description:Contains data from service's field localized_description
	`LocalizedMemo`Nonexistent in DB	`nvarchar(MAX)`	Localized Memo	-
Description:Contains data from service's field localized_memo
	`Longitude`Nonexistent in DB	`decimal`	Longitude	-
Description:Contains data from service's field longitude
	`MemberIsManagedByUser`Nonexistent in DB	`bit`	Member Is Managed By User	-
Description:Contains data from service's field member_is_managed_by_user
	`Memo`Nonexistent in DB	`nvarchar(MAX)`	Memo	-
Description:No description available
	`MerchantCategoryCode`Nonexistent in DB	`int`	Merchant Category Code	-
Description:Contains data from service's field merchant_category_code
	`MerchantGuid`Nonexistent in DB	`nvarchar(MAX)`	Merchant GUID	-
Description:Contains data from service's field merchant_guid
	`MerchantLocationGuid`Nonexistent in DB	`nvarchar(MAX)`	Merchant Location GUID	-
Description:Contains data from service's field merchant_location_guid
	`MerchantName`Nonexistent in DB	`nvarchar(MAX)`	Merchant Name	-
Description:Contains data from service's field merchant_name
	`Metadata`Nonexistent in DB	`nvarchar(MAX)`	Metadata	-
Description:Contains data from service's field metadata
	`Name`Nonexistent in DB	`nvarchar(MAX)`	Name	-
Description:No description available
	`OriginalDescription`Nonexistent in DB	`nvarchar(MAX)`	Original Description	-
Description:Contains data from service's field original_description
	`PartnerAccountId`Nonexistent in DB	`nvarchar(MAX)`	Partner Account ID	-
Description:No description available
	`Payee`Nonexistent in DB	`nvarchar(MAX)`	Payee	-
Description:Contains data from service's field payee
	`PayeeName`Nonexistent in DB	`nvarchar(MAX)`	Payee/Payer	-
Description:Contains data about Payee/Payer from the file.
	`Payer`Nonexistent in DB	`nvarchar(MAX)`	Payer	-
Description:Contains data from service's field payer
	`PaymentChannel`Nonexistent in DB	`nvarchar(MAX)`	Payment Channel	-
Description:Contains data from service's field payment_channel
	`PaymentMethod`Nonexistent in DB	`nvarchar(MAX)`	Payment Method	-
Description:Contains data from service's field payment_method
	`PaymentProcessor`Nonexistent in DB	`nvarchar(MAX)`	Payment Processor	-
Description:Contains data from service's field payment_processor
	`Pending`Nonexistent in DB	`bit`	Pending	-
Description:No description available
	`PendingTransactionID`Nonexistent in DB	`nvarchar(MAX)`	Pending Transaction ID	-
Description:No description available
	`PersonalFinanceCategory`Nonexistent in DB	`nvarchar(MAX)`	Personal Finance Category	-
Description:Contains data from service's field personal_finance_category
	`PostalCode`Nonexistent in DB	`nvarchar(MAX)`	Postal Code	-
Description:Contains data from service's field postal_code
	`PostedAt`Nonexistent in DB	`datetime`	Posted At	-
Description:Contains data from service's field posted_at
	`PpdId`Nonexistent in DB	`nvarchar(MAX)`	PPD ID	-
Description:Contains data from service's field ppd_id
	`Reason`Nonexistent in DB	`nvarchar(MAX)`	Reason	-
Description:Contains data from service's field reason
	`ReferenceNumber`Nonexistent in DB	`nvarchar(MAX)`	Reference Number	-
Description:Contains data from service's field reference_number
	`Region`Nonexistent in DB	`nvarchar(MAX)`	Region	-
Description:Contains data from service's field region
	`StoreNumber`Nonexistent in DB	`nvarchar(MAX)`	Store Number	-
Description:Contains data from service's field store_number
	`TranCode`Nonexistent in DB	`nvarchar(MAX)`	Tran. Code	-
Description:Contains data about the transaction code from the file.
	`TransactedAt`Nonexistent in DB	`datetime`	Transacted At	-
Description:Contains data from service's field transacted_at
	`TransactionCode`Nonexistent in DB	`nvarchar(MAX)`	Transaction Code	-
Description:Contains data from service's field transaction_code
	`Type`Nonexistent in DB	`nvarchar(MAX)`	Type	-
Description:No description available
	`UnofficialCurrencyCode`Nonexistent in DB	`nvarchar(MAX)`	Unofficial Currency Code	-
Description:Contains data from service's field unofficial_currency_code
	`UpdatedAt`Nonexistent in DB	`datetime`	Updated At	-
Description:Contains data from service's field updated_at
	`UserDesc`Nonexistent in DB	`nvarchar(MAX)`	Custom Tran. Desc.	-
Description:Contains data about the custom transaction description from the file.
	`UserId`Nonexistent in DB	`nvarchar(MAX)`	User ID	-
Description:Contains data from service's field user_id