Data Warehouse

ALTERNATE_PAYEE_INDICATOR

Indicator specifying whether an alternate payee is defined for the vendor.

VARCHAR2

1

ALTERNATE_PAYEE_VENDOR_NUMBER

Vendor number of an alternate payee associated with this vendor.

VARCHAR2

10

ANY_POSTING_BLOCK

Indicator specifying whether any posting block exists for the vendor.

VARCHAR2

1

BLOCKED_FUNCTIONS_CODE

Code identifying specific blocked functions applicable to the vendor.

VARCHAR2

2

BLOCKED_FUNCTIONS_DESC

Description of blocked functions associated with the vendor.

VARCHAR2

40

CENTRAL_POSTING_BLOCK

Indicator specifying whether the vendor is blocked for central posting activities.

VARCHAR2

1

CENTRAL_PURCHASING_BLOCK

Indicator specifying whether the vendor is blocked for central purchasing activities.

VARCHAR2

1

CHECK_FOR_DOUBLE_INVOICES

Indicator specifying whether duplicate invoice checks are enforced for this vendor.

VARCHAR2

1

CITY

City component of the vendor address.

VARCHAR2

35

COMMUNICATION_TYPE_DESCRIPTION

Description of the preferred communication method associated with the vendor.

VARCHAR2

20

COMPANY_PAYMENT_BLOCK

Indicator specifying whether the vendor is blocked for payment within a specific company context.

VARCHAR2

1

COMPANY_POSTING_BLOCK

Indicator specifying whether the vendor is blocked for posting within a specific company context.

VARCHAR2

1

COUNTRY_CODE

Country code representing the vendor's country of registration or residence.

VARCHAR2

3

COUNTRY_NAME

Country name corresponding to the vendor's country code.

VARCHAR2

15

CREATION_DATE

Date the vendor record was created in the source system.

DATE

CREATOR

Identifier of the user or process that created the vendor record.

VARCHAR2

12

CREDIT_INFO_NUMBER

Credit information reference number associated with the vendor.

VARCHAR2

11

CUSTOMER_NUMBER

Customer number associated with the vendor for cross-system reference.

VARCHAR2

10

DELETE_FLAG

Indicator specifying whether the vendor record is marked for deletion in the source system.

VARCHAR2

1

FAX_NUMBER

Fax number associated with the vendor.

VARCHAR2

31

GL_RECONCILIATION_ACCOUNT

General ledger reconciliation account associated with the vendor for financial postings.

VARCHAR2

10

HOUSE_BANK

House bank identifier used for vendor payment processing.

VARCHAR2

5

INDUSTRY_CODE

Industry classification code assigned to the vendor.

VARCHAR2

4

INDUSTRY_DESCRIPTION

Description of the vendor's industry classification.

VARCHAR2

20

IS_ALT_PAYEE_ALLOWED

Indicator specifying whether alternate payees are permitted for this vendor.

VARCHAR2

1

IS_CREDIT_CARD_ACCEPTED

Indicator specifying whether the vendor accepts credit card payments.

VARCHAR2

1

IS_ONE_TIME_VENDOR

Indicator specifying whether the vendor is designated as a one-time vendor.

VARCHAR2

1

LAST_EXTERNAL_REVIEW_DATE

Date of the most recent external compliance or risk review of the vendor record.

DATE

MASTER_REC_VENDOR_NUMBER

Master vendor record number linking related vendor records.

VARCHAR2

10

MINORITY_NAME

Minority business designation or classification associated with the vendor, if applicable.

VARCHAR2

30

NATURAL_PERSON

Indicator specifying whether the vendor represents an individual (natural person).

VARCHAR2

1

PAYMENT_GROUPING_KEY

Key used to group vendor payments during processing.

VARCHAR2

2

PAYMENT_METHODS

Payment methods authorized for transactions with the vendor.

VARCHAR2

10

PAYMENT_TERMS

Payment terms code defining settlement conditions for vendor invoices.

VARCHAR2

4

PERSONNEL_KEY

Personnel key linking the vendor to an internal individual record when the vendor represents a natural person.

VARCHAR2

8

PHONE_NUMBER_1

Primary phone number associated with the vendor.

VARCHAR2

16

PHONE_NUMBER_2

Secondary phone number associated with the vendor.

VARCHAR2

16

POSTAL_CODE

Postal code used for international vendor addresses when applicable.

VARCHAR2

10

PO_BOX

Post office box associated with the vendor mailing address.

VARCHAR2

10

PREVIOUS_ACCOUNT_NUMBER

Previous account number associated with the vendor record.

VARCHAR2

10

RECIPIENT_TYPE

Code identifying the type of payment recipient (e.g., individual or organization).

VARCHAR2

2

RELEASE_GROUP

Release group classification used in procurement approval workflows.

VARCHAR2

4

SEARCH_TERM_1

Primary search term used to facilitate vendor lookup in the source system.

VARCHAR2

20

SEARCH_TERM_2

Secondary search term used for vendor lookup and indexing.

VARCHAR2

20

STATE

State or province component of the vendor address.

VARCHAR2

3

STREET

Street address associated with the vendor.

VARCHAR2

40

TAX_NUMBER

Consolidated tax identification number associated with the vendor.

VARCHAR2

25

TAX_NUMBER_1

Primary tax identification number associated with the vendor.

VARCHAR2

16

TAX_NUMBER_2

Secondary tax identification number associated with the vendor.

VARCHAR2

16

TELEBOX

Telebox identifier associated with the vendor record.

VARCHAR2

40

TELEX_NUMBER

Telex number associated with the vendor, if applicable.

VARCHAR2

30

VENDOR_ACCOUNT_GROUP_NAME

Account group classification assigned to the vendor in the source system.

VARCHAR2

30

VENDOR_EMAIL

Email address associated with the vendor for communication purposes.

VARCHAR2

241

VENDOR_KEY

Surrogate primary key uniquely identifying the vendor record in the warehouse.

VARCHAR2

11

VENDOR_NAME_1

Primary vendor name line used for identification and payment purposes.

VARCHAR2

50

VENDOR_NAME_2

Secondary vendor name line for additional identifying information.

VARCHAR2

50

VENDOR_NAME_3

Additional vendor name line for extended identification details.

VARCHAR2

50

VENDOR_NAME_4

Additional vendor name line for extended identification details.

VARCHAR2

50

VENDOR_NUMBER

Business vendor number assigned by the source financial system.

VARCHAR2

10

VENDOR_PERMITTED_AS_PAYEE

Indicator or code specifying whether the vendor is permitted to receive payments.

VARCHAR2

10

WAREHOUSE_LOAD_DATE

Date the vendor record was loaded into the data warehouse for auditing and lineage tracking.

DATE

WITHHOLDING_COUNTRY

Country code used for vendor withholding tax reporting.

VARCHAR2

3

WITHHOLDING_EXEMPN_AUTH

Indicator identifying the authority granting the withholding tax exemption.

VARCHAR2

1

WITHHOLDING_EXEMPN_NUMBER

Identifier of the vendor's withholding tax exemption certificate.

VARCHAR2

10

WITHHOLDING_EXEMPN_VALID_UNTIL

Expiration date of the vendor's withholding tax exemption.

DATE

WITHHOLDING_TAX_CODE

Withholding tax code applicable to the vendor.

VARCHAR2

2

ZIP_CODE

ZIP code associated with the vendor address.

VARCHAR2

10