CA
CATranExt
PX.Objects.CA.BankStatementHelpers61 of 61 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
TranID | bigint | Document Number | - | |
Description:No description available | ||||
BatchNbr | nvarchar(15) | Batch Number | - | |
Description:No description available | ||||
BegBalNonexistent in DB | decimal | BegBal | - | |
Description:No description available | ||||
BranchID | int | - | ||
Description:No description available | ||||
CashAccountID | int | Cash Account | - | |
Description:No description available | ||||
ClearDate | datetime2 | Clear Date | - | |
Description:No description available | ||||
Cleared | bit | Cleared | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | - | |
Description:No description available | ||||
CreatedByScreenID | varchar(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 | ||||
CuryID | nvarchar(5) | Currency | - | |
Description:No description available | ||||
CuryInfoID | bigint | - | ||
Description:No description available | ||||
CuryTranAbsAmtNonexistent in DB | decimal | Amount | - | |
Description:No description available | ||||
CuryTranAmt | decimal | Amount | - | |
Description:No description available | ||||
CuryTranAmtCalcNonexistent in DB | decimal | Amount | - | |
Description:No description available | ||||
DayDescNonexistent in DB | nvarchar(20) | Day of Week | - | |
Description:No description available | ||||
DrCr | char(1) | Disb. / Receipt | - | |
Description:No description available | ||||
EndBalNonexistent in DB | decimal | Ending Balance | - | |
Description:No description available | ||||
ExtRefNbr | nvarchar(40) | Document Ref. | - | |
Description:No description available | ||||
FinPeriodID | char(6) | Post Period | - | |
Description:No description available | ||||
Hold | bit | - | ||
Description:No description available | ||||
IsBestMatchNonexistent in DB | bit | Best Match | - | |
Description:No description available | ||||
IsMatchedNonexistent in DB | bit | Matched | - | |
Description:No description available | ||||
IsPaymentChargeTran | bit | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | - | |
Description:No description available | ||||
LastModifiedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
MatchRelevanceNonexistent in DB | decimal | Match Relevance | - | |
Description:No description available | ||||
MatchRelevancePercentNonexistent in DB | decimal | Match Relevance, % | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrigLineNbr | int | - | ||
Description:No description available | ||||
OrigModule | char(2) | Module | - | |
Description:No description available | ||||
OrigRefNbr | nvarchar(15) | Orig. Doc. Number | - | |
Description:No description available | ||||
OrigTranType | char(3) | Orig. Doc. Type | - | |
Description:No description available | ||||
OrigTranTypeUI | nvarchar(MAX) | Tran. Type | - | |
Description:No description available | ||||
PendingApproval | bit | - | ||
Description:No description available | ||||
Posted | bit | - | ||
Description:No description available | ||||
Reconciled | bit | Reconciled | - | |
Description:No description available | ||||
ReconDate | datetime2 | - | ||
Description:No description available | ||||
ReconNbr | nvarchar(15) | Reconciled Number | - | |
Description:No description available | ||||
ReferenceID | int | Business Account | - | |
Description:No description available | ||||
ReferenceNameNonexistent in DB | nvarchar(60) | Business Name | - | |
Description:No description available | ||||
RefSplitLineNbr | int | - | ||
Description:No description available | ||||
RefTranAccountID | int | ChildTran Account | - | |
Description:No description available | ||||
RefTranID | bigint | - | ||
Description:No description available | ||||
Released | bit | Released | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
StatusNonexistent in DB | nchar(1) | Status | - | |
Description:No description available | ||||
TranAbsAmtNonexistent in DB | decimal | Tran. Amount | - | |
Description:No description available | ||||
TranAmt | decimal | Tran. Amount | - | |
Description:No description available | ||||
TranAmtCalcNonexistent in DB | decimal | Tran. Amount | - | |
Description:No description available | ||||
TranDate | datetime2 | Doc. Date | - | |
Description:No description available | ||||
TranDesc | nvarchar(512) | Description | - | |
Description:No description available | ||||
TranPeriodID | char(6) | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
Voided | bit | - | ||
Description:No description available | ||||
VoidedTranID | bigint | - | ||
Description:No description available | ||||