Excel Add-In for NetSuite

Build 25.0.9434

vendorprepaymentapplication

Tracks the application of vendor prepayments to invoices, ensuring proper allocation of funds.

Columns

Name Type References Description
account String The general ledger account associated with this vendor prepayment application. This account determines where the prepayment amount is recorded.
class String The classification category assigned to this vendor prepayment application, often used for tracking and reporting purposes.
createddate Datetime The date and time when this vendor prepayment application record was initially created in the system.
currency String The currency in which the vendor prepayment application is recorded. This determines the monetary unit for the transaction.
customform String The specific custom form used for this vendor prepayment application, if any, to accommodate company-specific fields and layouts.
department String The department associated with this vendor prepayment application, typically used for financial tracking and internal reporting.
entity String The vendor to whom the prepayment is applied. This represents the business entity receiving the funds.
exchangerate Decimal The exchange rate applied at the time of the transaction, determining the conversion between the base currency and the transaction currency.
externalid String An optional unique identifier for this vendor prepayment application, typically used for data integration with external systems.
isbasecurrency Boolean Indicates whether the currency used in this transaction is the base currency of the company. A value of true means it is the base currency.
lastmodifieddate Datetime The most recent date and time when this vendor prepayment application record was updated in the system.
location String The physical or operational location associated with this vendor prepayment application, used for tracking and reporting purposes.
memo String A free-text field for adding additional notes or comments related to this vendor prepayment application.
postingperiod String The accounting period in which this vendor prepayment application is posted. This determines when the transaction affects financial reports.
prepaymentaccount String The designated general ledger account used to track prepayments made to vendors before goods or services are received.
prepaymentdate Date The date when the vendor prepayment was made, indicating when funds were issued to the vendor.
subsidiary String The subsidiary company associated with this vendor prepayment application, relevant in multi-subsidiary NetSuite accounts.
trandate Date The transaction date of the vendor prepayment application, indicating when it was recorded in the system.
tranid String A unique identifier assigned to this vendor prepayment application by NetSuite, often used for referencing the transaction.
transactionnumber String The system-generated transaction number assigned to this vendor prepayment application, ensuring uniqueness within NetSuite.
vendorprepayment String The vendor prepayment record to which this application is linked, specifying the original prepayment transaction being applied.

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