The metadata header (Row 1-5) instructs FDMEE on how to find the relevant segments of data that it handles in this template. The following Row 1-5 topics explain how each piece of metadata is used by FDMEE.
The tag in row 1 is used to set the Journal ID and the FDMEE location that the data should be loaded into. The Journal ID must be placed in row 1 of the Account column. The Location tag must be placed in row 1 of the Amount column.
Note: | The journal ID is limited to ten characters. |
The tag in row 2 sets the FDMEE category into which the journal loads. The category must be a valid FDMEE category. The FDMEE Category tag must be placed in the Amount column.
The tag in row 3 sets the period that the data should be loaded into. The period must be a valid FDMEE period. This tag must be placed in the Amount column.
The tag in row 4 sets the journal load method within FDMEE. To append to an existing journal with the same Journal ID, type the letter A. If a journal exists with the same Journal ID within the same FDMEE point of view, then the new journal is appended to the previously submitted journal. To replace an existing journal with the same Journal ID, type the letter R.
If a journal exists with the same journal ID within the same FDMEE point of view, then the new journal replaces the old journal. This tag must be placed in the Amount column. The table below defines the possible tags. The “AZ” and “RZ” settings work the same as the “A” and “R” methods except that all zero value amounts are suppressed.
| Method | Valid Tags |
|---|---|
| Append Journal | A, Append |
Replace Journal (default) | R Replace |
Append journal - Zero Suppress | AZ |
Replace journal - Zero Suppress | RZ |
The tags in row five define the dimension that the amounts are loaded into. The table below defines the possible dimension tags.
| FDMEE Dimension | Valid Tags |
|---|---|
Account (Required) | A, Account, SrcAcctKey |
Center (Required) | C, Center, SrcCenterKey |
Description (Optional) | D, Description, SrcAcctDesc |
IC Counter Party (Optional) | I, IC, ICCoParty |
| User Defined 1-User Defined 20 (Optional) | 1-20, UD1-UD20, UserDefined1-UserDefined20 |
| Amount (Required) | V, Amount, SrcAmount |