Upcs
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.
Insert
To create a UPC object CompanyId, Upc and Description are required fields.
INSERT INTO Upcs (CompanyId, Upc, Description) VALUES (283040, '023032550992', 'Yarn')
Update
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
Delete
To delete a Upc, you need to specify Id and CompanyId in WHERE clause.
DELETE FROM Upcs WHERE Id = 123456789 AND CompanyId = 283040
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | Int | False |
The unique ID number for this UPC. |
| CompanyId [KEY] | Int | False |
The unique ID number of the company to which this UPC belongs. |
| ModifiedUserId | Int | False |
The user ID of the user who last modified this record. |
| CreatedUserId | Int | False |
The User ID of the user who created this record. |
| Upc | String | False |
The 12-14 character Universal Product Code, European Article Number, or Global Trade Identification Number. |
| ModifiedDate | Datetime | False |
The date/time when this record was last modified. |
| EndDate | Date | False |
If this UPC expired or will expire on a certain date, this contains the last date on which the UPC was effective. |
| LegacyTaxCode | String | False |
Legacy Tax Code applied to any product sold with this UPC. |
| Usage | Int | False |
A usage identifier for this UPC code. |
| IsSystem | Int | False |
A flag indicating whether this UPC code is attached to the AvaTax system or to a company. |
| EffectiveDate | Date | False |
If this UPC became effective on a certain date, this contains the first date on which the UPC was effective. |
| Description | String | False |
Description of the product to which this UPC applies. |
| CreatedDate | Datetime | False |
The date when this record was created. |
| PageKey | String | False |