Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse CYBERSOURCE MERCHANT HIER Table


XXX


Field Name

Description

Data Type

Length

CYBER_MERCHANT_ID

XXX

VARCHAR2

30

CYBER_MERCHANT_KEY

XXX

VARCHAR2

30

CYBER_MERCHANT_NAME

XXX

VARCHAR2

255

LEVEL1_ID

The code assigned to this Profit Center Group hierarchy node in SAP.

VARCHAR2

30

LEVEL1_NAME

The Profit Center Group name assigned to this hierarchy node in SAP.

VARCHAR2

255

LEVEL2_ID

The code assigned to this Profit Center Group hierarchy node in SAP.

VARCHAR2

30

LEVEL2_NAME

The Profit Center Group name assigned to this hierarchy node in SAP.

VARCHAR2

255

LEVEL3_ID

The code assigned to this Profit Center Group hierarchy node in SAP.

VARCHAR2

30

LEVEL3_NAME

The Profit Center Group name assigned to this hierarchy node in SAP.

VARCHAR2

255

LEVEL4_ID

The code assigned to this Profit Center Group hierarchy node in SAP.

VARCHAR2

30

LEVEL4_NAME

The Profit Center Group name assigned to this hierarchy node in SAP.

VARCHAR2

255

LEVEL5_ID

The code assigned to this Profit Center Group hierarchy node in SAP.

VARCHAR2

30

LEVEL5_NAME

The Profit Center Group name assigned to this hierarchy node in SAP.

VARCHAR2

255

LEVEL6_ID

The code assigned to this Profit Center Group hierarchy node in SAP.

VARCHAR2

30

LEVEL6_NAME

The Profit Center Group name assigned to this hierarchy node in SAP.

VARCHAR2

255

LEVEL7_ID

The code assigned to this Profit Center Group hierarchy node in SAP.

VARCHAR2

30

LEVEL7_NAME

The Profit Center Group name assigned to this hierarchy node in SAP.

VARCHAR2

255

LEVEL8_ID

XXX

VARCHAR2

30

LEVEL8_NAME

XXX

VARCHAR2

255

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE