| id |
integer |
Yes |
Yes |
nextval('sales_order_equipment_id_seq'::regclass) |
Unique identifier |
| order_no |
character varying(10) |
No |
No |
|
Sales order number for this record - links to sales_orders.order_no |
| equipment_no |
character varying(10) |
No |
No |
|
Equipment number - links to equipment.equipment_no |
| unit_no |
character varying(80) |
No |
No |
|
Unit number from equipment.unit_no |
| odometer |
integer |
No |
No |
|
Current reading |
| estimate |
numeric(15,2) |
No |
No |
|
Repair estimate |
| order_type |
character varying(1) |
No |
No |
'R'::character varying |
Not used |
| 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 |