| id |
integer |
Yes |
Yes |
nextval('phases_id_seq'::regclass) |
Unique identifier |
| phase_type |
character varying(4) |
No |
No |
''::character varying |
Phase type SORD = Sales order PORD = Purchae Order BORD = Production Order |
| phase_id |
character varying(20) |
No |
No |
''::character varying |
User set code for this Phase |
| phase_desc |
character varying(100) |
No |
No |
''::character varying |
User set Description of this Phase |
| report_tmpl |
character varying(20) |
No |
No |
''::character varying |
Crystal Reports template used when order enters this Phase |
| _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 |
| next_phases |
character varying(20)[] |
Yes |
No |
'{"","","","","","","","","",""}'::character varying[] |
The next Phase ID that the Order goes to when Next Phase is clicked |