id |
integer |
Yes |
Yes |
nextval('gl_segments_id_seq'::regclass) |
Unique indentifier |
segment_no |
character varying(1) |
No |
No |
|
The segment number. 1 - 4 |
code |
character varying(24) |
No |
No |
|
General Ledger code for the segment |
description |
character varying(60) |
No |
No |
|
Segment description |
_created_by |
character varying(3) |
No |
No |
|
User initials that created this record |
_modified_by |
character varying(3) |
No |
No |
|
User initials that modified this record |
_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 |
_modified |
timestamp without time zone |
No |
No |
|
UTC Date and time record was last modified |