id |
integer |
Yes |
Yes |
nextval('production_template_items_id_seq'::regclass) |
Unique identifier |
template_id |
integer |
Yes |
No |
|
Link to production_templates.id |
child_template_id |
integer |
No |
No |
|
Link to production.template_id for sub assemblies |
sequence |
smallint |
No |
No |
|
Sequential number for order line |
whse |
character varying(6) |
No |
No |
|
Inventory warehouse for this record - links to inventory.whse |
part_no |
character varying(34) |
No |
No |
|
Inventory part number for this record - links to inventory.part_no |
description |
character varying(80) |
No |
No |
|
Description of component |
unit_qty |
numeric(15,5) |
No |
No |
|
Quantity required of this component to build 1 of the sub-assembly or assembly, 1 level abov |
unit_cost |
numeric(15,5) |
No |
No |
|
Cost of the component |
uom_usage |
character varying(10) |
No |
No |
|
Unit of Measure to use for this item |
lead_time |
numeric(5) |
No |
No |
|
Lead time of the item as set by user |
category |
character varying(6) |
No |
No |
|
Category assigned to this component - links to bom_categories.category |
expected_scrap_pct |
numeric(5,2) |
No |
No |
|
Expected scrap percentage of the component |
guid |
character varying(32) |
No |
No |
|
Uniique identifier for linking to production_order_items |
vend_no |
character varying(20) |
No |
No |
|
Vendor code that will be used for Inventory Requisition |
employee |
character varying(6) |
No |
No |
|
Employee number added to the line - links to employees.employee_no |
revision |
character varying(8) |
No |
No |
|
The revision number set by user when the Template was last edited and saved |
instructions |
text |
No |
No |
|
Component instruction notes |
user_flag |
boolean |
No |
No |
|
|
_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 |
parent_item_id |
integer |
No |
No |
|
Link to production_order_items.id for the parent of this record |
udf_data |
hstore |
No |
No |
''::hstore |
User defined data for this record |