CREATE TABLE SUP_SALARY
(
  SUP_SALARY_ID  CHARACTER VARYING(32)		NOT NULL,
  AD_CLIENT_ID  CHARACTER VARYING(32)		NOT NULL,
  AD_ORG_ID     CHARACTER VARYING(32)		NOT NULL,
  ISACTIVE      CHARACTER(1)                   NOT NULL        DEFAULT 'Y',
  CREATED       TIMESTAMP WITHOUT TIME ZONE 	NOT NULL 	DEFAULT now(),
  CREATEDBY     CHARACTER VARYING(32)		NOT NULL,
  UPDATED       TIMESTAMP WITHOUT TIME ZONE 	NOT NULL 	DEFAULT now(),
  UPDATEDBY     CHARACTER VARYING(32)         	NOT NULL,
  m_product_ch_conf_id character varying(32) NOT NULL,
  AMOUNT	 NUMERIC 	      	        NOT NULL,
    CONSTRAINT SUP_ISACTIVE_CHECK CHECK (isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])),
    CONSTRAINT SUP_SALARY_KEY PRIMARY KEY (SUP_SALARY_ID), 
    CONSTRAINT AD_ORG_SUP_PROJECT FOREIGN KEY (AD_ORG_ID)
     REFERENCES AD_ORG (AD_ORG_ID), 
    CONSTRAINT AD_CLIENT_SUP_PROJECT FOREIGN KEY (AD_CLIENT_ID)
     REFERENCES AD_CLIENT (AD_CLIENT_ID),
    CONSTRAINT SUP_m_prod_ch_conf_fk FOREIGN KEY (m_product_ch_conf_id)
      REFERENCES m_product_ch_conf (m_product_ch_conf_id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE CASCADE
);