Adding "Parent" Custom Properties to a BOM

Hi all,

I'm wondering if it's possible to add custom properties from an assembly file into a part/sub-assembly Bill of Materials row with indented numbering. I've created a sample below, where part number 1111 is the top level assembly.

The part numbers in our system are generated by Solidworks PDM. I am trying to export the Solidworks custom properties into a database and having the parent part number is needed to replicate the assembly structure in the database.

Is it possible to do this in Solidworks or PDM, or am I best to export the BOM and add in Excel (manually or with some Excel magic)?

Thanks!

SolidworksDrawings And Detailing