TaxTran

PX.Objects.TX

78 of 78 fields

	Field Name	Type	Display Name	Foreign Key
	`Module`	`char(2)`	Module	-
Description:The source module of the record. The field is a part of the primary key.
	`RecordID`	`int`		-
Description:This is an auto-numbered field, which is a part of the primary key.
	`AccountID`Default Navigation	`int`	Account	Account
Description:The reference to the account record (Account.AccountID) of the related Tax record.
	`AdjdDocType`	`char(3)`		-
Description:Link to APPayment (Check) application. Used for withholding taxes.
	`AdjdRefNbr`	`nvarchar(15)`		-
Description:Link to APPayment (Check) application. Used for withholding taxes.
	`AdjNbr`	`int`		-
Description:Link to APPayment (Check) application. Used for withholding taxes.
	`AdjustedTaxableAmt`	`decimal(19, 4)`		-
Description:The Taxable Amount of the prepayment invoice document (PPI)reduced by a credit memo when the feature FeaturesSet.VATRecognitionOnPrepayments is activated. In the base currency
	`AdjustedTaxAmt`	`decimal(19, 4)`		-
Description:The Tax Amount of the prepayment invoice document (PPI)reduced by a credit memo when the feature FeaturesSet.VATRecognitionOnPrepayments is activated. In the base currency
	`BAccountID`	`int`		Vendor
Description:The reference to the vendor record (Vendor.BAccountID) or customer record (Customer.BAccountID). The field is used for the records that have been created in the AP or AR module.
	`BranchID`Default Navigation	`int`	Branch	Branch
Description:The reference to the Branch record to which the record belongs. The value is copied from the document from which the record is created.
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`		-
Description:No description available
	`CuryAdjustedTaxableAmt`	`decimal(19, 4)`	Adj. Taxable Amount	-
Description:The Taxable Amount of the prepayment invoice document (PPI)reduced by a credit memo when the feature FeaturesSet.VATRecognitionOnPrepayments is activated.
	`CuryAdjustedTaxAmt`	`decimal(19, 4)`	Adj. Tax Amount	-
Description:The Tax Amount of the prepayment invoice document (PPI)reduced by a credit memo when the feature FeaturesSet.VATRecognitionOnPrepayments is activated.
	`CuryEffDate`Nonexistent in DB	`datetime`		-
Description:The effective date of the suitable CurrencyRate record. The field is filled in only during preparation of the tax report.
	`CuryExemptedAmt`	`decimal(19, 4)`	Exempted Amount	-
Description:The exempted amount in the record currency.
	`CuryExpenseAmt`	`decimal(19, 4)`	Expense Amount	-
Description:The expense amount in the record currency.
	`CuryID`Default Navigation	`nvarchar(5)`	Currency	Currency
Description:The reference to the currency (Currency.CuryID) of the document to which the record belongs.
	`CuryInfoID`	`bigint`		CurrencyInfo
Description:The reference to the CurrencyInfo record that is related to the document.
	`CuryOrigTaxableAmt`	`decimal(19, 4)`	Orig. Taxable Amount	-
Description:The original taxable amount (before truncation by minimal or maximal value) in the record currency.
	`CuryRetainedTaxableAmt`	`decimal(19, 4)`	Retained Taxable Amount	-
Description:No description available
	`CuryRetainedTaxAmt`	`decimal(19, 4)`	Retained Tax	-
Description:No description available
	`CuryRetainedTaxAmtSumm`	`decimal(19, 4)`		-
Description:No description available
	`CuryTaxableAmt`	`decimal(19, 4)`	Taxable Amount	-
Description:The taxable amount in the record currency.
	`CuryTaxAmt`	`decimal(19, 4)`	Tax Amount	-
Description:The tax amount in the record currency.
	`CuryTaxAmtSumm`	`decimal(19, 4)`		-
Description:No description available
	`Description`	`nvarchar(512)`	Description	-
Description:The description of the transaction.
	`ExemptedAmt`	`decimal(19, 4)`	Exempted Amount	-
Description:The exempted amount in the base currency.
	`ExpenseAmt`	`decimal(19, 4)`	Expense Amount	-
Description:The expense amount in the base currency.
	`FinDate`	`datetime`		-
Description:No description available
	`FinPeriodID`	`char(6)`		-
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 taxes from Avalara.
	`JurisType`	`nvarchar(9)`	Tax Jurisdiction Type	-
Description:The tax jurisdiction type. The field is used for the taxes from Avalara.
	`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`	`int`		CAExpense
Description:No description available
	`LineRefNbr`	`nvarchar(15)`	Line Ref. Number	-
Description:The reference number of the transaction to which the record is related. The field is used for the records that are created from GL.
	`NonDeductibleTaxRate`	`decimal(9, 6)`	Deductible Tax Rate	-
Description:The deductible tax rate from the related TaxRev record.
	`OrigRefNbr`	`nvarchar(15)`	Orig. Doc. Number	-
Description:The original document reference number for which the tax amount has been entered. The field is used for the records that are created on the Tax Bills and Adjustments (TX303000) form.
	`OrigTaxableAmt`	`decimal(19, 4)`	Orig. Taxable Amount	-
Description:The original taxable amount (before truncation by minimal or maximal value) in the base currency.
	`OrigTranType`	`char(3)`	Orig. Tran. Type	-
Description:The original document type for which the tax amount has been entered. The field is used for the records that are created on the Tax Bills and Adjustments (TX303000) form.
	`RefNbr`	`nvarchar(15)`	Ref. Nbr.	APRegister
Description:The reference number of the document to which the record is releated.
	`Released`	`bit`		-
Description:Indicates (if set to "true") that the record has been released.
	`ReportCuryEffDate`	`datetime2`	Report Effective Date	-
Description:The effective date of the currency rate (CurrencyRate.CuryEffDate), which is used during report preparation to obtain amounts in the tax agency currency.
	`ReportCuryID`Default Navigation	`nvarchar(5)`	Report Currency	Currency
Description:The reference to the currency (Currency.CuryID) of the tax agency.
	`ReportCuryMultDiv`	`char(1)`	Report Mult Div	-
Description:The conversion type of the currency rate (CurrencyRate.CuryMultDiv), which is used during report preparation to obtain amounts in the tax agency currency.
	`ReportCuryRate`	`decimal(19, 8)`		-
Description:The currency rate value (CurrencyRate.CuryRate) of the (CurrencyRate) record which is used on report prepare to obtaion amounts in the tax agency currency.
	`ReportCuryRateTypeID`Default Navigation	`nvarchar(6)`	Report Currency Rate Type	CurrencyRateType
Description:The reference to the currency rate type (CurrencyRateType.CuryRateTypeID), which is used during report preparation to obtain amounts in the tax agency currency.
	`ReportExemptedAmt`	`decimal(19, 4)`	Report Exempted Amount	-
Description:The exempted amount in the tax agency currency.
	`ReportTaxableAmt`	`decimal(19, 4)`	Report Taxable Amount	-
Description:The taxable amount in the tax agency currency.
	`ReportTaxAmt`	`decimal(19, 4)`	Report Tax Amount	-
Description:The tax amount in the tax agency currency.
	`RetainedTaxableAmt`	`decimal(19, 4)`	Retained Taxable Amount	-
Description:No description available
	`RetainedTaxAmt`	`decimal(19, 4)`	Retained Tax	-
Description:No description available
	`RetainedTaxAmtSumm`	`decimal(19, 4)`		-
Description:No description available
	`RevisionID`	`int`		TaxReport
Description:The revision of the tax report to which the record was included.
	`Selected`Nonexistent in DB	`bit`	Selected	-
Description:Indicates (if set to "true") that the tax transaction is selected on a form.
	`SubID`Default Navigation	`int`	Sub.	Sub
Description:The reference to the subaccount (Account.AccountID) of the related Tax record.
	`TaxableAmt`	`decimal(19, 4)`	Taxable Amount	-
Description:The taxable amount in the base currency.
	`TaxableQty`	`decimal(25, 6)`	Taxable Qty.	-
Description:No description available
	`TaxAmt`	`decimal(19, 4)`	Tax Amount	-
Description:The tax amount in the base currency.
	`TaxAmtSumm`	`decimal(19, 4)`		-
Description:No description available
	`TaxBucketID`	`int`		TaxBucket
Description:The reference to the reporting group (TaxBucket.BucketID) for which the record should be reported. During record creation, the value of the field is assigned based on the document. During preparation of the tax report, the value is updated from the relevant record.
	`TaxID`Default Navigation	`nvarchar(60)`	Tax ID	Tax
Description:The reference to the Tax record.
	`TaxInvoiceDate`	`datetime2`	Tax Invoice Date	-
Description:The date of the tax invoice. The field is used for recognized SVAT records.
	`TaxInvoiceNbr`	`nvarchar(15)`	Tax Invoice Nbr.	-
Description:The reference number of the tax invoice. The field is used for recognized SVAT records.
	`TaxPeriodID`	`char(6)`		TaxPeriod
Description:The key of the tax period to which the record has been reported. The field has the null value for the unreported records.
	`TaxRate`	`decimal(9, 6)`	Tax Rate	-
Description:The tax rate of the relevant Tax record.
	`TaxType`	`char(1)`		-
Description:No description available
	`TaxUOM`Default Navigation	`nvarchar(6)`	Tax UOM	INUnit
Description:No description available
	`TaxZoneID`Default Navigation	`nvarchar(10)`	Tax Zone	TaxZone
Description:The reference to the tax zone (TaxZone.TaxZoneID). The value is assigned based on the document to which the record belongs.
	`TranDate`	`datetime2`	Tran. Date	-
Description:The date of the tax record. The value corresponds to the date of the document to which the record belongs.
	`TranType`	`char(3)`	Tran. Type	-
Description:The type of the record. If the record is related to a document, the field contains the type of the document. In other cases, the field contains one of the following values: "TFW": GL tax record "TRV": GL tax record "INT": Output tax adjustment "RET": Input tax adjustment "VTI": Input VAT "VTO": Output VAT "REI": Reverse input VAT "REO": Reverse output VAT
	`tstamp`	`timestamp`		-
Description:No description available
	`VendorID`	`int`		Vendor
Description:The foreign key to AP.Vendor, which specifies the tax agency to which the record belongs. When the record is created, the field is assigned the default value based on the document. The value of the field is updated during preparation of a tax report.
	`Voided`	`bit`		-
Description:Indicates (if set to "true") that the record has been voided.