ADMIN MAINTENANCE

Income Type Maintenance

Execute the following scripts to add income type maintenance.

Where OBDXBU2 is the entity id for which the Third party host is configured.

 

Insert into DIGX_OR_FIN_INC_TYPE (CODE, DESCRIPTION, ORDINAL, DETERMINANT_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_STATUS, OBJECT_VERSION_NUMBER) values ('B', 'Business', 30, 'OBDXBU2', 'superadmin', sysdate, 'superadmin', sysdate, null, 1);

 

Insert into DIGX_OR_FIN_INC_TYPE (CODE, DESCRIPTION, ORDINAL, DETERMINANT_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_STATUS, OBJECT_VERSION_NUMBER) values

('S', 'Salary', 10, ''OBDXBU2', 'superadmin', sysdate, 'superadmin', sysdate, null, 1);

 

Insert into DIGX_OR_FIN_INC_TYPE (CODE, DESCRIPTION, ORDINAL, DETERMINANT_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_STATUS, OBJECT_VERSION_NUMBER) values

('R', 'Rent', 20, ''OBDXBU2', 'superadmin', sysdate, 'superadmin', sysdate, null, 1);

 

Insert into DIGX_OR_FIN_INC_TYPE (CODE, DESCRIPTION, ORDINAL, DETERMINANT_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_STATUS, OBJECT_VERSION_NUMBER) values

('O', 'Others', 40, ''OBDXBU2', 'superadmin', sysdate , 'superadmin', sysdate, null, 1);

Liability Type maintenance

Execute the following scripts to add liability type maintenance.

Where 'OBDXBU2' is the entity id for which the Third party host is configured.

Insert into DIGX_OR_FIN_LIAB_TYPE (CODE, DESCRIPTION, ORDINAL, DETERMINANT_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_STATUS, OBJECT_VERSION_NUMBER) values ('E', 'Lease', 10, 'OBDXBU2', 'superadmin', sysdate, 'superadmin', sysdate, null,

 

Insert into DIGX_OR_FIN_LIAB_TYPE (CODE, DESCRIPTION, ORDINAL, DETERMINANT_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_STATUS, OBJECT_VERSION_NUMBER) values ('R', 'Rent', 20, 'OBDXBU2', 'superadmin', sysdate, 'superadmin', sysdate, null,

 

Insert into DIGX_OR_FIN_LIAB_TYPE (CODE, DESCRIPTION, ORDINAL, DETERMINANT_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_STATUS, OBJECT_VERSION_NUMBER) values ('L', 'Loan', 30, 'OBDXBU2', 'superadmin', sysdate, 'superadmin', sysdate, null,

 

Insert into DIGX_OR_FIN_LIAB_TYPE (CODE, DESCRIPTION, ORDINAL, DETERMINANT_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_STATUS, OBJECT_VERSION_NUMBER) values ('O', 'Others', 40, 'OBDXBU2', 'superadmin', sysdate, 'superadmin', sysdate, null, 1);

Accommodation Type maintenance

Execute the following scripts to add accommodation type maintenance.

Where OBDXBU2 is the entity id for which the Third party host is configured.

 

Insert into DIGX_OR_ACC_TYPE (CODE, DESCRIPTION, ORDINAL, DETERMINANT_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_STATUS, OBJECT_VERSION_NUMBER) values ('O', 'Other', 30, 'OBDXBU2', 'superadmin', sysdate, 'superadmin', sysdate, null,

Insert into DIGX_OR_ACC_TYPE (CODE, DESCRIPTION, ORDINAL, DETERMINANT_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_STATUS, OBJECT_VERSION_NUMBER) values ('S', 'Self Owned', 20, 'OBDXBU2', 'superadmin', sysdate, 'superadmin', sysdate, null,

 

Insert into DIGX_OR_ACC_TYPE (CODE, DESCRIPTION, ORDINAL, DETERMINANT_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_STATUS, OBJECT_VERSION_NUMBER) values ('C', 'Company Provided', 10, 'OBDXBU2', 'superadmin', sysdate, 'superadmin', sysdate, null, 1);

Asset Type Maintenance

Execute the following scripts to add accommodation type maintenance.

Where OBDXBU2 is the entity id for which the Third party host is configured.

 

Insert into DIGX_OR_FIN_ASSET_TYPE (CODE, DESCRIPTION, ORDINAL, DETERMINANT_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_STATUS, OBJECT_VERSION_NUMBER) values ('L','Land','10','OBDXBU2','superadmin',sysdate,'superadmin',sysdate,null,1);

 

Insert into DIGX_OR_FIN_ASSET_TYPE (CODE, DESCRIPTION, ORDINAL, DETERMINANT_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_STATUS, OBJECT_VERSION_NUMBER) values ('P','Property','20','OBDXBU2','superadmin',sysdate,'superadmin',sysdate,null,1);

Back