CATaxTran

PX.Objects.CARelease 2025.2

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

Select a row for its description 78 of 78 fields

	Field Name	Type	Display Name	Foreign Key
	`AccountID`Default Navigation	`int`	Account	Account
Description:The reference to the account record (Account.AccountID) of the related Tax record.
	`AdjNbr`	`int`		-
Description:Link to APPayment (Check) application. Used for withholding taxes.
	`AdjdDocType`	`nvarchar(3)`		-
Description:Link to APPayment (Check) application. Used for withholding taxes.
	`AdjdRefNbr`	`nvarchar(15)`		-
Description:Link to APPayment (Check) application. Used for withholding taxes.
	`AdjustedTaxAmt`	`decimal`		-
Description:The Tax Amount of the prepayment invoice document (PPI) reduced by a credit memo or a debit adjustment. when the feature FeaturesSet.VATRecognitionOnPrepaymentsAR or FeaturesSet.VATRecognitionOnPrepaymentsAP is activated. In the base currency
	`AdjustedTaxableAmt`	`decimal`		-
Description:The Taxable Amount of the prepayment invoice document (PPI) reduced by a credit memo or a debit adjustment. when the feature FeaturesSet.VATRecognitionOnPrepaymentsAR or FeaturesSet.VATRecognitionOnPrepaymentsAP 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
	`CuryAdjustedTaxAmt`	`decimal`	Adj. Tax Amount	-
Description:The Tax Amount of the prepayment invoice document (PPI) reduced by a credit memo or a debit adjustment. when the feature FeaturesSet.VATRecognitionOnPrepaymentsAR or FeaturesSet.VATRecognitionOnPrepaymentsAP is activated.
	`CuryAdjustedTaxableAmt`	`decimal`	Adj. Taxable Amount	-
Description:The Taxable Amount of the prepayment invoice document (PPI) reduced by a credit memo or a debit adjustment. when the feature FeaturesSet.VATRecognitionOnPrepaymentsAR or FeaturesSet.VATRecognitionOnPrepaymentsAP 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`	Exempted Amount	-
Description:The exempted amount in the record currency.
	`CuryExpenseAmt`	`decimal`	Expense Amount	-
Description:The expense amount in the record currency.
	`CuryID`Default Navigation	`string`		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`	Orig. Taxable Amount	-
Description:The original taxable amount (before truncation by minimal or maximal value) in the record currency.
	`CuryRetainedTaxAmt`	`decimal`	Retained Tax	-
Description:No description available
	`CuryRetainedTaxAmtSumm`	`decimal`		-
Description:No description available
	`CuryRetainedTaxableAmt`	`decimal`	Retained Taxable Amount	-
Description:No description available
	`CuryTaxAmt`	`decimal`	Tax Amount	-
Description:The tax amount in the record currency.
	`CuryTaxAmtSumm`	`decimal`		-
Description:No description available
	`CuryTaxableAmt`	`decimal`	Taxable Amount	-
Description:The taxable amount in the record currency.
	`Description`	`nvarchar(512)`	Description	-
Description:The description of the transaction.
	`ExemptedAmt`	`decimal`	Exempted Amount	-
Description:The exempted amount in the base currency.
	`ExpenseAmt`	`decimal`	Expense Amount	-
Description:The expense amount in the base currency.
	`FinDate`	`datetime`		-
Description:The last day (FinPeriod.FinDate) of the financial period of the document to which the record belongs.
	`FinPeriodID`	`string`		-
Description:The reference to the financial period of the document to which the record belongs.
	`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 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`		-
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.
	`Module`	`char(2)`	Module	-
Description:The source module of the record. The field is a part of the primary key.
	`NonDeductibleTaxRate`	`decimal`	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`	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.
	`RecordID`	`int`		-
Description:This is an auto-numbered field, which is a part of the primary key.
	`RefNbr`	`nvarchar(15)`	Ref. Nbr.	CAAdj
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`	`datetime`	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`		-
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`	Report Exempted Amount	-
Description:The exempted amount in the tax agency currency.
	`ReportTaxAmt`	`decimal`	Report Tax Amount	-
Description:The tax amount in the tax agency currency.
	`ReportTaxableAmt`	`decimal`	Report Taxable Amount	-
Description:The taxable amount in the tax agency currency.
	`RetainedTaxAmt`	`decimal`	Retained Tax	-
Description:No description available
	`RetainedTaxAmtSumm`	`decimal`		-
Description:No description available
	`RetainedTaxableAmt`	`decimal`	Retained Taxable Amount	-
Description:No description available
	`RevisionID`	`int`		TaxReport
Description:The revision of the tax report to which the record was included.
	`Selected`Nonexistent in DB	`bool?`	Selected	-
Description:Indicates (if set to "true") that the tax transaction is selected on a form.
	`SubID`Default Navigation	`int`	Subaccount	Sub
Description:The reference to the subaccount (Account.AccountID) of the related Tax record.
	`TaxAmt`	`decimal`	Tax Amount	-
Description:The tax amount in the base currency.
	`TaxAmtSumm`	`decimal`		-
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`	Tax ID	Tax
Description:The reference to the Tax record.
	`TaxInvoiceDate`	`datetime`	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`	`string`		-
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`	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:The unit of measure used by tax. Specific/Per Unit taxes are calculated on quantities in this UOM
	`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.
	`TaxableAmt`	`decimal`	Taxable Amount	-
Description:The taxable amount in the base currency.
	`TaxableQty`	`decimal`	Taxable Qty.	-
Description:The taxable quantity for per unit taxes.
	`TranDate`	`datetime`	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	CAAdj
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
	`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.
	`tstamp`	`timestamp`		-
Description:No description available