Data Structure advice

[John_Henry_Jose]

I am asked my Management to develop an Inventory Management which consists the following modules.

1. Master Inventory Items to be stored in different locations

2. Issuance - items are issued to Machinery, Client, Employees

3. Receipts - items are received back from Machinery, Client, Employees

Apart from this,

The Inventory items may be transferred to one storage location to another storage location

The Inventory items may be transferred to one country to another country with storage location

For all issuance / receipts / transfer - I need to the item condition also like good or damaged.

How the data structure supposed to be?

This is very challenging for me.

Please advice.

Thanks in advance.

@Aleksi @Steve @WillowMobileSys