tr_sales_gross_profit_by_ctgr_product

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

CREATE TABLE tr_sales_gross_profit_by_ctgr_product
(
    sales_gross_profit_by_ctgr_product_id bigint NOT NULL DEFAULT nextval('tr_sales_gross_profit_by_ctgr_product_seq'),
    session_id character varying(50),
    tenant_id bigint,
    ou_id bigint,
    year_month_date character varying(6),
    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),
    doc_type_id bigint,
    doc_no character varying(30),
    doc_date character varying(8),
    product_id bigint,
    curr_code character varying(5),
    qty numeric,
    nett_sell_price numeric,
    nett_amount_item numeric,
    monthly_price_curr_code character varying(5),
    monthly_price_amount numeric,
    flg_use_receive_goods character varying(1) DEFAULT 'N',
    CONSTRAINT tr_sales_gross_profit_by_ctgr_product_pkey PRIMARY KEY (sales_gross_profit_by_ctgr_product_id)
)
WITH(
    OIDS=FALSE
);

CREATE INDEX idx_tr_sales_gross_profit_by_ctgr_product_01
  ON tr_sales_gross_profit_by_ctgr_product
  USING btree
  (session_id, tenant_id, year_month_date, ou_id, partner_id, ctgr_product_id);