CADepositDetail

PX.Objects.CA

30 of 30 fields

	Field Name	Type	Display Name	Foreign Key
	`LineNbr`	`int`	Line Nbr.	-
Description:The line number of the detail line. The CADeposit.lineCntr field depends on this field. This field is a part of the compound key of DepositDetail.
	`RefNbr`	`nvarchar(15)`	Reference Nbr.	CADeposit
Description:No description available
	`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.
	`CashAccountID`Default Navigation	`int`	Cash Account	CashAccount
Description:The cash account to hold the payment.
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`		-
Description:No description available
	`CuryInfoID`	`bigint`		CurrencyInfo
Description:The identifier of the exchange rate record for the deposit. Corresponds to the CurrencyInfo.CuryInfoID field.
	`CuryOrigAmt`	`decimal(19, 4)`	Original Amount	-
Description:The amount of the original payment document in the selected currency.
	`CuryTranAmt`	`decimal(19, 4)`	Deposit Amount	-
Description:The amount of the payment to be deposited in the selected currency.
	`DetailType`	`char(3)`	Detail. Type	-
Description:The type of the delail, which is one of the following options: ""CHD"": Check Deposit; ""VCD"": Void Check Deposit; ""CSD"": Cash Deposit; ""VSD"": Void Cash Deposit.
	`DrCr`	`char(1)`	Disb. / Receipt	-
Description:The balance type of the DepositDetail line. The field can have one of the following values: ""D"": Receipt; ""C"": Disbursement.
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime`	`datetime`		-
Description:No description available
	`OrigAmt`	`decimal(19, 4)`		-
Description:The amount of the original payment document in the base currency.
	`OrigCuryID`Default Navigation	`nvarchar(5)`	Currency	Currency
Description:The currency of the deposit detail, which corresponds to the currency of the cash account (CashAccount.CashAccountID).
	`OrigCuryInfoID`	`bigint`		CurrencyInfo
Description:The currency of the original payment document, which corresponds to the currency of the cash account (CashAccount.CuryID).
	`OrigDocSign`Nonexistent in DB	`decimal`		-
Description:The sign of the amount.
	`OrigDocType`	`char(3)`	Doc.Type	-
Description:The type of the payment, which is one of the following options: Payment, Credit Memo, Prepayment, or Refund.
	`OrigDrCr`	`char(1)`		-
Description:The balance type of the original document The field can have one of the following values: ""D"": Receipt; ""C"": Disbursement.
	`OrigModule`	`char(2)`	Doc. Module	-
Description:The module of the origin for the payment document. The field can have one of the following values: ""AP"": Accounts Payable; ""AR"": Accounts Receivable.
	`OrigRefNbr`	`nvarchar(15)`	Reference Nbr.	ARPayment
Description:The reference number of the payment as assigned by the system.
	`PaymentMethodID`Default Navigation	`nvarchar(10)`	Payment Method	PaymentMethod
Description:The payment method used by the customer for the payment.
	`Released`Obsolete	`bit`		-
Description:A flag that indicates (if selected) that the deposit is released.
	`Selected`Nonexistent in DB	`bit`	Selected	-
Description:No description available
	`TranAmt`	`decimal(19, 4)`	Tran Amount	-
Description:The amount of the payment to be deposited in the base currency.
	`TranDesc`	`nvarchar(256)`	Description	-
Description:The description of the deposit detail. This field is copied to the CATran.TranDesc field.
	`TranID`	`bigint`	CA Tran ID	CATran
Description:The identifier of the corresponding cash transaction, which corresponds to the CATran.TranID field.
	`tstamp`	`timestamp`		-
Description:No description available