---
title: AX - How do you find the physical path (bin file) of a document from the DocID?
description: Find file path
---
[Skip to content](https://knowledgebase.metasource.com/ax-how-do-you-find-the-physical-path-bin-file-of-a-document-from-the-docid-#main-content)
[](https://www.metasource.com/)
Open main navigation
Close main navigation
- [Go to Customer Portal](https://clientsupport.metasource.com/tickets-view)
[Go to Customer Portal](https://clientsupport.metasource.com/tickets-view?hsLang=en)
Hello. How can we help you?
- There are no suggestions because the search field is empty.
1. [MetaSource Knowledge Base](https://knowledgebase.metasource.com/?hsLang=en)
2. [OpenText AppEnhancer (ApplicationXtender)](https://knowledgebase.metasource.com/opentext-appenhancer-applicationxtender?hsLang=en)
3. [Basic Features](https://knowledgebase.metasource.com/opentext-appenhancer-applicationxtender?hsLang=en#basic-features)
# AX - How do you find the physical path (bin file) of a document from the DocID?
Versions: All
Issue:
How do you find the physical path (bin file) of a document from the DocID?
Solution:
1\. Determine the Application ID. To do this, run the query below on the AX database:
Select \* from AE\_APPS
Record the appid from the results for the particular application.
2\. Determine the docid. This will be found in the AE\_DTx table (where x = the appid
found in step 1). If you know the index data for the particular document you're
looking for, add that to the query to narrow down the results.
Select \* from AE\_DTx
Where field1="TEST"
Record the docid from the results.
3\. Determine the objectid associated with the file:
Select \* from AE\_DLx where docid = y
x = the appid found in step 1
y = the docid found in step 2
Note: There may be many entries returned from this query. You will need to use the
below columns to determine which file you are looking for
Pagenum = page within the document
Subpage = this is usually for COLD or a multi-page tiff
Pagever = page version 1=first through 255 (max versions)
Once you have determined which of the entries you are looking for, you can record
the objectid and the pathid to determine the file's physical location.
4\. Determine the path of the file:
Select \* from AE\_PATHS where pathid = z
z = pathid found in previous step
Record the path from the result set
5\. Compute the hashing scheme to find the full path. The storage path is a
combination of the path found in step 4, plus the application name, plus the hashing
scheme (defined in this step)
Compute:
A = Objectid
A / 1024 = X
X / 1024 = Y
X - (1024 \* Y) = Z
path from AE\_PATHS\\APP NAME\\Y\\Z\\objectid.bin
Example:
Application Name = "Test Application"
Path = "C:\\TestAXPath"
ObjectID = 786924
786924/1024 = 768.4804 ==\> Rounded down to 768.
768/1024 = 0.75 ==\> Rounded down to whole number only = 0.
768 - (1024 \* 0) = 768
Result:
C:\\TestAXPath\\Test Application\\0\\768\\786924.bin
- [Tungsten (Kofax)](https://knowledgebase.metasource.com/tungsten-kofax?hsLang=en#main-content)
- [Installation and Setup](https://knowledgebase.metasource.com/tungsten-kofax?hsLang=en#installation-and-setup)
- [Troubleshooting](https://knowledgebase.metasource.com/tungsten-kofax?hsLang=en#troubleshooting)
- [Updates](https://knowledgebase.metasource.com/tungsten-kofax?hsLang=en#updates)
- [OpenText AppEnhancer (ApplicationXtender)](https://knowledgebase.metasource.com/opentext-appenhancer-applicationxtender?hsLang=en#main-content)
- [Installation and Setup](https://knowledgebase.metasource.com/opentext-appenhancer-applicationxtender?hsLang=en#installation-and-setup)
- [Basic Features](https://knowledgebase.metasource.com/opentext-appenhancer-applicationxtender?hsLang=en#basic-features)
- [Troubleshooting](https://knowledgebase.metasource.com/opentext-appenhancer-applicationxtender?hsLang=en#troubleshooting)
- [Updates](https://knowledgebase.metasource.com/opentext-appenhancer-applicationxtender?hsLang=en#updates)
- [System Requirements](https://knowledgebase.metasource.com/opentext-appenhancer-applicationxtender?hsLang=en#system-requirements)
- [Security](https://knowledgebase.metasource.com/opentext-appenhancer-applicationxtender?hsLang=en#security)
- [OpenText Intelligent Capture (Captiva)](https://knowledgebase.metasource.com/opentext-intelligent-capture-captiva?hsLang=en#main-content)
- [Installation and Setup](https://knowledgebase.metasource.com/opentext-intelligent-capture-captiva?hsLang=en#installation-and-setup)
- [Troubleshooting](https://knowledgebase.metasource.com/opentext-intelligent-capture-captiva?hsLang=en#troubleshooting)
- [PaperVision](https://knowledgebase.metasource.com/papervision?hsLang=en)
- [OpenText OTS (Output Transformation Server)](https://knowledgebase.metasource.com/opentext-ots-output-transformation-server?hsLang=en#main-content)
- [OTS](https://knowledgebase.metasource.com/opentext-ots-output-transformation-server?hsLang=en#ots)
- [FileBound](https://knowledgebase.metasource.com/filebound?hsLang=en)
[](http://www.metasource.com)
[getsupport@metasource.com](mailto:getsupport@metasource.com)
[(888) 634-7684](tel:18886347684)
© 2025 MetaSource, LLC. All rights reserved.