objid | demand_dtl | objid | Demand_dlt internal record number | 3 (UNIQUE) |
hdr_objid | demand_hdr | objid | Demand hdr internal record number | |
part_mod_objid | mod_level | objid | Part revision internal record number | |
request_date | demand_hdr | header_date | The create date for the request header | |
case_id_number | demand_hdr | header_case_no | The case or subcase optionally related to the request | |
rma_number | demand_dtl | detail_number | The part request number for the request | |
site_name | demand_hdr | site_name | Local copy of the site name | |
part_number | part_num | part_number | Part number/name | |
request_type | demand_dtl | demand_subtype | Reserved; future | |
request_status | demand_hdr | request_status | Status of the request | |
order_qty | demand_dtl | demand_qty | The order quantity | |
activity | demand_dtl | activity | Reserved; future | |
required_date | demand_dtl | next_date | The date required | |
details_status | demand_dtl | request_status | Status of the request | |
details_type | demand_dtl | request_type | Type displayed in WIP and queue forms | |
part_num | part_num | description | Maps to sales and mfg systems | |
details_date | demand_dtl | details_date | The create date for the part request | |
serial_no | demand_dtl | serial_no | Serial number for the request | |
shipped_qty | demand_dtl | shipped_qty | The quantity shipped | |
backorder_qty | demand_dtl | backorder_qty | Reserved; future | |
part_mod_l | mod_level | mod_level | Revision level | |
condition | condition | title | Part request condition | 7 |
status | gse_status(gbst_elm) | title | Status of the part request | 17 |
owner | user | login_name | User login name | |
fulfilled_qty | demand_dtl | fulfilled_qty | Quantify fulfilled (moved) against the part request) | |
picked_qty | demand_dtl | picked_qty | Quantify picked (reserved for a fulfill) against the part request) | |
received_qty | demand_dtl | received_qty | Quantify received (from a fulfill) against the part request) | |
domain | part_num | domain | Name of the domain for the part num. See object prt_domain | |
cond_objid | condition | objid | Part request condition internal record number | |
cond_code | condition | condition | Part request condition code | |
owner_objid | user | objid | User owner of the part request internal record number | |
header_number | demand_hdr | header_number | header_number | |
orig_id | demand_dtl | orig_id | If originated from another demand_dtl, the originating part request's detail_number (see relation demand_dtl.child_dtl2demand_dtl) | |