Customer Detail

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

Back to List

Customer Workspace

ACE SYNERGY INSURANCE BERHAD

Compact enterprise workspace for customer_master, applicant_contact, and card_master.

Company Reg No 991729A

Contacts 3

Managed Cards 20

Record Status 1

ACE SYNERGY INSURANCE BERHAD

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 200015 00016	WCH 6918	JUNE CHEW	Active	2007-10-31	Edit
700618 200015 00024	WBF 9267	RICHARD HOOI	Active	2007-10-31	Edit
700618 200015 00032	WBN 6594	ROSELI MAHMOOD	Active	2007-10-31	Edit
700618 200015 00040	WCH 6918	TAN CHENG KEANG	Active	2007-10-31	Edit
700618 200015 00057	WAW 6946	AFNI YAHYA	Active	2007-10-31	Edit
700618 200015 00065	WDF 4910	JUNE CHEW	Active	2007-10-31	Edit
700618 200015 00073	WBK 8193	TAN CHENG KEANG	Active	2007-10-31	Edit
700618 200015 00081	WCY 347	MOHD ASRI BIN ABAS	Active	2007-10-31	Edit
700618 200015 00099	WEJ 5222	CLIFF LEE KOON YEW	Active	2007-10-31	Edit
700618 200015 00107	WCH 6918	CHEE PEK HAR	Active	2007-10-31	Edit
700618 200015 00115	WCH 6918	CHEE PAK HAR	Active	2007-10-31	Edit
700618 200015 00123	WDT 7355	VOLKERT ROBERTUS	Active	2007-10-31	Edit
700618 200015 00131	WEE 8180	CHEONG CHEE WAI	Active	2007-10-31	Edit
700618 200015 00149	WEK 1026	SERINNA FOO CHEE IT	Active	2007-10-31	Edit
700618 200015 00156	WEN 8698	JUNE CHEW	Active	2007-10-31	Edit
700618 200015 00164	WEE 8180	CHEONG CHEE WAI	Active	2007-10-31	Edit
700618 200015 00172	WEK 1026	TONI LEE	Active	2007-10-31	Edit
700618 200015 00180	WHS 3326	PATRICK MCCALEB	Active	2007-10-31	Edit
700618 200015 00198	WJQ 5028	CLIFF LEE	Active	2007-10-31	Edit
789713 3000951 0019	WJQ 5028	CLIFF LEE	Active	2007-10-31	Edit