Difference between revisions of "ProDon:Commitment Importation module"
Pgillespie (talk | contribs) |
Pgillespie (talk | contribs) |
||
Line 45: | Line 45: | ||
| align="center" | <br> | | align="center" | <br> | ||
|- | |- | ||
− | | | + | | CommRecdAnnual<br> |
− | | | + | | CommRecdA<br> |
| <br> | | <br> | ||
− | | '''N''' | + | | '''N''' or '''F''' or '''Empty ''' = No<br>'''O''' or '''T''' = Yes |
| style="text-align: center;" | 1<br> | | style="text-align: center;" | 1<br> | ||
| align="center" | <br> | | align="center" | <br> | ||
|- | |- | ||
− | | | + | | CommCodeEvent<br> |
− | | | + | | CommOccasion<br> |
− | | | + | | CommEvent<br> |
− | | '''Code''' | + | | Existing occasion '''Code'''<br> |
| style="text-align: center;" | 15<br> | | style="text-align: center;" | 15<br> | ||
| align="center" | <br> | | align="center" | <br> | ||
|- | |- | ||
− | | | + | | CommCodeActivity<br> |
− | | | + | | CommAct<br> |
− | | | + | | CommCodeActivity<br> |
− | | '''Code''' | + | | Existing activity '''Code'''<br> |
| style="text-align: center;" | 15<br> | | style="text-align: center;" | 15<br> | ||
| align="center" | [[#2eng|2]]<br> | | align="center" | [[#2eng|2]]<br> | ||
|- | |- | ||
− | | | + | | CommActSource<br> |
| <br> | | <br> | ||
| <br> | | <br> | ||
− | | ''' | + | | Existing '''source'''<br> |
| style="text-align: center;" | 15<br> | | style="text-align: center;" | 15<br> | ||
| align="center" | [[#3eng|3]]<br> | | align="center" | [[#3eng|3]]<br> | ||
|- | |- | ||
− | | | + | | CommCodeGL<br> |
− | | | + | | CommGL<br> |
| <br> | | <br> | ||
− | | '''Code''' | + | | Existing GL '''Code''' <br> |
| style="text-align: center;" | 15<br> | | style="text-align: center;" | 15<br> | ||
| align="center" | [[#etoileeng|[*]]]<br> | | align="center" | [[#etoileeng|[*]]]<br> | ||
|- | |- | ||
− | | | + | | CommFrequency<br> |
− | | | + | | CommFreq<br> |
| <br> | | <br> | ||
− | | '''? | + | | '''?W''' = Every ? week(s)<br>'''?M''' = Every ? month(s)'''?Y''' = Every ? year(s) |
| style="text-align: center;" | 3<br> | | style="text-align: center;" | 3<br> | ||
| align="center" | <br> | | align="center" | <br> | ||
|- | |- | ||
− | | | + | | CommPayment<br> |
− | | | + | | CommPaym<br> |
| <br> | | <br> | ||
− | | ''' | + | | '''Currency format'''<br> |
| style="text-align: center;" | 15<br> | | style="text-align: center;" | 15<br> | ||
| align="center" | <br> | | align="center" | <br> | ||
|- | |- | ||
− | | | + | | CommMethodPayment<br> |
− | | | + | | CommPaym<br> |
− | | | + | | CommPayment<br> |
− | | '''Code''' | + | | Existing payment method '''Code'''<br> |
| style="text-align: center;" | 15<br> | | style="text-align: center;" | 15<br> | ||
| align="center" | <br> | | align="center" | <br> | ||
|- | |- | ||
− | | | + | | CommReferencePayment<br> |
− | | | + | | CommRefPayment<br> |
| <br> | | <br> | ||
| <br> | | <br> | ||
Line 108: | Line 108: | ||
| align="center" | <br> | | align="center" | <br> | ||
|- | |- | ||
− | | | + | | CommTransit<br> |
| <br> | | <br> | ||
| <br> | | <br> | ||
− | | ''' | + | | '''Integer'''<br> |
| style="text-align: center;" | 10<br> | | style="text-align: center;" | 10<br> | ||
| align="center" | [[#4eng|4]]<br> | | align="center" | [[#4eng|4]]<br> | ||
|- | |- | ||
− | | | + | | CommNoInstitution<br> |
| <br> | | <br> | ||
| <br> | | <br> | ||
− | | ''' | + | | '''Integer'''<br> |
| style="text-align: center;" | 10<br> | | style="text-align: center;" | 10<br> | ||
| align="center" | [[#4eng|4]]<br> | | align="center" | [[#4eng|4]]<br> | ||
|- | |- | ||
− | | | + | | CommNameInstitution<br> |
| <br> | | <br> | ||
| <br> | | <br> | ||
Line 129: | Line 129: | ||
| align="center" | <br> | | align="center" | <br> | ||
|- | |- | ||
− | | | + | | CommCreditCardNo<br> |
| <br> | | <br> | ||
| <br> | | <br> | ||
− | | ''' | + | | '''Integer'''<br> |
| style="text-align: center;" | 30<br> | | style="text-align: center;" | 30<br> | ||
| align="center" | [[#4eng|4]]<br> | | align="center" | [[#4eng|4]]<br> | ||
|- | |- | ||
− | | | + | | CommExpiration<br> |
| <br> | | <br> | ||
| <br> | | <br> | ||
− | | '''MM/ | + | | '''MM/YY''' or '''MM/YYYY'''<br>Slash is required |
| style="text-align: center;" | 5 ou 7<br> | | style="text-align: center;" | 5 ou 7<br> | ||
| align="center" | <br> | | align="center" | <br> | ||
|- | |- | ||
− | | | + | | CommNoAccount<br> |
| <br> | | <br> | ||
| <br> | | <br> | ||
− | | ''' | + | | '''Integer'''<br> |
| style="text-align: center;" | 20<br> | | style="text-align: center;" | 20<br> | ||
| align="center" | [[#4eng|4]]<br> | | align="center" | [[#4eng|4]]<br> | ||
|- | |- | ||
− | | | + | | CommRIBKey<br> |
| <br> | | <br> | ||
| <br> | | <br> | ||
− | | ''' | + | | '''Integer'''<br> |
| style="text-align: center;" | 2<br> | | style="text-align: center;" | 2<br> | ||
| align="center" | [[#5eng|5]]<br> | | align="center" | [[#5eng|5]]<br> | ||
|- | |- | ||
− | | | + | | CommSolicitorCode<br> |
− | | | + | | CommSolCode<br> |
| <br> | | <br> | ||
− | | '''Code''' | + | | Existing solicitor '''Code'''<br> |
| style="text-align: center;" | 25<br> | | style="text-align: center;" | 25<br> | ||
| align="center" | <br> | | align="center" | <br> | ||
|- | |- | ||
− | | | + | | CommSolicitorName<br> |
− | | | + | | CommSolName<br> |
| <br> | | <br> | ||
− | | ''' | + | | '''Firstname Lastname''' of an existing solicitor.<br>'''Note:''' The use of this field is not recommended.<br>A known issue can arise if there are multiple identical existing solicitors.<br> |
| style="text-align: center;" | 200<br> | | style="text-align: center;" | 200<br> | ||
| align="center" | <br> | | align="center" | <br> | ||
|- | |- | ||
− | | | + | | CommObjective<br> |
− | | | + | | CommObj<br> |
| <br> | | <br> | ||
− | | ''' | + | | '''Currency format'''<br> |
| style="text-align: center;" | 15<br> | | style="text-align: center;" | 15<br> | ||
| align="center" | <br> | | align="center" | <br> | ||
|- | |- | ||
− | | | + | | CommTerminateIfObjAchvd<br> |
| <br> | | <br> | ||
| <br> | | <br> | ||
− | | '''N''' | + | | '''N''' or '''F''' or '''Empty''' = Non<br>'''Y''' or '''T''' = Yes |
| style="text-align: center;" | 1<br> | | style="text-align: center;" | 1<br> | ||
| align="center" | [[#6eng|6]]<br> | | align="center" | [[#6eng|6]]<br> | ||
|} | |} | ||
− | '''{{Anchor|[+]|pluseng}}''' : | + | '''{{Anchor|[+]|pluseng}}''' : If the symbol [+] is added to the end of the label, the imported data will be added to the existing information in the database. Otherwise, the imported data will replace the existing information. |
'''{{Anchor|[*]|etoileeng}}''' : Si le code [*] est ajouté à la fin du libellé, le code sera créé s'il n'existe pas déjà. | '''{{Anchor|[*]|etoileeng}}''' : Si le code [*] est ajouté à la fin du libellé, le code sera créé s'il n'existe pas déjà. |
Revision as of 13:32, 25 October 2010
Full Label | Abbreviation 1 | Abbreviation 2 | Possible Values | Maximum Length | Specific Properties |
---|---|---|---|---|---|
CommDateRegistration | CommReg |
|
Date Empty = Current date |
10 |
1 |
CommDateStart |
CommStart |
|
Date Empty = Current date |
10 |
1 |
CommDateEnd |
CommEnd |
|
Date Empty = Current date |
10 |
1 |
CommComments |
CommCom |
|
|
255 |
[+] |
CommType |
|
|
Y or Empty = Objective A = Automatic |
1 |
|
CommRecdAnnual |
CommRecdA |
|
N or F or Empty = No O or T = Yes |
1 |
|
CommCodeEvent |
CommOccasion |
CommEvent |
Existing occasion Code |
15 |
|
CommCodeActivity |
CommAct |
CommCodeActivity |
Existing activity Code |
15 |
2 |
CommActSource |
|
|
Existing source |
15 |
3 |
CommCodeGL |
CommGL |
|
Existing GL Code |
15 |
[*] |
CommFrequency |
CommFreq |
|
?W = Every ? week(s) ?M = Every ? month(s)?Y = Every ? year(s) |
3 |
|
CommPayment |
CommPaym |
|
Currency format |
15 |
|
CommMethodPayment |
CommPaym |
CommPayment |
Existing payment method Code |
15 |
|
CommReferencePayment |
CommRefPayment |
|
|
255 |
|
CommTransit |
|
|
Integer |
10 |
4 |
CommNoInstitution |
|
|
Integer |
10 |
4 |
CommNameInstitution |
|
|
|
255 |
|
CommCreditCardNo |
|
|
Integer |
30 |
4 |
CommExpiration |
|
|
MM/YY or MM/YYYY Slash is required |
5 ou 7 |
|
CommNoAccount |
|
|
Integer |
20 |
4 |
CommRIBKey |
|
|
Integer |
2 |
5 |
CommSolicitorCode |
CommSolCode |
|
Existing solicitor Code |
25 |
|
CommSolicitorName |
CommSolName |
|
Firstname Lastname of an existing solicitor. Note: The use of this field is not recommended. A known issue can arise if there are multiple identical existing solicitors. |
200 |
|
CommObjective |
CommObj |
|
Currency format |
15 |
|
CommTerminateIfObjAchvd |
|
|
N or F or Empty = Non Y or T = Yes |
1 |
6 |
[+] : If the symbol [+] is added to the end of the label, the imported data will be added to the existing information in the database. Otherwise, the imported data will replace the existing information.
[*] : Si le code [*] est ajouté à la fin du libellé, le code sera créé s'il n'existe pas déjà.
1 : Le format de date est dicté par le format choisi dans les options d'importation. Les caractères en trop par rapport à la longueur maximale seront ignorés.
2 : Ce champ requiert la présence du champ similaire en Occasion.
3 : Utile seulement si vous utilisez l'option « Créer les activités inexistantes ». Il est impossible d'avoir plus d'une provenance pour un code d'activité donné.
4 : Le champ doit contenir au moins 1 caractère et un maximum de ? caractères. La longueur maximale est définie dans la « Configuration des paiements électroniques ».
5 : Ce champ est obligatoire si les 3 autres champs liés à la validation RIB sont utilisés.
6 : Ce champ est ignoré si l'engagement est de type « Objectif ».
Document name: ProDon:Commitment Importation module