Un-normalised
form (User view).
Kauri Furniture Company
21 Cameron Road, Tauranga |
Invoice
No: 122433
Date: 12 February 1999 |
| Customer No: |
333333 |
| Customer Name: |
Ches Long |
| Address: |
245 Queen Street
Onehunga
AUCKLAND |
|
| Product Code |
Description |
Quantity |
Price |
Amount |
| 13425 |
Bedside Cabinet |
4 |
150.00 |
600.00 |
| 10266 |
Coffee Table |
3 |
60.00 |
180.00 |
| 54000 |
Kauri Chest |
1 |
200.00 |
200.00 |
| |
|
|
|
|
|
Listed Data: (with initial
type & notes)
| Data item |
Type |
Notes |
| InvId |
Number |
Automatic |
| InvDate |
Date |
Automatic |
| CustId |
Number(6 ) |
not null |
| CustLName |
Text (30) |
Last Name |
| CustFName |
Text (30) |
FirstName |
| CustAdd1 |
Text (30) |
not null |
| CustAdd2 |
Text (30) |
|
| CustAdd3 |
Text (30) |
Uppercase |
| ProdCode1 |
Number (5) |
not null |
| Dsn1 |
Text (20) |
Description |
| Qty1 |
Number (3) |
> 0 |
| Price1 |
Number (7,2) |
|
| Amt1 |
Number (8,2) |
Amount |
| ProdCode2 |
Number (5) |
not null |
| Dsn2 |
Text (20) |
Description |
| Qty2 |
Number (3) |
> 0 |
| Price2 |
Number (7,2) |
|
| Amt2 |
Number (8,2) |
Amount |
| ProdCode3 |
Number (5) |
not null |
| Dsn3 |
Text (20) |
Description |
| Qty3 |
Number (3) |
> 0 |
| Price3 |
Number (7,2) |
|
| Amt3 |
Number (8,2) |
Amount |
| ProdCode4 |
Number (5) |
not null |
| Dsn4 |
Text (20) |
Description |
| Qty4 |
Number (3) |
> 0 |
| Price4 |
Number (7,2) |
|
| Amt4 |
Number (8,2) |
Amount |
| Freight |
Number (6,2) |
|
| Insur |
Number (6,2) |
Insurance |
| GST |
Number (6,2) |
|
| TotalDue |
Number (9,2) |
|
|
