Project

General

Profile

Statistics
| Branch: | Tag: | Revision:

aqbanking / src / libs / plugins / imexporters / csv / profiles / full.conf @ 892bb6c9

History | View | Annotate | Download (3.35 KB)

1

    
2
char name="full"
3
char shortDescr="full profile"
4
char longDescr="This profile supports the CSV format"
5
int import="1"
6
int export="1"
7

    
8
char type="csv"
9
char groupNames="transaction", "transfer", "debitnote", "line"
10
char dateFormat="YYYY/MM/DD"
11
int utc="0"
12

    
13
# The following vars are used when there is an additional field within a
14
# record which defines the sign of the amount.
15
# Some banks use "C" (positive) and "D" (negative) or "Af" (negative) and
16
# "Bij" (positive)
17
int usePosNegField="0"
18
char posNegFieldName="posNeg"
19
#char positiveValues="Bij", "C"
20
#char negativeValues="Af", "D"
21
int defaultIsPositive="1"
22

    
23
# default is "float", other values: "rational"
24
char valueFormat="rational"
25

    
26
params {
27
  # if 1 then values are quoted
28
  quote="1"
29
  
30
  # if 1 then a title line will be written containing the names of each
31
  # column
32
  title="1"
33
  
34
  # special values are "TAB" and "SPACE"
35
  delimiter=";" 
36
  
37
  # this is the group name looked for in the given data to GWEN_CSV_Write
38
  # if not given then all groups match
39
  #group="transaction"
40
  
41
  # this group contains the definition for each column
42
  # each variable in this group has its number as name
43
  # you can use index variables in the names (using square brackets)
44
  # the value of each of these variables is the name of a variable to be looked
45
  # up in the data given to GWEN_CSV_Write
46
  columns {
47
    1="localCountry"
48
    2="localBankCode"
49
    3="localBranchId"
50
    4="localAccountNumber"
51
    5="localSuffix"
52
    6="localIban"
53
    7="localName"
54
    8="localBic"
55
    9="remoteCountry"
56
    10="remoteBankName"
57
    11="remoteBankLocation"
58
    12="remoteBankCode"
59
    13="remoteBranchId"
60
    14="remoteAccountNumber"
61
    15="remoteSuffix"
62
    16="remoteIban"
63
    17="remoteName[0]"
64
    18="remoteName[1]"
65
    19="remoteBic"
66
    20="uniqueId"
67
    21="idForApplication"
68
    22="groupId"
69
    23="valutaDate"
70
    24="date"
71
    25="value/value"
72
    26="value/currency"
73
    27="fees/value"
74
    28="fees/currency"
75
    29="textKey"
76
    30="textKeyExt"
77
    31="transactionKey"
78
    32="customerReference"
79
    33="bankReference"
80
    34="transactionCode"
81
    35="transactionText"
82
    36="primanota"
83
    37="fiId"
84
    38="purpose[0]"
85
    39="purpose[1]"
86
    40="purpose[2]"
87
    41="purpose[3]"
88
    42="purpose[4]"
89
    43="purpose[5]"
90
    44="purpose[6]"
91
    45="purpose[7]"
92
    46="purpose[8]"
93
    47="purpose[9]"
94
    48="purpose[10]"
95
    49="purpose[11]"
96
    50="category[0]"
97
    51="category[1]"
98
    52="category[2]"
99
    53="category[3]"
100
    54="category[4]"
101
    55="category[5]"
102
    56="category[6]"
103
    57="category[7]"
104
    58="period"
105
    59="cycle"
106
    60="executionDay"
107
    61="firstDate"
108
    62="lastDate"
109
    63="nextDate"
110
    64="type"
111
    65="subType"
112
    66="status"
113
    67="charge"
114
    68="remoteAddrStreet"
115
    69="remoteAddrZipcode"
116
    70="remoteAddrCity"
117
    71="remotePhone"
118
    72="unitId"
119
    73="unitIdNameSpace"
120
    74="units/value"
121
    75="units/currency"
122
    76="unitPriceValue/value"
123
    77="unitPriceValue/currency"
124
    78="commissionValue/value"
125
    79="commissionValue/currency"
126
    80="bankAccountId"
127
    81="groupId"                    # double entry
128

    
129
    82="creditorSchemeId"           # SEPA debit notes
130
    83="originatorId"
131
    84="mandateId"
132
    85="mandateDate"
133
    86="mandateDebitorName"
134
    87="sequence"
135
    88="originalCreditorSchemeId"
136
    89="originalMandateId"
137
    90="originalCreditorName"
138
    91="endToEndReference"
139
  } # columns
140

    
141
} # params
142