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 |