Customer Detail

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

Back to List

Customer Workspace

ACTION BOLTS AND NUTS SDN BHD

Compact enterprise workspace for customer_master, applicant_contact, and card_master.

Company Reg No 608134-H

Contacts 3

Managed Cards 32

Record Status 1

ACTION BOLTS AND NUTS 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 276145 00010	BET 8255	LESLIE SOH KOK HWA	Active	2015-10-31	Edit
700618 276145 00028	BHF 2328	HARVEY YAP LAI HE	Active	2015-10-31	Edit
700618 276145 00036	WFE 596	HAZE LIM SEA YIN	Active	2015-10-31	Edit
700618 276145 00044	JCH 8990	ONG BENG TEE	Active	2015-10-31	Edit
700618 276145 00051	BET 8255	JEFF FOONG WAI HOONG	Active	2015-10-31	Edit
700618 276145 00069	WHV 5861	LESLIE SOH KOK HWA	Active	2015-10-31	Edit
700618 276145 00077	WHV 5861	LESLIE SOH KOK HWA	Active	2015-10-31	Edit
700618 276145 00085	BHX 5328	HARVEY YAP LAI HE	Active	2015-10-31	Edit
700618 276145 00093	BGG 3414	ELVIN ONG CHEW KEONG	Active	2015-10-31	Edit
700618 276145 00101	BHP 5827	BRYAN TAN YAU BENG	Active	2015-10-31	Edit
789713 3000865 0014	BET 8255	JEFF FOONG WAI HOONG	Active	2015-10-31	Edit
789713 3000865 0022	WHV 5861	LESLIE SOH KOK HWA	Active	2015-10-31	Edit
789713 3000865 0030	BHX 5328	HARVEY YAP LAI HE	Active	2015-10-31	Edit
789713 3000865 0048	BGG 3414	ELVIN ONG CHEW KEONG	Active	2015-10-31	Edit
789713 3000865 0055	BHP 5827	BRYAN TAN YAU BENG	Active	2015-10-31	Edit
789713 3000865 0063	WFE 596	HAZE LIM SEA YIN	Active	2015-10-31	Edit
789713 3000865 0071	BJT 3328	SIMON TEH BOON HUAT	Inactive	2015-10-31	Edit
789713 3000865 0089	WKG 4092	FRANKIE SOH KOK CHONG	Inactive	2015-10-31	Edit
789713 3000865 0097	BKF 9328	LESLIE SOH KOK HWA	Inactive	2015-10-31	Edit
789713 3000865 0105	BKG 3328	HAZE LIM SEA YIN	Inactive	2015-10-31	Edit
789713 3000865 0113	WQD 8439	MACKSON TAN SOON HIAN	Inactive	2015-10-31	Edit
789713 3000865 0121	BJF 6317	TAN WEI KHONG	Inactive	2015-10-31	Edit
789713 3000865 0139	BKF 9328	LESLIE SOH KOK HWA	Active	2015-10-31	Edit
789713 3000865 0147	WKG 4092	FRANKIE SOH KOK CHONG	Active	2015-10-31	Edit
789713 3000865 0154	BKG 3328	HAZE LIM SEA YIN	Active	2015-10-31	Edit
789713 3000865 0162	BJF 6317	TAN WEI KHONG	Active	2015-10-31	Edit
789713 3000865 0170	WQD 8439	MACKSON TAN SOON HIAN	Active	2015-10-31	Edit
789713 3000865 0188	BKR 1328	HARVEY YAP LAI HE	Active	2015-10-31	Edit
789713 3000865 0196	BKG 9328	LIEW CHEE KEONG	Inactive	2015-10-31	Edit
789713 3000865 0204	BKG 3328	JAMIE CHEW MEI LENG	Active	2015-10-31	Edit
789713 3000865 0212	BKG 9328	MOHD MISWAN BIN SANIP	Active	2015-10-31	Edit
789713 3000865 0220	BKG 3328	JOHNNY CHOO SIEW CHOONG	Active	2015-10-31	Edit