id |
integer |
Yes |
Yes |
nextval('equipment_history_id_seq'::regclass) |
Unique identifier |
invoice_no |
character varying(10) |
No |
No |
|
Invoice number for this record - links to sales_history.invoice_no |
cust_no |
character varying(20) |
No |
No |
|
Customer number - links to customers.cust_no |
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 Purchase Order number |
invoice_date |
date |
No |
No |
|
Invoice date |
total_net |
numeric(15,2) |
No |
No |
|
Invoice subtotal |
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 |
|
Program version that last modified this record |
_modified |
timestamp without time zone |
No |
No |
|
UTC Date and time this record was last modified |
_modified_by |
character varying(3) |
No |
No |
|
User initials that last modified this record |
_created |
timestamp without time zone |
No |
No |
|
UTC Date and time record was created |
_created_by |
character varying(3) |
No |
No |
|
User initials that created this record |