ADMIN MAINTENANCE
Income Type maintenance
Execute the following scripts to add income type maintenance.
Where OBDX_BU
Business Unit is the entity id for which the FCUBS 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, 'OBDX_BU', '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, 'OBDX_BU', '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, 'OBDX_BU', ‘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, 'OBDX_BU', 'superadmin', sysdate , 'superadmin', sysdate, null, 1);
Liability Type maintenance
Execute the following scripts to add liability type maintenance.
Where OBDX_BU is the entity id for which the FCUBS 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, 'OBDX_BU', 'superadmin', sysdate, 'superadmin', sysdate, null, 1);
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, 'OBDX_BU', ‘superadmin’, sysdate, ‘superadmin’, sysdate, null, 1);
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, 'OBDX_BU', 'superadmin', sysdate, 'superadmin', sysdate, null, 1);
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, 'OBDX_BU', 'superadmin', sysdate, 'superadmin', sysdate, null, 1);
Accommodation Type maintenance
Execute the following scripts to add accommodation type maintenance.
Where OBDX_BU is the entity id for which the FCUBS 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, 'OBDX_BU', 'superadmin', sysdate, 'superadmin', sysdate, null, 1);
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, 'OBDX_BU', 'superadmin', sysdate, 'superadmin', sysdate, null, 1);
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, 'OBDX_BU', 'superadmin', sysdate, 'superadmin', sysdate, null, 1);