VENDORID | char(15) | Yes | Vendor ID | IN |
VENDNAME | char(64) | Yes | Vendor Name: Required for new record | IN |
VENDSHNM | char(15) | No | Vendor Short Name | IN |
VNDCHKNM | char(64) | No | Vendor Check Name | IN |
HOLD | tinyint | No | Hold; 0=Not on Hold; 1=Hold; Default=0 on new record | IN |
VENDSTTS | smallint | No | Status: 1=Active; 2=Inactive; 3=Temporary; Default=1 on new record | IN |
VNDCLSID | char(10) | No | Class ID | IN |
VADDCDPR | char(15) | No | Primary Address ID | IN |
VNDCNTCT | char(60) | No | Contact | IN |
ADDRESS1 | char(60) | No | Address1 | IN |
ADDRESS2 | char(60) | No | Address2 | IN |
ADDRESS3 | char(60) | No | Address3 | IN |
CITY | char(35) | No | City | IN |
STATE | char(29) | No | State | IN |
ZIPCODE | char(10) | No | Zip Code | IN |
CCode | char(6) | No | Country Code | IN |
COUNTRY | char(60) | No | Country | IN |
PHNUMBR1 | char(21) | No | Phone1 | IN |
PHNUMBR2 | char(21) | No | Phone2 | IN |
PHNUMBR3 | char(21) | No | phone3 | IN |
FAXNUMBR | char(21) | No | Fax Number | IN |
TAXSCHID | char(15) | No | Tax Schedule | IN |
SHIPMTHD | char(15) | No | Shipping Method | IN |
UPSZONE | char(3) | No | UPS Zone | IN |
VADCDPAD | char(15) | No | Purchase Address ID | IN |
VADCDTRO | char(15) | No | Remit To Address ID | IN |
VADCDSFR | char(15) | No | Ship From Address ID | IN |
ACNMVNDR | char(20) | No | Vendor Account | IN |
COMMENT1 | char(30) | No | Comment1 | IN |
COMMENT2 | char(30) | No | Comment2 | IN |
NOTETEXT | varchar(8000) | No | Note Text | IN |
CURNCYID | char(15) | No | Currency ID | IN |
RATETPID | char(15) | No | Rate Type ID | IN |
PYMTRMID | char(20) | No | Payment terms ID | IN |
DISGRPER | smallint | No | Discount Grace Period: Max value=99 | IN |
DUEGRPER | smallint | No | Due Date Grace Period: Max value=99 | IN |
PYMNTPRI | char(3) | No | Payment Priority | IN |
MINORDER | numeric(19,5) | No | Minimum Order | IN |
TRDDISCT | numeric(19,5) | No | Trade Discount | IN |
TXIDNMBR | char(11) | No | Tax ID | IN |
TXRGNNUM | char(25) | No | Tax Registration | IN |
CHEKBKID | char(15) | No | Checkbook ID | IN |
USERDEF1 | char(20) | No | User-Defined 1 | IN |
USERDEF2 | char(20) | No | User-Defined 2 | IN |
TEN99TYPE | smallint | No | Tax Type: 1=Not a 1099 Vendor; 2=Dividend; 3=Interest; 4=Misc.; Default=1 on new vendor | IN |
TEN99BOXNUMBER | smallint | No | Ten 99 Box Number | IN |
FREEONBOARD | smallint | No | FOB: 1=None; 2=Origin; 3=Destination; Default=1 on new vendor | IN |
USERLANG | smallint | No | User Language; Default=0 on new record | IN |
MINPYTYP | smallint | No | Minimum Payment Type: 0=No Minimum; 1=Percent; 2=Amount; Default=0 on new record | IN |
MINPYDLR | numeric(19,5) | No | Minimum Payment Dollar Amount: Used if @I_vMINPYTYP=2 | IN |
MINPYPCT | numeric(19,5) | No | Minimum Payment Percent: Used if @I_vMINPYTYP=1 | IN |
MXIAFVND | smallint | No | Maximum Invoice Amount Type: 0=No Maximum; 1=Amount; Default=0 on new record | IN |
MAXINDLR | numeric(19,5) | No | Maximum Invoice Dollar Amount: Used if @I_vMXIAFVND=1 | IN |
CREDTLMT | smallint | No | Credit Limit Type: 0=No Credit; 1=Unlimited; 2=Amount; Default=1 on new record | IN |
CRLMTDLR | numeric(19,5) | No | Credit Limit Dollar Amount: Used if @I_vCREDTLMT=2 | IN |
WRITEOFF | smallint | No | Writeoff Type: 0=Not Allowed; 1=Unlimited; 2=Maximum | IN |
MXWOFAMT | numeric(19,5) | No | Maximum Writeoff Amount: Used if @I_vWRITEOFF=2 | IN |
Revalue_Vendor | tinyint | No | Revalue Vendor: 0=Do Not Revalue; 1=Revalue; Default=1 on new record | IN |
Post_Results_To | smallint | No | Post Results To: 0=Payables/Discount Acct; 1=Purchasing Offset Acct; Default=0 on new record | IN |
KPCALHST | tinyint | No | Maintain History - Calendar Year: 0=Do Not Maintain; 1=Maintain; Default=1 on new record | IN |
KPERHIST | tinyint | No | Maintain History - Fiscal Year: 0=Do Not Maintain; 1=Maintain; Default=1 on new record | IN |
KPTRXHST | tinyint | No | Maintain History - Transaction: 0=Do Not Maintain; 1=Maintain; Default=1 on new record | IN |
KGLDSTHS | tinyint | No | Maintain History - Distribution: 0=Do Not Maintain; 1=Maintain; Default=1 on new record | IN |
PTCSHACF | smallint | No | Use Cash Account From: 0=Checkbook; 1=Vendor; Default=0 on new record | IN |
PMCSHACTNUMST | varchar(75) | No | Cash Account: Only valid if @I_vPTCSHACF=1 | IN |
PMAPACTNUMST | varchar(75) | No | Account Payable Account | IN |
PMDAVACTNUMST | varchar(75) | No | Terms Discount Available Account | IN |
PMDTKACTNUMST | varchar(75) | No | Terms Discount Taken Account | IN |
PMFINACTNUMST | varchar(75) | No | Finance Charges Account | IN |
PMPRCHACTNUMST | varchar(75) | No | Purchases Account | IN |
PMTDSCACTNUMST | varchar(75) | No | Trade Discount Account | IN |
PMMSCHACTNUMST | varchar(75) | No | Miscellaneous Account | IN |
PMFRTACTNUMST | varchar(75) | No | Freight Account | IN |
PMTAXACTNUMST | varchar(75) | No | Tax Account | IN |
PMWRTACTNUMST | varchar(75) | No | Writeoffs Account | IN |
ACPURACTNUMST | varchar(75) | No | Accrued Purchases Account | IN |
PURPVACTNUMST | varchar(75) | No | Purchase Price Variance Account | IN |
UseVendorClass | tinyint | No | Flag to have class setting roll down to parameters that are not passed in. Uses the @I_vVNDCLSID class | IN |
CreateAddress | tinyint | No | Flag to allow an address code to be created on the fly | IN |
UpdateIfExists | tinyint | No | Flag to allow updates: 0=Create only; 1=Update if exists; 2=Create, do NOT update(no error) | IN |
RequesterTrx | smallint | No | Requester Transaction: 0=False; 1=True - if true than populates Requester shadow table | IN |
USRDEFND1 | char(50) | No | User Defined field - developer use only | IN |
USRDEFND2 | char(50) | No | User Defined field - developer use only | IN |
USRDEFND3 | char(50) | No | User Defined field - developer use only | IN |
USRDEFND4 | varchar(8000) | No | User Defined field - developer use only | IN |
USRDEFND5 | varchar(8000) | No | User Defined field - developer use only | IN |
ErrorState | int | No | Create Custom Business Logic | INOUT |
oErrString | varchar(255) | No | Create Custom Business Logic | INOUT |