If we do not have data to insert in some of the tables, should we leave the fields empty or enter ' 0 ' ?
It depends on what has been entered in the programme. If there's a record in the programme with ' 0 ', then you will have to enter it in the Accounts with ' 0 ' too because some of the validation rules check the values are greater or equal to those records.