| Field Name |
|
Select By Default |
Filterable |
Sortable |
Postable |
Post Default Value |
Putable |
| accountName |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- Required Field - The account name must be specified
|
| accountNumber |
|
|
|
|
|
- |
|
| accountverified |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- Must be a date - accountverified must be a valid date of format DD/MM/YYYY
- Required Field - This can not be empty if Account Verified By is provided
|
| accountVerifiedBy |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- Required Field - This can not be empty if Account Verified is provided
|
| balance |
|
|
|
|
|
- |
|
| banddescription |
|
|
|
|
|
- |
|
| bandID |
|
|
|
|
|
- |
|
| bandname |
|
|
|
|
|
- |
|
| bankAddress |
|
|
|
|
|
- |
|
| bankName |
|
|
|
|
|
- |
|
| bankPostcode |
|
|
|
|
|
- |
|
| bic |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- Must macth the RegEx: ^([A-Z]{4}[A-Z]{2}[A-Z0-9]{2}([A-Z0-9]{3})?)$ - Please enter a valid BIC / Swift Code. It should contain only numbers and upper case letters (no spaces) and be in the form "6 letters + 2 numbers or letters (+ optional: 3 numbers or letters)"
|
| created |
|
|
|
|
|
- |
|
| currency |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- The currency must exist again the lookup
|
| ddiDateReceived |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- Must be a date - ddiDateReceived must be a valid date of format DD/MM/YYYY
- Required Field - You must enter the ddiDateReceived
|
| ddiMethod |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- Required Field - You must enter the ddiMethod
|
| ddiStartDate |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- Must be a date - ddiStartDate must be a valid date of format DD/MM/YYYY
|
| ddiStatus |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- Required Field - You must enter the ddiStatus
|
| directDebitInstruction |
|
|
|
|
|
- |
|
| expirydate |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- Must be a date - expirydate must be a valid date of format DD/MM/YYYY
- Required Field - Please enter an Expiry Date or mark the membership as Open Ended
- Must be greater than or equal to @STARTDATE - Expiry Date must be greater than or equal to Start Date
|
| ibanNumber |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- Must macth the RegEx: ^[A-Z]{2}[0-9]{2}([A-Z0-9]?){0,30}$ - Please enter a valid IBAN. IBANs should contain only numbers and upper case letters (no spaces) and be in the form "2 letters + 2 numbers + up to 30 numbers or letters"
|
| invoiceAddressLine1 |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- Required Field - You must enter the invoiceAddressLine1
|
| invoiceAddressline3 |
|
|
|
|
|
- |
|
| invoiceAddressline4 |
|
|
|
|
|
- |
|
| invoiceCountry |
|
|
|
|
|
- |
|
| invoicePostcode |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- Required Field - You must enter the invoicePostcode
|
| locationOfPaperDDI |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- Required Field - You must enter the locationOfPaperDDI
|
| membershipcardno |
|
|
|
|
|
- |
|
| membershipDetailID |
|
|
|
|
|
- |
|
| membershipID |
|
|
|
|
|
- |
|
| membershiptype |
|
|
|
|
|
- |
|
| modified |
|
|
|
|
|
- |
|
| nextPayment |
|
|
|
|
|
- |
|
| nextPaymentAmount |
|
|
|
|
|
- |
|
| outstanding |
|
|
|
|
|
- |
|
| paymentDay |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- Must be numeric - paymentDay must be numeric
- Must be greater than 0
- Must be less than or equal to 28
- Required Field - You must enter the paymentDay
|
| paymentFrequency |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- Required Field - You must enter the paymentFrequency
|
| paymentStartDate |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- Must be a date - paymentStartDate must be a valid date of format DD/MM/YYYY
- Required Field - You must enter the paymentStartDate
|
| paymentType |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- The payment type must be specified against the membership
|
| periodID |
|
|
|
|
|
- |
|
| serialNumber |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- Required Field - You must enter the serialNumber
|
| sortCode |
|
|
|
|
|
- |
|
| sourceCode |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- Please enter a valid Source Code
|
| startdate |
|
|
|
|
|
- |
|
| typeID |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- Required Field - You must enter the typeID
|