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 |