SWO-Part
This category groups 2 relationships in the Ramco Aviation domain.
Edges
FOR_PART — ShopWorkOrder → Part
SWO is for a part
- Source table: swo_swoh_shop_wo_hdr
- Target table: PRT_PRCRL_CENTRALREFLIST_INFO
- SQL join:
swo_swoh_shop_wo_hdr.swoh_part_desc = PRT_PRCRL_CENTRALREFLIST_INFO.PRCRL_PART_DESC - Inference:
suffix_match
SWO_PART_CONSUMPTION — SWOPartDetail → Part
SWO part detail for specific part
- Source table: swo_swoprt_part_details
- Target table: PRT_PRCRL_CENTRALREFLIST_INFO
- SQL join:
swo_swoprt_part_details.swoprt_part_no = PRT_PRCRL_CENTRALREFLIST_INFO.PRCRL_PART_NO - Inference:
suffix_match