Customer Detail

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

Back to List

Customer Workspace

ADJ ASSOCIATES SDN BHD

Compact enterprise workspace for customer_master, applicant_contact, and card_master.

Company Reg No 375373-T

Contacts 3

Managed Cards 63

Record Status 1

ADJ ASSOCIATES 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 261361 00010	WKC 7610	DANNY WONG	Active	2015-10-31	Edit
700618 261361 00028	WGT 3208	GAN BOON HAK	Active	2015-10-31	Edit
700618 261361 00036	BGG 323	YOON LAI CHONG	Active	2015-10-31	Edit
700618 261361 00044	WEJ 8699	GAN BOON PIN	Active	2015-10-31	Edit
700618 261361 00051	WFF 3517	BILL WONG	Active	2015-10-31	Edit
700618 261361 00069	WJL 6381	JEFFERY CHEAH	Active	2015-10-31	Edit
700618 261361 00077	WDT 1902	S K LAU	Active	2015-10-31	Edit
700618 261361 00085	WKR 2646	YOON LAI YONG	Active	2015-10-31	Edit
700618 261361 00093	WKQ 2082	JEFFERY CHEAH	Active	2015-10-31	Edit
700618 261361 00101	WDT 1902	LAU SIEW KAI	Active	2015-10-31	Edit
700618 261361 00119	WKR 2646	YOON LAI CHONG	Active	2015-10-31	Edit
700618 261361 00127	WHA 4860	MOHD AZLI B MOHD YUSOFF	Active	2015-10-31	Edit
700618 261361 00135	WJJ 7265	PROTON WIRA	Active	2015-10-31	Edit
700618 261361 00143	WDT 1902	LAU SIEW KAI	Active	2015-10-31	Edit
700618 261361 00150	WMP 3145	GAN BOON PIN	Active	2015-10-31	Edit
700618 261361 00168	WMK 9236	BILL WONG	Active	2015-10-31	Edit
700618 261361 00176	WNE 4388	JEFFERY CHEAH	Active	2015-10-31	Edit
700618 261361 00184	WKQ 2082	YOON LAI CHONG	Active	2015-10-31	Edit
700618 261361 00192	WKK 7265	HUSSIN B ABU HASSAN	Active	2015-10-31	Edit
700618 261361 00200	WNC 2552	MOHAMAD SUKRI B HAJI YUSOF	Inactive	2015-10-31	Edit
789713 3000734 0013	WKC 7610	DANNY WONG	Active	2015-10-31	Edit
789713 3000734 0021	WMP 3145	GAN BOON PIN	Active	2015-10-31	Edit
789713 3000734 0039	WMK 9236	BILL WONG	Active	2015-10-31	Edit
789713 3000734 0047	WNE 4388	JEFFERY CHEAH	Active	2015-10-31	Edit
789713 3000734 0054	WKQ 2082	YOON LAI CHONG	Active	2015-10-31	Edit
789713 3000734 0062	WKK 7265	HUSSIN B ABU HASSAN	Active	2015-10-31	Edit
789713 3000734 0070	WDT 1902	LAU SIEW KAI	Active	2015-10-31	Edit
789713 3000734 0088	WJJ 7265	PROTON WIRA	Active	2015-10-31	Edit
789713 3000734 0096	WNC 2552	MOHAMAD SUKRI B HAJI YUSOF	Active	2015-10-31	Edit
789713 3000734 0104	WKR 2646		Inactive	2015-10-31	Edit
789713 3000734 0112	WKQ 2082	MOHD AZLI BIN MOHD YUSOFF	Inactive	2015-10-31	Edit
789713 3000734 0120	WNE 4388	JEFFERY CHEAH	Active	2015-10-31	Edit
789713 3000734 0138	WKQ 2082	YOON LAI CHONG	Active	2015-10-31	Edit
789713 3000734 0146	WKQ 2082	MOHD AZLI BIN MOHD YUSOFF	Active	2015-10-31	Edit
789713 3000734 0153	WMK 9236	BILL WONG	Active	2015-10-31	Edit
789713 3000734 0161	WKR 2646		Active	2015-10-31	Edit
789713 3000734 0179	WMP 3145	GAN BOON PIN	Active	2015-10-31	Edit
789713 3000734 0187	WHX 8603	TAN CHIK YOON	Inactive	2015-10-31	Edit
789713 3000734 0195	WRN 5309	MOHD FADZIL BIN MD YUSOF	Inactive	2015-10-31	Edit
789713 3000734 0203	KV 5995	SAIFUL FADHLY BIN ABDUL LABEB	Inactive	2015-10-31	Edit
789713 3000734 0211	WVA 2529	ROSLEE BIN ISHAK	Inactive	2015-10-31	Edit
789713 3000734 0229	WVJ 2306	WONG WING KIT	Inactive	2015-10-31	Edit
789713 3000734 0237	WTM 2877	LUA BEAH KEAT	Inactive	2015-10-31	Edit
789713 3000734 0245	WLF 1454	YONG CHEE KEAT	Inactive	2015-10-31	Edit
789713 3000734 0252	WNE 4388	JEFFERY CHEAH	Active	2015-10-31	Edit
789713 3000734 0260	WWX 7161	HUSSIN B ABU HASSAN	Active	2015-10-31	Edit
789713 3000734 0278	WWE 6819	GAN BOON PIN	Active	2015-10-31	Edit
789713 3000734 0286	WVT 7288	YOON LAI CHONG	Active	2015-10-31	Edit
789713 3000734 0294	WUF 2061	JEFFERY CHEAH	Active	2015-10-31	Edit
789713 3000734 0302	AFY 5072	KAMARIZUAN BIN HUSIAN	Inactive	2015-10-31	Edit
789713 3000734 0310	AJB 780	RYAN BIN MYGAL	Inactive	2015-10-31	Edit
789713 3000734 0328	WXT 3481	YONG CHEE KEAT	Active	2015-10-31	Edit
789713 3000734 0336	AJB 780	RYAN BIN MYGAL	Active	2015-10-31	Edit
789713 3000734 0344	WWE 6819	GAN BOON PIN	Active	2015-10-31	Edit
789713 3000734 0351	WVT 7288	YOON LAI CHONG	Active	2015-10-31	Edit
789713 3000734 0369	WUF 2061	JEFFERY CHEAH	Active	2015-10-31	Edit
789713 3000734 0377	WXS 8798	BILL WONG	Active	2015-10-31	Edit
789713 3000734 0385	WUF 2061	JEFFERY CHEAH	Active	2015-10-31	Edit
789713 3000734 0393	WVH 7355	CHONG CHEE KEONG	Inactive	2015-10-31	Edit
789713 3000734 0401	WNE 7034	KHUZAIDI ABDUL KHALIP	Inactive	2015-10-31	Edit
789713 3000734 0419	WXT 3481	HUSSIN B ABU HASSAN	Active	2015-10-31	Edit
789713 3000734 0427	AGD 9394	SULAIMAN BIN BADRY	Inactive	2015-10-31	Edit
789713 3000734 0435	WA 4191 Q	AZLI BIN MOHAMMAD BAJURI	Inactive	2015-10-31	Edit