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
  • Business Edition
AD_TYPE_REF.AD_TYPE_MAP CPPMN.PROMODISPTYPE
  • Professional Edition
  • Business Edition
ADJUST_LEVEL_REF.ADJUST_LEVEL_MAP ORDIADJUST.DISPLAYLEVEL
  • Professional Edition
  • Business Edition
ADJUST_TYPE_REF.ADJUST_TYPE.MAP ORDIADJUST.CALUSAGE_ID
  • Professional Edition
  • Business Edition
ADDRESS_TYPE_REF.ADDRESS_TYPE ADDRESS.ADDRESS_TYPE
  • Professional Edition
  • Business Edition
AGE_RANGE_REF.AGE_RANGE USERDEMO.AGE
  • Professional Edition
  • Business Edition
APV_STATUS_REF.APV_STATUS_ID MEMBER.STATE
  • Business Edition
BUYERPOTYP_REF.BUYERPOTYP_ID BUYERPO.BUYERPOTYP_ID
  • Business Edition
CON_STATUS_REF.CON_STATUS_ID CONTRACT.STATE
  • Business Edition
CPN_STATUS_REF.CPN_STATUS_MAP CPPMN.STATUS
  • Professional Edition
  • Business Edition
CPN_TYPE_REF.CPN_TYPE_MAP CPPMN.PURCHASECONDTYPE
  • Professional Edition
  • Business Edition
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
  • Professional Edition
  • Business Edition
GENDER_REF.GENDER No corresponding WebSphere Commerce table.
HOUR_TYPE_REF No corresponding WebSphere Commerce table.
INCOME_REF.INCOME_RANGE USERDEMO.INCOME
  • Professional Edition
  • Business Edition
INVNTRY_STAT_REF.INVNTRY_STAT_SDESC ORDERITEMS.INVENTORYSTATUS
  • Professional Edition
  • Business Edition
LAST_UPDATED_REF No corresponding WebSphere Commerce table.
MARITAL_STAT_REF.MARITAL_STATUS USERDEMO.MARITAL_STATUS
  • Professional Edition
  • Business Edition
MEMBER_TYPE_REF.MEMBER_TYPE USERS.REGISTERTYPE
  • Professional Edition
  • Business Edition
MPE_TYPE_REF.MPE_TYPE MPETYPE.NAME
  • Professional Edition
  • Business Edition
MPF_TYPE_REF.MPF_TYPE_DESC USERS.PROFILETYPE
  • Business Edition
ORDER_STATUS_REF.ORDER_STATUS ORDERS.STATUS ORDERITEMS.STATUS
  • Professional Edition
  • Business Edition
ORIGIN_REF.ORIGIN_ID CONTRACT.ORIGIN
  • Business Edition
PARTROLE_REF.PARTROLE_ID PARTICIPNT.PARTROLE_ID
  • Business Edition
PER_AGGR_REF No corresponding WebSphere Commerce table.
RANK_RANGE_REF No corresponding WebSphere Commerce table.
RFQ_ENDRES_REF.RFQ_ENDRES_ID RFQ.ENDRESULT
  • Business Edition
RFQ_STATUS_REF.RFQ_STATUS_ID RFQ.STATE
  • Business Edition
RSP_STATUS_REF.RSP_STATUS_ID RFQRSP.STATE
  • Business Editionf
SEG_ATTRIBUTE_REF No corresponding WebSphere Commerce table.
SEGMENTATION_REF No corresponding WebSphere Commerce table.
TRADETYPE_REF.TRDTYPE_ID TRADING.TRDTYPE_ID
  • Business Edition
TRD_STATUS_REF.TRD_STATUS_ID TRADING.STATE
  • Business Edition

Feedback