ERP 2.50:Acceptance Testing/Create payment terms script PostgreSQL
Scripts for 2.40/2.3x
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();
Scripts 2.50 or higher
CREATE OR REPLACE FUNCTION create_paymentTerm()
RETURNS void AS
$BODY$ DECLARE
v_paymentterm_id varchar(32);
v_client_id varchar(32);
BEGIN
SELECT AD_CLIENT_ID INTO v_client_id FROM AD_CLIENT WHERE created=(SELECT max(created) FROM ad_client);
SELECT get_uuid() INTO v_paymentterm_id;
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');
END ; $BODY$
LANGUAGE 'plpgsql' VOLATILE;
SELECT create_paymentTerm();
DROP FUNCTION create_paymentTerm();