Free trade qualification method and system

A non-transitory computer readable medium or media having computer-executable instructions stored thereon for operating a computer system a perform a method to determine trade qualification of an item, the item containing a plurality of subassemblies, each subassembly potentially containing a plurality of subassemblies or being a base entry, the method comprising:

• maintaining a database of item records, with one record for each subassembly, each item record containing fields for information about the subassembly, including information relating to trade qualification;
• maintaining a database or relationship records, with each relationship record indicating a parent-child relationship between subassemblies;
• determining an item to be trade qualified;
• for the determined item, selecting each subassembly which is present in the item utilizing the relationship records;
• traversing the selected subassemblies and determining trade qualification information for each subassembly based on the subassembly's constituent subassemblies using the item records;
• storing the determined trade qualification information for each subassembly as the determination is completed;
• determining the trade qualification information for the item based on its direct constituent subassemblies;
• and
• storing the determined trade qualification information of the item;
• and
• producing and storing a certificate for an item based on the stored determined trade qualification information of the item, wherein the stored certificate is available for access to a user.

A computer system for determining trade qualification of an item, the item containing a plurality of subassemblies, each subassembly potentially containing a plurality of subassemblies or being a base entry, the computer system comprising:

• a database server maintaining a database of item records, with one record for each subassembly, each item record containing fields for information about the subassembly, including information relating to trade qualification and maintaining a database or relationship records, with each relationship record indicating a parent-child relationship between subassemblies;
• and
• an application server coupled to said database server for determining from a user an item to be trade qualified;
• for the determined item, selecting each subassembly which is present in the item utilizing the relationship records;
• traversing the selected subassemblies and determining trade qualification information for each subassembly based on the subassembly's constituent subassemblies using the item records;
• storing the determined trade qualification information for each subassembly as the determination is completed;
• determining the trade qualification information for the item based on its direct constituent subassemblies;
• and
• storing the determined trade qualification information of the item;
• and
• producing and storing a certificate for an item based on the stored determined trade qualification information of the item, wherein the stored certificate is available for access to a user.