Help Page Home

PosCustomerMaster

Name	Type	Additional information
CODE	string	Required Max length: 20
NAME	string	Max length: 40
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
EMAIL	string	Max length: 40
TEL1	string	Max length: 15
TEL2	string	Max length: 15
MOBILE	string	Max length: 15
FAX	string	Max length: 15
MARITAL_ST	string	Max length: 8
WED_DATE	date	None.
SPOUSE_NAME	string	Max length: 40
REMARKS	string	Max length: 2500
DATE_OF_BIRTH	date	None.
OPENING_ON	date	None.
GENDER	string	Max length: 7
REGION	string	Max length: 20
NATIONALITY	string	Max length: 30
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
MID	integer	Required
PICTURE_NAME	string	Max length: 150
PICTURE	Collection of byte	None.
SALVOCTYPE_NO	string	Max length: 25
SALDATE	date	None.
SALAMOUNT	decimal number	None.
SALBRLOC	string	Max length: 6
BRANCH_CODE	string	Max length: 6
TOTALSALES	decimal number	None.
POSCUSTIDNO	string	Max length: 30
POSSMAN	string	Max length: 6
POSCUSTPREFIX	string	Required Max length: 10
MOBILE1	string	Max length: 15
CUST_LANGUAGE	string	Max length: 15
CUST_TYPE	string	Max length: 15
FAVORITE_CELEB	string	Max length: 20
STAFF_COURTESY	string	Max length: 15
PRODUCT_KNOWLEDGE	string	Max length: 20
LOCATION_AMBIENCE	string	Max length: 20
VARIETY_QUALITY	string	Max length: 20
OVERALL_EXP	string	Max length: 20
PRODUCT_SELECTION	string	Max length: 20
SERVICE	string	Max length: 20
MAKING_CHARGES	string	Max length: 20
BRAND_NAME	string	Max length: 20
BUY_BACK	string	Max length: 20
LOCATION_PARKING	string	Max length: 20
SOURCE	string	Max length: 20
PREFERENCE_CONTACT	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
INTERESTED_IN	string	Max length: 50
BLOOD_GROUP	string	Max length: 5
NO_OF_CHILDREN	decimal number	None.
ZODIAC_SIGN	string	Max length: 12
DESIGNATION	string	Max length: 50
LEVELFLAG	decimal number	None.
INCOMERANGE	string	Max length: 20
LAST_UPDATED_DATE	date	None.
BR_CODE	string	Max length: 6
TAXOFFICENO	string	Max length: 30
SALESMANNAME	string	Max length: 100
VOCTYPE	string	Max length: 3
YEARMONTH	string	Max length: 6
VOCNO	decimal number	None.
VOCDATE	date	None.
SPOUSE_DATE_OF_BIRTH	date	None.
OCCUPATION	string	Max length: 50
PROMO_NEEDED	string	Max length: 50
PROMO_HOW_OFTEN	string	Max length: 50
CHILDNAME1	string	Max length: 50
CHILDNAME2	string	Max length: 50
CHILDNAME3	string	Max length: 50
CHILDNAME4	string	Max length: 50
CHILDDATEOFBIRTH1	date	None.
CHILDDATEOFBIRTH2	date	None.
CHILDDATEOFBIRTH3	date	None.
CHILDDATEOFBIRTH4	date	None.
OTHERNAMES	string	Max length: 50
AUTOCREATEMST	boolean	None.
TEL_R_CODE	string	Required Max length: 5
TEL_O_CODE	string	Required Max length: 5
GST_NUMBER	string	Max length: 20
VAT_NUMBER	string	Required Max length: 15
PARENT_CODE	string	Required Max length: 12
REFERED_BY	string	Required Max length: 100
CREDIT_LIMIT	decimal number	Required
CREDIT_LIMIT_STATUS	boolean	Required
PANCARDNO	string	Required Max length: 20
LOYALTYALLOW	boolean	Required
LOYALTY_CODE	string	Required Max length: 20
LOYALTY_POINT	decimal number	None.
DEFAULT_DISDIAMONDPERCENT	decimal number	None.
DEFAULT_DISMETALPERCENT	decimal number	None.
WUPMOBILECODE	string	None.
WUPMOBILENO	string	None.