VENDORID

string

15

Y

Not applicable

Vendor ID

VENDNAME

string

64

N

Default from setup

Vendor name

VENDSHNM

string

15

N

Default from setup

Vendor short name

VNDCHKNM

string

64

N

Default from setup

Vendor check name

HOLD

i4

1

N

Default from setup

Hold:

0=Not on hold;

1=Hold

Default is zero on new record

VENDSTTS

i4

2

N

Default from setup

Vendor status:

1=Active;

2=Inactive;

3=Temporary

Default is 1 on new record

VNDCLSID

string

10

N

Default from setup

Vendor class ID

VADDCDPR

string

15

N

Default from setup

Primary vendor address ID

VNDCNTCT

string

60

N

Default from setup

Vendor contact

ADDRESS1

string

60

N

Default from setup

Address 1

ADDRESS2

string

60

N

Default from setup

Address 2

ADDRESS3

string

60

N

Default from setup

Address 3

CITY

string

35

N

Default from setup

City

STATE

string

29

N

Default from setup

State

ZIPCODE

string

10

N

Default from setup

Zip Code

CCode

string

6

N

Default from setup

Country code

COUNTRY

string

60

N

Default from setup

Country

PHNUMBR1

string

21

N

Default from setup

Phone 1

PHNUMBR2

string

21

N

Default from setup

Phone 2

PHNUMBR3

string

21

N

Default from setup

Phone 3

FAXNUMBR

string

21

N

Default from setup

Fax number

TAXSCHID

string

15

N

Default from setup

Tax schedule ID

SHIPMTHD

string

15

N

Default from setup

Shipping method

UPSZONE

string

3

N

Default from setup

UPS zone

VADCDPAD

string

15

N

Default from setup

Vendor purchase address ID

VADCDTRO

string

15

N

Default from setup

Vendor remit to address ID

VADCDSFR

string

15

N

Default from setup

Vendor ship from address ID

ACNMVNDR

string

20

N

Default from setup

Vendor account number

COMMENT1

string

30

N

Default from setup

Comment 1

COMMENT2

string

30

N

Default from setup

Comment 2

NOTETEXT

string

8000

N

Default from setup

Note text

CURNCYID

string

15

N

Default from setup

Currency ID

RATETPID

string

15

N

Default from setup

Rate type ID

PYMTRMID

string

20

N

Default from setup

Payment terms ID

DISGRPER

i4

2

N

Default from setup

Discount grace period; max value is 99

DUEGRPER

i4

2

N

Default from setup

Due date grace period; max value is 99

PYMNTPRI

string

3

N

Default from setup

Payment priority

MINORDER

number

21

N

Default from setup

Minimum order

TRDDISCT

number

21

N

Default from setup

Trade discount

TXIDNMBR

string

11

N

Default from setup

Tax ID number

TXRGNNUM

string

25

N

Default from setup

Tax registration number

CHEKBKID

string

15

N

Default from setup

Checkbook ID

USERDEF1

string

20

N

Default from setup

User-defined 1

USERDEF2

string

20

N

Default from setup

User-defined 2

TEN99TYPE

i4

2

N

Default from setup

Tax 1099 type:

1=Not a 1099 vendor;

2=Dividend;

3=Interest;

4=Miscellaneous

TEN99BOXNUMBER

i4

2

N

Default from setup

Tax 1099 box number

FREEONBOARD

i4

2

N

Default from setup

Free on board:

1=None;

2=Origin;

3=Destination

Default is 1 on new order

USERLANG

i4

2

N

Default from setup

User language; default is 0 on new record

MINPYTYP

i4

2

N

Default from setup

Minimum payment type: 0=No minimum;

1=Percent;

2=Amount

Default is zero on new record

MINPYDLR

number

21

N

Default from setup

Minimum payment dollar amount; used if MINPYTYP=2

MINPYPCT

number

21

N

Default from setup

Minimum payment percent; used if MINPYTYP=1

MXIAFVND

i4

2

N

Default from setup

Maximum invoice amount type:

0=No maximum;

1=Amount

Default is zero on new record

MAXINDLR

number

21

N

Default from setup

Maximum invoice dollar amount; used if MXIAFVND=1

CREDTLMT

i4

2

N

Default from setup

Credit limit type:

0=No credit;

1=Unlimited;

2=Amount

Default is zero on new record

CRLMTDLR

number

21

N

Default from setup

Credit limit dollar amount; used if CREDTLMT=2

WRITEOFF

i4

2

N

Default from setup

Write-off type:

0=Not allowed;

1=Unlimited;

2=Maximum

MXWOFAMT

number

21

N

Default from setup

Maximum write-off amount; used if WRITEOFF=2

Revalue_Vendor

i4

1

N

Default from setup

Revalue vendor:

0=Do not revalue;

1=Revalue

Default is 1 on new record

Post_Results_To

i4

2

N

Default from setup

Post results to:

0=Payable/Discount account;

1=Purchasing offset account

Default is 1 on new record

KPCALHST

i4

1

N

Default from setup

Maintain history—calendar year:

0=Do not maintain;

1=Maintain

Default is 1 on new record

KPERHIST

i4

1

N

Default from setup

Maintain history—fiscal year:

0=Do not maintain;

1=Maintain

Default is 1 on new record

KPTRXHST

i4

1

N

Default from setup

Maintain history—transaction:

0=Do not maintain;

1=Maintain

Default is 1 on new record

KGLDSTHS

i4

1

N

Default from setup

Maintain history—distribution:

0=Do not maintain;

1=Maintain

Default is 1 on new record

PTCSHACF

i4

2

N

Default from setup

Use cash account from:

0=Checkbook;

1=Vendor

Default is zero on new record

PMCSHACTNUMST

string

75

N

Default from setup

Cash account; only valid if PTCSHACF=1

PMAPACTNUMST

string

75

N

Default from setup

Accounts payable account

PMDAVACTNUMST

string

75

N

Default from setup

Terms discount available account

PMDTKACTNUMST

String

75

N

Default from setup

Terms discount taken account

PMFINACTNUMST

string

75

N

Default from setup

Finance charges account

PMPRCHACTNUMST

string

75

N

Default from setup

Purchases account

PMTDSCACTNUMST

string

75

N

Default from setup

Trade discount account

PMMSCHACTNUMST

string

75

N

Default from setup

Miscellaneous account

PMFRTACTNUMST

string

75

N

Default from setup

Freight account

PMTAXACTNUMST

string

75

N

Default from setup

Tax account

PMWRTACTNUMST

string

75

N

Default from setup

Write-off account

ACPURACTNUMST

string

75

N

Default from setup

Accrued purchases account

PURPVACTNUMST

string

75

N

Default from setup

Purchase price variance account

UseVendorClass

i4

1

N

0

Flag to have class setting roll down to elements that not passed in; uses the VNDCLSID class

CreateAddress

i4

1

N

1

Flag to allow a primary address code to be created on the fly:

0=Do not create address code;

1=Create address code

UpdateIfExists

i4

1

N

1

Flag to allow vendor data to be updated if it exists:

0=Do not update;

1=Update if exists;

2=Create if record does not exist and exits without error if record does exist

RequesterTrx

i4

2

N

0

Requester transaction:

0=False;

1=True (if True, it populates the requester shadow table)

USRDEFND1

string

50

N

<blank>

User-defined field—developer use only

USRDEFND2

string

50

N

<blank>

User-defined field—developer use only

USRDEFND3

string

50

N

<blank>

User-defined field—developer use only

USRDEFND4

string

8000

N

<blank>

User-defined field—developer use only

USRDEFND5

string

8000

N

<blank>

User-defined field—developer use only