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);
Financial Parameters maintenance
Insert into DIGX_OR_FINANCIAL_PARAMETERS (CODE,DETERMINANT_VALUE,DESCRIPTION,FIN_PARAM_TYPE,ORDINAL,PRODUCT_SUB_CLASS) values ('RT','OBDX_BU','Rent','Expense',10,'PERSONAL_LOAN');
Insert into DIGX_OR_FINANCIAL_PARAMETERS (CODE,DETERMINANT_VALUE,DESCRIPTION,FIN_PARAM_TYPE,ORDINAL,PRODUCT_SUB_CLASS) values ('FD','OBDX_BU','Food','Expense',20,'PERSONAL_LOAN');
Insert into DIGX_OR_FINANCIAL_PARAMETERS (CODE,DETERMINANT_VALUE,DESCRIPTION,FIN_PARAM_TYPE,ORDINAL,PRODUCT_SUB_CLASS) values ('TR','OBDX_BU','Transport','Expense',40,'PERSONAL_LOAN');
Insert into DIGX_OR_FINANCIAL_PARAMETERS (CODE,DETERMINANT_VALUE,DESCRIPTION,FIN_PARAM_TYPE,ORDINAL,PRODUCT_SUB_CLASS) values ('HC','OBDX_BU','Healthcare','Expense',50,'PERSONAL_LOAN');
Insert into DIGX_OR_FINANCIAL_PARAMETERS (CODE,DETERMINANT_VALUE,DESCRIPTION,FIN_PARAM_TYPE,ORDINAL,PRODUCT_SUB_CLASS) values ('CH','OBDX_BU','Childcare','Expense',70,'PERSONAL_LOAN');
Insert into DIGX_OR_FINANCIAL_PARAMETERS (CODE,DETERMINANT_VALUE,DESCRIPTION,FIN_PARAM_TYPE,ORDINAL,PRODUCT_SUB_CLASS) values ('EDU','OBDX_BU','Education','Expense',80,'PERSONAL_LOAN');
Insert into DIGX_OR_FINANCIAL_PARAMETERS (CODE,DETERMINANT_VALUE,DESCRIPTION,FIN_PARAM_TYPE,ORDINAL,PRODUCT_SUB_CLASS) values ('OTH','OBDX_BU','Other','Expense',90,'PERSONAL_LOAN');
Insert into DIGX_OR_FINANCIAL_PARAMETERS (CODE,DETERMINANT_VALUE,DESCRIPTION,FIN_PARAM_TYPE,ORDINAL,PRODUCT_SUB_CLASS) values ('LN','OBDX_BU','Loan','Liability',10,'PERSONAL_LOAN');
Insert into DIGX_OR_FINANCIAL_PARAMETERS (CODE,DETERMINANT_VALUE,DESCRIPTION,FIN_PARAM_TYPE,ORDINAL,PRODUCT_SUB_CLASS) values ('LS','OBDX_BU','Lease','Liability',20,'PERSONAL_LOAN');
Insert into DIGX_OR_FINANCIAL_PARAMETERS (CODE,DETERMINANT_VALUE,DESCRIPTION,FIN_PARAM_TYPE,ORDINAL,PRODUCT_SUB_CLASS) values ('OTH','OBDX_BU','Other','Liability',40,'PERSONAL_LOAN');
Insert into DIGX_OR_FINANCIAL_PARAMETERS (CODE,DETERMINANT_VALUE,DESCRIPTION,FIN_PARAM_TYPE,ORDINAL,PRODUCT_SUB_CLASS) values ('EM','OBDX_BU','Salary','Income',10,'PERSONAL_LOAN');
Insert into DIGX_OR_FINANCIAL_PARAMETERS (CODE,DETERMINANT_VALUE,DESCRIPTION,FIN_PARAM_TYPE,ORDINAL,PRODUCT_SUB_CLASS) values ('RE','OBDX_BU','Rental Income','Income',20,'PERSONAL_LOAN');
Insert into DIGX_OR_FINANCIAL_PARAMETERS (CODE,DETERMINANT_VALUE,DESCRIPTION,FIN_PARAM_TYPE,ORDINAL,PRODUCT_SUB_CLASS) values ('EM','OBDX_BU','Salary','Income',10,'AUTOMOBILE');
Insert into DIGX_OR_FINANCIAL_PARAMETERS (CODE,DETERMINANT_VALUE,DESCRIPTION,FIN_PARAM_TYPE,ORDINAL,PRODUCT_SUB_CLASS) values ('RE','OBDX_BU','Rental Income','Income',20,'AUTOMOBILE');
Insert into DIGX_OR_FINANCIAL_PARAMETERS (CODE,DETERMINANT_VALUE,DESCRIPTION,FIN_PARAM_TYPE,ORDINAL,PRODUCT_SUB_CLASS) values ('RT','OBDX_BU','Rent','Expense',10,'AUTOMOBILE');
Insert into DIGX_OR_FINANCIAL_PARAMETERS (CODE,DETERMINANT_VALUE,DESCRIPTION,FIN_PARAM_TYPE,ORDINAL,PRODUCT_SUB_CLASS) values ('FD','OBDX_BU','Food','Expense',20,'AUTOMOBILE');
Insert into DIGX_OR_FINANCIAL_PARAMETERS (CODE,DETERMINANT_VALUE,DESCRIPTION,FIN_PARAM_TYPE,ORDINAL,PRODUCT_SUB_CLASS) values ('TR','OBDX_BU','Transport','Expense',40,'AUTOMOBILE');
Insert into DIGX_OR_FINANCIAL_PARAMETERS (CODE,DETERMINANT_VALUE,DESCRIPTION,FIN_PARAM_TYPE,ORDINAL,PRODUCT_SUB_CLASS) values ('HC','OBDX_BU','Healthcare','Expense',50,'AUTOMOBILE');
Insert into DIGX_OR_FINANCIAL_PARAMETERS (CODE,DETERMINANT_VALUE,DESCRIPTION,FIN_PARAM_TYPE,ORDINAL,PRODUCT_SUB_CLASS) values ('CH','OBDX_BU','Childcare','Expense',70,'AUTOMOBILE');
Insert into DIGX_OR_FINANCIAL_PARAMETERS (CODE,DETERMINANT_VALUE,DESCRIPTION,FIN_PARAM_TYPE,ORDINAL,PRODUCT_SUB_CLASS) values ('EDU','OBDX_BU','Education','Expense',80,'AUTOMOBILE');
Insert into DIGX_OR_FINANCIAL_PARAMETERS (CODE,DETERMINANT_VALUE,DESCRIPTION,FIN_PARAM_TYPE,ORDINAL,PRODUCT_SUB_CLASS) values ('OTH','OBDX_BU','Other','Expense',90,'AUTOMOBILE');
Insert into DIGX_OR_FINANCIAL_PARAMETERS (CODE,DETERMINANT_VALUE,DESCRIPTION,FIN_PARAM_TYPE,ORDINAL,PRODUCT_SUB_CLASS) values ('LN','OBDX_BU','Loan','Liability',10,'AUTOMOBILE');
Insert into DIGX_OR_FINANCIAL_PARAMETERS (CODE,DETERMINANT_VALUE,DESCRIPTION,FIN_PARAM_TYPE,ORDINAL,PRODUCT_SUB_CLASS) values ('LS','OBDX_BU','Lease','Liability',20,'AUTOMOBILE');
Insert into DIGX_OR_FINANCIAL_PARAMETERS (CODE,DETERMINANT_VALUE,DESCRIPTION,FIN_PARAM_TYPE,ORDINAL,PRODUCT_SUB_CLASS) values ('OTH','OBDX_BU','Other','Liability',40,'AUTOMOBILE');
Insert into DIGX_OR_FINANCIAL_PARAMETERS (CODE,DETERMINANT_VALUE,DESCRIPTION,FIN_PARAM_TYPE,ORDINAL,PRODUCT_SUB_CLASS) values ('L','OBDX_BU','Land','Assets',10,'PERSONAL_LOAN');
Insert into DIGX_OR_FINANCIAL_PARAMETERS (CODE,DETERMINANT_VALUE,DESCRIPTION,FIN_PARAM_TYPE,ORDINAL,PRODUCT_SUB_CLASS) values ('P','OBDX_BU','Property','Assets',20,'PERSONAL_LOAN');
Insert into DIGX_OR_FINANCIAL_PARAMETERS (CODE,DETERMINANT_VALUE,DESCRIPTION,FIN_PARAM_TYPE,ORDINAL,PRODUCT_SUB_CLASS) values ('L','OBDX_BU','Land','Assets',10,'AUTOMOBILE');
Insert into DIGX_OR_FINANCIAL_PARAMETERS (CODE,DETERMINANT_VALUE,DESCRIPTION,FIN_PARAM_TYPE,ORDINAL,PRODUCT_SUB_CLASS) values ('P','OBDX_BU','Property','Assets',20,'AUTOMOBILE');