CABankTaxTranMatch

PX.Objects.CARelease 2025.2

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

Select a row for its description 58 of 58 fields

	Field Name	Type	Display Name	Foreign Key
	`AccountID`Default Navigation	`int`	Account	Account
Description:No description available
	`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.
	`BAccountID`	`int`		-
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.
	`BankTranID`	`int`		CABankTran
Description:No description available
	`BankTranType`	`char(1)`	Type	CABankTran
Description:No description available
	`BranchID`Default Navigation	`int`	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
	`CuryExemptedAmt`	`decimal`	Exempted Amount	-
Description:The exempted amount in the record currency.
	`CuryExpenseAmt`	`decimal`	Expense Amount	-
Description:No description available
	`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`		-
Description:No description available
	`CuryOrigTaxableAmt`	`decimal`	Orig. Taxable Amount	-
Description:The original taxable amount (before truncation by minimal or maximal value) in the record currency.
	`CuryTaxAmt`	`decimal`	Tax Amount	-
Description:No description available
	`CuryTaxAmtSumm`	`decimal`		-
Description:No description available
	`CuryTaxDiscountAmt`	`decimal`		-
Description:No description available
	`CuryTaxableAmt`	`decimal`	Taxable Amount	-
Description:The taxable amount in the record currency.
	`Description`	`nvarchar(256)`	Description	-
Description:The description of the transaction.
	`ExemptedAmt`	`decimal`	Exempted Amount	-
Description:The exempted amount in the base currency.
	`ExpenseAmt`	`decimal`	Expense Amount	-
Description:No description available
	`FinDate`	`datetime`		-
Description:The last day (FinPeriod.FinDate) of the financial period of the document to which the record belongs.
	`FinPeriodID`	`string`		-
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
	`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:No description available
	`NonDeductibleTaxRate`	`decimal`	Deductible Tax Rate	-
Description:No description available
	`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.
	`Released`	`bit`		-
Description:Indicates (if set to "true") that the record has been released.
	`RevisionID`	`int`		-
Description:The revision of the tax report to which the record was included.
	`SubID`Default Navigation	`int`	Subaccount	Sub
Description:No description available
	`TaxAmt`	`decimal`	Tax Amount	-
Description:The tax amount in the base currency.
	`TaxAmtSumm`	`decimal`		-
Description:No description available
	`TaxBucketID`	`int`		-
Description:No description available
	`TaxDiscountAmt`	`decimal`		-
Description:No description available
	`TaxID`Default Navigation	`nvarchar(60)`	Tax ID	Tax
Description:No description available
	`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:No description available
	`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`	`nvarchar(10)`		-
Description:No description available
	`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`		-
Description:No description available
	`VendorID`	`int`		-
Description:No description available
	`Voided`	`bit`		-
Description:Indicates (if set to "true") that the record has been voided.
	`tstamp`	`timestamp`		-
Description:No description available