...
Code (varchar) (Mandatory, not editable once created)
TradeName (varchar) (Mandatory)
LocationsUUID (fk tblLocations) (Mandatory)
Search for location with Level - Code - Name (all strings)
Address (varchar/json): multiline Box String OR (Address line 1, line2 , post code, city)TextInput
Phone (varchar): string + configurable Regex (default Regex:
^[0-9]*$
) for validation/constraintFax (varchar): + configurable Regex for validation/constraint (for the testing we could use something like
^[1-9]{8,9}$
)Email (varchar): + std email field validation
ContactName (varchar/json)
LegalForm (configEnum:legalForm )
ActivityCode (configEnum:activity)
AccountancyAccount (varchar) + configurable Regex (default Regex:
.+
) for validation/constraint?bankAccount BankAccount (json)
PaymentReference (varchar) + configurable Regex (default Regex:
.+
) for validation/constraintDateValidFrom (date) (Mandatory)
DateValidTo (date)
...