tr_sales_gross_profit_by_ctgr_product_for_output

CREATE SEQUENCE tr_sales_gross_profit_by_ctgr_product_for_output_seq
 INCREMENT 1
 MINVALUE 1
 MAXVALUE 9223372036854775807
 START 10
 CACHE 1;

CREATE TABLE tr_sales_gross_profit_by_ctgr_product_for_output
(
    sales_gross_profit_by_ctgr_product_for_output_id bigint NOT NULL DEFAULT nextval('tr_sales_gross_profit_by_ctgr_product_for_output_seq'),
    session_id character varying(50),
    tenant_id bigint,
    ou_id bigint,
    partner_id bigint,
    partner_code character varying(50),
    partner_name character varying(100),
    ctgr_product_id bigint,
    ctgr_product_code character varying(50),
    ctgr_product_name character varying(100),
    curr_code character varying(5),
    current_sales_amount numeric,
    current_gross_profit numeric,
    rekap_sales_amount numeric,
    rekap_gross_profit numeric,
    CONSTRAINT tr_sales_gross_profit_by_ctgr_product_for_output_pkey PRIMARY KEY (sales_gross_profit_by_ctgr_product_for_output_id)
)
WITH (
    OIDS=FALSE
);

CREATE INDEX idx_tr_sales_gross_profit_by_ctgr_product_for_output_01
   ON tr_sales_gross_profit_by_ctgr_product_for_output
   USING btree
   (session_id, tenant_id, ou_id, partner_id, ctgr_product_id, curr_code);