Data Warehouse

VEN_1099

Indicator or descriptive value related to 1099 tax reporting status for the vendor.

VARCHAR2

40

VEN_ADDRESS1

Primary street address line for the vendor.

VARCHAR2

40

VEN_ADDRESS2

Secondary street address line for the vendor.

VARCHAR2

40

VEN_ALTERNATE_FLAG

Indicator flag identifying whether this record represents an alternate vendor entry.

VARCHAR2

1

VEN_BANK_CODE

Bank code associated with the vendor for payment processing purposes.

VARCHAR2

2

VEN_CATEGORY_CODE

Vendor category classification code used for reporting or grouping vendors.

VARCHAR2

3

VEN_CITY

City portion of the vendor mailing address.

VARCHAR2

25

VEN_COMMENT

Free-text comment field containing additional notes or remarks about the vendor.

VARCHAR2

60

VEN_COMMODITY_CODE

Commodity classification code indicating the primary goods or services provided by the vendor.

VARCHAR2

3

VEN_CONTACT_NAME

Primary contact name for the vendor organization.

VARCHAR2

25

VEN_CORP

Indicator flag identifying whether the vendor is a corporate entity.

VARCHAR2

1

VEN_COUNTRY

Country code associated with the vendor address.

VARCHAR2

2

VEN_CURRENCY

Default currency used for transactions with the vendor.

VARCHAR2

15

VEN_CUSTOMER

Indicator or reference identifying whether the vendor is also recorded as a customer.

VARCHAR2

15

VEN_DANDB

Dun and Bradstreet (DandB) number associated with the vendor.

VARCHAR2

9

VEN_DELAY

Code or value indicating payment delay or special processing conditions for the vendor.

VARCHAR2

8

VEN_DELETE

Logical delete flag indicating whether the vendor record is marked as deleted or inactive.

VARCHAR2

1

VEN_FOB_CODE

Freight On Board (FOB) code specifying shipping responsibility terms for the vendor.

VARCHAR2

26

VEN_FREIGHT

Indicator specifying whether freight charges apply to vendor transactions.

VARCHAR2

1

VEN_FREIGHT_AGENCY

Code identifying the freight agency used for vendor shipments.

VARCHAR2

1

VEN_FREIGHT_BY

Identifier for the party responsible for freight charges.

VARCHAR2

13

VEN_FREIGHT_DATE

Effective date associated with freight terms or freight arrangements.

VARCHAR2

10

VEN_FREIGHT_TERM

Freight terms code associated with vendor transactions.

VARCHAR2

7

VEN_HANDICAPPED

Indicator flag identifying whether the vendor qualifies under handicapped-owned business classifications.

VARCHAR2

1

VEN_HOLD

Indicator flag specifying whether the vendor is currently on payment or processing hold.

VARCHAR2

1

VEN_LOG

Indicator flag used for internal logging or audit purposes within the VAPS system.

VARCHAR2

1

VEN_MINORITY

Indicator flag identifying whether the vendor is classified as a minority-owned business.

VARCHAR2

1

VEN_NAME

Name of the vendor or business entity.

VARCHAR2

40

VEN_NODAPO_CODE

Indicator code controlling DAPO (Departmental Accounts Payable Office) processing rules for the vendor.

VARCHAR2

1

VEN_NUM

Primary vendor number serving as the unique identifier for the vendor within the VAPS system.

NUMBER

6

VEN_OFFICE_CODE

Office code associated with the vendor record within the VAPS system.

VARCHAR2

4

VEN_OTHER

Indicator flag for other vendor classification categories not otherwise specified.

VARCHAR2

1

VEN_PARENT

Vendor number of the parent vendor, if applicable, used to represent hierarchical vendor relationships.

NUMBER

6

VEN_PARENT_FLAG

Indicator flag specifying whether this vendor record is designated as a parent vendor.

VARCHAR2

1

VEN_PAY_FREIGHT

Indicator specifying whether freight is payable to the vendor.

VARCHAR2

1

VEN_SEND

Indicator flag controlling whether communications or documents are sent to the vendor.

VARCHAR2

1

VEN_SHIP_VIA

Default shipping method or carrier used for the vendor.

VARCHAR2

20

VEN_SIZE

Vendor size classification code used for reporting or regulatory purposes.

VARCHAR2

1

VEN_STATE

State or province code for the vendor address.

VARCHAR2

2

VEN_TAXCODE

Tax code associated with the vendor for withholding or reporting purposes.

VARCHAR2

1

VEN_TAXID

Vendor tax identification number (e.g., EIN or SSN equivalent for business entities).

VARCHAR2

9

VEN_TELEPHONE1

Primary telephone number for the vendor.

VARCHAR2

24

VEN_TELEPHONE2

Secondary telephone number for the vendor.

VARCHAR2

24

VEN_TELEPHONE3

Additional telephone number for the vendor.

VARCHAR2

24

VEN_TELEX

Telex communication number associated with the vendor (legacy communication method).

VARCHAR2

10

VEN_TERMS_DISC_DAYS

Number of days within which a payment discount applies under vendor terms.

VARCHAR2

10

VEN_TERMS_DISC_PC

Discount percentage applicable if payment is made within the discount period.

NUMBER

11,2

VEN_TERMS_NET_DAYS

Net payment term expressed as number of days until full payment is due.

VARCHAR2

10

VEN_WOMAN

Indicator flag identifying whether the vendor is classified as a woman-owned business.

VARCHAR2

1

VEN_ZIP

Postal or ZIP code for the vendor address.

VARCHAR2

19