struktur table

CREATE TABLE stock_opname_planning_adjustment
(
  stock_opname_planning_adjustment_id bigint NOT NULL DEFAULT nextval('stock_opname_planning_adjustment_seq'::regclass),
  stock_opname_period_id bigint,
  product_code character varying(100),
  whs_location_code character varying(100),
  qty_adj_system bigint,
  create_datetime character varying(14),
  create_user_id bigint,
  update_datetime character varying(14),
  update_user_id bigint,
  version bigint NOT NULL,
  qty_adj_final bigint,
  flg_adjustment character varying(1) DEFAULT 'N'::character varying,
  remark text,
  qty_system_snapshot bigint DEFAULT 0,
  qty_fisik bigint DEFAULT 0,
  qty_reject_snapshot bigint DEFAULT 0,
  qty_reject_fisik bigint DEFAULT 0,
  qty_adj_reject_system bigint DEFAULT 0,
  qty_adj_reject_final bigint DEFAULT 0,
  CONSTRAINT stock_opname_planning_adjustment_pkey PRIMARY KEY (stock_opname_planning_adjustment_id)
)



CREATE TABLE stock_opname_planning_adjustment_detail
(
  stock_opname_planing_adjustment_detail_id bigint NOT NULL DEFAULT nextval('stock_opname_planing_adjustment_detail_seq'::regclass),
  stock_opname_planing_adjustment_id bigint,
  stock_opname_period_id bigint,
  product_code character varying(100),
  whs_location_code character varying(100),
  qty_adj_system bigint,
  qty_adj_final bigint,
  flg_adjustment character varying(1),
  remark text,
  warehouse_code character varying(100),
  flg_system character varying(1),
  qty_system_snapshot bigint,
  create_datetime character varying(14),
  create_user_id bigint,
  update_datetime character varying(14),
  update_user_id bigint,
  version bigint NOT NULL,
  product_status character varying(100) DEFAULT 'GOOD'::character varying,
  CONSTRAINT stock_opname_planing_adjustment_detail_pkey PRIMARY KEY (stock_opname_planing_adjustment_detail_id)
)