ImportCreditCardStatement
Imports your bank/credit card feeds into your account.
Execute
Import your bank/credit card feeds into your account:
INSERT INTO ImportCreditCardStatement#TEMP (TransactionsTransactionId, TransactionsTransactionDate, TransactionsTransactionDebitOrCredit, TransactionsTransactionAmount) VALUES ('3255827000000150156', '2023-03-27', 'Debit', '6000')
EXEC ImportCreditCardStatement AccountId = '3255827000000150152', StartDate= '2023-03-01', EndDate = '2023-03-31', Transactions = ImportCreditCardStatement#TEMP
EXEC ImportCreditCardStatement AccountId = '3255827000000150152', StartDate = '2023-03-01', EndDate = '2023-03-31', TransactionsTransactionId = 3255827000000150156, TransactionsTransactionDate = 2023-03-27, TransactionsTransactionDebitOrCredit = debit, TransactionsTransactionAmount = 6000
Input
| Name | Type | Required | Description |
| AccountId | String | True | Id of the Bank/Credit Card account |
| StartDate | Date | False | Least date in the transaction set |
| EndDate | Date | False | Greatest date in the transaction set |
| Transactions | String | False | Transactions |
| TransactionsTransactionId | String | False | Least date in the transaction set |
| TransactionsTransactionDate | Date | False | Date of the transaction |
| TransactionsTransactionDebitOrCredit | String | False | Indicates if transaction is Debit or Credit |
| TransactionsTransactionAmount | String | False | Amount involved in the transaction |
| TransactionsTransactionPayee | String | False | Payee involved in the transaction |
| TransactionsTransactionDescription | String | False | Transaction description |
| TransactionsTransactionReferenceNumber | String | False | Reference Number of the transaction |
Result Set Columns
| Name | Type | Description |
| Status | String | Stored procedure execution status. |