Facility

Must be an existing Facility

int(5)

Vendor Number

Create New- must be unique

Update - must match existing vendor number in that facility

int(10)

Abbreviation

Must be unique

char(20)

Name

char(25)

Account Number

char(25)

Contact

char(25)

Address 1

char(25)

Address 2

char(25)

City and State

char(25)

Zip Code

char(12)

Fax Number

char(24)

Phone Number

char(24)

Pay Due Days

int(3)

Terms

char(12)

Discount Days

int(3)

Discount Percent

This should be the ACTUAL percent i.e 20.1 for 20.1%

decimal(2,2)

Ships Via

char(12)

Email

char(60)

F.O.B.

char(10)

Total Ship Days

int(4)

Tax ID Number

char(15)

Tax Rate

This should be the DECIMAL version of the rate, i.e .0875 for 8.75%. 

decimal(0,5)+/-

Legal Status

char(5)

Last Purchase Date

date

YTD Purchases

decimal(10,2)+/-

LTD Purchases

decimal(10,2)+/-

Total POs

int(7)

Disadvantage Flag

Y = True/Checked

N = False/Unchecked

char(1)

Certified Flag

Y = True/Checked

N = False/Unchecked

char(1)

Certified Date

date

Business Type

char(5)

Use Blanket PO Flag

Y = Yes

N = No

char(1) 

PO Budget

decimal(7,2)

Budget Used

decimal(7,3)+/-

Budget Running Balance

decimal(7,3)+/-

Blanket PO Start Date

date

Blanket PO Expire Date

date