CAExpense

PX.Objects.CA

54 of 54 fields

	Field Name	Type	Display Name	Foreign Key
	`LineNbr`	`int`	Line Nbr.	-
Description:No description available
	`RefNbr`	`nvarchar(15)`		CATransfer
Description:No description available
	`AccountID`Default Navigation	`int`	Offset Account	Account
Description:No description available
	`AdjCuryRate`Nonexistent in DB	`decimal`	Currency Rate	-
Description:No description available
	`AdjRefNbr`Obsolete	`nvarchar(15)`	Ref. Nbr.	-
Description:No description available
	`BatchNbr`	`nvarchar(15)`	Batch Number	-
Description:No description available
	`BranchID`Default Navigation	`int`	Branch	Branch
Description:No description available
	`CashAccountID`Default Navigation	`int`	Cash Account	CashAccount
Description:No description available
	`CashTranID`	`bigint`		CATran
Description:No description available
	`ClearDate`	`datetime2`	Clear Date	-
Description:No description available
	`Cleared`	`bit`	Cleared	-
Description:No description available
	`ControlAmt`	`decimal(19, 4)`		-
Description:The control total of the transaction in the base currency.
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`		-
Description:No description available
	`CuryControlAmt`	`decimal(19, 4)`	Control Total	-
Description:The control total of the transaction in the selected currency. A user enters this amount manually. This amount should be equal to the sum of amounts of all detail lines of the transaction.
	`CuryID`Default Navigation	`nvarchar(5)`	Currency	Currency
Description:No description available
	`CuryInfoID`	`bigint`		CurrencyInfo
Description:No description available
	`CurySplitTotal`	`decimal(19, 4)`	Detail Total	-
Description:The sum of amounts of all detail lines in the selected currency.
	`CuryTaxableAmt`	`decimal(19, 4)`	Amount	-
Description:No description available
	`CuryTaxAmt`	`decimal(19, 4)`	Tax Amount	-
Description:The tax amount to be paid for the document in the selected currency. This field is enable and visible only if the CASetup.RequireControlTaxTotal field and the FeaturesSet.NetGrossEntryMode field are set to "true".
	`CuryTaxRoundDiff`	`decimal(19, 4)`	Rounding Diff.	-
Description:The difference between the original document amount and the rounded amount in the selected currency.
	`CuryTaxTotal`	`decimal(19, 4)`	Tax Total	-
Description:The total amount of tax paid on the document in the selected currency.
	`CuryTranAmt`	`decimal(19, 4)`	Total Amount	-
Description:No description available
	`CuryVatExemptTotal`	`decimal(19, 4)`	VAT Exempt Total	-
Description:The document total that is exempt from VAT in the selected currency. This total is calculated as the taxable amount for the tax with the Tax.ExemptTax field set to "true" (that is, the Include in VAT Exempt Total check box selected on the Taxes (TX205000) form).
	`CuryVatTaxableTotal`	`decimal(19, 4)`	VAT Taxable Total	-
Description:The document total that is subjected to VAT in the selected currency. The field is displayed only if the Tax.IncludeInTaxable field is set to "true" (that is, the Include in VAT Exempt Total check box is selected on the Taxes (TX205000) form).
	`DrCr`	`char(1)`	Disb./Receipt	-
Description:No description available
	`EntryTypeID`Default Navigation	`nvarchar(10)`	Entry Type	CAEntryType
Description:No description available
	`ExtRefNbr`	`nvarchar(40)`	Document Ref.	-
Description:No description available
	`FinPeriodID`Default Navigation	`char(6)`	Fin. Period	-
Description:No description available
	`HasUseTax`Nonexistent in DB	`bit`		-
Description:Specifies (if set to "true") that use taxes are applied to the document. This is a technical field, which is calculated on the fly and is used to restrict the values of the TaxCalcMode field.
	`HasWithHoldTax`Nonexistent in DB	`bit`		-
Description:Specifies (if set to "true") that withholding taxes are applied to the document. This is a technical field, which is calculated on the fly and is used to restrict the values of the TaxCalcMode field.
	`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
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`PaymentsReclassification`	`bit`		-
Description:Specifies (if set to "true") that this transaction is used for payments reclassification. Corresponds to the value of the CAEntryType.UseToReclassifyPayments field of the selected entry type.
	`Released`	`bit`	Released	-
Description:No description available
	`SplitTotal`	`decimal(19, 4)`		-
Description:The sum of amounts of all detail lines in the base currency.
	`SubID`Default Navigation	`int`	Offset Subaccount	Sub
Description:No description available
	`TaxableAmt`	`decimal(19, 4)`	Amount	-
Description:No description available
	`TaxAmt`	`decimal(19, 4)`		-
Description:The tax amount to be paid for the document in the base currency.
	`TaxCalcMode`	`char(1)`	Tax Calculation Mode	-
Description:No description available
	`TaxCategoryID`Default Navigation	`nvarchar(15)`	Tax Category	TaxCategory
Description:No description available
	`TaxRoundDiff`	`decimal(19, 4)`		-
Description:The difference between the original document amount and the rounded amount in the base currency.
	`TaxTotal`	`decimal(19, 4)`		-
Description:The total amount of tax paid on the document in the base currency.
	`TaxZoneID`Default Navigation	`nvarchar(10)`	Tax Zone	TaxZone
Description:The tax zone that applies to the transaction. Corresponds to the value of the TaxZone.TaxZoneID field.
	`TranAmt`	`decimal(19, 4)`	Total Amount	-
Description:No description available
	`TranDate`	`datetime2`	Doc. Date	-
Description:No description available
	`TranDesc`	`nvarchar(256)`	Description	-
Description:No description available
	`TranPeriodID`	`char(6)`		-
Description:No description available
	`tstamp`	`timestamp`		-
Description:No description available
	`VatExemptTotal`	`decimal(19, 4)`		-
Description:The document total that is exempt from VAT in the base currency.
	`VatTaxableTotal`	`decimal(19, 4)`		-
Description:The document total that is subjected to VAT in the base currency.