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
Note: The Lawson interface requires a separate license fee to use. Contact the Naviga Support Center for details.
Record | Field | Length | Field Contents |
---|---|---|---|
Control | GL-Asterisk | x(1) | * |
| GL-Fiscal-Date | 9(6) | The end date specified in Export GL. Format MMDDYY |
| Filler | x(113) | Spaces |
|
|
|
|
Detail | GL-Reference | x(6) | First 6 characters of the GL Journal Code. |
| GL-Fiscal-Period | 9(3) | Fiscal month and last digit of fiscal year. Format MMY. |
| GL-Effective-Month | x(2) | Month of the transaction date. Format MM. |
| GL-Effective-Code | x(1) | M (for “month”) |
| GL-Journal-Ref | 9(7) | GL company ID plus “C” plus day number of current date (Sunday = 01, Monday = 02, etc.) |
| GL-Intercompany | 9(2) | GL company ID |
| GL-Account | 9(13) | GL account number for the transaction |
| GL-Distribution-Amount | 9(10) | Transaction amount. Last two spaces for cents (no decimal). Credits exported with leading minus sign |
| GL-Description | x(30) | Transaction memo |
| Filler | x(44) | Spaces |
Last updated