Customer Detail

Each customer can manage multiple contacts and cards from the same SQL Express database.

Back to List

Customer Workspace

ACCELTEAM SDN BHD

Compact enterprise workspace for customer_master, applicant_contact, and card_master.

Company Reg No 396737-M

Contacts 10

Managed Cards 52

Record Status 1

ACCELTEAM SDN BHD

All non-_ID fields from customer_master.

Customer Information

Reference layout based on customer_profile.jpg.

Company Name

Company Reg Num

Date Of Incorporation

Name Appear On Card

Agreement Start Date

Agreement Expiry Date

Customer Account Num

Approved Credit Limit

Aut Credit Limit

Parent Reg Num

Approved Date

Approved By

Date Suspended

Date Delinquency

Date Legal Case

Date Resigned

Date Terminated

Created By

Created Date

Modified By

Modified Date

Bank Account Giro

Record Status

Cancellation Date

Auto Renewal

Cancellation Remark

Diesel Subsidy

Extra Credit

Aging 1

Aging 2

Aging 3

Aging 4

Aging 5

Aging 0

Unbill

Last Month Purchased

Current Month Purchased

Update Ascendent

Write Off

Diesel Xybase Ref Num

Diesel Subsidy Ref Num

Quota Changed

Diesel Subsidy Quota

Max Agreement Expiry Date

Provision

Total Invoice

Total Collected

Aging As Of

Debt Legal

Reminder1

Reminder2

Statement Send

Late Charges Calculation

Old Customer Account Num

Prepaid Reminder

Ref Reg No

Reminder3

Suspension

Auto Ds Renewal

Customer Contacts

Linked by customer_master.customer_id = applicant_contact.applicant_id.

Name	Designation	Email	Telephone	Mobile	Record Status

Cards

Loaded on demand from card_master.

Card No	Vehicle Reg No	Driver Name	Record Status	Renewal Expiry
789713 3002885 0016	WSP 9980	YONG WEI CHIANG	Inactive	2016-02-29	Edit
789713 3002885 0024	WSP 9980	RAFI'I	Inactive	2016-02-29	Edit
789713 3002885 0032	WMD 6860	VINCENT TAN KAH HOW	Inactive	2016-02-29	Edit
789713 3002885 0040	WTH 7557	KEN LOH	Inactive	2016-02-29	Edit
789713 3002885 0057	WLX 8476	WILSON TAN KOK WAI	Inactive	2016-02-29	Edit
789713 3002885 0065	WNF 6961	LEE CHOO HAR	Inactive	2016-02-29	Edit
789713 3002885 0073	WHH 9289	AMRITH BHAT KANDLUR	Inactive	2016-02-29	Edit
789713 3002885 0081	WGW 7093	TAN SOON HEE	Inactive	2016-02-29	Edit
789713 3002885 0099	BHM 2992	CHIN WEI MIN	Inactive	2016-02-29	Edit
789713 3002885 0107	JHQ 8290	ANG KHO WEI	Inactive	2016-02-29	Edit
789713 3002885 0115	WPT 8565	AMANDA CHEE	Inactive	2016-02-29	Edit
789713 3002885 0123	BJA 1282	ROBIN GWEE	Inactive	2016-02-29	Edit
789713 3002885 0131	WKD 332	ASFANI MUSA	Inactive	2016-02-29	Edit
789713 3002885 0149	WNX 1918	HASSAN MOHD SIMOH	Inactive	2016-02-29	Edit
789713 3002885 0156	WHV 6628	MOHD HAZEM SHAH	Inactive	2016-02-29	Edit
789713 3002885 0164	WSP 9980	MOHD SHAKRI SAID	Inactive	2016-02-29	Edit
789713 3002885 0172	WPJ 1980	KAMIL KHAIRI MOHD KHAN	Inactive	2016-02-29	Edit
789713 3002885 0180	XIIINAM 709	NOOR AZHAR HJ AHMAD	Inactive	2016-02-29	Edit
789713 3002885 0198	WPT 8565	AMANDA CHEE	Active	2016-02-29	Edit
789713 3002885 0206	WNE 5183	LIM BOON SHENG	Inactive	2016-02-29	Edit
789713 3002885 0214	WQW 3523	EDY	Inactive	2016-02-29	Edit
789713 3002885 0222	WUP 6169	MOHD FAIZAL SHEBLI	Inactive	2016-02-29	Edit
789713 3002885 0230	WUS 3112	TAN BEE KIAN	Inactive	2016-02-29	Edit
789713 3002885 0248	WRJ 6727	AZMIN ABDULLAH	Inactive	2016-02-29	Edit
789713 3002885 0255	WPP 8336	KHOO KIM SENG JOE	Inactive	2016-02-29	Edit
789713 3002885 0263	CAY 1113	FOO SOOI CHIN	Inactive	2016-02-29	Edit
789713 3002885 0271	WPT 8565	AMANDA CHEE	Active	2016-02-29	Edit
789713 3002885 0289		LIM CHAI FOONG	Inactive	2016-02-29	Edit
789713 3002885 0297		LIM CHAI FOONG	Active	2016-02-29	Edit
789713 3002885 0305	AGQ 684	SAMY VELU	Inactive	2016-02-29	Edit
789713 3002885 0313	WHX 7290	THO CHING LOONG	Inactive	2016-02-29	Edit
789713 3002885 0321	WWJ 5003	MOHAMAD ALEX EDWARD	Inactive	2016-02-29	Edit
789713 3002885 0339	WVW 216	NURUL AZRINA	Inactive	2016-02-29	Edit
789713 3002885 0347	WKD 332	ASFANI MUSA	Active	2016-02-29	Edit
789713 3002885 0354	WTQ 2668	LEE CHOO HAR	Active	2016-02-29	Edit
789713 3002885 0362	WSP 9980	YONG WEI CHIANG	Active	2016-02-29	Edit
789713 3002885 0370	WSG 3961	MOHD WAFIUDDIN B ZAINAL ABIDIN	Inactive	2016-02-29	Edit
789713 3002885 0388	WSG 3961	MOHD WAFIUDDIN B ZAINAL ABIDIN	Active	2016-02-29	Edit
789713 3002885 0396	PJY 3831	LOO SZE MING	Inactive	2016-02-29	Edit
789713 3002885 0404	WKG 5628	IMRA BIN IBRAHIM	Inactive	2016-02-29	Edit
789713 3002885 0412	TAN 8139	MOHD SAHRULNIZAM	Inactive	2016-02-29	Edit
789713 3002885 0420	WUM 8566	GERRY LEONG	Inactive	2016-02-29	Edit
789713 3002885 0438	W1231U	SENG CHUNG YUEH	Inactive	2016-02-29	Edit
789713 3002885 0446	WWR 7829	LAU KAH WAI	Inactive	2016-02-29	Edit
789713 3002885 0453	WSG 3961	MOHD WAFIUDDIN B ZAINAL ABIDIN	Active	2016-02-29	Edit
789713 3002885 0461	AFD 5888	LEE KOK SIONG	Inactive	2016-02-29	Edit
789713 3002885 0479	WVK 802	CHIN TZE KIEN	Inactive	2016-02-29	Edit
789713 3002885 0487	JNH 7113	PREM A/L SUBRAMANIAM	Inactive	2016-02-29	Edit
789713 3002885 0495	WLK 2811	WONG KEAN CHENG	Inactive	2016-02-29	Edit
789713 3002885 0503	AHQ 7133	PHILLIP ONG JOO YEONG	Inactive	2016-02-29	Edit
789713 3002885 0511	WUK 678	HADURA HASHIM	Inactive	2016-02-29	Edit
789713 3002885 0529	WPN 6413	FAUZY BIN OMAR	Inactive	2016-02-29	Edit