# General Ledger Interface Format

File type: The DTI Standard format is space delimited with non-numeric fields enclosed in double quotes. The Lawson format is fixed length.

Location: /dti/exchange/cm. The file name is specified at runtime; the default is cmgltran.d

## DTI Standard

| Field                     | Sample Output |
| ------------------------- | ------------- |
| GL company ID             | “01”          |
| GL journal code           | “Unearnrv”    |
| Fiscal year               | 1996          |
| GL account number         | “2232”        |
| Transaction date          | 07/31/96      |
| Transaction amount        | -15.5         |
| Fiscal period             | 4             |
| Memo and reference number | “256084 776”  |
| GL batch number           | 6824          |

## Lawson

{% hint style="info" %}
**Note:** *The Lawson interface requires a separate license fee to use. Contact the Naviga Support Center for details.*
{% endhint %}

<table><thead><tr><th width="150">Record</th><th width="150">Field</th><th width="150">Length</th><th width="246.15384615384616">Field Contents</th></tr></thead><tbody><tr><td>Control</td><td>GL-Asterisk</td><td>x(1)</td><td>*</td></tr><tr><td> </td><td>GL-Fiscal-Date</td><td>9(6)</td><td>The end date specified in Export GL. Format MMDDYY</td></tr><tr><td> </td><td>Filler</td><td>x(113)</td><td>Spaces</td></tr><tr><td> </td><td> </td><td> </td><td> </td></tr><tr><td>Detail</td><td>GL-Reference</td><td>x(6)</td><td>First 6 characters of the GL Journal Code.</td></tr><tr><td> </td><td>GL-Fiscal-Period</td><td>9(3)</td><td>Fiscal month and last digit of fiscal year. Format MMY.</td></tr><tr><td> </td><td>GL-Effective-Month</td><td>x(2)</td><td>Month of the transaction date. Format MM.</td></tr><tr><td> </td><td>GL-Effective-Code</td><td>x(1)</td><td>M (for “month”)</td></tr><tr><td> </td><td>GL-Journal-Ref</td><td>9(7)</td><td>GL company ID plus “C” plus day number of current date (Sunday = 01, Monday = 02, etc.)</td></tr><tr><td> </td><td>GL-Intercompany</td><td>9(2)</td><td>GL company ID</td></tr><tr><td> </td><td>GL-Account</td><td>9(13)</td><td>GL account number for the transaction</td></tr><tr><td> </td><td>GL-Distribution-Amount</td><td>9(10)</td><td>Transaction amount. Last two spaces for cents (no decimal). Credits exported with leading minus sign</td></tr><tr><td> </td><td>GL-Description</td><td>x(30)</td><td>Transaction memo</td></tr><tr><td> </td><td>Filler</td><td>x(44)</td><td>Spaces</td></tr></tbody></table>