ADO.NET Provider for NetSuite

Build 25.0.9434

VendorPayment

Tracks payments made to vendors for goods and services, including payment methods and statuses in NetSuite.

Columns

Name Type ReadOnly Description
InternalId [KEY] String True

A unique internal identifier assigned to the vendor payment in NetSuite. This ID is used to track and reference the payment within the system and ensures that each transaction is distinct and can be retrieved or updated without ambiguity.

Account_ExternalId String False

The external identifier for the account involved in this vendor payment, typically used for integration with external systems such as banks, ERP systems, or other accounting platforms. This ID links the payment to an external account for cross-system tracking.

Account_InternalId String False

The internal identifier for the account from which the vendor payment is being made. This ID is used within NetSuite to associate the payment with a specific account in the financial records, ensuring that the transaction is properly categorized in internal reporting.

Account_Name String False

The name of the account from which the payment is issued, such as 'Checking Account', 'Accounts Payable', or 'Cash Account'. This helps to identify the payment source and provides clarity in accounting and bank reconciliation processes.

Account_Type String False

The type of account used for the payment, indicating whether it's a 'Bank', 'Cash', 'Credit', or another type of financial account. This field helps classify the payment for financial reporting and aids in identifying the account type in audits.

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.

Address String False

The address of the vendor receiving the payment. This information can be used for mailing purposes (for example, if the payment is issued via check) and can also help ensure that the correct vendor is associated with the payment transaction in case of any disputes or clarifications.

ApAcct_ExternalId String False

The external identifier for the accounts payable (AP) account linked to the vendor payment. This ID is typically used when integrating with other systems like external financial tools or bank accounts, and it ensures that the AP account is correctly referenced across platforms.

ApAcct_InternalId String False

The internal identifier for the AP account in the NetSuite system. This unique ID is used to link the payment to the correct accounts payable account within the system for accurate financial tracking and reporting.

ApAcct_Name String False

The name of the accounts payable account associated with the vendor payment, such as 'Accounts Payable' or 'Vendor Payments'. This name helps users quickly identify which liability account is being used for the payment.

ApAcct_Type String False

The type of accounts payable account associated with the payment, such as 'Liability' or 'Expense'. This classification is important for managing the financial reporting of liabilities and ensures that payments are tracked against the appropriate financial category.

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.

ApplyList_ReplaceAll Boolean False

A flag indicating whether to replace the entire list of applied payments when updating this record. If set to true, this means any previous applied payments will be removed and replaced, which is useful in scenarios where the payment allocations need to be completely redefined.

Balance Double False

The remaining balance of the vendor after this payment is applied. This amount shows how much the vendor is still owed after the payment, allowing businesses to track outstanding liabilities and ensure that vendors are paid accurately.

BillPay Boolean False

Indicates whether this payment is part of a bill pay transaction. If true, the payment is processed as part of a scheduled bill payment system, often used for automated vendor payment cycles like recurring payments or scheduled due dates.

Class_ExternalId String False

The external identifier for the classification or category associated with this vendor payment. Classifications are often used for financial reporting, cost allocation, or internal categorization purposes, and the external ID helps link this classification to other systems or processes.

Class_InternalId String False

The internal identifier for the classification applied to the vendor payment within NetSuite. This helps to associate the payment with a specific internal category for reporting or analysis purposes, such as 'Office Expenses' or 'Vendor Payments'.

Class_Name String False

The name of the classification or category applied to the vendor payment, which is useful for distinguishing between different types of vendor payments or departmental cost allocations in reporting.

Class_Type String False

The type of classification assigned to this vendor payment, such as 'Expense', 'Liability', or 'Asset'. This classification provides a higher level of context to categorize the transaction within the broader accounting or financial structure of the business.

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.

CreatedDate Datetime False

The date and time when this vendor payment record was created in NetSuite. This timestamp is essential for maintaining an accurate transaction history and helps track when payments were processed, supporting audit and financial reconciliation needs.

CreditList_ReplaceAll Boolean False

Indicates whether the entire list of credits applied to this vendor payment should be replaced when updating the record. If true, any existing credits will be cleared and replaced with new credit entries, which can be necessary in cases of payment adjustments or corrections.

Currency_ExternalId String False

The external identifier for the currency used in the vendor payment, linking the transaction to a specific currency code in external systems or financial tools. This ensures that the correct exchange rates and financial figures are used for cross-border payments.

Currency_InternalId String False

The internal identifier for the currency applied to the vendor payment within NetSuite. This ID helps the system recognize which currency is being used for the transaction and ensures that the proper financial calculations, such as exchange rates, are applied.

Currency_Name String False

The name of the currency used for the payment, such as 'US Dollar', 'Euro', 'British Pound', or other recognized currencies. This name clarifies the denomination of the payment and provides context for financial reporting.

Currency_Type String False

The type of currency used for the transaction, such as 'Local Currency', 'Foreign Currency', or 'Functional Currency'. This classification helps determine the rules and calculations applied to the payment based on currency exchange rates.

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.

CurrencyName String False

The display name of the currency associated with this vendor payment, typically matching the standard currency codes or the local name used in financial records and reports.

CustomForm_ExternalId String False

The external identifier for the custom form template used to create this vendor payment. Custom forms are often used to tailor the data entry process or transaction layout according to specific business requirements.

CustomForm_InternalId String False

The internal identifier for the custom form associated with this vendor payment transaction. This ID links the payment to a specific form used to capture custom fields, enabling flexibility in managing unique payment processes.

CustomForm_Name String False

The name of the custom form used for the vendor payment, helping users identify which form template was used for entering or processing the payment. It’s useful for tracking the form’s intended use or audience.

CustomForm_Type String False

The type of custom form used for this transaction, which can vary depending on the organization’s needs. This classification allows businesses to apply different data entry formats or workflows depending on the context of the vendor payment.

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.

Department_ExternalId String False

The external identifier for the department associated with this vendor payment. This ID is useful for integrating with external systems or managing the payment in relation to departmental budgets or cost centers in larger organizations.

Department_InternalId String False

The internal identifier for the department within NetSuite. This ID links the payment to a specific department, which helps with cost allocation, reporting, and ensuring that expenses are assigned to the correct part of the organization.

Department_Name String False

The name of the department associated with this vendor payment, such as 'Marketing', 'Purchasing', or 'IT Department'. This helps users quickly identify which part of the organization is responsible for the payment or how the payment should be categorized in financial records.

Department_Type String False

The type of department associated with this payment, typically used to classify the department’s role, such as 'Operational', 'Support', or 'Sales'. This type helps categorize payments for reporting purposes and provides insight into the distribution of financial resources within the organization.

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.

Entity_ExternalId String False

The external identifier for the entity or vendor to whom the payment is being made. This ID is typically used for integrations with external systems to ensure that the payment is linked to the correct entity in the broader enterprise ecosystem.

Entity_InternalId String False

The internal identifier for the entity or vendor within NetSuite. This ID ensures that the payment is associated with the correct vendor or business partner in the system, allowing for proper tracking and financial reporting.

Entity_Name String False

The name of the entity or vendor to whom the payment is issued. This is the name displayed in the payment records and helps users identify the recipient of the transaction for auditing, reporting, and tracking purposes.

Entity_Type String False

The type of entity receiving the payment, such as 'Vendor', 'Customer', or 'Employee'. This classification provides context for the transaction and ensures that it is properly categorized in financial reports, helping distinguish between different payment types.

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.

ExchangeRate Double False

The exchange rate applied to the payment if it involves a foreign currency. This rate is used to convert the payment amount from the original currency to the functional or reporting currency, ensuring accurate financial records and avoiding discrepancies in cross-currency transactions.

ExternalId String False

The external identifier for this vendor payment. This ID can be used to link the payment to external systems or tools, allowing for integration between NetSuite and other financial platforms or ERP systems to streamline payment tracking.

LastModifiedDate Datetime False

The date and time when the vendor payment record was last modified. This timestamp helps track changes made to the payment record, whether for adjustments, cancellations, or updates, and is useful for audit purposes.

Location_ExternalId String False

The external identifier for the location associated with this vendor payment. This ID is helpful when managing payments across multiple geographic locations or branches and is used for integrations with external systems that track locations or stores.

Location_InternalId String False

The internal identifier for the location within NetSuite. This ID links the payment to a specific location or branch, ensuring that transactions are recorded accurately based on the physical or operational location from which the payment originated.

Location_Name String False

The name of the location associated with this vendor payment, such as 'New York Office', 'London Branch', or 'Warehouse A'. This field helps provide context for the transaction, indicating which part of the business the payment is related to.

Location_Type String False

The type of location related to the vendor payment, such as 'Warehouse', 'Retail Store', or 'Headquarters'. This classification can help categorize payments by operational context and provide insights into financial distributions across different business areas.

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.

Memo String False

A free-text field where users can add notes or a description related to the vendor payment. This can include details such as payment purpose, vendor instructions, or additional reference information that can not be captured elsewhere in the record.

PostingPeriod_ExternalId String False

The external identifier for the posting period in which the vendor payment is recorded. This ID links the payment to a specific accounting period in external systems or financial tools, ensuring consistency in financial reporting and period-based tracking.

PostingPeriod_InternalId String False

The internal identifier for the posting period within NetSuite. This helps the system determine the correct accounting period for the payment, facilitating proper period-end closing and ensuring that transactions are posted to the right fiscal period.

PostingPeriod_Name String False

The name of the posting period associated with this vendor payment, such as 'Q1 2025' or 'January 2025'. This is used to categorize the payment within specific financial periods, ensuring that transactions are tracked and reported in the correct timeframe.

PostingPeriod_Type String False

The type of posting period assigned to the payment, such as 'Monthly', 'Quarterly', or 'Annually'. This classification helps align the payment with the appropriate financial period for reporting and closing purposes.

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.

PrintVoucher Boolean False

Indicates whether the vendor payment will be printed as a physical voucher, such as a check or payment slip. If set to true, the payment will be processed for printing, and a voucher or check number will be generated. This is commonly used for manual payments or external vendor processing.

Status String False

The current status of the vendor payment, such as 'Pending', 'Paid', 'Voided', or 'In Progress'. This status helps users track the payment’s lifecycle and provides insights into whether the payment has been completed, is awaiting approval, or has encountered issues.

Subsidiary_ExternalId String False

The external identifier for the subsidiary associated with this vendor payment. This ID is used for multi-subsidiary organizations to link the payment to the correct subsidiary within external systems, ensuring accurate intercompany accounting.

Subsidiary_InternalId String False

The internal identifier for the subsidiary within NetSuite. This ID links the payment to a specific subsidiary, helping track payments at the subsidiary level for financial reporting and compliance purposes in multi-subsidiary setups.

Subsidiary_Name String False

The name of the subsidiary associated with this vendor payment, such as 'Subsidiary A' or 'Regional Office XYZ'. This helps users identify which subsidiary is responsible for the payment, supporting reporting and operational clarity in large enterprises.

Subsidiary_Type String False

The type of subsidiary associated with this payment, such as 'Operating', 'Holding', or 'Branch'. This type can help classify the payment within different organizational structures, offering insights into the specific role or function of the subsidiary within the business.

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.

ToAch Boolean False

Indicates whether the vendor payment is intended to be processed via Automated Clearing House (ACH). If set to true, the payment will be processed electronically through ACH, facilitating faster and more secure transfers without the need for paper checks.

ToBePrinted Boolean False

Indicates whether the vendor payment is marked to be printed. If set to true, this field signals that the payment is ready to be printed, typically as a physical check, which is common in traditional payment processes.

Total Double False

The total amount of the vendor payment. This is the full sum being paid to the vendor, which can include taxes, adjustments, or other amounts. It reflects the final payment value after any applicable deductions, such as discounts or partial payments.

TranDate Datetime False

The transaction date of the vendor payment. This date represents when the payment was made or processed, and it’s used for accounting purposes to ensure the payment is recorded in the correct financial period.

TranId String False

A unique identifier for the vendor payment transaction, such as a payment reference number. This ID helps track the specific payment and serves as a reference for reconciling payments in accounting systems or external tools.

VoidJournal_ExternalId String False

The external identifier for the journal entry associated with the voiding of a vendor payment. If the payment is canceled or voided, this ID links the reversal to an external system for audit and reporting purposes, ensuring consistency in financial records.

VoidJournal_InternalId String False

The internal identifier for the journal entry within NetSuite that reverses or voids the vendor payment. This ID links the voided payment to the corresponding journal entry in the NetSuite system, ensuring that financial records are updated accurately.

VoidJournal_Name String False

The name of the journal entry associated with the voiding of the vendor payment, such as 'Vendor Payment Reversal' or 'Void Check #12345'. This helps users track the details of payment cancellations or reversals in accounting records.

VoidJournal_Type String False

The type of journal entry created when the vendor payment is voided. This could include 'Journal Entry', 'Payment Reversal', or other types depending on the organization's accounting practices and the system's configuration for handling void 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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434