ForFUND Export

Definition file:

  Field Name Type Length eTapestry Field
1 TR_ACCT Char 19 GL Number, 16 characters
2 TR_JVNO Char 7 Journal Entry Number
3 TR_JVDATE Numeric 8 Journal Transaction Date
4 TR_MO Numeric 2 Fiscal Period (1-13)
5 TR_YR Numeric 4 Fiscal Year
6 TR_MAMT Numeric 12 - 2 decimals Transaction Amount (+ are debits, - are credits)
7 TR_JVTOTAL Numeric 14 - 2 decimals Sum of All JE Transaction (Must Equal Zero to Post)
8 TR_REF2 Char 10 Reference Field (Misc.)
9 TR_DESC Char 30 User Description of Transaction

Sample:

TR_ACCT TR_JVNO TR_JVDATE TR_MO TR_YR TR_MAMT TR_JVTOTAL TR_REF2 TR_DESC
revenue# blank 06172002 blank blank -2525 000 ref description