Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse SALES ORDER PARTNER Table


View exposing sales order partner reference data including partner type, category, customer identifiers, and partner name.


Field Name

Description

Data Type

Length

CUSTOMER_KEY

Surrogate key identifying the customer.

VARCHAR2

11

SALES_ORDER_PARTNER_CATEGORY

Sales order partner category associated with the record.

VARCHAR2

1

SALES_ORDER_PARTNER_ID

Business identifier for the sales order partner.

VARCHAR2

10

SALES_ORDER_PARTNER_KEY

Surrogate key identifying the sales order partner.

VARCHAR2

20

SALES_ORDER_PARTNER_NAME

Sales order partner name associated with the record.

VARCHAR2

70

SALES_ORDER_PARTNER_TYPE

Sales order partner type associated with the record.

VARCHAR2

20

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE