cb_in_out_cashbank

-- Table: cb_in_out_cashbank

-- DROP TABLE cb_in_out_cashbank;

CREATE TABLE cb_in_out_cashbank
(
  in_out_cashbank_id bigint NOT NULL DEFAULT nextval('cb_in_out_cashbank_seq'::regclass),
  tenant_id bigint,
  doc_type_id bigint,
  doc_no character varying(30),
  doc_date character varying(8),
  ou_id bigint,
  partner_id bigint,
  type_in_out_cashbank character varying(5),
  ext_doc_no character varying(30),
  ext_doc_date character varying(8),
  ref_doc_type_id bigint,
  ref_id bigint,
  ref_curr_code character varying(5),
  ref_amount numeric,
  due_date character varying(8),
  remark character varying(1024),
  status_doc character varying(1),
  workflow_status character varying(50),
  version bigint NOT NULL,
  create_datetime character varying(14),
  create_user_id bigint,
  update_datetime character varying(14),
  update_user_id bigint,
  CONSTRAINT cb_in_out_cashbank_pkey PRIMARY KEY (in_out_cashbank_id)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE cb_in_out_cashbank
  OWNER TO sts;

-- Index: idx_cb_in_out_cashbank_01

-- DROP INDEX idx_cb_in_out_cashbank_01;

CREATE UNIQUE INDEX idx_cb_in_out_cashbank_01
  ON cb_in_out_cashbank
  USING btree
  (tenant_id, doc_type_id, doc_no COLLATE pg_catalog."default", "substring"(doc_date::text, 1, 6) COLLATE pg_catalog."default", ou_id);