Table Data dictionary report - production_orders

Generated: 2018-10-18 7:31:43 AM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict_donotremove
Schema: public
Notes:

Table for Production Orders not yet fully built

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('production_orders_id_seq'::regclass) Unique identifier
order_no character varying(10) No No Production Order number
whse character varying(6) No No Warehouse of the manufactured item to be built - links to inventory.whse
part_no character varying(34) No No Part number of the manufactured item to be built - links to inventory.part_no
description character varying(80) No No Description of the manufactured item to be built, can be user edited
status character varying(1) No No Status of the Production Order; A = Pending I = In Progress U = Open
lead numeric(5) No No Lead time to build item as set by user
order_date date No No Production Order date
required_date date No No Required date on the Production Order
required_qty numeric(13,5) No No Quantity required of the manufactured item
backorder_qty numeric(13,5) No No Quantity still left to build on this Production Order
parts_cost numeric(17,3) No No Total unit cost of components on this Production Order
cust_no character varying(20) No No Customer that was assigned to this Production Order - links to customer.cust_no
category character varying(6) No No Category assigned to this build - links to bom_categories.category
priority smallint No No Priority that the Production Order was as set by user; 0 - Highest 1 - High 2 - Normal 3 - Low 4 - Lowest
expected_yield_pct numeric(5,2) No No Expected yield percentage
actual_yield_qty numeric(13,5) No No Actual yield quantity
assemble_qty numeric(17,5) No No Quantity to assemble using expected yield
assembled_qty numeric(17,5) No No Quantity already built
sales_order_no character varying(10) No No Sales Order number that this Production Order is for - links to sales_orders.order_no
cust_po_no character varying(20) No No Customer Purchase Order number
phase_date date No No The Phase Date on the Production Order
guid character varying(32) No No Uniique identifier for linking to other tables; sales_order_items.guid inventory_serial_transactions.link_guid inventory_receipts.link_guid
reference character varying(30) No No User added reference number
revision character varying(8) No No The revision of the Production Template when the Production Order was created or updated
phase_id character varying(20) No No Phase ID on the Production Order
user_type character varying(40) No No Not used
req_no character varying(10) No No Requisition number that created this Production Order - links to inventory_requisitions.requisition_no
employee character varying(6) No No Employee number added by user - links to employees.employee_no
template_no character varying(10) No No Production Template that was used to create this Production Order
template_guid character varying(32) No No The Template GUID linked to this Production Order - links to production_templates.guid
user_flag boolean No No User edited flag; FALSE = No, record still same as populated from template TRUE = User modified this record since it was created from the template
committed_qty numeric(21,5) No No The Inventory committed quantity by this Production Order - effects inventory.purchase_qty
_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
instructions text No No Manufacturing instructions for the Production Order
mfg_notes text No No Manufacturing notes for the Production Order
udf_data hstore No No ''::hstore User defined data for this record

Constraints

Name Type Definition Comment
bve_bombuild_pkey Primary key (id)

Report generated by pgAdmin3 LTS by BigSQL