FA15000 - Fixed Assets Batch Headers
Dynamics GP table FA15000 (Fixed Assets Batch Headers) contains 21 columns including GLINTBTCHNUM, POSTED, GLINTTRXDATE....
SQL Query Builder
21 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| GLINTBTCHNUM | GL Interface Batch Number | String | 16 | |
| POSTED | Posted | Boolean | 2 | |
| GLINTTRXDATE | GL Interface TRX Date | Date | 4 | |
| GL_Interface_Comment | GL Interface Comment | String | 32 | |
| GL_Intf_Begin_Period | GL Interface Begin Period | Integer | 2 | |
| GL_Interface_Begin_Year | GL Interface Begin Year | Integer | 2 | |
| GL_Interface_End_Period | GL Interface End Period | Integer | 2 | |
| GL_Interface_End_Year | GL Interface End Year | Integer | 2 | |
| SSRCEDOC | Start Source Document | String | 12 | |
| ENDSRCDC | End Source Document | String | 12 | |
| Start_Asset_ID | Start Asset ID | String | 16 | |
| End_Asset_ID | End Asset ID | String | 16 | |
| Start_Asset_ID_Suffix | Start Asset ID Suffix | Integer | 2 | |
| End_Asset_ID_Suffix | End Asset ID Suffix | Integer | 2 | |
| STTCLSID | Start Class ID | String | 16 | |
| ENDCLSID | End Class ID | String | 16 | |
| BOOKINDX | Book Index | Long Integer | 4 | |
| JRNENTRY | Journal Entry | Long Integer | 4 | |
| DEBITAMT | Debit Amount | Currency | 10 | |
| CRDTAMNT | Credit Amount | Currency | 10 | |
| USERID | User ID | String | 16 |
Related Tables
Tables that share columns with FA15000. Click "Join" to add to your query.
STTCLSID
ENDCLSID
BOOKINDX