| Name | Data type | Not Null? | Primary key? | Default | Comment |
|---|---|---|---|---|---|
| id | integer | Yes | Yes | nextval('gl_segments_id_seq'::regclass) | |
| segment_no | character varying(1) | No | No | The segment number. 1 - 4 | |
| code | character varying(24) | No | No | GL code for the segment | |
| description | character varying(60) | No | No | GL description | |
| _created_by | character varying(3) | No | No | ||
| _modified_by | character varying(3) | No | No | ||
| _dbversion | integer | No | No | ||
| _created | timestamp without time zone | No | No | ||
| _modified | timestamp without time zone | No | No |
| Name | Type | Definition | Comment |
|---|---|---|---|
| gl_segments_pkey | Primary key | (id) |