---
title: insert_new_COA_gncoa
---

# insert_new_COA_gncoa




## Parameters


| **Name** | **Type** |
|----------|----------|
| table_name | VARCHAR(50) |
| ind | INT |
| supaccount | VARCHAR(50) |
| level | INT |
| code_of_account | VARCHAR(50) |
| account_description | VARCHAR(50) |
| total_cost | INT |
| review_status | VARCHAR(50) |
| prn | VARCHAR(50) |
| gncoa | VARCHAR(50) |
| gn_level | INT |
| gn_supaccount | VARCHAR(50) |
| gn_ind | INT |


## SQL Definition

```sql
CREATE PROCEDURE `insert_new_COA_gncoa`(IN table_name VARCHAR(50), IN ind INT, IN supaccount VARCHAR(50), IN level INT, IN code_of_account VARCHAR(50), IN account_description VARCHAR(50), IN total_cost INT, IN review_status VARCHAR(50), IN prn VARCHAR(50), IN gncoa VARCHAR(50), IN gn_level INT, IN gn_supaccount VARCHAR(50), IN gn_ind INT)
BEGIN
    SET @stmt = CONCAT('INSERT INTO ', table_name,
    						' (ind, supaccount, level, code_of_account, account_description, 
    							total_cost, review_status, prn, 
                                gncoa, gn_level, gn_supaccount, gn_ind) 
    							VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)');
    PREPARE stmt FROM @stmt;
    SET @ind = ind;
    SET @supaccount = supaccount;
    SET @level = level;
    SET @code_of_account = code_of_account;
    SET @account_description = account_description;
    SET @total_cost = total_cost;
    SET @review_status = review_status;
    SET @prn = prn;
    SET @gncoa = gncoa; 
    SET @gn_level = gn_level; 
    SET @gn_supaccount = gn_supaccount;
    SET @gn_ind = gn_ind;

    EXECUTE stmt USING @ind, @supaccount, @level, @code_of_account, @account_description,
    @total_cost, @review_status, @prn, @gncoa, @gn_level, @gn_supaccount, @gn_ind;
    DEALLOCATE PREPARE stmt;
END;;