View source for Data Conversion from Petra to Openpetra

== Standard and System Accounts ==

The Converter has to create the [https://sourceforge.net/apps/phpbb/openpetraorg/viewtopic.php?f=14&t=117&p=333 new set of account properties]

In the code you can refer TAccountPropertyEnum.

This data shall be stored in a_account_property. Therefore new key of a_property_code_c is defined:

# Is_Special_Account 

The primary key of a_account_property is:

<pre>CONSTRAINT a_account_property_pk PRIMARY KEY (a_ledger_number_i, a_account_code_c, a_property_code_c, a_property_value_c),</pre>

and so more than one value can be assigned to a key. 

=== Standard Accounts ===

<pre>&GLOBAL-DEFINE EARNINGS-BF-ACCT 9700
&GLOBAL-DEFINE DIRECT-XFER-ACCT 5501
&GLOBAL-DEFINE ICH-SETTLEMENT-ACCT 5601
&GLOBAL-DEFINE ICH-ACCT 8500
&GLOBAL-DEFINE INTERNAL-XFER-ACCT 9800
&GLOBAL-DEFINE ADMIN-FEE-INCOME-ACCT 3400
&GLOBAL-DEFINE ADMIN-FEE-EXPENSE-ACCT 4900
&GLOBAL-DEFINE FUND-TRANSFER-INCOME-ACCT 3300
&GLOBAL-DEFINE FUND-TRANSFER-EXPENSE-ACCT 4800</pre>

Actually in use are ...

<pre>&GLOBAL-DEFINE ICH-ACCT 8500</pre>

In this case we set: 

<pre>a_property_code_c = "Is_Special_Account";
a_property_value_c = "EARNINGS_BF_ACCT"</pre>

There is only one standard account for each of the types above. So the first value which is found shall be used. 

Hint: The characters "-" and "_" are replaced in order to get a proper enum set in c#.

And furthermore there is another hard coded account 

<pre>IF a_ledger.a_ilt_processing_centre_l THEN DO:  
    FOR EACH a_account
    WHERE a_account.a_ledger_number_i EQ pv_ledger_number_i
    AND   a_account.a_posting_status_l
    AND   a_account.a_account_code_c BEGINS "85" ...</pre>

But this is ICH-ACCT

=== System Accounts ===

<pre>&GLOBAL-DEFINE GIFT-HEADING GIFT
&GLOBAL-DEFINE INTER-LEDGER-HEADING ILT
&GLOBAL-DEFINE BANK-HEADING CASH
&GLOBAL-DEFINE BALANCE-SHEET-HEADING BAL SHT
&GLOBAL-DEFINE PROFIT-AND-LOSS-HEADING PL
&GLOBAL-DEFINE INCOME-HEADING INC
&GLOBAL-DEFINE EXPENSE-HEADING EXP
&GLOBAL-DEFINE DEBTOR-HEADING DRS
&GLOBAL-DEFINE CREDITOR-HEADING CRS
&GLOBAL-DEFINE TOTAL-ASSET-HEADING ASSETS
&GLOBAL-DEFINE TOTAL-LIABILITY-HEADING LIABS
&GLOBAL-DEFINE EQUITY-HEADING RET EARN</pre>

In this case we set: 

<pre>a_property_code_c = "Is_Special_Account";
a_property_value_c = "GIFT_HEADING"</pre>

In this case we get a unique summation account.