Skip to main content
CA

CAAdj

PX.Objects.CAScreensCA304000CA501600Release 2025.2

The main properties of CA transactions. CA transaction are edited on the Cash Transactions (CA304000) form (which corresponds to the CATranEntry graph).

Field NameTypeDisplay NameForeign Key
AdjRefNbrDefault Navigation
nvarchar(15)Reference Nbr.-
Description:The user-friendly unique identifier assigned to the cash transaction in accordance with the numbering sequence. This field is the key field.
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
bitApproved-
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".
BranchIDDefault Navigation
intBranchBranch
Description:The branch of the cash transaction.
CABankTranRefNoteID
uniqueidentifier-
Description:No description available
CashAccountID API Default Navigation
intCash AccountCashAccount
Description:The cash account that is the source account for the transaction.
ClearDate
datetimeClear Date-
Description:The date when the transaction was cleared.
Cleared
bitCleared-
Description:Specifies (if set to "true") that the transaction was cleared.
ControlAmt
decimal-
Description:The control total of the transaction in the base currency.
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime
datetimeCreated On-
Description:No description available
CuryControlAmt
decimalControl 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.
CuryIDDefault Navigation
nvarchar(5)CurrencyCurrency
Description:The currency of the cash transaction. Corresponds to the currency of the CashAccount.CuryID cash account.
CuryInfoID
bigintCurrencyInfo
Description:The identifier of the exchange rate record for the deposit. Corresponds to the CurrencyInfo.CuryInfoID field.
CurySplitTotal
decimalDetail Total-
Description:The sum of amounts of all detail lines in the selected currency.
CuryTaxAmt
decimalTax 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
decimalRounding Diff.-
Description:The difference between the original document amount and the rounded amount in the selected currency.
CuryTaxTotal
decimalTax Total-
Description:The total amount of tax paid on the document in the selected currency.
CuryTranAmt
decimalAmount-
Description:The amount of the transaction in the selected currency.
CuryVatExemptTotal
decimalTax 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
decimalTaxable 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
datetimeDeposit After-
Description:Informational date specified on the document, which is the source of the deposit.
DepositAsBatch
bitBatch Deposit-
Description:When set to "true" indicates that the transaction can be included in a deposit.
DepositDateNonexistent in DB
DateTime?Batch Deposit Date-
Description:The date of deposit.
DepositNbrDefault 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.
Deposited
bitDeposited-
Description:When equal to "true" indicates that the transaction was deposited.
DontApprove
bitDon't Approve-
Description:Indicates that the current document should be excluded from the approval process.
DrCr
char(1)Disbursement/Receipt-
Description:The basic type of the transaction: Receipt or Disbursement.
Draft
bitDraft-
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.
EmployeeIDDefault Navigation
intOwnerEPEmployee
Description:The user who created the cash transaction.
EntityUsageType
char(1)Tax Exemption Type-
Description:The entity usage type for reporting purposes. The field is used if the system is integrated with External Tax Calculation and the External Tax Calculation Integration feature is enabled. The field can have one of the values described in . Defaults to the Tax Exemption Type that is specified for the location of the branch.
EntryTypeID API Default Navigation
nvarchar(10)Entry TypeCAEntryType
Description:The user-defined transaction type. Selects the appropriate type from the list of entry types defined for the selected cash account.
ExtRefNbr API
nvarchar(40)Document Ref.-
Description:The reference number of the external document.
ExternalTaxExemptionNumber
nvarchar(30)Tax Exemption Number-
Description:The tax exemption number for reporting purposes. The field is used if the system is integrated with External Tax Calculation and the External Tax Calculation Integration feature is enabled.
FinPeriodIDDefault Navigation
stringFin. PeriodFinPeriod
Description:financial period of the document. Defaults to the period to which the APRegister.DocDate belongs, but can be overridden by a user.
FormCaptionDescriptionNonexistent in DB
string-
Description:No description available
HasUseTaxNonexistent in DB
bool?-
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.
HasWithHoldTaxNonexistent in DB
bool?-
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
bitHold-
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
bitTax 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
bitTax 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
bitTax Is Up to Date-
Description:Specifies (if set to "true") that the transaction's tax is validated by the external tax provider.
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
char(8)-
Description:No description available
LastModifiedDateTime
datetimeLast 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
bitNon-Taxable-
Description:Get or set NonTaxable that mark current document does not impose sales taxes.
NoteID
uniqueidentifier-
Description:No description available
OrigAdjRefNbrDefault Navigation
nvarchar(15)Orig. Ref. Nbr.CAAdj
Description:The number of the original CA transaction.
OrigAdjTranType
char(3)Orig. Tran. Type-
Description:The type of the original cash transaction.
OwnerIDDefault Navigation
intApproverContact
Description:The ID of the employee who was assigned to approve the transaction.
PaymentsReclassificationNonexistent in DB
bool?-
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
bitReject-
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.
ReverseCountNonexistent 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.
SelectedNonexistent in DB
bool?Selected-
Description:No description available
SplitTotal
decimal-
Description:The sum of amounts of all detail lines in the base currency.
Status
char(1)Status-
Description:The status of the cash transaction. The field can have one of the values described in CATransferStatus.ListAttribute.
TaxAmt
decimal-
Description:The tax amount to be paid for the document in the base currency.
TaxCalcMode
char(1)Tax Calculation Mode-
Description:The tax calculation mode, which defines which amounts (tax-inclusive or tax-exclusive) should be entered in the detail lines of a document. This field is displayed only if the FeaturesSet.NetGrossEntryMode field is set to "true". The field can have one of the following values: ""T"" (Tax Settings): The tax amount for the document is calculated according to the settings of the applicable tax or taxes. ""G"" (Gross): The amount in the document detail line includes a tax or taxes. ""N"" (Net): The amount in the document detail line does not include taxes.
TaxRoundDiff
decimal-
Description:The difference between the original document amount and the rounded amount in the base currency.
TaxTotal
decimal-
Description:The total amount of tax paid on the document in the base currency.
TaxZoneIDDefault Navigation
nvarchar(10)Tax ZoneTaxZone
Description:The tax zone that applies to the transaction. Corresponds to the value of the TaxZone.TaxZoneID field.
TranAmt
decimalTran. Amount-
Description:The amount of the transaction in the base currency.
TranDate API
datetimeTran. Date-
Description:The date of the transaction.
TranDesc API
nvarchar(512)Description-
Description:The description of the transaction.
TranIDDefault Navigation
bigintCATran
Description:The identifier of the transaction that is recorded to the cash account. Corresponds to the CATran.TranID field.
TranPeriodID
string-
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.
TransferNbrObsolete
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).
VatExemptTotal
decimal-
Description:The document total that is exempt from VAT in the base currency.
VatTaxableTotal
decimal-
Description:The document total that is subjected to VAT in the base currency.
WorkgroupIDDefault NavigationNonexistent in DB
int?Approval Workgroup IDEPCompanyTree
Description:The ID of the workgroup which was assigned to approve the transaction.
tstamp
timestamp-
Description:No description available