fun_insert_conceptos

fun_insert_conceptos(
    wnom_concepto VARCHAR,
    wind_operacion BOOLEAN,
    wind_perio_pago CHAR(1),
    wneto_pagado BOOLEAN,
    wval_porcent NUMERIC,
    wval_fijo NUMERIC,
    wind_legal BOOLEAN
) RETURNS BOOLEAN

-- Insert a new concept
SELECT fun_insert_conceptos(
    'concepto3',
    FALSE,
    'Q',
    TRUE,
    0,
    1067625,
    TRUE
);

-- Insert a percentage-based deduction
SELECT fun_insert_conceptos(
    'Health Insurance',
    FALSE,
    'M',
    TRUE,
    4,
    0,
    TRUE
);