FND Design Data [Home] [Help]

Table: SY_REAS_CDS

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: Not implemented in this database
Primary Key: SY_REAS_CDS_PK
  1. ColumnREASON_CODE
Foreign Keys
Table
Foreign Table Foreign Key Column
SY_REAS_CDS FK Joins to TableSY_TEXT_HDR SY_REAS_CDS.TEXT_CODE
TableGL_ACCT_MAP FK Joins to SY_REAS_CDS GL_ACCT_MAP.REASON_CODE
TableIC_ADJS_JNL FK Joins to SY_REAS_CDS IC_ADJS_JNL.REASON_CODE
TableIC_PHYS_CNT FK Joins to SY_REAS_CDS IC_PHYS_CNT.REASON_CODE
TableIC_TRAN_ARC FK Joins to SY_REAS_CDS IC_TRAN_ARC.REASON_CODE
TableIC_TRAN_CMP FK Joins to SY_REAS_CDS IC_TRAN_CMP.REASON_CODE
TableIC_TRAN_PND FK Joins to SY_REAS_CDS IC_TRAN_PND.REASON_CODE
TableIC_XFER_MST FK Joins to SY_REAS_CDS IC_XFER_MST.RELEASE_REASON_CODE
TableIC_XFER_MST FK Joins to SY_REAS_CDS IC_XFER_MST.RECEIVE_REASON_CODE
TableIC_XFER_MST FK Joins to SY_REAS_CDS IC_XFER_MST.CANCEL_REASON_CODE
TableOP_ORDR_DTL FK Joins to SY_REAS_CDS OP_ORDR_DTL.CHANGEREAS_CODE
TableOP_ORDR_HDR FK Joins to SY_REAS_CDS OP_ORDR_HDR.CHANGEREAS_CODE
TablePC_TRAN_PND FK Joins to SY_REAS_CDS PC_TRAN_PND.REASON_CODE
TablePO_BPOS_DTL FK Joins to SY_REAS_CDS PO_BPOS_DTL.BPOHOLD_CODE
TablePO_BPOS_DTL FK Joins to SY_REAS_CDS PO_BPOS_DTL.CANCELLATION_CODE
TablePO_BPOS_DTL FK Joins to SY_REAS_CDS PO_BPOS_DTL.CLOSURE_CODE
TablePO_BPOS_HDR FK Joins to SY_REAS_CDS PO_BPOS_HDR.BPOHOLD_CODE
TablePO_BPOS_HDR FK Joins to SY_REAS_CDS PO_BPOS_HDR.CANCELLATION_CODE
TablePO_BPOS_HDR FK Joins to SY_REAS_CDS PO_BPOS_HDR.CLOSURE_CODE
TablePO_ORDR_DTL FK Joins to SY_REAS_CDS PO_ORDR_DTL.POHOLD_CODE
TablePO_ORDR_DTL FK Joins to SY_REAS_CDS PO_ORDR_DTL.CANCELLATION_CODE
TablePO_ORDR_HDR FK Joins to SY_REAS_CDS PO_ORDR_HDR.POHOLD_CODE
TablePO_ORDR_HDR FK Joins to SY_REAS_CDS PO_ORDR_HDR.CANCELLATION_CODE
TablePO_RECV_HDR FK Joins to SY_REAS_CDS PO_RECV_HDR.REASON_CODE
TablePO_RTRN_DTL FK Joins to SY_REAS_CDS PO_RTRN_DTL.RETURN_CODE