CA
CAAdj
The main properties of CA transactions. CA transaction are edited on the Cash Transactions (CA304000) form (which corresponds to the CATranEntry graph).
View API Entity: CashTransaction
/entity/Default/25.200.001/CashTransaction| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AdjRefNbr | 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 | 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 | int | Branch | Branch | |
Description:The branch of the cash transaction. | ||||
CABankTranRefNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
CashAccountID API | int | Cash Account | CashAccount | |
Description:The cash account that is the source account for the transaction. | ||||
ClearDate | datetime | 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 | - | ||
Description:The control total of the transaction in the base currency. | ||||
CreatedByID | 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 | 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 | 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 | Detail Total | - | |
Description:The sum of amounts of all detail lines in the selected currency. | ||||
CuryTaxAmt | decimal | 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 | Rounding Diff. | - | |
Description:The difference between the original document amount and the rounded amount in the selected currency. | ||||
CuryTaxTotal | decimal | Tax Total | - | |
Description:The total amount of tax paid on the document in the selected currency. | ||||
CuryTranAmt | decimal | Amount | - | |
Description:The amount of the transaction in the selected currency. | ||||
CuryVatExemptTotal | decimal | 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 | 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 | datetime | 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. | ||||
DepositDateNonexistent in DB | DateTime? | Batch Deposit Date | - | |
Description:The date of deposit. | ||||
DepositNbr | 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 | bit | Deposited | - | |
Description:When equal to "true" indicates that the transaction was deposited. | ||||
DontApprove | bit | Don'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 | 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. | ||||
EmployeeID | int | Owner | EPEmployee | |
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 | nvarchar(10) | Entry Type | CAEntryType | |
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. | ||||
FinPeriodID | string | Fin. Period | FinPeriod | |
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 | 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 | 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 | 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. | ||||
OwnerID | int | Approver | Contact | |
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 | 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. | ||||
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. | ||||
TaxZoneID | 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 | Tran. Amount | - | |
Description:The amount of the transaction in the base currency. | ||||
TranDate API | datetime | Tran. Date | - | |
Description:The date of the transaction. | ||||
TranDesc API | nvarchar(512) | Description | - | |
Description:The description of the transaction. | ||||
TranID | bigint | CATran | ||
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. | ||||
WorkgroupIDNonexistent in DB | int? | Approval Workgroup ID | EPCompanyTree | |
Description:The ID of the workgroup which was assigned to approve the transaction. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||