CA
CADeposit
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CashAccountID | int | Cash Account | CashAccount | |
Description:The cash account (usually a bank account) to which the deposit will be posted. | ||||
CashTranID | bigint | CATran | ||
Description:The identifier of the cash drop transaction. Corresponds to the CATran.TranID field. The field can be empty. | ||||
ChargeMultNonexistent in DB | decimal? | Control Total | - | |
Description:The coefficient of the charge total amount in the calculation of the deposit total amount. The field depends on the ChargesSeparate field. The field is read-only; it is not displayed on any Acumatica ERP form. This is virtual field and has no representation in the database. If the charges for the deposit are specified by a separate transaction (that is, if the ChargesSeparate field is set to "true"), the value of the field is ""decimal.Zero"". If the charges for the deposit are deducted from the deposit amount (that is, if the ChargesSeparate field is set to "false"), the value of the field is ""decimal.MinusOne"". | ||||
ChargeTotal | decimal | - | ||
Description:The total amount of any charges that apply to the deposit in the base currency. | ||||
ChargeTranID | bigint | CATran | ||
Description:The identifier of the cash transaction made for deposit charges. Corresponds to the CATran.TranID field. | ||||
ChargesSeparate | bit | Separate Charges | - | |
Description:Specifies (if set to "true") that the charges for the deposit will be booked as a separate transaction in GL. If the field is set to "false", charges will be deducted from the deposit amount. | ||||
ClearDate | datetime | Clear Date | - | |
Description:The date when the deposit has been cleared with the bank reconciliation statement. | ||||
Cleared | bit | Cleared | - | |
Description:A check box that indicates (if selected) that the deposit was cleared with the bank. | ||||
ControlAmt | decimal | - | ||
Description:The control total of the deposit, which should be equal to the total amount 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 | ||||
CuryChargeTotal | decimal | Charge Total | - | |
Description:The total amount of any charges that apply to the deposit in the selected currency. | ||||
CuryControlAmt | decimal | Control Total | - | |
Description:The control total of the deposit, which should be equal to the total amount in the selected currency. | ||||
CuryDetailTotal | decimal | Deposits Total | - | |
Description:The line total amount of the deposit in the selected currency. | ||||
CuryExtraCashTotal | decimal | Cash Drop Amount | - | |
Description:The total amount of cash to be deposited through this deposit in the selected currency. | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:The currency of the deposit. Corresponds to the currency of the cash account CashAccount.CuryID. | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:The identifier of the exchange rate record for the deposit. Corresponds to the CurrencyInfo.CuryInfoID field. | ||||
CuryTranAmt | decimal | Total Amount | - | |
Description:The total amount of the deposit, including the cash amount minus the charge total amount in the selected currency. | ||||
DetailTotal | decimal | - | ||
Description:The line total amount of the deposit in the base currency. | ||||
DrCr | char(1) | - | ||
Description:The balance type of the deposit. The field can have one of the following values: ""D"": Receipt, ""C"": Disbursement. | ||||
ExtRefNbr | nvarchar(40) | Document Ref. | - | |
Description:The external reference number of the deposit. | ||||
ExtraCashAccountID | int | Cash Drop Account | CashAccount | |
Description:The cash account (usually a Cash On Hand account) from which you want to also deposit some amount on the bank account. | ||||
ExtraCashTotal | decimal | - | ||
Description:The total amount of cash to be deposited through this deposit in the base currency. | ||||
FinPeriodID | string | Fin. Period | FinPeriod | |
Description:Financial Period of the document. Defaults to the period to which the CADeposit.TranDate belongs, but can be overridden by a user. | ||||
FormCaptionDescriptionNonexistent in DB | string | - | ||
Description:No description available | ||||
Hold | bit | Hold | - | |
Description:A check box that indicates (if selected) that the deposit is on hold, which means it may be edited but cannot be released. | ||||
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 detail lines. The field depends on CADepositDetail.LineNbr. | ||||
LineCntrCharge | int | - | ||
Description:The counter of Charges detail lines. The field depends on CADepositCharge.LineNbr. | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OwnerID | int | Owner | Contact | |
Description:The owner of the deposit, which is the employee who controls the processing. | ||||
RefNbr | nvarchar(15) | Reference Nbr. | - | |
Description:The reference number of the deposit. This field is a part of the compound key of the deposit. | ||||
Released | bit | - | ||
Description:Specifies (if set to "true") that the deposit is released. | ||||
Status | char(1) | Status | - | |
Description:The status of the deposit, which the system assigns automatically. This is virtual field and has no representation in the database. The field can have one of the following values: ""H"": On Hold; ""B"": Balanced; ""R"": Released; ""V"": Voided. | ||||
TranAmt | decimal | Tran Amount | - | |
Description:The total amount of the deposit, including the cash amount minus the charge total amount in the base currency. | ||||
TranDate | datetime | Deposit Date | - | |
Description:The date of the deposit. | ||||
TranDesc | nvarchar(256) | Description | - | |
Description:A detailed description of the deposit. | ||||
TranID | bigint | CATran | ||
Description:The identifier of the deposit-related cash transaction that recorded to the cash account (usually a bank account). Corresponds to the CATran.TranID field. | ||||
TranPeriodID | string | - | ||
Description:The financial period of the document. Is determined by the date of the document. A user can override the value of this field (unlike CADeposit.FinPeriodID). | ||||
TranType | char(3) | Tran. Type | - | |
Description:The type of the deposit. This field is a part of the compound key of the deposit. The field can have one of the following values: ""CDT"": CA Deposit, ""CVD"": CA Void Deposit. | ||||
Voided | bit | Voided | - | |
Description:Specifies (if set to "true") that the deposit is voided. | ||||
WorkgroupID | int | Workgroup | EPCompanyTree | |
Description:The workgroup to which the deposit is assigned for processing. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||