| id |
integer |
Yes |
Yes |
nextval('production_template_items_id_seq'::regclass) |
|
| template_id |
integer |
Yes |
No |
|
Links to production_templates.id |
| child_template_id |
integer |
No |
No |
|
Links to template_id for sub assemblies |
| sequence |
smallint |
No |
No |
|
Sequence number starting from 0 |
| whse |
character varying(6) |
No |
No |
|
Warehouse of item |
| part_no |
character varying(34) |
No |
No |
|
Part number of item |
| description |
character varying(80) |
No |
No |
|
Description of item |
| unit_qty |
numeric(15,5) |
No |
No |
|
Quantity of component |
| unit_cost |
numeric(15,5) |
No |
No |
|
Cost of component |
| user_cost_flag |
boolean |
No |
No |
|
User edit cost TRUE = Yes FALSE = No |
| uom_usage |
character varying(10) |
No |
No |
|
Unit of measure quantity |
| lead_time |
numeric(5) |
No |
No |
|
Lead time for item |
| category |
character varying(6) |
No |
No |
|
Category for component |
| expected_scrap_pct |
numeric(5,2) |
No |
No |
|
Expected scrap for the component |
| guid |
character varying(32) |
No |
No |
|
GUID linking to purchase or production order |
| vend_no |
character varying(20) |
No |
No |
|
Vendor this component is to be ordered from. |
| employee |
character varying(6) |
No |
No |
|
Employee added to this line. |
| revision |
character varying(8) |
No |
No |
|
|
| instructions |
text |
No |
No |
|
Line isntructions for this component |
| user_flag |
boolean |
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 |
|
|
| parent_item_id |
integer |
No |
No |
|
ID of the parent when sub assemblies are toggled |
| udf_data |
hstore |
No |
No |
''::hstore |
hstore field containing user defined data |