Table Data dictionary report - production_order_items

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


Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('production_order_items_id_seq'::regclass)
sequence smallint No No Sequence number starting from 0 for each production order
parent smallint No No Used to show which sequence number toggled sub assemblies belong to.
whse character varying(6) No No Warehouse of the component
part_no character varying(34) No No Part number of the component
description character varying(80) No No Description of the component
unit_qty numeric(15,5) No No Quantity of the component
yield_qty numeric(21,5) No No
scrap_qty numeric(21,5) No No Scrap for the component
extended_qty numeric(21,5) No No Extended quantity of the component
committed_qty numeric(21,5) No No Committed quantity of the component
consumed_qty numeric(21,5) No No Consumed quantity of the component
unit_cost numeric(15,5) No No Unit cost of the component
user_cost_flag boolean No No User edited cost TRUE = Yes FALSE = No
uom_usage character varying(10) No No Quantity of the unit of measure used.
uom_usage_factor numeric(13,5) No No Unit of measure conversion factor
direct_factor boolean No No Using direct factor TRUE= Yes FALSE = No
lead_time numeric(5) No No Lead time of the component
date date No No Date line committed
category character varying(6) No No Category of the component
expected_yield_pct numeric(5,2) No No
expected_scrap_pct numeric(5,2) No No Expected scrap percentage of the component
guid character varying(32) No No GUID to link to purchase or production order
phase_id character varying(20) No No
req_no character varying(10) No No Requisition number
vend_no character varying(20) No No Vendor the item will be ordered from if requisitioned
employee character varying(6) No No Employee added to the line
template_no character varying(10) No No Template for this line
template_guid character varying(32) No No GUID linking to template
user_flag boolean No No
revision character varying(8) No No
_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
instructions text No No Line instructions
order_id integer Yes No Links to ID from
udf_data hstore No No ''::hstore hstore field containing user defined data


Name Type Definition Comment
bve_bombuild_dtl_pkey Primary key (id)
production_order_items_order_id_fkey Foreign key (order_id) REFERENCES production_orders (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE CASCADE

Report generated by pgAdmin III