CA
CABankTranHeader
A header of a bank statement by an account.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BankStatementFormat | nvarchar(15) | Bank Statements Format | - | |
Description:No description available | ||||
CashAccountID | int | Cash Account | CashAccount | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
CuryBegBalance | decimal | Beginning Balance | - | |
Description:No description available | ||||
CuryCreditsTotal | decimal | Total Disbursements | - | |
Description:No description available | ||||
CuryDebitsTotal | decimal | Total Receipts | - | |
Description:No description available | ||||
CuryDetailsEndBalanceNonexistent in DB | decimal? | Calculated Balance | - | |
Description:No description available | ||||
CuryEndBalance | decimal | Ending Balance | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
DocDate | datetime | Statement Date | - | |
Description:No description available | ||||
EndBalanceDate | datetime | End Balance Date | - | |
Description:No description available | ||||
ExternalReference | nvarchar(50) | - | ||
Description:The external reference to the bank statement. | ||||
ExternalTranOrigin | int | - | ||
Description:The external bank statement origin. | ||||
FormatVerisionNbr | nvarchar(15) | Format Verision Nbr | - | |
Description:No description available | ||||
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 | ||||
ManualMatchingAllowed | bit | Manual Matching Allowed | - | |
Description:Specifies (if not set to "true") that the bank transactions statement is locked by the external system. The field is used only if the FeaturesSet.AmazonIntegration feature is activated. | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
RefNbr | nvarchar(15) | Reference Nbr. | - | |
Description:No description available | ||||
StartBalanceDate | datetime | Start Balance Date | - | |
Description:No description available | ||||
TranMaxDate | datetime | - | ||
Description:No description available | ||||
TranType | char(1) | Type | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||