NameDescriptionTypeAdditional information
REFMID

decimal number

None.

ACCODE

string

Required

Max length: 6

CUSTOMER_NAME

string

Max length: 100

DESIGNATION

string

Max length: 100

MOBILE

string

Max length: 50

EMAIL

string

Max length: 100

DEFAULT_CONTACT

boolean

None.

ACMID

decimal number

Required

ACC_DESCRIPTION

string

Max length: 100

SL_CODE

string

Required

Max length: 20

DESCRIPTION

string

Max length: 100

COMPANY

string

Max length: 40

ADDRESS

string

Max length: 150

POBOX_NO

string

Max length: 6

STATE

string

Max length: 20

CITY

string

Max length: 20

ZIPCODE

string

Max length: 10

COUNTRY_CODE

string

Max length: 20

TEL1

string

Max length: 15

TEL2

string

Max length: 15

FAX

string

Max length: 15

MARITAL_ST

string

Max length: 8

SPOUSE_NAME

string

Max length: 40

SPOUSE_NO

string

Max length: 40

SPOUSE_EMAIL

string

Max length: 40

REMARKS

string

Max length: 2500

DATE_OF_BIRTH

date

None.

OPENING_ON

date

Required

GENDER

string

Max length: 7

REGION

string

Max length: 20

NATIONALITY

string

Max length: 20

POSCUSTIDNO

string

Max length: 50

RELIGION

string

Max length: 20

TYPE

string

Max length: 20

CATEGORY

string

Max length: 20

INCOME

decimal number

None.

CUST_STATUS

string

Max length: 20

BRANCH_CODE

string

Max length: 6

MOBILE1

string

Max length: 15

CUST_LANGUAGE

string

Max length: 15

CUST_TYPE

string

Max length: 15

FAVORITE_CELEB

string

Max length: 20

MOBILECODE1

string

Max length: 5

MOBILECODE2

string

Max length: 5

IDCATEGORY

string

Max length: 15

ADDRESS_OFFICIAL

string

Max length: 150

ADDRESS_DELIVARY

string

Max length: 150

BLOOD_GROUP

string

Max length: 5

NO_OF_CHILDREN

decimal number

None.

ZODIAC_SIGN

string

Max length: 12

OCCUPATION

string

Max length: 50

TEL_R_CODE

string

Required

Max length: 5

TEL_O_CODE

string

Required

Max length: 5