CA
CATransfer
The main properties of funds transfers and their classes. Funds transfers are edited on the Funds Transfers (CA301000) form (which corresponds to the CashTransferEntry graph).
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BaseCuryIDNonexistent in DB | string | - | ||
Description:The identifier of the base currency for the transfer. | ||||
CashBalanceInNonexistent in DB | decimal? | Available Balance | - | |
Description:The actual balance of the target cash account. | ||||
CashBalanceOutNonexistent in DB | decimal? | Available Balance | - | |
Description:The actual balance of the source cash account. | ||||
ClearDateIn | datetime | Clear Date | - | |
Description:The date when the incoming transaction was cleared in the process of reconciliation. | ||||
ClearDateOut | datetime | Clear Date | - | |
Description:The date when the outcoming transaction was cleared in the process of reconciliation. | ||||
ClearedIn | bit | Cleared | - | |
Description:Indicates (if set to "true") that this incoming transaction has been cleared. | ||||
ClearedOut | bit | Cleared | - | |
Description:Indicates (if set to "true") that this outcoming transaction has been cleared. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
CuryTranIn | decimal | Destination Amount | - | |
Description:The amount of the transfer incomes to the destination cash account (in the specified currency). | ||||
CuryTranOut | decimal | Source Amount | - | |
Description:The amount of the transfer outcomes from the source cash account (in the specified currency). | ||||
Descr | nvarchar(256) | Description | - | |
Description:A detailed description for the transfer transaction. An alphanumeric string of up to 60 characters may be used. | ||||
ExpenseCntr | int | - | ||
Description:No description available | ||||
Hold | bit | Hold | - | |
Description:Indicates (if set to "true") that the transfer is on hold. The value of the field can be set to "false" only for balanced transfers. | ||||
InAccountCuryIDNonexistent in DB | string | - | ||
Description:No description available | ||||
InAccountID | int | Destination Account | CashAccount | |
Description:The identifier of the destination cash account to which the funds are transferred. Corresponds to the value of the CashAccount.CashAccountID field. | ||||
InBranchID | int | Destination Branch | Branch | |
Description:No description available | ||||
InCuryID | nvarchar(5) | Destination Currency | Currency | |
Description:The currency of denomination for the destination cash account. | ||||
InCuryInfoID | bigint | CurrencyInfo | ||
Description:The identifier of the exchange rate record for the incoming amount. Corresponds to the CurrencyInfo.CuryInfoID field. | ||||
InDate | datetime | Receipt Date | - | |
Description:The date of the transfer receipt. | ||||
InExtRefNbr | nvarchar(40) | Document Ref. | - | |
Description:The reference number of the transfer for the target cash account. This is a number provided by an external bank or organization. The value of the field is entered by a user. | ||||
InGLBalanceNonexistent in DB | decimal? | GL Balance | - | |
Description:The balance of the target account, as recorded in the General Ledger. | ||||
InPeriodID | string | In Period | FinPeriod | |
Description:No description available | ||||
InTranPeriodID | string | - | ||
Description:No description available | ||||
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 | ||||
NoteID | uniqueidentifier | - | ||
Description:A global unique identifier of the transfer in Acumatica ERP. The field is used for attachments for the transfer (such as notes, files). Corresponds to the value of the Note.NoteID field. | ||||
OrigTransferNbr | nvarchar(15) | Orig. Tran. Nbr. | CATransfer | |
Description:The number of the original transfer. | ||||
OutAccountCuryIDNonexistent in DB | string | - | ||
Description:No description available | ||||
OutAccountID | int | Cash Account | CashAccount | |
Description:The identifier of the source cash account from which the funds are transferred. Corresponds to the value of the CashAccount.CashAccountID field. | ||||
OutBranchID | int | Source Branch | Branch | |
Description:No description available | ||||
OutCuryID | nvarchar(5) | Source Currency | Currency | |
Description:The currency of denomination for the source cash account. | ||||
OutCuryInfoID | bigint | CurrencyInfo | ||
Description:The identifier of the exchange rate record for the outcoming amount. Corresponds to the CurrencyInfo.CuryInfoID field. | ||||
OutCuryRateNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
OutDate | datetime | Transfer Date | - | |
Description:The date of the transaction (when funds were withdrawn from the source cash account). | ||||
OutExtRefNbr | nvarchar(40) | Document Ref. | - | |
Description:The reference number of the transfer for the source cash account. This is a number provided by an external bank or organization. This field is entered manually. | ||||
OutGLBalanceNonexistent in DB | decimal? | GL Balance | - | |
Description:A read-only box displaying the balance of the source account recorded in the General Ledger for the financial period that includes the transfer date. | ||||
OutPeriodID | string | Out Period | FinPeriod | |
Description:No description available | ||||
OutTranPeriodID | string | - | ||
Description:No description available | ||||
RGOLAmt | decimal | RGOL | - | |
Description:A read-only box that displays the difference between the amount in the base currency specified for the source account and the amount in the base currency resulting for the destination cash account, for cases when the source and destination currencies are different. | ||||
Released | bit | - | ||
Description:Specifies (if set to "true") that the transfer is 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 CashTransferEntry graph, which corresponds to the Funds Transfers CA301000 form. | ||||
Status | char(1) | Status | - | |
Description:The status of the transfer. The field can have one of the values described in CATransferStatus.ListAttribute. | ||||
TotalExpensesNonexistent in DB | decimal? | Total Charges | - | |
Description:The sum of total amounts of the charges linked to the transfer (in the base currency). | ||||
TranIDIn | bigint | Currency | ||
Description:The unique identifier of the incoming CA transaction. Corresponds to the value of the CATran.TranID field. | ||||
TranIDIn_CATran_batchNbrNonexistent in DB | string | Batch Number | Batch | |
Description:The number of the batch that contains the transaction for the target account in the General Ledger. | ||||
TranIDOut | bigint | Currency | ||
Description:The unique identifier of the outcoming CA transaction. Corresponds to the value of the CATran.TranID field. | ||||
TranIDOut_CATran_batchNbrNonexistent in DB | string | Batch Number | Batch | |
Description:The batch number for the transfer. Only released transfers have batch numbers. | ||||
TranIn | decimal | Base Currency Amount | - | |
Description:The amount of the transfer incomes to the destination cash account (in the base currency). | ||||
TranOut | decimal | Base Currency Amount | - | |
Description:The amount of the transfer outcomes from the source cash account (in the base currency). | ||||
TransferNbr | nvarchar(15) | Transfer Number | - | |
Description:The user-friendly unique identifier of the transfer. This field is the auto-numbering key field. | ||||
TransitAcctID | int | Cash-In-Transit Account | Account | |
Description:The special multi-currency asset account used (when necessary) as an intermediate account for currency conversions performed during funds transfers. Corresponds to the value of the Account.accountID field. | ||||
TransitSubID | int | Cash-In-Transit Subaccount | Sub | |
Description:The special multi-currency asset subaccount used (when necessary) as an intermediate account for currency conversions performed during funds transfers. Corresponds to the value of the Sub.SubID field. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||