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