| Name | Description | Type | Additional 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 |
|
| 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 |