VENDOR FULL Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ALTERNATE_PAYEE_INDICATOR |
XXX |
VARCHAR2 |
1 |
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 |
COMMUNICATION_TYPE_DESCRIPTION |
XXX |
VARCHAR2 |
20 |
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 |
NATURAL_PERSON |
XXX |
VARCHAR2 |
1 |
PAYMENT_GROUPING_KEY |
XXX |
VARCHAR2 |
2 |
PAYMENT_METHODS |
XXX |
VARCHAR2 |
10 |
PAYMENT_TERMS |
XXX |
VARCHAR2 |
4 |
PERSONNEL_KEY |
Key field used to join to the PERSONNEL table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
8 |
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 |
RELEASE_GROUP |
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 |
TAX_NUMBER |
XXX |
VARCHAR2 |
16 |
TAX_NUMBER_1 |
Primary Tax identification number. |
VARCHAR2 |
16 |
TAX_NUMBER_2 |
Secondary Tax identification number. |
VARCHAR2 |
11 |
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 |
VENDOR_PERMITTED_AS_PAYEE |
XXX |
VARCHAR2 |
10 |
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 |