ProDon:Commitment Importation module

Template:Header ProDon

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 or 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.

[*] : 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" option is selected. The use of more than one source for a given activity 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