CA
CADeposit
PX.Objects.CA46 of 46 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
RefNbr | nvarchar(15) | Reference Nbr. | - | |
Description:The reference number of the deposit. This field is a part of the compound key of the deposit. | ||||
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. | ||||
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"". | ||||
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. | ||||
ChargeTotal | decimal(19, 4) | - | ||
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. | ||||
ClearDate | datetime2 | 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(19, 4) | - | ||
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(19, 4) | Charge Total | - | |
Description:The total amount of any charges that apply to the deposit in the selected currency. | ||||
CuryControlAmt | decimal(19, 4) | Control Total | - | |
Description:The control total of the deposit, which should be equal to the total amount in the selected currency. | ||||
CuryDetailTotal | decimal(19, 4) | Deposits Total | - | |
Description:The line total amount of the deposit in the selected currency. | ||||
CuryExtraCashTotal | decimal(19, 4) | 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(19, 4) | Total Amount | - | |
Description:The total amount of the deposit, including the cash amount minus the charge total amount in the selected currency. | ||||
DetailTotal | decimal(19, 4) | - | ||
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. | ||||
ExtraCashAccountID | int | Cash Drop Account | CashAccount | |
Description:No description available | ||||
ExtraCashTotal | decimal(19, 4) | - | ||
Description:The total amount of cash to be deposited through this deposit in the base currency. | ||||
ExtRefNbr | nvarchar(40) | Document Ref. | - | |
Description:The external reference number of the deposit. | ||||
FinPeriodID | char(6) | Fin. Period | - | |
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. | ||||
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(19, 4) | Tran Amount | - | |
Description:The total amount of the deposit, including the cash amount minus the charge total amount in the base currency. | ||||
TranDate | datetime2 | 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 | char(6) | - | ||
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). | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
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. | ||||