cb_trx_cashbank_balance

-- Table: cb_trx_cashbank_balance

-- DROP TABLE cb_trx_cashbank_balance;

CREATE TABLE cb_trx_cashbank_balance
(
  trx_cashbank_balance_id bigint NOT NULL DEFAULT nextval('cb_trx_cashbank_balance_seq'::regclass),
  tenant_id bigint,
  ou_id bigint,
  doc_type_id bigint,
  payment_id bigint,
  payment_doc_no character varying(100),
  payment_doc_date character varying(8),
  payment_remark character varying(1024),
  partner_id bigint,
  partner_bank_id bigint,
  curr_code character varying(5),
  amount numeric,
  due_date character varying(8),
  flg_payment character varying(1),
  ref_doc_type_id bigint,
  ref_id bigint,
  version bigint NOT NULL,
  create_datetime character varying(14),
  create_user_id bigint,
  update_datetime character varying(14),
  update_user_id bigint,
  CONSTRAINT cb_trx_cashbank_balance_pkey PRIMARY KEY (trx_cashbank_balance_id)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE cb_trx_cashbank_balance
  OWNER TO sts;

-- Index: idx_cb_trx_cashbank_balance_01

-- DROP INDEX idx_cb_trx_cashbank_balance_01;

CREATE UNIQUE INDEX idx_cb_trx_cashbank_balance_01
  ON cb_trx_cashbank_balance
  USING btree
  (tenant_id, ou_id, partner_id, doc_type_id, payment_id, payment_doc_no COLLATE pg_catalog."default", "substring"(payment_doc_date::text, 1, 6) COLLATE pg_catalog."default");