id |
integer |
Yes |
Yes |
nextval('phase_history_id_seq'::regclass) |
|
phase_type |
character varying(4) |
No |
No |
|
Phase Type SORD - Sales Order SHIS = Sales History PORD = Purchase Order PHIS - Purchase History BORD - Production Order BHIS - Production History |
order_no |
character varying(10) |
No |
No |
|
Sales, Purchase or prodcution order number |
phase_id |
character varying(20) |
No |
No |
|
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 |
Carrier name if shipping involved. Added and edited manually |
ref_no |
character varying(50) |
No |
No |
''::character varying |
Reference number for this phase movement that is manually added/edited by user. |
notes |
text |
No |
No |
''::text |
Notes that are manually added/edited by user. |
_dbversion |
integer |
No |
No |
|
|
_created |
timestamp without time zone |
No |
No |
|
|
_created_by |
character varying(3) |
No |
No |
|
|
_modified |
timestamp without time zone |
No |
No |
|
|
_modified_by |
character varying(3) |
No |
No |
|
|
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. |