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 |
|