Table Data dictionary report - phase_history

Generated: 9/23/2016 2:56:37 PM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict
Schema: public

Columns

Name Data type Not Null? Primary key? Default Comment
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.

Constraints

Name Type Definition Comment
bve_phase_dtl_pkey Primary key (id)

Report generated by pgAdmin III