CABankFeed

PX.Objects.CA

40 of 40 fields

	Field Name	Type	Display Name	Foreign Key
	`BankFeedID`Default Navigation	`nvarchar(10)`	Bank Feed ID	-
Description:No description available
	`AccessToken`	`nvarchar(MAX)`	AccessToken	-
Description:No description available
	`AccountQty`	`int`	Accounts	-
Description:No description available
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`	Created Date Time	-
Description:No description available
	`CreateExpenseReceipt`	`bit`	Create Expense Receipts	-
Description:No description available
	`CreateReceiptForPendingTran`	`bit`	Create Expense Receipts for Pending Transactions	-
Description:No description available
	`CreditLabel`	`nvarchar(15)`	Receipt Property	-
Description:Defines the label that indicates that the transaction belongs to the Receipt type.
	`DebitLabel`	`nvarchar(15)`	Disbursement Property	-
Description:Defines the label that indicates that the transaction belongs to the Disbursement type.
	`DefaultExpenseItemID`Default Navigation	`int`	Default Expense Item	InventoryItem
Description:No description available
	`Descr`	`nvarchar(60)`	Description	-
Description:No description available
	`ErrorMessage`	`nvarchar(250)`	Error message	-
Description:No description available
	`ExternalItemID`	`nvarchar(50)`	Item ID/Member ID	-
Description:No description available
	`ExternalUserID`	`nvarchar(50)`	User ID	CABankFeedUser
Description:No description available
	`FileAmountFormat`	`char(1)`	Amount Format	-
Description:Defines the format of the amount in files.
	`FileFormat`	`char(1)`	File Format	-
Description:Defines the file format that is stored in the shared folder.
	`FolderLogin`	`nvarchar(80)`	Login	-
Description:Folder login to access the shared folder.
	`FolderPassword`	`nvarchar(MAX)`	Password	-
Description:Folder password to access the shared folder.
	`FolderPath`	`nvarchar(250)`	URL	-
Description:Defines the folder path to the shared folder.
	`ImportStartDate`	`datetime`	Import Start Date	-
Description:No description available
	`Institution`	`nvarchar(150)`	Financial Institution	-
Description:No description available
	`InstitutionID`	`nvarchar(50)`		-
Description:No description available
	`IsTestFeed`Nonexistent in DB	`bit`		-
Description:Returns "true" when Bank Feed is using a sandbox
	`LastModifiedByID`Default Navigation	`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
	`MultipleMapping`	`bit`	Map Multiple Bank Accounts to One Cash Account	-
Description:A Boolean value that indicates whether the bank feed works in the multiple mapping mode.
	`Noteid`	`uniqueidentifier`	Noteid	-
Description:No description available
	`OrganizationID`	`int`		-
Description:No description available
	`ProviderID`Default Navigation	`uniqueidentifier`	Data Provider	SYProvider
Description:Defines the provider that is used to read lines in files.
	`RetrievalDate`	`datetime`	Retrieval Date	-
Description:No description available
	`RetrievalStatus`	`char(1)`	Retrieval Status	-
Description:No description available
	`Selected`Nonexistent in DB	`bit`	Selected	-
Description:No description available
	`SshCertificateName`Default Navigation	`nvarchar(50)`	SSH Private Key	Certificate
Description:Name of the certificate that is used to connect to the SFTP server.
	`StatementImportSource`Nonexistent in DB	`nvarchar(MAX)`	Statement Import Source	-
Description:No description available
	`Status`	`char(1)`	Status	-
Description:No description available
	`Tstamp`	`timestamp`	Tstamp	-
Description:No description available
	`Type`	`char(1)`	Bank Feed Type	-
Description:No description available
	`UnmatchedAccountQty`	`int`	Unmatched Accounts	-
Description:No description available