Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse SALES ORDER PARTNER Table


Sales Order Partners information-- currently contains Tech Review data only


Field Name

Description

Data Type

Length

CUSTOMER_KEY

This key is to be used to join the FINANCIAL_DETAIL and the PROJECT or PROJECT_OSP tables. This field should only be used for linking tables together, NOT for reporting.

VARCHAR2

11

SALES_ORDER_PARTNER_CATEGORY

XXX

VARCHAR2

1

SALES_ORDER_PARTNER_ID

XXX

VARCHAR2

10

SALES_ORDER_PARTNER_KEY

Key field used to join to the SALES_ORDER_PARTNER table. This field should only be used for joining data, NOT for reporting

VARCHAR2

20

SALES_ORDER_PARTNER_NAME

XXX

VARCHAR2

70

SALES_ORDER_PARTNER_TYPE

XXX

VARCHAR2

20

WAREHOUSE_LOAD_DATE

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

DATE

8