One moment please...
 
 
Exact Financials   
 

Connectivity Manual - IFALL - Financial entries

Financial entries

As of version 3.34 the journal entry business logic has been updated (to IFALL4). The business logic of older versions is internally linked through to the latest version, so no adjustments in existing EDIS links should be required.

Due to the differences between the various journal entry types the EDIS modules have been split up per type:

Accrual journal entries

Accrual journal entry header - ATRSH_ACCRUAL

Nr Field name Data type Field length Ref Description Check/Action
1 ADM_NR Integer 6 admdat Company -
2 YEAR Integer 4 - Year -
3 PERIOD Integer 3 - Period -
4 JOURNAL_NR Integer 8 - Journal number -
5 SEQNR_ATRSH Integer 8 - Sequence number -
6 ENTRY_NR Integer 8 - Entry number -
7 DESCR Character 25 - Description -
8 IFALL_BLOCK Logical 1 - Block for changes -
9 ORIGIN Integer 8 - Origin -


Accrual journal entry line - ATRSS_ACCRUAL

Nr Field name Data type Field length Ref Description Check/Action
1 LINENR_ATRSS Integer 4 - Line number -
2 DATE_LINE Date 10 - Date -
3 DESCR_LINE Character 25 - Description -
4 ACC_NR Character 9 ledger General ledger account -
5 CURR_CODE_LINE Character 8 curren Currency -
6 AMOUNT_FC Decimal 23 - Amount -
7 AMOUNT_DC Decimal 23 - Amount: Default currency -
8 EXCH_RATE_LINE Decimal 13 - Exchange rate -
9 QUANTITY Decimal 10 - Quantity -
10 COST_CENTER Character 8 ccent Cost center -
11 COST_UNIT Character 8 cunit Cost unit -
12 MDIM_CODE_1 Character 8 - Dimension 1 -
13 MDIM_CODE_2 Character 8 - Dimension 2 -
14 MDIM_CODE_3 Character 8 - Dimension 3 -
15 MDIM_CODE_4 Character 8 - Dimension 4 -
16 MDIM_CODE_5 Character 8 - Dimension 5 -
17 PROJECT_CODE Character 10 prmst Project -
18 COST_CAT_CODE Character 8 prccat Project cost category -
19 PROJECT_COST_CENTER Character 8 ccent Project cost center -
20 PROJECT_DESCR Character 30 - Project description -
21 RESULT_TYPE Integer 6 1 Project result type -
22 NR_PERIODS_ALLOCATION Integer 8 - Number of periods -
23 START_YEAR_ALLOCATION Integer 8 - Start year period allocation -
24 START_PERIOD_ALLOCATION Integer 8 - Start period period allocation -


Bank journal entries

Bank journal entry header - ATRSH_BANK

Nr Field name Data type Field length Ref Description Check/Action
1 ADM_NR Integer 6 admdat Company -
2 YEAR Integer 4 - Year -
3 PERIOD Integer 3 - Period -
4 JOURNAL_NR Integer 8 - Journal number -
5 SEQNR_ATRSH Integer 8 - Sequence number -
6 ENTRY_NR Integer 8 - Entry number -
7 DESCR Character 25 - Description -
8 OPENING_BALANCE_JC Decimal 23 - OpenBal: Journal currency -
9 CLOSING_BALANCE_JC Decimal 23 - ClosBal: Journal currency -
10 IFALL_BLOCK Logical 1 - Block for changes -
11 ORIGIN Integer 8 - Origin -


Bank journal entry line - ATRSS_BANK

Nr Field name Data type Field length Ref Description Check/Action
1 LINENR_ATRSS Integer 4 - Line number -
2 DATE_LINE Date 10 - Date -
3 DESCR_LINE Character 25 - Description -
4 ACC_NR Character 9 ledger General ledger account -
5 ENTRY_TYPE_LINE Integer 6 - Entry: Type -
6 ENTRY_NR_LINE Integer 8 - Entry number -
7 VAT_CODE Character 8 vattrs VAT code -
8 DEBTOR_LINE Integer 8 debtor Debtor -
9 CREDITOR_LINE Integer 8 credit Creditor -
10 CURR_CODE_LINE Character 8 curren Currency -
11 AMOUNT_FC Decimal 23 - Amount -
12 AMOUNT_DC Decimal 23 - Amount: Default currency -
13 EXCH_RATE_LINE Decimal 13 - Exchange rate -
14 VAT_AMOUNT_FC Decimal 23 - VAT amount -
15 VAT_AMOUNT_DC Decimal 23 - VAT amount DC -
16 AMOUNT_JC Decimal 23 - Amount: Journal currency -
17 VAT_AMOUNT_JC Decimal 23 - VAT amount: Journal currency -
18 QUANTITY Decimal 10 - Quantity -
19 COST_CENTER Character 8 ccent Cost center -
20 COST_UNIT Character 8 cunit Cost unit -
21 MDIM_CODE_1 Character 8 - Dimension 1 -
22 MDIM_CODE_2 Character 8 - Dimension 2 -
23 MDIM_CODE_3 Character 8 - Dimension 3 -
24 MDIM_CODE_4 Character 8 - Dimension 4 -
25 MDIM_CODE_5 Character 8 - Dimension 5 -
26 IC_ACC_NR Character 9 ledger IC: G/L account -
27 IC_COST_CENTER Character 8 ccent IC: Cost center -
28 IC_COST_UNIT Character 8 cunit IC: Cost unit -
29 IC_MDIM_CODE_1 Character 8 - IC: Dimension 1 -
30 IC_MDIM_CODE_2 Character 8 - IC: Dimension 2 -
31 IC_MDIM_CODE_3 Character 8 - IC: Dimension 3 -
32 IC_MDIM_CODE_4 Character 8 - IC: Dimension 4 -
33 IC_MDIM_CODE_5 Character 8 - IC: Dimension 5 -
34 IC_PROJECT_CODE Character 10 prmst IC: Project -
35 IC_COST_CAT_CODE Character 8 prccat IC: Project cost category -
36 IC_PROJECT_COST_CENTER Character 8 ccent IC: Project cost center -
37 IC_PROJECT_DESCR Character 30 - IC: Project description -
38 IC_RESULT_TYPE Integer 6 1 IC: Project result type -
39 IC_QUANTITY Decimal 16 - IC: Quantity -
40 IC_ORIGIN Integer 6 - Origin -
41 IC_NR_PERIODS_ALLOCATION Integer 2 - IC: Number of periods -
42 IC_START_YEAR_ALLOCATION Integer 4 - Start year period allocation -
43 IC_START_PERIOD_ALLOCATION Integer 3 - Start period period allocation -
44 IC_DEBTOR Integer 8 debtor IC: Debtor -
45 IC_CREDITOR Integer 8 credit IC: Creditor -
46  IC_OI_ENTRY_NR Integer 8 - IC: Invoice number -
47  IC_OI_ENTRY_TYPE Integer 2 2 IC: Invoice number type -
48  IC_DIFF_CODE Integer 2 3 IC: Difference code -
49 IC_DISCOUNT_AMOUNT_FC Decimal 23 - IC: Discount amount -
50 IC_PAYMENT_CHARGE_FC Decimal 23 - IC: Payment charge -
51 IC_PAYMENT_DIFFERENCE_FC Decimal 23 - IC: Payment difference -
52 PROJECT_CODE Character 10 prmst Project -
53 COST_CAT_CODE Character 8 prccat Project cost category -
54 PROJECT_COST_CENTER Character 8 ccent Project cost center -
55 PROJECT_DESCR Character 30 - Project description -
56  RESULT_TYPE Integer 6 1 Project result type -
57  NR_PERIODS_ALLOCATION Integer 8 - Number of periods -
58 START_YEAR_ALLOCATION Integer 8 - Start year period allocation -
59 START_PERIOD_ALLOCATION Integer 8 - Start period period allocation -
60 OUTST_ITEM_ENTRY_TYPE Integer 6 2 Outstanding item: Entry type -
61 OUTST_ITEM_ENTRY_NR Integer 8 - Outstanding item: Entry number -
62 OUTST_ITEM_CURR_CODE Character 8 curren Outstanding item: Currency -
63 OUTST_ITEM_EXCH_RATE Decimal 13 - Outstanding item: ExRate -
64 AMOUNT_OC Decimal 23 - Amount: OI currency -
65 OUTST_ITEM_DIFFERENCE Integer 6 3 Difference code -
66  OUTST_ITEM_DISCOUNT_FC Decimal 23 - Discount amount -
67  OUTST_ITEM_PAY_CHARGE_FC Decimal 23 - Payment charge -
68 OUTST_ITEM_PAY_DIFFERENCE_FC Decimal 23 - Payment difference -


Cash journal entries

Cash journal entry header - ATRSH_CASH

Nr Field name Data type Field length Ref Description Check/Action
1 ADM_NR Integer 6 admdat Company -
2 YEAR Integer 4 - Year -
3 PERIOD Integer 3 - Period -
4 JOURNAL_NR Integer 8 - Journal number -
5 SEQNR_ATRSH Integer 8 - Sequence number -
6 DESCR Character 25 - Description -
7 OPENING_BALANCE_JC Decimal 23 - OpenBal: Journal currency -
8 CLOSING_BALANCE_JC Decimal 23 - ClosBal: Journal currency -
9 IFALL_BLOCK Logical 1 - Block for changes -
10 ORIGIN Integer 8 - Origin -


Cash journal entry line - ATRSS_CASH

Nr Field name Data type Field length Ref Description Check/Action
1 LINENR_ATRSS Integer 4 - Line number -
2 DATE_LINE Date 10 - Date -
3 DESCR_LINE Character 25 - Description -
4 ACC_NR Character 9 ledger General ledger account -
5 ENTRY_TYPE_LINE Integer 6 - Entry: Type -
6 ENTRY_NR_LINE Integer 8 - Entry number -
7 VAT_CODE Character 8 vattrs VAT code -
8 DEBTOR_LINE Integer 8 debtor Debtor -
9 CREDITOR_LINE Integer 8 credit Creditor -
10 CURR_CODE_LINE Character 8 curren Currency -
11 AMOUNT_FC Decimal 23 - Amount -
12 AMOUNT_DC Decimal 23 - Amount: Default currency -
13 EXCH_RATE_LINE Decimal 13 - Exchange rate -
14 VAT_AMOUNT_FC Decimal 23 - VAT amount -
15 VAT_AMOUNT_DC Decimal 23 - VAT amount DC -
16 AMOUNT_JC Decimal 23 - Amount: Journal currency -
17 VAT_AMOUNT_JC Decimal 23 - VAT amount: Journal currency -
18 QUANTITY Decimal 10 - Quantity -
19 COST_CENTER Character 8 ccent Cost center -
20 COST_UNIT Character 8 cunit Cost unit -
21 MDIM_CODE_1 Character 8 - Dimension 1 -
22 MDIM_CODE_2 Character 8 - Dimension 2 -
23 MDIM_CODE_3 Character 8 - Dimension 3 -
24 MDIM_CODE_4 Character 8 - Dimension 4 -
25 MDIM_CODE_5 Character 8 - Dimension 5 -
26 IC_ACC_NR Character 9 ledger IC: G/L account -
27 IC_COST_CENTER Character 8 ccent IC: Cost center -
28 IC_COST_UNIT Character 8 cunit IC: Cost unit -
29 IC_MDIM_CODE_1 Character 8 - IC: Dimension 1 -
30 IC_MDIM_CODE_2 Character 8 - IC: Dimension 2 -
31 IC_MDIM_CODE_3 Character 8 - IC: Dimension 3 -
32 IC_MDIM_CODE_4 Character 8 - IC: Dimension 4 -
33 IC_MDIM_CODE_5 Character 8 - IC: Dimension 5 -
34 IC_PROJECT_CODE Character 10 prmst IC: Project -
35 IC_COST_CAT_CODE Character 8 prccat IC: Project cost category -
36 IC_PROJECT_COST_CENTER Character 8 ccent IC: Project cost center -
37 IC_PROJECT_DESCR Character 30 - IC: Project description -
38 IC_RESULT_TYPE Integer 6 1 IC: Project result type -
39 IC_QUANTITY Decimal 16 - IC: Quantity -
40 IC_ORIGIN Integer 6 - Origin -
41 IC_NR_PERIODS_ALLOCATION Integer 2 - IC: Number of periods -
42 IC_START_YEAR_ALLOCATION Integer 4 - Start year period allocation -
43 IC_START_PERIOD_ALLOCATION Integer 3 - Start period period allocation -
44 IC_DEBTOR Integer 8 debtor IC: Debtor -
45 IC_CREDITOR Integer 8 credit IC: Creditor -
46  IC_OI_ENTRY_NR Integer 8 - IC: Invoice number -
47  IC_OI_ENTRY_TYPE Integer 2 2 IC: Invoice number type -
48  IC_DIFF_CODE Integer 2 3 IC: Difference code -
49 IC_DISCOUNT_AMOUNT_FC Decimal 23 - IC: Discount amount -
50 IC_PAYMENT_CHARGE_FC Decimal 23 - IC: Payment charge -
51 IC_PAYMENT_DIFFERENCE_FC Decimal 23 - IC: Payment difference -
52 PROJECT_CODE Character 10 prmst Project -
53 COST_CAT_CODE Character 8 prccat Project cost category -
54 PROJECT_COST_CENTER Character 8 ccent Project cost center -
55 PROJECT_DESCR Character 30 - Project description -
56  RESULT_TYPE Integer 6 1 Project result type -
57  NR_PERIODS_ALLOCATION Integer 8 - Number of periods -
58 START_YEAR_ALLOCATION Integer 8 - Start year period allocation -
59 START_PERIOD_ALLOCATION Integer 8 - Start period period allocation -
60 OUTST_ITEM_ENTRY_TYPE Integer 6 2 Outstanding item: Entry type -
61 OUTST_ITEM_ENTRY_NR Integer 8 - Outstanding item: Entry number -
62 OUTST_ITEM_CURR_CODE Character 8 curren Outstanding item: Currency -
63 OUTST_ITEM_EXCH_RATE Decimal 13 - Outstanding item: ExRate -
64 AMOUNT_OC Decimal 23 - Amount: OI currency -
65 OUTST_ITEM_DIFFERENCE Integer 6 3 Difference code -
66 OUTST_ITEM_DISCOUNT_FC Decimal 23 - Discount amount -
67 OUTST_ITEM_PAY_CHARGE_FC Decimal 23 - Payment charge -
68 OUTST_ITEM_PAY_DIFFERENCE_FC Decimal 23 - Payment difference -

General journal entries

General journal entry header - ATRSH_GENERAL

Nr Field name Data type Field length Ref Description Check/Action
1 ADM_NR Integer 6 admdat Company -
2 YEAR Integer 4 - Year -
3 PERIOD Integer 3 - Period -
4 JOURNAL_NR Integer 8 journl Journal number -
5 SEQNR_ATRSH Integer 8 - Sequence number -
6 ORIGIN Integer 8 - Origin -
7 ENTRY_TYPE Integer 6 - Entry: Type -
8 ENTRY_NR Integer 8 - Entry number -
9 DESCR Character 25 - Description -


General journal entry lines - ATRSS_GENERAL

Nr Field name Data type Field length Ref Description Check/Action
1 LINENR_ATRSS Integer 4 - Line number -
2 DATE_LINE Date 10 - Date -
3 DESCR_LINE Character 25 - Description -
4 ACC_NR Character 9 ledger General ledger account -
5 DEBTOR_LINE Integer 8 debtor Debtor -
6 CREDITOR_LINE Integer 8 credit Creditor -
7 CURR_CODE_LINE Character 8 curren Currency -
8 AMOUNT_FC Decimal 23 - Amount -
9 AMOUNT_DC Decimal 23 - Amount: Default currency -
10 EXCH_RATE_LINE Decimal 13 - Exchange rate -
11 QUANTITY Decimal 10 - Quantity -
12 COST_CENTER Character 8 ccent Cost center -
13 COST_UNIT Character 8 cunit Cost unit -
14 MDIM_CODE_1 Character 8 - Dimension 1 -
15 MDIM_CODE_2 Character 8 - Dimension 2 -
16 MDIM_CODE_3 Character 8 - Dimension 3 -
17 MDIM_CODE_4 Character 8 - Dimension 4 -
18 MDIM_CODE_5 Character 8 - Dimension 5 -
19 PROJECT_CODE Character 10 prmst Project -
20 COST_CAT_CODE Character 8 prccat Project cost category -
21 PROJECT_COST_CENTER Character 8 ccent Project cost center -
22 PROJECT_DESCR Character 30 - Project description -
23 RESULT_TYPE Integer 6 1 Project result type -
24 NR_PERIODS_ALLOCATION Integer 8 - Number of periods -
25 START_YEAR_ALLOCATION Integer 8 - Start year period allocation -
26 START_PERIOD_ALLOCATION Integer 8 - Start period period allocation -
27 IC_ACC_NR Character 9 ledger IC: G/L account -
28 IC_COST_CENTER Character 8 ccent IC: Cost center -
29 IC_COST_UNIT Character 8 cunit IC: Cost unit -
30 IC_MDIM_CODE_1 Character 8 - IC: Dimension 1 -
31 IC_MDIM_CODE_2 Character 8 - IC: Dimension 2 -
32 IC_MDIM_CODE_3 Character 8 - IC: Dimension 3 -
33 IC_MDIM_CODE_4 Character 8 - IC: Dimension 4 -
34 IC_MDIM_CODE_5 Character 8 - IC: Dimension 5 -
35 IC_PROJECT_CODE Character 10 prmst IC: Project -
36 IC_COST_CAT_CODE Character 8 prccat IC: Project cost category -
37 IC_PROJECT_COST_CENTER Character 8 ccent IC: Project cost center -
38 IC_PROJECT_DESCR Character 30 - IC: Project description -
39 IC_RESULT_TYPE Integer 6 1 IC: Project result type -
40 IC_QUANTITY Decimal 16 - IC: Quantity -
41 IC_ORIGIN Integer 6 - Origin -
42 IC_NR_PERIODS_ALLOCATION Integer 2 - IC: Number of periods -
43 IC_START_YEAR_ALLOCATION Integer 4 - Start year period allocation -
44 IC_START_PERIOD_ALLOCATION Integer 3 - Start period period allocation -
45 IC_DEBTOR Integer 8 debtor IC: Debtor -
46 IC_CREDITOR Integer 8 credit IC: Creditor -
47 IC_OI_ENTRY_NR Integer 8 - IC: Invoice number -
48 IC_OI_ENTRY_TYPE Integer 2 2 IC: Invoice number type -
49 IC_DIFF_CODE Integer 2 3 IC: Difference code -
50 IC_DISCOUNT_AMOUNT_FC Decimal 23 - IC: Discount amount -
51 IC_PAYMENT_CHARGE_FC Decimal 23 - IC: Payment charge -
52 IC_PAYMENT_DIFFERENCE_FC Decimal 23 - IC: Payment difference -
53 OUTST_ITEM_ENTRY_TYPE Integer 6 2  Outstanding item: Entry type -
54 OUTST_ITEM_ENTRY_NR Integer 8 - Outstanding item: Entry number -
55 OUTST_ITEM_CURR_CODE Character 8 curren Outstanding item: Currency -
56  OUTST_ITEM_EXCH_RATE Decimal 13 - Outstanding item: ExRate -
57  AMOUNT_OC Decimal 23 - Amount: OI currency -
58 OUTST_ITEM_DIFFERENCE Integer 6 3 Difference code -
59 OUTST_ITEM_DISCOUNT_FC Decimal 23 - Discount amount -
60 OUTST_ITEM_PAY_CHARGE_FC Decimal 23 - Payment charge -
61 OUTST_ITEM_PAY_DIFFERENCE_FC Decimal 23 - Payment difference -
62 OUTST_ITEM_PAY_CONDITION* Character 4 paycon Payment condition -
63 OUTST_ITEM_PAY_REFERENCE* Character 20 - Payment reference -
64 OUTST_ITEM_PAY_METHOD* Integer 6 4 Payment method -
65 OUTST_ITEM_DUE_DATE* Date 10 - Due date -
66 OUTST_ITEM_DUE_WEEK* Integer 2 - Due week -
67 OUTST_ITEM_BLOCKED_LINE* Logical 1 - Outstanding item: Blocked -
68 OUTST_ITEM_AMT_BLOCK_FC* Decimal   23 - Amount blocked account -
* = Available as of version 3.34.6


Giro journal entries

Giro journal entry header - ATRSH_GIRO

Nr Field name Data type Field length Ref Description Check/Action
1 ADM_NR Integer 6 admdat Company -
2 YEAR Integer 4 - Year -
3 PERIOD Integer 3 - Period -
4 JOURNAL_NR Integer 8 - Journal number -
5 SEQNR_ATRSH Integer 8 - Sequence number -
6 ENTRY_NR Integer 8 - Entry number -
7 DESCR Character 25 - Description -
8 OPENING_BALANCE_JC Decimal 23 - OpenBal: Journal currency -
9 CLOSING_BALANCE_JC Decimal 23 - ClosBal: Journal currency -
10 IFALL_BLOCK Logical 1 - Block for changes -
11 ORIGIN Integer 8 - Origin -


Giro journal entry line - ATRSS_GIRO

Nr Field name Data type Field length Ref Description Check/Action
1 LINENR_ATRSS Integer 4 - Line number -
2 DATE_LINE Date 10 - Date -
3 DESCR_LINE Character 25 - Description -
4 ACC_NR Character 9 ledger General ledger account -
5 VAT_CODE Character 8 vattrs VAT code -
6 DEBTOR_LINE Integer 8 debtor Debtor -
7 CREDITOR_LINE Integer 8 credit Creditor -
8 CURR_CODE_LINE Character 8 curren Currency -
9 AMOUNT_FC Decimal 23 - Amount -
10 AMOUNT_DC Decimal 23 - Amount: Default currency -
11 EXCH_RATE_LINE Decimal 13 - Exchange rate -
12 VAT_AMOUNT_FC Decimal 23 - VAT amount -
13 VAT_AMOUNT_DC Decimal 23 - VAT amount DC -
14 AMOUNT_JC Decimal 23 - Amount: Journal currency -
15 VAT_AMOUNT_JC Decimal 23 - VAT amount: Journal currency -
16 QUANTITY Decimal 10 - Quantity -
17 COST_CENTER Character 8 ccent Cost center -
18 COST_UNIT Character 8 cunit Cost unit -
19 MDIM_CODE_1 Character 8 - Dimension 1 -
20 MDIM_CODE_2 Character 8 - Dimension 2 -
21 MDIM_CODE_3 Character 8 - Dimension 3 -
22 MDIM_CODE_4 Character 8 - Dimension 4 -
23 MDIM_CODE_5 Character 8 - Dimension 5 -
24 PROJECT_CODE Character 10 prmst Project -
25 COST_CAT_CODE Character 8 prccat Project cost category -
26 IC_ACC_NR Character 9 ledger IC: G/L account -
27 IC_COST_CENTER Character 8 ccent IC: Cost center -
28 IC_COST_UNIT Character 8 cunit IC: Cost unit -
29 IC_MDIM_CODE_1 Character 8 - IC: Dimension 1 -
30 IC_MDIM_CODE_2 Character 8 - IC: Dimension 2 -
31 IC_MDIM_CODE_3 Character 8 - IC: Dimension 3 -
32 IC_MDIM_CODE_4 Character 8 - IC: Dimension 4 -
33 IC_MDIM_CODE_5 Character 8 - IC: Dimension 5 -
34 IC_PROJECT_CODE Character 10 prmst IC: Project -
35 IC_COST_CAT_CODE Character 8 prccat IC: Project cost category -
36 IC_PROJECT_COST_CENTER Character 8 ccent IC: Project cost center -
37 IC_PROJECT_DESCR Character 30 - IC: Project description -
38 IC_RESULT_TYPE Integer 6 1 IC: Project result type -
39 IC_QUANTITY Decimal 16 - IC: Quantity -
40 IC_ORIGIN Integer 6 - Origin -
41 IC_NR_PERIODS_ALLOCATION Integer 2 - IC: Number of periods -
42 IC_START_YEAR_ALLOCATION Integer 4 - Start year period allocation -
43 IC_START_PERIOD_ALLOCATION Integer 3 - Start period period allocation -
44 IC_DEBTOR Integer 8 debtor IC: Debtor -
45 IC_CREDITOR Integer 8 credit IC: Creditor -
46  IC_OI_ENTRY_NR Integer 8 - IC: Invoice number -
47 IC_OI_ENTRY_TYPE Integer 2 2 IC: Invoice number type -
48 IC_DIFF_CODE Integer 2 3 IC: Difference code -
49 IC_DISCOUNT_AMOUNT_FC Decimal 23 - IC: Discount amount -
50 IC_PAYMENT_CHARGE_FC Decimal 23 - IC: Payment charge -
51 IC_PAYMENT_DIFFERENCE_FC Decimal 23 - IC: Payment difference -
52 PROJECT_COST_CENTER Character 8 ccent Project cost center -
53 PROJECT_DESCR Character 30 - Project description -
54 RESULT_TYPE Integer 6 1  Project result type -
55 NR_PERIODS_ALLOCATION Integer 8 - Number of periods -
56  START_YEAR_ALLOCATION Integer 8 - Start year period allocation -
57  START_PERIOD_ALLOCATION Integer 8 - Start period period allocation -
58 OUTST_ITEM_ENTRY_TYPE Integer 6 2 Outstanding item: Entry type -
59 OUTST_ITEM_ENTRY_NR Integer 8 - Outstanding item: Entry number -
60 OUTST_ITEM_CURR_CODE Character 8 curren Outstanding item: Currency -
61 OUTST_ITEM_EXCH_RATE Decimal 13 - Outstanding item: ExRate -
62 AMOUNT_OC Decimal 23 - Amount: OI currency -
63 OUTST_ITEM_DIFFERENCE Integer 6 3 Difference code -
64 OUTST_ITEM_DISCOUNT_FC Decimal 23 - Discount amount -
65 OUTST_ITEM_PAY_CHARGE_FC Decimal 23 - Payment charge -
66  OUTST_ITEM_PAY_DIFFERENCE_FC Decimal 23 - Payment difference -


Purchase journal entries

Purchase journal entry header - ATRSH_PURCHASE

Nr Field name Data type Field length Ref Description Check/Action
1 ADM_NR Integer 6 admdat Company -
2 YEAR Integer 4 - Year -
3 PERIOD Integer 3 - Period -
4 JOURNAL_NR Integer 8 - Journal number -
5 SEQNR_ATRSH Integer 8 - Sequence number -
6 ENTRY_NR Integer 8 - Entry number -
7 DESCR Character 25 - Description -
8 DATE Date 10 - Date -
9 CREDITOR Integer 8 credit Creditor -
10 CURR_CODE Character 8 curren Currency -
11 AMOUNT_INC_VAT_FC Decimal 23 - Amount -
12 AMOUNT_INC_VAT_DC Decimal 23 - Amount: Default currency -
13 EXCH_RATE Decimal 13 - Exchange rate -
14 REVERSAL_ENTRY Logical 1 - Reversal entry -
15 SEQNR_BOE Integer 8 - B/E number -
16 PAY_CONDITION Character 8 paycon Payment condition -
17 PAY_REFERENCE Character 20 - Payment reference -
18 PAY_METHOD Integer 6 4  Payment method -
19 SURCHARGE_DISCOUNT Integer 6 5  Payment charge/discount -
20 DUE_DATE Date 10 - Due date -
21 DUE_WEEK Integer 8 - Due week -
22 PERCENTAGE_1 Decimal 10 - Payment charge: Percentage 1 -
23 AMOUNT_1_FC Decimal 23 - Payment charge: Amount 1 -
24 DUE_DATE_1 Date 10 - Payment charge: Due date 1 -
25 PERCENTAGE_2 Decimal 10 - Payment charge: Percentage 2 -
26 AMOUNT_2_FC Decimal 23 - Payment charge: Amount 2 -
27 DUE_DATE_2 Date 10 - Payment charge: Due date 2 -
28 PERCENTAGE_3 Decimal 10 - Payment charge: Percentage 3 -
29 AMOUNT_3_FC Decimal 23 - Payment charge: Amount 3 -
30 DUE_DATE_3 Date 10 - Payment charge: Due date 3 -
31 PERCENTAGE_4 Decimal 10 - Payment charge: Percentage 4 -
32 AMOUNT_4_FC Decimal 23 - Payment charge: Amount 4 -
33 DUE_DATE_4 Date 10 - Payment charge: Due date 4 -
34 PERCENTAGE_5 Decimal 10 - Payment charge: Percentage 5 -
35 AMOUNT_5_FC Decimal 23 - Payment charge: Amount 5 -
36 DUE_DATE_5 Date 10 - Payment charge: Due date 5 -
37 EXTERNAL_ENTRY_NR Character 30 - External entry number -
38 OUTST_ITEM_BLOCKED Logical 1 - Outstanding item: Blocked -
39 IFALL_BLOCK Logical 1 - Block for changes -
40 ORIGIN Integer 8 - Origin -


Purchase journal entry line - ATRSS_PURCHASE

Nr Field name Data type Field length Ref Description Check/Action
1 LINENR_ATRSS Integer 4 - Line number -
2 COMMITMENT_NR Integer 8 - Commitment -
3 COMMITMENT_LINE Integer 8 - Commitment line -
4 COMMITMENT_AMT_EX_VAT_FC Decimal 23 - Commitment: Amount FC -
5 COMMITMENT_CORR_EX_VAT_FC Decimal 23 - Commitment correction -
6 DESCR_LINE Character 25 - Description -
7 ACC_NR Character 9 ledger General ledger account -
8 VAT_CODE Character 8 vattrs VAT code -
9 AMOUNT_FC Decimal 23 - Amount -
10 AMOUNT_DC Decimal 23 - Amount: Default currency -
11 VAT_AMOUNT_FC Decimal 23 - VAT amount -
12 VAT_AMOUNT_DC Decimal 23 - VAT amount DC -
13 QUANTITY Decimal 10 - Quantity -
14 COST_CENTER Character 8 ccent Cost center -
15 COST_UNIT Character 8 cunit Cost unit -
16 MDIM_CODE_1 Character 8 - Dimension 1 -
17 MDIM_CODE_2 Character 8 - Dimension 2 -
18 MDIM_CODE_3 Character 8 - Dimension 3 -
19 MDIM_CODE_4 Character 8 - Dimension 4 -
20 MDIM_CODE_5 Character 8 - Dimension 5 -
21 PROJECT_CODE Character 10 prmst Project -
22 COST_CAT_CODE Character 8 prccat Project cost category -
23 PROJECT_COST_CENTER Character 8 ccent Project cost center -
24 PROJECT_DESCR Character 30 - Project description -
25 RESULT_TYPE Integer 6 1 Project result type -
26 IC_ACC_NR Character 9 ledger IC: G/L account -
27 IC_COST_CENTER Character 8 ccent IC: Cost center -
28 IC_COST_UNIT Character 8 cunit IC: Cost unit -
29 IC_MDIM_CODE_1 Character 8 - IC: Dimension 1 -
30 IC_MDIM_CODE_2 Character 8 - IC: Dimension 2 -
31 IC_MDIM_CODE_3 Character 8 - IC: Dimension 3 -
32 IC_MDIM_CODE_4 Character 8 - IC: Dimension 4 -
33 IC_MDIM_CODE_5 Character 8 - IC: Dimension 5 -
34 IC_PROJECT_CODE Character 10 prmst IC: Project -
35 IC_COST_CAT_CODE Character 8 prccat IC: Project cost category -
36 IC_PROJECT_COST_CENTER Character 8 ccent IC: Project cost center -
37 IC_PROJECT_DESCR Character 30 - IC: Project description -
38 IC_RESULT_TYPE Integer 6 1 IC: Project result type -
39 IC_QUANTITY Decimal 16 - IC: Quantity -
40 IC_ORIGIN Integer 6 - Origin -
41 IC_NR_PERIODS_ALLOCATION Integer 2 - IC: Number of periods -
42 IC_START_YEAR_ALLOCATION Integer 4 - Start year period allocation -
43 IC_START_PERIOD_ALLOCATION Integer 3 - Start period period allocation -
44 NR_PERIODS_ALLOCATION Integer 8 - Number of periods -
45 START_YEAR_ALLOCATION Integer 8 - Start year period allocation -
46  START_PERIOD_ALLOCATION Integer 8 - Start period period allocation -
47  ASSET_CODE Character 12 - Asset -
48 ASSET_SET Character 8 fas_mast Asset set -
49 ASSET_DESCR Character 30 - Asset description -
50 ASSET_QUANTITY Decimal 11 - Asset quantity -


Sales journal entries

Sales journal entry header - ATRSH_SALES

Nr Field name Data type Field length Ref Description Check/Action
1 ADM_NR Integer 6 admdat Company -
2 YEAR Integer 4 - Year -
3 PERIOD Integer 3 - Period -
4 JOURNAL_NR Integer 8 - Journal number -
5 SEQNR_ATRSH Integer 8 - Sequence number -
6 ENTRY_NR Integer 8 - Entry number -
7 DESCR Character 25 - Description -
8 DATE Date 10 - Date -
9 DEBTOR Integer 8 debtor Debtor -
10 CURR_CODE Character 8 curren Currency -
11 AMOUNT_INC_VAT_FC Decimal 23 - Amount -
12 AMOUNT_INC_VAT_DC Decimal 23 - Amount: Default currency -
13 EXCH_RATE Decimal 13 - Exchange rate -
14 REVERSAL_ENTRY Logical 1 - Reversal entry -
15 SEQNR_BOE Integer 8 - B/E number -
16 PAY_CONDITION Character 8 paycon Payment condition -
17 PAY_REFERENCE Character 20 - Payment reference -
18 PAY_METHOD Integer 6 4  Payment method -
19 SURCHARGE_DISCOUNT Integer 6 5 Payment charge/discount -
20 DUE_DATE Date 10 - Due date -
21 DUE_WEEK Integer 8 - Due week -
22 PERCENTAGE_1 Decimal 10 - Payment charge: Percentage 1 -
23 AMOUNT_1_FC Decimal 23 - Payment charge: Amount 1 -
24 DUE_DATE_1 Date 10 - Payment charge: Due date 1 -
25 PERCENTAGE_2 Decimal 10 - Payment charge: Percentage 2 -
26 AMOUNT_2_FC Decimal 23 - Payment charge: Amount 2 -
27 DUE_DATE_2 Date 10 - Payment charge: Due date 2 -
28 PERCENTAGE_3 Decimal 10 - Payment charge: Percentage 3 -
29 AMOUNT_3_FC Decimal 23 - Payment charge: Amount 3 -
30 DUE_DATE_3 Date 10 - Payment charge: Due date 3 -
31 PERCENTAGE_4 Decimal 10 - Payment charge: Percentage 4 -
32 AMOUNT_4_FC Decimal 23 - Payment charge: Amount 4 -
33 DUE_DATE_4 Date 10 - Payment charge: Due date 4 -
34 PERCENTAGE_5 Decimal 10 - Payment charge: Percentage 5 -
35 AMOUNT_5_FC Decimal 23 - Payment charge: Amount 5 -
36 DUE_DATE_5 Date 10 - Payment charge: Due date 5 -
37 OUTST_ITEM_BLOCKED Logical 1 - Outstanding item: Blocked -
38 IFALL_BLOCK Logical 1 - Block for changes -
39 ORIGIN Integer 8 - Origin -


Sales journal entry line - ATRSS_SALES

Nr Field name Data type Field length Ref Description Check/Action
1 LINENR_ATRSS Integer 4 - Line number -
2 DESCR_LINE Character 25 - Description -
3 ACC_NR Character 9 ledger General ledger account -
4 VAT_CODE Character 8 vattrs VAT code -
5 AMOUNT_FC Decimal 23 - Amount -
6 AMOUNT_DC Decimal 23 - Amount: Default currency -
7 VAT_AMOUNT_FC Decimal 23 - VAT amount -
8 VAT_AMOUNT_DC Decimal 23 - VAT amount DC -
9 QUANTITY Decimal 10 - Quantity -
10 COST_CENTER Character 8 ccent Cost center -
11 COST_UNIT Character 8 cunit Cost unit -
12 MDIM_CODE_1 Character 8 - Dimension 1 -
13 MDIM_CODE_2 Character 8 - Dimension 2 -
14 MDIM_CODE_3 Character 8 - Dimension 3 -
15 MDIM_CODE_4 Character 8 - Dimension 4 -
16 MDIM_CODE_5 Character 8 - Dimension 5 -
17 PROJECT_CODE Character 10 prmst Project -
18 COST_CAT_CODE Character 8 prccat Project cost category -
19 PROJECT_COST_CENTER Character 8 ccent Project cost center -
20 PROJECT_DESCR Character 30 - Project description -
21 RESULT_TYPE Integer 6 1 Project result type -
22 NR_PERIODS_ALLOCATION Integer 8 - Number of periods -
23 START_YEAR_ALLOCATION Integer 8 - Start year period allocation -
24 START_PERIOD_ALLOCATION Integer 8 - Start period period allocation -
25 IC_ACC_NR Character 9 ledger IC: G/L account -
26 IC_COST_CENTER Character 8 ccent IC: Cost center -
27 IC_COST_UNIT Character 8 cunit IC: Cost unit -
28 IC_MDIM_CODE_1 Character 8 - IC: Dimension 1 -
29 IC_MDIM_CODE_2 Character 8 - IC: Dimension 2 -
30 IC_MDIM_CODE_3 Character 8 - IC: Dimension 3 -
31 IC_MDIM_CODE_4 Character 8 - IC: Dimension 4 -
32 IC_MDIM_CODE_5 Character 8 - IC: Dimension 5 -
33 IC_PROJECT_CODE Character 10 prmst IC: Project -
34 IC_COST_CAT_CODE Character 8 prccat IC: Project cost category -
35 IC_PROJECT_COST_CENTER Character 8 ccent IC: Project cost center -
36 IC_PROJECT_DESCR Character 30 - IC: Project description -
37 IC_RESULT_TYPE Integer 6 1 IC: Project result type -
38 IC_QUANTITY Decimal 16 - IC: Quantity -
39 IC_ORIGIN Integer 6 - Origin -
40 IC_NR_PERIODS_ALLOCATION Integer 2 - IC: Number of periods -
41 IC_START_YEAR_ALLOCATION Integer 4 - Start year period allocation -
42 IC_START_PERIOD_ALLOCATION Integer 3 - Start period period allocation -

VAT journal entries

VAT journal entry header - ATRSH_VAT

Nr Field name Data type Field length Ref Description Check/Action
1 ADM_NR Integer 6 admdat Company -
2 YEAR Integer 4 - Year -
3 PERIOD Integer 3 - Period -
4 JOURNAL_NR Integer 8 - Journal number -
5 SEQNR_ATRSH Integer 8 - Sequence number -
6 ENTRY_NR Integer 8 - Entry number -
7 DESCR Character 25 - Description -
8 IFALL_BLOCK Logical 1 - Block for changes -
9 ORIGIN Integer 8 - Origin -


VAT journal entry line - ATRSS_VAT

Nr Field name Data type Field length Ref Description Check/Action
1 LINENR_ATRSS Integer 4 - Line number -
2 DATE_LINE Date 10 - Date -
3 DESCR_LINE Character 25 - Description -
4 ACC_NR Character 9 ledger General ledger account -
5 VAT_CODE Character 8 vattrs VAT code -
6 CURR_CODE_LINE Character 8 curren Currency -
7 AMOUNT_FC Decimal 23 - Amount -
8 AMOUNT_DC Decimal 23 - Amount: Default currency -
9 EXCH_RATE_LINE Decimal 13 - Exchange rate -
10 VAT_AMOUNT_FC Decimal 23 - VAT amount -
11 VAT_AMOUNT_DC Decimal 23 - VAT amount DC -
12 DELIVERY_ACQUISITION Integer 6 6 Delivery/Acquisition -
13 QUANTITY Decimal 10 - Quantity -
14 COST_CENTER Character 8 ccent Cost center -
15 COST_UNIT Character 8 cunit Cost unit -
16 MDIM_CODE_1 Character 8 - Dimension 1 -
17 MDIM_CODE_2 Character 8 - Dimension 2 -
18 MDIM_CODE_3 Character 8 - Dimension 3 -
19 MDIM_CODE_4 Character 8 - Dimension 4 -
20 MDIM_CODE_5 Character 8 - Dimension 5 -
21 PROJECT_CODE Character 10 prmst Project -
22 COST_CAT_CODE Character 8 prccat Project cost category -
23 PROJECT_COST_CENTER Character 8 ccent Project cost center -
24 PROJECT_DESCR Character 30 - Project description -
25 RESULT_TYPE Integer 6 1  Project result type -
26 NR_PERIODS_ALLOCATION Integer 8 - Number of periods -
27 START_YEAR_ALLOCATION Integer 8 - Start year period allocation -
28 START_PERIOD_ALLOCATION Integer 8 - Start period period allocation -

Valid values

1 - Project result type

  • 400501: expense entry
  • 400502: revenue entry
  • 400503: neutral entry

2 - Entry type

  • 1: normal entry
  • 3: prepayment

3 - Difference code outstanding item

  • 1: do not write off
  • 2: discount
  • 3: payment charge
  • 4: payment difference
  • 5: combination

4 - Payment method

  • 1: cash
  • 2: bank
  • 3: giro
  • 4: collection
  • 5: giro collection
  • 6: cheque
  • 7: BACS
  • 8: only remittance
  • 9: bill of exchange
  • 10: bill of exchange direct to bank
  • 11: Collection in installments

5 - Payment surcharge / Payment discount

  • 1: payment charge
  • 2: payment discount

6 - Delivery / Acquisition

  • 1: delivery
  • 2: acquisition
Connectivity Manual > Contents > IFALL > Finance > Financial entries

     
 Main Category: Support Product Know How  Document Type: Support - On-line help
 Category: On-line help files  Security  level: All - 0
 Sub category: Details  Document ID: 18.329.930
 Assortment: Exact Financials  Date: 03-12-2008
 Release:  Attachment:
 Disclaimer