public Business() : base("businesses") { Fields = new DBField[] { new DBField("id", FieldType.Numeric, true, false), new DBField("business_name", FieldType.Text, false, false), new DBField("taxid_number", FieldType.Text, false, false), new DBField("comments", FieldType.Text, false, false), }; }
public ImportData() : base("import_data") { Fields = new DBField[] { new DBField("id", FieldType.Text, true, false), new DBField("import_date", FieldType.Date, false, false), new DBField("account_id", FieldType.Text, false, false), new DBField("data", FieldType.Text, false, false) }; }
public Account() : base("accounts") { Fields = new DBField[] { new DBField("id", FieldType.Text, true, false), new DBField("account_name", FieldType.Text, false, false), new DBField("routing_number", FieldType.Text, false, false), new DBField("account_number", FieldType.Text, false, false), new DBField("comments", FieldType.Text, false, false), new DBField("last_import", FieldType.Text, false, false) }; }
public Ledger() : base("ledger") { Fields = new DBField[] { new DBField("id", FieldType.Numeric, true, true), new DBField("business_id", FieldType.Numeric, false, false), new DBField("entry_date", FieldType.Date, false, false), new DBField("entry_type", FieldType.Text, false, false), new DBField("entry_amount", FieldType.Numeric, false, false), new DBField("entry_account", FieldType.Text, false, false), new DBField("description", FieldType.Text, false, false), new DBField("comments", FieldType.Text, false, false) }; }
public BankTransaction() : base("bank_transactions") { Fields = new DBField[] { new DBField("transaction_id", FieldType.Text, true, false), new DBField("account_id", FieldType.Text, true, false), new DBField("check_register_id", FieldType.Text, false, false), new DBField("trans_date", FieldType.Date, false, false), new DBField("trans_type", FieldType.Text, true, false), new DBField("check_number", FieldType.Text, false, false), new DBField("trans_name", FieldType.Text, false, false), new DBField("description", FieldType.Text, false, false), new DBField("trans_amount", FieldType.Numeric, true, false) }; }
public CheckRegister() : base("check_register") { Fields = new DBField[] { new DBField("id", FieldType.Text, true, false), new DBField("account_id", FieldType.Text, false, false), new DBField("trans_date", FieldType.Date, false, false), new DBField("trans_type", FieldType.Text, false, false), new DBField("check_number", FieldType.Text, false, false), new DBField("description", FieldType.Text, false, false), new DBField("amount", FieldType.Numeric, false, false), new DBField("trans_category", FieldType.Text, false, false), new DBField("cleared", FieldType.Numeric, false, false), new DBField("comments", FieldType.Text, false, false), new DBField("archived", FieldType.Numeric, false, false) }; }