Table Detail Report

MM_XFI_CNTRCT_PRICE_ADJ



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM XFI CNTRCT PRICE ADJ
Definition: Table used to store relationships between contracts and price adjustments. Data is moved from this table to MM_CNTRCT_PRICE_ADJ.
Table Type: REFERENCE





Column Detail - MM_XFI_CNTRCT_PRICE_ADJ


Column Name Type Null? Definition
ACTION_FLAG DOUBLE Y Adjustment action flag
ADJUSTMENT DOUBLE Y adjustment
ADJ_CLASS_NODE VARCHAR(60) Y Adjustment class node
ADJ_CLASS_NODE_ID DOUBLE N Adjustment class node key
ADJ_METRIC VARCHAR(60) Y Adjustment metric
ADJ_METRIC_CD DOUBLE N Adjustment metric code value
ADJ_TYPE VARCHAR(60) Y Adjustment type
ADJ_TYPE_CD DOUBLE N Adjustment type code value
CONTRIBUTOR_CD DOUBLE N Contributor Source Code value
CREATE_APPLCTX DOUBLE Y The application context responsible for inserting this row on the table
CREATE_DT_TM DATETIME Y This is the date and time the note was created.
CREATE_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the insert of the row in the table.
CREATE_TASK DOUBLE Y The registered (assigned) task number for the process that inserted the row.
PRICE_ADJ_ID DOUBLE N price adjustment identifier
PROCESS_FLAG DOUBLE Y process flag
TRANSACTION_ID DOUBLE N Primary key
TRANS_PARENT_ID DOUBLE N transaction parent identifier
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - MM_XFI_CNTRCT_PRICE_ADJ


Child Column in MM_XFI_CNTRCT_PRICE_ADJ(FK) Parent Table Name Parent Column Name
Parents: ADJ_CLASS_NODE_ID CLASS_NODE CLASS_NODE_ID
PRICE_ADJ_ID MM_CNTRCT_PRICE_ADJ PRICE_ADJ_ID
TRANS_PARENT_ID MM_XFI_CNTRCT_HDR TRANSACTION_ID


MM_XFI_CNTRCT_REBATE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contract Rebate
Definition: Table used to store relationships between a contract and rebates that apply to that contract. Data is moved from this table to MM_CNTRCT_REBATE.
Table Type: REFERENCE





Column Detail - MM_XFI_CNTRCT_REBATE


Column Name Type Null? Definition
ACH_METRIC VARCHAR(60) Y Achievement metric
ACH_METRIC_CD DOUBLE N Achievement metric code value
ACH_THRESHOLD DOUBLE Y Achievement threshold
ACTION_FLAG DOUBLE Y Achievement action flag
CONTRIBUTOR_CD DOUBLE N Contributor used to resolve code value alias
CREATE_APPLCTX DOUBLE Y The application context number from the record info block.
CREATE_DT_TM DATETIME Y The date and time the record was created
CREATE_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
CREATE_TASK DOUBLE Y The registered (assigned) task number for the process that inserted the row.
PROCESS_FLAG DOUBLE Y process flag
REBATE_CALC_ON VARCHAR(60) Y rebate calculated on
REBATE_CALC_ON_CD DOUBLE N rebate calculated on code
REBATE_ID DOUBLE N Rebate Identifier
REBATE_PERIOD VARCHAR(60) Y rebate period
REBATE_PERIOD_CD DOUBLE N rebate period code
TRANSACTION_ID DOUBLE N Transaction identifier
TRANS_PARENT_ID DOUBLE N Transaction parent identifier
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - MM_XFI_CNTRCT_REBATE


Child Column in MM_XFI_CNTRCT_REBATE(FK) Parent Table Name Parent Column Name
Parents: REBATE_ID MM_CNTRCT_REBATE REBATE_ID
TRANS_PARENT_ID MM_XFI_CNTRCT_HDR TRANSACTION_ID