Finding Inventory type, inventory Source - project or free inventory.

​@ranjithduraisamy72  Here are the main tables you should consider:

 1. INTran – Inventory Transactions

This table stores inventory movement details and includes sourcing information.

Relevant fields:

• ProjectID: If set (not PMProjectAttribute.NonProject()), the inventory is project-related.

• TaskID: Related project task.

• SiteID: Warehouse/site (used in both project and non-project inventory).

• OrigModule: Helps determine source module (e.g., SO, PO, PM).

 2. INItemSite – Item per Warehouse

Shows if the item is available at a specific site/warehouse.

Relevant for: Determining free stock availability across sites.

 3. PMInventoryAllocAccum / PMCostBudget / PMTran

Used to track project-specific inventory and usage.

Relevant if: Inventory is reserved/consumed for a project.
Look for:

• InventoryID, ProjectID, TaskID

 4. INSiteStatus – Quantity per Site

Shows quantities of each item at each warehouse.

Use this to: Identify how much "free" stock is available.

For Type

You can use logic like:

SELECT 
    InventoryID, 
    ProjectID, 
    CASE 
        WHEN ProjectID IS NULL OR ProjectID = 0 THEN 'Free Stock'
        ELSE 'Project-Related'
    END AS StockType
FROM INTran

I hope it helps.