|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Attachments - Rows
Table Name: ATC1
Table Description: Attachments - Rows
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Absolute entry | Int | 11 | - | Â | Â | Â |
| Line | Row Number | Int | 11 | - | Â | Â | Â |
| srcPath | Source Path | Text | 16 | - | Â | Â | Â |
| trgtPath | Target Path | Text | 16 | - | Â | Â | Â |
| FileName | File Name | nVarChar | 254 | - | Â | Â | Â |
| FileExt | File Extension | nVarChar | 8 | - | Â | Â | Â |
| Date | Attachment Date | Date | 8 | - | Â | Â | Â |
| UsrID | User ID | Int | 11 | - | Â | Â | Â |
| Copied | Copied | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Override | Override file | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| subPath | Subpath | nVarChar | 254 | - | Â | Â | Â |
| FreeText | Free Text | nVarChar | 100 | - | Â | Â | Â |
| CopyToTrgt | Copy to Target Document | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| CopyToProd | Copy to Production Order | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EDocSign | EDocSign | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| SendInMail | Send in Email | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| FileSize | File Size | Int | 11 | - | Â | Â | Â |
| CopyFile | Copy File | VarChar | 1 | - | N | Â | Â |
| FileSuffix | File suffix | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| Â | Â | Line |