Customer Detail

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

Back to List

Customer Workspace

AGENDA ISTIMEWA SDN BHD

Compact enterprise workspace for customer_master, applicant_contact, and card_master.

Company Reg No 281606H

Contacts 3

Managed Cards 59

Record Status 1

AGENDA ISTIMEWA 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 205291 00018	WEQ 6288	THOMAS K.K.KIU	Active	2015-11-30	Edit
700618 205291 00026	WEX 2839	OOI LING HOCK	Active	2015-11-30	Edit
700618 205291 00034	WEP 8990	LEE CHOW HUANN	Active	2015-11-30	Edit
700618 205291 00042	WCG 2685	KOH LEH KEY	Active	2015-11-30	Edit
700618 205291 00059	WEE 7970	ZAWANI AHMAD	Active	2015-11-30	Edit
700618 205291 00067	BEE 717	ADRIAN KHEUNG PENG YIN	Active	2015-11-30	Edit
700618 205291 00075	WFB 6172	RICHARD LEONG	Active	2015-11-30	Edit
700618 205291 00083	WFH 8406	LEE CHOW HUANN	Active	2015-11-30	Edit
700618 205291 00091	WEQ 6288	LIM CHANG TZE	Active	2015-11-30	Edit
700618 205291 00109	WEX 2839	JOANNE WONG	Active	2015-11-30	Edit
700618 205291 00117	WDT 8419	YUSNIZA BT AYUB	Active	2015-11-30	Edit
700618 205291 00125	WFD 8045	TIANG KEW LEONG	Active	2015-11-30	Edit
700618 205291 00133	WCU 7498	ZAWANI AHMAD	Active	2015-11-30	Edit
700618 205291 00141	BFF 569	CHENG SIEW KEE	Active	2015-11-30	Edit
700618 205291 00158	WFH 8406	LEE CHOW HUANN	Active	2015-11-30	Edit
700618 205291 00166	WFU 7978	RAHPAL A/L JOSEPH	Active	2015-11-30	Edit
700618 205291 00174	BFW 7207	TAN LAY KUEN	Active	2015-11-30	Edit
700618 205291 00182	BFW 7207	TAN LAY KUEN	Active	2015-11-30	Edit
700618 205291 00190	BFW 7207	JOANNE WONG	Active	2015-11-30	Edit
700618 205291 00208	WEX 2839		Active	2015-11-30	Edit
700618 205291 00216	WFB 6172	K H LEE	Active	2015-11-30	Edit
700618 205291 00224	WJK 9133		Inactive	2015-11-30	Edit
700618 205291 00232	WHS 6249		Inactive	2015-11-30	Edit
789713 3001209 0017	BFF 569	CHENG SIEW KEE	Active	2015-11-30	Edit
789713 3001209 0025	BFW 7207	JOANNE WONG	Active	2015-11-30	Edit
789713 3001209 0033	WFB 6172	K H LEE	Active	2015-11-30	Edit
789713 3001209 0041	WJK 9133	JOANNE WONG	Active	2015-11-30	Edit
789713 3001209 0058	WHS 6249		Active	2015-11-30	Edit
789713 3001209 0066	BGL 1893		Inactive	2015-11-30	Edit
789713 3001209 0074	BFF 569	CHENG SIEW KEE	Inactive	2015-11-30	Edit
789713 3001209 0082	WFB 6172	K H LEE	Inactive	2015-11-30	Edit
789713 3001209 0090	WJK 9133		Inactive	2015-11-30	Edit
789713 3001209 0108	BGL 1893		Inactive	2015-11-30	Edit
789713 3001209 0116	WFD 8045	LAI KIM LING	Inactive	2015-11-30	Edit
789713 3001209 0124	BKD 6857	LAI KIM LING	Inactive	2015-11-30	Edit
789713 3001209 0132	BGL 1893	LAU YONG WA	Inactive	2015-11-30	Edit
789713 3001209 0140	WML 512	LIM MENG WEI	Inactive	2015-11-30	Edit
789713 3001209 0157	WJK 9133		Inactive	2015-11-30	Edit
789713 3001209 0165	BHS 3133	JOANNE WONG	Active	2015-11-30	Edit
789713 3001209 0173	BDH 7777	LIM CHANG TZE	Inactive	2015-11-30	Edit
789713 3001209 0181	BHS 3133	JOANNE WONG	Active	2015-11-30	Edit
789713 3001209 0199	WKH 3939	TIANG KEW LEONG	Inactive	2015-11-30	Edit
789713 3001209 0207	BJA 3733	DAVID HON KIM LONG	Inactive	2015-11-30	Edit
789713 3001209 0215	WOU 5484	HARRY LIM HEE GUAN	Inactive	2015-11-30	Edit
789713 3001209 0223	MBW 3301	PATRICK LIM PENG CHUAN	Inactive	2015-11-30	Edit
789713 3001209 0231	BKQ 9112	WEE VOON LEE	Inactive	2015-11-30	Edit
789713 3001209 0249	BKC 8818	RAYMOND NG JIN TECK	Inactive	2015-11-30	Edit
789713 3001209 0256	BFQ 2881	PAULINE CHIN	Inactive	2015-11-30	Edit
789713 3001209 0264	BDH 7777	LIM CHANG TZE	Active	2015-11-30	Edit
789713 3001209 0272	BHS 3133	JOANNE WONG	Active	2015-11-30	Edit
789713 3001209 0280	WOU 5484	HARRY LIM HEE GUAN	Active	2015-11-30	Edit
789713 3001209 0298	MBW 3301	PATRICK LIM PENG CHUAN	Active	2015-11-30	Edit
789713 3001209 0306	BKQ 9112	WEE VOON LEE	Active	2015-11-30	Edit
789713 3001209 0314	BKC 8818	RAYMOND NG JIN TECK	Active	2015-11-30	Edit
789713 3001209 0322	BFQ 2881	PAULINE CHIN	Active	2015-11-30	Edit
789713 3001209 0330	BDH 7777	LIM CHANG TZE	Active	2015-11-30	Edit
789713 3001209 0348	BDH 7777	LIM CHANG TZE	Active	2015-11-30	Edit
789713 3001209 0355	WKH 3939	TIANG KEW LEONG	Active	2015-11-30	Edit
789713 3001209 0363	WSN 3317	RAYMOND NG JIN TECK	Active	2015-11-30	Edit