pola techniczne/poza zakresem- nie zostaną wystawione w docelowym widoku
(refrencja) - zostanie dostarczona wartość ze słownika (nie id)
key - wartość klucza obcego (łączącego widoki)
wszystkie daty w formacie:
[BankAccount]
[Id] [int] IDENTITY(1,1) NOT NULL,
[AccountName] nvarchar NULL,
[AccountNumber] nvarchar NULL,
[userExternalId] nvarchar NOT NULL,
[CreateDate] datetime2 NOT NULL,
[Currency] nvarchar NOT NULL,Currency ISO code
[BankSwiftCode] nvarchar NOT NULL,
[SyncFromDate] datetime2 NULL,
[SyncLastDate] datetime2 NULL,
[HolderInfo] nvarchar NULL, dane posiadacza rachunku (imię, nazwisko, adres) *nie zawsze zwracana przez ASPSP
[AccountTypeName] nvarchar NULL,
[BankAccountType] [int] NULL, - wartość słownikowa (ChargeCard, CreditCard, CurrentAccount, EMoney, Loan, Mortgage, PrePaidCard, Savings)
[HolderType] [int] NULL, - wartość słownikowa (individual, corporation)
Do sprawdzenie informacje o referencji do zgody. Zgoda zawiera informacje o kontach objętych jej zakresem. Jeden rachunek może być objęty więcej niż jedną zgodą więc referencja do zgody nie jest zwracna na poziomie rachunku.
[BankAccountBalance]
[Id] [int] IDENTITY(1,1) NOT NULL,
[Amount] [decimal](18, 2) NOT NULL,
[Currency] nvarchar NOT NULL,Currency ISO code
[BalanceDate] datetime2 NOT NULL, - data na którą ASPSP wskazał wartość balansu
[BalanceType] [int] NULL, - Balance type name (refrencja), zgodnie ze słownikiem *
[BankAccountId] [int] NOT NULL, - key- referencja do bankaccount.id
1 public enum BalanceTypeEnum 2 { 3 ClosingAvailable = 1, 4 ClosingBooked, 5 Expected, 6 ForwardAvailable, 7 Information, 8 InterimAvailable, 9 InterimBooked, 10 OpeningAvailable, 11 OpeningBooked, 12 PreviouslyClosedBooked, 13 Other 14 } 15}
[Transaction]
[Id] [int] IDENTITY(1,1) NOT NULL,
[AccountingDate] datetime2 NULL,
[Address] nvarchar NULL,
[BankAccountId] [int] NOT NULL, - key- referencja do bankaccount.id
[BankName] nvarchar NULL, - wartość zwracana przez ASPSP
[CurrencyDate] datetime2 NULL,
[Currency] nvarchar NOT NULL, - Currency ISO code
[Amount] [decimal](18, 2) NOT NULL,
[Owner] nvarchar NULL,
[Recipient] nvarchar NULL,
[RecipientBankAddress] nvarchar NULL,
[RecipientBankCode] nvarchar NULL,
[RecipientBankName] nvarchar NULL,
[RecipientNameAddress] nvarchar NULL,
[RecipientAccount] nvarchar NULL,
[RecipientBankBicOrSwift] nvarchar NULL,
[RecipientCountryCode] nvarchar NULL,
[Sender] nvarchar NULL,
[SenderAddress] nvarchar NULL,
[SenderBankBicOrSwift] nvarchar NULL,
[SenderAccount] nvarchar NULL,
[SenderAccountMassPayment] nvarchar NULL,
[SenderBankAddress] nvarchar NULL,
[SenderBankCountryCode] nvarchar NULL,
[SenderBankCode] nvarchar NULL,
[SenderBankName] nvarchar NULL,
[SenderNameAddress] nvarchar NULL,
[ReferenceNumber] nvarchar NULL,
[Title] nvarchar NULL,
[TransactionStatus] [int] NOT NULL, status name (refrencja)
[EffectiveDate] datetime2 NULL,
[OrdinalNumber] [bigint] NOT NULL,
[ExternalNumber] nvarchar NULL,
[Initiator] nvarchar NULL,
[TransactionType] nvarchar NULL,
[CreditOrDebit] [int] NOT NULL, - wartość słownikowa (debit,credit)
[OriginalTransactionType] nvarchar NULL,
[LastSyncDate] datetime2 NULL,
IsTransactionDetail - flaga [0,1] oznaczająca czy istnieją szczegóły transakcji
BankSwiftCode
ExternalUserId
[TransactionDetail]
[TransactionId] [int] NOT NULL,- key- referencja do transaction.id
[RejectionReason] nvarchar NULL,
[HoldExpirationDate] datetime2 NULL,
[SiiContributionId] nvarchar NULL,
[SiiAdditionalPayerIdentification] nvarchar NULL,
[SiiAdditionalPayerIdentificationType] nvarchar NULL,
[SiiObligationId] nvarchar NULL,
[SiiTaxPayerIdentification] nvarchar NULL,
[SiiContributionType] nvarchar NULL,
[SiiPaymentTypeIdentification] nvarchar NULL,
[SiiContributionPeriod] nvarchar NULL,
[TaxPayerIdentification] nvarchar NULL,
[TaxObligationId] nvarchar NULL,
[TaxFormCode] nvarchar NULL,
[TaxPayerIdentificationType] nvarchar NULL,
[TaxPeriodId] nvarchar NULL,
[TaxPeriodType] nvarchar NULL,
[TaxPeriodYear] nvarchar NULL,
[CardHolder] nvarchar NULL,
[CardNumber] nvarchar NULL,
[FxOriginalCurrencyCode] nvarchar NULL,
[FxToCurrencyCode] nvarchar NULL,
[FxCurrencyDate] datetime2 NULL,
[FxFromCurrency] nvarchar NULL,
[FxOriginalCurrencyAmount] [decimal](18, 2) NULL,
[PaymentInstrumentIdentification] nvarchar NULL,
[TppReferenceIdentification] nvarchar NULL,
[TppName] nvarchar NULL,
BankSwiftCode
ExternalUserId
[Payment]
[Amount] [decimal](18, 2) NOT NULL,
[BankAccountId] [int] NULL,- key- referencja do bankaccount.id
[CurrencyId] [int] NOT NULL, - Currency ISO code (refrencja)
[PaymentDate] datetime2 NOT NULL,
[ExternalUserId] nvarchar NULL,
[RecipientName] nvarchar NULL,
[RecipientAddress] nvarchar NULL,
[RecipientBankAccountIdentifierValue] nvarchar NULL,
[SenderBankAccountIdentifierValue] nvarchar NULL,
[SenderName] nvarchar NULL,
[PaymentStatus] [int] NOT NULL, PaymentStatus name referencja
[Title] nvarchar NULL,
[ExternalTransactionId] nvarchar NULL,
[TransactionSubmissionId] nvarchar NULL,
[ExternalId] nvarchar NULL,
[BankSwiftCode] NOT NULL, - Bank SWIFT code (referencja)
[Id] [uniqueidentifier] NOT NULL,
[SenderBankAccountIdentifierScheme] [int] NOT NULL,
[RecipientBankIdentifierScheme] [int] NULL,
[RecipientBankIdentifierValue] nvarchar NULL,
[RecipientBankAccountIdentifierScheme] [int] NOT NULL,
[Psd2SessionId] [uniqueidentifier] NOT NULL,
[DeliveryMode] nvarchar NULL,
[DeliverySystem] nvarchar NULL,
[ExecutionMode] nvarchar NULL,
[TppTransactionId] nvarchar NULL,
[Consent]
- lista zgód per user
Do sprawdzenie informacje o referencji do zgody.
[ConsentId] nvarchar NOT NULL
[ExternalId] nvarchar NOT NULL
[Content] nvarchar NULL
[PurposeNames] nvarchar NULL
[BankName] nvarchar NULL
[BankSwiftCode] nvarchar NOT NULL
[Status] nvarchar NOT NULL -słownik
[CreateDate] datetime2 NOT NULL
[ExpirationDate] datetime2 NOT NULL
[previousStatus] nvarchar NULL
[userExternalId] nvarchar NOT NULL,
[userScope] nvarchar NOT NULL
aktualizacja(24.11.2020)
Widoki:
1 [Id] 2 ,[AccountName] 3 ,[AccountNumber] 4 ,[UserExternalId] 5 ,[CreateDate] 6 ,[Currency] 7 ,[BankSwiftCode] 8 ,[SyncFromDate] 9 ,[SyncLastDate] 10 ,[HolderInfo] 11 ,[AccountTypeName] 12 ,[BankAccountType] 13 ,[HolderType] 14 FROM [dbo].[BankAccountView]
1 2 [Id] 3 ,[Amount] 4 ,[Currency] 5 ,[Date] 6 ,[BalanceTypeMap] 7 ,[BankAccountId] 8 FROM [dbo].[BankAccountBalanceView]
1 2 [Id] 3 ,[IsTransactionDetail] 4 ,[BankSwiftCode] 5 ,[UserExternalId] 6 ,[AccountingDate] 7 ,[Address] 8 ,[BankAccountId] 9 ,[BankName] 10 ,[CurrencyDate] 11 ,[Currency] 12 ,[Amount] 13 ,[Owner] 14 ,[Recipient] 15 ,[RecipientBankAddress] 16 ,[RecipientBankCode] 17 ,[RecipientBankName] 18 ,[RecipientNameAddress] 19 ,[RecipientAccount] 20 ,[RecipientBankBicOrSwift] 21 ,[RecipientCountryCode] 22 ,[Sender] 23 ,[SenderAddress] 24 ,[SenderBankBicOrSwift] 25 ,[SenderAccount] 26 ,[SenderAccountMassPayment] 27 ,[SenderBankAddress] 28 ,[SenderBankCountryCode] 29 ,[SenderBankCode] 30 ,[SenderBankName] 31 ,[SenderNameAddress] 32 ,[ReferenceNumber] 33 ,[Title] 34 ,[TransactionStatusEnum] 35 ,[EffectiveDate] 36 ,[OrdinalNumber] 37 ,[ExternalNumber] 38 ,[Initiator] 39 ,[TransactionType] 40 ,[CreditOrDebit] 41 ,[OriginalTransactionType] 42 ,[LastSyncDate] 43 FROM [dbo].[TransactionView]
1 2 [TransactionId] 3 ,[RejectionReason] 4 ,[HoldExpirationDate] 5 ,[SiiContributionId] 6 ,[SiiAdditionalPayerIdentification] 7 ,[SiiAdditionalPayerIdentificationType] 8 ,[SiiObligationId] 9 ,[SiiTaxPayerIdentification] 10 ,[SiiContributionType] 11 ,[SiiPaymentTypeIdentification] 12 ,[SiiContributionPeriod] 13 ,[TaxPayerIdentification] 14 ,[TaxObligationId] 15 ,[TaxFormCode] 16 ,[TaxPayerIdentificationType] 17 ,[TaxPeriodId] 18 ,[TaxPeriodType] 19 ,[TaxPeriodYear] 20 ,[CardHolder] 21 ,[CardNumber] 22 ,[FxOriginalCurrencyCode] 23 ,[FxToCurrencyCode] 24 ,[FxCurrencyDate] 25 ,[FxFromCurrency] 26 ,[FxOriginalCurrencyAmount] 27 ,[PaymentInstrumentIdentification] 28 ,[TppReferenceIdentification] 29 ,[TppName] 30 ,[BankSwiftCode] 31 ,[UserExternalId] 32 FROM [dbo].[TransactionDetailView]
1 [Amount] 2 ,[Currency] 3 ,[PaymentDate] 4 ,[ExternalUserId] 5 ,[RecipientName] 6 ,[RecipientAddress] 7 ,[RecipientBankAccountIdentifierValue] 8 ,[SenderBankAccountIdentifierValue] 9 ,[SenderName] 10 ,[PaymentStatus] 11 ,[Title] 12 ,[ExternalId] 13 ,[BankSwiftCode] 14 ,[Id] 15 ,[SenderBankAccountIdentifierScheme] 16 ,[RecipientBankSwiftCode] 17 ,[RecipientBankAccountIdentifierScheme] 18 ,[Psd2SessionId] 19 ,[DeliveryMode] 20 ,[DeliverySystem] 21 ,[ExecutionMode] 22 FROM [dbo].[PaymentRestApiView]
aktualizcja(30.11.2020)
Przykładowe callbacki na podstawie agregacji kont dla banku mBank(sandbox) oraz mapowania wartości z tych Callbacków: