| id |
integer |
Yes |
Yes |
nextval('bom_item_replacements_id_seq'::regclass) |
Unique identifier |
| status |
character varying(1) |
No |
No |
|
Status flag; A = Applied U = Unapplied |
| uuid |
character varying(36) |
No |
No |
|
Unique record indentifier |
| old_whse |
character varying(6) |
No |
No |
|
Warehouse for old (original) part number |
| old_part_no |
character varying(34) |
No |
No |
|
Old part number to be replaced |
| new_whse |
character varying(6) |
No |
No |
|
Warehouse for new (replacement) part number |
| new_part_no |
character varying(34) |
No |
No |
|
New replacement part number |
| update_bom |
boolean |
No |
No |
|
Update templates flag; FALSE = No TRUE = Yes |
| update_bo |
boolean |
No |
No |
|
Update Production Orders flag; FALSE = No TRUE = Yes |
| include_allocated |
boolean |
No |
No |
|
Update committed Production Orders components; FALSE = No TRUE = Yes |
| _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 record was last modified |
| _modified_by |
character varying(3) |
No |
No |
|
User initials that modified this record |