VENDOR FS Table
Stores vendor master reference data sourced from Singapore Financials (FS), including vendor identifiers, names, contact details, and industry classification. Each row represents a vendor record as maintained in the Singapore Financials system for financial and procurement reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CITY |
City component of the vendor address from Singapore Financials (FS). |
VARCHAR2 |
35 |
COUNTRY_CODE |
Country code identifying the vendor?s country of residence or operation in Singapore Financials (FS). |
VARCHAR2 |
3 |
COUNTRY_NAME |
Descriptive country name corresponding to the country code in Singapore Financials (FS). |
VARCHAR2 |
15 |
FAX_NUMBER |
Fax number associated with the vendor in Singapore Financials (FS). |
VARCHAR2 |
31 |
INDUSTRY_CODE |
Code representing the industry classification assigned to the vendor in Singapore Financials (FS). |
VARCHAR2 |
4 |
INDUSTRY_DESCRIPTION |
Descriptive text of the industry classification associated with the vendor in Singapore Financials (FS). |
VARCHAR2 |
20 |
PHONE_NUMBER_1 |
Primary telephone number associated with the vendor in Singapore Financials (FS). |
VARCHAR2 |
16 |
PHONE_NUMBER_2 |
Secondary telephone number associated with the vendor in Singapore Financials (FS). |
VARCHAR2 |
16 |
POSTAL_CODE |
Postal code portion of the vendor address, used for international addressing in Singapore Financials (FS). |
VARCHAR2 |
10 |
PO_BOX |
Post office box address associated with the vendor in Singapore Financials (FS). |
VARCHAR2 |
10 |
SEARCH_TERM_1 |
Primary search term used to facilitate vendor lookup within Singapore Financials (FS) and downstream reporting systems. |
VARCHAR2 |
20 |
SEARCH_TERM_2 |
Secondary search term used to facilitate vendor lookup within Singapore Financials (FS) and downstream reporting systems. |
VARCHAR2 |
20 |
STATE |
State or province code associated with the vendor address in Singapore Financials (FS). |
VARCHAR2 |
3 |
STREET |
Street address of the vendor as recorded in Singapore Financials (FS). |
VARCHAR2 |
40 |
TELEBOX |
Telebox or electronic communication reference associated with the vendor in Singapore Financials (FS). |
VARCHAR2 |
40 |
TELEX_NUMBER |
Telex number associated with the vendor in Singapore Financials (FS), if applicable. |
VARCHAR2 |
30 |
VENDOR_KEY |
Surrogate key uniquely identifying the vendor record in the data warehouse derived from Singapore Financials (FS). |
VARCHAR2 |
11 |
VENDOR_NAME_1 |
Primary vendor name line as maintained in Singapore Financials (FS). |
VARCHAR2 |
50 |
VENDOR_NAME_2 |
Secondary vendor name line from Singapore Financials (FS), used for additional legal or business name information. |
VARCHAR2 |
50 |
VENDOR_NAME_3 |
Tertiary vendor name line from Singapore Financials (FS) for extended naming conventions or alternate identifiers. |
VARCHAR2 |
50 |
VENDOR_NAME_4 |
Quaternary vendor name line from Singapore Financials (FS) for additional descriptive or legal name information. |
VARCHAR2 |
50 |
VENDOR_NUMBER |
Business vendor number assigned in Singapore Financials (FS) and used as the primary operational vendor identifier. |
VARCHAR2 |
10 |
WAREHOUSE_LOAD_DATE |
Date the vendor record sourced from Singapore Financials (FS) was loaded into the data warehouse for reporting and audit purposes. |
DATE |
|
ZIP_CODE |
ZIP code portion of the vendor address, typically used for U.S. addresses in Singapore Financials (FS). |
VARCHAR2 |
10 |