| id |
integer |
Yes |
Yes |
nextval('jobs_id_seq'::regclass) |
Unique identifier |
| job_no |
character varying(10) |
No |
No |
|
Job number as set by user |
| account |
character varying(10) |
No |
No |
|
Job account as set by user - blank for Job header record |
| name |
character varying(60) |
No |
No |
|
Job account name or description |
| start_date |
date |
No |
No |
|
Start date as set by user |
| end_date |
date |
No |
No |
|
End date as set by user |
| trans_flag |
boolean |
No |
No |
|
|
| memo |
character varying(60) |
No |
No |
|
Reference as set by user |
| status |
character varying(1) |
No |
No |
|
Job status; A = Active C = Completed H = Hold |
| ranking |
numeric(5) |
No |
No |
|
Rank as set by user |
| contract_no |
character varying(10) |
No |
No |
|
Contract number |
| contract_date |
date |
No |
No |
|
Contract date |
| estimator |
character varying(60) |
No |
No |
|
Job estimator |
| estimated_income |
numeric(15,2) |
No |
No |
|
Estimated Income or Revenue |
| actual_income |
numeric(15,2) |
No |
No |
|
Actual Income or Revenue |
| estimated_expense |
numeric(15,2) |
No |
No |
|
Estimated Expenses |
| actual_expense |
numeric(15,2) |
No |
No |
|
Actual Expenses |
| actual_hours |
numeric(9,2) |
No |
No |
|
Actual hours |
| estimated_hours |
numeric(9,2) |
No |
No |
|
Estimated hours |
| last_refno |
character varying(10) |
No |
No |
|
Last billing number |
| _dbversion |
integer |
No |
No |
|
Program version 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 |
| _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 |
| udf_data |
hstore |
No |
No |
''::hstore |
User defined data for this record |