SOTaxTran

PX.Objects.SO

38 of 38 fields

	Field Name	Type	Display Name	Foreign Key
	`LineNbr`	`int`	Line Nbr.	SOLine
Description:The line number of this tax item. The field is included in the following foreign keys:
	`OrderNbr`	`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:
	`OrderType`	`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:
	`RecordID`	`int`		-
Description:This is an auto-numbered field, which is a part of the primary key.
	`TaxID`Default Navigation	`nvarchar(60)`	Tax ID	SOTax
Description:The identifier of the specific tax applied to the document. The field is included in the following foreign keys:
	`TaxZoneID`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.
	`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(19, 4)`	Exempted Amount	-
Description:The exempt amount for the specific tax calculated through the document (in the currency of the document).
	`CuryExpenseAmt`	`decimal(19, 4)`	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.
	`CuryTaxableAmt`	`decimal(19, 4)`	Taxable Amount	-
Description:The taxable amount for the specific tax calculated through the document (in the currency of the document).
	`CuryTaxAmt`	`decimal(19, 4)`	Tax Amount	-
Description:The tax amount for the specific tax (in the currency of the document).
	`CuryUnbilledTaxableAmt`	`decimal(19, 4)`	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.
	`CuryUnbilledTaxAmt`	`decimal(19, 4)`	Unbilled Tax Amount	-
Description:The tax amount for the specific tax calculated through the unbilled document lines (in the currency of the document).
	`CuryUnshippedTaxableAmt`	`decimal(19, 4)`	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).
	`CuryUnshippedTaxAmt`	`decimal(19, 4)`	Unshipped Tax Amount	-
Description:The taxable amount for the specific tax calculated through the unshipped document lines (in the currency of the document).
	`ExemptedAmt`	`decimal(19, 4)`	Exempted Amount	-
Description:The exempt amount for the specific tax calculated through the document.
	`ExpenseAmt`	`decimal(19, 4)`	Expense Amount	-
Description:No description available
	`IsTaxInclusive`	`bit`	Tax Inclusive	-
Description:No description available
	`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
	`TaxableAmt`	`decimal(19, 4)`	Taxable Amount	-
Description:The taxable amount for the specific tax calculated through the document.
	`TaxableQty`	`decimal(25, 6)`	Taxable Qty.	-
Description:No description available
	`TaxAmt`	`decimal(19, 4)`	Tax Amount	-
Description:The tax amount for the specific tax calculated through the document.
	`TaxRate`	`decimal(15, 6)`	Tax Rate	-
Description:No description available
	`TaxUOM`Default Navigation	`nvarchar(6)`	Tax UOM	INUnit
Description:No description available
	`tstamp`	`timestamp`		-
Description:No description available
	`UnbilledTaxableAmt`	`decimal(19, 4)`		-
Description:The taxable amount for the specific tax calculated through the unbilled document lines.
	`UnbilledTaxableQty`	`decimal(25, 6)`	Unbilled Taxable Qty.	-
Description:The unbilled taxable quantity for per unit taxes.
	`UnbilledTaxAmt`	`decimal(19, 4)`		-
Description:The tax amount for the specific tax calculated through the unbilled document lines.
	`UnshippedTaxableAmt`	`decimal(19, 4)`		-
Description:The taxable amount for the specific tax calculated through the document lines with nonzero unshipped quantities of stock items.
	`UnshippedTaxableQty`	`decimal(25, 6)`	Unshipped Taxable Qty.	-
Description:The unshipped taxable quantity for per unit taxes.
	`UnshippedTaxAmt`	`decimal(19, 4)`		-
Description:The taxable amount for the specific tax calculated through the unshipped document lines.