| 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 production_order.id |
| udf_data |
hstore |
No |
No |
''::hstore |
hstore field containing user defined data |