File layout for Standard Multi-Journal format





Description of Issue

What layout can be used the Standard Multi-Journal import format?



Context

Import Journals



Cause

Import layout required



Resolution

The file will be saved as a .prn file with the spacing noted below.



Additional Information

Header

1-1 Header Identifier value will be H

2-7 Reference 1

8-19 short description

20-23 fiscal year

24-25 Fiscal period

26-33 Effective date

Detail

1-1 Detail Identifier value will be D

2-9 Org

10-15 Object

16-20 Project

21-55 Cross reference account

56-85 Comment

96-107 Reference 1

108-108 Actual debit or credit

109-121 Actual Amount

122-122 Encumbrance debit or credit

123-135 Encumbrance amount

136-140 Allocation Code

141-141 Transaction Type

142-142 Account Type

143-197 Full account

198-198 Project String Type

199-241 Project String