ATC1 - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL Administration / Attachments / Attachments - Rows

DTW Administration / System Initialization / Attachments2 / Attachments - Rows

API Attachments 2 / Attachments 2 Lines

SBO SQL database table details

Field	Description	Type	Constraints	Size	Default	Primary_Key	Unique
AbsEntry ^KEY ^UNIQUE	Absolute entry	Int		11		PRIMARY	Yes
Line	Row Number	Int		11
srcPath	Source Path	Text		16
trgtPath	Target Path	Text		16
FileName	File Name	nVarChar		127
FileExt	File Extension	nVarChar		8
Date	Attachment Date	Date		8
UsrID	User ID	Int		11
Copied	Copied	VarChar	Y) Yes N) No	1	N
Override	Override file	VarChar	Y) Yes N) No	1	N
subPath	Subpath	nVarChar		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

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

biuan SAP® BUSINESS ONE

Object
Attachments2

Object
Attachments2_Lines

Method

Add

SetCurrentLine

Property

Count

DTW DB

DTW DB

DTW DB

DTW DB

UserFields

UserID

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