Customer Detail

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

Back to List

Customer Workspace

AE AUTOMOTION (M) S/B

Compact enterprise workspace for customer_master, applicant_contact, and card_master.

Company Reg No 229753 W

Contacts 3

Managed Cards 57

Record Status 1

AE AUTOMOTION (M) S/B

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 200962 00019	WCY 6361	YEP CHAU SHYONG	Active	2013-10-31	Edit
700618 200962 00027	WCG 4121		Active	2013-10-31	Edit
700618 200962 00035	WDA 1777	FONG MUM HEONG	Active	2013-10-31	Edit
700618 200962 00043	WDW 2016	LIM KEE HIN	Active	2013-10-31	Edit
700618 200962 00050	JCL 328	LIM KEE SINN	Active	2013-10-31	Edit
700618 200962 00068	WDF 3241		Active	2013-10-31	Edit
700618 200962 00076	JCJ 5909		Active	2013-10-31	Edit
700618 200962 00084	JCJ 8479		Active	2013-10-31	Edit
700618 200962 00092	JCV 6639		Active	2013-10-31	Edit
700618 200962 00100	JDC 7551		Active	2013-10-31	Edit
700618 200962 00118	WBL 6254		Active	2013-10-31	Edit
700618 200962 00126	WDY 5205		Active	2013-10-31	Edit
700618 200962 00134	WES 1652		Active	2013-10-31	Edit
700618 200962 00142	JCL 328	LIM KEE HIN	Active	2013-10-31	Edit
700618 200962 00159	WFA 2938	FONG MUM HEONG	Active	2013-10-31	Edit
700618 200962 00167	PCP 9357	WONG HONG KHEONG	Active	2013-10-31	Edit
700618 200962 00175	WFY 8237		Active	2013-10-31	Edit
700618 200962 00183	WDB 8284	MALAYSIA	Active	2013-10-31	Edit
700618 200962 00191	WDB 8284	MALAYSIA	Active	2013-10-31	Edit
700618 200962 00209	WDB 8284	MALAYSIA	Active	2013-10-31	Edit
700618 200962 00217	WDY 9033		Active	2013-10-31	Edit
700618 200962 00225	WDF 3241		Active	2013-10-31	Edit
700618 200962 00233	WES 1652		Active	2013-10-31	Edit
700618 200962 00241	WDB 8284	MALAYSIA	Active	2013-10-31	Edit
700618 200962 00258	WDF 3241		Active	2013-10-31	Edit
700618 200962 00266	BEF 33	KEN LIM	Active	2013-10-31	Edit
700618 200962 00274	WHX 4140	ALL DRIVER	Active	2013-10-31	Edit
700618 200962 00282	NAC 5211	ALL DRIVERS	Active	2013-10-31	Edit
700618 200962 00290	WES 1652		Active	2013-10-31	Edit
700618 200962 00308	WES 1652	MALAYSIA	Active	2013-10-31	Edit
700618 200962 00316	WKD 5609	NISSAN	Active	2013-10-31	Edit
700618 200962 00324	WDY 5205		Active	2013-10-31	Edit
700618 200962 00332	WKQ 2741		Active	2013-10-31	Edit
700618 200962 00340	WES 1652		Active	2013-10-31	Edit
700618 200962 00357	WMA 2938	ALL DRIVER	Active	2013-10-31	Edit
700618 200962 00365	WMA 8392	ALL DRIVERS	Active	2013-10-31	Edit
700618 200962 00373	WGW 6175	ZULKIFLE B HAMID	Active	2013-10-31	Edit
700618 200962 00381	WMA 2938	ALL DRIVERS	Active	2013-10-31	Edit
700618 200962 00399	WMA 2938	ALL DRIVERS	Active	2013-10-31	Edit
700618 200962 00407	WDY 5205		Active	2013-10-31	Edit
700618 200962 00415	WNV 9832	ALL DRIVER	Active	2013-10-31	Edit
789713 3001054 0013	WFY 8237		Active	2013-10-31	Edit
789713 3001054 0021	WKD 5609	NISSAN	Active	2013-10-31	Edit
789713 3001054 0039	WKQ 2741		Active	2013-10-31	Edit
789713 3001054 0047	WMA 8392	ALL DRIVERS	Active	2013-10-31	Edit
789713 3001054 0054	WGW 6175	ZULKIFLE B HAMID	Active	2013-10-31	Edit
789713 3001054 0062	WMA 2938	ALL DRIVERS	Active	2013-10-31	Edit
789713 3001054 0070	WDY 5205		Active	2013-10-31	Edit
789713 3001054 0088	WNV 9832	ALL DRIVER	Active	2013-10-31	Edit
789713 3001054 0096	WFA 2938	FONG MUM HEONG	Active	2013-10-31	Edit
789713 3001054 0104	JJB 3427	H K LOW	Inactive	2013-10-31	Edit
789713 3001054 0112	WQL 9328	SM SUBRAMANIAM	Inactive	2013-10-31	Edit
789713 3001054 0120	WGW 6175	ZULKIFLE BIN HAMID	Inactive	2013-10-31	Edit
789713 3001054 0138	WNV 9832	ALL DRIVER	Active	2013-10-31	Edit
789713 3001054 0146	WNV 9832	ALL DRIVER	Active	2013-10-31	Edit
789713 3001054 0153	WUH 9382	LOW HUN KEE	Inactive	2013-10-31	Edit
789713 3001054 0161	WVJ 9328	ALL DRIVER	Inactive	2013-10-31	Edit