Upcs table for AvalaraAvatax data provider.
A UPC represents a single Universal Product Code in your catalog and matches this product to the tax code identified by this UPC.
To create a UPC object CompanyId, Upc and Description are required fields.
INSERT INTO Upcs (CompanyId, Upc, Description) VALUES (283040, '023032550992', 'Yarn')
To update a Upc, you need to specify Id and CompanyId in WHERE clause.
UPDATE Upcs SET LegacyTaxCode = 'PS081282' WHERE Id = 123456789 AND CompanyId = 283040
To delete a Upc, you need to specify Id and CompanyId in WHERE clause.
DELETE FROM Upcs WHERE Id = 123456789 AND CompanyId = 283040
The unique ID number for this UPC.
The unique ID number of the company to which this UPC belongs.
The user ID of the user who last modified this record.
The User ID of the user who created this record.
The 12-14 character Universal Product Code, European Article Number, or Global Trade Identification Number.
The date/time when this record was last modified.
If this UPC expired or will expire on a certain date, this contains the last date on which the UPC was effective.
Legacy Tax Code applied to any product sold with this UPC.
A usage identifier for this UPC code.
A flag indicating whether this UPC code is attached to the AvaTax system or to a company.
If this UPC became effective on a certain date, this contains the first date on which the UPC was effective.
Description of the product to which this UPC applies.
The date when this record was created.