Customer Detail

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

Back to List

Customer Workspace

AE ELTROMATIC (M)SDN. BHD.

Compact enterprise workspace for customer_master, applicant_contact, and card_master.

Company Reg No 131125 T

Contacts 3

Managed Cards 50

Record Status 1

AE ELTROMATIC (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 203789 00013	WEL 8225	C.K.CHEW	Active	2014-08-31	Edit
700618 203789 00021	WEQ 2310	ALLEN NG YONG CHANG	Active	2014-08-31	Edit
700618 203789 00039	BCF 9262	ELVIN KUEH SWEE KEE	Active	2014-08-31	Edit
700618 203789 00047	WBD 3687	DING POI HAW	Active	2014-08-31	Edit
700618 203789 00054	WEL 8225	C.K.CHEW	Active	2014-08-31	Edit
700618 203789 00062	NAS 5084	CHIEW SONG MENG	Active	2014-08-31	Edit
700618 203789 00070	WEC 8225	C.K. CHEW	Active	2014-08-31	Edit
700618 203789 00088	JFA 8287	NG LEE TATT	Active	2014-08-31	Edit
700618 203789 00096	WGQ 4552	WOO WEN YANG	Active	2014-08-31	Edit
700618 203789 00104	WHD 7106	MALAYSIA	Active	2014-08-31	Edit
700618 203789 00112	WHD 7106	MALAYSIA	Active	2014-08-31	Edit
700618 203789 00120	WHF 307	WONG FONG YOK	Active	2014-08-31	Edit
700618 203789 00138	JFA 8287	NG LEE TATT	Active	2014-08-31	Edit
700618 203789 00146	WHD 7106	MALAYSIA	Active	2014-08-31	Edit
700618 203789 00153	JFA 8287	NG LEE TATT	Active	2014-08-31	Edit
700618 203789 00161	BGM 5228		Active	2014-08-31	Edit
700618 203789 00179	WKF 1398	CHAI CHOON YEN	Active	2014-08-31	Edit
700618 203789 00187	JFA 8287	NG LEE TATT	Active	2014-08-31	Edit
700618 203789 00195	WHS 5228	NG LEE TATT	Active	2014-08-31	Edit
700618 203789 00203	WKY 6901	FONG CHIN YONG	Active	2014-08-31	Edit
700618 203789 00211	WEH 9669	HO SING CHEONG	Active	2014-08-31	Edit
700618 203789 00229	WHM 9579	ONG YING PING	Active	2014-08-31	Edit
700618 203789 00237	MAX 5228	NG LEE TATT	Active	2014-08-31	Edit
700618 203789 00245	WHS 5228	WONG FONG YOK	Active	2014-08-31	Edit
700618 203789 00252	WHS 5228	WONG FONG YOK	Active	2014-08-31	Edit
700618 203789 00260	WKF 1398	CHAI CHOON YEN	Active	2014-08-31	Edit
700618 203789 00278	MMX 8881	BEN HO SING CHEONG	Active	2014-08-31	Edit
700618 203789 00286	WHD 7106	MALAYSIA	Active	2014-08-31	Edit
789713 3000050 0019	WGQ 4552	WOO WEN YANG	Active	2014-08-31	Edit
789713 3000050 0027	BGM 5228		Active	2014-08-31	Edit
789713 3000050 0035	WKF 1398	CHAI CHOON YEN	Active	2014-08-31	Edit
789713 3000050 0043	MMX 8881	BEN HO SING CHEONG	Active	2014-08-31	Edit
789713 3000050 0050	WHD 7106	MALAYSIA	Active	2014-08-31	Edit
789713 3000050 0068	WKY 6901	FONG CHIN YONG	Active	2014-08-31	Edit
789713 3000050 0076	MAX 5228	NG LEE TATT	Active	2014-08-31	Edit
789713 3000050 0084	WHS 5228	WONG FONG YOK	Active	2014-08-31	Edit
789713 3000050 0092	WMK 6823	CHEW CHEE CHUAN	Inactive	2014-08-31	Edit
789713 3000050 0100	WMC 7098		Inactive	2014-08-31	Edit
789713 3000050 0118	WVG 5228	CHAI CHOON YEN	Active	2014-08-31	Edit
789713 3000050 0126	WSG 5228	NG LEE TATT	Active	2014-08-31	Edit
789713 3000050 0134	WPC 5228	WONG FONG YOK	Active	2014-08-31	Edit
789713 3000050 0142	WVF 5228		Inactive	2014-08-31	Edit
789713 3000050 0159	WPC 5228	WONG FONG YOK	Active	2014-08-31	Edit
789713 3000050 0167	WTF 5228		Inactive	2014-08-31	Edit
789713 3000050 0175	WKY 6901	FONG CHIN YONG	Active	2014-08-31	Edit
789713 3000050 0183	WVG 5228	CHAI CHOON YEN	Active	2014-08-31	Edit
789713 3000050 0191	WKY 6901	FONG CHIN YONG	Active	2014-08-31	Edit
789713 3000050 0209	WGQ 4552	WOO WEN YANG	Active	2014-08-31	Edit
789713 3000050 0217	WHD 7106	OFFICE	Active	2014-08-31	Edit
789713 3000050 0225	WVG 5228	CHAI CHOON YEN	Active	2014-08-31	Edit