CREATE TABLE "ZEAL_ERP"."GL_ALT_TYPE_MATRIX_MAP_T" 
   (	"ORG_ID" NUMBER, 
	"ALTERATION_TYPE" VARCHAR2(20 BYTE), 
	"MATRIX_ID" VARCHAR2(50 BYTE), 
	"ACTIVE" VARCHAR2(1 BYTE), 
	"CREATED_BY" VARCHAR2(50 BYTE), 
	"CREATION_DATE" DATE, 
	"LAST_UPDATED_BY" VARCHAR2(50 BYTE), 
	"LAST_UPDATE_DATE" DATE, 
	"EXECUTION_ORDER" NUMBER, 
	"TAKAFUL_TYPE" VARCHAR2(20 BYTE), 
	 CONSTRAINT "PK_ALTERATION_TYPE" PRIMARY KEY ("ORG_ID", "ALTERATION_TYPE", "MATRIX_ID")
   ) ;
   
   create table GL_ACCOUNT_MATRIX_SL_VALUES_T
(
	ORG_ID number,
	MATRIX_DETAIL_ID number,
	MATRIX_ID character (50 BYTE),
	VARIABLE_NAME VARCHAR2(50 BYTE),
	REF_KEY varchar2(200),
	SL_TYPE varchar2(50),
	SL_CODE varchar2(50),
	VARIABLE_VALUE varchar2(200),
	CREATED_BY VARCHAR2(50 BYTE), 
	CREATION_DATE date, 
	LAST_UPDATED_BY VARCHAR2(50 BYTE), 
	LAST_UPDATE_DATE date,	
	constraint pk_GL_ACCOUNT_MATRIX_SL_VAL_T primary key (ORG_ID,MATRIX_ID,MATRIX_DETAIL_ID,VARIABLE_NAME,REF_KEY,SL_TYPE,SL_CODE)
);