| id |
integer |
Yes |
Yes |
nextval('phase_history_id_seq'::regclass) |
Unique identifier |
| phase_type |
character varying(4) |
No |
No |
|
Order type that Phase records are linked to; BORD = Production Order BHIS = Production History PORD = Purchase Order PHIS = Purchase History SORD = Sales Order SHIS = Sales History |
| order_no |
character varying(10) |
No |
No |
|
Sales, Purchase or Production order number that this record is linked to |
| phase_id |
character varying(20) |
No |
No |
|
User set Phase code - links to phases.phase_id |
| phase_desc |
character varying(100) |
No |
No |
|
Phase description |
| operator |
character varying(3) |
No |
No |
|
Initials of the person that moved it to this Phase |
| carrier |
character varying(20) |
No |
No |
''::character varying |
User set Carrier name if shipping involved in this Phase change |
| ref_no |
character varying(50) |
No |
No |
''::character varying |
User set Reference number for this Phase change |
| notes |
text |
No |
No |
''::text |
User entered Notes for this Phase change |
| _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 |
| started |
timestamp without time zone |
No |
No |
|
Date/Time that the Order entered this Phase |
| ended |
timestamp without time zone |
No |
No |
|
Date/Time that the Order left this Phase. |