| id |
integer |
Yes |
Yes |
nextval('production_templates_id_seq'::regclass) |
Unique identifier |
| template_no |
character varying(10) |
No |
No |
|
Template number |
| whse |
character varying(6) |
No |
No |
|
Warehouse of the manufactured item - links to inventory.whse |
| part_no |
character varying(34) |
No |
No |
|
Part number of the manufactured item - links to inventory.part_no |
| description |
character varying(80) |
No |
No |
|
Description of the manufactureded item, can be edited by user |
| status |
character varying(1) |
No |
No |
|
Not used |
| lead |
numeric(5) |
No |
No |
|
Lead time to build item as set by user |
| cust_no |
character varying(20) |
No |
No |
|
Customer that was assigned to this Production Template - 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 as set by user; 0 - Highest 1 - High 2 - Normal 3 - Low 4 - Lowest |
| expected_yield_pct |
numeric(5,2) |
No |
No |
|
Expected yield percentage |
| required_qty |
numeric(13,5) |
No |
No |
|
Default quantity required of the manufactured item |
| guid |
character varying(32) |
No |
No |
|
Uniique identifier for linking to production_orders |
| reference |
character varying(30) |
No |
No |
|
Default reference number |
| revision |
character varying(8) |
No |
No |
|
The revision number set by user when the Template was last edited and saved |
| employee |
character varying(6) |
No |
No |
|
Default employee number set on the line - links to employees.employee_no |
| instructions |
text |
No |
No |
|
Manufacturing instructions for the manufactured item |
| mfg_notes |
text |
No |
No |
|
Manufacturing notes for the manufactured item |
| _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 |
| default_flag |
boolean |
No |
No |
false |
Flag to assign this template as default when manufactured item is set on a Production Order; FALSE = No TRUE = Yes |
| udf_data |
hstore |
No |
No |
''::hstore |
User defined data for this record |