VendorContacts Table

Back to list of tables.

Column Data type Data type name Length Can be queried? Can be updated? Can be inserted? Mandatory when inserting? Format Refers To Version introduced in Edition available in
ID 12 VARCHAR 75
ListID 12 VARCHAR 36 True False False False %s 1.0 US, CA, UK
TimeCreated 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 1.0 US, CA, UK
TimeModified 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 1.0 US, CA, UK
EditSequence 12 VARCHAR 16 True False False False %s 1.0 US, CA, UK
Name 12 VARCHAR 41 True True True True %s 1.0 US, CA, UK
IsActive -7 BIT 2 True True True False
1
0
true
false
 1.0 US, CA, UK
ClassRef_ListID 12 VARCHAR 36 True True True False %s ListID 12.0 US, CA, UK
ClassRef_FullName 12 VARCHAR 159 True True True False %s FullName 12.0 US, CA, UK
CompanyName 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
Salutation 12 VARCHAR 15 True True True False %s 1.0 US, CA, UK
FirstName 12 VARCHAR 25 True True True False %s 1.0 US, CA, UK
MiddleName 12 VARCHAR 5 True True True False %s 1.0 US, CA, UK
LastName 12 VARCHAR 25 True True True False %s 1.0 US, CA, UK
JobTitle 12 VARCHAR 41 True True True False %s 12.0 US, CA, UK
VendorAddress_Addr1 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
VendorAddress_Addr2 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
VendorAddress_Addr3 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
VendorAddress_Addr4 12 VARCHAR 41 True True True False %s 2.0 US, CA, UK
VendorAddress_Addr5 12 VARCHAR 41 True True True False %s 6.0 US, CA, UK
VendorAddress_City 12 VARCHAR 31 True True True False %s 1.0 US, CA, UK
VendorAddress_State 12 VARCHAR 21 True True True False %s 1.0 US, CA, UK
VendorAddress_PostalCode 12 VARCHAR 13 True True True False %s 1.0 US, CA, UK
VendorAddress_Country 12 VARCHAR 31 True True True False %s 1.0 US, CA, UK
VendorAddress_Note 12 VARCHAR 41 True True True False %s 6.0 US, CA, UK
VendorAddressBlock_Addr1 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
VendorAddressBlock_Addr2 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
VendorAddressBlock_Addr3 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
VendorAddressBlock_Addr4 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
VendorAddressBlock_Addr5 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
ShipAddress_Addr1 12 VARCHAR 41 True False False False %s 11.0 US, CA, UK
ShipAddress_Addr2 12 VARCHAR 41 True False False False %s 1.0 US, CA, UK
ShipAddress_Addr3 12 VARCHAR 41 True False False False %s 1.0 US, CA, UK
ShipAddress_Addr4 12 VARCHAR 41 True False False False %s 2.0 US, CA, UK
ShipAddress_Addr5 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
ShipAddress_City 12 VARCHAR 31 True False False False %s 1.0 US, CA, UK
ShipAddress_State 12 VARCHAR 21 True False False False %s 1.0 US, CA, UK
ShipAddress_PostalCode 12 VARCHAR 13 True False False False %s 1.0 US, CA, UK
ShipAddress_Country 12 VARCHAR 31 True False False False %s 1.0 US, CA, UK
ShipAddress_Note 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
Phone 12 VARCHAR 21 True True True False %s 1.0 US, CA, UK
AltPhone 12 VARCHAR 21 True True True False %s 1.0 US, CA, UK
Fax 12 VARCHAR 21 True True True False %s 1.0 US, CA, UK
Email 12 VARCHAR 1023 True True True False %s 1.0 US, CA, UK
Cc 12 VARCHAR 1023 True True True False %s 12.0 US, CA, UK
Contact 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
AltContact 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
AdditionalContactRef_ContactName1 12 VARCHAR 40 12.0 US, CA, UK
AdditionalContactRef_ContactValue1 12 VARCHAR 255 12.0 US, CA, UK
AdditionalContactRef_ContactName2 12 VARCHAR 40 12.0 US, CA, UK
AdditionalContactRef_ContactValue2 12 VARCHAR 255 12.0 US, CA, UK
AdditionalContactRef_ContactName3 12 VARCHAR 40 12.0 US, CA, UK
AdditionalContactRef_ContactValue3 12 VARCHAR 255 12.0 US, CA, UK
AdditionalContactRef_ContactName4 12 VARCHAR 40 12.0 US, CA, UK
AdditionalContactRef_ContactValue4 12 VARCHAR 255 12.0 US, CA, UK
AdditionalContactRef_ContactName5 12 VARCHAR 40 12.0 US, CA, UK
AdditionalContactRef_ContactValue5 12 VARCHAR 255 12.0 US, CA, UK
AdditionalContactRef_ContactName6 12 VARCHAR 40 12.0 US, CA, UK
AdditionalContactRef_ContactValue6 12 VARCHAR 255 12.0 US, CA, UK
AdditionalContactRef_ContactName7 12 VARCHAR 40 12.0 US, CA, UK
AdditionalContactRef_ContactValue7 12 VARCHAR 255 12.0 US, CA, UK
AdditionalContactRef_ContactName8 12 VARCHAR 40 12.0 US, CA, UK
AdditionalContactRef_ContactValue8 12 VARCHAR 255 12.0 US, CA, UK
CustomerTypeRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
CustomerTypeRef_FullName 12 VARCHAR 159 True True True False %s FullName 1.0 US, CA, UK
TermsRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
TermsRef_FullName 12 VARCHAR 31 True True True False %s Name 1.0 US, CA, UK
SalesRepRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
SalesRepRef_FullName 12 VARCHAR 5 True True True False %s Initial 1.0 US, CA, UK
OpenBalance 2 NUMERIC 14 True False True False %10.2f 1.0 US, CA, UK
Balance 2 NUMERIC 14 True False False False %10.2f 1.0 US, CA, UK
TotalBalance 2 NUMERIC 14 True False False False %10.2f 1.0 US, CA, UK
OpenBalanceDate 91 DATE 10 True False True False CCCC-MM-DD 1.0 US, CA, UK
SalesTaxCodeRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
SalesTaxCodeRef_FullName 12 VARCHAR 3 True True True False %s Name 1.0 US, CA, UK
ItemSalesTaxRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
ItemSalesTaxRef_FullName 12 VARCHAR 31 True True True False %s Name 1.0 US, CA, UK
ResaleNumber 12 VARCHAR 15 True True True False %s 1.0 US, CA, UK
AccountNumber 12 VARCHAR 99 True True True False %s 1.0 US, CA, UK
CreditLimit 2 NUMERIC 14 True True True False %10.2f 1.0 US, CA, UK
PreferredPaymentMethodRef_ListID 12 VARCHAR 36 True True True False %s ListID 3.0 US, CA, UK
PreferredPaymentMethodRef_FullName 12 VARCHAR 31 True True True False %s Name 3.0 US, CA, UK
CreditCardInfo_CreditCardNumber 12 VARCHAR 25 True True True False %s 3.0 US, CA, UK
CreditCardInfo_ExpirationMonth 4 INTEGER 9 True True True False %13.0f 3.0 US, CA, UK
CreditCardInfo_ExpirationYear 4 INTEGER 9 True True True False %13.0f 3.0 US, CA, UK
CreditCardInfo_NameOnCard 12 VARCHAR 41 True True True False %s 3.0 US, CA, UK
CreditCardInfo_CreditCardAddress 12 VARCHAR 41 True True True False %s 3.0 US, CA, UK
CreditCardInfo_CreditCardPostalCode 12 VARCHAR 41 True True True False %s 3.0 US, CA, UK
JobStatus 12 VARCHAR 10 True True True False
None
Pending
Awarded
InProgress
Closed
NotAwarded
 3.0 US, CA, UK
JobStartDate 91 DATE 10 True True True False CCCC-MM-DD 1.0 US, CA, UK
JobProjectedEndDate 91 DATE 10 True True True False CCCC-MM-DD 1.0 US, CA, UK
JobEndDate 91 DATE 10 True True True False CCCC-MM-DD 1.0 US, CA, UK
JobDesc 12 VARCHAR 99 True True True False %s 1.0 US, CA, UK
JobTypeRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
JobTypeRef_FullName 12 VARCHAR 159 True True True False %s FullName 1.0 US, CA, UK
Notes 12 VARCHAR 4095 True True True False %s 1.0 US, CA, UK
PreferredDeliveryMethod 12 VARCHAR 10 True True True True
None
Email
Fax
 12.0 US, CA, UK
PriceLevelRef_ListID 12 VARCHAR 36 True True True False %s ListID 4.0 US, CA, UK
PriceLevelRef_FullName 12 VARCHAR 31 True True True False %s Name 4.0 US, CA, UK
ExternalGUID 12 VARCHAR 40 True False True False {XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX} 8.0 US, CA, UK
CurrencyRef_ListID 12 VARCHAR 36 True True True False %s ListID 8.0 US, CA, UK
CurrencyRef_FullName 12 VARCHAR 64 True True True False %s Name 8.0 US, CA, UK
Contacts_ListID 12 VARCHAR 36 True True False False %s 1.0 US, CA, UK
Contacts_TimeCreated 11 TIMESTAMP 16 True False False False %s 1.0 US, CA, UK
Contacts_TimeModified 11 TIMESTAMP 16 True False False False %s 1.0 US, CA, UK
Contacts_EditSequence 12 VARCHAR 16 True True False False %s 1.0 US, CA, UK
Contacts_Salutation 12 VARCHAR 15 True True True False %s 1.0 US, CA, UK
Contacts_FirstName 12 VARCHAR 25 True True True False %s 1.0 US, CA, UK
Contacts_MiddleName 12 VARCHAR 5 True True True False %s 1.0 US, CA, UK
Contacts_LastName 12 VARCHAR 25 True True True False %s 1.0 US, CA, UK
Contacts_JobTitle 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
Contacts_AdditionalContactRef_ContactName1 12 VARCHAR 40 True True True False %s 1.0 US, CA, UK
Contacts_AdditionalContactRef_ContactValue1 12 VARCHAR 255 True True True False %s 1.0 US, CA, UK
Contacts_AdditionalContactRef_ContactName2 12 VARCHAR 40 True True True False %s 1.0 US, CA, UK
Contacts_AdditionalContactRef_ContactValue2 12 VARCHAR 255 True True True False %s 1.0 US, CA, UK
Contacts_AdditionalContactRef_ContactName3 12 VARCHAR 40 True True True False %s 1.0 US, CA, UK
Contacts_AdditionalContactRef_ContactValue3 12 VARCHAR 255 True True True False %s 1.0 US, CA, UK
Contacts_AdditionalContactRef_ContactName4 12 VARCHAR 40 True True True False %s 1.0 US, CA, UK
Contacts_AdditionalContactRef_ContactValue4 12 VARCHAR 255 True True True False %s 1.0 US, CA, UK
Contacts_AdditionalContactRef_ContactName5 12 VARCHAR 40 True True True False %s 1.0 US, CA, UK
Contacts_AdditionalContactRef_ContactValue5 12 VARCHAR 255 True True True False %s 1.0 US, CA, UK
NameOnCheck 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
AccountNumber 12 VARCHAR 99 True True True False %s 1.0 US, CA, UK
Notes 12 VARCHAR 4095 True True True False %s 1.0 US, CA, UK
VendorTypeRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
VendorTypeRef_FullName 12 VARCHAR 159 True True True False %s FullName 1.0 US, CA, UK
TermsRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
TermsRef_FullName 12 VARCHAR 31 True True True False %s Name 1.0 US, CA, UK
CreditLimit 2 NUMERIC 15 True True True False %10.2f 1.0 US, CA, UK
VendorTaxIdent 12 VARCHAR 15 True True True False %s 1.0 US, CA, UK
IsVendorEligibleFor1099 -7 BIT 2 True True True False
1
0
true
false
 1.0 US, CA, UK
OpenBalance 2 NUMERIC 15 True False True False %10.2f 1.0 US, CA, UK
OpenBalanceDate 91 DATE 10 True False True False CCCC-MM-DD 1.0 US, CA, UK
Balance 2 NUMERIC 15 True False False False %10.2f 1.0 US, CA, UK
BillingRateRef_ListID 12 VARCHAR 36 True True True False %s ListID 6.0 US, CA, UK
BillingRateRef_FullName 12 VARCHAR 31 True True True False %s FullName 6.0 US, CA, UK
ExternalGUID 12 VARCHAR 40 True False True False {XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX} 8.0 US, CA, UK
PrefillAccount_ListID1 12 VARCHAR 36 True True True False %s ListID 8.0 US, CA, UK
PrefillAccount_FullName1 12 VARCHAR 159 True True True False %s FullName 8.0 US, CA, UK
PrefillAccount_ListID2 12 VARCHAR 36 True True True False %s ListID 8.0 US, CA, UK
PrefillAccount_FullName2 12 VARCHAR 159 True True True False %s FullName 8.0 US, CA, UK
PrefillAccount_ListID3 12 VARCHAR 36 True True True False %s ListID 8.0 US, CA, UK
PrefillAccount_FullName3 12 VARCHAR 159 True True True False %s FullName 8.0 US, CA, UK
CurrencyRef_ListID 12 VARCHAR 36 True True True False %s ListID 8.0 US, CA, UK
CurrencyRef_FullName 12 VARCHAR 64 True True True False %s Name 8.0 US, CA, UK
CFDDiscountAvailable 12 VARCHAR 30 True True True False %s 1.0 US, CA, UK

Back to list of tables.