Customer Detail

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

Back to List

Customer Workspace

ACME COMMERCE SDN BHD

Compact enterprise workspace for customer_master, applicant_contact, and card_master.

Company Reg No 184927W

Contacts 3

Managed Cards 71

Record Status 1

ACME COMMERCE 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 202433 00019	WEF 9388	LIM SWEE LIT	Active	2015-05-31	Edit
700618 202433 00027	BDF 2073	WONG FOOK LOONG	Active	2015-05-31	Edit
700618 202433 00035	BEY 5747	WONG FOOK SEONG	Active	2015-05-31	Edit
700618 202433 00043	WEF 9388	WONG LU PENG	Active	2015-05-31	Edit
700618 202433 00050	WDU 8405	TAN SU CHING	Active	2015-05-31	Edit
700618 202433 00068	BDF 2073		Active	2015-05-31	Edit
700618 202433 00076	WDU 8405		Active	2015-05-31	Edit
700618 202433 00084	WCJ 3766	LAW CHEE KONG	Active	2015-05-31	Edit
700618 202433 00092	NAL 7713	NGU CHOON MUN	Active	2015-05-31	Edit
700618 202433 00100	BEF 7522	GOH NAI BOON	Active	2015-05-31	Edit
700618 202433 00118	WER 6370	ROHAIZAT HASBULLAH	Active	2015-05-31	Edit
700618 202433 00126	WFR 1386	WONG FOOK LOONG	Active	2015-05-31	Edit
700618 202433 00134	WEF 9388	LIM SWEE LIT	Active	2015-05-31	Edit
700618 202433 00142	CAD 8700	JAIPALA SIMON	Active	2015-05-31	Edit
700618 202433 00159	WEN 4341	NG SOU CHING	Active	2015-05-31	Edit
700618 202433 00167	WEQ 4931	CHIA JIA LOONG	Active	2015-05-31	Edit
700618 202433 00175	WET 8019		Active	2015-05-31	Edit
700618 202433 00183	JBF 3267	LAM KOK MIN	Active	2015-05-31	Edit
700618 202433 00191	WFH 9956	CHANG SIEW HOONG	Active	2015-05-31	Edit
700618 202433 00209	WFS 6733	DEREK LIM WAI KET	Active	2015-05-31	Edit
700618 202433 00217	WEN 4341	NG SOU CHING	Active	2015-05-31	Edit
700618 202433 00225	WEM 5070	SARAWANAN	Active	2015-05-31	Edit
700618 202433 00233	WEN 4341	GOH NAI BOON	Active	2015-05-31	Edit
700618 202433 00241	WAU 9059	YAU CHEE KHAN	Active	2015-05-31	Edit
700618 202433 00258	WAY 1461	LEN ROOI YEW	Active	2015-05-31	Edit
700618 202433 00266	WHA 9982	LIM SWEE LIT	Active	2015-05-31	Edit
700618 202433 00274	WHU 8335	YAU CHEE KHAN	Active	2015-05-31	Edit
700618 202433 00282	WHV 6028	WONG FOOK SEONG	Active	2015-05-31	Edit
700618 202433 00290	WHV 6028	WONG FOOK SEONG	Active	2015-05-31	Edit
700618 202433 00308	WJU 9982	WONG LU PENG	Active	2015-05-31	Edit
700618 202433 00316	WJY 9892	LIM SWEE LIT	Active	2015-05-31	Edit
700618 202433 00324	WJY 9892	WONG LU PENG	Active	2015-05-31	Edit
700618 202433 00332	WFS 6733	DEREK LIM WUI KET	Active	2015-05-31	Edit
700618 202433 00340	WHU 8335	LIM SWEE LIT	Active	2015-05-31	Edit
700618 202433 00357	WKU 1386	WONG FOOK LOONG	Active	2015-05-31	Edit
700618 202433 00365	WHV 6028	ALFRED LIM	Active	2015-05-31	Edit
700618 202433 00373	WLB 6028	LIM SWEE LIT	Active	2015-05-31	Edit
700618 202433 00381	WLB 6028	WONG FOOK SEONG	Active	2015-05-31	Edit
700618 202433 00399	WLU 9829	ALFRED LIM	Active	2015-05-31	Edit
700618 202433 00407	WLU 832	DEREK LIM WUI KET	Active	2015-05-31	Edit
700618 202433 00415	WLU 832	DEREK LIM WUI KET	Active	2015-05-31	Edit
789713 3001937 0016	WJY 9892	LIM SWEE LIT	Active	2015-05-31	Edit
789713 3001937 0024	WJY 9892	WONG LU PENG	Active	2015-05-31	Edit
789713 3001937 0032	WLB 6028	WONG FOOK SEONG	Active	2015-05-31	Edit
789713 3001937 0040	WLU 9829	ALFRED LIM	Active	2015-05-31	Edit
789713 3001937 0057	WKU 1386	WONG FOOK LOONG	Active	2015-05-31	Edit
789713 3001937 0065	WHU 2265	CHEE PENG KEE	Inactive	2015-05-31	Edit
789713 3001937 0073	WHU 2265	GOH LING WEI	Inactive	2015-05-31	Edit
789713 3001937 0081	WHU 2265	TEOH SEE KIAT	Inactive	2015-05-31	Edit
789713 3001937 0099	JGV 3286	IVAN OON	Inactive	2015-05-31	Edit
789713 3001937 0107	WQF 9829	ALFRED LIM	Inactive	2015-05-31	Edit
789713 3001937 0115	WJU 9892	LAI SIEW CHING	Inactive	2015-05-31	Edit
789713 3001937 0123	BJV 9829	LIM CHU YOK	Inactive	2015-05-31	Edit
789713 3001937 0131	BJV 9829	LIM SWEE FATT	Inactive	2015-05-31	Edit
789713 3001937 0149	WJY 9892	WONG LU PENG	Active	2015-05-31	Edit
789713 3001937 0156	WLB 6028	WONG FOOK SEONG	Active	2015-05-31	Edit
789713 3001937 0164	WKU 1386	WONG FOOK LOONG	Active	2015-05-31	Edit
789713 3001937 0172	WHU 2265	TEOH SEE KIAT	Active	2015-05-31	Edit
789713 3001937 0180	JGV 3286	IVAN OON	Active	2015-05-31	Edit
789713 3001937 0198	WQF 9829	ALFRED LIM	Active	2015-05-31	Edit
789713 3001937 0206	BJV 9829	LIM SWEE FATT	Active	2015-05-31	Edit
789713 3001937 0214	JGV 3286	S L LIM	Active	2015-05-31	Edit
789713 3001937 0222	BJV 9829	LIM SWEE FATT	Active	2015-05-31	Edit
789713 3001937 0230	WTL 7068	TEOH SEE KIAT	Active	2015-05-31	Edit
789713 3001937 0248	WTS 1386	WONG FOOK LOONG	Active	2015-05-31	Edit
789713 3001937 0255	WRV 9899	WONG FOOK SEONG	Active	2015-05-31	Edit
789713 3001937 0263	WWK 9829	ALFRED LIM	Active	2015-05-31	Edit
789713 3001937 0271	WWY 9829	WONG LU PENG	Active	2015-05-31	Edit
789713 3001937 0289	BJV 9829	LIM SWEE FATT	Active	2015-05-31	Edit
789713 3001937 0297	BJV 9829	LIM SWEE FATT	Active	2015-05-31	Edit
789713 3001937 0305	WA 7189 L	WONG FOOK SEONG	Active	2015-05-31	Edit