| View Name: | part_inst_alst |
| View Number: | 409 |
| Group: | Logistics |
| Description: | Used internally to feed Inventory Part activity log display |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| entry_time | act_entry | entry_time | Date and time of activity log entry | 1 |
| act_code | act_entry | act_code | Activity code | 10 |
| add_info | act_entry | addnl_info | Additional information such as notes | 11 |
| login_name | user | login_name | Login name of user that made activity log entry | 12 |
| parent_objid | from_part_inst(part_inst) | objid | Unique object ID number of parent object | 13 |
| to_objid | to_part_inst(part_inst) | objid | Unique object ID number of TO object | |
| objid | act_entry | objid | Unique object ID number of activity object | 3 (UNIQUE) |
| act_name | gbst_elm | title | Activity name | 2 |
| Join From | Join To |
|---|---|
| (act_entry).act_entry2user | (user).originator2act_entry |
| (act_entry).entry_name2gbst_elm | (gbst_elm).act_name2act_entry |
| (act_entry).act_entry2part_trans | (part_trans).part_trans2act_entry |
| (part_trans).from_inst2part_inst | from_part_inst(part_inst).from_inst2part_trans |
| (part_trans).to_inst2part_inst | to_part_inst(part_inst).to_inst2part_trans |
| part_inst_alst | |||