ProDon:Commitment Importation module

Commitment Importation module

Printable version

---

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
CommDateNext			Date Empty = Current date	10	1
CommComments	CommCom			255	[+]
CommType			Y or Empty = Objective A = Automatic	1
CommAnnualReceipt	CommAReceipt		N or F or Empty = No Y or T = Yes	1
CommCodeOccasion	CommOccasion	CommOcc	Existing occasion Code	15
CommCodeActivity	CommActivity	CommAct	Existing activity Code	15	2
CommDescOccasion				100	3
CommDescActivity				100	3
CommActOrigin			Existing origin	15	3
CommCodeGL	CommGL		Existing GL Code	15	[*]
CommFrequency	CommFreq		?W = Every ? week(s) ?M = Every ? month(s) ?Y = Every ? year(s)	3
CommInstalment	CommInstalm		Currency format	15
CommPaymentMethod	CommPayment	CommPaym	Existing payment method Code	15
CommPaymentReference	CommPaymentRef			255
CommTransit			Integer	10	4
CommInstitutionNo			Integer	10	4
CommInstitutionName				255
CommCreditCardNo			Integer	30	4
CommExpiration			MM/YY or MM/YYYY Slash is required	5 or 7
CommAccountNo			Integer	20	4
CommRIBKey			Integer	2	5
CommCanvasserCode	CommCanvCode		Existing solicitor Code	25
CommCanvasserName	CommCanvName		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
CommCompleteIfObjAchieved			N or F or Empty = No 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.

[*] : If the symbol [*] is added to the end of the label, the code will be created if it does not already exist.

1 : The date format is determined by the format selected in the import options. Characters that extend beyond the maximum length will be ignored.

2 : This field requires the presence of a similar field under Occasion.

3 : Useful only if the "Create non-existent activities or occasion" option is selected. The use of more than one origin or description for a given activity or occasion code is not allowed.

4 : The field must contain at least 1 character and no more than ? characters. The maximum length is defined in the electronic payment configuration.

5 : This field is required if the 3 other RIB validation-related fields are used.

6 : This field is ignored if the commitment type is "Objective."

---

Document name: ProDon:Commitment Importation module

Printable version