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 |