biuan SAP® BUSINESS ONE SDK
DTW Administration / System Initialization / Attachments2 / Attachments - Rows
API Attachments 2 / Attachments 2 Lines
ATC1 - Attachments - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEAbsolute entryInt
11
PRIMARYYes
LineRow NumberInt
11
srcPathSource PathText
16
trgtPathTarget PathText
16
FileNameFile NamenVarChar
127
FileExtFile ExtensionnVarChar
8
DateAttachment DateDate
8
UsrIDUser IDInt
11
CopiedCopiedVarChar
Y) Yes
N) No
1
N
OverrideOverride fileVarChar
Y) Yes
N) No
1
N
subPathSubpathnVarChar
127

SELECT statement

SELECT ATC1.AbsEntry AS 'Absolute entry', ATC1.Line AS 'Row Number', ATC1.srcPath AS 'Source Path', ATC1.trgtPath AS 'Target Path', ATC1.FileName AS 'File Name', ATC1.FileExt AS 'File Extension', ATC1.Date AS 'Attachment Date', ATC1.UsrID AS 'User ID', ATC1.Copied AS 'Copied', ATC1.Override AS 'Override file', ATC1.subPath AS 'Subpath' FROM ATC1 AS ATC1

Related information


Attachments 2 Lines Attachments2_Lines Object· Table: ATC1
The Attachments2_Lines is a child object of the Attachments2 object. Each line stores details about one attachment file. Source table: ATC1.
   Parent: Attachments 2 Attachments2 Object· Table: OATC


SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates