[
Lists Home |
Date Index |
Thread Index
]
On Mon, 4 Apr 2005 12:46 am, Ronald Bourret wrote:
> Can you query the XML documents?
From an accounting perspective you can, as the important fields from within
the document are broken out to the sql database to enable such queries. ie:
aged debtor analysis : select name, a_c, a_30, a_60, a_90 from trader
where trading_relationship = "Customer"
list of invoices : select document_type,document_reference,
document_date,document_amount from
trader_documents where document_type =
"Invoice"
etc... etc....
It makes it very simple to do the normal sort of accounting queries.
Also makes it possible to use traditional rdms report writers to build
reports.
> If not -- for example, if they're
> stored as BLOBs -- it seems this would make sense only if the only thing
> you wanted to do with your accounting data is to ship it somewhere else.
A copy of the entire document is stored in a text-memo field.
It is designed so that the xml document can be shipped off as created
to the Customer (xml Invoices) or Supplier (xml Purchase Orders).
> Doesn't strike me as very likely...
Sending xml purchase orders and invoices is becoming much more
common.... it certainly does happen in the real world in increasing
amounts...
Best Regards
David
--
Computergrid : The ones with the most connections win.
|
