ODBC Driver for Zoho Books

Build 24.0.9060

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060