FND Design Data [Home] [Help]

Table: SY_REAS_CDS_B

Product: GMA - Process Manufacturing Systems
Description: The Reason Code table is used to store Reason Code definitions which provide information on the increase or decrease in inventory. Reason codes are used to flag transactions and attach reasons to them.
Implementation/DBA Data: TableGMA.SY_REAS_CDS_B
Primary Key: SY_REAS_CDS_B_PK
  1. ColumnREASON_CODE
Foreign Keys
Table
Foreign Table Foreign Key Column
SY_REAS_CDS_B FK Joins to TableSY_TEXT_HDR SY_REAS_CDS_B.TEXT_CODE
TableGL_ACCT_MAP FK Joins to SY_REAS_CDS_B GL_ACCT_MAP.REASON_CODE
TableGMP_RSRC_EXCP_DTL FK Joins to SY_REAS_CDS_B GMP_RSRC_EXCP_DTL.REASON_CODE
TableGMP_RSRC_UNAVAIL_MAN FK Joins to SY_REAS_CDS_B GMP_RSRC_UNAVAIL_MAN.REASON_CODE
TableIC_ADJS_JNL FK Joins to SY_REAS_CDS_B IC_ADJS_JNL.REASON_CODE
TableIC_PHYS_CNT FK Joins to SY_REAS_CDS_B IC_PHYS_CNT.REASON_CODE
TableIC_TRAN_ARC FK Joins to SY_REAS_CDS_B IC_TRAN_ARC.REASON_CODE
TableIC_TRAN_CMP FK Joins to SY_REAS_CDS_B IC_TRAN_CMP.REASON_CODE
TableIC_TRAN_PND FK Joins to SY_REAS_CDS_B IC_TRAN_PND.REASON_CODE
TableIC_XFER_MST FK Joins to SY_REAS_CDS_B IC_XFER_MST.RELEASE_REASON_CODE
TableIC_XFER_MST FK Joins to SY_REAS_CDS_B IC_XFER_MST.RECEIVE_REASON_CODE
TableIC_XFER_MST FK Joins to SY_REAS_CDS_B IC_XFER_MST.CANCEL_REASON_CODE
TableOP_ORDR_DTL FK Joins to SY_REAS_CDS_B OP_ORDR_DTL.CHANGEREAS_CODE
TableOP_ORDR_HDR FK Joins to SY_REAS_CDS_B OP_ORDR_HDR.CHANGEREAS_CODE
TablePC_TRAN_PND FK Joins to SY_REAS_CDS_B PC_TRAN_PND.REASON_CODE
TablePO_BPOS_DTL FK Joins to SY_REAS_CDS_B PO_BPOS_DTL.BPOHOLD_CODE
TablePO_BPOS_DTL FK Joins to SY_REAS_CDS_B PO_BPOS_DTL.CANCELLATION_CODE
TablePO_BPOS_DTL FK Joins to SY_REAS_CDS_B PO_BPOS_DTL.CLOSURE_CODE
TablePO_BPOS_HDR FK Joins to SY_REAS_CDS_B PO_BPOS_HDR.BPOHOLD_CODE
TablePO_BPOS_HDR FK Joins to SY_REAS_CDS_B PO_BPOS_HDR.CANCELLATION_CODE
TablePO_BPOS_HDR FK Joins to SY_REAS_CDS_B PO_BPOS_HDR.CLOSURE_CODE
TablePO_ORDR_DTL FK Joins to SY_REAS_CDS_B PO_ORDR_DTL.POHOLD_CODE
TablePO_ORDR_DTL FK Joins to SY_REAS_CDS_B PO_ORDR_DTL.CANCELLATION_CODE
TablePO_ORDR_HDR FK Joins to SY_REAS_CDS_B PO_ORDR_HDR.POHOLD_CODE
TablePO_ORDR_HDR FK Joins to SY_REAS_CDS_B PO_ORDR_HDR.CANCELLATION_CODE
TablePO_RECV_HDR FK Joins to SY_REAS_CDS_B PO_RECV_HDR.REASON_CODE
TablePO_RTRN_DTL FK Joins to SY_REAS_CDS_B PO_RTRN_DTL.RETURN_CODE