D&C GLug - Home Page

[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]

Re: [LUG] Expenses records

 

On Sat, Oct 07, 2006 at 08:28:50AM +0100, Neil Williams wrote:
> Addresses have vcard, ToDo lists have vTodo, Appointments have  
> vCalendar (amongst others).
> 
> What could be conceived as a "standard format for expenses"?
> 
Anything to get away from QIF

> Basically, needs to include:
> 1. Amount (a simple number, independent of currency)
> 2. Currency (standardised ID that references a fixed table of symbols,  
> fractions, mnemonics, formatting and currency code suitable for  
> retrieval of currency conversion rates).

You need two sorts of variants:
-   Currency which is the ISO currency derivation
-   What the display is (eg is it xx,xxx,xxx.xx or is it xx.xxx.xxx,xx.
    Similarly what the date fields are YYMMDD or MMDDYY etc etc) Unless
    this information is obtained from elsewhere

> 3. Date (timestamp)
> 4. form of payment (visa, prepaid, cash, etc.)

Presumably this would depend on the format. Would this not be a string?

> 5. Vendor (string)
> 6. City/Location (string)
> 7. Note (long string)
> 8. Mileage unit (because lots of expenses are actually mileage claims)
> 9. Category ("Business", "Personal", "Family" etc.)
> 
> 

--
Henry
Sun Oct  8 13:56:00 BST 2006

Attachment: signature.asc
Description: Digital signature

-- 
The Mailing List for the Devon & Cornwall LUG
http://mailman.dclug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/linux_adm/list-faq.html