vendorbill

Records vendor bills issued for goods and services, tracking payment status, due dates, and financial impact.

Columns


Name	Type	References	Description
account	String		The general ledger account associated with this vendor bill, used for expense tracking and financial reporting.
approvalstatus	String		The current approval status of the vendor bill, indicating whether it is pending, approved, or rejected.
availablevendorcredit	Decimal		The remaining vendor credit available for application to this bill, reducing the outstanding amount due.
balance	String		The outstanding balance on this vendor bill, reflecting the amount still payable to the vendor.
billaddresslist	String		A reference to the predefined billing address associated with this transaction, used for record-keeping and correspondence.
billingaddress	String		The detailed billing address of the vendor for this bill, used for invoice processing and tax reporting.
class	String		The classification category assigned to this vendor bill, typically used for tracking expenses across business segments.
createddate	Datetime		The date and time when this vendor bill was initially recorded in the system.
creditlimit	Decimal		The maximum credit amount allowed for this vendor, helping manage financial exposure.
currency	String		The currency in which the vendor bill is denominated, determining the exchange rate applied.
currencyname	String		The full name of the currency associated with this vendor bill, such as 'United States Dollar' or 'Euro.'
currencysymbol	String		The symbol of the currency associated with this vendor bill, such as '$' or '€'.
customform	String		The specific custom form template used for this vendor bill, allowing for tailored data entry and presentation.
department	String		The internal department responsible for this vendor bill, used for expense allocation and reporting.
discountamount	Decimal		The total discount applied to this bill, typically based on early payment terms or vendor agreements.
discountdate	Date		The deadline for an early payment discount, if applicable, beyond which the full amount is due.
documentstatus	String		The overall status of this vendor bill, such as 'Pending Submission,' 'Open,' or 'Paid.'
duedate	Date		The date by which payment must be made to avoid late fees or penalties.
entity	String		The vendor associated with this bill, representing the supplier providing the goods or services.
entitynexus	String		The tax jurisdiction applicable to this vendor based on the nexus rules, affecting tax calculations.
entitytaxregnum	String		The tax registration number of the vendor, required for compliance and reporting purposes.
exchangerate	Decimal		The conversion rate applied if the bill is in a different currency than the company’s base currency.
externalid	String		A unique identifier for this vendor bill assigned by an external system for integration purposes.
isbasecurrency	Boolean		Indicates whether the currency of this bill matches the company’s base currency.
landedcostperline	Boolean		Specifies whether landed costs are allocated on a per-line basis, useful for inventory cost tracking.
lastmodifieddate	Datetime		The date and time when this vendor bill was last modified, providing an audit trail of changes.
location	String		The business location associated with this vendor bill, useful for regional financial reporting.
memo	String		A free-text field for additional notes or details about this vendor bill.
nextapprover	String		The designated approver responsible for reviewing and approving this vendor bill.
nexus	String		The tax nexus applicable to this bill, affecting how sales and use taxes are calculated.
overrideinstallments	Boolean		Indicates whether the installment payment schedule for this bill is manually overridden.
paymenthold	Boolean		A flag indicating whether payment for this vendor bill is currently on hold.
postingperiod	String		The accounting period in which this vendor bill is posted, used for financial reporting.
received	String		Indicates whether the goods or services associated with this bill have been received.
status	String		The current lifecycle status of this bill, such as 'Open,' 'Pending Approval,' or 'Paid.'
statusref	String		A system reference code indicating the status of this vendor bill.
subsidiary	String		The subsidiary company associated with this bill, used in multi-entity accounting structures.
subsidiarytaxregnum	String		The tax registration number of the subsidiary handling this vendor bill, ensuring tax compliance.
taxdetailsoverride	Boolean		Indicates whether tax details on this bill have been manually overridden.
taxpointdate	Date		The date used to determine tax liability, typically based on invoice or delivery date.
taxpointdateoverride	Boolean		Specifies whether the tax point date has been manually adjusted.
taxregoverride	Boolean		Indicates whether tax registration details have been manually modified for this bill.
terms	String		The payment terms agreed upon with the vendor, such as 'Net 30' or 'Due on Receipt.'
tobeprinted	Boolean		Indicates whether this bill is marked for printing, typically used in scenarios where businesses manage their accounts payable processes.
total	Decimal		The total amount due on this vendor bill, including taxes and discounts.
trandate	Date		The transaction date of this bill, representing when it was recorded in the system.
tranid	String		A unique system-generated transaction identifier for each vendor bill, enabling effective tracking and management of bills.
transactionnumber	String		A sequential number assigned to this transaction for tracking and reference.
unbilledorders	String		Represents the total amount of outstanding purchase orders that have been received but not yet billed by the vendor. usertotal,column:decimal,The total amount entered by the user
usertotal	Decimal		Usertotal

Power BI Connector for NetSuite

vendorbill

Columns