| id |
integer |
Yes |
Yes |
nextval('timecard_entries_id_seq'::regclass) |
Unique identifier |
| timecard_id |
integer |
No |
No |
|
Link to timecards.id |
| sequence |
smallint |
No |
No |
|
Sequential number for timecard line |
| code |
character varying(1) |
No |
No |
|
Pay code on this time card record; $ = Salary A = Advance C = Commission R = Regular Pay O = Overtime P = Premium S = Sick X = Other V = Vacation |
| hours |
numeric(5,2) |
No |
No |
|
Number of hours on this record |
| rate |
numeric(9,2) |
No |
No |
|
Pay rate on this record |
| amount |
numeric(15,2) |
No |
No |
|
Pay amount on this record |
| account |
character varying(24) |
No |
No |
|
General Ledger Account for this record |
| _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 |
| job_no |
character varying(10) |
No |
No |
|
Job cost number - links to jobs.job_no |
| job_acct_no |
character varying(10) |
No |
No |
|
Job cost account number - links to jobs.account |
| comment |
text |
No |
No |
|
Comment text |
| udf_data |
hstore |
No |
No |
''::hstore |
User defined data for this record |