TABLE DETAIL REFERENCE: Vendor
(Online VERSION)
| FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
|---|---|---|---|---|---|---|---|---|---|
| ListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| EditSequence | 12 | VARCHAR | 10 | True | False | False | False | %s | |
| Name | 12 | VARCHAR | 100 | True | True | True | True | %s | |
| IsActive | -7 | BIT | 1 | True | True | False | False | 1 0 true false | |
| CompanyName | 12 | VARCHAR | 50 | True | True | True | False | %s | |
| Salutation | 12 | VARCHAR | 15 | True | True | True | False | %s | |
| FirstName | 12 | VARCHAR | 25 | True | True | True | False | %s | |
| MiddleName | 12 | VARCHAR | 25 | True | True | True | False | %s | |
| LastName | 12 | VARCHAR | 25 | True | True | True | False | %s | |
| JobTitle | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| Suffix | 12 | VARCHAR | 10 | True | True | True | False | %s | |
| VendorAddressID | 12 | VARCHAR | 500 | True | True | True | False | %s | |
| VendorAddressAddr1 | 12 | VARCHAR | 500 | True | True | True | False | %s | |
| VendorAddressAddr2 | 12 | VARCHAR | 500 | True | True | True | False | %s | |
| VendorAddressAddr3 | 12 | VARCHAR | 500 | True | True | True | False | %s | |
| VendorAddressAddr4 | 12 | VARCHAR | 500 | True | True | True | False | %s | |
| VendorAddressAddr5 | 12 | VARCHAR | 500 | True | True | True | False | %s | |
| VendorAddressCity | 12 | VARCHAR | 255 | True | True | True | False | %s | |
| VendorAddressState | 12 | VARCHAR | 255 | True | True | True | False | %s | |
| VendorAddressPostalCode | 12 | VARCHAR | 30 | True | True | True | False | %s | |
| VendorAddressCountry | 12 | VARCHAR | 255 | True | True | True | False | %s | |
| Phone | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| Mobile | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| AltPhone | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| Fax | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| 12 | VARCHAR | 100 | True | True | True | False | %s | ||
| WebAddressURI | 12 | VARCHAR | 1000 | True | True | True | False | %s | |
| OtherContactInfoType | 12 | VARCHAR | 1000 | True | True | True | False | %s | |
| OtherContactInfoTelephone | 12 | VARCHAR | 1000 | True | True | True | False | %s | |
| NameOnCheck | 12 | VARCHAR | 110 | True | True | True | False | %s | |
| AccountNumber | 12 | VARCHAR | 99 | True | True | True | False | %s | |
| TermsRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| TermsRefFullName | 12 | VARCHAR | 100 | True | True | True | False | %s | Yes |
| VendorTaxIdent | 12 | VARCHAR | 20 | True | True | True | False | %s | |
| IsVendorEligibleFor1099 | -7 | BIT | 1 | True | False | True | False | 1 0 true false | |
| Balance | 3 | DECIMAL | 13 | True | False | False | False | %11.2f | |
| CurrencyRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| CurrencyRefFullName | 12 | VARCHAR | 64 | True | True | True | False | %s | Yes |
| Cc | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| AdditionalContactRefContactName | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| AdditionalContactRefContactValue | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| ContactsRetListID | 12 | VARCHAR | 36 | True | True | False | False | %s | |
| ContactsRetTimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| ContactsRetTimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| ContactsRetEditSequence | 12 | VARCHAR | 10 | True | True | False | False | %s | |
| ContactsRetName | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| ContactsRetIsActive | -7 | BIT | 1 | True | True | False | False | 1 0 true false | |
| ContactsRetFirstName | 12 | VARCHAR | 25 | True | True | True | False | %s | |
| ContactsRetMiddleName | 12 | VARCHAR | 25 | True | True | True | False | %s | |
| ContactsRetLastName | 12 | VARCHAR | 25 | True | True | True | False | %s | |
| ContactsRetJobTitle | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| ContactsRetAdditionalContactRefContactName | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| ContactsRetAdditionalContactRefContactValue | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| AdditionalNotesNoteID | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| AdditionalNotesDate | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| AdditionalNotesNote | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| BusinessNumber | 12 | VARCHAR | 99 | True | False | True | False | %s | |
| GSTIN | 12 | VARCHAR | 99 | True | False | True | False | %s | |
| GSTRegistrationType | 12 | VARCHAR | 99 | True | False | True | False | %s | |
| Organization | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| UserId | 12 | VARCHAR | 1000 | True | True | True | False | %s | |
| Status | 12 | VARCHAR | 1000 | True | True | True | False | %s | |
| ContactName | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| AltContactName | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| CreditLimit | 3 | DECIMAL | 13 | True | True | True | False | %8.2f | |
| T5018Eligible | -7 | BIT | 1 | True | True | False | False | 1 0 true false | |
| TDSEnabled | -7 | BIT | 1 | True | True | False | False | 1 0 true false | |
| TDSEntityTypeId | 3 | DECIMAL | 15 | True | False | False | False | %11.2f | |
| TDSSectionTypeId | 3 | DECIMAL | 15 | True | False | False | False | %11.2f | |
| TDSOverrideThreshold | -7 | BIT | 1 | True | True | False | False | 1 0 true false | |
| IsSubContractor | -7 | BIT | 1 | True | True | False | False | 1 0 true false | |
| SubcontractorType | 12 | VARCHAR | 1000 | True | True | True | False | %s | |
| CISRate | 12 | VARCHAR | 1000 | True | True | True | False | %s | |
| HasTPAR | -7 | BIT | 1 | True | True | False | False | 1 0 true false | |
| VendorPaymentBankDetailAccountNumber | 12 | VARCHAR | 7 | True | True | True | False | %s | |
| VendorPaymentBankDetailBankAccountName | 12 | VARCHAR | 1000 | True | True | True | False | %s | |
| VendorPaymentBankDetailBankBranchIdentifier | 12 | VARCHAR | 1000 | True | True | True | False | %s | |
| VendorPaymentBankDetailStatementText | 12 | VARCHAR | 1000 | True | True | True | False | %s | |
| CostRate | 3 | DECIMAL | 13 | True | True | True | False | %8.2f | |
| T4AEligible | -7 | BIT | 1 | True | True | False | False | 1 0 true false | |
| Vendor1099 | -7 | BIT | 1 | True | True | False | False | 1 0 true false | |
| Notes | 12 | VARCHAR | 2000 | True | True | True | False | %s | |
| TaxCountry | 12 | VARCHAR | 2000 | True | True | True | False | %s | |
| TaxIdEffectiveDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
| OpenBalance | 3 | DECIMAL | 13 | True | False | True | False | %11.2f | |
| OpenBalanceDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
| VendorTypeRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| VendorTypeRefFullName | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| Source | 12 | VARCHAR | 2000 | True | True | True | False | %s | |
| OtherAddrId | 12 | VARCHAR | 36 | True | True | True | False | %s | |
| OtherAddr1 | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherAddr2 | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherAddr3 | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherAddr4 | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherAddr5 | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherAddrCity | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherAddrState | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherAddrProvince | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherAddrCounty | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherAddrPostalCode | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherAddrLat | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| OtherAddrLong | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| TaxReportingBasis | 12 | VARCHAR | 1000 | True | True | True | False | %s | |
| APAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| APAccountRefFullName | 12 | VARCHAR | 64 | True | True | True | False | %s | Yes |
| UpdateAccountOnTxns | -7 | BIT | 1 | False | True | False | False | 1 0 true false |