ProDon:Commitment Importation module

From Logilys
Jump to: navigation, search
Commitment Importation module


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