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
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.
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
