Skip to main content
CA

CATransfer

PX.Objects.CA
Field NameTypeDisplay NameForeign Key
TransferNbrDefault Navigation
nvarchar(15)Transfer NumberCATransfer
Description:The user-friendly unique identifier of the transfer. This field is the auto-numbering key field.
BaseCuryIDNonexistent in DB
nvarchar(5)BaseCuryID-
Description:No description available
CashBalanceInNonexistent in DB
decimalAvailable Balance-
Description:The actual balance of the target cash account.
CashBalanceOutNonexistent in DB
decimalAvailable Balance-
Description:The actual balance of the source cash account.
ClearDateIn
datetime2Clear Date-
Description:The date when the incoming transaction was cleared in the process of reconciliation.
ClearDateOut
datetime2Clear Date-
Description:The date when the outcoming transaction was cleared in the process of reconciliation.
ClearedIn
bitCleared-
Description:Indicates (if set to "true") that this incoming transaction has been cleared.
ClearedOut
bitCleared-
Description:Indicates (if set to "true") that this outcoming transaction has been cleared.
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime
datetimeCreated On-
Description:No description available
CuryTranIn
decimal(19, 4)Destination Amount-
Description:The amount of the transfer incomes to the destination cash account (in the specified currency).
CuryTranOut
decimal(19, 4)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
bitHold-
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.
InAccountIDDefault Navigation
intDestination AccountCashAccount
Description:The identifier of the destination cash account to which the funds are transferred. Corresponds to the value of the CashAccount.CashAccountID field.
InBranchIDDefault Navigation
intDestination BranchBranch
Description:No description available
InCuryIDDefault Navigation
nvarchar(5)Destination CurrencyCurrency
Description:The currency of denomination for the destination cash account.
InCuryInfoID
bigintCurrencyInfo
Description:The identifier of the exchange rate record for the incoming amount. Corresponds to the CurrencyInfo.CuryInfoID field.
InDate
datetime2Receipt 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
decimalGL Balance-
Description:The balance of the target account, as recorded in the General Ledger.
InPeriodIDDefault Navigation
char(6)In Period-
Description:No description available
InTranPeriodID
char(6)-
Description:No description available
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
char(8)-
Description:No description available
LastModifiedDateTime
datetimeLast Modified On-
Description:No description available
NoteID
uniqueidentifier-
Description:No description available
OrigTransferNbrDefault Navigation
nvarchar(15)Orig. Tran. Nbr.-
Description:The number of the original transfer.
OutAccountIDDefault Navigation
intCash AccountCashAccount
Description:The identifier of the source cash account from which the funds are transferred. Corresponds to the value of the CashAccount.CashAccountID field.
OutBranchIDDefault Navigation
intSource BranchBranch
Description:No description available
OutCuryIDDefault Navigation
nvarchar(5)Source CurrencyCurrency
Description:The currency of denomination for the source cash account.
OutCuryInfoIDDefault Navigation
bigintCurrencyInfo
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
datetime2Transfer 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
decimalGL 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.
OutPeriodIDDefault Navigation
char(6)Out Period-
Description:No description available
OutTranPeriodID
char(6)-
Description:No description available
Released
bit-
Description:Specifies (if set to "true") that the transfer is released.
ReverseCountNonexistent in DB
intReversing 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.
RGOLAmt
decimal(19, 4)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.
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
decimalTotal Charges-
Description:No description available
TranIDInDefault Navigation
bigintCATran
Description:The unique identifier of the incoming CA transaction. Corresponds to the value of the CATran.TranID field.
TranIDIn_CATran_batchNbrDefault NavigationNonexistent in DB
nvarchar(15)Batch NumberBatch
Description:The number of the batch that contains the transaction for the target account in the General Ledger.
TranIDOutDefault Navigation
bigintCATran
Description:The unique identifier of the outcoming CA transaction. Corresponds to the value of the CATran.TranID field.
TranIDOut_CATran_batchNbrDefault NavigationNonexistent in DB
nvarchar(15)Batch NumberBatch
Description:The batch number for the transfer. Only released transfers have batch numbers.
TranIn
decimal(19, 4)Base Currency Amount-
Description:The amount of the transfer incomes to the destination cash account (in the base currency).
TranOut
decimal(19, 4)Base Currency Amount-
Description:The amount of the transfer outcomes from the source cash account (in the base currency).
TransitAcctIDDefault Navigation
intCash-In-Transit AccountAccount
Description:No description available
TransitSubIDDefault Navigation
intCash-In-Transit SubaccountSub
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