Reference table mappings
The following table shows the WebSphere Commerce Analyzer set of reference tables that have direct mappings to WebSphere Commerce tables.
| WebSphere Commerce AnalyzerTable.Column names | WebSphere Commerce Table.Column name | WebSphere Commerce edition |
|---|---|---|
| ACCT_STATUS_REF.ACCT_STATUS_ID | ACCOUNT.STATE | |
| AD_TYPE_REF.AD_TYPE_MAP | CPPMN.PROMODISPTYPE | |
| ADJUST_LEVEL_REF.ADJUST_LEVEL_MAP | ORDIADJUST.DISPLAYLEVEL | |
| ADJUST_TYPE_REF.ADJUST_TYPE.MAP | ORDIADJUST.CALUSAGE_ID | |
| ADDRESS_TYPE_REF.ADDRESS_TYPE | ADDRESS.ADDRESS_TYPE | |
| AGE_RANGE_REF.AGE_RANGE | USERDEMO.AGE | |
| APV_STATUS_REF.APV_STATUS_ID | MEMBER.STATE | |
| BUYERPOTYP_REF.BUYERPOTYP_ID | BUYERPO.BUYERPOTYP_ID | |
| CON_STATUS_REF.CON_STATUS_ID | CONTRACT.STATE | |
| CPN_STATUS_REF.CPN_STATUS_MAP | CPPMN.STATUS | |
| CPN_TYPE_REF.CPN_TYPE_MAP | CPPMN.PURCHASECONDTYPE | |
| DAY_OF_WK_REF | No corresponding WebSphere Commerce table. | |
| DAY_RANGE_REF | No corresponding WebSphere Commerce table. | |
| DR_MEMBER_TYPE_REF | No corresponding WebSphere Commerce table. | |
| EVENT_TYPE_REF | No corresponding WebSphere Commerce table. | |
| GENDER_REF.GENDER | USERDEMO.GENDER |
|
| GENDER_REF.GENDER | No corresponding WebSphere Commerce table. | |
| HOUR_TYPE_REF | No corresponding WebSphere Commerce table. | |
| INCOME_REF.INCOME_RANGE | USERDEMO.INCOME |
|
| INVNTRY_STAT_REF.INVNTRY_STAT_SDESC | ORDERITEMS.INVENTORYSTATUS |
|
| LAST_UPDATED_REF | No corresponding WebSphere Commerce table. | |
| MARITAL_STAT_REF.MARITAL_STATUS | USERDEMO.MARITAL_STATUS |
|
| MEMBER_TYPE_REF.MEMBER_TYPE | USERS.REGISTERTYPE |
|
| MPE_TYPE_REF.MPE_TYPE | MPETYPE.NAME |
|
| MPF_TYPE_REF.MPF_TYPE_DESC | USERS.PROFILETYPE | |
| ORDER_STATUS_REF.ORDER_STATUS | ORDERS.STATUS ORDERITEMS.STATUS |
|
| ORIGIN_REF.ORIGIN_ID | CONTRACT.ORIGIN | |
| PARTROLE_REF.PARTROLE_ID | PARTICIPNT.PARTROLE_ID | |
| PER_AGGR_REF | No corresponding WebSphere Commerce table. | |
| RANK_RANGE_REF | No corresponding WebSphere Commerce table. | |
| RFQ_ENDRES_REF.RFQ_ENDRES_ID | RFQ.ENDRESULT | |
| RFQ_STATUS_REF.RFQ_STATUS_ID | RFQ.STATE | |
| RSP_STATUS_REF.RSP_STATUS_ID | RFQRSP.STATE | |
| SEG_ATTRIBUTE_REF | No corresponding WebSphere Commerce table. | |
| SEGMENTATION_REF | No corresponding WebSphere Commerce table. | |
| TRADETYPE_REF.TRDTYPE_ID | TRADING.TRDTYPE_ID | |
| TRD_STATUS_REF.TRD_STATUS_ID | TRADING.STATE |
(C) Copyright IBM Corporation 1996, 2006. All Rights Reserved.