SOTaxTran

PX.Objects.SORelease 2025.2

Represents tax details at the sales order document level, that is, information on all individual taxes applied to the document lines.

View API Entity: TaxDetail/entity/Default/25.200.001/TaxDetail

Select a row for its description 40 of 40 fields

	Field Name	Type	Display Name	Foreign Key
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`		-
Description:No description available
	`CuryExemptedAmt`	`decimal`	Exempted Amount	-
Description:The exempt amount for the specific tax calculated through the document (in the currency of the document).
	`CuryExpenseAmt`	`decimal`	Expense Amount	-
Description:The expense amount of the tax line (in the currency of the document).
	`CuryInfoID`	`bigint`		CurrencyInfo
Description:The identifier of the currency and exchange rate information. The field is included in the foreign key FK.CurrencyInfo. The value of this field corresponds to the value of the CurrencyInfo.curyInfoID field.
	`CuryTaxAmt` API	`decimal`	Tax Amount	-
Description:The tax amount for the specific tax (in the currency of the document).
	`CuryTaxableAmt` API	`decimal`	Taxable Amount	-
Description:The taxable amount for the specific tax calculated through the document (in the currency of the document).
	`CuryTotalTaxAmount`Nonexistent in DB	`decimal?`		-
Description:The tax total with Canadian tax calculations, which is used for printing.
	`CuryUnbilledTaxAmt`	`decimal`	Unbilled Tax Amount	-
Description:The tax amount for the specific tax calculated through the unbilled document lines (in the currency of the document).
	`CuryUnbilledTaxableAmt`	`decimal`	Unbilled Taxable Amount	-
Description:The taxable amount for the specific tax calculated through the unbilled document lines (in the currency of the document). The taxable amount for the specific tax calculated through the unbilled document lines.
	`CuryUnshippedTaxAmt`	`decimal`	Unshipped Tax Amount	-
Description:The taxable amount for the specific tax calculated through the unshipped document lines (in the currency of the document).
	`CuryUnshippedTaxableAmt`	`decimal`	Unshipped Taxable Amount	-
Description:The taxable amount for the specific tax calculated through the document lines with nonzero unshipped quantities of stock items (in the currency of the document).
	`ExemptedAmt`	`decimal`	Exempted Amount	-
Description:The exempt amount for the specific tax calculated through the document.
	`ExpenseAmt`	`decimal`	Expense Amount	-
Description:No description available
	`IsTaxInclusive`	`bit`	Tax Inclusive	-
Description:A Boolean value that specifies that the tax transaction is tax inclusive or not
	`JurisName`	`nvarchar(200)`	Tax Jurisdiction Name	-
Description:The tax jurisdiction name. The field is used for the Avalara taxes.
	`JurisType`	`nvarchar(9)`	Tax Jurisdiction Type	-
Description:The tax jurisdiction type. The field is used for the Avalara taxes.
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime`	`datetime`		-
Description:No description available
	`LineNbr` API	`int`	Line Nbr.	SOLine
Description:The line number of this tax item. The field is included in the following foreign keys: - FK.OrderLine, the field is a part of the identifier of the sales order line SOLine.SOLine.lineNbr - FK.SOTax, the field is a part of the identifier of the parent sales order's tax line SO.SOTax.SOTax.lineNbr
	`NonDeductibleTaxRate`	`decimal`	Deductible Tax Rate	-
Description:No description available
	`OrderNbr` API	`nvarchar(15)`	Order Nbr.	SOOrder
Description:The reference number of the sales order in which this tax item is listed. The field is included in the following foreign keys: - FK.Order, the field is a part of the identifier of the sales order SOOrder.SOOrder.orderNbr - FK.OrderLine, the field is a part of the identifier of the sales order line SOLine.SOLine.orderNbr - FK.SOTax, the field is a part of the identifier of the parent sales order's tax line SO.SOTax.SOTax.orderNbr
	`OrderType` API	`char(2)`	Order Type	-
Description:The type of the sales order in which this tax item is listed. The field is included in the following foreign keys: - FK.Order, the field is a part of the identifier of the sales order SOOrder.SOOrder.orderType - FK.OrderLine, the field is a part of the identifier of the sales order line SOLine.SOLine.orderType - FK.SOTax, the field is a part of the identifier of the parent sales order's tax line SO.SOTax.SOTax.orderType
	`RecordID` API	`int`		-
Description:This is an auto-numbered field, which is a part of the primary key.
	`TaxAmt`	`decimal`	Tax Amount	-
Description:The tax amount for the specific tax calculated through the document.
	`TaxID` API Default Navigation	`nvarchar`	Tax ID	Tax
Description:The identifier of the specific tax applied to the document. The field is included in the following foreign keys: - FK.SOTax, the field is a part of the identifier of the parent sales order's tax line SO.SOTax.SOTax.taxID - FK.Tax, the field is the identifier of the tax TX.Tax.Tax.taxID
	`TaxRate` API	`decimal`	Tax Rate	-
Description:No description available
	`TaxUOM`Default Navigation	`nvarchar(6)`	Tax UOM	INUnit
Description:The unit of measure used by tax. Specific/Per Unit taxes are calculated on quantities in this UOM
	`TaxZoneID` API Default Navigation	`nvarchar(10)`	Customer Tax Zone	TaxZone
Description:The tax zone to be used to process customer sales orders. The value of this field corresponds to the value of the TaxZone.taxZoneID field. The field is the identifier of the tax zone. The field is included in the FK.TaxZone foreign key.
	`TaxableAmt`	`decimal`	Taxable Amount	-
Description:The taxable amount for the specific tax calculated through the document.
	`TaxableQty`	`decimal`	Taxable Qty.	-
Description:The taxable quantity for per unit taxes.
	`UnbilledTaxAmt`	`decimal`		-
Description:The tax amount for the specific tax calculated through the unbilled document lines.
	`UnbilledTaxableAmt`	`decimal`		-
Description:The taxable amount for the specific tax calculated through the unbilled document lines.
	`UnbilledTaxableQty`	`decimal`	Unbilled Taxable Qty.	-
Description:The unbilled taxable quantity for per unit taxes.
	`UnshippedTaxAmt`	`decimal`		-
Description:The taxable amount for the specific tax calculated through the unshipped document lines.
	`UnshippedTaxableAmt`	`decimal`		-
Description:The taxable amount for the specific tax calculated through the document lines with nonzero unshipped quantities of stock items.
	`UnshippedTaxableQty`	`decimal`	Unshipped Taxable Qty.	-
Description:The unshipped taxable quantity for per unit taxes.
	`tstamp`	`timestamp`		-
Description:No description available