Vendor
Stores vendor records, including contact details, transaction history, and payment terms in NetSuite.
Columns
| Name | Type | ReadOnly | Description |
| InternalId [KEY] | String | True |
The InternalId of the vendor, a unique identifier used to distinguish this particular vendor within the system. |
| AccountNumber | String | False |
The account number associated with the vendor, often used for financial transactions or in communication with the vendor's financial department. |
| AddressbookList_ReplaceAll | Boolean | False |
Indicates whether the vendor’s address book list should be replaced entirely. If true, all existing addresses will be removed and replaced with new ones. |
| AltEmail | String | False |
An alternative email address for the vendor, used for additional communication channels, often in cases where the primary email is unavailable. |
| AltName | String | False |
An alternate name or identifier for the vendor, used for reference in cases where the vendor can be known by a different name in certain contexts. |
| AltPhone | String | False |
An alternate phone number for the vendor, used as a backup contact number for reaching the vendor in case the primary phone number is unavailable. |
| Balance | Double | False |
The total outstanding balance owed to the vendor for goods or services provided. This value can fluctuate depending on payments or credit terms. |
| BalancePrimary | Double | False |
The balance of the vendor in the primary currency. This is the balance owed to the vendor, taking into account the primary accounting currency. |
| Bcn | String | False |
A business code number (BCN) for the vendor, which can be used to uniquely identify the vendor in certain industries or systems. |
| BillPay | Boolean | False |
Indicates whether the vendor is eligible for bill payment. If true, it means the vendor can receive payments through the company's bill payment process. |
| Category_ExternalId | String | False |
The external identifier for the category to which the vendor belongs, used for system integrations and to categorize vendors for reporting or processing purposes. |
| Category_InternalId | String | False |
The internal identifier for the category of the vendor, used to classify the vendor for internal system processes or reporting. |
| Category_Name | String | False |
The name of the category to which the vendor belongs, helping to group vendors by type or service (for example, 'Suppliers', 'Service Providers'). |
| Category_Type | String | False |
The type of category under which the vendor is classified, such as product type, service type, or geographic region. The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |
| Comments | String | False |
Free-text field for adding additional notes or comments about the vendor. This could include special instructions, contract details, or reminders. |
| CompanyName | String | False |
The official company name of the vendor, which is typically used in formal transactions, contracts, and billing documentation. |
| CreditLimit | Double | False |
The maximum credit limit assigned to the vendor, representing the total amount of credit that can be extended to the vendor before payment is required. |
| Currency_ExternalId | String | False |
The external identifier of the currency used for transactions with the vendor, allowing integrations with external systems or financial platforms. |
| Currency_InternalId | String | False |
The internal identifier of the currency for the vendor, used within the company’s system to manage transactions and payments in the vendor's currency. |
| Currency_Name | String | False |
The name of the currency used for transactions with the vendor (for example, USD for US Dollars, EUR for Euros). |
| Currency_Type | String | False |
The type of currency (for example, local currency, base currency) used in transactions with the vendor. The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |
| CurrencyList_ReplaceAll | Boolean | False |
Indicates whether the list of currencies associated with the vendor should be replaced entirely. If true, any existing currency settings will be replaced. |
| CustomForm_ExternalId | String | False |
The external identifier for the custom form associated with the vendor, often used in customized workflows or reports. |
| CustomForm_InternalId | String | False |
The internal identifier for the custom form assigned to the vendor, which can include specific fields or formats required by the business. |
| CustomForm_Name | String | False |
The name of the custom form linked to the vendor, used to assign specific workflows or processes unique to the vendor’s needs. |
| CustomForm_Type | String | False |
The type of custom form used for the vendor, indicating how the form is structured and its intended use within the system. The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |
| DateCreated | Datetime | False |
The date when the vendor record was first created in the system, which is typically used for tracking vendor history and data updates. |
| DefaultAddress | String | False |
The default address for the vendor, typically used for shipping or billing purposes unless another address is specified. |
| EligibleForCommission | Boolean | False |
Indicates whether the vendor is eligible to receive commission payments based on sales or other commissionable activities. |
| String | False |
The primary email address for the vendor, used for communication such as orders, invoices, or customer service inquiries. | |
| EmailPreference | String | False |
The vendor’s preferred method for receiving email communications, such as HTML format, plain text, or opt-out options. The allowed values are _default, _hTML, _pDF. |
| EmailTransactions | Boolean | False |
Indicates whether email notifications related to transactions (like invoices or payment confirmations) should be sent to the vendor. |
| EntityId | String | False |
The unique identifier for the vendor entity within the system, typically used to distinguish this vendor from others in reporting or analysis. |
| ExpenseAccount_ExternalId | String | False |
The external identifier for the expense account associated with the vendor, often used for financial reporting and tracking vendor-related expenses. |
| ExpenseAccount_InternalId | String | False |
The internal identifier for the expense account linked to the vendor, used for categorizing transactions and payments in the general ledger. |
| ExpenseAccount_Name | String | False |
The name of the expense account tied to the vendor, used to track payments, expenses, and other financial dealings with the vendor. |
| ExpenseAccount_Type | String | False |
The type of the expense account associated with the vendor, such as a 'Cost of Goods Sold' or 'Operating Expense' account. The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |
| ExternalId | String | False |
The external identifier for the vendor, often used in integrations with external systems to link vendor data across platforms. |
| Fax | String | False |
The fax number of the vendor, used for official communications or document transmission in some business environments. |
| FaxTransactions | Boolean | False |
Indicates whether the vendor should receive faxed copies of transaction-related documents, such as invoices or purchase orders. |
| FirstName | String | False |
The first name of the primary contact person for the vendor, used in personal communications or when identifying a specific contact for the vendor. |
| GiveAccess | Boolean | False |
Indicates whether the vendor is allowed access to certain internal systems or portals, such as for order tracking or invoicing purposes. |
| GlobalSubscriptionStatus | String | False |
The global subscription status of the vendor, which can indicate whether the vendor has any active subscription or service agreement with the company. The allowed values are _confirmedOptIn, _confirmedOptOut, _softOptIn, _softOptOut. |
| HomePhone | String | False |
The personal or home phone number of the vendor’s primary contact person, which can be used for informal or emergency communications. |
| Image_ExternalId | String | False |
The external identifier for any image associated with the vendor, such as a logo or profile picture, for use in reporting or marketing. |
| Image_InternalId | String | False |
The internal identifier for the image linked to the vendor within the company’s system, often used for digital or print media purposes. |
| Image_Name | String | False |
The name of the image associated with the vendor, such as the vendor's logo or branding image. |
| Image_Type | String | False |
The type of image file associated with the vendor, which could include formats such as JPEG, PNG, or GIF. The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |
| Is1099Eligible | Boolean | False |
Indicates whether the vendor is eligible to receive a 1099 form, typically used in the U.S. to report certain types of payments for tax purposes. |
| IsAccountant | Boolean | False |
Indicates whether the vendor is classified as an accountant, typically for vendors offering accounting or tax services. |
| IsInactive | Boolean | False |
Indicates whether the vendor is inactive, meaning the vendor is no longer engaged for business or is temporarily on hold. |
| IsJobResourceVend | Boolean | False |
Indicates whether the vendor is considered a resource for a job or project, meaning the vendor provides goods or services specific to a project or job. |
| IsPerson | Boolean | False |
Indicates whether the vendor is an individual person (as opposed to a business entity), which can impact the vendor’s tax status or reporting requirements. |
| LaborCost | Double | False |
The labor cost associated with the vendor, typically used in situations where the vendor provides services that require billing based on time or labor. |
| LastModifiedDate | Datetime | False |
The date and time when the vendor's record was last updated, often used to track changes made to vendor details. |
| LastName | String | False |
The last name of the primary contact person for the vendor, useful for personal identification and formal communications. |
| LegalName | String | False |
The official legal name of the vendor or business entity, used for contracts, legal documents, and formal communications. |
| MiddleName | String | False |
The middle name of the vendor's primary contact, typically used in full legal names for identification purposes. |
| MobilePhone | String | False |
The mobile phone number of the vendor’s primary contact person, used for informal or immediate communications. |
| OpeningBalance | Double | False |
The initial balance or outstanding amount that the vendor owed or was owed when their account was first created or transitioned into the system. |
| OpeningBalanceAccount_ExternalId | String | False |
The external identifier for the account where the opening balance of the vendor is tracked, typically used in accounting systems for integration. |
| OpeningBalanceAccount_InternalId | String | False |
The internal identifier for the account used to track the vendor’s opening balance, helping to reconcile the vendor’s initial amounts in the system. |
| OpeningBalanceAccount_Name | String | False |
The name of the account where the vendor’s opening balance is stored, such as an accounts payable or receivable account. |
| OpeningBalanceAccount_Type | String | False |
The type of account used for the vendor’s opening balance, such as a liability or asset account, impacting the accounting treatment of the balance. The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |
| OpeningBalanceDate | Datetime | False |
The date when the opening balance for the vendor was recorded, marking the point at which the account balance was established. |
| Password | String | False |
The vendor’s password used to access any vendor-specific portals or systems, such as an online ordering platform or support system. |
| Password2 | String | False |
A second password field used for verifying the vendor’s identity or for multi-factor authentication, enhancing security for account access. |
| PayablesAccount_ExternalId | String | False |
The external identifier for the account linked to the vendor for managing payables, used for financial reporting and integrations. |
| PayablesAccount_InternalId | String | False |
The internal identifier for the payables account associated with the vendor, used for accounting and managing vendor-related financial transactions. |
| PayablesAccount_Name | String | False |
The name of the account used for processing payments to the vendor, typically categorized under accounts payable. |
| PayablesAccount_Type | String | False |
The type of payables account linked to the vendor, such as a current liability account used for short-term payments. The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |
| Phone | String | False |
The primary phone number of the vendor’s contact, used for direct communication regarding orders, inquiries, or account issues. |
| PhoneticName | String | False |
The phonetic pronunciation of the vendor’s name, typically used in systems that require verbal identification or to avoid mispronunciation during calls. |
| PricingScheduleList_ReplaceAll | Boolean | False |
Indicates whether the vendor’s pricing schedule list should be replaced with a new set of pricing rules, often used when vendor pricing changes. |
| PrintOnCheckAs | String | False |
The name that should appear on printed checks for payments to the vendor, often used for legal or accounting purposes. |
| PrintTransactions | Boolean | False |
Indicates whether transaction details should be printed for the vendor, such as invoices, purchase orders, or payment receipts. |
| RepresentingSubsidiary_ExternalId | String | False |
The external identifier of the subsidiary that the vendor represents, typically used in multi-subsidiary organizations or international operations. |
| RepresentingSubsidiary_InternalId | String | False |
The internal identifier for the subsidiary that the vendor is associated with, often used for financial consolidation or reporting purposes. |
| RepresentingSubsidiary_Name | String | False |
The name of the subsidiary that the vendor represents, used for reporting and distinguishing between different company branches or units. |
| RepresentingSubsidiary_Type | String | False |
The type of subsidiary the vendor is linked to, such as a regional office, division, or subsidiary, affecting financial or operational decisions. The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |
| RequirePwdChange | Boolean | False |
Indicates whether the vendor is required to change their password periodically, often as part of security policy to maintain account protection. |
| RolesList_ReplaceAll | Boolean | False |
Indicates whether the roles list for the vendor should be replaced, typically used in systems with access control based on roles or permissions. |
| Salutation | String | False |
The salutation used for formal communications with the vendor, such as 'Mr.', 'Ms.', or 'Dr.', helping to personalize emails or letters. |
| SendEmail | Boolean | False |
Indicates whether the vendor should receive email notifications, typically used for sending order confirmations, invoices, or other updates. |
| SubscriptionsList_ReplaceAll | Boolean | False |
Indicates whether the list of subscriptions related to the vendor should be replaced, often used in recurring billing or subscription-based services. |
| Subsidiary_ExternalId | String | False |
The external identifier for the subsidiary associated with the vendor, used in organizations with multiple subsidiaries to track where the vendor is associated. |
| Subsidiary_InternalId | String | False |
The internal identifier for the subsidiary the vendor belongs to, used for internal financial reporting and ensuring accurate transactions within the subsidiary. |
| Subsidiary_Name | String | False |
The name of the subsidiary that the vendor is linked to, which helps in distinguishing the different units or branches within a company. |
| Subsidiary_Type | String | False |
The type of subsidiary the vendor is linked to, such as a branch, division, or subsidiary, which impacts financial reporting and organizational structure. The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |
| TaxIdNum | String | False |
The tax identification number for the vendor, essential for tax reporting and ensuring compliance with local tax regulations, particularly for businesses in specific regions. |
| TaxItem_ExternalId | String | False |
The external identifier for the tax item associated with the vendor, used in systems that manage sales tax or other tax-related transactions. |
| TaxItem_InternalId | String | False |
The internal identifier for the tax item linked to the vendor, helping in managing the appropriate tax treatment for transactions with that vendor. |
| TaxItem_Name | String | False |
The name of the tax item related to the vendor, such as a specific tax rate or category, used for tax reporting and calculation. |
| TaxItem_Type | String | False |
The type of tax item associated with the vendor, such as sales tax, VAT, or service tax, used to determine how tax is applied in transactions. The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |
| Terms_ExternalId | String | False |
The external identifier for the payment terms assigned to the vendor, used for integration with external systems and for managing vendor agreements. |
| Terms_InternalId | String | False |
The internal identifier for the payment terms associated with the vendor, typically used for financial reporting and tracking the vendor’s payment schedule. |
| Terms_Name | String | False |
The name of the payment terms assigned to the vendor, such as 'Net 30', 'Due on Receipt', or custom payment terms, helping to manage the payment process. |
| Terms_Type | String | False |
The type of payment terms applied to the vendor, such as fixed or dynamic, which determines how payments should be scheduled and processed. The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |
| Title | String | False |
The title of the vendor’s primary contact person, such as 'Manager', 'Owner', or 'Director', often used for formal or professional correspondence. |
| UnbilledOrders | Double | False |
The total value of unbilled orders for the vendor, indicating the amount of goods or services ordered but not yet invoiced. |
| UnbilledOrdersPrimary | Double | False |
The unbilled orders amount in the primary currency, providing a financial measure of orders that have not yet been invoiced in the vendor's primary currency. |
| Url | String | False |
The website URL for the vendor, often used for quick reference to the vendor's online store or portal for order management or customer support. |
| VatRegNumber | String | False |
The VAT registration number assigned to the vendor, important for compliance with value-added tax (VAT) regulations, especially for businesses in the European Union or other regions requiring VAT. |
| WorkCalendar_ExternalId | String | False |
The external identifier for the work calendar associated with the vendor, typically used for managing and tracking vendor working hours or holiday schedules. |
| WorkCalendar_InternalId | String | False |
The internal identifier for the vendor’s work calendar, used for scheduling and ensuring that vendor availability aligns with business operations. |
| WorkCalendar_Name | String | False |
The name of the work calendar linked to the vendor, such as 'Holiday Schedule' or 'Standard Workweek', which helps manage vendor-related activities. |
| WorkCalendar_Type | String | False |
The type of work calendar used for the vendor, such as a standard workweek or custom calendar, which defines working days, holidays, and hours of operation. The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |