CA
CABankFeedDetail
Contains the information about the feed account associated with Bank Feed.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccountID | nvarchar(100) | Account ID | - | |
Description:No description available | ||||
AccountMask | nvarchar(50) | Account Mask | - | |
Description:No description available | ||||
AccountName | nvarchar(250) | Account Name | - | |
Description:No description available | ||||
AccountSubType | nvarchar(100) | Account Subtype | - | |
Description:No description available | ||||
AccountType | nvarchar(100) | Account Type | - | |
Description:No description available | ||||
BankFeedID | nvarchar(10) | CABankFeed | ||
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 Date Time | - | |
Description:No description available | ||||
Currency | nvarchar(5) | Currency | CurrencyList | |
Description:No description available | ||||
Descr | nvarchar(60) | Description | - | |
Description:No description available | ||||
ErrorMessage | nvarchar(250) | Error message | - | |
Description:No description available | ||||
FileDateTime | datetime | - | ||
Description:Defines the current file date and time to process or the last processed one for the feed account. | ||||
FileID | uniqueidentifier | - | ||
Description:Defines the current file to process or the last processed one for the feed account. | ||||
FileRevisionID | int | - | ||
Description:Defines the current file revision to process or the last processed one for the feed account. | ||||
Hidden | bit | Hidden | - | |
Description:Specifies (if set to "true") that this Cash Account has been hidden from details on the Bank Feed (CA205500) form. | ||||
ImportStartDateNonexistent in DB | DateTime? | Import Transactions From | - | |
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 Date Time | - | |
Description:No description available | ||||
LineNbr | int | - | ||
Description:No description available | ||||
ManualImportDate | datetime | - | ||
Description:The manual import start date to retrieve new transactions for the bank feed account. | ||||
Noteid | uniqueidentifier | Noteid | - | |
Description:No description available | ||||
OverrideDate | bit | - | ||
Description:A Boolean value that indicates whether the import start date was overridden by a user. | ||||
RetrievalDate | datetime | Retrieval Date | - | |
Description:No description available | ||||
RetrievalStatus | char(1) | Retrieval Status | - | |
Description:No description available | ||||
StatementPeriod | nvarchar | Statement Period | - | |
Description:No description available | ||||
StatementStartDay | int | Statement Start Day | - | |
Description:No description available | ||||
Tstamp | timestamp | Tstamp | - | |
Description:No description available | ||||