| id |
integer |
Yes |
Yes |
nextval('equipment_history_id_seq'::regclass) |
|
| invoice_no |
character varying(10) |
No |
No |
|
Sales history invoice number |
| cust_no |
character varying(20) |
No |
No |
|
Customer code |
| equipment_no |
character varying(10) |
No |
No |
|
Equipment number. Links to Equipment.equipment_no |
| previous_odometer |
integer |
No |
No |
|
Previous reading |
| odometer |
integer |
No |
No |
|
Current reading |
| order_no |
character varying(10) |
No |
No |
|
Sales order number |
| cust_po_no |
character varying(20) |
No |
No |
|
Customer PO number |
| invoice_date |
date |
No |
No |
|
Date invoiced |
| total_net |
numeric(15,2) |
No |
No |
|
Invoice sub total |
| total_current_cost |
numeric(15,2) |
No |
No |
|
Total current cost |
| total_average_cost |
numeric(15,2) |
No |
No |
|
Total average cost |
| followup_date |
date |
No |
No |
|
Date to follow-up |
| reference_no |
character varying(20) |
No |
No |
|
Reference number |
| _dbversion |
integer |
No |
No |
|
|
| _modified |
timestamp without time zone |
No |
No |
|
|
| _modified_by |
character varying(3) |
No |
No |
|
|
| _created |
timestamp without time zone |
No |
No |
|
|
| _created_by |
character varying(3) |
No |
No |
|
|