| Document Storage |  |
| ERP LN related documents are stored in Sharepoint using this structure: Site Zero or more document libraries representing a company in ERP LN Zero or more folders representing a table in ERP LN Zero or more folders representing a record in ERP LN Zero or more documents For details, see the following sections. Site To access Sharepoint, ERP LN uses the site that is specified in the Site URL field in the Sharepoint Parameters (ttdms0100m000) session. The site URL is a combination of the Sharepoint server name and the site. For example: `http://alpine/erpln_att` Document Libraries ERP LN generates a document library in Sharepoint for each company for which document management is enabled. See the Companies (ttdms1110m000) session. Multiple BSEs can connect to the same Sharepoint site. Therefore the hostname of the ERP LN server and the BSE are part of the library name. The library name has this format: `[hostname]:[BSE]:[company number formatted with 3 digits]` For example: `orion:/usr1/bse:425` The generated library description has this format: `Document Library for ERP LN documents - company [company number formatted with 3 digits]` For example: `Document Library for ERP LN documents - company 425` Folders Within a document library two levels of folders are used. The folders on the first level represent the ERP LN tables, as defined in the Object Types (ttdms1100m000) session. If table sharing is applied, the documents are stored in the physical company. Examples:
Folder name | Explanation
`tcibd001` | Represents the Items (tcibd001) table
`tdsls401` | Represents the Sales Order Lines (tdsls401) table
The folders on the second level represent the ERP LN records for each table. The set of allowed characters for a folder is limited. Therefore a folder name has this format: `[object id]` `[object id]` is a concatenation of all parts that form the key of the record in ERP LN. The parts are separated by the @ character. To support key values that begin with spaces, such as item codes without a project, the first part also begins with the @ character. If a key part is an empty string, a space is used for that part. Examples:
Folder name | Explanation
`@ ITEM-001` | Sub folder of `tcibd001` Contains documents that are attached to the " ITEM-001" record in the Items (tcibd001) table
`@SLS123456@50` | Sub folder of `tdsls401` Contains documents that are attached to order line "50" of the "SLS123456" order record in the Sales Order Lines (tdsls401) table
Documents Documents are the attachments that are uploaded via ERP LN. Documents have the same name as they had on the client when they were selected for upload. Example You upload the c:\Data\Report.doc file. In Sharepoint, this file is called Report.doc. |