CABankTaxTran

PX.Objects.CA

58 of 58 fields

	Field Name	Type	Display Name	Foreign Key
	`BankTranID`	`int`		CABankTran
Description:No description available
	`BankTranType`	`char(1)`	Type	-
Description:No description available
	`Module`	`char(2)`	Module	-
Description:No description available
	`RecordID`	`int`		-
Description:This is an auto-numbered field, which is a part of the primary key.
	`TaxID`Default Navigation	`nvarchar(60)`	Tax ID	Tax
Description:No description available
	`AccountID`Default Navigation	`int`	Account	Account
Description:No description available
	`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.
	`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.
	`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
	`CuryExemptedAmt`	`decimal(19, 4)`	Exempted Amount	-
Description:The exempted amount in the record currency.
	`CuryExpenseAmt`	`decimal(19, 4)`	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(19, 4)`	Orig. Taxable Amount	-
Description:The original taxable amount (before truncation by minimal or maximal value) in the record currency.
	`CuryTaxableAmt`	`decimal(19, 4)`	Taxable Amount	-
Description:The taxable amount in the record currency.
	`CuryTaxAmt`	`decimal(19, 4)`	Tax Amount	-
Description:No description available
	`CuryTaxAmtSumm`	`decimal(19, 4)`		-
Description:No description available
	`CuryTaxDiscountAmt`	`decimal(19, 4)`		-
Description:No description available
	`Description`	`nvarchar(256)`	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:No description available
	`FinDate`	`datetime`		-
Description:No description available
	`FinPeriodID`	`char(6)`		-
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.
	`NonDeductibleTaxRate`	`decimal(9, 6)`	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(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.
	`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
	`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`		-
Description:No description available
	`TaxDiscountAmt`	`decimal(19, 4)`		-
Description:No description available
	`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)`		-
Description:No description available
	`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`	`nvarchar(10)`		-
Description:No description available
	`TranDate`	`datetime2`		-
Description:No description available
	`tstamp`	`timestamp`		-
Description:No description available
	`VendorID`	`int`		-
Description:No description available
	`Voided`	`bit`		-
Description:Indicates (if set to "true") that the record has been voided.