Organisation Custom Field

This table stores information about individual custom fields which can be added by organisation which specific to their need.

Example

If one company wants to add GST field in invoice and other company wants to add internal invoice number.

Attributes

orgCusFieId: Primary key of the table.

fieldName: Name of the custom field.

fieldDescription: Description of the custom field. This will be shown as placeholder.

orgId: Foreign key of the organisation table. This field stores the information of the Organisation to which custom field belongs.

fieldType: Field indicating the type of custom field. Eg: Text, email, textarea, number etc.

fieldRegex: Pattern to be validated before saving the data.

position: Position of the custom field such as top or bottom. This is only applicable if document type is main document and not document items.

isRequired: Boolean value indicating whether the field is required or not.

documentType: Field which specifies the document type.

Possible values

1. Invoice
2. InvoiceItems
3. Vendor Bill
4. Vendor Bill Items
5. Sales Order
6. Sales Order Items
7. Purchase Order
8. Purchase Order Items

createdBy: Foreign key of the User table. This field stores the information of the email id which created the custom field.

---

Associations

Organisation

Custom field always belongs any one organisation.

User

Custom field always created by any one user belongs to organisation.