SalesTax

PX.Objects.ARRelease 2025.2

No summary is documented for this DAC in the release source.

Select a row for its description 61 of 61 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`	Created On	-
Description:No description available
	`DeductibleVAT`	`bit`	Partially Deductible VAT	-
Description:Specifies (if set to "true") that the tax is a deductible VAT, which means that a company is allowed to deduct some part of the tax paid to a vendor from its own VAT liability to the government.
	`Descr`	`nvarchar(100)`	Description	-
Description:The description of the tax, which can be specified by the user.
	`DirectTax`	`bit`	Direct-Entry Tax	-
Description:Specifies (if set to "true") that the tax can be entered only by the documents from the Tax Bills and Adjustments form (TX303000).
	`ExemptTax`	`bit`	Include in VAT Exempt Total	-
Description:Specifies (if set to "true") that the calculated amount should be displayed in the VAT Exempt Total box in the documents, such as bills and invoices.
	`ExpenseAccountID`Default Navigation	`int`	Tax Expense Account	Account
Description:The foreign key to Account, which specifies the expense account that is used to record either the tax amounts of use taxes or the non-deductible tax amounts of deductible value-added taxes.
	`ExpenseSubID`Default Navigation	`int`	Tax Expense Subaccount	Sub
Description:The foreign key to Sub, which specifies the corresponding expense subaccount.
	`HistTaxAcctID`Nonexistent in DB	`int?`		-
Description:No description available
	`HistTaxSubID`Nonexistent in DB	`int?`		-
Description:No description available
	`ImportTax`	`bit`	100% Import Purchases GST	-
Description:No description available
	`IncludeInTaxable`	`bit`	Include in VAT Taxable Total	-
Description:Specifies (if set to "true") that the VAT taxable amount should be displayed in the VAT Taxable Total box in the documents, such as bills and invoices.
	`IsExternal`	`bit`		-
Description:Specifies (if set to "true") that the tax zone is used for the external tax provider.
	`IsImported`Obsolete	`bit`		-
Description:Specifies (if set to "true") that the tax configuration was imported from Avalara files. The field is obsolete.
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime`	`datetime`	Last Modified On	-
Description:No description available
	`LongPrintingLabel`	`nvarchar(20)`	Long Printing Label	-
Description:The Long Printing Label of a tax is used to print total tax amount in the invoice totals section.
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`OnAPPrepaymentTaxAcctID`Default Navigation	`int`	Tax on AP Prepayment Account	Account
Description:The foreign key to Account, which specifies liability or asset account that keeps VAT collected on AP prepayment invoices for which final bill is not issued yet. Uses when the feature FeaturesSet.VATRecognitionOnPrepaymentsAP is activated.
	`OnAPPrepaymentTaxSubID`Default Navigation	`int`	Tax on AP Prepayment Subaccount	Sub
Description:The foreign key to Sub, which specifies the corresponding tax on AP prepayments subaccount. Uses when the feature FeaturesSet.VATRecognitionOnPrepaymentsAP is activated.
	`OnARPrepaymentTaxAcctID`Default Navigation	`int`	Tax on AR Prepayment Account	Account
Description:The foreign key to Account, which specifies liability or asset account that keeps VAT collected on prepayment invoices for which final invoice is not issued yet. Uses when the feature FeaturesSet.VATRecognitionOnPrepaymentsAR is activated.
	`OnARPrepaymentTaxSubID`Default Navigation	`int`	Tax on AR Prepayment Subaccount	Sub
Description:The foreign key to Sub, which specifies the corresponding tax on AR prepayments subaccount. Uses when the feature FeaturesSet.VATRecognitionOnPrepaymentsAR is activated.
	`OutDate`	`datetime`	Not Valid After	-
Description:The date after which the tax is not effective.
	`Outdated`	`bit`	Is Blocked	-
Description:Specifies (if set to "true") that OutDate was specified.
	`PendingPurchTaxAcctID`Default Navigation	`int`	Pending Tax Claimable Account	Account
Description:The foreign key to Account, which specifies the account that accumulates the tax amounts to be claimed from the tax agency for the pending tax.
	`PendingPurchTaxSubID`Default Navigation	`int`	Pending Tax Claimable Subaccount	Sub
Description:The foreign key to Sub, which specifies the corresponding tax claimable pending subaccount.
	`PendingSalesTaxAcctID`Default Navigation	`int`	Pending Tax Payable Account	Account
Description:The foreign key to Account, which specifies the liability account that accumulates the amount of taxes to be paid to a tax agency for the pending tax.
	`PendingSalesTaxSubID`Default Navigation	`int`	Pending Tax Payable Subaccount	Sub
Description:The foreign key to Sub, which specifies the corresponding tax payable pending subaccount.
	`PendingTax`	`bit`	Pending VAT	-
Description:Specifies (if set to "true") that the tax is a pending VAT. The pending VAT should be calculated in documents, but should not be recorded in the tax report. Later the VAT of the pending type can be converted into the general VAT.
	`PerUnitTaxPostMode`	`char(1)`	Post To	-
Description:An per-unit tax post mode for posting during the document release. Possible options are - post tax amounts on tax account or post to document line's account.
	`PrintingSequence`	`int`	Printing Sequence	-
Description:The Printing Sequence field value is used to define order in which taxes are printed on the documents.
	`PurchTaxAcctID`Default Navigation	`int`	Tax Claimable Account	Account
Description:The foreign key to Account, which specifies the account that accumulates the tax amounts to be claimed from the tax agency for the tax reporting period.
	`PurchTaxAcctIDOverride`Default Navigation	`int`	Account to Use on Purchase	Account
Description:The override of Tax.PurchTaxAcctID to display different labels for per-unit Tax.
	`PurchTaxSubID`Default Navigation	`int`	Tax Claimable Subaccount	Sub
Description:The foreign key to Sub, which specifies the corresponding tax claimable subaccount.
	`PurchTaxSubIDOverride`Default Navigation	`int`	Subaccount to Use on Purchase	Sub
Description:The override of Tax.PurchTaxSubID to display different labels for per-unit Tax.
	`ReportExpenseToSingleAccount`	`bit`	Use Tax Expense Account	-
Description:Specifies (if set to "true") that the non-deductible part should be posted to the Tax Expense account.
	`RetainageTaxClaimableAcctID`Default Navigation	`int`	Retainage Tax Claimable Account	Account
Description:No description available
	`RetainageTaxClaimableSubID`Default Navigation	`int`	Retainage Tax Claimable Subaccount	Sub
Description:No description available
	`RetainageTaxPayableAcctID`Default Navigation	`int`	Retainage Tax Payable Account	Account
Description:No description available
	`RetainageTaxPayableSubID`Default Navigation	`int`	Retainage Tax Payable Subaccount	Sub
Description:No description available
	`ReverseTax`	`bit`	Reverse VAT	-
Description:Specifies (if set to "true") that the tax is a reverse VAT. When the reverse VAT is applied to a company that supplies goods or service to other EU countries, the liability of reporting VAT is reversed and goes to the customer rather than to the vendor.
	`SalesTaxAcctID`Default Navigation	`int`	Tax Payable Account	Account
Description:The foreign key to Account, which specifies the liability account that accumulates the tax amounts to be paid to a tax agency for the tax reporting period.
	`SalesTaxAcctIDOverride`Default Navigation	`int`	Account to Use on Sale	Account
Description:The override of Tax.SalesTaxAcctID to display different labels for per-unit Tax.
	`SalesTaxSubID`Default Navigation	`int`	Tax Payable Subaccount	Sub
Description:The foreign key to Sub, which specifies the corresponding tax payable subaccount.
	`SalesTaxSubIDOverride`Default Navigation	`int`	Subaccount to Use on Sale	Sub
Description:The override of Tax.SalesTaxSubID to display different labels for per-unit Tax.
	`ShortPrintingLabel`	`char(1)`	Short Printing Label	-
Description:The Short Printing Label value is used to print tax in the invoice lines.
	`StatisticalTax`	`bit`	Statistical VAT	-
Description:Specifies (if set to "true") that the tax is a statistical VAT. The statistical VAT is calculated for statistical purposes; the VAT is reported but not paid.
	`TaxApplyTermsDisc`	`char(1)`	Cash Discount	-
Description:The method of calculating the tax base amount if a cash discount is applied. The field can have the following values: ""X"": Reduce the taxable amount. ""P"": Reduce taxable amount on early payment. ""N"": Do not affect taxable amount.
	`TaxCalcLevel`	`char(1)`		-
Description:The tax level. The field can have the following values: ""0"": An inclusive tax. ""1"": A first-level exclusive tax. ""2"": A second-level exclusive tax.
	`TaxCalcLevel2Exclude`	`bit`	Exclude from Tax-on-Tax Calculation	-
Description:Specifies (if set to "true") that the system should exclude the first-level/per unit tax amount from the tax base that is used for calculation of the second-level tax amount in case of first-level taxes or all other taxes in case of per unit taxes. The flag is applicable to only first-level and per unit taxes.
	`TaxCalcRule`Nonexistent in DB	`string`	Calculation Rule	-
Description:The aggregated rule of tax calculation based on TaxCalcType and TaxCalcLevel. The field can have the following values: ""I0"": The tax amount is included in item amounts and should be extracted. ""I1"": The tax is a first-level tax calculated on item amounts. ""I2"": The tax is a second-level tax calculated on item amounts. ""D1"": The tax is a first-level tax calculated on the document amount. ""D2"": The tax is a second-level tax calculated on the document amount.
	`TaxCalcType`	`char(1)`		-
Description:The basis of the tax calculation. The field can have the following values: ""D"": A tax is calculated on a document basis. ""I"": A tax is calculated on a per-line basis.
	`TaxID`Default Navigation	`nvarchar(60)`	Tax ID	Tax
Description:The tax ID. This is the key field, which can be specified by the user.
	`TaxType`	`char(1)`	Tax Type	-
Description:The type of the tax. The field can have the following values: ""S"": Sales tax. ""P"": Use (purchase) tax. ""V"": Value-added tax (VAT). ""W"": Withholding.
	`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
	`TaxVendorID`Default Navigation	`int`	Vendor	Vendor
Description:The foreign key to AP.Vendor, which specifies the tax agency to which the tax belongs. The key can be NULL.
	`TranTaxType`Nonexistent in DB	`string`		-
Description:No description available
	`ZeroTaxable`	`bit`		-
Description:Allow Zero Taxable
	`tstamp`	`timestamp`		-
Description:No description available