Help Page Home

POSCustomerMaster

Name	Type	Additional information
CODE	string	Required Max length: 20
NAME	string	Max length: 120
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: 25
TEL2	string	Max length: 15
MOBILE	string	Max length: 15
FAX	string	Max length: 15
MARITAL_ST	string	Max length: 8
WED_DATE	string	None.
SPOUSE_NAME	string	Max length: 40
REMARKS	string	Max length: 2500
DATE_OF_BIRTH	string	None.
OPENING_ON	date	None.
GENDER	string	Max length: 7
REGION	string	Max length: 20
NATIONALITY	string	Max length: 20
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	string	None.
SALAMOUNT	decimal number	None.
SALBRLOC	string	Max length: 6
Branch_Code	string	Max length: 6
TOTALSALES	decimal number	None.
levelflag	decimal number	None.
POSCustIDNo	string	Max length: 30
POSSMAN	string	Max length: 10
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: 100
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
INCOMERANGE	string	Max length: 20
LAST_UPDATED_DATE	date	None.
TAXOFFICENO	string	Max length: 30
SALESMANNAME	string	Max length: 100
Default_DisDiamondPercent	decimal number	None.
Default_DisMetalPercent	decimal number	None.
LoyaltyAllow	boolean	Required
LoyaltyAllowEmail	boolean	Required
LoyaltyAllowSMS	boolean	Required
SENDPROMOTIONALEMAIL	boolean	Required
LOYALTY_CODE	string	Max length: 10
PREFERRED_COLOR	string	Max length: 20
PREFERRED_ITEM	string	Max length: 20
WRIST_SIZE	string	Max length: 20
FINGER_SIZE	string	Max length: 20
LOYALTY_POINT	decimal number	None.
FIRSTNAME	string	Max length: 40
MIDDLENAME	string	Max length: 40
LASTNAME	string	Max length: 40
POSKnownAbout	decimal number	None.
CIVILID_IMGPATH	string	Max length: 250
SUGGESTION	string	Max length: 1000
AMLNAMEVALIDATION	boolean	Required
AML_TYPE	boolean	Required
UN_NUMBER	string	Max length: 100
NAME_1	string	Max length: 200
NAME_2	string	Max length: 200
NAME_3	string	Max length: 200
NAME_4	string	Max length: 200
NAME_5	string	Max length: 200
DOB_2	string	None.
DOB_3	string	None.
DOB_4	string	None.
DOB_5	string	None.
GOOD_QUALITY	string	Max length: 500
LOW_QUALITY	string	Max length: 500
A_K_A	string	Max length: 500
F_K_A	string	Max length: 500
NATIONALITY_2	string	Max length: 20
NATIONALITY_3	string	Max length: 20
NATIONALITY_4	string	Max length: 20
NATIONALITY_5	string	Max length: 20
PASSPORT_NO_1	string	Max length: 20
PASSPORT_NO_2	string	Max length: 20
PASSPORT_NO_3	string	Max length: 20
PASSPORT_NO_4	string	Max length: 20
PASSPORT_NO_5	string	Max length: 20
LISTED_ON_DATE	string	None.
NATIONAL_IDENTIFICATION_NO	string	Max length: 100
OTHER_INFORMATION	string	Max length: 1000
LINKS	string	Max length: 500
FATHERNAME	string	Max length: 200
WUPMOBILECODE	string	Max length: 10
WUPMOBILENO	string	Max length: 20
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	string	None.
ChildDateOfBirth2	string	None.
ChildDateOfBirth3	string	None.
ChildDateOfBirth4	string	None.
OtherNames	string	Max length: 50
AUTOCREATEMST	boolean	None.
OCCUPATION	string	Max length: 50
ShowRoomAccessibility	string	Max length: 20
ProductRangeAvailability	string	Max length: 20
DIGISCREENED	boolean	Required
BR_CODE	string	Max length: 6
VOCTYPE	string	Max length: 3
YEARMONTH	string	Max length: 6
VOCNO	decimal number	None.
VOCDATE	date	None.
SPOUSE_DATE_OF_BIRTH	string	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