| View Name: | recv_sum |
| View Number: | 23 |
| Group: | Logistics |
| Description: | Queries in the query group. Used by form Receipts Query List (590) |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| objid | recv_parts | objid | Recv_parts internal record number | 3 (UNIQUE) |
| trans_date | part_trans | creation_date | The date of transaction | |
| ref_number | part_trans | reference_no | The reference number of transaction | |
| qty | part_trans | quantity | The quantity of transaction | |
| to_location | to_loc(inv_locatn) | location_name | The TO location for the parts | |
| fr_location | from_loc(inv_locatn) | location_name | The FROM location for the parts | |
| to_bin | to_bin(inv_bin) | bin_name | The To inventory bin name | |
| from_bin | from_bin(inv_bin) | bin_name | The From inventory bin name | |
| part_number | part_trans | part_number | The part number | |
| serial_no | demand_dtl | serial_no | The serial number of the requested part | |
| receipt_type | recv_parts | receipt_type | The receipt type of the transaction | |
| title | demand_dtl | title | Part request title | 2 |
| mod_level | mod_level | mod_level | The revision of the part | |
| dtl_objid | demand_dtl | objid | Unique object ID number of parent object | |
| hdr_objid | demand_hdr | objid | Demand hdr internal record number | |
| part_num_desc | part_num | description | Maps to sales and mfg systems | |
| detail_number | demand_dtl | detail_number | The part request number for the request | |
| recv_serial_no | part_inst | part_serial_no | The serial number of the received part |
| Join From | Join To |
|---|---|
| (part_trans).recv_trans2recv_parts | (recv_parts).received2part_trans |
| (part_trans).to_bin2inv_bin | to_bin(inv_bin).to_bin2part_trans |
| (part_trans).from_bin2inv_bin | from_bin(inv_bin).from_bin2part_trans |
| from_bin(inv_bin).inv_bin2inv_locatn | from_loc(inv_locatn).inv_locatn2inv_bin |
| to_bin(inv_bin).inv_bin2inv_locatn | to_loc(inv_locatn).inv_locatn2inv_bin |
| (part_trans).from_inst2part_inst | (part_inst).from_inst2part_trans |
| (part_inst).n_part_inst2part_mod | (mod_level).n_part_info2part_inst |
| (mod_level).part_info2part_num | (part_num).part_num2mod_level |
| (part_trans).part_trans2demand_dtl | (demand_dtl).demand_dtl2part_trans |
| (demand_dtl).demand_dtl2demand_hdr | (demand_hdr).demand_hdr2demand_dtl |
| recv_sum | |||