Customer Detail

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

Back to List

Customer Workspace

AE AUTOMATION (M) SDN BHD

Compact enterprise workspace for customer_master, applicant_contact, and card_master.

Company Reg No 229753W5

Contacts 3

Managed Cards 66

Record Status 1

AE AUTOMATION (M) 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
700618 203457 00017	WDB 5074	TAN KAR YEE	Active	2014-06-30	Edit
700618 203457 00025	WDK 8155	KELVIN TEO	Active	2014-06-30	Edit
700618 203457 00033	WDB 4364	WILLARD LEONG	Active	2014-06-30	Edit
700618 203457 00041	WBY 5472	LEE CHIEN KOK	Active	2014-06-30	Edit
700618 203457 00058	WED 6817	JACKY CHEW	Active	2014-06-30	Edit
700618 203457 00066	WCQ 9543	YAN YAP CHIN	Active	2014-06-30	Edit
700618 203457 00074	CAE 9998	ALEX LEE	Active	2014-06-30	Edit
700618 203457 00082	BCH 1217	K.L.CHAN	Active	2014-06-30	Edit
700618 203457 00090	BEN 6328	WONG FOO WAH	Active	2014-06-30	Edit
700618 203457 00108	PCQ 8639	OOI CHONG AN	Active	2014-06-30	Edit
700618 203457 00116	WEQ 2645	TAN KAR YEE	Active	2014-06-30	Edit
700618 203457 00124	PCQ 8639	OOI CHONG AN	Active	2014-06-30	Edit
700618 203457 00132	NAS 3689	YAP CHEE HONG	Active	2014-06-30	Edit
700618 203457 00140	WFQ 6212	YEP CHAU SHYONG	Active	2014-06-30	Edit
700618 203457 00157	ACF 3225	LOOI KAM YONG	Active	2014-06-30	Edit
700618 203457 00165	WCQ 9543	YAN YAP CHIN	Active	2014-06-30	Edit
700618 203457 00173	JEC 2164	CHIN HOY MENG	Active	2014-06-30	Edit
700618 203457 00181	WFP 314	GAVIN CHEN KHIN KIEN	Active	2014-06-30	Edit
700618 203457 00199	ACF 3225	LOOI KAM YONG	Active	2014-06-30	Edit
700618 203457 00207	ACF 3225	LOOI KAM YONG	Active	2014-06-30	Edit
700618 203457 00215	NAS 3689	YAP CHEE HONG	Active	2014-06-30	Edit
700618 203457 00223	CAE 9998	ALEX LEE	Active	2014-06-30	Edit
700618 203457 00231	WFP 314	GAVIN CHEN KHIN KIEN	Active	2014-06-30	Edit
700618 203457 00249	WFQ 4815	LOO SIEW ONN	Active	2014-06-30	Edit
700618 203457 00256	NAR 3127	JAN TH. OUD	Active	2014-06-30	Edit
700618 203457 00264	ACM 9901	TSHAI KIM YEOW	Active	2014-06-30	Edit
700618 203457 00272	BFB 375	KHOO KIEN TECK	Active	2014-06-30	Edit
700618 203457 00280	WDV 2014	KUAN WENG LOONG	Active	2014-06-30	Edit
700618 203457 00298	BFB 375	KHOO KIEN TECK	Active	2014-06-30	Edit
700618 203457 00306	JDF 959	HONG SWEE HOE	Active	2014-06-30	Edit
700618 203457 00314	ACM 775	DANNY CHAN	Active	2014-06-30	Edit
700618 203457 00322	WAU 4751	VICTOR HOH	Active	2014-06-30	Edit
700618 203457 00330	BDR 8874	HENRY LING	Active	2014-06-30	Edit
700618 203457 00348	WCE 5093	JOHN LOH	Active	2014-06-30	Edit
700618 203457 00355	WDK 8155	KELVIN TEOH	Active	2014-06-30	Edit
700618 203457 00363	WHV 4488	WONG FOO WAH	Active	2014-06-30	Edit
700618 203457 00371	WHV 4488	WONG FOO WAH	Active	2014-06-30	Edit
700618 203457 00389	KAP 1071	LOW HUN KEE	Active	2014-06-30	Edit
700618 203457 00397	WEG 9406	KELVIN YEE YONG KONG	Active	2014-06-30	Edit
700618 203457 00405	BCU 7884	ELWIN LEE	Active	2014-06-30	Edit
700618 203457 00413	NAR 3127	JAN TH. OUD	Active	2014-06-30	Edit
700618 203457 00421	WCE 5093	JOHN LOH	Active	2014-06-30	Edit
700618 203457 00439	NAR 3127	JAN TH OUD	Active	2014-06-30	Edit
700618 203457 00447	JGY 6847	JASON TEO	Active	2014-06-30	Edit
700618 203457 00454	ADY 3623	JUSTIN LIN	Active	2014-06-30	Edit
700618 203457 00462	WEQ 2645	TAN KAR YEE	Active	2014-06-30	Edit
700618 203457 00470	WNN 6201	HENRY LING	Inactive	2014-06-30	Edit
700618 203457 00488	PGV 1705	ANG KHAI LOON	Inactive	2014-06-30	Edit
700618 203457 00496	WAY 2066	STEVE ANG	Inactive	2014-06-30	Edit
789713 3002312 0019	JDF 959	HONG SWEE HOE	Active	2014-06-30	Edit
789713 3002312 0027	WDK 8155	KELVIN TEOH	Active	2014-06-30	Edit
789713 3002312 0035	BCU 7884	ELWIN LEE	Active	2014-06-30	Edit
789713 3002312 0043	NAR 3127	JAN TH OUD	Active	2014-06-30	Edit
789713 3002312 0050	JGY 6847	JASON TEO	Active	2014-06-30	Edit
789713 3002312 0068	ADY 3623	JUSTIN LIN	Active	2014-06-30	Edit
789713 3002312 0076	WEQ 2645	TAN KAR YEE	Active	2014-06-30	Edit
789713 3002312 0084	WNN 6201	HENRY LING	Active	2014-06-30	Edit
789713 3002312 0092	PGV 1705	ANG KHAI LOON	Active	2014-06-30	Edit
789713 3002312 0100	WAY 2066	STEVE ANG	Active	2014-06-30	Edit
789713 3002312 0118	WNT 3552	KS CHEAH	Inactive	2014-06-30	Edit
789713 3002312 0126	WNN 6201	HENRY LING	Active	2014-06-30	Edit
789713 3002312 0134	WTW 2039	CHEN CHEE FEI	Inactive	2014-06-30	Edit
789713 3002312 0142	WTW 2039	CHEN CHEE FEI	Active	2014-06-30	Edit
789713 3002312 0159	JHB 2858	KENNY LIM	Inactive	2014-06-30	Edit
789713 3002312 0167	JHB 2858	KENNY LIM	Active	2014-06-30	Edit
789713 3002312 0175	WUD 3367	LIM MUI HANN	Inactive	2014-06-30	Edit