Financial Account Transaction DMO

Object API Name: std__FinancialAccountTransactionDmo__dlm
Category: Unassigned
Availability: Available in 254 and later versions
Primary Key Field: Id

• FinancialAccountID has a FOREIGNKEY relationship with the Financial Account DMO Id field.

• AccruedInterestAmount
• AcquiringBankName
• AuthorizationRecordText
• CardSchemeName
• CashFlowType
• cdp_sys_record_currency
• City
• Country
• CountryRegion
• CreatedDate
• Currency
• DataSourceId
• DataSourceObjectId
• Description
• FeeAmount
• FinanceCategoryDescription
• FinancialAccountId
• FinancialAccountTransactionStatus
• FinancialAccountTransactionType
• FinancialTransactionCategory
• ForexConversionChargeAmount
• Id
• InternalOrganizationId
• IsBillPay
• IsDeleted
• IsDirectDeposit
• IsExpense
• IsFee
• IsIncome
• IsOverdraftFee
• IsPayrollAdvance
• IsSubscription
• IssuingBankName
• Latitude
• Longitude
• MechantLocationIdentifier
• MemoText
• MerchantAddressStreet
• MerchantCategoryCode
• MerchantLogoUrl
• MerchantName
• MerchantWebsite
• NameInterfaceField
• OwnerId
• PostalCode
• RunningBalanceAmount
• SecretKeyIdentifier
• SourceSystemIdentifier
• SourceTransactionIdentifier
• SourceTransactionTypeCode
• StoreNumber
• TargetAccountIdentifier
• TransactionAmount
• TransactionDate
• TransactionFrequency
• TransactionLocationName
• TransactionPostedDate
• TransactionQuantityCt
• TransactionSubType
• UnitPriceAmount

• Field API Name: std__AccruedInterestAmount__c
• Data Type: DOUBLE
• Description: The accrued interest amount bought or sold as part of a bond transaction.

• Field API Name: std__AcquiringBankName__c
• Data Type: TEXT
• Description: Name of merchant acquirer.

• Field API Name: std__AuthorizationRecordText__c
• Data Type: TEXT
• Description: authorization code for transaction (if credit or debit).

• Field API Name: std__CardSchemeName__c
• Data Type: TEXT
• Description: The name of the card scheme for the financial account transaction. Maximum size is 255 characters.

• Field API Name: std__CashFlowType__c
• Data Type: TEXT
• Description: Direction of the transaction from the perspective of the account holder: inflow, outflow.

• Field API Name: std__cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

• Field API Name: std__City__c
• Data Type: TEXT
• Description: City where merchant is located.

• Field API Name: std__Country__c
• Data Type: TEXT
• Description: Country where merchant is located.

• Field API Name: std__CountryRegion__c
• Data Type: TEXT
• Description: The state or county where the merchant is located.

• Field API Name: std__CreatedDate__c
• Data Type: DATETIME
• Description: The date and time the record was originally created.

• Field API Name: std__Currency__c
• Data Type: TEXT
• Description: ISO 4217 currency code associated with the record.

• Field API Name: std__DataSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__DataSourceObjectId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__Description__c
• Data Type: TEXT
• Description: Description of the Financial Account Transaction.

• Field API Name: std__FeeAmount__c
• Data Type: DOUBLE
• Description: The transaction fee or commission amount charged.

• Field API Name: std__FinanceCategoryDescription__c
• Data Type: TEXT
• Description: Information describing the intent of the transaction (bill pay, fee,) Some providers use this in place of the booleans above. Most relevant for personal finance use cases, but not limited to such use cases.

• Field API Name: std__FinancialAccountId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__FinancialAccountTransactionStatus__c
• Data Type: TEXT
• Description: Status of the Transaction. For example, Pending Posted.

• Field API Name: std__FinancialAccountTransactionType__c
• Data Type: TEXT
• Description: Type of Transaction. For example, Credit, Debit.

• Field API Name: std__FinancialTransactionCategory__c
• Data Type: TEXT
• Description: Name of the category or sub category For example, Electronics, Grocery, Bill.

• Field API Name: std__ForexConversionChargeAmount__c
• Data Type: DOUBLE
• Description: Amount of charge within the transaction relating to Forex conversion.

• Field API Name: std__Id__c
• Data Type: TEXT
• Description: Required. A unique, system-generated identifier for this FinancialAccountTransaction record. Maximum size is 15 characters.

• Field API Name: std__InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__IsBillPay__c
• Data Type: TEXT
• Description: Whether the transaction represents a bill pay (true) or not (false).

• Field API Name: std__IsDeleted__c
• Data Type: BOOLEAN
• Description: Indicates whether this record is deleted (true) or not (false).

• Field API Name: std__IsDirectDeposit__c
• Data Type: TEXT
• Description: Whether the transaction represents a direct deposit (true) or not (false).

• Field API Name: std__IsExpense__c
• Data Type: TEXT
• Description: Whether the transaction represents an expense (true) or not (false).

• Field API Name: std__IsFee__c
• Data Type: TEXT
• Description: Whether the transaction represents a fee (true) or not (false).

• Field API Name: std__IsIncome__c
• Data Type: TEXT
• Description: When the Software Application or Web Page that generated the Engagement was accessed via a link or deep link this stores the URL that was used (personalized).

• Field API Name: std__IsOverdraftFee__c
• Data Type: TEXT
• Description: Whether the transaction represents an overdraft fee (true) or not (false).

• Field API Name: std__IsPayrollAdvance__c
• Data Type: TEXT
• Description: Whether the transaction is a payroll advance (true) or not (false).

• Field API Name: std__IsSubscription__c
• Data Type: TEXT
• Description: Whether the transaction is a subscription (true) or not (false).

• Field API Name: std__IssuingBankName__c
• Data Type: TEXT
• Description: Issuing bank of credit/debit card.

• Field API Name: std__Latitude__c
• Data Type: DOUBLE
• Description: Latitude of the merchant location, number is a signed decimal. For example, Rio de Janeiro is -22.9027800.

• Field API Name: std__Longitude__c
• Data Type: DOUBLE
• Description: The longitude of the merchant location.

• Field API Name: std__MechantLocationIdentifier__c
• Data Type: TEXT
• Description: Unique identifier for the merchant location, defined by MX.

• Field API Name: std__MemoText__c
• Data Type: TEXT
• Description: Contains additional descriptive information about the transaction.

• Field API Name: std__MerchantAddressStreet__c
• Data Type: TEXT
• Description: Street address where the merchant is located.

• Field API Name: std__MerchantCategoryCode__c
• Data Type: TEXT
• Description: Identifier of the type of business undertaken by a merchant. For example, retail, construction, hardware, beauty.

• Field API Name: std__MerchantLogoUrl__c
• Data Type: TEXT
• Description: The URL of a logo associated with the counterparty, if available. The logo is formatted as a 100x100 pixel PNG file.

• Field API Name: std__MerchantName__c
• Data Type: TEXT
• Description: Reference of the merchant accepting payment of debit/credit card.

• Field API Name: std__MerchantWebsite__c
• Data Type: TEXT
• Description: Merchant website.

• Field API Name: std__NameInterfaceField__c
• Data Type: TEXT
• Description: Name of this record.

• Field API Name: std__OwnerId__c
• Data Type: TEXT
• Description: Reference to the owner of the record.

• Field API Name: std__PostalCode__c
• Data Type: TEXT
• Description: The postal code where the merchant is located.

• Field API Name: std__RunningBalanceAmount__c
• Data Type: DOUBLE
• Description: Running balance for the transaction.

• Field API Name: std__SecretKeyIdentifier__c
• Data Type: TEXT
• Description: Placeholder for API secret if transactions pulled in from open banking for example.

• Field API Name: std__SourceSystemIdentifier__c
• Data Type: TEXT
• Description: Record ID from an external data source.

• Field API Name: std__SourceTransactionIdentifier__c
• Data Type: TEXT
• Description: ID that uniquely identifies the transaction in an external data source.

• Field API Name: std__SourceTransactionTypeCode__c
• Data Type: TEXT
• Description: Source transaction type from an external data source.

• Field API Name: std__StoreNumber__c
• Data Type: TEXT
• Description: The merchant defined store number where the transaction occurred.

• Field API Name: std__TargetAccountIdentifier__c
• Data Type: TEXT
• Description: Account a payment is going to. For example, to indicate a transfer between accounts.

• Field API Name: std__TransactionAmount__c
• Data Type: DOUBLE
• Description: Required. The transaction amount for the financial account transaction.

• Field API Name: std__TransactionDate__c
• Data Type: DATETIME
• Description: Date of Transaction.

• Field API Name: std__TransactionFrequency__c
• Data Type: TEXT
• Description: Biweekly, monthly, annually,

• Field API Name: std__TransactionLocationName__c
• Data Type: TEXT
• Description: Location of the transaction.

• Field API Name: std__TransactionPostedDate__c
• Data Type: DATETIME
• Description: Date the transaction posted to the account.

• Field API Name: std__TransactionQuantityCt__c
• Data Type: DOUBLE
• Description: The number of shares or units involved in the transaction.

• Field API Name: std__TransactionSubType__c
• Data Type: TEXT
• Description: Alphanumeric string representing the transaction sub type.

• Field API Name: std__UnitPriceAmount__c
• Data Type: DOUBLE
• Description: The per-unit price amount at which the transaction was executed.