The Chart of Account structure is made up of the following pieces of data below. This guide will focus on the Production, Detail and Set code pieces of information.
CU - Currency Code
Lo - Location Code
Eps - Episode Code
Prod - Production Code
Detl - Detail Code
Set - Set Code
CU = 2 character max
Loc = 2 character max
Eps = 3 character max
Prod = 4 character max
Detl = 4 character max
Set = 3 character max
An account with the max characters in each field would look like
CU = GB
LOC = 01
EPS = 000
PROD = 5000
DETL = 1000
SET = 001
<CU>.<LOC>.<EPS>.<PROD>.<DETL>.<SET>
GB.01.000.5000.1000.001 with a separator added for readability
<CU><LOC><EPS><PROD><DETL><SET>
GB0100050001000001 when exported from Eclipse to Excel
If there are LESS characters then the MAX for each field, then these must be entered in as a blank space if you are inserting or editing codes in Excel and then pasting them back into Eclipse.
For example:
PROD = 500
DETL= 100
SET = 01
When combined this would look like:
<PROD><DETL><SET>
500 .100 .01
500 100 01 in Excel
GB01000500 100 01 would be the full chart code in Excel with the CU, LOC and EPS.