Table WSB_DCAFile¶
Obsolete
This table will be replaced by WSB_DCARemofile and WSB_DCARemofileLink in a future update (or when DCASetup FileStructureV2Enabled is set)
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 |
| ObsoleteReason | This table will be replaced by WSB_DCARemofile and WSB_DCARemofileLink in a future update (or when DCASetup FileStructureV2Enabled is set) |
| ObsoleteState | Pending |
| ObsoleteTag | 1.58.0 |
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. |
| 200 | BigInteger |
DCARemoteFileEntryNo |
The UpgradeToFileStructureV2 migration filled DCA_RemoteFile EntryNo in the new File Structure. |
| 201 | Text[2048] |
RemoteFilePath |
The full file path of the remote file on the remote storage. |