View Name:trans_sum
View Number:19
Group:Logistics
Description:Displays queries in the query group. Used by form Transaction Query List (587)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidpart_transobjidPart transaction internal record number 3 (UNIQUE)
part_mod_objidmod_levelobjidPart revision internal record number 
to_locationto_bin(inv_bin)location_nameThe TO location for the parts 
fr_locationfrom_bin(inv_bin)location_nameThe FROM location for the parts 
trans_datepart_transcreation_dateThe date of transaction 
ref_numberpart_transreference_noThe reference number of transaction 
trans_idpart_transtransaction_idThe ID number of transaction 
part_numberpart_numpart_numberPart number/name 
part_num_descpart_numdescriptionDescription of the product 
qtypart_transquantityThe quantity of transaction 
std_costpart_transstandard_costThe cost of transaction 
serial_nofrom_inst(part_inst)part_serial_noThe serial number transaction 
mod_levelmod_levelmod_levelPart revision 
to_binto_bin(inv_bin)bin_nameThe TO inventory bin name 
from_binfrom_bin(inv_bin)bin_nameThe FROM inventory bin name 
notespart_transnotesNotes for the transaction 
fr_bin_objidfrom_bin(inv_bin)objidInternal record number of the FROM inventory bin 
to_bin_objidto_bin(inv_bin)objidInternal record number of the TO inventory bin 
part_objidpart_numobjidInternal record number of the part number 
movement_typepart_transmovement_typeMovement type; i.e., 0=good to good, 1=good to bad, 2=bad to good, 3=bad to bad 
to_inst_objidto_inst(part_inst)objidThe TO part_inst internal record number for this part transaction 
fr_inst_objidfrom_inst(part_inst)objidThe FROM part_inst internal record number for this part transaction 
to_containerto_bin(inv_bin)id_numberThe TO inventory container ID 
from_containerfrom_bin(inv_bin)id_numberThe FROM inventory container ID 

Joins:

Join FromJoin To
(part_trans).from_inst2part_instfrom_inst(part_inst).from_inst2part_trans
from_inst(part_inst).n_part_inst2part_mod(mod_level).n_part_info2part_inst
(mod_level).part_info2part_num(part_num).part_num2mod_level
(part_trans).to_bin2inv_binto_bin(inv_bin).to_bin2part_trans
(part_trans).from_bin2inv_binfrom_bin(inv_bin).from_bin2part_trans
(part_trans).to_inst2part_instto_inst(part_inst).to_inst2part_trans
My Recent Objects
trans_sum