Stores files from Bankgirot, automatically fetched from the incoming FTP server. Only applicable when using the "FTP via Internet" and "Third party files via FTP" delivery methods.
Use the Bankgiro component in "Process files" mode to process the files.
Add row:
Not allowed
Delete row:
Not allowed
Foreign key:
Not allowed
Columns
| Name | Datatype | Read | Write | Primary key | Description |
|---|---|---|---|---|---|
| BankgiroFileIncomingId | int | Yes | No | Yes | Primary key. |
| FileName | varchar(300) | Yes | No | No | Filename from Bankgirot. |
| Product | varchar(30) | Yes | No | No |
Identified by the component, based on file contents. One of AG BGI BGI IMAGE LBUT UNKNOWN Only attempt to process files with a product supported by the component. Files of type "BGI IMAGE" will be deleted after a week to keep disk usage down. If they need to be kept longer than that, they have to be put in another table. If the file was found in a subdirectory, then the product is assumed to be the name of the subdirectory. |
| ReceivedDateTimeUtc | datetime2 | Yes | No | No | When the file was retrieved from the local FTP server; not when Bankgirot put it there. |
| IsProcessed | bit | Yes | No | No | Use the procedure SoftadminApi.BankgiroFtp_SetAsProcessed to update the status after the file has been processed. |
| IsTestFile | bit | Yes | No | No | If the file is a test file. |
| IsThirdPartyFile | bit | Yes | No | No | Set to 1 if the file was found in a subdirectory on the FTP server. |
| File | varbinary(max) | Yes | No | No | File data. |