CA
CAReconEntry.CATranExt
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BatchNbr | nvarchar(15) | Batch Number | Batch | |
Description:No description available | ||||
BegBalNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
BranchID | int | Branch | ||
Description:No description available | ||||
CashAccountID | int | Cash Account | CashAccount | |
Description:No description available | ||||
ClearDate | datetime | Clear Date | - | |
Description:No description available | ||||
Cleared | bit | Cleared | - | |
Description:No description available | ||||
CountCreditNonexistent in DB | int? | - | ||
Description:No description available | ||||
CountDebitNonexistent in DB | int? | - | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CuryClearedCreditAmtNonexistent in DB | decimal? | Disbursement | - | |
Description:No description available | ||||
CuryClearedDebitAmtNonexistent in DB | decimal? | Receipt | - | |
Description:No description available | ||||
CuryCreditAmtNonexistent in DB | decimal? | Disbursement | - | |
Description:No description available | ||||
CuryDebitAmtNonexistent in DB | decimal? | Receipt | - | |
Description:No description available | ||||
CuryEffClearedCreditAmtNonexistent in DB | decimal? | Disbursement | - | |
Description:No description available | ||||
CuryEffClearedDebitAmtNonexistent in DB | decimal? | Receipt | - | |
Description:No description available | ||||
CuryEffCreditAmtNonexistent in DB | decimal? | Disbursement | - | |
Description:No description available | ||||
CuryEffDebitAmtNonexistent in DB | decimal? | Receipt | - | |
Description:No description available | ||||
CuryEffTranAmtNonexistent in DB | decimal? | Amount | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryReconciledCreditNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
CuryReconciledDebitNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
CuryTranAmt | decimal | Amount | - | |
Description:No description available | ||||
DayDescNonexistent in DB | string | Day of Week | - | |
Description:No description available | ||||
DrCr | char(1) | Disb. / Receipt | - | |
Description:No description available | ||||
EffTranAmtNonexistent in DB | decimal? | Tran. Amount | - | |
Description:No description available | ||||
EndBalNonexistent in DB | decimal? | Ending Balance | - | |
Description:No description available | ||||
ExtRefNbr | nvarchar(40) | Document Ref. | - | |
Description:No description available | ||||
FinPeriodID | string | Post Period | - | |
Description:No description available | ||||
Hold | bit | - | ||
Description:No description available | ||||
IsPaymentChargeTran | bit | - | ||
Description:Indicates that CATran was created by ARPaymentChargeTran or APPaymentChargeTran | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrigLineNbr | int | - | ||
Description:No description available | ||||
OrigModule | char(2) | Module | Batch | |
Description:No description available | ||||
OrigRefNbr | nvarchar(15) | Orig. Doc. Number | APPayment | |
Description:No description available | ||||
OrigTranType | char(3) | Orig. Doc. Type | APPayment | |
Description:No description available | ||||
OrigTranTypeUINonexistent in DB | string | Tran. Type | - | |
Description:The CATran type. The field can have one of the values described in PRCATranType.ListAttribute. | ||||
PendingApproval | bit | - | ||
Description:Indicates that CATran is pending approval | ||||
Posted | bit | - | ||
Description:No description available | ||||
ProcessedFromFeedNonexistent in DB | bool? | - | ||
Description:No description available | ||||
ReconDate | datetime | - | ||
Description:No description available | ||||
ReconNbr | nvarchar(15) | Reconciled Number | CARecon | |
Description:No description available | ||||
Reconciled | bit | Reconciled | - | |
Description:No description available | ||||
ReconciledCreditNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
ReconciledDebitNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
RefSplitLineNbr | int | - | ||
Description:No description available | ||||
RefTranAccountID | int | ChildTran Account | CashAccount | |
Description:No description available | ||||
RefTranID | bigint | CATran | ||
Description:No description available | ||||
ReferenceID | int | Business Account | BAccount | |
Description:No description available | ||||
ReferenceNameNonexistent in DB | string | Business Name | - | |
Description:No description available | ||||
Released | bit | - | ||
Description:No description available | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
SkipCountNonexistent in DB | bool? | - | ||
Description:This flag is required for the specific situation when SkipVoids is true and transaction was included to Reconcillation Statement before it was voided and then voiding transaction was included. If this flag is set to true Transaction will not be counted in Reconcillation Statement header and Transaction's credit amount will be subtracted from Reconcillation Statement's debit amount instead of adding to Reconcillation Statement's credit amount and Transaction's debit amount will be subtracted from Reconcillation Statement's credit amount instead of adding to Reconcillation Statement's debit amount. | ||||
StatusNonexistent in DB | string | Status | - | |
Description:No description available | ||||
TranAmt | decimal | Tran. Amount | - | |
Description:No description available | ||||
TranDate | datetime | Doc. Date | - | |
Description:No description available | ||||
TranDesc | nvarchar(512) | Description | - | |
Description:No description available | ||||
TranID | bigint | Document Number | CATran | |
Description:No description available | ||||
TranPeriodID | string | - | ||
Description:No description available | ||||
Voided | bit | Voided | - | |
Description:No description available | ||||
VoidedTranID | bigint | CATran | ||
Description:No description available | ||||
VoidingNotReleasedNonexistent in DB | bool? | - | ||
Description:No description available | ||||
VoidingTranIDNonexistent in DB | long? | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||