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