Power BI Connector for NetSuite

Build 25.0.9454

vendorprepayment

Manages prepayments made to vendors before invoicing, assisting in financial planning.

Columns

Name Type References Description
account String The general ledger account associated with the vendor prepayment transaction.
balance Decimal The remaining balance of the vendor prepayment, reflecting any applied amounts.
class String The classification associated with the vendor prepayment, used for categorization and reporting.
cleared Boolean Indicates whether the vendor prepayment transaction has been cleared in the bank reconciliation process.
cleareddate Date The date on which the vendor prepayment transaction was cleared in the reconciliation process.
createddate Datetime The date and time when the vendor prepayment transaction record was created in NetSuite.
currency String The currency in which the vendor prepayment transaction was made, essential for financial processing.
currencyname String The full name of the currency used in the vendor prepayment transaction.
currencysymbol String The symbol representing the currency used in the vendor prepayment transaction, such as '$' for U.S. dollars or '€' for Euros. customform,column:string,The custom form used for recording this vendor prepayment
customform String Customform
department String The department associated with the vendor prepayment, used for organizational reporting and expense tracking.
entity String The vendor or payee associated with the prepayment transaction, which typically stores the unique identifier or name of the vendor to whom the prepayment is being made.
exchangerate Decimal The exchange rate applied to convert the vendor prepayment amount into the base currency of the company.
externalid String A unique identifier for the vendor prepayment transaction that can be used for external integrations or imports.
isbasecurrency Boolean Indicates whether the vendor prepayment transaction was recorded in the company's base currency.
lastmodifieddate Datetime The date and time when the vendor prepayment transaction record was last modified.
location String The physical location or business unit associated with the vendor prepayment transaction.
memo String A note or description entered by the user to provide additional details about the vendor prepayment.
payment String The payment method or reference associated with the vendor prepayment, such as check or bank transfer.
postingperiod String The accounting period in which the vendor prepayment transaction was posted.
prepaymentaccount String The designated general ledger account used to record the vendor prepayment.
printvoucher Boolean Indicates whether a voucher for this vendor prepayment transaction is marked for printing.
purchaseorder String The purchase order related to the vendor prepayment, if applicable.
status String The current status of the vendor prepayment transaction, such as Pending, Approved, or Applied.
subsidiary String The subsidiary entity under which the vendor prepayment transaction was recorded.
tobeprinted Boolean Indicates whether the vendor prepayment transaction is marked to be printed.
trandate Date The transaction date of the vendor prepayment, representing when it was recorded.
tranid String A system-generated transaction ID for the vendor prepayment, used for tracking and reference.
transactionnumber String The unique transaction number assigned to the vendor prepayment, used for auditing and reporting.

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