Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse VENDOR Table


Contains data about vendors: vendor name, address, vendor number in SAP, telephone and fax numbers, and other contact information.


Field Name

Description

Data Type

Length

ALTERNATE_PAYEE_VENDOR_NUMBER

Identifies an alternate vendor to whom payments are usually made. This allows purchases to be made from vendor A and payments made to vendor B identified by this field. In this case, vendor B may be vendor A's bank or a subdivision of vendor A's company.

VARCHAR2

10

ANY_POSTING_BLOCK

Indicates whether a vendor has been blocked for posting EITHER for a specific company code OR for all company codes. Values are Y (blocked) or N (not blocked). Will be set to Y if either of Central Posting Block or Company Posting Block is Y.

VARCHAR2

1

BLOCKED_FUNCTIONS_CODE

Code indicating which, if any, purchasing functions have been blocked for a vendor. The meanings of the codes can be gleaned by looking at the Blocked Functions Desc field.

VARCHAR2

2

BLOCKED_FUNCTIONS_DESC

Text describing which, if any, purchasing functions have been blocked for a vendor.

VARCHAR2

40

CENTRAL_POSTING_BLOCK

Indicates whether a vendor has been blocked for posting for all company codes. Values are Y (blocked) or N (not blocked).

VARCHAR2

1

CENTRAL_PURCHASING_BLOCK

Indicates whether a vendor has been blocked for purchasing for all company codes. Values are Y (blocked) or N (not blocked).

VARCHAR2

1

CHECK_FOR_DOUBLE_INVOICES

XXX

VARCHAR2

1

CITY

City.

VARCHAR2

35

COMPANY_CODE

Shows to which "company" in SAP a cost collector is attached. MIT uses separate "companies" in SAP to differentiate financial transactions for different legal entities with differing business rules or reporting requirements. There are currently three company codes, "CUR" for main campus, "TECR" for MIT's alumni magazine, Technology Review, and "LCP1" for Lincoln Laboratory.

VARCHAR2

4

COMPANY_PAYMENT_BLOCK

XXX

VARCHAR2

1

COMPANY_POSTING_BLOCK

Indicates whether a vendor has been blocked for posting for a specific company code. Values are Y (blocked) or N (not blocked).

VARCHAR2

1

COUNTRY_CODE

The 3 digit code which identifies a country (Example: USA United States of America).

VARCHAR2

3

COUNTRY_NAME

The long name of the country (Example United States, France)

VARCHAR2

40

CREATION_DATE

The date a record was created.

DATE

8

CREATOR

The name of the person who created the record.

VARCHAR2

12

CREDIT_INFO_NUMBER

Reference number for credit agencies.

VARCHAR2

11

CUSTOMER_NUMBER

Identifies the customer.

VARCHAR2

10

DELETE_FLAG

Indicates whether the record is marked as deleted. Values are Y (marked as deleted) and N (not marked as deleted).

VARCHAR2

1

FAX_NUMBER

The employee's FAX number.

VARCHAR2

31

GL_RECONCILIATION_ACCOUNT

XXX

VARCHAR2

10

HOUSE_BANK

XXX

VARCHAR2

5

INDUSTRY_CODE

XXX

VARCHAR2

4

INDUSTRY_DESCRIPTION

XXX

VARCHAR2

20

IS_ALT_PAYEE_ALLOWED

Indicates whether payments for POs for this vendor can be made to a different vendor. Values are Y (payments can be made to a different vendor) or N (payments must be made to this vendor).

VARCHAR2

1

IS_CREDIT_CARD_ACCEPTED

Indicates whether the vendor accepts MIT credit cards. Values are Y (accepts credit card), N (does not accept credit card) or U (not known whether vendor accepts card).

VARCHAR2

1

IS_ONE_TIME_VENDOR

Indicates whether this is a one-time vendor - a vendor who is not expected to supply materials or service on a regular basis. Values are Y (one-time vendor) or N (not one-time vendor).

VARCHAR2

1

LAST_EXTERNAL_REVIEW_DATE

XXX

DATE

7

MASTER_REC_VENDOR_NUMBER

Identifies the vendor number representing a 'master' record holding a fiscal address.

VARCHAR2

10

MINORITY_NAME

Minority group to which the vendor belongs. (example: Small Business, Non-Profit, Large Business, Foreign Company)

VARCHAR2

30

PAYMENT_GROUPING_KEY

XXX

VARCHAR2

2

PAYMENT_METHODS

XXX

VARCHAR2

10

PAYMENT_TERMS

XXX

VARCHAR2

4

PHONE_NUMBER_1

Primary telephone number

VARCHAR2

16

PHONE_NUMBER_2

Secondary telephone number

VARCHAR2

16

POSTAL_CODE

Postal Code (part of an address)

VARCHAR2

15

PO_BOX

Post Office Box.

VARCHAR2

10

PREVIOUS_ACCOUNT_NUMBER

XXX

VARCHAR2

10

RECIPIENT_TYPE

XXX

VARCHAR2

2

SEARCH_TERM_1

XXX

VARCHAR2

10

SEARCH_TERM_2

XXX

VARCHAR2

20

STATE

State.

VARCHAR2

30

STREET

In the SPONSORED_BILLING_CUSTOMER and VENDOR tables, the street address of a person or business doing business with MIT.

VARCHAR2

35

TELEBOX

XXX

VARCHAR2

15

TELEX_NUMBER

Telex number.

VARCHAR2

30

VENDOR_ACCOUNT_GROUP_NAME

Account group to which the vendor belongs.

VARCHAR2

30

VENDOR_EMAIL

XXX

VARCHAR2

241

VENDOR_KEY

Key identifying an entry in the VENDOR master table. This field should only be used for linking tables together, not for reporting.

VARCHAR2

11

VENDOR_NAME_1

First part of the vendor name. This could refer to a company, MIT employee, student, or affiliate.

VARCHAR2

35

VENDOR_NAME_2

Second part of the vendor name.

VARCHAR2

35

VENDOR_NAME_3

Third part of the vendor name.

VARCHAR2

35

VENDOR_NAME_4

Fourth part of the vendor name.

VARCHAR2

35

VENDOR_NUMBER

10 digit number identifing the vendor.

VARCHAR2

10

WAREHOUSE_CURRENT_TIMESTAMP

XXX

DATE

7

WAREHOUSE_LOAD_DATE

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

DATE

8

WITHHOLDING_COUNTRY

XXX

VARCHAR2

3

WITHHOLDING_EXEMPN_AUTH

XXX

VARCHAR2

1

WITHHOLDING_EXEMPN_NUMBER

XXX

VARCHAR2

10

WITHHOLDING_EXEMPN_VALID_UNTIL

XXX

DATE

8

WITHHOLDING_TAX_CODE

XXX

VARCHAR2

2

ZIP_CODE

The zip code.

VARCHAR2

10