Information for the FinancialPaymentDetail

Columns

  • Id (datatype: int) Required Primary Key
  • AccountNumberMasked (datatype: nvarchar(max)) Required Primary Key
  • CurrencyTypeValueId (datatype: int) Required Primary Key
  • CreditCardTypeValueId (datatype: int) Required Primary Key
  • NameOnCardEncrypted (datatype: nvarchar(256)) Required Primary Key
  • ExpirationMonthEncrypted (datatype: nvarchar(256)) Required Primary Key
  • ExpirationYearEncrypted (datatype: nvarchar(256)) Required Primary Key
  • BillingLocationId (datatype: int) Required Primary Key
  • CreatedDateTime (datatype: datetime) Required Primary Key
  • ModifiedDateTime (datatype: datetime) Required Primary Key
  • CreatedByPersonAliasId (datatype: int) Required Primary Key
  • ModifiedByPersonAliasId (datatype: int) Required Primary Key
  • Guid (datatype: uniqueidentifier) Required Primary Key
  • ForeignKey (datatype: nvarchar(100)) Required Primary Key
  • ForeignGuid (datatype: uniqueidentifier) Required Primary Key
  • ForeignId (datatype: int) Required Primary Key
  • GatewayPersonIdentifier (datatype: nvarchar(50)) Required Primary Key
  • FinancialPersonSavedAccountId (datatype: int) Required Primary Key
  • NameOnCard (datatype: nvarchar(max)) Required Primary Key
  • CardExpirationDate (datatype: datetime) Required Primary Key
  • ExpirationMonth (datatype: int) Required Primary Key
  • ExpirationYear (datatype: int) Required Primary Key