Acceptance Testing/Create payment terms script PostgreSQL

CREATE OR REPLACE FUNCTION create_paymentTerm()
  RETURNS void AS
$BODY$ DECLARE

v_paymentterm_id numeric(10);
v_client_id numeric(10);

BEGIN

SELECT MAX(AD_CLIENT_ID) INTO v_client_id FROM AD_CLIENT;

SELECT COALESCE(MAX(C_PAYMENTTERM_ID),999999) +1 INTO v_paymentterm_id FROM  C_PAYMENTTERM;
 
INSERT INTO C_PAYMENTTERM
(C_PAYMENTTERM_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY,  UPDATED, UPDATEDBY,  NAME, ISDUEFIXED, NETDAYS, FIXMONTHOFFSET,  ISNEXTBUSINESSDAY, ISDEFAULT, VALUE, ISVALID)
VALUES
 (v_paymentterm_id, v_client_id, 0, 'Y', now(), 100, now(), 100, '90 DAYS',  'N', 0, 3, 'N', 'N', '90d', 'N');

PERFORM AD_UPDATE_SEQUENCE();

END ; $BODY$
LANGUAGE 'plpgsql' VOLATILE;

SELECT create_paymentTerm();

drop function create_paymentTerm();