· 6 years ago · Dec 31, 2019, 05:56 PM
1CREATE TABLE IF NOT EXISTS "ob_transaction" (
2 "Data_Transaction_AccountId" INT,
3 "Data_Transaction_TransactionId" INT,
4 "Data_Transaction_TransactionReference" TEXT,
5 "Data_Transaction_Amount_Amount" NUMERIC(4, 2),
6 "Data_Transaction_Amount_Currency" TEXT,
7 "Data_Transaction_CreditDebitIndicator" TEXT,
8 "Data_Transaction_Status" TEXT,
9 "Data_Transaction_BookingDateTime" TEXT,
10 "Data_Transaction_ValueDateTime" TEXT,
11 "Data_Transaction_TransactionInformation" TEXT,
12 "Data_Transaction_BankTransactionCode_Code" TEXT,
13 "Data_Transaction_BankTransactionCode_SubCode" TEXT,
14 "Data_Transaction_ProprietaryBankTransactionCode_Code" TEXT,
15 "Data_Transaction_ProprietaryBankTransactionCode_Issuer" TEXT,
16 "Data_Transaction_Balance_Amount_Amount" NUMERIC(5, 2),
17 "Data_Transaction_Balance_Amount_Currency" TEXT,
18 "Data_Transaction_Balance_CreditDebitIndicator" TEXT,
19 "Data_Transaction_Balance_Type" TEXT
20);
21INSERT INTO "ob_transaction" VALUES
22 (22289,123,'Ref 1',10.00,'GBP','Credit','Booked','2017-04-05T10:43:07+00:00','2017-04-05T10:45:22+00:00','Cash from Aubrey','ReceivedCreditTransfer','DomesticCreditTransfer','Transfer','AlphaBank',230.00,'GBP','Credit','InterimBooked');