Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Pencatatan Journal dari Transaksi Module2 yang lain
- CREATE SEQUENCE gl_journal_trx_seq
- INCREMENT 1
- MINVALUE 1
- MAXVALUE 9223372036854775807
- START 10
- CACHE 1;
- /*
- * journal type : lihat di data combo JOURNALTYPE
- * journal type : dibuat berdasarkan jenis doc_type_id ( dari table m_document_jurnal ) contoh : STOCK.PURCH, AP.CLAIM, dll
- * doc_type_id : transaksi ERP yang akan dijurnal
- * doc_id : receive goods id, purch invoice id, pos id, dll
- * untuk pos_id nilai bisa -99, maka doc_no diperlukan supaya data tidak duplikat
- * status_doc :
- * 1. DRAFT : saat submit dan saat input jv manual
- * 2. RELEASE : sudah dilakukan perhitungan rate
- * 3. FINAL : sudah dilakukan posting ( proses bulanan G/L )
- *
- * flg_fix : Y artinya jurnal tersbut tidak akan dihapus
- *
- */
- CREATE TABLE gl_journal_trx
- (
- journal_trx_id bigint NOT NULL DEFAULT nextval('gl_journal_trx_seq'),
- tenant_id bigint,
- journal_type character varying(20),
- doc_type_id bigint,
- doc_id bigint,
- doc_no character varying(30),
- doc_date character varying(8),
- ou_id bigint,
- sub_ou_id bigint,
- partner_id bigint,
- cashbank_id bigint,
- warehouse_id bigint,
- ext_doc_no character varying(30),
- ext_doc_date character varying(8),
- ref_doc_type_id bigint,
- ref_id bigint,
- ref_doc_no character varying(30),
- ref_doc_date character varying(8),
- due_date character varying(8),
- curr_code character varying(5),
- remark character varying(1024),
- status_doc character varying(1),
- workflow_status character varying(50),
- flg_fix character varying(1) DEFAULT 'Y',
- "version" bigint NOT NULL,
- create_datetime character varying(14),
- create_user_id bigint,
- update_datetime character varying(14),
- update_user_id bigint,
- CONSTRAINT gl_journal_trx_pkey PRIMARY KEY (journal_trx_id)
- )
- WITH (
- OIDS=FALSE
- );
- CREATE UNIQUE INDEX idx_gl_journal_trx_01
- ON gl_journal_trx
- USING btree
- (tenant_id, journal_type, doc_type_id, doc_id, doc_no, ou_id, sub_ou_id);
- CREATE INDEX idx_gl_journal_trx_02
- ON gl_journal_trx
- USING btree
- (tenant_id, doc_type_id, doc_no, doc_date, ou_id);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement