Vendors: Vendor Information

Returns detailed information about vendors that have been created or updated in the past 7 days. Used in project involving development of a custom Product Information Manager (PIM).

-- Contributor: Tim Dietrich (timdietrich@me.com)
-- Source: https://timdietrich.me/blog/netsuite-suiteql-product-information-manager-sync/
SELECT
	Vendor.ID,
	Vendor.IsInactive, 
	Vendor.CompanyName,
	Vendor.AccountNumber,
	Vendor.Balance,
	Vendor.Email,
	Vendor.Phone,
	BUILTIN.DF( Vendor.Terms ) AS Terms,
	Vendor.DateCreated,
	Vendor.LastModifiedDate
FROM
	Vendor
WHERE
	( Vendor.DateCreated >= ( CURRENT_DATE - 7 ) )
	OR ( Vendor.LastModifiedDate >= ( CURRENT_DATE - 7 ) )

Click here to return to the list of available queries.