| id |
integer |
Yes |
Yes |
nextval('production_order_items_id_seq'::regclass) |
Unique identifier |
| sequence |
smallint |
No |
No |
|
Sequential number for order line |
| parent |
smallint |
No |
No |
|
Link to production_order_items.id for the parent of this record |
| 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 the component |
| unit_qty |
numeric(15,5) |
No |
No |
|
Quantity required of this component to build 1 of the sub-assembly or assembly, 1 level above |
| yield_qty |
numeric(21,5) |
No |
No |
|
Not used |
| scrap_qty |
numeric(21,5) |
No |
No |
|
Actual scrap quantity |
| extended_qty |
numeric(21,5) |
No |
No |
|
Extended quantity of the component |
| committed_qty |
numeric(21,5) |
No |
No |
|
Committed quantity of the component, affects inventory.committed_qty |
| consumed_qty |
numeric(21,5) |
No |
No |
|
Consumed quantity of the component as per partial builds |
| unit_cost |
numeric(15,5) |
No |
No |
|
Cost of the component |
| user_cost_flag |
boolean |
No |
No |
|
User edited cost flag; FALSE = No TRUE = Yes |
| uom_usage |
character varying(10) |
No |
No |
|
Unit of Measure to use for this item |
| uom_usage_factor |
numeric(13,5) |
No |
No |
|
Unit of Measure conversion factor to use for this record, 0 or 1 = no conversion |
| direct_factor |
boolean |
No |
No |
|
Use UOM direct factor for conversion; TRUE= multiply FALSE = divide |
| lead_time |
numeric(5) |
No |
No |
|
Lead time of the item as set by user |
| date |
date |
No |
No |
|
Order date, editable by user |
| category |
character varying(6) |
No |
No |
|
Category assigned to this component - links to bom_categories.category |
| expected_yield_pct |
numeric(5,2) |
No |
No |
|
Not used |
| 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 other tables; inventory_serial_transactions.link_guid inventory_receipts.link_guid inventory_requisitions_targ_guid |
| phase_id |
character varying(20) |
No |
No |
|
Not used |
| req_no |
character varying(10) |
No |
No |
|
Requisition number that was created by this record - links to inventory_requisitions.requisition_no |
| 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 |
| template_no |
character varying(10) |
No |
No |
|
Template that was used when creating this record |
| template_guid |
character varying(32) |
No |
No |
|
Template GUID that was used to create this line - links to production_template_items.guid |
| user_flag |
boolean |
No |
No |
|
Not used |
| revision |
character varying(8) |
No |
No |
|
The revision number of the template that created or last updated this record |
| _dbversion |
integer |
No |
No |
|
Unique identifier |
| _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 |
| instructions |
text |
No |
No |
|
Component instruction notes |
| order_id |
integer |
Yes |
No |
|
Link to production_order.id |
| udf_data |
hstore |
No |
No |
''::hstore |
User defined data for this record |