Table Data dictionary report - production_history

Generated: 9/23/2016 2:57:15 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('production_history_id_seq'::regclass)
order_no character varying(10) No No Production order number
history_no character varying(10) No No Build number
build_date date No No Date built
whse character varying(6) No No Warehouse of item built
part_no character varying(34) No No Part number of item built
description character varying(80) No No Description of item built
status character varying(1) No No Status production order was in when it was built A = Pending I = In Progress U = Open
lead numeric(5) No No Lead time
order_date date No No Production order date
required_date date No No Required date
required_qty numeric(13,5) No No Quantity required
backorder_qty numeric(13,5) No No Quantity still to build at time of this build
parts_cost numeric(17,3) No No Total unit cost of components
cust_no character varying(20) No No Customer that was assigned to this build
category character varying(6) No No Category assigned to this build
priority smallint No No Priority the production order was in when it was built 0 - Highest 1 - High 2 - Normal 3 - Low 4 - Lowest
expected_yield_pct numeric(5,2) No No Expected yeild percentage
actual_yield_qty numeric(13,5) No No Actual yield quantity
assemble_qty numeric(17,5) No No
assembled_qty numeric(17,5) No No Quantity that were built
sales_order_no character varying(10) No No Sales order this production order is linked to
cust_po_no character varying(20) No No Customer PO number
phase_date date No No The phase date the order was in when built
guid character varying(32) No No GUID linking to sales order
reference character varying(30) No No User added reference
revision character varying(8) No No The revision the template was in when built
phase_id character varying(20) No No Phase ID the order was in when built
user_type character varying(40) No No
req_no character varying(10) No No Requisition number
employee character varying(6) No No Employee added by user
template_no character varying(10) No No Template this order came form
template_guid character varying(32) No No Template GUID
user_flag boolean No No
committed_qty numeric(21,5) No No
instructions text No No Instructions for top assembly
mfg_notes text No No Manufacturing notes added by user
_dbversion integer No No
_modified timestamp without time zone No No
_modified_by character varying(3) No No
_created timestamp without time zone No No
_created_by character varying(3) No No
udf_data hstore No No ''::hstore hstore field containing user defined fields data

Constraints

Name Type Definition Comment
production_history_pkey Primary key (id)

Report generated by pgAdmin III