vendor
The vendor table.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | Internal ID | |
| accountnumber | String | Account Number | |
| altemail | String | Alt. Email | |
| altname | String | Vendor | |
| balance | Decimal | Balance (Base) | |
| balanceprimary | Decimal | Balance | |
| billpay | Boolean | Enable Online Bill Pay | |
| category | String | Category | |
| comments | String | Comments | |
| companyname | String | Company Name | |
| contact | String | Primary Contact | |
| contactlist | String | Contacts | |
| creditlimit | Decimal | Credit Limit | |
| currency | String | Currency | |
| datecreated | Date | Date Created | |
| defaultbankaccount | String | Default Bank Account | |
| defaultbillingaddress | String | Default Billing Address | |
| defaultshippingaddress | String | Default Shipping Address | |
| duplicate | Boolean | Duplicate | |
| String | Vendor Email | ||
| emailpreference | String | Email Preference | |
| emailtransactions | Boolean | Email Transactions | |
| entityid | String | Entity ID | |
| entitynumber | Integer | Number | |
| entitytitle | String | Vendor ID | |
| expenseaccount | String | Default Expense Account | |
| externalid | String | External ID | |
| faxtransactions | Boolean | Fax Transactions | |
| firstname | String | First Name | |
| giveaccess | Boolean | Login Access | |
| globalsubscriptionstatus | String | Global Subscription Status | |
| incoterm | String | Incoterm | |
| isinactive | Boolean | Vendor is Inactive | |
| isjobresourcevend | Boolean | Job Resource | |
| isperson | Boolean | Is Individual | |
| laborcost | Decimal | Labor Cost | |
| lastmodifieddate | Date | Last Modified Date | |
| lastname | String | Last Name | |
| legalname | String | Legal Name | |
| middlename | String | Middle Name | |
| payablesaccount | String | -No label- | |
| phoneticname | String | Furigana | |
| predconfidence | Double | Predicted Risk Confidence | |
| predicteddays | Integer | Predicted Days Late/Early | |
| printoncheckas | String | Print on Check As | |
| printtransactions | Boolean | Print Transactions | |
| purchaseorderamount | Double | Vendor Bill - Purchase Order Amount Tolerance | |
| purchaseorderquantity | Double | Vendor Bill - Purchase Order Quantity Tolerance | |
| purchaseorderquantitydiff | Double | Vendor Bill - Purchase Order Quantity Difference | |
| receiptamount | Double | Vendor Bill - Item Receipt Amount Tolerance | |
| receiptquantity | Double | Vendor Bill - Item Receipt Quantity Tolerance | |
| receiptquantitydiff | Double | Vendor Bill - Item Receipt Quantity Difference | |
| rolesforsearch | String | Roles | |
| salutation | String | Mr./Ms... | |
| subsidiaryedition | String | Edition | |
| terms | String | Terms | |
| timeapprover | String | Time Approver | |
| title | String | Job Title | |
| unbilledorders | Decimal | Unbilled Orders (Base) | |
| unbilledordersprimary | Decimal | Unbilled Orders |