Skip to content

Table WSB_DCAFile

Stores information about the files which are stored at remote file locations (e.g. a SharePoint drive).

Properties

Name Value
Access Public
Caption Document Archive File
DataClassification EndUserIdentifiableInformation
DataPerCompany True
DrillDownPageId WSB_DCAFiles
LookupPageId WSB_DCAFiles

Fields

ID Type Name Description
1 Integer TableNo The ID of the source table record that the file record is linked to.
2 Integer SourceType If applicable, the type of the source table record that the file record is linked to.
3 Code[20] SourceNo The no. of the source table record that the file record is linked to.
4 Code[20] SourceSubNo If applicable, the sub no. of the source table record that the file record is linked to.
5 Integer SourceLineNo If applicable, the line no. of the source table record that the file record is linked to.
6 Integer LineNo The line no. of the file record. This line no. is incremented for each file that is linked to the same source record.
7 RecordId SourceRecID The record ID of the source table record that the file record is linked to.
8 Guid SourceSystemID The system ID of the source table record that the file record is linked to.
10 Integer SourceNoOccurrence If applicable, the ID occurrence of the source table record that the file record is linked to.
11 Integer SourceVersionNo If applicable, the version no. of the source table record that the file record is linked to.
20 Code[20] NoSeries The code of the No. Series used to give the file a No.
21 Text[255] RemoteFileName The file name on the remote storage.
22 Code[20] No The No. assigned to the file record.
30 Code[20] CategoryCode The code of the Document Archive file category that the file record belongs to.
40 Text[50] CreatedBy The user that originally created the file record.
41 DateTime CreatedDateTime The date and time at which the file was originally created.
50 Text[255] FileName The file name as shown in Business Central for this file record.
51 Text[10] FileExt The file extension of the file of this file record.
52 DateTime FileCreatedDateTime The date and time at which the file was originally created.
60 Text[100] MessageFrom If the file is an .msg file uploaded via drag and drop, then this field contains who the email message was from.
61 DateTime MessageDateTime If the file is an .msg file uploaded via drag and drop, then this field contains the date and time of the email message.
70 Enum WSB_DCAFileSourceType FileSourceType Specifies where the file record originates from.
71 Enum WSB_DCAPDFArchiveScenario PDFArchiveScenario If applicable, specifies the PDF archive scenario through which the file record was created.
80 Enum WSB_DCARemoteFolderStructure RemoteFolderStructure Specifies the built-in remote folder structure used for this file.
81 Enum WSB_DCARemoteFolderOrder RemoteFolderOrder Specifies the built-in remote folder order used for this file.
82 Enum WSB_DCAFileHandler FileHandler Specifies the name of the file handler used to store the file remotely.
83 Code[30] RemoteFolderStructureCode Specifies the code of the folder structure used to store the file remotely.
90 Text[128] EnvironmentName Specifies the name of the Business Central environment in which the file record was originally created.
91 Text[30] CompanyName Specifies the name of the Business Central company in which the file record was originally created.
100 Text[255] SiteID If applicable, specifies the ID of the SharePoint site at which the remote file is stored.
101 Text[255] DriveID If applicable, specifies the ID of the SharePoint drive at which the remote file is stored.
110 Text[24] ABSStorageAccountName If applicable, specifies the name of the Azure Blob Storage account at which the remote file is stored.
111 Text[64] ABSContainerName If applicable, specifies the name of the Azure Blob Storage container at which the remote file is stored.
120 Text[24] AFSStorageAccountName If applicable, specifies the name of the Azure File Share Storage account at which the remote file is stored.
121 Text[64] AFSFileShareName If applicable, specifies the name of the Azure File Share at which the remote file is stored.
150 Integer InitialTableNo The ID of the source table record that the file record was originally linked to.
151 Integer InitialSourceType If applicable, the type of the source table record that the file record was originally linked to.
152 Code[20] InitialSourceNo The no. of the source table record that the file record was originally linked to.
153 Code[20] InitialSourceSubNo If applicable, the sub no. of the source table record that the file record was originally linked to.
154 Integer InitialSourceLineNo If applicable, the line no. of the source table record that the file record was originally linked to.
156 RecordId InitialSourceRecID The record ID of the source table record that the file record was originally linked to.
157 Guid InitialSourceSystemID The system ID of the source table record that the file record was originally linked to.
159 Integer InitialSourceNoOccurrence If applicable, the ID occurrence of the source table record that the file record was originally linked to.
160 Integer InitialSourceVersionNo If applicable, the version no. of the source table record that the file record was originally linked to.