Document ID Question

[unknown-user]

If I wrote a third party component, say in .NET to associate the faxed document with an invoice in my invoice system, what database value would I use for a DocumentID? What table would I access?

If all new faxes came in with a custom index value = NEW and I matched the barcode value with a value in the invoice system (invoice key value) for all documents with a value of NEW what value would be the document's primary key value/DocumentID?

What value uniquely identifies a document?

I hope I made sense.

[unknown-user]

Not much help around here. I guess we will be going to P8. Oh Well.
I tried evaluating Open Source but the support is not there.

[mrogers]

If you are using the public forums you need to be a little more patient.    There's an element of luck whether someone will read your post and respond to it.

If you want faster support then one option is to pay for an Enterpise subscription.   Then you can have 24X7 support with a guaranteed response time.

To answer your question.   You don't access the database tables directly and should not take that approach.   Alfresco is a "black box" and you shouldn't get involved in the internals.

There's lots of options.

Each node has a unique id that can serve as a key.    You can also store "properties" for each node so you could generate your own key to link your systems.   You would probably want to store properties such as the invoice number and you could then search via invoice number.

You can retireve content either through the nodeid or searching for properties. 

You could also model some sort of parent/child relationship with the faxes being children of an invoice document.