Customer Detail

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

Back to List

Customer Workspace

AGENCY PRODUCTS SYNERGY (M) SDN BHD

Compact enterprise workspace for customer_master, applicant_contact, and card_master.

Company Reg No 275067U

Contacts 3

Managed Cards 41

Record Status 1

AGENCY PRODUCTS SYNERGY (M) 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 202241 00016	ABC 7531	HAMIZAT	Active	2015-09-30	Edit
700618 202241 00024	WBD 2980	MALAYSIA	Active	2015-09-30	Edit
700618 202241 00032	WDY 1138	LIM WAN THONG	Active	2015-09-30	Edit
700618 202241 00040	WBM 1935		Active	2015-09-30	Edit
700618 202241 00057	WBQ 7660		Active	2015-09-30	Edit
700618 202241 00065	WAV 6527		Active	2015-09-30	Edit
700618 202241 00073	WCC 2904		Active	2015-09-30	Edit
700618 202241 00081	WFW 128		Active	2015-09-30	Edit
700618 202241 00099	WGA 3830		Active	2015-09-30	Edit
700618 202241 00107	WBQ 7660	MALAYSIA	Active	2015-09-30	Edit
700618 202241 00115	WFW 128		Active	2015-09-30	Edit
700618 202241 00123	WFW 128		Active	2015-09-30	Edit
700618 202241 00131	WDY 1138	MALAYSIA	Active	2015-09-30	Edit
700618 202241 00149	WFW 128		Active	2015-09-30	Edit
700618 202241 00156	WHR 7088		Active	2015-09-30	Edit
700618 202241 00164	WKC 728		Active	2015-09-30	Edit
700618 202241 00172	WCK 728		Active	2015-09-30	Edit
700618 202241 00180	WKC 728		Active	2015-09-30	Edit
700618 202241 00198	WGA 3830		Active	2015-09-30	Edit
700618 202241 00206	WCC 2904		Active	2015-09-30	Edit
700618 202241 00214	WLT 1810		Active	2015-09-30	Edit
700618 202241 00222	WLT 1810		Active	2015-09-30	Edit
700618 202241 00230	WGA 3830		Active	2015-09-30	Edit
700618 202241 00248	WNW 9810	MALAYSIA	Active	2015-09-30	Edit
789713 3000444 0014	WDY 1138		Active	2015-09-30	Edit
789713 3000444 0022	WHR 7088		Active	2015-09-30	Edit
789713 3000444 0030	WKC 728		Active	2015-09-30	Edit
789713 3000444 0048	WCC 2904		Active	2015-09-30	Edit
789713 3000444 0055	WLT 1810		Active	2015-09-30	Edit
789713 3000444 0063	WGA 3830		Active	2015-09-30	Edit
789713 3000444 0071	WNW 9810	MALAYSIA	Active	2015-09-30	Edit
789713 3000444 0089	WNW 9810	MALAYSIA	Active	2015-09-30	Edit
789713 3000444 0097	CBH 8954	KAMARULNIZAM BIN SALEHHUDIN	Inactive	2015-09-30	Edit
789713 3000444 0105	WHR 7088		Inactive	2015-09-30	Edit
789713 3000444 0113	WRW 8190	ALL DRIVERS	Inactive	2015-09-30	Edit
789713 3000444 0121	WNW 9810		Active	2015-09-30	Edit
789713 3000444 0139	WHR 7088		Active	2015-09-30	Edit
789713 3000444 0147	WGA 3830		Active	2015-09-30	Edit
789713 3000444 0154	WWQ 128		Inactive	2015-09-30	Edit
789713 3000444 0162	WRW 8190	ALL DRIVERS	Active	2015-09-30	Edit
789713 3000444 0170	WGA 3830		Active	2015-09-30	Edit