CAAdj

PX.Objects.CA

View API Entity: CashTransaction/entity/Default/24.200.001/CashTransaction

74 of 74 fields

	Field Name	Type	Display Name	Foreign Key
	`AdjRefNbr`Default Navigation	`nvarchar(15)`	Reference Nbr.	-
Description:No description available
	`AdjTranType`	`char(3)`	Tran. Type	-
Description:The type of the cash transaction. On the Transactions (CA304000) form, transactions of the only Cash Entry type are created. The field can have one of the following values: ""CTE"": Expense entry, ""CAE"": Cash entry.
	`Approved` API	`bit`	Approved	-
Description:Specifies (if set to "true") that the transaction has been approved by a responsible person. This field is displayed if the CASetup.RequestApproval field is set to "true".
	`BranchID`Default Navigation	`int`	Branch	Branch
Description:The branch of the cash transaction.
	`CABankTranRefNoteID`	`uniqueidentifier`		-
Description:No description available
	`CashAccountID`Default Navigation	`int`	Cash Account	CashAccount
Description:No description available
	`ClearDate`	`datetime2`	Clear Date	-
Description:The date when the transaction was cleared.
	`Cleared`	`bit`	Cleared	-
Description:Specifies (if set to "true") that the transaction was cleared.
	`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`	Created On	-
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:The currency of the cash transaction. Corresponds to the currency of the CashAccount.CuryID cash account.
	`CuryInfoID`	`bigint`		CurrencyInfo
Description:The identifier of the exchange rate record for the deposit. Corresponds to the CurrencyInfo.CuryInfoID field.
	`CurySplitTotal`	`decimal(19, 4)`	Detail Total	-
Description:The sum of amounts of all detail lines in the selected currency.
	`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)`	Amount	-
Description:The amount of the transaction in the selected currency.
	`CuryVatExemptTotal`	`decimal(19, 4)`	Tax 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)`	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).
	`DepositAfter`	`datetime2`	Deposit After	-
Description:Informational date specified on the document, which is the source of the deposit.
	`DepositAsBatch`	`bit`	Batch Deposit	-
Description:When set to "true" indicates that the transaction can be included in a deposit.
	`DepositDate`Nonexistent in DB	`datetime`	Batch Deposit Date	-
Description:The date of deposit.
	`Deposited`	`bit`	Deposited	-
Description:When equal to "true" indicates that the transaction was deposited.
	`DepositNbr`Default Navigation	`nvarchar(15)`	Batch Deposit Nbr.	CADeposit
Description:The reference number of the deposit document.
	`DepositType`	`char(3)`		-
Description:The type of the deposit document.
	`DontApprove`	`bit`	Don't Approve	-
Description:Indicates that the current document should be excluded from the approval process.
	`Draft`	`bit`	Draft	-
Description:Specifies (if set to "true") that the adjustment was created on the Journal Vouchers (GL304000) form and the parent GLDocBatch record of the adjustment has the ""On Hold"" status.
	`DrCr`	`char(1)`	Disbursement/Receipt	-
Description:The basic type of the transaction: Receipt or Disbursement.
	`EmployeeID`Default Navigation	`int`	Owner	EPEmployee
Description:The user who created the cash transaction.
	`EntityUsageType`	`char(1)`	Tax Exemption Type	-
Description:No description available
	`EntryTypeID`Default Navigation	`nvarchar(10)`	Entry Type	CAEntryType
Description:No description available
	`ExternalTaxExemptionNumber`	`nvarchar(30)`	Tax Exemption Number	-
Description:No description available
	`ExtRefNbr`	`nvarchar(40)`	Document Ref.	-
Description:The reference number of the external document.
	`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.
	`Hold`	`bit`	Hold	-
Description:Specifies (if set to "true") that the cash transaction is on hold, which means that it can be edited but cannot be released.
	`IsTaxPosted`	`bit`	Tax Is Posted/Committed to External Tax Engine (Avalara)	-
Description:Specifies (if set to "true") that the transaction's tax is posted or committed to the external tax provider.
	`IsTaxSaved`	`bit`	Tax has been saved in the external tax provider	-
Description:Specifies (if set to "true") that the transaction's tax is saved in the external tax provider.
	`IsTaxValid`	`bit`	Tax Is Up to Date	-
Description:Specifies (if set to "true") that the transaction's tax is validated by the external tax provider.
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime`	`datetime`	Last Modified On	-
Description:No description available
	`LineCntr`	`int`		-
Description:The counter of child CASplit records. "PXParentAttribute" of the CASplit.LineNbr field refers to this field.
	`NonTaxable`	`bit`	Non-Taxable	-
Description:Get or set NonTaxable that mark current document does not impose sales taxes.
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`OrigAdjRefNbr`Default Navigation	`nvarchar(15)`	Orig. Ref. Nbr.	CAAdj
Description:No description available
	`OrigAdjTranType`	`char(3)`	Orig. Tran. Type	-
Description:The type of the original cash transaction.
	`OwnerID`Default NavigationNonexistent in DB	`int`	Approver	Contact
Description:The ID of the employee who was assigned to approve the transaction.
	`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.
	`Rejected`	`bit`	Reject	-
Description:Specifies (if set to "true") that the transaction has been rejected by a responsible person. When the transaction has been rejected, its status changes to On Hold.
	`Released`	`bit`		-
Description:Specifies (if set to "true") that the transaction was released.
	`ReverseCount`Nonexistent in DB	`int`	Reversing Transactions	-
Description:The read-only field, reflecting the number of transactions in the system, which reverse this transaction. This field is populated only by the CATranEntry graph, which corresponds to the Cash Entry (CA304000) form.
	`Selected`Nonexistent in DB	`bit`	Selected	-
Description:No description available
	`SplitTotal`	`decimal(19, 4)`		-
Description:The sum of amounts of all detail lines in the base currency.
	`Status`	`char(1)`	Status	-
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
	`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)`	Tran. Amount	-
Description:The amount of the transaction in the base currency.
	`TranDate`	`datetime2`	Tran. Date	-
Description:The date of the transaction.
	`TranDesc`	`nvarchar(512)`	Description	-
Description:The description of the transaction.
	`TranID`Default Navigation	`bigint`		CATran
Description:The identifier of the transaction that is recorded to the cash account. Corresponds to the CATran.TranID field.
	`TranPeriodID`	`char(6)`		-
Description:financial period of the document. Is determined by the date of the cash transaction. Unlike FinPeriodID the value of this field can't be overridden by a user.
	`TransferNbr`Obsolete	`nvarchar(15)`		-
Description:The unique identifier of the cash transfer. Corresponds to the value of the CATransfer.TransferNbr field. The value of the field can be empty. If the value of the field is not empty, this cash transaction is an expense entry (AdjTranType is ""CTE""), which was created on the Funds Transfers (CA301000) form. Then this cash transaction is an expense entry from the form Funds Transfer (CA301000).
	`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.
	`WorkgroupID`Default NavigationNonexistent in DB	`int`	Approval Workgroup ID	EPCompanyTree
Description:The ID of the workgroup which was assigned to approve the transaction.