ProDon:Commitment Importation module

From Logilys
Revision as of 13:36, 25 October 2010 by Pgillespie (talk | contribs)
Jump to: navigation, search

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

[*] : 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