Data Conversion from Petra to Openpetra: Difference between revisions
Jump to navigation
Jump to search
Wolfganguhr (talk | contribs) |
Wolfganguhr (talk | contribs) |
||
| Line 3: | Line 3: | ||
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] | 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] | ||
This data shall be stored in a_account_property. Therefore new key of a_property_code_c | 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: | The primary key of a_account_property is: | ||
| Line 25: | Line 24: | ||
&GLOBAL-DEFINE FUND-TRANSFER-INCOME-ACCT 3300 | &GLOBAL-DEFINE FUND-TRANSFER-INCOME-ACCT 3300 | ||
&GLOBAL-DEFINE FUND-TRANSFER-EXPENSE-ACCT 4800</pre> | &GLOBAL-DEFINE FUND-TRANSFER-EXPENSE-ACCT 4800</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#. | |||
=== System Accounts === | === System Accounts === | ||
| Line 40: | Line 48: | ||
&GLOBAL-DEFINE TOTAL-LIABILITY-HEADING LIABS | &GLOBAL-DEFINE TOTAL-LIABILITY-HEADING LIABS | ||
&GLOBAL-DEFINE EQUITY-HEADING RET EARN</pre> | &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 can finde more than one Accounts which hold this property. | |||
Revision as of 13:31, 14 April 2011
Standard and System Accounts
The Converter has to create the new set of account properties
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:
CONSTRAINT a_account_property_pk PRIMARY KEY (a_ledger_number_i, a_account_code_c, a_property_code_c, a_property_value_c),
and so more than one value can be assigned to a key.
Standard Accounts
&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
In this case we set:
a_property_code_c = "Is_Special_Account"; a_property_value_c = "EARNINGS_BF_ACCT"
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#.
System Accounts
&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
In this case we set:
a_property_code_c = "Is_Special_Account"; a_property_value_c = "GIFT_HEADING"
In this case we can finde more than one Accounts which hold this property.