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 |
|
|
|
|
|
- |
|
accountverifiedby |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- Required Field - This can not be empty if Account Verified is provided
|
animalid_bsk |
|
|
|
|
|
- |
|
balance |
|
|
|
|
|
- |
|
banddescription |
|
|
|
|
|
- |
|
bandid |
|
|
|
|
|
- |
|
bandname |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- Must be in the list of values - Invalid entry
|
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)"
|
concessioncategory_bsk |
|
|
|
|
|
- |
|
created |
|
|
|
|
|
- |
|
createdby |
|
|
|
|
|
- |
|
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
|
giftmembership |
|
|
|
|
|
- |
|
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 |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- Required Field - You must enter the membershipid
|
membershiptype |
|
|
|
|
|
- |
|
modified |
|
|
|
|
|
- |
|
modifiedby |
|
|
|
|
|
- |
|
nameoncard_bsk |
|
|
|
|
|
- |
|
nextpayment |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- Must be a date - nextpayment must be a valid date of format DD/MM/YYYY
|
nextpaymentamount |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- Must be numeric - nextpaymentamount must be numeric
|
outstanding |
|
|
|
|
|
- |
|
payerserialnumber |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- Required Field - You must enter the payerserialnumber
|
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
|
paymenttype |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- The payment type must be specified against the membership
|
periodid |
|
|
|
|
|
- |
|
receiptserialnumber |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- Required Field - You must enter the receiptserialnumber
|
recruitername_bsk |
|
|
|
|
|
- |
|
recruitmentlocation_bsk |
|
|
|
|
|
- |
|
serialnumber |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- Required Field - You must enter the serialnumber
|
sortcode |
|
|
|
|
|
- |
|
sourcecode |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- Please enter a valid Source Code
|
startdate |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- Must be a date - startdate must be a valid date of format DD/MM/YYYY
- Required Field - You must enter the startdate
|
typeid |
|
|
|
|
|
- |
|
|
Validation (Rule - Message):
- Required Field - You must enter the typeid
|
year1destinationcode_bsk |
|
|
|
|
|
- |
|