...
<CU><LOC><EPS><PROD><DETL><SET>
GB0100050001000001 is the format of the chart of account when exported from Eclipse to Excel or when needing to Import into Eclipse from Excel or a Movie Magic Text File.
Note: If there are LESS characters then the MAX for each field, then these must be entered in as a blank spaceif . If you are inserting or editing codes in Excel or a Movie Magic Text File and then pasting importing them back into Eclipse this is a very important concept to grasp.For example
Example 1:
PROD = 500
DETL = 100
SET = 01
...
500 .100 .01
500 100 01 in Excel or a Movie Magic Text File
GB01000500 100 01 would be the full chart code in Excel with the CU, LOC and EPS of GB.01.000
Example 2:
PROD = 6250
DETL = 01
SET = (blank)
When combined this would look like:
<PROD><DETL><SET>
6250.01
625001 in Excel or a Movie Magic Text File
GB01000625001 would be the full chart code in Excel with the CU, LOC and EPS of GB.01.000
Example 3:
PROD = 6250
DETL = 01
SET = (blank)
When combined this would look like:
<PROD><DETL><SET>
6250.01
625001 in Excel or a Movie Magic Text File
GB01000625001 would be the full chart code in Excel with the CU, LOC and EPS of GB.01.000