Sovos.com
Contact SupportField mappings
Map Sovos fields to fields in NetSuite Legacy Tax.
| Sovos Field Name | Sovos Field Type | NetSuite Field Name | Notes |
|---|---|---|---|
| subsidiaryName | String | subsidiary.name | |
| taxRegistrationId | String | subsidiary.federalidnumber | |
| currencyId | String | transaction.currencyname | |
| nexusId | String | ||
| locationId | String | ||
| subtotal | Decimal | transaction.subtotal | |
| discountTotal | Decimal | transaction.discounttotal | |
| headerDiscount | headerDiscount.amount | ||
| headerDiscount.amount | Decimal | transaction.discounttotal | |
| headerDiscount.discountType | Integer | ||
| isPreview | Boolean | Conditional | This value is a function of the transaction type and calculation |
| isNetSuitePendingWorkflow | Boolean | Conditional | This value is a function of the transaction type and calculation |
| isTaxRegistrationOverridden | Boolean | Static false | |
| billFromAddress | Conditional | This address is pulled from the subsidary.mainaddress unless a location has been specified. If a location is specified the address is pulled from location.mainaddress | |
| billFromAddress.streetNameNumber | String | ||
| billFromAddress.city | String | ||
| billFromAddress.state | String | ||
| billFromAddress.zipCode | String | ||
| billFromAddress.country | String | ||
| billToAddress | Conditional | This value is pulled from transaction.billingaddress. If billingaddress is blank, then transaction.shippingaddress is used | |
| billToAddress.streetNameNumber | String | ||
| billToAddress.city | String | ||
| billToAddress.state | String | ||
| billToAddress.zipCode | String | ||
| billToAddress.country | String | ||
| shipToAddress | |||
| shipToAddress.streetNameNumber | String | transaction.shippingaddress | |
| shipToAddress.city | String | ||
| shipToAddress.state | String | ||
| shipToAddress.zipCode | String | ||
| shipToAddress.country | String | ||
| shipToAddress | Conditional | This address is pulled from subsidary.mainaddress unless a location has been specified, in which case the address is pulled from location.mainaddress | |
| shipFromAddress.streetNameNumber | String | ||
| shipFromAddress.city | String | ||
| shipFromAddress.state | String | ||
| shipFromAddress.zipCode | String | ||
| shipFromAddress.country | String | ||
| transactionDate | String | transaction.transdate | |
| transactionDate.day | Integer | ||
| transactionDate.month | Integer | ||
| transactionDate.year | Integer | ||
| postingEndDate | transaction.transdate | ||
| postingEndDate.day | Integer | ||
| postingEndDate.month | Integer | ||
| postingEndDate.year | Integer | ||
| taxCalculationInputLine | |||
| taxCalculationInputLine.lineNumber | Integer | transaction.item.line | |
| taxCalculationInputLine.itemType | String | item.recordtype | |
| taxCalculationInputLine.lineType | String | item.recordtype | |
| taxCalculationInputLine.amount | Decimal | transaction.item.amount | |
| taxCalculationInputLine.quantity | Decimal | transaction.item.quantity | |
| taxCalculationInputLine.reference | Integer | transaction.item.line | |
| taxCalculationInputLine.itemName | String | Conditional | This is equal to item.custitem_svs_otc_ptc_tax_code unless this value is blank, in which case item.itemid is used. |
| taxCalculationInputLine.discounts | |||
| taxCalculationInputLine.discounts.amount | Decimal | transaction.item.amount | Item is a discount line item |
| taxCalculationInputLine.discounts.discountType | Integer | Conditional | This value is pulled from custom record type customrecord_grav_discountmap.custrecord_sovos_discount_type where customrecord_grav_discountmap.custrecord_sovos_discount_item equals transaction.lineitem.item. Item is a discount item. |
| taxCalculationInputLine.shipToAddress | Conditional | Only if line item shipping is enabled. Pulled from transaction.line.shipaddress | |
| taxCalculationInputLine.shipToAddress.streetNameNumber | String | ||
| taxCalculationInputLine.shipToAddress.city | String | ||
| taxCalculationInputLine.shipToAddress.state | String | ||
| taxCalculationInputLine.shipToAddress.zipCode | String | ||
| taxCalculationInputLine.shipToAddress.country | String | ||
| taxCalculationInputLine.shipFromAddress | Conditional | Only on transactions with Location field on lines. Pulled from transaction.item.location | |
| taxCalculationInputLine.shipFromAddress.streetNameNumber | String | ||
| taxCalculationInputLine.shipFromAddress.city | String | ||
| taxCalculationInputLine.shipFromAddress.state | String | ||
| taxCalculationInputLine.shipFromAddress.zipCode | String | ||
| taxCalculationInputLine.shipFromAddress.country | String | ||
| customerVendor | |||
| customerVendor.name | String | customer.entityid | |
| customerVendor.taxRegistrationNumber | String | customer.vatregnumber | |
| isPosting | Boolean | Conditional | This value is a function of the transaction type and calculation |
| transactionDocNumber | String | transaction.tranid | |
| transactionId | String | tranaction.id | |
| transactionRecordType | String | transaction.recordType |