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 |