Customer Detail

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

Back to List

Customer Workspace

AFFIN FINANCE BHD

Compact enterprise workspace for customer_master, applicant_contact, and card_master.

Company Reg No D123938

Contacts 3

Managed Cards 28

Record Status 1

AFFIN FINANCE 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 202233 00013	WAR 7		Active	1999-03-31	Edit
700618 202233 00021	WDA 4409	IDRIS ABD HAMID	Active	1999-03-31	Edit
700618 202233 00039	WCT 7557	MOHAMED NEZURI GANI	Active	1999-03-31	Edit
700618 202233 00047	WCT 7761	ZULKIFLI MUHAMMAD	Active	1999-03-31	Edit
700618 202233 00054	WDL 7350	NOORHAYATI BAHARUDDIN	Active	1999-03-31	Edit
700618 202233 00062	WDY 4428	LEE YOKE KIOW	Active	1999-03-31	Edit
700618 202233 00070	WDM 1584	MOHD NASIR TAJUDIN	Active	1999-03-31	Edit
700618 202233 00088	WDY 4427		Active	1999-03-31	Edit
700618 202233 00096	WCT 7726	KAMAL BIN IBRAHIM	Active	1999-03-31	Edit
700618 202233 00104	WBL 7943		Active	1999-03-31	Edit
700618 202233 00112	QM 9355		Active	1999-03-31	Edit
700618 202233 00120	MG 1861Q		Active	1999-03-31	Edit
700618 202233 00138	TP 8055		Active	1999-03-31	Edit
700618 202233 00146	WCT 7729		Active	1999-03-31	Edit
700618 202233 00153	WDK 6244		Active	1999-03-31	Edit
700618 202233 00161	SA 9271K		Active	1999-03-31	Edit
700618 202233 00179	SS 2849C		Active	1999-03-31	Edit
700618 202233 00187	PBV 1733		Active	1999-03-31	Edit
700618 202233 00195	ST 5320C		Active	1999-03-31	Edit
700618 202233 00203	WDN 4999		Active	1999-03-31	Edit
700618 202233 00211	KT 5119Q		Active	1999-03-31	Edit
700618 202233 00229	WCT 7763	JESSICA LEE AH CHAU	Active	1999-03-31	Edit
700618 202233 00237	WDN 4999	IDRIS ABD HAMID	Active	1999-03-31	Edit
700618 202233 00245	WCT 4114	HAMIDI B.ABU HASAN	Active	1999-03-31	Edit
700618 202233 00252	WCT 7761	MOHAMED ABDULLAH	Active	1999-03-31	Edit
700618 202233 00260	WEW 2580		Active	1999-03-31	Edit
700618 202233 00278	WFK 4717	MOHAMAD AYUB	Active	1999-03-31	Edit
700618 202233 00286	WEW 2580		Active	1999-03-31	Edit