x

Start now

Schedule a demo

  • Date Format: MM slash DD slash YYYY
  • This field is for validation purposes and should be left unchanged.
sysSpec: Attachments – OneSource: Inventory for QuickBooks Online sysSpec: Attachments – OneSource: Inventory for QuickBooks Online

Have a Question?

sysSpec: Attachments

You are here:
< All Topics

Overview

Attachments contain all the attached files

                            * Received from mails

                            * Stored by users and so on.

The files may be of any format. This schema contains a path of a file that is stored in a server. We have a separate folder to store attachments. These attachments are per company ID. Each company contains separate folders for their file storage.

Attachments(View)

Related Tables

  • Attachments

Attachments

 X REQ# Form Section
(or Tab Name)
User Friendly
Object Label
Object Type   Table.FieldName Data Type Related Utility Table Notes
===== ===== =========== ====================== ============= ======================== ===== ====================== =====================================
 1 Attachments#  ID  Attachments.ID nvarchar(150) This is the unique primary key.
 CompanyID  Attachments.CompanyID Int
 AttachmentSourceType  Attachments.AttachmentSourceType nvarchar(50) This is the source of attahcments. ie, this attachement is from customers or vendors or jobs?
 AttachmentSourceID  Attachments.AttachmentSourceID nvarchar(150) This is the source ID
 AttachmentPath  Attachments.AttachmentPath nvarchar(-1) Path in which the files are stored in server.
 AttachmentDate  Attachments.AttachmentDate Datetime This is the date when the attachment is saved
 JobMailUIDL  Attachments.JobMailUIDL nvarchar(400) This fields stores the mailid from which the attachment fetched.
Previous screenSpec: Reports
Next screenSpec: Warehouse > Item Stock Transfers
Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Table of Contents