Java Reference
In-Depth Information
pointing to the Billing Rate Table holding information about payment terms, discounts,
and so forth.
Table 2-9: Invoice Table
id
invoice_number
date
start_date
end_date
billing_rate_id
description
1
2001
4/14/02
3/1/02
3/31/02
1021
Services,
March 2002
2
2002
4/14/02
3/1/02
3/31/02
1021
Services,
March 2002
Invoices are generated by creating a list of billable items which have not been
previously invoiced. Billable items which have not been previously invoiced are
identified using the links between the tables shown in
Figure 2-3
.
The relationships between the main tables used to create an invoice are shown in
Figure 2-4
. Notice the one to one relationship between the Billings and Client_Matter
tables mentioned earlier.
Figure 2-4:
These tables are used to create the invoice header.
By combining the data from all these tables, you can generate an invoice containing
all the information in
Listing 2 -1
. In addition to itemizing the individual fee and
expense items, the LEDES 2000 invoice format requires that fees be summarized by
timekeeper. This is done by using the foreign key tk_id in the Billable Items Table.
The final step is to create the invoice header using data from the Clients and Contacts
Tables. The procedure to create the invoice header is straightforward, and follows the
same basic steps as have been outlined in describing the detail sections of the
invoice.
