Customer Detail

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

Back to List

Customer Workspace

A.M. GLASS SDN BHD

Compact enterprise workspace for customer_master, applicant_contact, and card_master.

Company Reg No 206772 A

Contacts 3

Managed Cards 28

Record Status 1

A.M. GLASS 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 200645 00010	BDS 1601	YEW CHANG BENG	Active	1999-05-31	Edit
700618 200645 00028	BCW 2188	CHEANG SHEN KOON	Active	1999-05-31	Edit
700618 200645 00036	WCH 8690	CHOY MUN YEE	Active	1999-05-31	Edit
700618 200645 00044	BDH 7693	POH SOH SINN	Active	1999-05-31	Edit
700618 200645 00051	WCH 8690	POH SOH SINN	Active	1999-05-31	Edit
700618 200645 00069	BDH 7693	PANG LEE LING	Active	1999-05-31	Edit
700618 200645 00077	WCY 8067	LIEW KOK LEONG	Active	1999-05-31	Edit
700618 200645 00085	WCH 8690	CHEANG SHEN KOON	Active	1999-05-31	Edit
700618 200645 00093	BCW 2188	POH SOH SINN	Active	1999-05-31	Edit
700618 200645 00101	ABY 102	ONG HENG GIAP	Active	1999-05-31	Edit
700618 200645 00119	BEW 4546	THIYAGARAJAN	Active	1999-05-31	Edit
700618 200645 00127	BDS 1601	BALAN A/L SINNIAH	Active	1999-05-31	Edit
700618 200645 00135	ABY 102	ANG HENG GIAP	Active	1999-05-31	Edit
700618 200645 00143	BCW 2188	CHEANG SHEN KOON	Active	1999-05-31	Edit
700618 200645 00150	BDH 7693	ANG HENG GIAP	Active	1999-05-31	Edit
700618 200645 00168	ABY 102	PANG LEE LING	Active	1999-05-31	Edit
700618 200645 00176	WBT 5271	POH SOH SINN	Active	1999-05-31	Edit
700618 200645 00184	WBT 5271	PANG LEE LING	Active	1999-05-31	Edit
700618 200645 00192	WCH 8690	ANG HENG GIAP	Active	1999-05-31	Edit
700618 200645 00200	WBT 5271	STEPHANIE LOH MEIWAN	Active	1999-05-31	Edit
700618 200645 00218	BES 2984		Active	1999-05-31	Edit
700618 200645 00226	BEW 4546	MOHAMAD YUSOFF MUSA	Active	1999-05-31	Edit
700618 200645 00234	ADE 6622	TEH TIANG WENG	Active	1999-05-31	Edit
700618 200645 00242	BEW 4546	MOHAMAD YUSOFF MUSA	Active	1999-05-31	Edit
700618 200645 00259	BDX 8716	SINNAR A/L SINNAYA	Active	1999-05-31	Edit
700618 200645 00267	WGF 822	SAMSUL ADZMAN BIN BAHROM	Active	1999-05-31	Edit
700618 200645 00275	BES 2984		Active	1999-05-31	Edit
700618 200645 00283	BDX 8716	SINNAR A/L SINNAYA	Active	1999-05-31	Edit