Sovos
|
NetSuite
|
Field Name
|
Field Type
|
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
|
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
|
|
|
|
shipFromAddress
|
|
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
|
|