| id |
integer |
Yes |
Yes |
nextval('production_history_id_seq'::regclass) |
Unique identifier |
| order_no |
character varying(10) |
No |
No |
|
Production Order number |
| history_no |
character varying(10) |
No |
No |
|
Build number, note that each Production Order can be partially built more than once |
| build_date |
date |
No |
No |
|
Date item was built |
| whse |
character varying(6) |
No |
No |
|
Warehouse of the manufactured item that was built - links to inventory.whse |
| part_no |
character varying(34) |
No |
No |
|
Part number of the manufactured item that was built - links to inventory.part_no |
| description |
character varying(80) |
No |
No |
|
Description of item built, may be user edited |
| status |
character varying(1) |
No |
No |
|
Status of the Production Order at build time; A = Pending I = In Progress U = Open |
| lead |
numeric(5) |
No |
No |
|
Lead time of the item as set on the Production Order |
| 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 on the Production Order |
| 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 set to when it was built; 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 |
|
Not used |
| assembled_qty |
numeric(17,5) |
No |
No |
|
Quantity that were built |
| sales_order_no |
character varying(10) |
No |
No |
|
Sales Order number that this Production Order is for - links to sales_orders.order_no or sales_history.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 when built |
| 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 when built |
| 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 |
| 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 at build time |
| instructions |
text |
No |
No |
|
Instructions for the top assembly |
| mfg_notes |
text |
No |
No |
|
Manufacturing notes added by user |
| _dbversion |
integer |
No |
No |
|
Program version that last modified this record |
| _modified |
timestamp without time zone |
No |
No |
|
UTC Date and time record was created |
| _modified_by |
character varying(3) |
No |
No |
|
User initials that created this record |
| _created |
timestamp without time zone |
No |
No |
|
UTC Date and time this record was last modified |
| _created_by |
character varying(3) |
No |
No |
|
User initials that last modified this record |
| udf_data |
hstore |
No |
No |
''::hstore |
User defined data for this record |